Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [31]
|
From: <ro...@us...> - 2006-06-14 18:58:11
|
Revision: 31 Author: rouquin Date: 2006-06-14 11:57:27 -0700 (Wed, 14 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=31&view=rev Log Message: ----------- Created the Product page, add screenshots, and added the product and user tables to the database Modified Paths: -------------- WebPrototype/App_Code/DummyDataSet.xsd WebPrototype/App_Code/DummyDataSet.xss WebPrototype/App_Data/ASPNETDB.MDF WebPrototype/App_Data/aspnetdb_log.ldf WebPrototype/FeatureEdit.aspx WebPrototype/Product.aspx WebPrototype/Product.aspx.cs Added Paths: ----------- Screenshots/ Screenshots/ActionItem.JPG Screenshots/Assigments.JPG Screenshots/Feature.JPG Screenshots/Objective.JPG Screenshots/Product.JPG Screenshots/TestCase.JPG Added: Screenshots/ActionItem.JPG =================================================================== (Binary files differ) Property changes on: Screenshots/ActionItem.JPG ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Screenshots/Assigments.JPG =================================================================== (Binary files differ) Property changes on: Screenshots/Assigments.JPG ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Screenshots/Feature.JPG =================================================================== (Binary files differ) Property changes on: Screenshots/Feature.JPG ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Screenshots/Objective.JPG =================================================================== (Binary files differ) Property changes on: Screenshots/Objective.JPG ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Screenshots/Product.JPG =================================================================== (Binary files differ) Property changes on: Screenshots/Product.JPG ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Screenshots/TestCase.JPG =================================================================== (Binary files differ) Property changes on: Screenshots/TestCase.JPG ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-14 15:52:15 UTC (rev 30) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-06-14 18:57:27 UTC (rev 31) @@ -631,23 +631,149 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductsTableAdapter" GeneratorDataComponentClassName="ProductsTableAdapter" Name="Products" UserDataComponentName="ProductsTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Products" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetProductData" GetMethodModifier="Public" GetMethodName="GetProductData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetProductData" UserSourceName="GetProductData"> + <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="Fill"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT id, Name, Description, DevManager, QAManager, DevLead, QALead, ProductManager, Code +FROM Products +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.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="DevManager" DataSetColumn="DevManager" /> + <Mapping SourceColumn="QAManager" DataSetColumn="QAManager" /> + <Mapping SourceColumn="DevLead" DataSetColumn="DevLead" /> + <Mapping SourceColumn="QALead" DataSetColumn="QALead" /> + <Mapping SourceColumn="ProductManager" DataSetColumn="ProductManager" /> + <Mapping SourceColumn="Code" DataSetColumn="Code" /> + </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="GetDataBy2" UserSourceName="DeleteByID"> + <DeleteCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>DELETE FROM Products +WHERE (id = @original_id)</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> + </Parameters> + </DbCommand> + </DeleteCommand> + </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"> <InsertCommand> - <DbCommand CommandType="Text" ModifiedByUser="False"> - <CommandText>INSERT INTO [Products] ([id], [Name]) VALUES (@id, @Name)</CommandText> + <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> <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" 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.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> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" 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.Products" 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> + <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="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="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> </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="GetDataBy" UserSourceName="UpdateAll"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE Products +SET Name = @Name, Description = @Description, Code = @Code +WHERE (id = @original_id)</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> + <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> + <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> + <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> + <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="GetDataBy4" 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> + <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> + </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 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"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Users" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetUserDataByID" GetMethodModifier="Public" GetMethodName="GetUserDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetUserDataByID" UserSourceName="Fill"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT id, Name -FROM Products</CommandText> + <CommandText>SELECT id, email, officePhone, homePhone, cellPhone, firstName, lastName, automation +FROM Users +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.Users" 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> @@ -655,7 +781,13 @@ </MainSource> <Mappings> <Mapping SourceColumn="id" DataSetColumn="id" /> - <Mapping SourceColumn="Name" DataSetColumn="Name" /> + <Mapping SourceColumn="email" DataSetColumn="email" /> + <Mapping SourceColumn="officePhone" DataSetColumn="officePhone" /> + <Mapping SourceColumn="homePhone" DataSetColumn="homePhone" /> + <Mapping SourceColumn="cellPhone" DataSetColumn="cellPhone" /> + <Mapping SourceColumn="firstName" DataSetColumn="firstName" /> + <Mapping SourceColumn="lastName" DataSetColumn="lastName" /> + <Mapping SourceColumn="automation" DataSetColumn="automation" /> </Mappings> <Sources> </Sources> @@ -672,36 +804,36 @@ <xs:element name="Assignments" msprop:Generator_UserTableName="Assignments" msprop:Generator_RowDeletedName="AssignmentsRowDeleted" msprop:Generator_RowChangedName="AssignmentsRowChanged" msprop:Generator_RowClassName="AssignmentsRow" msprop:Generator_RowChangingName="AssignmentsRowChanging" msprop:Generator_RowEvArgName="AssignmentsRowChangeEvent" msprop:Generator_RowEvHandlerName="AssignmentsRowChangeEventHandler" msprop:Generator_TableClassName="AssignmentsDataTable" msprop:Generator_TableVarName="tableAssignments" msprop:Generator_RowDeletingName="AssignmentsRowDeleting" msprop:Generator_TablePropName="Assignments"> <xs:complexType> <xs:sequence> - <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnPropNameInTable="DateColumn" minOccurs="0"> + <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="Assignment" msprop:Generator_UserColumnName="Assignment" msprop:Generator_ColumnVarNameInTable="columnAssignment" msprop:Generator_ColumnPropNameInRow="Assignment" msprop:Generator_ColumnPropNameInTable="AssignmentColumn" minOccurs="0"> + <xs:element name="Assignment" msprop:Generator_UserColumnName="Assignment" msprop:Generator_ColumnPropNameInRow="Assignment" msprop:Generator_ColumnVarNameInTable="columnAssignment" msprop:Generator_ColumnPropNameInTable="AssignmentColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> + <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="20" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="_x0025__x0020_Complete" msprop:Generator_UserColumnName="% Complete" msprop:Generator_ColumnVarNameInTable="_column__Complete" msprop:Generator_ColumnPropNameInRow="___Complete" msprop:Generator_ColumnPropNameInTable="___CompleteColumn" type="xs:float" minOccurs="0" /> - <xs:element name="Total" msprop:Generator_UserColumnName="Total" msprop:Generator_ColumnVarNameInTable="columnTotal" msprop:Generator_ColumnPropNameInRow="Total" msprop:Generator_ColumnPropNameInTable="TotalColumn" type="xs:int" minOccurs="0" /> - <xs:element name="Pass_x0020_Rate" msprop:Generator_UserColumnName="Pass Rate" msprop:Generator_ColumnVarNameInTable="columnPass_Rate" msprop:Generator_ColumnPropNameInRow="Pass_Rate" msprop:Generator_ColumnPropNameInTable="Pass_RateColumn" type="xs:float" minOccurs="0" /> - <xs:element name="Pass" msprop:Generator_UserColumnName="Pass" msprop:Generator_ColumnVarNameInTable="columnPass" msprop:Generator_ColumnPropNameInRow="Pass" msprop:Generator_ColumnPropNameInTable="PassColumn" type="xs:int" minOccurs="0" /> - <xs:element name="Fail" msprop:Generator_UserColumnName="Fail" msprop:Generator_ColumnVarNameInTable="columnFail" msprop:Generator_ColumnPropNameInRow="Fail" msprop:Generator_ColumnPropNameInTable="FailColumn" type="xs:int" minOccurs="0" /> - <xs:element name="Error" msprop:Generator_UserColumnName="Error" msprop:Generator_ColumnVarNameInTable="columnError" msprop:Generator_ColumnPropNameInRow="Error" msprop:Generator_ColumnPropNameInTable="ErrorColumn" type="xs:int" minOccurs="0" /> - <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="completed" msprop:Generator_UserColumnName="completed" msprop:Generator_ColumnPropNameInRow="completed" msprop:Generator_ColumnVarNameInTable="columncompleted" msprop:Generator_ColumnPropNameInTable="completedColumn" type="xs:boolean" minOccurs="0" /> - <xs:element name="Type" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0"> + <xs:element name="_x0025__x0020_Complete" msprop:Generator_UserColumnName="% Complete" msprop:Generator_ColumnPropNameInRow="___Complete" msprop:Generator_ColumnVarNameInTable="_column__Complete" msprop:Generator_ColumnPropNameInTable="___CompleteColumn" type="xs:float" minOccurs="0" /> + <xs:element name="Total" msprop:Generator_UserColumnName="Total" msprop:Generator_ColumnPropNameInRow="Total" msprop:Generator_ColumnVarNameInTable="columnTotal" msprop:Generator_ColumnPropNameInTable="TotalColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Pass_x0020_Rate" msprop:Generator_UserColumnName="Pass Rate" msprop:Generator_ColumnPropNameInRow="Pass_Rate" msprop:Generator_ColumnVarNameInTable="columnPass_Rate" msprop:Generator_ColumnPropNameInTable="Pass_RateColumn" type="xs:float" minOccurs="0" /> + <xs:element name="Pass" msprop:Generator_UserColumnName="Pass" msprop:Generator_ColumnPropNameInRow="Pass" msprop:Generator_ColumnVarNameInTable="columnPass" msprop:Generator_ColumnPropNameInTable="PassColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Fail" msprop:Generator_UserColumnName="Fail" msprop:Generator_ColumnPropNameInRow="Fail" msprop:Generator_ColumnVarNameInTable="columnFail" msprop:Generator_ColumnPropNameInTable="FailColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Error" msprop:Generator_UserColumnName="Error" msprop:Generator_ColumnPropNameInRow="Error" msprop:Generator_ColumnVarNameInTable="columnError" msprop:Generator_ColumnPropNameInTable="ErrorColumn" type="xs:int" minOccurs="0" /> + <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="completed" msprop:Generator_UserColumnName="completed" msprop:Generator_ColumnVarNameInTable="columncompleted" msprop:Generator_ColumnPropNameInRow="completed" msprop:Generator_ColumnPropNameInTable="completedColumn" type="xs:boolean" minOccurs="0" /> + <xs:element name="Type" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> @@ -714,45 +846,45 @@ <xs:element name="WorkOrder" msprop:Generator_UserTableName="WorkOrder" msprop:Generator_RowDeletedName="WorkOrderRowDeleted" msprop:Generator_RowChangedName="WorkOrderRowChanged" msprop:Generator_RowClassName="WorkOrderRow" msprop:Generator_RowChangingName="WorkOrderRowChanging" msprop:Generator_RowEvArgName="WorkOrderRowChangeEvent" msprop:Generator_RowEvHandlerName="WorkOrderRowChangeEventHandler" msprop:Generator_TableClassName="WorkOrderDataTable" msprop:Generator_TableVarName="tableWorkOrder" msprop:Generator_RowDeletingName="WorkOrderRowDeleting" msprop:Generator_TablePropName="WorkOrder"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" /> - <xs:element name="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" 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="platform" msprop:Generator_UserColumnName="platform" msprop:Generator_ColumnVarNameInTable="columnplatform" msprop:Generator_ColumnPropNameInRow="platform" msprop:Generator_ColumnPropNameInTable="platformColumn" minOccurs="0"> + <xs:element name="platform" msprop:Generator_UserColumnName="platform" msprop:Generator_ColumnPropNameInRow="platform" msprop:Generator_ColumnVarNameInTable="columnplatform" msprop:Generator_ColumnPropNameInTable="platformColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="created" msdata:ReadOnly="true" msprop:Generator_UserColumnName="created" msprop:Generator_ColumnVarNameInTable="columncreated" msprop:Generator_ColumnPropNameInRow="created" msprop:Generator_ColumnPropNameInTable="createdColumn" type="xs:base64Binary" minOccurs="0" /> - <xs:element name="finished" msprop:Generator_UserColumnName="finished" msprop:Generator_ColumnVarNameInTable="columnfinished" msprop:Generator_ColumnPropNameInRow="finished" msprop:Generator_ColumnPropNameInTable="finishedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="userid" msprop:Generator_UserColumnName="userid" msprop:Generator_ColumnVarNameInTable="columnuserid" msprop:Generator_ColumnPropNameInRow="userid" msprop:Generator_ColumnPropNameInTable="useridColumn" minOccurs="0"> + <xs:element name="created" msdata:ReadOnly="true" msprop:Generator_UserColumnName="created" msprop:Generator_ColumnPropNameInRow="created" msprop:Generator_ColumnVarNameInTable="columncreated" msprop:Generator_ColumnPropNameInTable="createdColumn" type="xs:base64Binary" minOccurs="0" /> + <xs:element name="finished" msprop:Generator_UserColumnName="finished" msprop:Generator_ColumnPropNameInRow="finished" msprop:Generator_ColumnVarNameInTable="columnfinished" msprop:Generator_ColumnPropNameInTable="finishedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="userid" msprop:Generator_UserColumnName="userid" msprop:Generator_ColumnPropNameInRow="userid" msprop:Generator_ColumnVarNameInTable="columnuserid" msprop:Generator_ColumnPropNameInTable="useridColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="WoName" msprop:Generator_UserColumnName="WoName" msprop:Generator_ColumnPropNameInRow="WoName" msprop:Generator_ColumnVarNameInTable="columnWoName" msprop:Generator_ColumnPropNameInTable="WoNameColumn" minOccurs="0"> + <xs:element name="WoName" msprop:Generator_UserColumnName="WoName" msprop:Generator_ColumnVarNameInTable="columnWoName" msprop:Generator_ColumnPropNameInRow="WoName" msprop:Generator_ColumnPropNameInTable="WoNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> + <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="steps" msprop:Generator_UserColumnName="steps" msprop:Generator_ColumnVarNameInTable="columnsteps" msprop:Generator_ColumnPropNameInRow="steps" msprop:Generator_ColumnPropNameInTable="stepsColumn" minOccurs="0"> + <xs: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" /> @@ -765,44 +897,44 @@ <xs:element name="ActionItems" msprop:Generator_UserTableName="ActionItems" msprop:Generator_RowDeletedName="ActionItemsRowDeleted" msprop:Generator_RowChangedName="ActionItemsRowChanged" msprop:Generator_RowClassName="ActionItemsRow" msprop:Generator_RowChangingName="ActionItemsRowChanging" msprop:Generator_RowEvArgName="ActionItemsRowChangeEvent" msprop:Generator_RowEvHandlerName="ActionItemsRowChangeEventHandler" msprop:Generator_TableClassName="ActionItemsDataTable" msprop:Generator_TableVarName="tableActionItems" msprop:Generator_RowDeletingName="ActionItemsRowDeleting" msprop:Generator_TablePropName="ActionItems"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="100000" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="dateStamp" msprop:Generator_UserColumnName="dateStamp" msprop:Generator_ColumnPropNameInRow="dateStamp" msprop:Generator_ColumnVarNameInTable="columndateStamp" msprop:Generator_ColumnPropNameInTable="dateStampColumn" minOccurs="0"> + <xs:element name="dateStamp" msprop:Generator_UserColumnName="dateStamp" msprop:Generator_ColumnVarNameInTable="columndateStamp" msprop:Generator_ColumnPropNameInRow="dateStamp" msprop:Generator_ColumnPropNameInTable="dateStampColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="percentFinished" msprop:Generator_UserColumnName="percentFinished" msprop:Generator_ColumnPropNameInRow="percentFinished" msprop:Generator_ColumnVarNameInTable="columnpercentFinished" msprop:Generator_ColumnPropNameInTable="percentFinishedColumn" type="xs:int" /> - <xs:element name="state" msprop:Generator_UserColumnName="state" msprop:Generator_ColumnVarNameInTable="columnstate" msprop:Generator_ColumnPropNameInRow="state" msprop:Generator_ColumnPropNameInTable="stateColumn" minOccurs="0"> + <xs:element name="percentFinished" msprop:Generator_UserColumnName="percentFinished" msprop:Generator_ColumnVarNameInTable="columnpercentFinished" msprop:Generator_ColumnPropNameInRow="percentFinished" msprop:Generator_ColumnPropNameInTable="percentFinishedColumn" type="xs:int" /> + <xs:element name="state" msprop:Generator_UserColumnName="state" msprop:Generator_ColumnPropNameInRow="state" msprop:Generator_ColumnVarNameInTable="columnstate" msprop:Generator_ColumnPropNameInTable="stateColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="userID" msprop:Generator_UserColumnName="userID" msprop:Generator_ColumnPropNameInRow="userID" msprop:Generator_ColumnVarNameInTable="columnuserID" msprop:Generator_ColumnPropNameInTable="userIDColumn" minOccurs="0"> + <xs:element name="userID" msprop:Generator_UserColumnName="userID" msprop:Generator_ColumnVarNameInTable="columnuserID" msprop:Generator_ColumnPropNameInRow="userID" msprop:Generator_ColumnPropNameInTable="userIDColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="owner" msprop:Generator_UserColumnName="owner" msprop:Generator_ColumnPropNameInRow="owner" msprop:Generator_ColumnVarNameInTable="columnowner" msprop:Generator_ColumnPropNameInTable="ownerColumn" minOccurs="0"> + <xs:element name="owner" msprop:Generator_UserColumnName="owner" msprop:Generator_ColumnVarNameInTable="columnowner" msprop:Generator_ColumnPropNameInRow="owner" msprop:Generator_ColumnPropNameInTable="ownerColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> @@ -815,80 +947,80 @@ <xs:element name="Feature" msprop:Generator_UserTableName="Feature" msprop:Generator_RowDeletedName="FeatureRowDeleted" msprop:Generator_RowChangedName="FeatureRowChanged" msprop:Generator_RowClassName="FeatureRow" msprop:Generator_RowChangingName="FeatureRowChanging" msprop:Generator_RowEvArgName="FeatureRowChangeEvent" msprop:Generator_RowEvHandlerName="FeatureRowChangeEventHandler" msprop:Generator_TableClassName="FeatureDataTable" msprop:Generator_TableVarName="tableFeature" msprop:Generator_RowDeletingName="FeatureRowDeleting" msprop:Generator_TablePropName="Feature"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="parent_id" msprop:Generator_UserColumnName="parent_id" msprop:Generator_ColumnPropNameInRow="parent_id" msprop:Generator_ColumnVarNameInTable="columnparent_id" msprop:Generator_ColumnPropNameInTable="parent_idColumn" type="xs:int" minOccurs="0" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="parent_id" msprop:Generator_UserColumnName="parent_id" msprop:Generator_ColumnVarNameInTable="columnparent_id" msprop:Generator_ColumnPropNameInRow="parent_id" msprop:Generator_ColumnPropNameInTable="parent_idColumn" type="xs:int" minOccurs="0" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> + <xs:element name="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="25" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInTable="timeColumn" minOccurs="0"> + <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnPropNameInTable="timeColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="25" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="featureNumber" msprop:Generator_UserColumnName="featureNumber" msprop:Generator_ColumnPropNameInRow="featureNumber" msprop:Generator_ColumnVarNameInTable="columnfeatureNumber" msprop:Generator_ColumnPropNameInTable="featureNumberColumn" minOccurs="0"> + <xs:element name="featureNumber" msprop:Generator_UserColumnName="featureNumber" msprop:Generator_ColumnVarNameInTable="columnfeatureNumber" msprop:Generator_ColumnPropNameInRow="featureNumber" msprop:Generator_ColumnPropNameInTable="featureNumberColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="productID" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="productID" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Objective" msprop:Generator_UserTableName="Objective" msprop:Generator_RowDeletedName="ObjectiveRowDeleted" msprop:Generator_RowChangedName="ObjectiveRowChanged" msprop:Generator_RowClassName="ObjectiveRow" msprop:Generator_RowChangingName="ObjectiveRowChanging" msprop:Generator_RowEvArgName="ObjectiveRowChangeEvent" msprop:Generator_RowEvHandlerName="ObjectiveRowChangeEventHandler" msprop:Generator_TableClassName="ObjectiveDataTable" msprop:Generator_TableVarName="tableObjective" msprop:Generator_RowDeletingName="ObjectiveRowDeleting" msprop:Generator_TablePropName="Objective"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> + <xs:element name="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="25" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="time" msdata:ReadOnly="true" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInTable="timeColumn" minOccurs="0"> + <xs:element name="time" msdata:ReadOnly="true" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnPropNameInTable="timeColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="25" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="feature" msdata:ReadOnly="true" msprop:Generator_UserColumnName="feature" msprop:Generator_ColumnPropNameInRow="feature" msprop:Generator_ColumnVarNameInTable="columnfeature" msprop:Generator_ColumnPropNameInTable="featureColumn" minOccurs="0"> + <xs:element name="feature" msdata:ReadOnly="true" msprop:Generator_UserColumnName="feature" msprop:Generator_ColumnVarNameInTable="columnfeature" msprop:Generator_ColumnPropNameInRow="feature" msprop:Generator_ColumnPropNameInTable="featureColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> @@ -901,57 +1033,57 @@ <xs:element name="TestCase" msprop:Generator_UserTableName="TestCase" msprop:Generator_RowDeletedName="TestCaseRowDeleted" msprop:Generator_RowChangedName="TestCaseRowChanged" msprop:Generator_RowClassName="TestCaseRow" msprop:Generator_RowChangingName="TestCaseRowChanging" msprop:Generator_RowEvArgName="TestCaseRowChangeEvent" msprop:Generator_RowEvHandlerName="TestCaseRowChangeEventHandler" msprop:Generator_TableClassName="TestCaseDataTable" msprop:Generator_TableVarName="tableTestCase" msprop:Generator_RowDeletingName="TestCaseRowDeleting" msprop:Generator_TablePropName="TestCase"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="Objective" msprop:Generator_UserColumnName="Objective" msprop:Generator_ColumnPropNameInRow="Objective" msprop:Generator_ColumnVarNameInTable="columnObjective" msprop:Generator_ColumnPropNameInTable="ObjectiveColumn" minOccurs="0"> + <xs:element name="Objective" msprop:Generator_UserColumnName="Objective" msprop:Generator_ColumnVarNameInTable="columnObjective" msprop:Generator_ColumnPropNameInRow="Objective" msprop:Generator_ColumnPropNameInTable="ObjectiveColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="Feature" msprop:Generator_UserColumnName="Feature" msprop:Generator_ColumnPropNameInRow="Feature" msprop:Generator_ColumnVarNameInTable="columnFeature" msprop:Generator_ColumnPropNameInTable="FeatureColumn" minOccurs="0"> + <xs:element name="Feature" msprop:Generator_UserColumnName="Feature" msprop:Generator_ColumnVarNameInTable="columnFeature" msprop:Generator_ColumnPropNameInRow="Feature" msprop:Generator_ColumnPropNameInTable="FeatureColumn" 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_ColumnPropNameInRow="steps" msprop:Generator_ColumnVarNameInTable="columnsteps" msprop:Generator_ColumnPropNameInTable="stepsColumn" minOccurs="0"> + <xs:element name="steps" msprop:Generator_UserColumnName="steps" msprop:Generator_ColumnVarNameInTable="columnsteps" msprop:Generator_ColumnProp... [truncated message content] |
