Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [44] WebPrototype
|
From: <ro...@us...> - 2006-06-20 21:27:53
|
Revision: 44 Author: rouquin Date: 2006-06-20 14:27:31 -0700 (Tue, 20 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=44&view=rev Log Message: ----------- Changed Assignments page to show orders by user and added assignments TreeView. You can also filter test cases to assign to a test case by tags. Other minor changes Modified Paths: -------------- WebPrototype/ActionItemEdit.aspx WebPrototype/ActionItemEdit.aspx.cs WebPrototype/App_Code/DummyDataSet.xsd WebPrototype/App_Code/DummyDataSet.xss WebPrototype/App_Data/ASPNETDB.MDF WebPrototype/App_Data/Database.mdf WebPrototype/App_Data/Database_log.LDF WebPrototype/App_Data/aspnetdb_log.ldf WebPrototype/Assignments.aspx WebPrototype/Assignments.aspx.cs WebPrototype/TestCaseEdit.aspx WebPrototype/WorkOrderEdit.aspx WebPrototype/WorkOrderEdit.aspx.cs Removed Paths: ------------- WebPrototype/WorkOrder.aspx WebPrototype/WorkOrder.aspx.cs Modified: WebPrototype/ActionItemEdit.aspx =================================================================== --- WebPrototype/ActionItemEdit.aspx 2006-06-20 18:59:21 UTC (rev 43) +++ WebPrototype/ActionItemEdit.aspx 2006-06-20 21:27:31 UTC (rev 44) @@ -14,8 +14,9 @@ <asp:TreeView ID=TreeView1 runat="server" SelectedNodeStyle-CssClass="selectednode" OnTreeNodePopulate=TreeView1_TreeNodePopulate> <Nodes> - <asp:TreeNode Text="User Assignments" Value="Users" PopulateOnDemand="true" SelectAction=Expand /> + <asp:TreeNode Text="User Assignments" Value="Users" PopulateOnDemand="True" SelectAction=Expand NavigateUrl="~/Assignments.aspx" /> </Nodes> + <SelectedNodeStyle CssClass="selectednode" /> </asp:TreeView> </td> <td width="700px" valign="top"> Modified: WebPrototype/ActionItemEdit.aspx.cs =================================================================== --- WebPrototype/ActionItemEdit.aspx.cs 2006-06-20 18:59:21 UTC (rev 43) +++ WebPrototype/ActionItemEdit.aspx.cs 2006-06-20 21:27:31 UTC (rev 44) @@ -37,6 +37,7 @@ DropDownList statusList = (DropDownList)sender; SqlCommand cmd = new SqlCommand("UPDATE Assignments SET statusID=" + statusList.SelectedValue + " WHERE actionItemID=" + id, DBConnection); cmd.ExecuteNonQuery(); + FormView1.DataBind(); } } @@ -147,6 +148,7 @@ // Set additional properties for the node. newNode.SelectAction = TreeNodeSelectAction.Expand; + newNode.NavigateUrl = "~/Assignments.aspx?id=" + row["id"]; // Add the new node to the ChildNodes collection of the parent node. e.Node.ChildNodes.Add(newNode); Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-20 18:59:21 UTC (rev 43) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-06-20 21:27:31 UTC (rev 44) @@ -329,7 +329,7 @@ </DbCommand> </DeleteCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.TestCase" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAllTestCaseData" GetMethodModifier="Public" GetMethodName="GetAllTestCaseData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAllTestCaseData" UserSourceName="FillBy"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.TestCase" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAllTestCaseData" GetMethodModifier="Public" GetMethodName="GetAllTestCaseData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAllTestCaseData" UserSourceName="GetAllTestCaseData1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT id, objectiveID, CAST(number AS varchar(20)) + ': ' + name AS Name, statusID, steps, createdby, editedby, dateCreated, dateEdited @@ -792,6 +792,43 @@ <Mapping SourceColumn="assignedID" DataSetColumn="assignedID" /> </Mappings> <Sources> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetActionItemNamesByUser" GetMethodModifier="Public" GetMethodName="GetActionItemNamesByUser" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetActionItemNamesByUser" UserSourceName="FillBy"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT ActionItem.name AS ActionItem, Assignments.assignmentID, u1.firstName + ' ' + u1.lastName AS Creator, u2.firstName + ' ' + u2.lastName AS Assignee, Assignments.dateAssigned, + Assignments.dateFinished, Assignments.dateDue, Assignments.statusID, Status.stateName, Assignments.actionItemID, Assignments.highPriorityID +FROM Assignments INNER JOIN + ActionItem ON ActionItem.actionItemID = Assignments.actionItemID LEFT OUTER JOIN + Users AS u1 ON u1.id = Assignments.creatorID LEFT OUTER JOIN + Users AS u2 ON u2.id = Assignments.assignedID LEFT OUTER JOIN + Status ON Status.id = Assignments.statusID +WHERE assignedID=@assignedID</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="assignedID" ColumnName="assignedID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Assignments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@assignedID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="assignedID" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetWorkOrderNamesByUser" GetMethodModifier="Public" GetMethodName="GetWorkOrderNamesByUser" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetWorkOrderNamesByUser" UserSourceName="FillBy1"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT WorkOrder.name AS WorkOrder, Assignments.assignmentID, u1.firstName + ' ' + u1.lastName AS Creator, + u2.firstName + ' ' + u2.lastName AS Assignee, Assignments.dateAssigned, Assignments.dateFinished, Assignments.dateDue, Assignments.statusID, + Status.stateName, Assignments.workOrderID, Assignments.highPriorityID +FROM Assignments INNER JOIN + WorkOrder ON WorkOrder.workOrderID = Assignments.workOrderID LEFT OUTER JOIN + Users AS u1 ON u1.id = Assignments.creatorID LEFT OUTER JOIN + Users AS u2 ON u2.id = Assignments.assignedID LEFT OUTER JOIN + Status ON Status.id = Assignments.statusID +WHERE assignedID=@assignedID</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="assignedID" ColumnName="assignedID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Assignments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@assignedID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="assignedID" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAllActionItemNames" GetMethodModifier="Public" GetMethodName="GetAllActionItemNames" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAllActionItemNames" UserSourceName="GetAllActionItemNames1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> @@ -1034,7 +1071,7 @@ <Mapping SourceColumn="osID" DataSetColumn="osID" /> </Mappings> <Sources> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetPlatformNameDataByID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetPlatformNameDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetPlatformNameDataByID" UserSourceName="FillBy"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetPlatformNameDataByID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetPlatformNameDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetPlatformNameDataByID" UserSourceName="GetPlatformNameDataByID1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT platform.platformID, architecture.name, os.friendlyName @@ -1074,7 +1111,7 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="architectureTableAdapter" GeneratorDataComponentClassName="architectureTableAdapter" Name="architecture" UserDataComponentName="architectureTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.architecture" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllArchitectureData" GetMethodModifier="Public" GetMethodName="GetAllArchitectureData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllArchitectureData" UserSourceName="Fill"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.architecture" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllArchitectureData" GetMethodModifier="Public" GetMethodName="GetAllArchitectureData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllArchitectureData" UserSourceName="GetAllArchitectureData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT architectureID, name @@ -1094,7 +1131,7 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="osTableAdapter" GeneratorDataComponentClassName="osTableAdapter" Name="os" UserDataComponentName="osTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.os" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllOSData" GetMethodModifier="Public" GetMethodName="GetAllOSData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllOSData" UserSourceName="Fill"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.os" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllOSData" GetMethodModifier="Public" GetMethodName="GetAllOSData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllOSData" UserSourceName="GetAllOSData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT * FROM os</CommandText> @@ -1124,117 +1161,117 @@ <xs:element name="Feature" msprop:Generator_UserTableName="Feature" msprop:Generator_RowDeletedName="FeatureRowDeleted" msprop:Generator_RowChangedName="FeatureRowChanged" msprop:Generator_RowClassName="FeatureRow" msprop:Generator_RowChangingName="FeatureRowChanging" msprop:Generator_RowEvArgName="FeatureRowChangeEvent" msprop:Generator_RowEvHandlerName="FeatureRowChangeEventHandler" msprop:Generator_TableClassName="FeatureDataTable" msprop:Generator_TableVarName="tableFeature" msprop:Generator_RowDeletingName="FeatureRowDeleting" msprop:Generator_TablePropName="Feature"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="parent_id" msprop:Generator_UserColumnName="parent_id" msprop:Generator_ColumnVarNameInTable="columnparent_id" msprop:Generator_ColumnPropNameInRow="parent_id" msprop:Generator_ColumnPropNameInTable="parent_idColumn" type="xs:int" minOccurs="0" /> - <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="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="parent_id" msprop:Generator_UserColumnName="parent_id" msprop:Generator_ColumnPropNameInRow="parent_id" msprop:Generator_ColumnVarNameInTable="columnparent_id" msprop:Generator_ColumnPropNameInTable="parent_idColumn" type="xs:int" minOccurs="0" /> + <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="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> + <xs:element name="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="25" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnPropNameInTable="timeColumn" minOccurs="0"> + <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInTable="timeColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="25" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="featureNumber" msprop:Generator_UserColumnName="featureNumber" msprop:Generator_ColumnVarNameInTable="columnfeatureNumber" msprop:Generator_ColumnPropNameInRow="featureNumber" msprop:Generator_ColumnPropNameInTable="featureNumberColumn" minOccurs="0"> + <xs:element name="featureNumber" msprop:Generator_UserColumnName="featureNumber" msprop:Generator_ColumnPropNameInRow="featureNumber" msprop:Generator_ColumnVarNameInTable="columnfeatureNumber" msprop:Generator_ColumnPropNameInTable="featureNumberColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="productID" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="productID" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Objective" msprop:Generator_UserTableName="Objective" msprop:Generator_RowDeletedName="ObjectiveRowDeleted" msprop:Generator_RowChangedName="ObjectiveRowChanged" msprop:Generator_RowClassName="ObjectiveRow" msprop:Generator_RowChangingName="ObjectiveRowChanging" msprop:Generator_RowEvArgName="ObjectiveRowChangeEvent" msprop:Generator_RowEvHandlerName="ObjectiveRowChangeEventHandler" msprop:Generator_TableClassName="ObjectiveDataTable" msprop:Generator_TableVarName="tableObjective" msprop:Generator_RowDeletingName="ObjectiveRowDeleting" msprop:Generator_TablePropName="Objective"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" 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="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" 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="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> + <xs:element name="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="25" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="feature" msprop:Generator_UserColumnName="feature" msprop:Generator_ColumnVarNameInTable="columnfeature" msprop:Generator_ColumnPropNameInRow="feature" msprop:Generator_ColumnPropNameInTable="featureColumn" type="xs:int" /> - <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnPropNameInTable="timeColumn" type="xs:dateTime" /> + <xs:element name="feature" msprop:Generator_UserColumnName="feature" msprop:Generator_ColumnPropNameInRow="feature" msprop:Generator_ColumnVarNameInTable="columnfeature" msprop:Generator_ColumnPropNameInTable="featureColumn" type="xs:int" /> + <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInTable="timeColumn" type="xs:dateTime" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="TestCase" msprop:Generator_UserTableName="TestCase" msprop:Generator_RowDeletedName="TestCaseRowDeleted" msprop:Generator_RowChangedName="TestCaseRowChanged" msprop:Generator_RowClassName="TestCaseRow" msprop:Generator_RowChangingName="TestCaseRowChanging" msprop:Generator_RowEvArgName="TestCaseRowChangeEvent" msprop:Generator_RowEvHandlerName="TestCaseRowChangeEventHandler" msprop:Generator_TableClassName="TestCaseDataTable" msprop:Generator_TableVarName="tableTestCase" msprop:Generator_RowDeletingName="TestCaseRowDeleting" msprop:Generator_TablePropName="TestCase"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" 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="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" 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="steps" msprop:Generator_UserColumnName="steps" msprop:Generator_ColumnVarNameInTable="columnsteps" msprop:Generator_ColumnPropNameInRow="steps" msprop:Generator_ColumnPropNameInTable="stepsColumn" minOccurs="0"> + <xs:element name="steps" msprop:Generator_UserColumnName="steps" msprop:Generator_ColumnPropNameInRow="steps" msprop:Generator_ColumnVarNameInTable="columnsteps" msprop:Generator_ColumnPropNameInTable="stepsColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="number" msprop:Generator_UserColumnName="number" msprop:Generator_ColumnVarNameInTable="columnnumber" msprop:Generator_ColumnPropNameInRow="number" msprop:Generator_ColumnPropNameInTable="numberColumn" type="xs:int" minOccurs="0" /> - <xs:element name="createdby" msprop:Generator_UserColumnName="createdby" msprop:Generator_ColumnVarNameInTable="columncreatedby" msprop:Generator_ColumnPropNameInRow="createdby" msprop:Generator_ColumnPropNameInTable="createdbyColumn" type="xs:int" minOccurs="0" /> - <xs:element name="editedby" msprop:Generator_UserColumnName="editedby" msprop:Generator_ColumnVarNameInTable="columneditedby" msprop:Generator_ColumnPropNameInRow="editedby" msprop:Generator_ColumnPropNameInTable="editedbyColumn" type="xs:int" minOccurs="0" /> - <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="dateEdited" msprop:Generator_UserColumnName="dateEdited" msprop:Generator_ColumnVarNameInTable="columndateEdited" msprop:Generator_ColumnPropNameInRow="dateEdited" msprop:Generator_ColumnPropNameInTable="dateEditedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="objectiveID" msprop:Generator_UserColumnName="objectiveID" msprop:Generator_ColumnVarNameInTable="columnobjectiveID" msprop:Generator_ColumnPropNameInRow="objectiveID" msprop:Generator_ColumnPropNameInTable="objectiveIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="statusID" msprop:Generator_UserColumnName="statusID" msprop:Generator_ColumnVarNameInTable="columnstatusID" msprop:Generator_ColumnPropNameInRow="statusID" msprop:Generator_ColumnPropNameInTable="statusIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="number" msprop:Generator_UserColumnName="number" msprop:Generator_ColumnPropNameInRow="number" msprop:Generator_ColumnVarNameInTable="columnnumber" msprop:Generator_ColumnPropNameInTable="numberColumn" type="xs:int" minOccurs="0" /> + <xs:element name="createdby" msprop:Generator_UserColumnName="createdby" msprop:Generator_ColumnPropNameInRow="createdby" msprop:Generator_ColumnVarNameInTable="columncreatedby" msprop:Generator_ColumnPropNameInTable="createdbyColumn" type="xs:int" minOccurs="0" /> + <xs:element name="editedby" msprop:Generator_UserColumnName="editedby" msprop:Generator_ColumnPropNameInRow="editedby" msprop:Generator_ColumnVarNameInTable="columneditedby" msprop:Generator_ColumnPropNameInTable="editedbyColumn" type="xs:int" minOccurs="0" /> + <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="dateEdited" msprop:Generator_UserColumnName="dateEdited" msprop:Generator_ColumnPropNameInRow="dateEdited" msprop:Generator_ColumnVarNameInTable="columndateEdited" msprop:Generator_ColumnPropNameInTable="dateEditedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="objectiveID" msprop:Generator_UserColumnName="objectiveID" msprop:Generator_ColumnPropNameInRow="objectiveID" msprop:Generator_ColumnVarNameInTable="columnobjectiveID" msprop:Generator_ColumnPropNameInTable="objectiveIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="statusID" msprop:Generator_UserColumnName="statusID" msprop:Generator_ColumnPropNameInRow="statusID" msprop:Generator_ColumnVarNameInTable="columnstatusID" msprop:Generator_ColumnPropNameInTable="statusIDColumn" type="xs:int" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Tags" msprop:Generator_UserTableName="Tags" msprop:Generator_RowDeletedName="TagsRowDeleted" msprop:Generator_RowChangedName="TagsRowChanged" msprop:Generator_RowClassName="TagsRow" msprop:Generator_RowChangingName="TagsRowChanging" msprop:Generator_RowEvArgName="TagsRowChangeEvent" msprop:Generator_RowEvHandlerName="TagsRowChangeEventHandler" msprop:Generator_TableClassName="TagsDataTable" msprop:Generator_TableVarName="tableTags" msprop:Generator_RowDeletingName="TagsRowDeleting" msprop:Generator_TablePropName="Tags"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" 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="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" 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="50" /> </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="255" /> @@ -1247,27 +1284,27 @@ <xs:element name="Products" msprop:Generator_UserTableName="Products" msprop:Generator_RowDeletedName="ProductsRowDeleted" msprop:Generator_RowChangedName="ProductsRowChanged" msprop:Generator_RowClassName="ProductsRow" msprop:Generator_RowChangingName="ProductsRowChanging" msprop:Generator_RowEvArgName="ProductsRowChangeEvent" msprop:Generator_RowEvHandlerName="ProductsRowChangeEventHandler" msprop:Generator_TableClassName="ProductsDataTable" msprop:Generator_TableVarName="tableProducts" msprop:Generator_RowDeletingName="ProductsRowDeleting" msprop:Generator_TablePropName="Products"> <xs:complexType> <xs:sequence> - <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" 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="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" 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="50" /> </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="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="ProductManager" msprop:Generator_UserColumnName="ProductManager" msprop:Generator_ColumnPropNameInRow="ProductManager" msprop:Generator_ColumnVarNameInTable="columnProductManager" msprop:Generator_ColumnPropNameInTable="ProductManagerColumn" type="xs:int" minOccurs="0" /> - <xs:element name="Code" msprop:Generator_UserColumnName="Code" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInTable="CodeColumn" minOccurs="0"> + <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="ProductManager" msprop:Generator_UserColumnName="ProductManager" msprop:Generator_ColumnVarNameInTable="columnProductManager" msprop:Generator_ColumnPropNameInRow="ProductManager" msprop:Generator_ColumnPropNameInTable="ProductManagerColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Code" msprop:Generator_UserColumnName="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnPropNameInTable="CodeColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> @@ -1280,72 +1317,72 @@ <xs:element name="Users" msprop:Generator_UserTableName="Users" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowClassName="UsersRow" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_TablePropName="Users"> <xs:complexType> <xs:sequence> - <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInTable="emailColumn" minOccurs="0"> + <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" minOccurs="0"> <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_ColumnPropNameInRow="officePhone" msprop:Generator_ColumnVarNameInTable="columnofficePhone" msprop:Generator_ColumnPropNameInTable="officePhoneColumn" minOccurs="0"> + <xs:element name="officePhone" msprop:Generator_UserColumnName="officePhone" msprop:Generator_ColumnVarNameInTable="columnofficePhone" msprop:Generator_ColumnPropNameInRow="officePhone" msprop:Generator_ColumnPropNameInTable="officePhoneColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="15" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="homePhone" msprop:Generator_UserColumnName="homePhone" msprop:Generator_ColumnPropNameInRow="homePhone" msprop:Generator_ColumnVarNameInTable="columnhomePhone" msprop:Generator_ColumnPropNameInTable="homePhoneColumn" minOccurs="0"> + <xs:element name="homePhone" msprop:Generator_UserColumnName="homePhone" msprop:Generator_ColumnVarNameInTable="columnhomePhone" msprop:Generator_ColumnPropNameInRow="homePhone" msprop:Generator_ColumnPropNameInTable="homePhoneColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="15" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="cellPhone" msprop:Generator_UserColumnName="cellPhone" msprop:Generator_ColumnPropNameInRow="cellPhone" msprop:Generator_ColumnVarNameInTable="columncellPhone" msprop:Generator_ColumnPropNameInTable="cellPhoneColumn" minOccurs="0"> + <xs:element name="cellPhone" msprop:Generator_UserColumnName="cellPhone" msprop:Generator_ColumnVarNameInTable="columncellPhone" msprop:Generator_ColumnPropNameInRow="cellPhone" msprop:Generator_ColumnPropNameInTable="cellPhoneColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="15" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="firstName" msprop:Generator_UserColumnName="firstName" msprop:Generator_ColumnPropNameInRow="firstName" msprop:Generator_ColumnVarNameInTable="columnfirstName" msprop:Generator_ColumnPropNameInTable="firstNameColumn" minOccurs="0"> + <xs:element name="firstName" msprop:Generator_UserColumnName="firstName" msprop:Generator_ColumnVarNameInTable="columnfirstName" msprop:Generator_ColumnPropNameInRow="firstName" msprop:Generator_ColumnPropNameInTable="firstNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="lastName" msprop:Generator_UserColumnName="lastName" msprop:Generator_ColumnPropNameInRow="lastName" msprop:Generator_ColumnVarNameInTable="columnlastName" msprop:Generator_ColumnPropNameInTable="lastNameColumn" minOccurs="0"> + <xs:element name="lastName" msprop:Generator_UserColumnName="lastName" msprop:Generator_ColumnVarNameInTable="columnlastName" msprop:Generator_ColumnPropNameInRow="lastName" msprop:Generator_ColumnPropNameInTable="lastNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="automation" msprop:Generator_UserColumnName="automation" msprop:Generator_ColumnPropNameInRow="automation" msprop:Generator_ColumnVarNameInTable="columnautomation" msprop:Generator_ColumnPropNameInTable="automationColumn" type="xs:boolean" minOccurs="0" /> + <xs:element name="automation" msprop:Generator_UserColumnName="automation" msprop:Generator_ColumnVarNameInTable="columnautomation" msprop:Generator_ColumnPropNameInRow="automation" msprop:Generator_ColumnPropNameInTable="automationColumn" type="xs:boolean" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Status" msprop:Generator_UserTableName="Status" msprop:Generator_RowDeletedName="StatusRowDeleted" msprop:Generator_RowChangedName="StatusRowChanged" msprop:Generator_RowClassName="StatusRow" msprop:Generator_RowChangingName="StatusRowChanging" msprop:Generator_RowEvArgName="StatusRowChangeEvent" msprop:Generator_RowEvHandlerName="StatusRowChangeEventHandler" msprop:Generator_TableClassName="StatusDataTable" msprop:Generator_TableVarName="tableStatus" msprop:Generator_RowDeletingName="StatusRowDeleting" msprop:Generator_TablePropName="Status"> <xs:complexType> <xs:sequence> - <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="stateName" msprop:Generator_UserColumnName="stateName" msprop:Generator_ColumnVarNameInTable="columnstateName" msprop:Generator_ColumnPropNameInRow="stateName" msprop:Generator_ColumnPropNameInTable="stateNameColumn" minOccurs="0"> + <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="stateName" msprop:Generator_UserColumnName="stateName" msprop:Generator_ColumnPropNameInRow="stateName" msprop:Generator_ColumnVarNameInTable="columnstateName" msprop:Generator_ColumnPropNameInTable="stateNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </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="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="groupName" msprop:Generator_UserColumnName="groupName" msprop:Generator_ColumnVarNameInTable="columngroupName" msprop:Generator_ColumnPropNameInRow="groupName" msprop:Generator_ColumnPropNameInTable="groupNameColumn" minOccurs="0"> + <xs:element name="groupName" msprop:Generator_UserColumnName="groupName" msprop:Generator_ColumnPropNameInRow="groupName" msprop:Generator_ColumnVarNameInTable="columngroupName" msprop:Generator_ColumnPropNameInTable="groupNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="20" /> @@ -1358,132 +1395,132 @@ <xs:element name="testCaseTags" msprop:Generator_UserTableName="testCaseTags" msprop:Generator_RowDeletedName="testCaseTagsRowDeleted" msprop:Generator_RowChangedName="testCaseTagsRowChanged" msprop:Generator_RowClassName="testCaseTagsRow" msprop:Generator_RowChangingName="testCaseTagsRowChanging" msprop:Generator_RowEvArgName="testCaseTagsRowChangeEvent" msprop:Generator_RowEvHandlerName="testCaseTagsRowChangeEventHandler" msprop:Generator_TableClassName="testCaseTagsDataTable" msprop:Generator_TableVarName="tabletestCaseTags" msprop:Generator_RowDeletingName="testCaseTagsRowDeleting" msprop:Generator_TablePropName="testCaseTags"> <xs:complexType> <xs:sequence> - <xs:element name="testCaseTagsID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="testCaseTagsID" msprop:Generator_ColumnPropNameInRow="testCaseTagsID" msprop:Generator_ColumnVarNameInTable="columntestCaseTagsID" msprop:Generator_ColumnPropNameInTable="testCaseTagsIDColumn" type="xs:int" /> - <xs:element name="testCaseID" msprop:Generator_UserColumnName="testCaseID" msprop:Generator_ColumnPropNameInRow="testCaseID" msprop:Generator_ColumnVarNameInTable="columntestCaseID" msprop:Generator_ColumnPropNameInTable="testCaseIDColumn" type="xs:int" /> - <xs:element name="tagID" msprop:Generator_UserColumnName="tagID" msprop:Generator_ColumnPropNameInRow="tagID" msprop:Generator_ColumnVarNameInTable="columntagID" msprop:Generator_ColumnPropNameInTable="tagIDColumn" type="xs:int" /> + <xs:element name="testCaseTagsID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="testCaseTagsID" msprop:Generator_ColumnVarNameInTable="columntestCaseTagsID" msprop:Generator_ColumnPropNameInRow="testCaseTagsID" msprop:Generator_ColumnPropNameInTable="testCaseTagsIDColumn" type="xs:int" /> + <xs:element name="testCaseID" msprop:Generator_UserColumnName="testCaseID" msprop:Generator_ColumnVarNameInTable="columntestCaseID" msprop:Generator_ColumnPropNameInRow="testCaseID" msprop:Generator_ColumnPropNameInTable="testCaseIDColumn" type="xs:int" /> + <xs:element name="tagID" msprop:Generator_UserColumnName="tagID" msprop:Generator_ColumnVarNameInTable="columntagID" msprop:Generator_ColumnPropNameInRow="tagID" msprop:Generator_ColumnPropNameInTable="tagIDColumn" type="xs:int" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="version" msprop:Generator_UserTableName="version" msprop:Generator_RowDeletedName="versionRowDeleted" msprop:Generator_RowChangedName="versionRowChanged" msprop:Generator_RowClassName="versionRow" msprop:Generator_RowChangingName="versionRowChanging" msprop:Generator_RowEvArgName="versionRowChangeEvent" msprop:Generator_RowEvHandlerName="versionRowChangeEventHandler" msprop:Generator_TableClassName="versionDataTable" msprop:Generator_TableVarName="tableversion" msprop:Generator_RowDeletingName="versionRowDeleting" msprop:Generator_TablePropName="version"> <xs:complexType> <xs:sequence> - <xs:element name="versionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="versionID" msprop:Generator_ColumnPropNameInRow="versionID" msprop:Generator_ColumnVarNameInTable="columnversionID" msprop:Generator_ColumnPropNameInTable="versionIDColumn" type="xs:int" /> - <xs:element name="productID" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" /> - <xs:element name="number" msprop:Generator_UserColumnName="number" msprop:Generator_ColumnPropNameInRow="number" msprop:Generator_ColumnVarNameInTable="columnnumber" msprop:Generator_ColumnPropNameInTable="numberColumn"> + <xs:element name="versionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="versionID" msprop:Generator_ColumnVarNameInTable="columnversionID" msprop:Generator_ColumnPropNameInRow="versionID" msprop:Generator_ColumnPropNameInTable="versionIDColumn" type="xs:int" /> + <xs:element name="productID" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" /> + <xs:element name="number" msprop:Generator_UserColumnName="number" msprop:Generator_ColumnVarNameInTable="columnnumber" msprop:Generator_ColumnPropNameInRow="number" msprop:Generator_ColumnPropNameInTable="numberColumn"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="dateCreated" msprop:Generator_UserColumnName="dateCreated" msprop:Generator_ColumnPropNameInRow="dateCreated" msprop:Generator_ColumnVarNameInTable="columndateCreated" msprop:Generator_ColumnPropNameInTable="dateCreatedColumn" type="xs:dateTime" /> - <xs:element name="active" msprop:Generator_UserColumnName="active" msprop:Generator_ColumnPropNameInRow="active" msprop:Generator_ColumnVarNameInTable="columnactive" msprop:Generator_ColumnPropNameInTable="activeColumn" type="xs:boolean" /> + <xs:element name="dateCreated" msprop:Generator_UserColumnName="dateCreated" msprop:Generator_ColumnVarNameInTable="columndateCreated" msprop:Generator_ColumnPropNameInRow="dateCreated" msprop:Generator_ColumnPropNameInTable="dateCreatedColumn" type="xs:dateTime" /> + <xs:element name="active" msprop:Generator_UserColumnName="active" msprop:Generator_ColumnVarNameInTable="columnactive" msprop:Generator_ColumnPropNameInRow="active" msprop:Generator_ColumnPropNameInTable="activeColumn" type="xs:boolean" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="versionTestCase" msprop:Generator_UserTableName="versionTestCase" msprop:Generator_RowDeletedName="versionTestCaseRowDeleted" msprop:Generator_RowChangedName="versionTestCaseRowChanged" msprop:Generator_RowClassName="versionTestCaseRow" msprop:Generator_RowChangingName="versionTestCaseRowChanging" msprop:Generator_RowEvArgName="versionTestCaseRowChangeEvent" msprop:Generator_RowEvHandlerName="versionTestCaseRowChangeEventHandler" msprop:Generator_TableClassName="versionTestCaseDataTable" msprop:Generator_TableVarName="tableversionTestCase" msprop:Generator_RowDeletingName="versionTestCaseRowDeleting" msprop:Generator_TablePropName="versionTestCase"> <xs:complexType> <xs:sequence> - <xs:element name="versionTestCaseID" msprop:Generator_UserColumnName="versionTestCaseID" msprop:Generator_ColumnPropNameInRow="versionTestCaseID" msprop:Generator_ColumnVarNameInTable="columnversionTestCaseID" msprop:Generator_ColumnPropNameInTable="versionTestCaseIDColumn" type="xs:int" /> - <xs:element name="testCaseID" msprop:Generator_UserColumnName="testCaseID" msprop:Generator_ColumnPropNameInRow="testCaseID" msprop:Generator_ColumnVarNameInTable="columntestCaseID" msprop:Generator_ColumnPropNameInTable="testCaseIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="versionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="versionID" msprop:Generator_ColumnPropNameInRow="versionID" msprop:Generator_ColumnVarNameInTable="columnversionID" msprop:Generator_ColumnPropNameInTable="versionIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="versionTestCaseID" msprop:Generator_UserColumnName="versionTestCaseID" msprop:Generator_ColumnVarNameInTable="columnversionTestCaseID" msprop:Generator_ColumnPropNameInRow="versionTestCaseID" msprop:Generator_ColumnPropNameInTable="versionTestCaseIDColumn" type="xs:int" /> + <xs:element name="testCaseID" msprop:Generator_UserColumnName="testCaseID" msprop:Generator_ColumnVarNameInTable="columntestCaseID" msprop:Generator_ColumnPropNameInRow="testCaseID" msprop:Generator_ColumnPropNameInTable="testCaseIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="versionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="versionID" msprop:Generator_ColumnVarNameInTable="columnversionID" msprop:Generator_ColumnPropNameInRow="versionID" msprop:Generator_ColumnPropNameInTable="versionIDColumn" type="xs:int" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="featureVersion" msprop:Generator_UserTableName="featureVersion" msprop:Generator_RowDeletedName="featureVersionRowDeleted" msprop:Generator_RowChangedName="featureVersionRowChanged" msprop:Generator_RowClassName="featureVersionRow" msprop:Generator_RowChangingName="featureVersionRowChanging" msprop:Generator_RowEvArgName="featureVersionRowChangeEvent" msprop:Generator_RowEvHandlerName="featureVersionRowChangeEventHandler" msprop:Generator_TableClassName="featureVersionDataTable" msprop:Generator_TableVarName="tablefeatureVersion" msprop:Generator_RowDeletingName="featureVersionRowDeleting" msprop:Generator_TablePropName="featureVersion"> <xs:complexType> <xs:sequence> - <xs:element name="featureVersionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="featureVersionID" msprop:Generator_ColumnPropNameInRow="featureVersionID" msprop:Generator_ColumnVarNameInTable="columnfeatureVersionID" msprop:Generator_ColumnPropNameInTable="featureVersionIDColumn" type="xs:int" /> - <xs:element name="featureID" msprop:Generator_UserColumnName="featureID" msprop:Generator_ColumnPropNameInRow="featureID" msprop:Generator_ColumnVarNameInTable="columnfeatureID" msprop:Generator_ColumnPropNameInTable="featureIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="versionID" msprop:Generator_UserColumnName="versionID" msprop:Generator_ColumnPropNameInRow="versionID" msprop:Generator_ColumnVarNameInTable="columnversionID" msprop:Generator_ColumnPropNameInTable="versionIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="featureVersionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="featureVersionID" msprop:Generator_ColumnVarNameInTable="columnfeatureVersionID" msprop:Generator_ColumnPropNameInRow="featureVersionID" msprop:Generator_ColumnPropNameInTable="featureVersionIDColumn" type="xs:int" /> + <xs:element name="featureID" msprop:Generator_UserColumnName="featureID" msprop:Generator_ColumnVarNameInTable="col... [truncated message content] |
