Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [56] WebPrototype
|
From: <ro...@us...> - 2006-07-03 19:57:11
|
Revision: 56 Author: rouquin Date: 2006-07-03 12:56:58 -0700 (Mon, 03 Jul 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=56&view=rev Log Message: ----------- Updated Objective and TestCase pages to use testMaster. Updated labels, etc. also. 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/FeatureEdit.aspx.cs WebPrototype/ObjectiveEdit.aspx WebPrototype/ObjectiveEdit.aspx.cs WebPrototype/TestCaseEdit.aspx WebPrototype/TestCaseEdit.aspx.cs WebPrototype/TestMaster.master.cs Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-30 21:40:33 UTC (rev 55) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-07-03 19:56:58 UTC (rev 56) @@ -13,7 +13,7 @@ <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 + <CommandText>SELECT objectiveID, featureID, name, description, userID, dateCreated, statusID FROM Objective</CommandText> <Parameters> </Parameters> @@ -22,34 +22,39 @@ </DbSource> </MainSource> <Mappings> - <Mapping SourceColumn="id" DataSetColumn="id" /> <Mapping SourceColumn="name" DataSetColumn="name" /> <Mapping SourceColumn="description" DataSetColumn="description" /> - <Mapping SourceColumn="user" DataSetColumn="user" /> - <Mapping SourceColumn="feature" DataSetColumn="feature" /> - <Mapping SourceColumn="time" DataSetColumn="time" /> + <Mapping SourceColumn="objectiveID" DataSetColumn="objectiveID" /> + <Mapping SourceColumn="featureID" DataSetColumn="featureID" /> + <Mapping SourceColumn="userID" DataSetColumn="userID" /> + <Mapping SourceColumn="dateCreated" DataSetColumn="dateCreated" /> + <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="GetDataBy" UserSourceName="DeleteByID"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>DELETE FROM Objective -WHERE (id = @original_id)</CommandText> +WHERE (objectiveID = @original_objectiveID)</CommandText> <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="original_id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" 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_objectiveID" ColumnName="objectiveID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_objectiveID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="objectiveID" SourceColumnNullMapping="False" SourceVersion="Original"> </Parameter> </Parameters> </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="GetObjectiveDataByID1"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" 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 -FROM Objective -WHERE (id = @id)</CommandText> + <CommandText>SELECT Objective.dateCreated, Objective.description, Objective.featureID, Feature.name AS featureName, Objective.name, Objective.objectiveID, + Objective.statusID, Status.stateName, Objective.userID, Users.firstName + ' ' + Users.lastName AS createdBy +FROM Objective LEFT OUTER JOIN + Feature ON Objective.featureID = Feature.featureID LEFT OUTER JOIN + Users ON Users.id = Objective.userID LEFT OUTER JOIN + Status ON Status.id = Objective.statusID +WHERE (Objective.objectiveID = @objectiveID)</CommandText> <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="objectiveID" ColumnName="objectiveID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@objectiveID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="objectiveID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> </Parameters> </DbCommand> @@ -59,131 +64,98 @@ <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>INSERT INTO Objective - (name, description, [user]) -VALUES (@name,@description,@user)</CommandText> + (name, description, featureID, dateCreated, statusID) +VALUES (@name,@description,@featureID,@dateCreated, @statusID)</CommandText> <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="nchar(255)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="255" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" 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.Objective" 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="user" ColumnName="user" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="nchar(25)" DbType="String" Direction="Input" ParameterName="@user" Precision="0" ProviderType="NChar" Scale="0" Size="25" SourceColumn="user" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="featureID" ColumnName="featureID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@featureID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="featureID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="dateCreated" ColumnName="dateCreated" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dateCreated" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dateCreated" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="statusID" ColumnName="statusID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@statusID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="statusID" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> </Parameters> </DbCommand> </InsertCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Objective" DbObjectType="Table" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy4" GeneratorSourceName="objectiveDateQuery" Modifier="Public" Name="objectiveDateQuery" QueryType="Scalar" ScalarCallRetval="System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="objectiveDateQuery"> - <SelectCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT description, feature, id, name, time, [user] FROM Objective WHERE (id = @id)</CommandText> - <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" 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> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="UpdateByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="UpdateByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE Objective -SET name = @name, description = @description, [user] = @user -WHERE (id = @original_id)</CommandText> +SET name = @name, description = @description, featureID=@featureID, statusID=@statusID +WHERE (objectiveID = @original_objectiveID)</CommandText> <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="nchar(255)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="255" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" 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.Objective" 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="user" ColumnName="user" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="nchar(25)" DbType="String" Direction="Input" ParameterName="@user" Precision="0" ProviderType="NChar" Scale="0" Size="25" SourceColumn="user" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="featureID" ColumnName="featureID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@featureID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="featureID" 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.Objective" 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="statusID" ColumnName="statusID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@statusID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="statusID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - </Parameters> - </DbCommand> - </UpdateCommand> - </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateFeature" Modifier="Public" Name="UpdateFeature" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy4" UserSourceName="UpdateFeature"> - <UpdateCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>UPDATE Objective -SET feature = @feature, time=@time -WHERE (id = @original_id)</CommandText> - <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="feature" ColumnName="feature" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@feature" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="feature" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="original_objectiveID" ColumnName="objectiveID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_objectiveID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="objectiveID" SourceColumnNullMapping="False" SourceVersion="Original"> </Parameter> - <Parameter AllowDbNull="False" AutogeneratedName="time" ColumnName="time" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@time" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="time" 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.Objective" 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> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy5" GeneratorSourceName="UpdateObjective" Modifier="Public" Name="UpdateObjective" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy5" UserSourceName="UpdateObjective"> - <UpdateCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>UPDATE Objective -SET feature = @feature, time = @time -WHERE (id IN - (SELECT MAX(id) AS Expr1 - FROM Objective))</CommandText> - <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="feature" ColumnName="feature" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@feature" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="feature" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="False" AutogeneratedName="time" ColumnName="time" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@time" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="time" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - </Parameters> - </DbCommand> - </UpdateCommand> - </DbSource> </Sources> </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="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="GetTestCaseDataByID"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT id, name, number, steps, createdby, editedby, dateCreated, dateEdited, objectiveID, statusID -FROM TestCase -WHERE (id = @id)</CommandText> + <CommandText>SELECT testcaseID, objectiveID, name, number, steps, creatorID, lastEditID, dateCreated, dateEdited, statusID +FROM TestCase</CommandText> <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" 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="steps" DataSetColumn="steps" /> <Mapping SourceColumn="number" DataSetColumn="number" /> - <Mapping SourceColumn="createdby" DataSetColumn="createdby" /> - <Mapping SourceColumn="editedby" DataSetColumn="editedby" /> <Mapping SourceColumn="dateCreated" DataSetColumn="dateCreated" /> <Mapping SourceColumn="dateEdited" DataSetColumn="dateEdited" /> <Mapping SourceColumn="objectiveID" DataSetColumn="objectiveID" /> <Mapping SourceColumn="statusID" DataSetColumn="statusID" /> + <Mapping SourceColumn="testcaseID" DataSetColumn="testcaseID" /> + <Mapping SourceColumn="creatorID" DataSetColumn="creatorID" /> + <Mapping SourceColumn="lastEditID" DataSetColumn="lastEditID" /> </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 TestCase WHERE id=@original_id</CommandText> + <CommandText>DELETE FROM TestCase WHERE testcaseID=@original_testcaseID</CommandText> <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="original_id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" 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_testcaseID" ColumnName="testcaseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_testcaseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="testcaseID" SourceColumnNullMapping="False" SourceVersion="Original"> </Parameter> </Parameters> </DbCommand> </DeleteCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.TestCase" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAllTestCaseData" GetMethodModifier="Public" GetMethodName="GetAllTestCaseData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAllTestCaseData" UserSourceName="GetAllTestCaseData1"> + <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"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT id, objectiveID, number, CAST(number AS varchar(20)) + ': ' + name AS Name, statusID, steps, createdby, editedby, dateCreated, dateEdited -FROM TestCase</CommandText> + <CommandText>SELECT TestCase.testcaseID, TestCase.objectiveID, Objective.name AS objectiveName, TestCase.name, TestCase.number, TestCase.steps, + TestCase.creatorID, u1.firstName + ' ' + u1.lastName AS createdBy, TestCase.lastEditID, u2.firstName + ' ' + u2.lastName AS editedBy, + TestCase.dateCreated, TestCase.dateEdited, TestCase.statusID, Status.stateName +FROM TestCase LEFT OUTER JOIN + Objective ON TestCase.objectiveID = Objective.objectiveID LEFT OUTER JOIN + Status ON Status.id = TestCase.statusID LEFT OUTER JOIN + Users AS u1 ON u1.id = TestCase.creatorID LEFT OUTER JOIN + Users AS u2 ON u2.id = TestCase.lastEditID +WHERE (TestCase.testcaseID = @testcaseID)</CommandText> <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="testcaseID" ColumnName="testcaseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" 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> </SelectCommand> @@ -192,86 +164,48 @@ <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>INSERT INTO TestCase - (number, name, steps) -VALUES (@number,@name,@steps)</CommandText> + (number, name, steps, objectiveID, dateCreated, dateEdited, statusID) +VALUES (@number,@name,@steps,@objectiveID,@dateCreated,@dateEdited,@statusID)</CommandText> <Parameters> <Parameter AllowDbNull="True" AutogeneratedName="number" ColumnName="number" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@number" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="number" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="nchar(255)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="255" 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.TestCase" 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="steps" ColumnName="steps" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@steps" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="steps" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - </Parameters> - </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="GetDataBy2" UserSourceName="UpdateSpecial"> - <UpdateCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>UPDATE TestCase -SET objectiveID = @objectiveID, statusID = @statusID, createdby = @createdby, editedby = @editedby, dateCreated = @dateCreated, - dateEdited = @dateEdited -WHERE (id IN - (SELECT MAX(id) AS Expr1 - FROM TestCase))</CommandText> - <Parameters> <Parameter AllowDbNull="True" AutogeneratedName="objectiveID" ColumnName="objectiveID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@objectiveID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="objectiveID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="statusID" ColumnName="statusID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@statusID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="statusID" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="createdby" ColumnName="createdby" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@createdby" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="createdby" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="editedby" ColumnName="editedby" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@editedby" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="editedby" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="dateCreated" ColumnName="dateCreated" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dateCreated" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dateCreated" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="dateEdited" ColumnName="dateEdited" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dateEdited" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dateEdited" SourceColumnNullMapping="False" SourceVersion="Current"> </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="GetDataBy3" UserSourceName="UpdateSpecialByID"> - <UpdateCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>UPDATE TestCase -SET objectiveID = @objectiveID, statusID = @statusID, createdby = @createdby, editedby = @editedby, dateCreated = @dateCreated, - dateEdited = @dateEdited -WHERE (id = @original_id)</CommandText> - <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="objectiveID" ColumnName="objectiveID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@objectiveID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="objectiveID" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="statusID" ColumnName="statusID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@statusID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="statusID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="createdby" ColumnName="createdby" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@createdby" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="createdby" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="editedby" ColumnName="editedby" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@editedby" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="editedby" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="dateCreated" ColumnName="dateCreated" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dateCreated" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dateCreated" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="dateEdited" ColumnName="dateEdited" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dateEdited" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dateEdited" 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.TestCase" 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> + </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"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE TestCase -SET number = @number, name = @name, steps = @steps -WHERE (id = @original_id)</CommandText> +SET number = @number, name = @name, steps = @steps, objectiveID = @objectiveID, statusID = @statusID, dateEdited = @dateEdited +WHERE (testcaseID = @original_testcaseid)</CommandText> <Parameters> <Parameter AllowDbNull="True" AutogeneratedName="number" ColumnName="number" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@number" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="number" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="nchar(255)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="255" 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.TestCase" 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="steps" ColumnName="steps" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@steps" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="steps" 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.TestCase" 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="objectiveID" ColumnName="objectiveID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@objectiveID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="objectiveID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="statusID" ColumnName="statusID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@statusID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="statusID" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="dateEdited" ColumnName="dateEdited" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dateEdited" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dateEdited" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="False" AutogeneratedName="original_testcaseid" ColumnName="testcaseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_testcaseid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="testcaseID" SourceColumnNullMapping="False" SourceVersion="Original"> + </Parameter> </Parameters> </DbCommand> </UpdateCommand> @@ -297,6 +231,20 @@ <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"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT Tags.id, Tags.name, Tags.description +FROM Tags INNER JOIN + testCaseTags ON testCaseTags.tagID = Tags.id +WHERE (testCaseTags.testCaseID = @testcaseID)</CommandText> + <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="testcaseID" ColumnName="testCaseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.testCaseTags" 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> + </SelectCommand> + </DbSource> </Sources> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductsTableAdapter" GeneratorDataComponentClassName="ProductsTableAdapter" Name="Products" UserDataComponentName="ProductsTableAdapter"> @@ -579,9 +527,23 @@ <Mapping SourceColumn="active" DataSetColumn="active" /> </Mappings> <Sources> - <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="FillBy"> + <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"> <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> + <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> + </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"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT versionID, productID, number, dateCreated, active FROM version WHERE (active = 1) AND productID=@productID</CommandText> @@ -638,7 +600,7 @@ <Mapping SourceColumn="versionID" DataSetColumn="versionID" /> </Mappings> <Sources> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetFeatureVersionsByID" GetMethodModifier="Public" GetMethodName="GetFeatureVersionsByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetFeatureVersionsByID" UserSourceName="FillBy"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetFeatureVersionsByID" GetMethodModifier="Public" GetMethodName="GetFeatureVersionsByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetFeatureVersionsByID" UserSourceName="GetFeatureVersionsByID1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT fv.featureID, fv.versionID, v.number @@ -1033,7 +995,7 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FeatureTableAdapter" GeneratorDataComponentClassName="FeatureTableAdapter" Name="Feature" UserDataComponentName="FeatureTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Feature" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllFeatures" GetMethodModifier="Public" GetMethodName="GetAllFeatures" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllFeatures" UserSourceName="Fill"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Feature" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllFeatures" GetMethodModifier="Public" GetMethodName="GetAllFeatures" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllFeatures" UserSourceName="GetAllFeatures"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT featureID, parentFeatureID, name, description, userID, dateCreated, featureNumber, orderNumber FROM Feature</CommandText> @@ -1054,7 +1016,7 @@ <Mapping SourceColumn="orderNumber" DataSetColumn="orderNumber" /> </Mappings> <Sources> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="DeleteFeatureByID" Modifier="Public" Name="DeleteFeatureByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="DeleteFeatureByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="DeleteFeatureByID" Modifier="Public" Name="DeleteFeatureByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="DeleteFeatureByID"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>DELETE FROM Feature WHERE featureID=@original_featureID</CommandText> @@ -1065,7 +1027,7 @@ </DbCommand> </DeleteCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetFeatureNamesByID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetFeatureNamesByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetFeatureNamesByID" UserSourceName="FillBy"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetFeatureNamesByID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetFeatureNamesByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetFeatureNamesByID" UserSourceName="GetFeatureNamesByID1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT Feature.featureID, Feature.name, Feature.description, Feature_1.name AS Parent, Feature.parentFeatureID, @@ -1085,7 +1047,7 @@ </DbCommand> </SelectCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertFeature" Modifier="Public" Name="InsertFeature" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="InsertFeature"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertFeature" Modifier="Public" Name="InsertFeature" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="InsertFeature"> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>INSERT INTO Feature @@ -1102,7 +1064,7 @@ </DbCommand> </InsertCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="UpdateByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="UpdateByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE Feature @@ -1135,7 +1097,6 @@ <xs:element name="Objective" msprop:Generator_UserTableName="Objective" msprop:Generator_RowDeletedName="ObjectiveRowDeleted" msprop:Generator_RowChangedName="ObjectiveRowChanged" msprop:Generator_RowClassName="ObjectiveRow" msprop:Generator_RowChangingName="ObjectiveRowChanging" msprop:Generator_RowEvArgName="ObjectiveRowChangeEvent" msprop:Generator_RowEvHandlerName="ObjectiveRowChangeEventHandler" msprop:Generator_TableClassName="ObjectiveDataTable" msprop:Generator_TableVarName="tableObjective" msprop:Generator_RowDeletingName="ObjectiveRowDeleting" msprop:Generator_TablePropName="Objective"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameI... [truncated message content] |
