Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [29] WebPrototype
|
From: <ro...@us...> - 2006-06-13 22:11:54
|
Revision: 29 Author: rouquin Date: 2006-06-13 15:11:30 -0700 (Tue, 13 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=29&view=rev Log Message: ----------- Created ObjectiveEdit and TestManagement and Product pages though ObjectiveEdit is the only one that's complete. Also updated TreeView so that it is populated from the database. Modified Paths: -------------- WebPrototype/ActionItemEdit.aspx.cs WebPrototype/App_Code/DummyDataSet.xsd WebPrototype/App_Code/DummyDataSet.xss WebPrototype/App_Data/ASPNETDB.MDF WebPrototype/App_Data/Database.mdf WebPrototype/App_Data/Database_log.LDF WebPrototype/App_Data/aspnetdb_log.ldf WebPrototype/MasterPage.master WebPrototype/Web.sitemap WebPrototype/WorkOrder.aspx Added Paths: ----------- WebPrototype/ObjectiveEdit.aspx WebPrototype/ObjectiveEdit.aspx.cs WebPrototype/Product.aspx WebPrototype/Product.aspx.cs WebPrototype/TestManagement.aspx WebPrototype/TestManagement.aspx.cs Modified: WebPrototype/ActionItemEdit.aspx.cs =================================================================== --- WebPrototype/ActionItemEdit.aspx.cs 2006-06-12 21:32:57 UTC (rev 28) +++ WebPrototype/ActionItemEdit.aspx.cs 2006-06-13 22:11:30 UTC (rev 29) @@ -15,13 +15,7 @@ protected void Page_Load(object sender, EventArgs e) { - ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); - src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; - src.SelectParameters.Add(new Parameter("id", TypeCode.Int32, "1")); - src.Select(); - myDS.SelectParameters["id"].DefaultValue = id.ToString(); - System.Convert.ToDateTime("06/13/2006"); } protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) { Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-12 21:32:57 UTC (rev 28) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-06-13 22:11:30 UTC (rev 29) @@ -197,7 +197,7 @@ </DbCommand> </UpdateCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateDateStampByID" Modifier="Public" Name="UpdateDateStampByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy7" UserSourceName="UpdateDateStampByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateDateStampByID" Modifier="Public" Name="UpdateDateStampByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy4" UserSourceName="UpdateDateStampByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE ActionItems @@ -212,7 +212,7 @@ </DbCommand> </UpdateCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdatePercentByID" Modifier="Public" Name="UpdatePercentByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy4" UserSourceName="UpdatePercentByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdatePercentByID" Modifier="Public" Name="UpdatePercentByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy5" UserSourceName="UpdatePercentByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE ActionItems SET percentFinished=@percentFinished WHERE id=@original_id</CommandText> @@ -225,7 +225,7 @@ </DbCommand> </UpdateCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateStateByID" Modifier="Public" Name="UpdateStateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy5" UserSourceName="UpdateStateByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateStateByID" Modifier="Public" Name="UpdateStateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy6" UserSourceName="UpdateStateByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE ActionItems @@ -240,7 +240,7 @@ </DbCommand> </UpdateCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy6" GeneratorSourceName="UpdateThreeByID" Modifier="Public" Name="UpdateThreeByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy6" UserSourceName="UpdateThreeByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy6" GeneratorSourceName="UpdateThreeByID" Modifier="Public" Name="UpdateThreeByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy7" UserSourceName="UpdateThreeByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE ActionItems @@ -308,6 +308,31 @@ <Mapping SourceColumn="Parent" DataSetColumn="Parent" /> </Mappings> <Sources> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Feature" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillFeatureData" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetFeatureData" GeneratorSourceName="FillFeatureData" GetMethodModifier="Public" GetMethodName="GetFeatureData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetFeatureData" UserSourceName="FillFeatureData"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT Feature.id, Feature.parent_id, RTRIM(Feature.name) AS name, Feature.description, Feature.[user], Feature.time, Feature.featureNumber, + RTRIM(Feature_1.name) AS Parent +FROM Feature INNER JOIN + Feature AS Feature_1 ON Feature.parent_id = Feature_1.id +WHERE (Feature.id = @id)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Feature" 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="dbo.Feature" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAllRows" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetAllRows" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAllRows" UserSourceName="GetAllRows1"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT id, RTRIM(name) AS name +FROM Feature</CommandText> + <Parameters> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> </Sources> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ObjectiveTableAdapter" GeneratorDataComponentClassName="ObjectiveTableAdapter" Name="Objective" UserDataComponentName="ObjectiveTableAdapter"> @@ -335,7 +360,7 @@ Feature ON Objective.feature = Feature.id WHERE (Objective.id= @id)</CommandText> <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="id" ColumnName="id" DataSourceName="[D:\MATTHEW\WORK\VINTELA\TCDB 2006\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="id" ColumnName="id" DataSourceName="[D:\MATTHEW\WORK\VINTELA\TCDB 2006\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> @@ -351,6 +376,98 @@ <Mapping SourceColumn="feature" DataSetColumn="feature" /> </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> + <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> + </Parameters> + </DbCommand> + </DeleteCommand> + </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Objective" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillObjectiveData" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetObjectiveData" GeneratorSourceName="FillObjectiveData" GetMethodModifier="Public" GetMethodName="GetObjectiveData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetObjectiveData" UserSourceName="FillObjectiveData"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT Objective.id, Objective.name, Objective.description, Objective.[user],Objective.time, Objective.feature, RTRIM(Feature.name) AS featureName +FROM Objective INNER JOIN + Feature ON Objective.feature = Feature.id +WHERE (Objective.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" 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="True"> + <CommandText>INSERT INTO Objective + (name, description, [user]) +VALUES (@name,@description,@user)</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> + <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> + </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 time +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"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE Objective +SET name = @name, description = @description, [user] = @user +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.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> + <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> + <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" 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> + <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> </Sources> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TestCaseTableAdapter" GeneratorDataComponentClassName="TestCaseTableAdapter" Name="TestCase" UserDataComponentName="TestCaseTableAdapter"> @@ -418,6 +535,37 @@ <Sources> </Sources> </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="Fill"> + <InsertCommand> + <DbCommand CommandType="Text" ModifiedByUser="False"> + <CommandText>INSERT INTO [Products] ([id], [Name]) VALUES (@id, @Name)</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> + <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> + </Parameters> + </DbCommand> + </InsertCommand> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT id, Name +FROM Products</CommandText> + <Parameters> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="id" DataSetColumn="id" /> + <Mapping SourceColumn="Name" DataSetColumn="Name" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> </Tables> <Sources> </Sources> @@ -739,6 +887,20 @@ </xs:sequence> </xs:complexType> </xs:element> + <xs:element name="Products" msprop:Generator_UserTableName="Products" msprop:Generator_RowDeletedName="ProductsRowDeleted" msprop:Generator_TableClassName="ProductsDataTable" msprop:Generator_RowChangedName="ProductsRowChanged" msprop:Generator_RowClassName="ProductsRow" msprop:Generator_RowChangingName="ProductsRowChanging" msprop:Generator_RowEvArgName="ProductsRowChangeEvent" msprop:Generator_RowEvHandlerName="ProductsRowChangeEventHandler" msprop:Generator_TablePropName="Products" msprop:Generator_TableVarName="tableProducts" msprop:Generator_RowDeletingName="ProductsRowDeleting"> + <xs:complexType> + <xs:sequence> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="50" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + </xs:sequence> + </xs:complexType> + </xs:element> </xs:choice> </xs:complexType> <xs:unique name="Constraint1" msdata:PrimaryKey="true"> Modified: WebPrototype/App_Code/DummyDataSet.xss =================================================================== --- WebPrototype/App_Code/DummyDataSet.xss 2006-06-12 21:32:57 UTC (rev 28) +++ WebPrototype/App_Code/DummyDataSet.xss 2006-06-13 22:11:30 UTC (rev 29) @@ -4,15 +4,16 @@ Changes to this file may cause incorrect behavior and will be lost if the code is regenerated. </autogenerated>--> -<DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="54" ViewPortY="-10" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout"> +<DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="-10" ViewPortY="7" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout"> <Shapes> - <Shape ID="DesignTable:Assignments" ZOrder="7" X="70" Y="70" Height="275" Width="239" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="228" /> - <Shape ID="DesignTable:WorkOrder" ZOrder="6" X="370" Y="311" Height="207" Width="204" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="22" SplitterPosition="160" /> - <Shape ID="DesignTable:ActionItems" ZOrder="1" X="424" Y="17" Height="275" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="22" OldDataTableHeight="22" SplitterPosition="160" /> - <Shape ID="DesignTable:Feature" ZOrder="5" X="111" Y="368" Height="207" Width="185" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="160" /> - <Shape ID="DesignTable:Objective" ZOrder="4" X="845" Y="115" Height="173" Width="195" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" /> - <Shape ID="DesignTable:TestCase" ZOrder="3" X="623" Y="349" Height="224" Width="192" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="177" /> - <Shape ID="DesignTable:Tags" ZOrder="2" X="937" Y="377" Height="105" Width="183" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="58" /> + <Shape ID="DesignTable:Assignments" ZOrder="8" X="13" Y="20" Height="275" Width="239" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="228" /> + <Shape ID="DesignTable:WorkOrder" ZOrder="7" X="282" Y="314" Height="207" Width="204" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="22" SplitterPosition="160" /> + <Shape ID="DesignTable:ActionItems" ZOrder="2" X="286" Y="21" Height="275" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="22" OldDataTableHeight="22" SplitterPosition="160" /> + <Shape ID="DesignTable:Feature" ZOrder="6" X="24" Y="309" Height="241" Width="229" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="160" /> + <Shape ID="DesignTable:Objective" ZOrder="5" X="608" Y="25" Height="241" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="22" OldDataTableHeight="0" SplitterPosition="126" /> + <Shape ID="DesignTable:TestCase" ZOrder="4" X="512" Y="315" Height="224" Width="192" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="177" /> + <Shape ID="DesignTable:Tags" ZOrder="3" X="727" Y="316" Height="105" Width="183" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="58" /> + <Shape ID="DesignTable:Products" ZOrder="1" X="967" Y="61" Height="105" Width="192" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="58" /> </Shapes> <Connectors /> </DiagramLayout> \ No newline at end of file Modified: WebPrototype/App_Data/ASPNETDB.MDF =================================================================== (Binary files differ) Modified: WebPrototype/App_Data/Database.mdf =================================================================== (Binary files differ) Modified: WebPrototype/App_Data/Database_log.LDF =================================================================== (Binary files differ) Modified: WebPrototype/App_Data/aspnetdb_log.ldf =================================================================== (Binary files differ) Modified: WebPrototype/MasterPage.master =================================================================== --- WebPrototype/MasterPage.master 2006-06-12 21:32:57 UTC (rev 28) +++ WebPrototype/MasterPage.master 2006-06-13 22:11:30 UTC (rev 29) @@ -29,7 +29,7 @@ VSM | 1.1 | Alpha | 134</div> <div id="tasks"> <a href="Assignments.aspx" class="header">Assignments</a> | <a href="Execution.aspx" - class="header">Execution</a> | <a href="Management.aspx" class="header">Test Management</a> + class="header">Execution</a> | <a href="TestManagement.aspx" class="header">Test Management</a> </div> </div> </div> Added: WebPrototype/ObjectiveEdit.aspx =================================================================== --- WebPrototype/ObjectiveEdit.aspx (rev 0) +++ WebPrototype/ObjectiveEdit.aspx 2006-06-13 22:11:30 UTC (rev 29) @@ -0,0 +1,317 @@ +<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" + CodeFile="ObjectiveEdit.aspx.cs" Inherits="ObjectiveEdit" Title="Objective" ValidateRequest="false" %> + +<%@ Register Assembly="EclipseWebSolutions.CustomControls" Namespace="EclipseWebSolutions.CustomControls" + TagPrefix="cc1" %> + +<%@ Register Assembly="FreeTextBox" Namespace="FreeTextBoxControls" TagPrefix="FTB" %> +<%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="atlas" %> +<asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> + <asp:Label ID="lblID" runat="server" Text="1" Visible="false"></asp:Label> + <table border="0" cellpadding="0" cellspacing="0" width="100%"> + <tr> + <td valign="top" width="10px" style="padding-right: 30px;"> + <asp:TreeView ID="TreeView1" runat="server" + SelectedNodeStyle-CssClass="selectednode" + OnTreeNodePopulate=TreeView1_TreeNodePopulate> + <SelectedNodeStyle CssClass="selectednode" /> + <Nodes> + <asp:TreeNode + Text="Project" + SelectAction="Expand" + NavigateUrl="~/TestManagement.aspx" + PopulateOnDemand="true" /> + </Nodes> + </asp:TreeView> + </td> + <td width="*" valign="top"> + <div id="Objective"> + <asp:FormView ID=FormView1 runat="server" DataKeyNames="id" DataSourceID=myDS Width=574px OnDataBound=FormView1_DataBound OnItemInserted=FormView1_ItemInserted OnItemUpdated=FormView1_ItemUpdated> + <HeaderTemplate> + <h2>Objective</h2> + </HeaderTemplate> + <ItemTemplate> + <table width="700"> + <tr> + <td colspan="2"> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <table width="100%"> + <tr> + <td colspan="2" align="left" style="width: 60%"> + <h3> + <asp:Label ID="Label1" runat="server" Text='<%# Eval("name") %>'></asp:Label></h3> + </td> + <td align="right" width="40%"> + <asp:Label ID="Label2" runat="server" Text='<%# Eval("time") %>'></asp:Label></td> + </tr> + <tr> + <td colspan="3"> + Feature: + <asp:LinkButton ID="ViewFeature" runat="server" Text='<%# Eval("featureName") %>' PostBackUrl="~/Feature.aspx"></asp:LinkButton><br /> + </td> + </tr> + <tr> + <td colspan="3" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan="3"> + <div id="ObjectiveData"> + <asp:Label ID="Label3" runat="server" Text='<%# Eval("description") %>'></asp:Label></div> + </td> + </tr> + <tr> + <td colspan="3" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td align="left" style="width: 25%"> + <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" + Text="Edit"> + </asp:LinkButton>| + <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" + Text="New"> + </asp:LinkButton>| + <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" + Text="Delete"> + </asp:LinkButton>|</td> + <td colspan="2" align="right" style="width: 60%"> + Authored by: + <asp:Label ID="Label4" runat="server" Text='<%# Eval("user") %>'></asp:Label></td> + </tr> + </table> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </td> + </tr> + </table> + </ItemTemplate> + <EditItemTemplate> + <table cellpadding="0" cellspacing="0" border="0" width="100%"> + <tr> + <td colspan="2"> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <table cellpadding="0" cellspacing="0" border="0" width="100%"> + <tr> + <td align="left"> + <h3> + Name: <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width=401px></asp:TextBox> + </h3> + </td> + <td align="right" style="width: 157px"> + Date:<cc1:DatePicker ID="DatePicker1" runat="server" OnInit=DatePicker1_Init /> + + </td> + </tr> + <tr> + <td colspan="2"> + <br /> + Feature: <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="featureData" + DataTextField="name" DataValueField="id" AppendDataBoundItems=True> + <asp:ListItem Selected="True" /> + </asp:DropDownList><asp:ObjectDataSource ID="featureData" runat="server" + OldValuesParameterFormatString="original_{0}" SelectMethod="GetAllRows" + TypeName="DummyDataSetTableAdapters.FeatureTableAdapter"> + </asp:ObjectDataSource> + <br /> + </td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + <div id="ObjectiveData"> + Description:<br /> + <FTB:FreeTextBox ID="FreeTextBox1" runat="server" SupportFolder="~/aspnet_client/FreeTextBox/" + Text='<%# Bind("description", "{0}") %>' Width="600px"> + </FTB:FreeTextBox> + </div> + <table cellpadding="0" cellspacing="0" border="0" width="100%" style="padding-top: 10px;"> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td width="25%" align="left"> + <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" + Text="Update"> + </asp:LinkButton> + <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" + Text="Cancel"> + </asp:LinkButton></td> + <td width="75%" align="right"> + Authored by: + <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("user") %>'></asp:TextBox> + </td> + </tr> + </table> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </td> + </tr> + </table> + </EditItemTemplate> + <InsertItemTemplate> + <table cellpadding="0" cellspacing="0" border="0" width="100%"> + <tr> + <td colspan="2"> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <table cellpadding="0" cellspacing="0" border="0" width="100%"> + <tr> + <td align="left"> + <h3> + Name: <asp:TextBox ID="InsertNameTextBox" runat="server" Text='<%# Bind("name") %>' Width=401px></asp:TextBox> + </h3> + </td> + <td align="right" style="width: 157px"> + Date:<cc1:DatePicker ID="DatePicker2" runat="server" /> + + </td> + </tr> + <tr> + <td colspan="2"> + <br /> + Feature: <asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="featureData" + DataTextField="name" DataValueField="id" AppendDataBoundItems=True> + <asp:ListItem Selected="True" /> + </asp:DropDownList><asp:ObjectDataSource ID="featureData" runat="server" + OldValuesParameterFormatString="original_{0}" SelectMethod="GetAllRows" + TypeName="DummyDataSetTableAdapters.FeatureTableAdapter"> + </asp:ObjectDataSource> + <br /> + </td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + <div id="ObjectiveData"> + Description:<br /> + <FTB:FreeTextBox ID="FreeTextBox2" runat="server" SupportFolder="~/aspnet_client/FreeTextBox/" + Text='<%# Bind("description", "{0}") %>' Width="600px"> + </FTB:FreeTextBox> + </div> + <table cellpadding="0" cellspacing="0" border="0" width="100%" style="padding-top: 10px;"> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td width="25%" align="left"> + <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" + Text="Insert"></asp:LinkButton> + <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" + Text="Cancel"> + </asp:LinkButton></td> + <td width="75%" align="right"> + Authored by: + <asp:TextBox ID="InsertUserTextBox" runat="server" Text='<%# Bind("user") %>'></asp:TextBox> + </td> + </tr> + </table> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </td> + </tr> + </table> + </InsertItemTemplate> + </asp:FormView> + </div> + </td> + <asp:ObjectDataSource ID="myDS" runat="server" OldValuesParameterFormatString="original_{0}" + SelectMethod="GetObjectiveData" TypeName="DummyDataSetTableAdapters.ObjectiveTableAdapter" + DeleteMethod="DeleteByID" InsertMethod="InsertAll" UpdateMethod=UpdateByID> + <SelectParameters> + <asp:Parameter Name="id" Type="Int32" /> + </SelectParameters> + <DeleteParameters> + <asp:Parameter Name="original_id" Type="Int32" /> + </DeleteParameters> + <InsertParameters> + <asp:Parameter Name="name" Type="String" /> + <asp:Parameter Name="description" Type="String" /> + <asp:Parameter Name="user" Type="String" /> + </InsertParameters> + <UpdateParameters> + <asp:Parameter Name="name" Type="String" /> + <asp:Parameter Name="description" Type="String" /> + <asp:Parameter Name="user" Type="String" /> + <asp:Parameter Name="original_id" Type="Int32" /> + </UpdateParameters> + </asp:ObjectDataSource> + <td width="300px" align="right" valign="top"> + <table width="100%" cellpadding="0" cellspacing="0" border="0" style="padding: 10px;"> + <tr> + <td width="100%"> + <b class="notetop"><b class="noteb1"></b><b class="noteb2"></b><b class="noteb3"></b> + <b class="noteb4"></b></b> + <div class="noteboxcontent"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <asp:Panel ID="Panel3" runat="server" CssClass="collapsePanelHeader"> + <td align="left" valign="bottom"> + <h4> + Reminder:</h4> + 15 Apr 2006 </td> + <td align="right" valign="bottom"> + <img alt="Note2Arrow" src="App_Themes/Python/Images/ArrowUp.gif" id="Note2Arrow" /> + <a href="#" class="notedelete">x</a></td> + </asp:Panel> + </tr> + </table> + <atlas:CollapsiblePanelExtender ID="CollapsiblePanelExtender2" runat="server"> + <atlas:CollapsiblePanelProperties Collapsed="true" SuppressPostBack="true" CollapseControlID="Note2Arrow" + ExpandControlID="Note2Arrow" ExpandedImage="App_Themes/Python/Images/ArrowUp.gif" + CollapsedImage="App_Themes/Python/Images/ArrowDown.gif" TargetControlID="Note2Content" + AutoCollapse="false" AutoExpand="false" CollapsedSize="0" ImageControlID="Note2Arrow" /> + </atlas:CollapsiblePanelExtender> + <asp:Panel ID="Note2Content" runat="server" Height="0" Style="overflow: hidden; padding: 0px; + margin: 0px;"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <td class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + Integer lacus elit, consectetuer nec, rutrum at, pretium ac, risus. Sed semper massa + luctus mi. Donec placerat, diam vitae ultricies posuere, felis dui sollicitudin + nibh, eget blandit purus libero in elit. Aenean eget lectus eget ipsum rutrum scelerisque. + Nunc orci mauris, rhoncus ac, pellentesque sit amet, condimentum vel, nibh. Pellentesque + habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. + Suspendisse blandit. + </asp:Panel> + </div> + <b class="notebottom"><b class="noteb4"></b><b class="noteb3"></b><b class="noteb2"> + </b></b><b class="noteb1"></b></td> + </tr> + </table> + <div style="padding-left: 10px; text-align: left;"> + <a href="#" style="padding-left: 10px; text-align: left;">New Note</a></div> + </td> + </tr> + </table> +</asp:Content> Added: WebPrototype/ObjectiveEdit.aspx.cs =================================================================== --- WebPrototype/ObjectiveEdit.aspx.cs (rev 0) +++ WebPrototype/ObjectiveEdit.aspx.cs 2006-06-13 22:11:30 UTC (rev 29) @@ -0,0 +1,297 @@ +using System; +using System.Data; +using System.Configuration; +using System.Collections; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; +using System.Data.SqlClient; + + +public partial class ObjectiveEdit : System.Web.UI.Page +{ + int id = System.Convert.ToInt32(HttpContext.Current.Request.QueryString["id"]); + SqlConnection DBConnection = new System.Data.SqlClient.SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;User Instance=True"); + + protected void Page_Load(object sender, EventArgs e) + { + myDS.SelectParameters["id"].DefaultValue = id.ToString(); + } + + protected void FormView1_DataBound(object sender, EventArgs e) + { + FormView fw = (FormView)sender; + DropDownList ddl = (DropDownList)fw.FindControl("DropDownList1"); + + if (fw.CurrentMode == FormViewMode.Edit) + { + // Get the data item bound to the FormView control. + DataRowView rowView = (DataRowView)fw.DataItem; + if (rowView["feature"] != null) + ddl.SelectedValue = System.Convert.ToString(rowView["feature"]); + else + { + ddl.SelectedIndex = 0; + } + } + } + protected void FormView1_ItemInserted(object sender, FormViewInsertedEventArgs e) + { + FormView fw = (FormView)sender; + DropDownList ddl = (DropDownList)fw.FindControl("DropDownList2"); + EclipseWebSolutions.CustomControls.DatePicker dp = (EclipseWebSolutions.CustomControls.DatePicker)fw.FindControl("DatePicker2"); + ObjectDataSource src = new ObjectDataSource("Objectives", "GetAllData"); + + src.TypeName = "DummyDataSetTableAdapters.ObjectiveTableAdapter"; + src.UpdateMethod = "UpdateFeature"; + src.UpdateParameters.Add(new Parameter("feature", TypeCode.Int32, ddl.SelectedValue)); + src.UpdateParameters.Add(new Parameter("time", TypeCode.String, dp.DateValue.ToString(dp.DateFormatString))); + src.UpdateParameters.Add(new Parameter("original_id", TypeCode.Int32, id.ToString())); + src.Update(); + } + protected void DatePicker1_Init(object sender, EventArgs e) + { + EclipseWebSolutions.CustomControls.DatePicker dp = (EclipseWebSolutions.CustomControls.DatePicker)sender; + ObjectDataSource src = new ObjectDataSource("Objectives", "GetAllData"); + + src.TypeName = "DummyDataSetTableAdapters.ObjectiveTableAdapter"; + src.SelectMethod = "objectiveDateQuery"; + src.SelectParameters.Add(new Parameter(... [truncated message content] |
