Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [97] Website
|
From: <m_h...@us...> - 2006-07-11 19:33:19
|
Revision: 97 Author: m_hildebrand Date: 2006-07-11 12:32:56 -0700 (Tue, 11 Jul 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=97&view=rev Log Message: ----------- Assigned global object g_user as the currently logged in user Modified Paths: -------------- Website/App_Code/TCDB_Assignments.cs Website/App_Code/TCDB_Common.cs Website/App_Code/TCDB_Products.cs Website/App_Code/TCDB_Users.cs Website/App_Code/dadDataSet.xsd Website/Includes/ActionItems.ascx Website/Includes/AdministrationTree.ascx Website/Includes/Assignments.ascx Website/Includes/AssignmentsTree.ascx Website/Includes/Authenticate.ascx Website/Includes/Builds.ascx Website/Includes/Execution.ascx Website/Includes/FeatureTree.ascx Website/Includes/Features.ascx Website/Includes/Footer.ascx Website/Includes/Header.ascx Website/Includes/Header_CurrentInfo.ascx Website/Includes/Header_Menu.ascx Website/Includes/Header_User.ascx Website/Includes/Notes.ascx Website/Includes/Objectives.ascx Website/Includes/Platforms.ascx Website/Includes/Products.ascx Website/Includes/Reports.ascx Website/Includes/SqlDatabase.ascx Website/Includes/Tags.ascx Website/Includes/TestCases.ascx Website/Includes/Users.ascx Website/Includes/Versions.ascx Website/Includes/WorkOrders.ascx Website/Plugins/VAS_Execution.ascx Website/TCDB.master Website/WorkOrder.aspx Added Paths: ----------- Website/App_Code/TCDB_Logs.cs Website/Global.asax Modified: Website/App_Code/TCDB_Assignments.cs =================================================================== --- Website/App_Code/TCDB_Assignments.cs 2006-07-11 17:05:34 UTC (rev 96) +++ Website/App_Code/TCDB_Assignments.cs 2006-07-11 19:32:56 UTC (rev 97) @@ -56,6 +56,7 @@ assignment.WOERROR = TCDB_Help.TCDB_DB_IntParse(dr["WOError"], 0); } + assignment.NAME = TCDB_Help.TCDB_DB_StringParse(dr["aName"], ""); assignment.CREATOR = TCDB_Help.TCDB_DB_StringParse(dr["creator"], ""); assignment.ASSIGNED = TCDB_Help.TCDB_DB_StringParse(dr["assigned"], ""); assignment.DATEASSIGNED = TCDB_Help.TCDB_DB_DateTimeParse(dr["dateAssigned"], TCDB_Constant.ASSIGNMENT_DEFAULTDATEASSIGNED); @@ -86,15 +87,35 @@ DataTableReader dr = ds.db_users.CreateDataReader(); if (dr.HasRows && dr.Read()) { - ai.ID = TCDB_Help.TCDB_DB_IntParse(dr["actionItemID"], TCDB_Constant.ACTIONITEM_DEFAULTID); - ai.NAME = TCDB_Help.TCDB_DB_StringParse(dr["name"], TCDB_Constant.ACTIONITEM_DEFAULTNAME); - ai.DESCRIPTION = TCDB_Help.TCDB_DB_StringParse(dr["description"], TCDB_Constant.ACTIONITEM_DEFAULTDESCRIPTION); - ai.CREATORID = TCDB_Help.TCDB_DB_IntParse(dr["creatorID"], TCDB_Constant.ACTIONITEM_DEFAULTCREATORID); - ai.PERCENTCOMPLETE = TCDB_Help.TCDB_DB_IntParse(dr["percentComplete"], TCDB_Constant.ACTIONITEM_DEFAULTPERCENTCOMPLETE); + ai.ID = TCDB_Help.TCDB_DB_IntParse(dr["actionItemID"], 0); + ai.NAME = TCDB_Help.TCDB_DB_StringParse(dr["name"], ""); + ai.DESCRIPTION = TCDB_Help.TCDB_DB_StringParse(dr["description"], ""); + ai.CREATOR = new TCDB_User(TCDB_Help.TCDB_DB_IntParse(dr["creatorID"], TCDB_Constant.USER_ANONYMOUSUSERID)); + ai.ASSIGNED = new TCDB_User(TCDB_Help.TCDB_DB_IntParse(dr["assignedID"], TCDB_Constant.USER_ANONYMOUSUSERID)); + ai.PERCENTCOMPLETE = TCDB_Help.TCDB_DB_IntParse(dr["percentComplete"], 0); } return ai; } + + public static bool TCDB_SaveActionItem(TCDB_ActionItem ai) + { + dadDataSet ds = new dadDataSet(); + dadDataSetTableAdapters.db_actionItemsTableAdapter ta = new dadDataSetTableAdapters.db_actionItemsTableAdapter(); + try + { + ta.Insert(ai.NAME, ai.DESCRIPTION, ai.CREATOR.ID, ai.ASSIGNED.ID, DateTime.Now, null, TCDB_Constant.ASSIGNMENT_PRIORITY_HIGH); + } + catch + { + return false; + } + + if (ds.db_users.HasErrors) + return false; + + return true; + } } public class TCDB_WorkOrderDB : Page @@ -288,7 +309,8 @@ private int p_id; private string p_name; private string p_description; - private int p_creatorID; + private TCDB_User p_creator; + private TCDB_User p_assigned; private int p_percentComplete; public TCDB_ActionItem() @@ -296,16 +318,18 @@ p_id = 0; p_name = ""; p_description = ""; - p_creatorID = 0; + p_creator = new TCDB_User(); + p_assigned = new TCDB_User(); p_percentComplete = 0; } - public TCDB_ActionItem(int id, string name, string description, int creatorID, int percentComplete) + public TCDB_ActionItem(int id, string name, string description, TCDB_User creator, TCDB_User assigned, int percentComplete) { p_id = id; p_name = name; p_description = description; - p_creatorID = creatorID; + p_creator = creator; + p_assigned = assigned; p_percentComplete = percentComplete; } @@ -327,12 +351,18 @@ set { p_description = value; } } - public int CREATORID + public TCDB_User CREATOR { - get { return p_creatorID; } - set { p_creatorID = value; } + get { return p_creator; } + set { p_creator = value; } } + public TCDB_User ASSIGNED + { + get { return p_assigned; } + set { p_assigned = value; } + } + public int PERCENTCOMPLETE { get { return p_percentComplete; } Modified: Website/App_Code/TCDB_Common.cs =================================================================== --- Website/App_Code/TCDB_Common.cs 2006-07-11 17:05:34 UTC (rev 96) +++ Website/App_Code/TCDB_Common.cs 2006-07-11 19:32:56 UTC (rev 97) @@ -31,6 +31,9 @@ public static string USER_ANONYMOUSCELLPHONE = ""; public static bool USER_ANONYMOUSAUTOMATION = false; + public static string USER_AI_NAME = "Assign permissions: "; + public static string USER_AI_DESCRIPTION = "Please assign appropriate permissions for new user: "; + public static int ACTIONITEM_DEFAULTID = 0; public static string ACTIONITEM_DEFAULTNAME = ""; public static string ACTIONITEM_DEFAULTDESCRIPTION = ""; Added: Website/App_Code/TCDB_Logs.cs =================================================================== --- Website/App_Code/TCDB_Logs.cs (rev 0) +++ Website/App_Code/TCDB_Logs.cs 2006-07-11 19:32:56 UTC (rev 97) @@ -0,0 +1,39 @@ +using System; +using System.Data; +using System.Configuration; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; + +namespace TCDB_Logs +{ + public class TCDB_Log + { + public TCDB_Log() + { + } + + public void Info() + { + } + + public void Debug() + { + } + + public void Error() + { + } + + public void Fatal() + { + } + + public void Warn() + { + } + } +} \ No newline at end of file Modified: Website/App_Code/TCDB_Products.cs =================================================================== --- Website/App_Code/TCDB_Products.cs 2006-07-11 17:05:34 UTC (rev 96) +++ Website/App_Code/TCDB_Products.cs 2006-07-11 19:32:56 UTC (rev 97) @@ -27,7 +27,7 @@ TCDB_Product product = new TCDB_Product(); - DataTableReader dr = ds.CreateDataReader(); + DataTableReader dr = ds.db_products.CreateDataReader(); if (dr.HasRows && dr.Read()) { int id = TCDB_Help.TCDB_DB_IntParse(dr["productID"], TCDB_Constant.PRODUCT_DEFAULTID); Modified: Website/App_Code/TCDB_Users.cs =================================================================== --- Website/App_Code/TCDB_Users.cs 2006-07-11 17:05:34 UTC (rev 96) +++ Website/App_Code/TCDB_Users.cs 2006-07-11 19:32:56 UTC (rev 97) @@ -10,6 +10,7 @@ using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; + using System.Security; using System.Collections; using System.Collections.Generic; @@ -17,6 +18,7 @@ using TCDB_Assignments; using TCDB_Common; using AD_Auth; +using System.Web.SessionState; @@ -71,6 +73,21 @@ return user; } + public static TCDB_User TCDB_GetUserInstance() + { + TCDB_User user; + try + { + user = (TCDB_User)(HttpContext.Current.Items["user"]); + } + catch + { + user = new TCDB_User(); + } + + return user; + } + public static TCDB_User TCDB_GetUserInfo(string strUserName) { // TODO: Check against the DB for user information @@ -186,58 +203,43 @@ /// </summary> public class TCDB_User { - private int userid; - private string username; - private string email; - private string officePhone; - private string homePhone; - private string cellPhone; - private string firstName; - private string lastName; - private bool automation; - private bool isAuthenticated; - private List<TCDB_Right> rights; - private List<TCDB_Config> config; - private List<TCDB_Assignment> assignments; + private int p_id; + private string p_username; + private string p_email; + private string p_officePhone; + private string p_homePhone; + private string p_cellPhone; + private string p_firstName; + private string p_lastName; + private bool p_automation; + private bool p_isAuthenticated; + private List<TCDB_Right> p_rights; + private List<TCDB_Config> p_config; + private List<TCDB_Assignment> p_assignments; /* TODO: Implement these as the time is right - private List<TCDB_Feature> features; - private List<TCDB_Assignment> assignmentsCreated; - private List<TCDB_Objective> objectives; - private List<TCDB_WorkOrderTemplate> savedWorkOrders; - private List<TCDB_TestCase> testCasesCreated; - private List<TCDB_TestCase> testCasesEdited; + private List<TCDB_Feature> p_features; + private List<TCDB_Assignment> p_assignmentsCreated; + private List<TCDB_Objective> p_objectives; + private List<TCDB_WorkOrderTemplate> p_savedWorkOrders; + private List<TCDB_TestCase> p_testCasesCreated; + private List<TCDB_TestCase> p_testCasesEdited; */ - public List<TCDB_Assignment> ASSIGNMENTS - { - // TODO: This list needs to be able to reflect filters! - get - { - List<TCDB_Assignment> assignments = new List<TCDB_Assignment>(); - if (assignments == null) - { - assignments = TCDB_AssignmentDB.TCDB_GetAssignmentList(TCDB_Constant.ASSIGNMENT_TYPE_BOTH, - TCDB_Constant.ASSIGNMENT_FINISHEDANDUNFINISHED, ID, null); - } - return assignments; - } - } - public TCDB_User() { - userid = TCDB_Constant.USER_ANONYMOUSUSERID; - username = TCDB_Constant.USER_ANONYMOUSUSERNAME; - email = ""; - officePhone = ""; - homePhone = ""; - cellPhone = ""; - firstName = TCDB_Constant.USER_ANONYMOUSFIRSTNAME; - lastName = TCDB_Constant.USER_ANONYMOUSLASTNAME; - automation = false; - isAuthenticated = false; - rights = null; - config = null; - assignments = null; + p_id = TCDB_Constant.USER_ANONYMOUSUSERID; + p_username = TCDB_Constant.USER_ANONYMOUSUSERNAME; + p_email = ""; + p_officePhone = ""; + p_homePhone = ""; + p_cellPhone = ""; + p_firstName = TCDB_Constant.USER_ANONYMOUSFIRSTNAME; + p_lastName = TCDB_Constant.USER_ANONYMOUSLASTNAME; + p_automation = false; + p_isAuthenticated = false; + p_rights = null; + p_config = null; + p_assignments = null; } public TCDB_User(string username) @@ -252,67 +254,67 @@ private void TCDB_BuildUser(TCDB_User user) { - userid = user.ID; - username = user.USERNAME; - email = user.EMAIL; - officePhone = user.OFFICEPHONE; - homePhone = user.HOMEPHONE; - cellPhone = user.CELLPHONE; - firstName = user.FIRSTNAME; - lastName = user.LASTNAME; - automation = user.AUTOMATION; - isAuthenticated = user.ISAUTHENTICATED; - rights = user.rights; - config = user.config; - assignments = null; + p_id = user.ID; + p_username = user.USERNAME; + p_email = user.EMAIL; + p_officePhone = user.OFFICEPHONE; + p_homePhone = user.HOMEPHONE; + p_cellPhone = user.CELLPHONE; + p_firstName = user.FIRSTNAME; + p_lastName = user.LASTNAME; + p_automation = user.AUTOMATION; + p_isAuthenticated = user.ISAUTHENTICATED; + p_rights = user.GetRights(false); + p_config = user.GetConfig(false); + p_assignments = user.GetAssignments(false); } public int ID { - get { return userid; } - set { userid = value; } + get { return p_id; } + set { p_id = value; } } public string USERNAME { - get { return username; } - set { username = value; } + get { return p_username; } + set { p_username = value; } } public string EMAIL { - get { return email; } - set { email = value; } + get { return p_email; } + set { p_email = value; } } public string OFFICEPHONE { - get { return officePhone; } - set { officePhone = value; } + get { return p_officePhone; } + set { p_officePhone = value; } } public string HOMEPHONE { - get { return homePhone; } - set { homePhone = value; } + get { return p_homePhone; } + set { p_homePhone = value; } } public string CELLPHONE { - get { return cellPhone; } - set { cellPhone = value; } + get { return p_cellPhone; } + set { p_cellPhone = value; } } public string FIRSTNAME { - get { return firstName; } - set { firstName = value; } + get { return p_firstName; } + set { p_firstName = value; } } public string LASTNAME { - get { return lastName; } - set { lastName = value; } + get { return p_lastName; } + set { p_lastName = value; } } public string FULLNAME @@ -322,14 +324,14 @@ public bool AUTOMATION { - get { return automation; } - set { automation = value; } + get { return p_automation; } + set { p_automation = value; } } public bool ISAUTHENTICATED { - get { return isAuthenticated; } - set { isAuthenticated = value; } + get { return p_isAuthenticated; } + set { p_isAuthenticated = value; } } public override string ToString() @@ -337,19 +339,31 @@ return FULLNAME; } - public List<TCDB_Right> GetRights() + public List<TCDB_Right> GetRights(bool reload) { // TODO: If rights == null // load the rights from the db - return rights; + return p_rights; } - public List<TCDB_Config> GetConfig() + public List<TCDB_Config> GetConfig(bool reload) { // TODO: If config == null // load the config from the db - return config; + return p_config; } + + public List<TCDB_Assignment> GetAssignments(bool reload) + { + // TODO: This list needs to be able to reflect filters! + p_assignments = new List<TCDB_Assignment>(); + if (p_assignments == null || reload) + { + p_assignments = TCDB_AssignmentDB.TCDB_GetAssignmentList(TCDB_Constant.ASSIGNMENT_TYPE_BOTH, + TCDB_Constant.ASSIGNMENT_FINISHEDANDUNFINISHED, ID, null); + } + return p_assignments; + } } public class TCDB_Right Modified: Website/App_Code/dadDataSet.xsd =================================================================== --- Website/App_Code/dadDataSet.xsd 2006-07-11 17:05:34 UTC (rev 96) +++ Website/App_Code/dadDataSet.xsd 2006-07-11 19:32:56 UTC (rev 97) @@ -39,7 +39,7 @@ </DbCommand> </InsertCommand> <SelectCommand> - <DbCommand CommandType="StoredProcedure" ModifiedByUser="True"> + <DbCommand CommandType="StoredProcedure" ModifiedByUser="False"> <CommandText>dbo.sel_users</CommandText> <Parameters> <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"> @@ -330,6 +330,7 @@ <Mapping SourceColumn="WOPass" DataSetColumn="WOPass" /> <Mapping SourceColumn="WOFail" DataSetColumn="WOFail" /> <Mapping SourceColumn="WOError" DataSetColumn="WOError" /> + <Mapping SourceColumn="aName" DataSetColumn="aName" /> </Mappings> <Sources> </Sources> @@ -346,146 +347,146 @@ <xs:element name="db_users" msprop:Generator_UserTableName="db_users" msprop:Generator_RowDeletedName="db_usersRowDeleted" msprop:Generator_RowChangedName="db_usersRowChanged" msprop:Generator_RowClassName="db_usersRow" msprop:Generator_RowChangingName="db_usersRowChanging" msprop:Generator_RowEvArgName="db_usersRowChangeEvent" msprop:Generator_RowEvHandlerName="db_usersRowChangeEventHandler" msprop:Generator_TableClassName="db_usersDataTable" msprop:Generator_TableVarName="tabledb_users" msprop:Generator_RowDeletingName="db_usersRowDeleting" msprop:Generator_TablePropName="db_users"> <xs:complexType> <xs:sequence> - <xs:element name="userID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="userID" msprop:Generator_ColumnVarNameInTable="columnuserID" msprop:Generator_ColumnPropNameInRow="userID" msprop:Generator_ColumnPropNameInTable="userIDColumn" type="xs:int" /> - <xs:element name="username" msprop:Generator_UserColumnName="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnPropNameInTable="usernameColumn"> + <xs:element name="userID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="userID" msprop:Generator_ColumnPropNameInRow="userID" msprop:Generator_ColumnVarNameInTable="columnuserID" msprop:Generator_ColumnPropNameInTable="userIDColumn" type="xs:int" /> + <xs:element name="username" msprop:Generator_UserColumnName="username" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInTable="usernameColumn"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn"> + <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInTable="emailColumn"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="officePhone" msprop:Generator_UserColumnName="officePhone" msprop:Generator_ColumnVarNameInTable="columnofficePhone" msprop:Generator_ColumnPropNameInRow="officePhone" msprop:Generator_ColumnPropNameInTable="officePhoneColumn" minOccurs="0"> + <xs:element name="officePhone" msprop:Generator_UserColumnName="officePhone" msprop:Generator_ColumnPropNameInRow="officePhone" msprop:Generator_ColumnVarNameInTable="columnofficePhone" msprop:Generator_ColumnPropNameInTable="officePhoneColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="14" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="homePhone" msprop:Generator_UserColumnName="homePhone" msprop:Generator_ColumnVarNameInTable="columnhomePhone" msprop:Generator_ColumnPropNameInRow="homePhone" msprop:Generator_ColumnPropNameInTable="homePhoneColumn" minOccurs="0"> + <xs:element name="homePhone" msprop:Generator_UserColumnName="homePhone" msprop:Generator_ColumnPropNameInRow="homePhone" msprop:Generator_ColumnVarNameInTable="columnhomePhone" msprop:Generator_ColumnPropNameInTable="homePhoneColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="14" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="cellPhone" msprop:Generator_UserColumnName="cellPhone" msprop:Generator_ColumnVarNameInTable="columncellPhone" msprop:Generator_ColumnPropNameInRow="cellPhone" msprop:Generator_ColumnPropNameInTable="cellPhoneColumn" minOccurs="0"> + <xs:element name="cellPhone" msprop:Generator_UserColumnName="cellPhone" msprop:Generator_ColumnPropNameInRow="cellPhone" msprop:Generator_ColumnVarNameInTable="columncellPhone" msprop:Generator_ColumnPropNameInTable="cellPhoneColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="14" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="firstName" msprop:Generator_UserColumnName="firstName" msprop:Generator_ColumnVarNameInTable="columnfirstName" msprop:Generator_ColumnPropNameInRow="firstName" msprop:Generator_ColumnPropNameInTable="firstNameColumn"> + <xs:element name="firstName" msprop:Generator_UserColumnName="firstName" msprop:Generator_ColumnPropNameInRow="firstName" msprop:Generator_ColumnVarNameInTable="columnfirstName" msprop:Generator_ColumnPropNameInTable="firstNameColumn"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="24" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="lastName" msprop:Generator_UserColumnName="lastName" msprop:Generator_ColumnVarNameInTable="columnlastName" msprop:Generator_ColumnPropNameInRow="lastName" msprop:Generator_ColumnPropNameInTable="lastNameColumn"> + <xs:element name="lastName" msprop:Generator_UserColumnName="lastName" msprop:Generator_ColumnPropNameInRow="lastName" msprop:Generator_ColumnVarNameInTable="columnlastName" msprop:Generator_ColumnPropNameInTable="lastNameColumn"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="24" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="fullName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="fullName" msprop:Generator_ColumnVarNameInTable="columnfullName" msprop:Generator_ColumnPropNameInRow="fullName" msprop:Generator_ColumnPropNameInTable="fullNameColumn" minOccurs="0"> + <xs:element name="fullName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="fullName" msprop:Generator_ColumnPropNameInRow="fullName" msprop:Generator_ColumnVarNameInTable="columnfullName" msprop:Generator_ColumnPropNameInTable="fullNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="49" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="automation" msprop:Generator_UserColumnName="automation" msprop:Generator_ColumnVarNameInTable="columnautomation" msprop:Generator_ColumnPropNameInRow="automation" msprop:Generator_ColumnPropNameInTable="automationColumn" type="xs:boolean" /> + <xs:element name="automation" msprop:Generator_UserColumnName="automation" msprop:Generator_ColumnPropNameInRow="automation" msprop:Generator_ColumnVarNameInTable="columnautomation" msprop:Generator_ColumnPropNameInTable="automationColumn" type="xs:boolean" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="db_products" msprop:Generator_UserTableName="db_products" msprop:Generator_RowDeletedName="db_productsRowDeleted" msprop:Generator_RowChangedName="db_productsRowChanged" msprop:Generator_RowClassName="db_productsRow" msprop:Generator_RowChangingName="db_productsRowChanging" msprop:Generator_RowEvArgName="db_productsRowChangeEvent" msprop:Generator_RowEvHandlerName="db_productsRowChangeEventHandler" msprop:Generator_TableClassName="db_productsDataTable" msprop:Generator_TableVarName="tabledb_products" msprop:Generator_RowDeletingName="db_productsRowDeleting" msprop:Generator_TablePropName="db_products"> <xs:complexType> <xs:sequence> - <xs:element name="productID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="productID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="devManager" msprop:Generator_UserColumnName="devManager" msprop:Generator_ColumnVarNameInTable="columndevManager" msprop:Generator_ColumnPropNameInRow="devManager" msprop:Generator_ColumnPropNameInTable="devManagerColumn" type="xs:int" minOccurs="0" /> - <xs:element name="qaManager" msprop:Generator_UserColumnName="qaManager" msprop:Generator_ColumnVarNameInTable="columnqaManager" msprop:Generator_ColumnPropNameInRow="qaManager" msprop:Generator_ColumnPropNameInTable="qaManagerColumn" type="xs:int" minOccurs="0" /> - <xs:element name="devLead" msprop:Generator_UserColumnName="devLead" msprop:Generator_ColumnVarNameInTable="columndevLead" msprop:Generator_ColumnPropNameInRow="devLead" msprop:Generator_ColumnPropNameInTable="devLeadColumn" type="xs:int" minOccurs="0" /> - <xs:element name="qaLead" msprop:Generator_UserColumnName="qaLead" msprop:Generator_ColumnVarNameInTable="columnqaLead" msprop:Generator_ColumnPropNameInRow="qaLead" msprop:Generator_ColumnPropNameInTable="qaLeadColumn" type="xs:int" minOccurs="0" /> - <xs:element name="pm" msprop:Generator_UserColumnName="pm" msprop:Generator_ColumnVarNameInTable="columnpm" msprop:Generator_ColumnPropNameInRow="pm" msprop:Generator_ColumnPropNameInTable="pmColumn" type="xs:int" minOccurs="0" /> - <xs:element name="codeName" msprop:Generator_UserColumnName="codeName" msprop:Generator_ColumnVarNameInTable="columncodeName" msprop:Generator_ColumnPropNameInRow="codeName" msprop:Generator_ColumnPropNameInTable="codeNameColumn" minOccurs="0"> + <xs:element name="devManager" msprop:Generator_UserColumnName="devManager" msprop:Generator_ColumnPropNameInRow="devManager" msprop:Generator_ColumnVarNameInTable="columndevManager" msprop:Generator_ColumnPropNameInTable="devManagerColumn" type="xs:int" minOccurs="0" /> + <xs:element name="qaManager" msprop:Generator_UserColumnName="qaManager" msprop:Generator_ColumnPropNameInRow="qaManager" msprop:Generator_ColumnVarNameInTable="columnqaManager" msprop:Generator_ColumnPropNameInTable="qaManagerColumn" type="xs:int" minOccurs="0" /> + <xs:element name="devLead" msprop:Generator_UserColumnName="devLead" msprop:Generator_ColumnPropNameInRow="devLead" msprop:Generator_ColumnVarNameInTable="columndevLead" msprop:Generator_ColumnPropNameInTable="devLeadColumn" type="xs:int" minOccurs="0" /> + <xs:element name="qaLead" msprop:Generator_UserColumnName="qaLead" msprop:Generator_ColumnPropNameInRow="qaLead" msprop:Generator_ColumnVarNameInTable="columnqaLead" msprop:Generator_ColumnPropNameInTable="qaLeadColumn" type="xs:int" minOccurs="0" /> + <xs:element name="pm" msprop:Generator_UserColumnName="pm" msprop:Generator_ColumnPropNameInRow="pm" msprop:Generator_ColumnVarNameInTable="columnpm" msprop:Generator_ColumnPropNameInTable="pmColumn" type="xs:int" minOccurs="0" /> + <xs:element name="codeName" msprop:Generator_UserColumnName="codeName" msprop:Generator_ColumnPropNameInRow="codeName" msprop:Generator_ColumnVarNameInTable="columncodeName" msprop:Generator_ColumnPropNameInTable="codeNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="active" msprop:Generator_UserColumnName="active" msprop:Generator_ColumnVarNameInTable="columnactive" msprop:Generator_ColumnPropNameInRow="active" msprop:Generator_ColumnPropNameInTable="activeColumn" type="xs:boolean" /> + <xs:element name="active" msprop:Generator_UserColumnName="active" msprop:Generator_ColumnPropNameInRow="active" msprop:Generator_ColumnVarNameInTable="columnactive" msprop:Generator_ColumnPropNameInTable="activeColumn" type="xs:boolean" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="db_actionItems" msprop:Generator_UserTableName="db_actionItems" msprop:Generator_RowDeletedName="db_actionItemsRowDeleted" msprop:Generator_RowChangedName="db_actionItemsRowChanged" msprop:Generator_RowClassName="db_actionItemsRow" msprop:Generator_RowChangingName="db_actionItemsRowChanging" msprop:Generator_RowEvArgName="db_actionItemsRowChangeEvent" msprop:Generator_RowEvHandlerName="db_actionItemsRowChangeEventHandler" msprop:Generator_TableClassName="db_actionItemsDataTable" msprop:Generator_TableVarName="tabledb_actionItems" msprop:Generator_RowDeletingName="db_actionItemsRowDeleting" msprop:Generator_TablePropName="db_actionItems"> <xs:complexType> <xs:sequence> - <xs:element name="actionItemID" msprop:Generator_UserColumnName="actionItemID" msprop:Generator_ColumnPropNameInRow="actionItemID" msprop:Generator_ColumnVarNameInTable="columnactionItemID" msprop:Generator_ColumnPropNameInTable="actionItemIDColumn" type="xs:int" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="actionItemID" msprop:Generator_UserColumnName="actionItemID" msprop:Generator_ColumnVarNameInTable="columnactionItemID" msprop:Generator_ColumnPropNameInRow="actionItemID" msprop:Generator_ColumnPropNameInTable="actionItemIDColumn" type="xs:int" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="dateAssigned" msprop:Generator_UserColumnName="dateAssigned" msprop:Generator_ColumnPropNameInRow="dateAssigned" msprop:Generator_ColumnVarNameInTable="columndateAssigned" msprop:Generator_ColumnPropNameInTable="dateAssignedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="dateDue" msprop:Generator_UserColumnName="dateDue" msprop:Generator_ColumnPropNameInRow="dateDue" msprop:Generator_ColumnVarNameInTable="columndateDue" msprop:Generator_ColumnPropNameInTable="dateDueColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="percentComplete" msprop:Generator_UserColumnName="percentComplete" msprop:Generator_ColumnPropNameInRow="percentComplete" msprop:Generator_ColumnVarNameInTable="columnpercentComplete" msprop:Generator_ColumnPropNameInTable="percentCompleteColumn" type="xs:int" minOccurs="0" /> - <xs:element name="statusName" msprop:Generator_UserColumnName="statusName" msprop:Generator_ColumnPropNameInRow="statusName" msprop:Generator_ColumnVarNameInTable="columnstatusName" msprop:Generator_ColumnPropNameInTable="statusNameColumn" minOccurs="0"> + <xs:element name="dateAssigned" msprop:Generator_UserColumnName="dateAssigned" msprop:Generator_ColumnVarNameInTable="columndateAssigned" msprop:Generator_ColumnPropNameInRow="dateAssigned" msprop:Generator_ColumnPropNameInTable="dateAssignedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="dateDue" msprop:Generator_UserColumnName="dateDue" msprop:Generator_ColumnVarNameInTable="columndateDue" msprop:Generator_ColumnPropNameInRow="dateDue" msprop:Generator_ColumnPropNameInTable="dateDueColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="percentComplete" msprop:Generator_UserColumnName="percentComplete" msprop:Generator_ColumnVarNameInTable="columnpercentComplete" msprop:Generator_ColumnPropNameInRow="percentComplete" msprop:Generator_ColumnPropNameInTable="percentCompleteColumn" type="xs:int" minOccurs="0" /> + <xs:element name="statusName" msprop:Generator_UserColumnName="statusName" msprop:Generator_ColumnVarNameInTable="columnstatusName" msprop:Generator_ColumnPropNameInRow="statusName" msprop:Generator_ColumnPropNameInTable="statusNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="createdBy" msdata:ReadOnly="true" msprop:Generator_UserColumnName="createdBy" msprop:Generator_ColumnPropNameInRow="createdBy" msprop:Generator_ColumnVarNameInTable="columncreatedBy" msprop:Generator_ColumnPropNameInTable="createdByColumn" minOccurs="0"> + <xs:element name="createdBy" msdata:ReadOnly="true" msprop:Generator_UserColumnName="createdBy" msprop:Generator_ColumnVarNameInTable="columncreatedBy" msprop:Generator_ColumnPropNameInRow="createdBy" msprop:Generator_ColumnPropNameInTable="createdByColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="49" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="highPriority" msprop:Generator_UserColumnName="highPriority" msprop:Generator_ColumnPropNameInRow="highPriority" msprop:Generator_ColumnVarNameInTable="columnhighPriority" msprop:Generator_ColumnPropNameInTable="highPriorityColumn" type="xs:boolean" minOccurs="0" /> - <xs:element name="createdById" msprop:Generator_UserColumnName="createdById" msprop:Generator_ColumnPropNameInRow="createdById" msprop:Generator_ColumnVarNameInTable="columncreatedById" msprop:Generator_ColumnPropNameInTable="createdByIdColumn" type="xs:int" /> + <xs:element name="highPriority" msprop:Generator_UserColumnName="highPriority" msprop:Generator_ColumnVarNameInTable="columnhighPriority" msprop:Generator_ColumnPropNameInRow="highPriority" msprop:Generator_ColumnPropNameInTable="highPriorityColumn" type="xs:boolean" minOccurs="0" /> + <xs:element name="createdById" msprop:Generator_UserColumnName="createdById" msprop:Generator_ColumnVarNameInTable="columncreatedById" msprop:Generator_ColumnPropNameInRow="createdById" msprop:Generator_ColumnPropNameInTable="createdByIdColumn" type="xs:int" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="db_status" msprop:Generator_UserTableName="db_status" msprop:Generator_RowDeletedName="db_statusRowDeleted" msprop:Generator_RowChangedName="db_statusRowChanged" msprop:Generator_RowClassName="db_statusRow" msprop:Generator_RowChangingName="db_statusRowChanging" msprop:Generator_RowEvArgName="db_statusRowChangeEvent" msprop:Generator_RowEvHandlerName="db_statusRowChangeEventHandler" msprop:Generator_TableClassName="db_statusDataTable" msprop:Generator_TableVarName="tabledb_status" msprop:Generator_RowDeletingName="db_statusRowDeleting" msprop:Generator_TablePropName="db_status"> <xs:complexType> <xs:sequence> - <xs:element name="statusID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="statusID" msprop:Generator_ColumnVarNameInTable="columnstatusID" msprop:Generator_ColumnPropNameInRow="statusID" msprop:Generator_ColumnPropNameInTable="statusIDColumn" type="xs:int" /> - <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0"> + <xs:element name="statusID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="statusID" msprop:Generator_ColumnPropNameInRow="statusID" msprop:Generator_ColumnVarNameInTable="columnstatusID" msprop:Generator_ColumnPropNameInTable="statusIDColumn" type="xs:int" /> + <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> @@ -498,67 +499,74 @@ <xs:element name="db_notes" msprop:Generator_UserTableName="db_notes" msprop:Generator_RowDeletedName="db_notesRowDeleted" msprop:Generator_RowChangedName="db_notesRowChanged" msprop:Generator_RowClassName="db_notesRow" msprop:Generator_RowChangingName="db_notesRowChanging" msprop:Generator_RowEvArgName="db_notesRowChangeEvent" msprop:Generator_RowEvHandlerName="db_notesRowChangeEventHandler" msprop:Generator_TableClassName="db_notesDataTable" msprop:Generator_TableVarName="tabledb_notes" msprop:Generator_RowDeletingName="db_notesRowDeleting" msprop:Generator_TablePropName="db_notes"> <xs:complexType> <xs:sequence> - <xs:element name="noteID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="noteID" msprop:Generator_ColumnVarNameInTable="columnnoteID" msprop:Generator_ColumnPropNameInRow="noteID" msprop:Generator_ColumnPropNameInTable="noteIDColumn" type="xs:int" /> - <xs:element name="dateCreated" msprop:Generator_UserColumnName="dateCreated" msprop:Generator_ColumnVarNameInTable="columndateCreated" msprop:Generator_ColumnPropNameInRow="dateCreated" msprop:Generator_ColumnPropNameInTable="dateCreatedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="noteField" msprop:Generator_UserColumnName="noteField" msprop:Generator_ColumnVarNameInTable="columnnoteField" msprop:Generator_ColumnPropNameInRow="noteField" msprop:Generator_ColumnPropNameInTable="noteFieldColumn" minOccurs="0"> + <xs:element name="noteID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="noteID" msprop:Generator_ColumnPropNameInRow="noteID" msprop:Generator_ColumnVarNameInTable="columnnoteID" msprop:Generator_ColumnPropNameInTable="noteIDColumn" type="xs:int" /> + <xs:element name="dateCreated" msprop:Generator_UserColumnName="dateCreated" msprop:Generator_ColumnPropNameInRow="dateCreated" msprop:Generator_ColumnVarNameInTable="columndateCreated" msprop:Generator_ColumnPropNameInTable="dateCreatedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="noteField" msprop:Generator_UserColumnName="noteField" msprop:Generator_ColumnPropNameInRow="noteField" msprop:Generator_ColumnVarNameInTable="columnnoteField" msprop:Generator_ColumnPropNameInTable="noteFieldColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="noteAuthor" msprop:Generator_UserColumnName="noteAuthor" msprop:Generator_ColumnVarNameInTable="columnnoteAuthor" msprop:Generator_ColumnPropNameInRow="noteAuthor" msprop:Generator_ColumnPropNameInTable="noteAuthorColumn" type="xs:int" minOccurs="0" /> + <xs:element name="noteAuthor" msprop:Generator_UserColumnName="noteAuthor" msprop:Generator_ColumnPropNameInRow="noteAuthor" msprop:Generator_ColumnVarNameInTable="columnnoteAuthor" msprop:Generator_ColumnPropNameInTable="noteAuthorColumn" type="xs:int" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="db_assignments" msprop:Generator_UserTableName="db_assignments" msprop:Generator_RowDeletedName="db_assignmentsRowDeleted" msprop:Generator_RowChangedName="db_assignmentsRowChanged" msprop:Generator_RowClassName="db_assignmentsRow" msprop:Generator_RowChangingName="db_assignmentsRowChanging" msprop:Generator_RowEvArgName="db_assignmentsRowChangeEvent" msprop:Generator_RowEvHandlerName="db_assignmentsRowChangeEventHandler" msprop:Generator_TableClassName="db_assignmentsDataTable" msprop:Generator_TableVarName="tabledb_assignments" msprop:Generator_RowDeletingName="db_assignmentsRowDeleting" msprop:Generator_TablePropName="db_assignments"> <xs:complexType> <xs:sequence> - <xs:element name="aType" msdata:ReadOnly="true" msprop:Generator_UserColumnName="aType" msprop:Generator_ColumnVarNameInTable="columnaType" msprop:Generator_ColumnPropNameInRow="aType" msprop:Generator_ColumnPropNameInTable="aTypeColumn" minOccurs="0"> + <xs:element name="aType" msdata:ReadOnly="true" msprop:Generator_UserColumnName="aType" msprop:Generator_ColumnPropNameInRow="aType" msprop:Generator_ColumnVarNameInTable="columnaType" msprop:Generator_ColumnPropNameInTable="aTypeColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="childID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="childID" msprop:Generator_ColumnVarNameInTable="columnchildID" msprop:Generator_ColumnPropNameInRow="childID" msprop:Generator_ColumnPropNameInTable="childIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="creator" msdata:ReadOnly="true" msprop:Generator_UserColumnName="creator" msprop:Generator_ColumnVarNameInTable="columncreator" msprop:Generator_ColumnPropNameInRow="creator" msprop:Generator_ColumnPropNameInTable="creatorColumn" minOccurs="0"> + <xs:element name="childID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="childID" msprop:Generator_ColumnPropNameInRow="childID" msprop:Generator_ColumnVarNameInTable="columnchildID" msprop:Generator_ColumnPropNameInTable="childIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="creator" msdata:ReadOnly="true" msprop:Generator_UserColumnName="creator" msprop:Generator_ColumnPropNameInRow="creator" msprop:Generator_ColumnVarNameInTable="columncreator" msprop:Generator_ColumnPropNameInTable="creatorColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="49" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="assigned" msdata:ReadOnly="true" msprop:Generator_UserColumnName="assigned" msprop:Generator_ColumnVarNameInTable="columnassigned" msprop:Generator_ColumnPropNameInRow="assigned" msprop:Generator_ColumnPropNameInTable="assignedColumn" minOccurs="0"> + <xs:element name="assigned" msdata:ReadOnly="true" msprop:Generator_UserColumnName="assigned" msprop:Generator_ColumnPropNameInRow="assigned" msprop:Generator_ColumnVarNameInTable="columnassigned" msprop:Generator_ColumnPropNameInTable="assignedColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="49" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="assignedID" msprop:Generator_UserColumnName="assignedID" msprop:Generator_ColumnVarNameInTable="columnassignedID" msprop:Generator_ColumnPropNameInRow="assignedID" msprop:Generator_ColumnPropNameInTable="assignedIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="dateAssigned" msprop:Generator_UserColumnName="dateAssigned" msprop:Generator_ColumnVarNameInTable="columndateAssigned" msprop:Generator_ColumnPropNameInRow="dateAssigned" msprop:Generator_ColumnPropNameInTable="dateAssignedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="dateDue" msprop:Generator_UserColumnName="dateDue" msprop:Generator_ColumnVarNameInTable="columndateDue" msprop:Generator_ColumnPropNameInRow="dateDue" msprop:Generator_ColumnPropNameInTable="dateDueColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="dateFinished" msprop:Generator_UserColumnName="dateFinished" msprop:Generator_ColumnVarNameInTable="columndateFinished" msprop:Generator_ColumnPropNameInRow="dateFinished" msprop:Generator_ColumnPropNameInTable="dateFinishedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="highPriority" msprop:Generator_UserColumnName="highPriority" msprop:Generator_ColumnVarNameInTable="columnhighPriority" msprop:Generator_ColumnPropNameInRow="highPriority" msprop:Generator_ColumnPropNameInTable="highPriorityColumn" type="xs:boolean" minOccurs="0" /> - <xs:element name="statusName" msprop:Generator_UserColumnName="statusName" msprop:Generator_ColumnVarNameInTable="columnstatusName" msprop:Generator_ColumnPropNameInRow="statusName" msprop:Generator_ColumnPropNameInTable="statusNameColumn" minOccurs="0"> + <xs:element name="assignedID" msprop:Generator_UserColumnName="assignedID" msprop:Generator_ColumnPropNameInRow="assignedID" msprop:Generator_ColumnVarNameInTable="columnassignedID" msprop:Generator_ColumnPropNameInTable="assignedIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="dateAssigned" msprop:Generator_UserColumnName="dateAssigned" msprop:Generator_ColumnPropNameInRow="dateAssigned" msprop:Generator_ColumnVarNameInTable="columndateAssigned" msprop:Generator_ColumnPropNameInTable="dateAssignedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="dateDue" msprop:Generator_UserColumnName="dateDue" msprop:Generator_ColumnPropNameInRow="dateDue" msprop:Generator_ColumnVarNameInTable="columndateDue" msprop:Generator_ColumnPropNameInTable="dateDueColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="dateFinished" msprop:Generator_UserColumnName="dateFinished" msprop:Generator_ColumnPropNameInRow="dateFinished" msprop:Generator_ColumnVarNameInTable="columndateFinished" msprop:Generator_ColumnPropNameInTable="dateFinishedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="highPriority" msprop:Generator_UserColumnName="highPriority" msprop:Generator_ColumnPropNameInRow="highPriority" msprop:Generator_ColumnVarNameInTable="columnhighPriority" msprop:Generator_ColumnPropNameInTable="highPriorityColumn" type="xs:boolean" minOccurs="0" /> + <xs:element name="statusName" msprop:Generator_UserColumnName="statusName" msprop:Generator_ColumnPropNameInRow="statusName" msprop:Generator_ColumnVarNameInTable="columnstatusName" msprop:Generator_ColumnPropNameInTable="statusNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="WOTotalTest" msprop:Generator_UserColumnName="WOTotalTest" msprop:Generator_ColumnVarNameInTable="columnWOTotalTest" msprop:Generator_ColumnPropNameInRow="WOTotalTest" msprop:Generator_ColumnPropNameInTable="WOTotalTestColumn" type="xs:int" minOccurs="0" /> - <xs:element name="WOPassRate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="WOPassRate" msprop:Generator_ColumnVarNameInTable="columnWOPassRate" msprop:Generator_ColumnPropNameInRow="WOPassRate" msprop:Generator_ColumnPropNameInTable="WOPassRateColumn" minOccurs="0"> + <xs:element name="WOTotalTest" msprop:Generator_UserColumnName="WOTotalTest" msprop:Generator_ColumnPropNameInRow="WOTotalTest" msprop:Generator_ColumnVarNameInTable="columnWOTotalTest" msprop:Generator_ColumnPropNameInTable="WOTotalTestColumn" type="xs:int" minOccurs="0" /> + <xs:element name="WOPassRate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="WOPassRate" msprop:Generator_ColumnPropNameInRow="WOPassRate" msprop:Generator_ColumnVarNameInTable="columnWOPassRate" msprop:Generator_ColumnPropNameInTable="WOPassRateColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="31" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="WOPass" msprop:Generator_UserColumnName="WOPass" msprop:Generator_ColumnVarNameInTable="columnWOPass" msprop:Generator_ColumnPropNameInRow="WOPass" msprop:Generator_ColumnPropNameInTable="WOPassColumn" type="xs:int" minOccurs="0" /> - <xs:element name="WOFail" msprop:Generator_UserColumnName="WOFail" msprop:Generator_ColumnVarNameInTable="columnWOFail" msprop:Generator_ColumnPropNameInRow="WOFail" msprop:Generator_ColumnPropNameInTable="WOFailColumn" type="xs:int" minOccurs="0" /> - <xs:element name="WOError" msprop:Generator_UserColumnName="WOError" msprop:Generator_ColumnVarNameInTable="columnWOError" msprop:Generator_ColumnPropNameInRow="WOError" msprop:Generator_ColumnPropNameInTable="WOErrorColumn" type="xs:int" minOccurs="0" /> + <xs:element name="WOPass" msprop:Generator_UserColumnName="WOPass" msprop:Generator_ColumnPropNameInRow="WOPass" msprop:Generator_ColumnVarNameInTable="columnWOPass" msprop:Generator_ColumnPropNameInTable="WOPassColumn" type="xs:int" minOccurs="0" /> + <xs:element name="WOFail" msprop:Generator_UserColumnName="WOFail" msprop:Generator_ColumnPropNameInRow="WOFail" msprop:Generator_ColumnVarNameInTable="columnWOFail" msprop:Generator_ColumnPropNameInTable="WOFailColumn" type="xs:int" minOccurs="0" /> + <xs:element name="WOError" msprop:Generator_UserColumnName="WOError" msprop:Generator_ColumnPropNameInRow="WOError" msprop:Generator_ColumnVarNameInTable="columnWOError" msprop:Generator_ColumnPropNameInTable="WOErrorColumn" type="xs:int" minOccurs="0" /> + <xs:element name="aName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="aName" msprop:Generator_ColumnPropNameInRow="aName" msprop:Generator_ColumnVarNameInTable="columnaName" msprop:Generator_ColumnPropNameInTable="aNameColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="255" /> + </xs:restriction> + </xs:simpleType> + </xs:element> </xs:sequence> </xs:complexType> </xs:element> Added: Website/Global.asax =================================================================== --- Website/Global.asax (rev 0) +++ Website/Global.asax 2006-07-11 19:32:56 UTC (rev 97) @@ -0,0 +1,26 @@ +<%@ Application Language="C#" %> +<%@ Import Namespace="TCDB_Users" %> + +<script runat="server"> + + void Application_PreRequestHandlerExecute(object sender, EventArgs e) + { + TCDB_User user; + + // Fires when a security module establishes the identity of the user + if (!Context.Items.Contains("user")) + { + try + { + user = TCDB_UserDB.TCDB_GetUserInfo((int)(Session["userID"])); + } + catch + { + user = new TCDB_User(); + } + + Context.Items.Add("user", user); + } + + } +</script> Modified: Website/Includes/ActionItems.ascx =================================================================== --- Website/Includes/ActionItems.ascx 2006-07-11 17:05:34 UTC (rev 96) +++ Website/Includes/ActionItems.ascx 2006-07-11 19:32:56 UTC (rev 97) @@ -1 +1,3 @@ <%@ Control Language="C#" AutoEventWireup="true" %> +<%@ Import Namespace="TCDB_Users" %> +<script runat="server">TCDB_User g_user = TCDB_UserDB.TCDB_GetUserInstance();</script> Modified: Website/Includes/AdministrationTree.ascx =================================================================== --- Website/Includes/AdministrationTree.ascx 2006-07-11 17:05:34 UTC (rev 96) +++ Website/Includes/AdministrationTree.ascx 2006-07-11 19:32:56 UTC (rev 97) @@ -1,4 +1,6 @@ <%@ Control Language="C#" ClassName="AdministrationTree" %> +<%@ Import Namespace="TCDB_Users" %> +<script runat="server">TCDB_User g_user = TCDB_UserDB.TCDB_GetUserInstance();</script> <script runat="server"> Modified: Website/Includes/Assignments.ascx =================================================================== --- Website/Includes/Assignments.ascx 2006-07-11 17:05:34 UTC (rev 96) +++ Website/Includes/Assignments.ascx 2006-07-11 19:32:56 UTC (rev 97) @@ -1 +1,3 @@ <%@ Control Language="C#" AutoEventWireup="true" %> +<%@ Import Namespace="TCDB_Users" %> +<script runat="server">TCDB_User g_user = TCDB_UserDB.TCDB_GetUserInstance();</script> Modified: Website/Includes/AssignmentsTree.ascx =================================================================== --- Website/Includes/AssignmentsTree.ascx 2006-07-11 17:05:34 UTC (rev 96) +++ Website/Includes/AssignmentsTree.ascx 2006-07-11 19:32:56 UTC (rev 97) @@ -4,8 +4,8 @@ <%@ Import Namespace="System.Collections.Generic" %> <%@ Import Namespace="TCDB_Assignments" %> <%@ Import Namespace="TCDB_Users" %> +<script runat="server">TCDB_User g_user = TCDB_UserDB.TCDB_GetUserInstance();</script> - <script runat="server"> protected void Page_Load(object sender, EventArgs e) @@ -24,11 +24,6 @@ protected void AssignmentsTree_TreeNodePopulate(object sender, TreeNodeEventArgs e) { - TreeView tv = (TreeView)sender; - DataSet ResultsDataSet = new DataSet(); - SqlDataAdapter DBAdapter; - String query; - // Call the appropriate method to populate a node at a particular level. switch (e.Node.Depth) { @@ -46,7 +41,7 @@ priv... [truncated message content] |
