Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [57] WebPrototype
|
From: <ro...@us...> - 2006-07-03 21:44:24
|
Revision: 57 Author: rouquin Date: 2006-07-03 14:44:07 -0700 (Mon, 03 Jul 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=57&view=rev Log Message: ----------- updated ProductEdit to be cleaner Modified Paths: -------------- 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/ProductEdit.aspx WebPrototype/ProductEdit.aspx.cs WebPrototype/TestMaster.master.cs Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-07-03 19:56:58 UTC (rev 56) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-07-03 21:44:07 UTC (rev 57) @@ -106,7 +106,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="GetAllTestCaseData" GetMethodModifier="Public" GetMethodName="GetAllTestCaseData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllTestCaseData" UserSourceName="GetTestCaseDataByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.TestCase" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllTestCaseData" GetMethodModifier="Public" GetMethodName="GetAllTestCaseData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllTestCaseData" UserSourceName="GetAllTestCaseData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT testcaseID, objectiveID, name, number, steps, creatorID, lastEditID, dateCreated, dateEdited, statusID @@ -141,7 +141,7 @@ </DbCommand> </DeleteCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetTestCasesByID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetTestCasesByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetTestCasesByID" UserSourceName="FillBy"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetTestCasesByID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetTestCasesByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetTestCasesByID" UserSourceName="GetTestCasesByID1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT TestCase.testcaseID, TestCase.objectiveID, Objective.name AS objectiveName, TestCase.name, TestCase.number, TestCase.steps, @@ -185,7 +185,7 @@ </DbCommand> </InsertCommand> </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="GetDataBy4" 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="GetDataBy2" UserSourceName="UpdateTestCaseByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE TestCase @@ -231,7 +231,7 @@ <Mapping SourceColumn="description" DataSetColumn="description" /> </Mappings> <Sources> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Tags" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetTagsByTestCaseID" GetMethodModifier="Public" GetMethodName="GetTagsByTestCaseID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetTagsByTestCaseID" UserSourceName="FillBy"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Tags" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetTagsByTestCaseID" GetMethodModifier="Public" GetMethodName="GetTagsByTestCaseID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetTagsByTestCaseID" UserSourceName="GetTagsByTestCaseID1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT Tags.id, Tags.name, Tags.description @@ -247,160 +247,120 @@ </DbSource> </Sources> </TableAdapter> - <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductsTableAdapter" GeneratorDataComponentClassName="ProductsTableAdapter" Name="Products" UserDataComponentName="ProductsTableAdapter"> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="productTableAdapter" GeneratorDataComponentClassName="productTableAdapter" Name="product" UserDataComponentName="productTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Products" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetProductDataByID" GetMethodModifier="Public" GetMethodName="GetProductDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetProductDataByID" UserSourceName="GetProductDataByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.product" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllProductData" GetMethodModifier="Public" GetMethodName="GetAllProductData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllProductData" UserSourceName="GetProductDataByID"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT p.id, p.Name, p.Description, p.Code, u1.firstName + ' ' + u1.lastName AS ProductManager, p.ProductManager AS ProductManagerID, - u2.firstName + ' ' + u2.lastName AS DevManager, p.DevManager AS DevManagerID, u3.firstName + ' ' + u3.lastName AS DevLead, - p.DevLead AS DevLeadID, u4.firstName + ' ' + u4.lastName AS QAManager, p.QAManager AS QAManagerID, - u5.firstName + ' ' + u5.lastName AS QALead, p.QALead AS QALeadID -FROM Products AS p LEFT OUTER JOIN - Users AS u1 ON u1.id = p.ProductManager LEFT OUTER JOIN - Users AS u2 ON u2.id = p.DevManager LEFT OUTER JOIN - Users AS u3 ON u3.id = p.DevLead LEFT OUTER JOIN - Users AS u4 ON u4.id = p.QAManager LEFT OUTER JOIN - Users AS u5 ON u5.id = p.QALead -WHERE (p.id = @id)</CommandText> + <CommandText>SELECT productID, name, description, devManager, qaManager, devLead, qaLead, pm, codeName +FROM product</CommandText> <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" 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="Description" DataSetColumn="Description" /> - <Mapping SourceColumn="Code" DataSetColumn="Code" /> - <Mapping SourceColumn="ProductManager" DataSetColumn="ProductManager" /> - <Mapping SourceColumn="ProductManagerID" DataSetColumn="ProductManagerID" /> - <Mapping SourceColumn="DevManager" DataSetColumn="DevManager" /> - <Mapping SourceColumn="DevManagerID" DataSetColumn="DevManagerID" /> - <Mapping SourceColumn="DevLead" DataSetColumn="DevLead" /> - <Mapping SourceColumn="DevLeadID" DataSetColumn="DevLeadID" /> - <Mapping SourceColumn="QAManager" DataSetColumn="QAManager" /> - <Mapping SourceColumn="QAManagerID" DataSetColumn="QAManagerID" /> - <Mapping SourceColumn="QALead" DataSetColumn="QALead" /> - <Mapping SourceColumn="QALeadID" DataSetColumn="QALeadID" /> + <Mapping SourceColumn="productID" DataSetColumn="productID" /> + <Mapping SourceColumn="name" DataSetColumn="name" /> + <Mapping SourceColumn="description" DataSetColumn="description" /> + <Mapping SourceColumn="devManager" DataSetColumn="devManager" /> + <Mapping SourceColumn="qaManager" DataSetColumn="qaManager" /> + <Mapping SourceColumn="devLead" DataSetColumn="devLead" /> + <Mapping SourceColumn="qaLead" DataSetColumn="qaLead" /> + <Mapping SourceColumn="pm" DataSetColumn="pm" /> + <Mapping SourceColumn="codeName" DataSetColumn="codeName" /> </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="GetDataBy" UserSourceName="DeleteByID"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>DELETE FROM Products -WHERE (id = @original_id)</CommandText> + <CommandText>DELETE FROM product +WHERE (productID = @original_productID)</CommandText> <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="original_id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original"> + <Parameter AllowDbNull="False" AutogeneratedName="original_productID" ColumnName="productID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_productID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="productID" SourceColumnNullMapping="False" SourceVersion="Original"> </Parameter> </Parameters> </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="GetAllProducts1"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.product" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetProductByID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetProductByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetProductByID" UserSourceName="FillBy"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT Code, Description, Name, id FROM Products</CommandText> + <CommandText>SELECT product.productID, product.name, product.description, product.devManager, u1.firstName + ' ' + u1.lastName AS devManagerName, + product.qaManager, u2.firstName + ' ' + u2.lastName AS qaManagerName, product.devLead, u3.firstName + ' ' + u3.lastName AS devLeadName, + product.qaLead, u3.firstName + ' ' + u3.lastName AS qaLeadName, product.pm, u4.firstName + ' ' + u4.lastName AS pmName, product.codeName +FROM product LEFT OUTER JOIN + Users AS u1 ON u1.id = product.devManager LEFT OUTER JOIN + Users AS u2 ON u2.id = product.qaManager LEFT OUTER JOIN + Users AS u3 ON u3.id = product.devLead LEFT OUTER JOIN + Users AS u4 ON u4.id = product.qaLead LEFT OUTER JOIN + Users AS u5 ON u5.id = product.pm +WHERE (product.productID = @productID)</CommandText> <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="productID" ColumnName="productID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@productID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="productID" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> </Parameters> </DbCommand> </SelectCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertAll" Modifier="Public" Name="InsertAll" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="InsertAll"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertProduct" Modifier="Public" Name="InsertProduct" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="InsertProduct"> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>INSERT INTO Products - (Name, Description, QAManager, DevManager, DevLead, QALead, ProductManager, Code) -VALUES (@Name,@Description,@QAManager,@DevManager,@DevLead,@QALead,@ProductManager,@Code)</CommandText> + <CommandText>INSERT INTO product + (name, description, devManager, qaManager, devLead, qaLead, pm, codeName) +VALUES (@name,@description,@devmanager,@qaManager,@devLead,@qaLead,@pm,@codeName)</CommandText> <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="Name" ColumnName="Name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="nchar(50)" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="50" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="Description" ColumnName="Description" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="description" ColumnName="description" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="description" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="QAManager" ColumnName="QAManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QAManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QAManager" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="devmanager" ColumnName="devManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@devmanager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="devManager" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="DevManager" ColumnName="DevManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DevManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DevManager" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="qaManager" ColumnName="qaManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@qaManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="qaManager" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="DevLead" ColumnName="DevLead" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DevLead" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DevLead" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="devLead" ColumnName="devLead" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@devLead" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="devLead" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="QALead" ColumnName="QALead" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QALead" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QALead" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="qaLead" ColumnName="qaLead" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@qaLead" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="qaLead" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="ProductManager" ColumnName="ProductManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductManager" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="pm" ColumnName="pm" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pm" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="pm" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="Code" ColumnName="Code" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="nchar(50)" DbType="String" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="NChar" Scale="0" Size="50" SourceColumn="Code" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="codeName" ColumnName="codeName" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@codeName" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="codeName" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> </Parameters> </DbCommand> </InsertCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateAll" Modifier="Public" Name="UpdateAll" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="UpdateAll"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateProductByID" Modifier="Public" Name="UpdateProductByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="UpdateProductByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>UPDATE Products -SET Name = @Name, Description = @Description, Code = @Code -WHERE (id = @original_id)</CommandText> + <CommandText>UPDATE product +SET description = @description, name = @name, devManager = @devManager, qaManager = @qaManager, devLead = @devLead, qaLead = @qaLead, + pm = @pm, codeName = @codeName +WHERE (productID = @original_productID)</CommandText> <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="Name" ColumnName="Name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="nchar(50)" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="50" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="description" ColumnName="description" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="description" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="Description" ColumnName="Description" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="Code" ColumnName="Code" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="nchar(50)" DbType="String" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="NChar" Scale="0" Size="50" SourceColumn="Code" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="devManager" ColumnName="devManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@devManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="devManager" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="False" AutogeneratedName="original_id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original"> + <Parameter AllowDbNull="True" AutogeneratedName="qaManager" ColumnName="qaManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@qaManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="qaManager" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - </Parameters> - </DbCommand> - </UpdateCommand> - </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateSpecial" Modifier="Public" Name="UpdateSpecial" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="UpdateSpecial"> - <UpdateCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>UPDATE Products -SET DevManager = @DevManager, QAManager = @QAManager, DevLead = @DevLead, QALead = @QALead, ProductManager = @ProductManager -WHERE (id IN - (SELECT MAX(id) AS Expr1 - FROM Products))</CommandText> - <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="DevManager" ColumnName="DevManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DevManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DevManager" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="devLead" ColumnName="devLead" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@devLead" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="devLead" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="QAManager" ColumnName="QAManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QAManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QAManager" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="qaLead" ColumnName="qaLead" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@qaLead" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="qaLead" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="DevLead" ColumnName="DevLead" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DevLead" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DevLead" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="pm" ColumnName="pm" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pm" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="pm" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="QALead" ColumnName="QALead" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QALead" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QALead" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="codeName" ColumnName="codeName" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@codeName" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="codeName" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="ProductManager" ColumnName="ProductManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductManager" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="original_productID" ColumnName="productID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_productID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="productID" SourceColumnNullMapping="False" SourceVersion="Original"> </Parameter> </Parameters> </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="GetDataBy4" UserSourceName="UpdateSpecialByID"> - <UpdateCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>UPDATE Products -SET DevManager = @DevManager, QAManager = @QAManager, DevLead = @DevLead, QALead = @QALead, ProductManager = @ProductManager -WHERE (id = @original_id)</CommandText> - <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="DevManager" ColumnName="DevManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DevManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DevManager" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="QAManager" ColumnName="QAManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QAManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QAManager" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="DevLead" ColumnName="DevLead" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DevLead" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DevLead" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="QALead" ColumnName="QALead" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QALead" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QALead" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="ProductManager" ColumnName="ProductManager" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductManager" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="False" AutogeneratedName="original_id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original"> - </Parameter> - </Parameters> - </DbCommand> - </UpdateCommand> - </DbSource> </Sources> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter"> @@ -527,28 +487,28 @@ <Mapping SourceColumn="active" DataSetColumn="active" /> </Mappings> <Sources> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.version" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetVersionsByTestCaseID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetVersionsByTestCaseID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetVersionsByTestCaseID" UserSourceName="FillBy"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.version" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetVersionsByProductID" GetMethodModifier="Public" GetMethodName="GetVersionsByProductID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetVersionsByProductID" UserSourceName="GetVersionsByProductID1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT v.versionID, v.productID, v.number, v.dateCreated, v.active -FROM version AS v INNER JOIN - versionTestCase AS vtc ON vtc.versionID = v.versionID -WHERE (v.active = 1) AND (vtc.testCaseID = @testcaseID)</CommandText> + <CommandText>SELECT versionID, productID, number, dateCreated, active +FROM version +WHERE (active = 1) AND productID=@productID</CommandText> <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="testcaseID" ColumnName="testCaseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.versionTestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@testcaseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="testCaseID" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="productID" ColumnName="productID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.version" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@productID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="productID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> </Parameters> </DbCommand> </SelectCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.version" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetVersionsByProductID" GetMethodModifier="Public" GetMethodName="GetVersionsByProductID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetVersionsByProductID" UserSourceName="GetVersionsByProductID1"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.version" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetVersionsByTestCaseID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetVersionsByTestCaseID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetVersionsByTestCaseID" UserSourceName="GetVersionsByTestCaseID1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT versionID, productID, number, dateCreated, active -FROM version -WHERE (active = 1) AND productID=@productID</CommandText> + <CommandText>SELECT v.versionID, v.productID, v.number, v.dateCreated, v.active +FROM version AS v INNER JOIN + versionTestCase AS vtc ON vtc.versionID = v.versionID +WHERE (v.active = 1) AND (vtc.testCaseID = @testcaseID)</CommandText> <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="productID" ColumnName="productID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.version" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@productID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="productID" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="testcaseID" ColumnName="testCaseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.versionTestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@testcaseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="testCaseID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> </Parameters> </DbCommand> @@ -1097,68 +1057,68 @@ <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="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" 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="objectiveID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="objectiveID" msprop:Generator_ColumnVarNameInTable="columnobjectiveID" msprop:Generator_ColumnPropNameInRow="objectiveID" msprop:Generator_ColumnPropNameInTable="objectiveIDColumn" type="xs:int" /> - <xs:element name="featureID" msprop:Generator_UserColumnName="featureID" msprop:Generator_ColumnVarNameInTable="columnfeatureID" msprop:Generator_ColumnPropNameInRow="featureID" msprop:Generator_ColumnPropNameInTable="featureIDColumn" type="xs:int" /> - <xs:element name="userID" msprop:Generator_UserColumnName="userID" msprop:Generator_ColumnVarNameInTable="columnuserID" msprop:Generator_ColumnPropNameInRow="userID" msprop:Generator_ColumnPropNameInTable="userIDColumn" 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="statusID" msprop:Generator_UserColumnName="statusID" msprop:Generator_ColumnVarNameInTable="columnstatusID" msprop:Generator_ColumnPropNameInRow="statusID" msprop:Generator_ColumnPropNameInTable="statusIDColumn" type="xs:int" default="0" minOccurs="0" /> + <xs:element name="objectiveID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="objectiveID" msprop:Generator_ColumnPropNameInRow="objectiveID" msprop:Generator_ColumnVarNameInTable="columnobjectiveID" msprop:Generator_ColumnPropNameInTable="objectiveIDColumn" 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" /> + <xs:element name="userID" msprop:Generator_UserColumnName="userID" msprop:Generator_ColumnPropNameInRow="userID" msprop:Generator_ColumnVarNameInTable="columnuserID" msprop:Generator_ColumnPropNameInTable="userIDColumn" 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="statusID" msprop:Generator_UserColumnName="statusID" msprop:Generator_ColumnPropNameInRow="statusID" msprop:Generator_ColumnVarNameInTable="columnstatusID" msprop:Generator_ColumnPropNameInTable="statusIDColumn" type="xs:int" default="0" minOccurs="0" /> </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="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" 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="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="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="testcaseID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="testcaseID" msprop:Generator_ColumnPropNameInRow="testcaseID" msprop:Generator_ColumnVarNameInTable="columntestcaseID" msprop:Generator_ColumnPropNameInTable="testcaseIDColumn" type="xs:int" /> - <xs:element name="creatorID" msprop:Generator_UserColumnName="creatorID" msprop:Generator_ColumnPropNameInRow="creatorID" msprop:Generator_ColumnVarNameInTable="columncreatorID" msprop:Generator_ColumnPropNameInTable="creatorIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="lastEditID" msprop:Generator_UserColumnName="lastEditID" msprop:Generator_ColumnPropNameInRow="lastEditID" msprop:Generator_ColumnVarNameInTable="columnlastEditID" msprop:Generator_ColumnPropNameInTable="lastEditIDColumn" 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="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:element name="testcaseID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="testcaseID" msprop:Generator_ColumnVarNameInTable="columntestcaseID" msprop:Generator_ColumnPropNameInRow="testcaseID" msprop:Generator_ColumnPropNameInTable="testcaseIDColumn" type="xs:int" /> + <xs:element name="creatorID" msprop:Generator_UserColumnName="creatorID" msprop:Generator_ColumnVarNameInTable="columncreatorID" msprop:Generator_ColumnPropNameInRow="creatorID" msprop:Generator_ColumnPropNameInTable="creatorIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="lastEditID" msprop:Generator_UserColumnName="lastEditID" msprop:Generator_ColumnVarNameInTable="columnlastEditID" msprop:Generator_ColumnPropNameInRow="lastEditID" msprop:Generator_ColumnPropNameInTable="lastEditIDColumn" 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" /> @@ -1168... [truncated message content] |
