Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [27] WebPrototype
|
From: <ro...@us...> - 2006-06-12 19:15:47
|
Revision: 27 Author: rouquin Date: 2006-06-12 12:15:21 -0700 (Mon, 12 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=27&view=rev Log Message: ----------- Added a DatePicker and fixed some database bugs I ran into. Modified Paths: -------------- WebPrototype/ActionItemEdit.aspx 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 Added Paths: ----------- WebPrototype/Bin/EclipseWebSolutions.CustomControls.dll Modified: WebPrototype/ActionItemEdit.aspx =================================================================== --- WebPrototype/ActionItemEdit.aspx 2006-06-09 21:20:34 UTC (rev 26) +++ WebPrototype/ActionItemEdit.aspx 2006-06-12 19:15:21 UTC (rev 27) @@ -2,6 +2,9 @@ ValidateRequest="false" CodeFile="ActionItemEdit.aspx.cs" Inherits="ActionItemEdit" Title="Action Item" %> +<%@ 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"> @@ -10,7 +13,7 @@ <tr> <td width="*" valign="top"> <asp:FormView ID="FormView1" runat="server" DataSourceID="myDS" DataKeyNames="id" - CellPadding=4 ForeColor="#333333" Height=348px> + CellPadding=4 ForeColor="#333333" Height=348px OnItemUpdated=FormView1_ItemUpdated OnItemInserted=FormView1_ItemInserted> <EditItemTemplate> <div class="xsnazzy"> <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> @@ -20,11 +23,13 @@ <tr> <td colspan="2" style="width: 239px; height: 11px;"> Name: <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width="100%" /></td> - <td align=right colspan=1 style="width: 576px; height: 11px"> - </td> - <td colspan="1" style="width: 576px; height: 11px;" align="right"> + <td align=right colspan=2 style="height: 11px"> + Due Date: + <cc1:DatePicker + ID="DatePicker1" + runat="server" + DateFormatString="MM/dd/yyyy" OnInit=DatePicker1_Init/> - Due Date: <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("dateStamp") %>' Width=81px /> </td> </tr> <tr> @@ -55,7 +60,7 @@ </td> <td align=right colspan=1 style="width: 576px; height: 23px"> Assigned To: - <asp:TextBox ID="assignedToTextBox" runat="server" Text='<%# Bind("assignedTo") %>'></asp:TextBox> </td> + <asp:TextBox ID="ownerTextBox" runat="server" Text='<%# Bind("owner") %>'></asp:TextBox> </td> <td colspan=1 style="width: 576px; height: 23px" align=right> Assigned By:<asp:TextBox ID="userIDTextBox" runat="server" Text='<%# Bind("userID") %>'></asp:TextBox></td> </tr> @@ -72,31 +77,31 @@ <div class="xboxcontent"> <table> <tr> - <td colspan=2 style="width: 3048px; height: 19px;"> + <td colspan=3 style="width: 3048px; height: 19px;"> <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' Style="font-size: large; color: black; font-family: Arial;"></asp:Label> </td> - <td align=right colspan=2 style="height: 19px"> + <td align=right colspan=2 style="height: 19px; width: 179px;"> Due Date: <asp:Label ID="dateStampLabel" runat="server" Text='<%# Eval("dateStamp") %>'></asp:Label></td> </tr> <tr> - <td colspan="4" class="hr"> + <td colspan="5" class="hr"> <img alt="" src="images/spacer.gif" height="5" /><br /> </td> </tr> <tr> - <td colspan=4 style="height: 197px" valign=top> + <td colspan=5 style="height: 197px" valign=top> <asp:Label ID="descriptionLabel" runat="server" Text='<%# Eval("description") %>'></asp:Label> </td> </tr> <tr> - <td colspan="4" class="hr" style="height: 1px"> + <td colspan="5" class="hr" style="height: 1px"> <img alt="" src="images/spacer.gif" height="5" /><br /> </td> </tr> <tr> - <td colspan=1 style="height: 16px; width: 3048px;"> + <td colspan=1 style="height: 16px; width: 15%;"> <br /> <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"> @@ -107,10 +112,12 @@ <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete"> </asp:LinkButton>| </td> - <td align=right colspan=1 style="width: 1217px; height: 16px"> + <td align=right colspan=1 style="width: 25%; height: 16px"> + </td> + <td align=right colspan=1 style="width: 25%; height: 16px"> Assigned To: - <asp:Label ID="Label1" runat="server" Text='<%# Eval("assignedTo", "{0}") %>'></asp:Label></td> - <td colspan=1 style="width: 594px; height: 16px" align=right> + <asp:Label ID="Label1" runat="server" Text='<%# Eval("owner") %>'></asp:Label></td> + <td colspan=1 style="width: 25%; height: 16px" align=right> Assigned By:<asp:Label ID="userIDLabel" runat="server" Text='<%# Eval("userID") %>'></asp:Label></td> </tr> </table> @@ -161,8 +168,8 @@ <td align=right colspan=1 style="width: 576px; height: 11px"> </td> <td colspan="1" style="width: 576px; height: 11px;" align="right"> - Due Date: - <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("dateStamp") %>' Width=81px /> + Due Date:<cc1:DatePicker ID="DatePicker2" runat="server" /> + </td> </tr> <tr> @@ -192,7 +199,7 @@ </td> <td align=right colspan=1 style="width: 576px; height: 23px"> Assigned To: - <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("assignedTo", "{0}") %>'></asp:TextBox> </td> + <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("owner", "{0}") %>'></asp:TextBox> </td> <td colspan=1 style="width: 576px; height: 23px" align=right> Assigned By: <asp:TextBox ID="TextBoxuserID" runat="server" Text='<%# Bind("userID") %>'></asp:TextBox></td> @@ -204,34 +211,38 @@ </div> </InsertItemTemplate> </asp:FormView> - </td> - <asp:ObjectDataSource ID="myDS" runat="server" SelectMethod="GetDummyActionItemData" - TypeName="DummyDataSetTableAdapters.ActionItemsTableAdapter" InsertMethod="InsertAll" - DeleteMethod="DeleteById" OldValuesParameterFormatString="original_{0}" 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="userID" Type="String" /> - <asp:Parameter Name="dateStamp" Type="String" /> - <asp:Parameter Name="percentFinished" Type="Int32" /> - <asp:Parameter Name="state" Type="String" /> - <asp:Parameter Name="assignedTo" Type="String" /> - </InsertParameters> - <UpdateParameters> - <asp:Parameter Name="name" Type="String" /> - <asp:Parameter Name="description" Type="String" /> - <asp:Parameter Name="userID" Type="String" /> - <asp:Parameter Name="dateStamp" Type="String" /> - <asp:Parameter Name="assignedTo" Type="String" /> - <asp:Parameter Name="original_ID" Type="Int32" /> - </UpdateParameters> - </asp:ObjectDataSource> + <asp:ObjectDataSource + ID="myDS" + runat="server" + DeleteMethod="DeleteById" + InsertMethod="InsertAll" + OldValuesParameterFormatString="original_{0}" + SelectMethod="GetDummyActionItemData" + TypeName="DummyDataSetTableAdapters.ActionItemsTableAdapter" + UpdateMethod="UpdateByID"> + <DeleteParameters> + <asp:Parameter Name="original_id" Type="Int32" /> + </DeleteParameters> + <UpdateParameters> + <asp:Parameter Name="name" Type="String" /> + <asp:Parameter Name="description" Type="String" /> + <asp:Parameter Name="userID" Type="String" /> + <asp:Parameter Name="owner" Type="String" /> + <asp:Parameter Name="original_ID" Type="Int32" /> + </UpdateParameters> + <SelectParameters> + <asp:Parameter DefaultValue="0" Name="id" Type="Int32" /> + </SelectParameters> + <InsertParameters> + <asp:Parameter Name="name" Type="String" /> + <asp:Parameter Name="description" Type="String" /> + <asp:Parameter Name="userID" Type="String" /> + <asp:Parameter Name="percentFinished" Type="Int32" /> + <asp:Parameter Name="state" Type="Int32" /> + <asp:Parameter Name="owner" Type="String" /> + </InsertParameters> + </asp:ObjectDataSource> + </td> <td width="300px" align="right" valign="top"> <table width="100%" cellpadding="0" cellspacing="0" border="0" style="padding: 10px;"> <tr> Modified: WebPrototype/ActionItemEdit.aspx.cs =================================================================== --- WebPrototype/ActionItemEdit.aspx.cs 2006-06-09 21:20:34 UTC (rev 26) +++ WebPrototype/ActionItemEdit.aspx.cs 2006-06-12 19:15:21 UTC (rev 27) @@ -21,10 +21,13 @@ src.Select(); myDS.SelectParameters["id"].DefaultValue = id.ToString(); + System.Convert.ToDateTime("06/13/2006"); } protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) { - RadioButtonList rbl = (RadioButtonList) FormView1.FindControl("RadioButtonList1"); + if (FormView1.CurrentMode == FormViewMode.Insert) return; + + RadioButtonList rbl = (RadioButtonList) sender; ObjectDataSource src = new ObjectDataSource("ActionItems","GetDummyActionItemData"); src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; @@ -35,7 +38,9 @@ } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { - DropDownList ddl = (DropDownList)FormView1.FindControl("DropDownList1"); + if (FormView1.CurrentMode == FormViewMode.Insert) return; + + DropDownList ddl = (DropDownList)sender; ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; @@ -44,4 +49,49 @@ 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("ActionItems", "GetDummyActionItemData"); + + src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.SelectMethod = "dateQuery"; + src.SelectParameters.Add(new Parameter("id", TypeCode.Int32, id.ToString())); + IEnumerable obj = src.Select(); + IEnumerator num = null; + DateTime dt; + if (obj != null) + { + num = src.Select().GetEnumerator(); + num.MoveNext(); + dt = System.Convert.ToDateTime(num.Current); + dp.DateValue = dt; + } + } + protected void FormView1_ItemUpdated(object sender, FormViewUpdatedEventArgs e) + { + EclipseWebSolutions.CustomControls.DatePicker dp = (EclipseWebSolutions.CustomControls.DatePicker)FormView1.FindControl("DatePicker1"); + ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); + + src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.UpdateMethod = "UpdateDateStampByID"; + src.UpdateParameters.Add(new Parameter("dateStamp", TypeCode.String, dp.DateValue.ToString(dp.DateFormatString))); + src.UpdateParameters.Add(new Parameter("original_id", TypeCode.Int32, id.ToString())); + src.Update(); + } + protected void FormView1_ItemInserted(object sender, FormViewInsertedEventArgs e) + { + EclipseWebSolutions.CustomControls.DatePicker dp = (EclipseWebSolutions.CustomControls.DatePicker)FormView1.FindControl("DatePicker2"); + DropDownList ddl = (DropDownList)FormView1.FindControl("DropDownList1"); + RadioButtonList rbl = (RadioButtonList)FormView1.FindControl("RadioButtonList1"); + ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); + + src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.UpdateMethod = "UpdateThreeByID"; + src.UpdateParameters.Add(new Parameter("dateStamp", TypeCode.String, dp.DateValue.ToString(dp.DateFormatString))); + src.UpdateParameters.Add(new Parameter("percentFinished", TypeCode.Int32, rbl.SelectedIndex.ToString())); + src.UpdateParameters.Add(new Parameter("state", TypeCode.String, ddl.SelectedValue)); + src.Update(); + Response.Redirect("~/Assignments.aspx"); + } } Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-09 21:20:34 UTC (rev 26) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-06-12 19:15:21 UTC (rev 27) @@ -106,7 +106,7 @@ <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.ActionItems" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillDummyActionItemData" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetDummyActionItemData" GeneratorSourceName="FillDummyActionItemData" GetMethodModifier="Public" GetMethodName="GetDummyActionItemData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyActionItemData" UserSourceName="FillDummyActionItemData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT id, name, description, userID, dateStamp, percentFinished, state, assignedTo + <CommandText>SELECT id, name, description, userID, dateStamp, percentFinished, state, owner FROM ActionItems WHERE (id = @id)</CommandText> <Parameters> @@ -125,10 +125,23 @@ <Mapping SourceColumn="percentFinished" DataSetColumn="percentFinished" /> <Mapping SourceColumn="state" DataSetColumn="state" /> <Mapping SourceColumn="userID" DataSetColumn="userID" /> - <Mapping SourceColumn="assignedTo" DataSetColumn="assignedTo" /> + <Mapping SourceColumn="owner" DataSetColumn="owner" /> </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"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.ActionItems" DbObjectType="Table" GenerateShortCommands="True" GeneratorSourceName="dateQuery" Modifier="Public" Name="dateQuery" QueryType="Scalar" ScalarCallRetval="System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="dateQuery"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT dateStamp +FROM ActionItems +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.ActionItems" 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="DeleteById" Modifier="Public" Name="DeleteById" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="DeleteById"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>DELETE FROM ActionItems @@ -140,12 +153,12 @@ </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"> + <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="GetDataBy2" UserSourceName="InsertAll"> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>INSERT INTO ActionItems - (name, description, userID, dateStamp, percentFinished, state, assignedTo) -VALUES (@name,@description,@userID,@dateStamp,@percentFinished,@state,@assignedTo)</CommandText> + (name, description, userID, percentFinished, state, owner) +VALUES (@name,@description,@userID,@percentFinished,@state,@owner)</CommandText> <Parameters> <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(255)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="255" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> @@ -153,23 +166,21 @@ </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="userID" ColumnName="userID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(50)" DbType="String" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="NChar" Scale="0" Size="50" SourceColumn="userID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="dateStamp" ColumnName="dateStamp" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="dateStamp" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="percentFinished" ColumnName="percentFinished" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="percentFinished" ColumnName="percentFinished" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="state" ColumnName="state" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@state" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="state" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="assignedTo" ColumnName="assignedTo" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@assignedTo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="assignedTo" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="owner" ColumnName="owner" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@owner" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="owner" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> </Parameters> </DbCommand> </InsertCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="UpdateByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="UpdateByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE ActionItems -SET name = @name, description = @description, userID = @userID, dateStamp = @dateStamp, assignedTo = @assignedTo +SET name = @name, description = @description, userID = @userID, owner = @owner 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.ActionItems" DataTypeServer="nchar(255)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="255" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> @@ -178,22 +189,35 @@ </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="userID" ColumnName="userID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(50)" DbType="String" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="NChar" Scale="0" Size="50" SourceColumn="userID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="dateStamp" ColumnName="dateStamp" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="dateStamp" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="owner" ColumnName="owner" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@owner" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="owner" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="assignedTo" ColumnName="assignedTo" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@assignedTo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="assignedTo" 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.ActionItems" 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="UpdatePercentByID" Modifier="Public" Name="UpdatePercentByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="UpdatePercentByID"> + <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"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE ActionItems +SET dateStamp = @dateStamp +WHERE (id = @original_id)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="dateStamp" ColumnName="dateStamp" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dateStamp" 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.ActionItems" 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="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"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE ActionItems SET percentFinished=@percentFinished WHERE id=@original_id</CommandText> <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="percentFinished" ColumnName="percentFinished" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="percentFinished" ColumnName="percentFinished" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="percentFinished" 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.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original"> </Parameter> @@ -201,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="GetDataBy4" 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="GetDataBy5" UserSourceName="UpdateStateByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE ActionItems @@ -216,6 +240,25 @@ </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"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE ActionItems +SET dateStamp = @dateStamp, percentFinished = @percentFinished, state = @state +WHERE (id IN + (SELECT MAX(id) AS Expr1 + FROM ActionItems AS ActionItems_1))</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="dateStamp" ColumnName="dateStamp" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dateStamp" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="False" AutogeneratedName="percentFinished" ColumnName="percentFinished" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="state" ColumnName="state" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@state" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="state" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </UpdateCommand> + </DbSource> </Sources> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FeatureTableAdapter" GeneratorDataComponentClassName="FeatureTableAdapter" Name="Feature" UserDataComponentName="FeatureTableAdapter"> @@ -498,11 +541,11 @@ <xs:element name="dateStamp" msprop:Generator_UserColumnName="dateStamp" msprop:Generator_ColumnPropNameInRow="dateStamp" msprop:Generator_ColumnVarNameInTable="columndateStamp" msprop:Generator_ColumnPropNameInTable="dateStampColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> - <xs:maxLength value="20" /> + <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" minOccurs="0" /> + <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:simpleType> <xs:restriction base="xs:string"> @@ -517,10 +560,10 @@ </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="assignedTo" msprop:Generator_UserColumnName="assignedTo" msprop:Generator_ColumnPropNameInRow="assignedTo" msprop:Generator_ColumnVarNameInTable="columnassignedTo" msprop:Generator_ColumnPropNameInTable="assignedToColumn" minOccurs="0"> + <xs:element name="owner" msprop:Generator_UserColumnName="owner" msprop:Generator_ColumnPropNameInRow="owner" msprop:Generator_ColumnVarNameInTable="columnowner" msprop:Generator_ColumnPropNameInTable="ownerColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> - <xs:maxLength value="10" /> + <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> Modified: WebPrototype/App_Code/DummyDataSet.xss =================================================================== --- WebPrototype/App_Code/DummyDataSet.xss 2006-06-09 21:20:34 UTC (rev 26) +++ WebPrototype/App_Code/DummyDataSet.xss 2006-06-12 19:15:21 UTC (rev 27) @@ -4,15 +4,15 @@ 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="55" 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="54" ViewPortY="-10" 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="5" X="425" Y="15" Height="275" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="22" OldDataTableHeight="22" SplitterPosition="160" /> - <Shape ID="DesignTable:Feature" ZOrder="4" X="111" Y="368" Height="207" Width="185" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="160" /> - <Shape ID="DesignTable:Objective" ZOrder="3" X="845" Y="115" Height="173" Width="195" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" /> - <Shape ID="DesignTable:TestCase" ZOrder="2" X="623" Y="349" Height="224" Width="192" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="177" /> - <Shape ID="DesignTable:Tags" ZOrder="1" X="937" Y="377" Height="105" Width="183" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="58" /> + <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" /> </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) Added: WebPrototype/Bin/EclipseWebSolutions.CustomControls.dll =================================================================== (Binary files differ) Property changes on: WebPrototype/Bin/EclipseWebSolutions.CustomControls.dll ___________________________________________________________________ Name: svn:mime-type + application/octet-stream This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
