Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [37] WebPrototype
|
From: <ro...@us...> - 2006-06-16 00:29:50
|
Revision: 37 Author: rouquin Date: 2006-06-15 17:29:32 -0700 (Thu, 15 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=37&view=rev Log Message: ----------- Enabled version and tag lists to be used on features and testcases. Also made other minor updates to pages using things I've learned along the way. Modified Paths: -------------- WebPrototype/ActionItemEdit.aspx 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/FeatureEdit.aspx WebPrototype/FeatureEdit.aspx.cs WebPrototype/ObjectiveEdit.aspx.cs WebPrototype/ProductEdit.aspx.cs WebPrototype/TestCaseEdit.aspx WebPrototype/TestCaseEdit.aspx.cs WebPrototype/TestManagement.aspx.cs WebPrototype/WorkOrder.aspx Modified: WebPrototype/ActionItemEdit.aspx =================================================================== --- WebPrototype/ActionItemEdit.aspx 2006-06-15 22:58:56 UTC (rev 36) +++ WebPrototype/ActionItemEdit.aspx 2006-06-16 00:29:32 UTC (rev 37) @@ -22,9 +22,10 @@ <table> <tr> <td colspan="2" style="width: 239px; height: 11px;"> - Name: <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width="100%" /></td> + <strong> Name: </strong> + <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width="100%" /></td> <td align=right colspan=2 style="height: 11px"> - Due Date: + <strong> Due Date: </strong> <cc1:DatePicker ID="DatePicker1" runat="server" @@ -39,7 +40,7 @@ </tr> <tr> <td colspan="4" style="height: 197px"> - Description:<br /> + <strong>Description:</strong><br /> <FTB:FreeTextBox ID="FreeTextBox1" runat="server" SupportFolder="~" Text='<%# Bind("description") %>' Height="100%" Width="100%" /> </td> @@ -53,16 +54,16 @@ <td colspan=1 style="height: 23px; width: 239px;"> <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update"> - </asp:LinkButton> + </asp:LinkButton> | <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"> </asp:LinkButton> </td> <td align=right colspan=1 style="width: 576px; height: 23px"> - Assigned To: + <strong>Assigned To:</strong> <asp:TextBox ID="ownerTextBox" runat="server" Text='<%# Bind("owner") %>'></asp:TextBox> </td> <td colspan=1 style="width: 576px; height: 23px" align=right> - Assigned By:<asp:TextBox ID="userIDTextBox" runat="server" Text='<%# Bind("userID") %>'></asp:TextBox></td> + <strong>Assigned By:</strong><asp:TextBox ID="userIDTextBox" runat="server" Text='<%# Bind("userID") %>'></asp:TextBox></td> </tr> </table> </div> @@ -82,7 +83,7 @@ color: black; font-family: Arial;"></asp:Label> </td> <td align=right colspan=2 style="height: 19px; width: 179px;"> - Due Date: + <strong>Due Date:</strong> <asp:Label ID="dateStampLabel" runat="server" Text='<%# Eval("dateStamp") %>'></asp:Label></td> </tr> <tr> @@ -92,6 +93,7 @@ </tr> <tr> <td colspan=5 style="height: 197px" valign=top> + <strong>Description:</strong><br /> <asp:Label ID="descriptionLabel" runat="server" Text='<%# Eval("description") %>'></asp:Label> </td> </tr> @@ -105,20 +107,22 @@ <br /> <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"> - </asp:LinkButton>| + </asp:LinkButton> + | <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New"> - </asp:LinkButton>| + </asp:LinkButton> + | <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete"> - </asp:LinkButton>| </td> + </asp:LinkButton></td> <td align=right colspan=1 style="width: 25%; height: 16px"> </td> <td align=right colspan=1 style="width: 25%; height: 16px"> - Assigned To: + <strong>Assigned To:</strong> <asp:Label ID="Label1" runat="server" Text='<%# Eval("owner") %>'></asp:Label></td> <td colspan=1 style="width: 25%; height: 16px" align=right> - Assigned By:<asp:Label ID="userIDLabel" runat="server" Text='<%# Eval("userID") %>'></asp:Label></td> + <strong>Assigned By:</strong><asp:Label ID="userIDLabel" runat="server" Text='<%# Eval("userID") %>'></asp:Label></td> </tr> </table> </div> @@ -163,12 +167,10 @@ <div class="xboxcontent"> <table> <tr> - <td colspan="2" style="width: 239px; height: 11px;"> - Name:<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width="100%" /></td> - <td align=right colspan=1 style="width: 576px; height: 11px"> - </td> + <td align=left colspan=3 style="height: 11px"> + <strong> Name:</strong><asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width="80%" /></td> <td colspan="1" style="width: 576px; height: 11px;" align="right"> - Due Date:<cc1:DatePicker ID="DatePicker2" runat="server" /> + <strong> Due Date:</strong><cc1:DatePicker ID="DatePicker2" runat="server" /> </td> </tr> @@ -184,24 +186,24 @@ </td> </tr> <tr> - <td colspan="4" class="hr"> + <td colspan="4" class="hr" style="height: 1px"> <img alt="" src="images/spacer.gif" height="5" /><br /> </td> </tr> <tr> - <td colspan=1 style="height: 23px; width: 239px;"> + <td colspan=2 style="height: 23px; width: 239px;"> <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert"> - </asp:LinkButton> + </asp:LinkButton> | <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"> </asp:LinkButton> </td> <td align=right colspan=1 style="width: 576px; height: 23px"> - Assigned To: + <strong>Assigned To:</strong> <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("owner", "{0}") %>'></asp:TextBox> </td> <td colspan=1 style="width: 576px; height: 23px" align=right> - Assigned By: + <strong>Assigned By:</strong> <asp:TextBox ID="TextBoxuserID" runat="server" Text='<%# Bind("userID") %>'></asp:TextBox></td> </tr> </table> Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-15 22:58:56 UTC (rev 36) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-06-16 00:29:32 UTC (rev 37) @@ -69,41 +69,9 @@ <Sources> </Sources> </TableAdapter> - <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkOrderTableAdapter" GeneratorDataComponentClassName="WorkOrderTableAdapter" Name="WorkOrder" UserDataComponentName="WorkOrderTableAdapter"> - <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetDummyWorkOrderData" GetMethodModifier="Public" GetMethodName="GetDummyWorkOrderData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyWorkOrderData" UserSourceName="GetDummyWorkOrderData"> - <SelectCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT WorkOrder.id, WorkOrder.name AS WoName, WorkOrder.platform, WorkOrder.created, WorkOrder.finished, WorkOrder.userid, TestCase.name, - RTRIM(TestCase.Status) AS Status, TestCase.steps -FROM WorkOrder INNER JOIN - TestCase ON WorkOrder.id = TestCase.workorder -WHERE (WorkOrder.id = @id)</CommandText> - <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="id" ColumnName="id" DataSourceName="[D:\MATTHEW\WORK\VINTELA\TCDB 2006\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.WorkOrder" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - </Parameters> - </DbCommand> - </SelectCommand> - </DbSource> - </MainSource> - <Mappings> - <Mapping SourceColumn="id" DataSetColumn="id" /> - <Mapping SourceColumn="name" DataSetColumn="name" /> - <Mapping SourceColumn="platform" DataSetColumn="platform" /> - <Mapping SourceColumn="created" DataSetColumn="created" /> - <Mapping SourceColumn="finished" DataSetColumn="finished" /> - <Mapping SourceColumn="userid" DataSetColumn="userid" /> - <Mapping SourceColumn="WoName" DataSetColumn="WoName" /> - <Mapping SourceColumn="Status" DataSetColumn="Status" /> - <Mapping SourceColumn="steps" DataSetColumn="steps" /> - </Mappings> - <Sources> - </Sources> - </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ActionItemsTableAdapter" GeneratorDataComponentClassName="ActionItemsTableAdapter" Name="ActionItems" UserDataComponentName="ActionItemsTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.ActionItems" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetDummyActionItemData" GetMethodModifier="Public" GetMethodName="GetDummyActionItemData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyActionItemData" UserSourceName="FillDummyActionItemData"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.ActionItems" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetDummyActionItemData" GetMethodModifier="Public" GetMethodName="GetDummyActionItemData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyActionItemData" UserSourceName="GetDummyActionItemData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT id, name, description, userID, dateStamp, percentFinished, state, owner @@ -412,7 +380,7 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ObjectiveTableAdapter" GeneratorDataComponentClassName="ObjectiveTableAdapter" Name="Objective" UserDataComponentName="ObjectiveTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Objective" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllObjectiveData" GetMethodModifier="Public" GetMethodName="GetAllObjectiveData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllObjectiveData" UserSourceName="GetDummyObjectiveData"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Objective" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllObjectiveData" GetMethodModifier="Public" GetMethodName="GetAllObjectiveData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllObjectiveData" UserSourceName="GetAllObjectiveData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT id, feature, name, description, [user], time @@ -444,7 +412,7 @@ </DbCommand> </DeleteCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Objective" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetObjectiveDataByID" GetMethodModifier="Public" GetMethodName="GetObjectiveDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetObjectiveDataByID" UserSourceName="FillBy"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Objective" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetObjectiveDataByID" GetMethodModifier="Public" GetMethodName="GetObjectiveDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetObjectiveDataByID" UserSourceName="GetObjectiveDataByID1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT id, feature, name, description, [user], time @@ -542,7 +510,7 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TestCaseTableAdapter" GeneratorDataComponentClassName="TestCaseTableAdapter" Name="TestCase" UserDataComponentName="TestCaseTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.TestCase" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetTestCaseDataByID" GetMethodModifier="Public" GetMethodName="GetTestCaseDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetTestCaseDataByID" UserSourceName="GetDummyTestCaseData"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.TestCase" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetTestCaseDataByID" GetMethodModifier="Public" GetMethodName="GetTestCaseDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetTestCaseDataByID" UserSourceName="GetTestCaseDataByID"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT id, name, number, steps, createdby, editedby, dateCreated, dateEdited, objectiveID, statusID @@ -569,7 +537,7 @@ <Mapping SourceColumn="statusID" DataSetColumn="statusID" /> </Mappings> <Sources> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="DeleteByID" Modifier="Public" Name="DeleteByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="DeleteByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="DeleteByID" Modifier="Public" Name="DeleteByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="DeleteByID"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>DELETE FROM TestCase WHERE id=@original_id</CommandText> @@ -580,7 +548,7 @@ </DbCommand> </DeleteCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertTestCase" Modifier="Public" Name="InsertTestCase" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy4" UserSourceName="InsertTestCase"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertTestCase" Modifier="Public" Name="InsertTestCase" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="InsertTestCase"> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>INSERT INTO TestCase @@ -597,7 +565,7 @@ </DbCommand> </InsertCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="UpdateSpecial" Modifier="Public" Name="UpdateSpecial" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="UpdateSpecial"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="UpdateSpecial" Modifier="Public" Name="UpdateSpecial" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="UpdateSpecial"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE TestCase @@ -623,7 +591,7 @@ </DbCommand> </UpdateCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateSpecialByID" Modifier="Public" Name="UpdateSpecialByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="UpdateSpecialByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateSpecialByID" Modifier="Public" Name="UpdateSpecialByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="UpdateSpecialByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE TestCase @@ -649,7 +617,7 @@ </DbCommand> </UpdateCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateTestCaseByID" Modifier="Public" Name="UpdateTestCaseByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="UpdateTestCaseByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateTestCaseByID" Modifier="Public" Name="UpdateTestCaseByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy4" UserSourceName="UpdateTestCaseByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE TestCase @@ -672,7 +640,7 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TagsTableAdapter" GeneratorDataComponentClassName="TagsTableAdapter" Name="Tags" UserDataComponentName="TagsTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Tags" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllTagData" GetMethodModifier="Public" GetMethodName="GetAllTagData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllTagData" UserSourceName="GetDummyTagData"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Tags" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllTagData" GetMethodModifier="Public" GetMethodName="GetAllTagData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllTagData" UserSourceName="GetAllTagData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT id, name, description @@ -731,7 +699,7 @@ </DbCommand> </DeleteCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Products" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAllProducts" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetAllProducts" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAllProducts" UserSourceName="FillBy"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Products" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAllProducts" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetAllProducts" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAllProducts" UserSourceName="GetAllProducts1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT id, Name, Description, DevManager, QAManager, DevLead, QALead, ProductManager, Code @@ -862,7 +830,7 @@ <Mapping SourceColumn="automation" DataSetColumn="automation" /> </Mappings> <Sources> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Users" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetUserNames" GetMethodModifier="Public" GetMethodName="GetUserNames" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetUserNames" UserSourceName="FillBy"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Users" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetUserNames" GetMethodModifier="Public" GetMethodName="GetUserNames" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetUserNames" UserSourceName="GetUserNames1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT id, firstName + ' ' + lastName AS Name @@ -876,7 +844,7 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StatusTableAdapter" GeneratorDataComponentClassName="StatusTableAdapter" Name="Status" UserDataComponentName="StatusTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Status" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetStatusDataByGroup" GetMethodModifier="Public" GetMethodName="GetStatusDataByGroup" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetStatusDataByGroup" UserSourceName="Fill"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Status" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetStatusDataByGroup" GetMethodModifier="Public" GetMethodName="GetStatusDataByGroup" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetStatusDataByGroup" UserSourceName="GetStatusDataByGroup"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT id, stateName, description, groupName @@ -916,6 +884,122 @@ </DbSource> </Sources> </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkOrderTableAdapter" GeneratorDataComponentClassName="WorkOrderTableAdapter" Name="WorkOrder" UserDataComponentName="WorkOrderTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.WorkOrder" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllWorkOrderData" GetMethodModifier="Public" GetMethodName="GetAllWorkOrderData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllWorkOrderData" UserSourceName="Fill"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT WorkOrder.* +FROM WorkOrder</CommandText> + <Parameters> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="workOrderID" DataSetColumn="workOrderID" /> + <Mapping SourceColumn="name" DataSetColumn="name" /> + <Mapping SourceColumn="platformID" DataSetColumn="platformID" /> + <Mapping SourceColumn="dateCreated" DataSetColumn="dateCreated" /> + <Mapping SourceColumn="dateCompleted" DataSetColumn="dateCompleted" /> + <Mapping SourceColumn="creatorID" DataSetColumn="creatorID" /> + <Mapping SourceColumn="testPassID" DataSetColumn="testPassID" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="testCaseTagsTableAdapter" GeneratorDataComponentClassName="testCaseTagsTableAdapter" Name="testCaseTags" UserDataComponentName="testCaseTagsTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.testCaseTags" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetTestCaseTagData" GetMethodModifier="Public" GetMethodName="GetTestCaseTagData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetTestCaseTagData" UserSourceName="Fill"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT testCaseTags.* +FROM testCaseTags</CommandText> + <Parameters> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="testCaseTagsID" DataSetColumn="testCaseTagsID" /> + <Mapping SourceColumn="testCaseID" DataSetColumn="testCaseID" /> + <Mapping SourceColumn="tagID" DataSetColumn="tagID" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="versionTableAdapter" GeneratorDataComponentClassName="versionTableAdapter" Name="version" UserDataComponentName="versionTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.version" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllVersionData" GetMethodModifier="Public" GetMethodName="GetAllVersionData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllVersionData" UserSourceName="Fill"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT versionID, productID, number, dateCreated, active +FROM version +WHERE (active = 1)</CommandText> + <Parameters> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="versionID" DataSetColumn="versionID" /> + <Mapping SourceColumn="productID" DataSetColumn="productID" /> + <Mapping SourceColumn="number" DataSetColumn="number" /> + <Mapping SourceColumn="dateCreated" DataSetColumn="dateCreated" /> + <Mapping SourceColumn="active" DataSetColumn="active" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="versionTestCaseTableAdapter" GeneratorDataComponentClassName="versionTestCaseTableAdapter" Name="versionTestCase" UserDataComponentName="versionTestCaseTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.versionTestCase" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllVersionTestCaseData" GetMethodModifier="Public" GetMethodName="GetAllVersionTestCaseData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllVersionTestCaseData" UserSourceName="Fill"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT vtc.versionTestCaseID, vtc.testCaseID, vtc.versionID +FROM versionTestCase AS vtc INNER JOIN + version AS v ON vtc.versionID = v.versionID +WHERE (v.active = 1)</CommandText> + <Parameters> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="versionTestCaseID" DataSetColumn="versionTestCaseID" /> + <Mapping SourceColumn="testCaseID" DataSetColumn="testCaseID" /> + <Mapping SourceColumn="versionID" DataSetColumn="versionID" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="featureVersionTableAdapter" GeneratorDataComponentClassName="featureVersionTableAdapter" Name="featureVersion" UserDataComponentName="featureVersionTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.featureVersion" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllFeatureVersionData" GetMethodModifier="Public" GetMethodName="GetAllFeatureVersionData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllFeatureVersionData" UserSourceName="Fill"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT fv.featureVersionID, fv.featureID, fv.versionID +FROM featureVersion AS fv INNER JOIN + version AS v ON v.versionID = fv.versionID +WHERE (v.active = 1)</CommandText> + <Parameters> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="featureVersionID" DataSetColumn="featureVersionID" /> + <Mapping SourceColumn="featureID" DataSetColumn="featureID" /> + <Mapping SourceColumn="versionID" DataSetColumn="versionID" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> </Tables> <Sources> </Sources> @@ -928,36 +1012,36 @@ <xs:element name="Assignments" msprop:Generator_UserTableName="Assignments" msprop:Generator_RowDeletedName="AssignmentsRowDeleted" msprop:Generator_RowChangedName="AssignmentsRowChanged" msprop:Generator_RowClassName="AssignmentsRow" msprop:Generator_RowChangingName="AssignmentsRowChanging" msprop:Generator_RowEvArgName="AssignmentsRowChangeEvent" msprop:Generator_RowEvHandlerName="AssignmentsRowChangeEventHandler" msprop:Generator_TableClassName="AssignmentsDataTable" msprop:Generator_TableVarName="tableAssignments" msprop:Generator_RowDeletingName="AssignmentsRowDeleting" msprop:Generator_TablePropName="Assignments"> <xs:complexType> <xs:sequence> - <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnPropNameInTable="DateColumn" minOccurs="0"> + <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="Assignment" msprop:Generator_UserColumnName="Assignment" msprop:Generator_ColumnVarNameInTable="columnAssignment" msprop:Generator_ColumnPropNameInRow="Assignment" msprop:Generator_ColumnPropNameInTable="AssignmentColumn" minOccurs="0"> + <xs:element name="Assignment" msprop:Generator_UserColumnName="Assignment" msprop:Generator_ColumnPropNameInRow="Assignment" msprop:Generator_ColumnVarNameInTable="columnAssignment" msprop:Generator_ColumnPropNameInTable="AssignmentColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> + <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="20" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="_x0025__x0020_Complete" msprop:Generator_UserColumnName="% Complete" msprop:Generator_ColumnVarNameInTable="_column__Complete" msprop:Generator_ColumnPropNameInRow="___Complete" msprop:Generator_ColumnPropNameInTable="___CompleteColumn" type="xs:float" minOccurs="0" /> - <xs:element name="Total" msprop:Generator_UserColumnName="Total" msprop:Generator_ColumnVarNameInTable="columnTotal" msprop:Generator_ColumnPropNameInRow="Total" msprop:Generator_ColumnPropNameInTable="TotalColumn" type="xs:int" minOccurs="0" /> - <xs:element name="Pass_x0020_Rate" msprop:Generator_UserColumnName="Pass Rate" msprop:Generator_ColumnVarNameInTable="columnPass_Rate" msprop:Generator_ColumnPropNameInRow="Pass_Rate" msprop:Generator_ColumnPropNameInTable="Pass_RateColumn" type="xs:float" minOccurs="0" /> - <xs:element name="Pass" msprop:Generator_UserColumnName="Pass" msprop:Generator_ColumnVarNameInTable="columnPass" msprop:Generator_ColumnPropNameInRow="Pass" msprop:Generator_ColumnPropNameInTable="PassColumn" type="xs:int" minOccurs="0" /> - <xs:element name="Fail" msprop:Generator_UserColumnName="Fail" msprop:Generator_ColumnVarNameInTable="columnFail" msprop:Generator_ColumnPropNameInRow="Fail" msprop:Generator_ColumnPropNameInTable="FailColumn" type="xs:int" minOccurs="0" /> - <xs:element name="Error" msprop:Generator_UserColumnName="Error" msprop:Generator_ColumnVarNameInTable="columnError" msprop:Generator_ColumnPropNameInRow="Error" msprop:Generator_ColumnPropNameInTable="ErrorColumn" type="xs:int" 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="completed" msprop:Generator_UserColumnName="completed" msprop:Generator_ColumnPropNameInRow="completed" msprop:Generator_ColumnVarNameInTable="columncompleted" msprop:Generator_ColumnPropNameInTable="completedColumn" type="xs:boolean" minOccurs="0" /> - <xs:element name="Type" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0"> + <xs:element name="_x0025__x0020_Complete" msprop:Generator_UserColumnName="% Complete" msprop:Generator_ColumnPropNameInRow="___Complete" msprop:Generator_ColumnVarNameInTable="_column__Complete" msprop:Generator_ColumnPropNameInTable="___CompleteColumn" type="xs:float" minOccurs="0" /> + <xs:element name="Total" msprop:Generator_UserColumnName="Total" msprop:Generator_ColumnPropNameInRow="Total" msprop:Generator_ColumnVarNameInTable="columnTotal" msprop:Generator_ColumnPropNameInTable="TotalColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Pass_x0020_Rate" msprop:Generator_UserColumnName="Pass Rate" msprop:Generator_ColumnPropNameInRow="Pass_Rate" msprop:Generator_ColumnVarNameInTable="columnPass_Rate" msprop:Generator_ColumnPropNameInTable="Pass_RateColumn" type="xs:float" minOccurs="0" /> + <xs:element name="Pass" msprop:Generator_UserColumnName="Pass" msprop:Generator_ColumnPropNameInRow="Pass" msprop:Generator_ColumnVarNameInTable="columnPass" msprop:Generator_ColumnPropNameInTable="PassColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Fail" msprop:Generator_UserColumnName="Fail" msprop:Generator_ColumnPropNameInRow="Fail" msprop:Generator_ColumnVarNameInTable="columnFail" msprop:Generator_ColumnPropNameInTable="FailColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Error" msprop:Generator_UserColumnName="Error" msprop:Generator_ColumnPropNameInRow="Error" msprop:Generator_ColumnVarNameInTable="columnError" msprop:Generator_ColumnPropNameInTable="ErrorColumn" type="xs:int" 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="completed" msprop:Generator_UserColumnName="completed" msprop:Generator_ColumnVarNameInTable="columncompleted" msprop:Generator_ColumnPropNameInRow="completed" msprop:Generator_ColumnPropNameInTable="completedColumn" type="xs:boolean" minOccurs="0" /> + <xs:element name="Type" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> @@ -967,10 +1051,10 @@ </xs:sequence> </xs:complexType> </xs:element> - <xs:element name="WorkOrder" msprop:Generator_UserTableName="WorkOrder" msprop:Generator_RowDeletedName="WorkOrderRowDeleted" msprop:Generator_RowChangedName="WorkOrderRowChanged" msprop:Generator_RowClassName="WorkOrderRow" msprop:Generator_RowChangingName="WorkOrderRowChanging" msprop:Generator_RowEvArgName="WorkOrderRowChangeEvent" msprop:Generator_RowEvHandlerName="WorkOrderRowChangeEventHandler" msprop:Generator_TableClassName="WorkOrderDataTable" msprop:Generator_TableVarName="tableWorkOrder" msprop:Generator_RowDeletingName="WorkOrderRowDeleting" msprop:Generator_TablePropName="WorkOrder"> + <xs:element name="ActionItems" msprop:Generator_UserTableName="ActionItems" msprop:Generator_RowDeletedName="ActionItemsRowDeleted" msprop:Generator_RowChangedName="ActionItemsRowChanged" msprop:Generator_RowClassName="ActionItemsRow" msprop:Generator_RowChangingName="ActionItemsRowChanging" msprop:Generator_RowEvArgName="ActionItemsRowChangeEvent" msprop:Generator_RowEvHandlerName="ActionItemsRowChangeEventHandler" msprop:Generator_TableClassName="ActionItemsDataTable" msprop:Generator_TableVarName="tableActionItems" msprop:Generator_RowDeletingName="ActionItemsRowDeleting" msprop:Generator_TablePropName="ActionItems"> <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" minOccurs="0" /> + <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:simpleType> <xs:restriction base="xs:string"> @@ -978,211 +1062,160 @@ </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="platform" msprop:Generator_UserColumnName="platform" msprop:Generator_ColumnVarNameInTable="columnplatform" msprop:Generator_ColumnPropNameInRow="platform" msprop:Generator_ColumnPropNameInTable="platformColumn" 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="255" /> - </xs:restriction> - </xs:simpleType> - </xs:element> - <xs:element name="created" msdata:ReadOnly="true" msprop:Generator_UserColumnName="created" msprop:Generator_ColumnVarNameInTable="columncreated" msprop:Generator_ColumnPropNameInRow="created" msprop:Generator_ColumnPropNameInTable="createdColumn" type="xs:base64Binary" minOccurs="0" /> - <xs:element name="finished" msprop:Generator_UserColumnName="finished" msprop:Generator_ColumnVarNameInTable="columnfinished" msprop:Generator_ColumnPropNameInRow="finished" msprop:Generator_ColumnPropNameInTable="finishedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="userid" msprop:Generator_UserColumnName="userid" msprop:Generator_ColumnVarNameInTable="columnuserid" msprop:Generator_ColumnPropNameInRow="userid" msprop:Generator_ColumnPropNameInTable="useridColumn" minOccurs="0"> - <xs:simpleType> - <xs:restriction base="xs:string"> - <xs:maxLength value="50" /> - </xs:restriction> - </xs:simpleType> - </xs:element> - <xs:element name="WoName" msprop:Generator_UserColumnName="WoName" msprop:Generator_ColumnPropNameInRow="WoName" msprop:Generator_ColumnVarNameInTable="columnWoName" msprop:Generator_ColumnPropNameInTable="WoNameColumn" minOccurs="0"> - <xs:simpleType> - <xs:restriction base="xs:string"> - <xs:maxLength value="255" /> - </xs:restriction> - </xs:simpleType> - </xs:element> - <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> - <xs:simpleType> - <xs:restriction base="xs:string"> - <xs:maxLength value="50" /> - </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:simpleType> - <xs:restriction base="xs:string"> - <xs:maxLength value="2147483647" /> - </xs:restriction> - </xs:simpleType> - </xs:element> - </xs:sequence> - </xs:complexType> - </xs:element> - <xs:element name="ActionItems" msprop:Generator_UserTableName="ActionItems" msprop:Generator_RowDeletedName="ActionItemsRowDeleted" msprop:Generator_RowChangedName="ActionItemsRowChanged" msprop:Generator_RowClassName="ActionItemsRow" msprop:Generator_RowChangingName="ActionItemsRowChanging" msprop:Generator_RowEvArgName="ActionItemsRowChangeEvent" msprop:Generator_RowEvHandlerName="ActionItemsRowChangeEventHandler" msprop:Generator_TableClassName="ActionItemsDataTable" msprop:Generator_TableVarName="tableActionItems" msprop:Generator_RowDeletingName="ActionItemsRowDeleting" msprop:Generator_TablePropName="ActionItems"> - <xs:complexType> - <xs:sequence> - <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_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> - <xs:simpleType> - <xs:restriction base="xs:string"> <xs:maxLength value="100000" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="dateStamp" msprop:Generator_UserColumnName="dateStamp" msprop:Generator_ColumnPropNameInRow="dateStamp" msprop:Generator_ColumnVarNameInTable="columndateStamp" msprop:Generator_ColumnPropNameInTable="dateStampColumn" minOccurs="0"> + <xs:element name="dateStamp" msprop:Generator_UserColumnName="dateStamp" msprop:Generator_ColumnVarNameInTable="columndateStamp" msprop:Generator_ColumnPropNameInRow="dateStamp" msprop:Generator_ColumnPropNameInTable="dateStampColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="percentFinished" msprop:Generator_UserColumnName="percentFinished" msprop:Generator_ColumnPropNameInRow="percentFinished" msprop:Generator_ColumnVarNameInTable="columnpercentFinished" msprop:Generator_ColumnPropNameInTable="percentFinishedColumn" type="xs:int" /> - <xs:element name="state" msprop:Generator_UserColumnName="state" msprop:Generator_ColumnVarNameInTable="columnstate" msprop:Generator_ColumnPropNameInRow="state" msprop:Generator_ColumnPropNameInTable="stateColumn" minOccurs="0"> + <xs:element name="percentFinished" msprop:Generator_UserColumnName="percentFinished" msprop:Generator_ColumnVarNameInTable="columnpercentFinished" msprop:Generator_ColumnPropNameInRow="percentFinished" msprop:Generator_ColumnPropNameInTable="percentFinishedColumn" type="xs:int" /> + <xs:element name="state" msprop:Generator_UserColumnName="state" msprop:Generator_ColumnPropNameInRow="state" msprop:Generator_ColumnVarNameInTable="columnstate" msprop:Generator_ColumnPropNameInTable="stateColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="userID" msprop:Generator_UserColumnName="userID" msprop:Generator_ColumnPropNameInRow="userID" msprop:Generator_ColumnVarNameInTable="columnuserID" msprop:Generator_ColumnPropNameInTable="userIDColumn" minOccurs="0"> + <xs:element name="userID" msprop:Generator_UserColumnName="userID" msprop:Generator_ColumnVarNameInTable="columnuserID" msprop:Generator_ColumnPropNameInRow="userID" msprop:Generator_ColumnPropNameInTable="userIDColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="owner" msprop:Generator_UserColumnName="owner" msprop:Generator_ColumnPropNameInRow="owner" msprop:Generator_ColumnVarNameInTable="columnowner" msprop:Generator_ColumnPropNameInTable="ownerColumn" minOccurs="0"> + <xs:element name="owner" msprop:Generator_UserColumnName="owner" msprop:Generator_ColumnVarNameInTable="columnowner" msprop:Generator_ColumnPropNameInRow="owner" msprop:Generator_ColumnPropNameInTable="ownerColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLengt... [truncated message content] |
