Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [23] WebPrototype
|
From: <ro...@us...> - 2006-06-09 19:03:32
|
Revision: 23 Author: rouquin Date: 2006-06-09 12:03:05 -0700 (Fri, 09 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=23&view=rev Log Message: ----------- Added changes for ActionItemEdit Modified Paths: -------------- WebPrototype/App_Code/DummyDataSet.xsd WebPrototype/App_Code/DummyDataSet.xss WebPrototype/App_Data/ASPNETDB.MDF WebPrototype/App_Data/Database.mdf WebPrototype/App_Data/Database_log.LDF WebPrototype/App_Data/aspnetdb_log.ldf WebPrototype/App_Themes/Python/python.css WebPrototype/Assignments.aspx WebPrototype/Details.aspx WebPrototype/MasterPage.master WebPrototype/Web.config WebPrototype/Web.sitemap Added Paths: ----------- WebPrototype/ActionItemEdit.aspx WebPrototype/ActionItemEdit.aspx.cs WebPrototype/Bin/FreeTextBox.dll Added: WebPrototype/ActionItemEdit.aspx =================================================================== --- WebPrototype/ActionItemEdit.aspx (rev 0) +++ WebPrototype/ActionItemEdit.aspx 2006-06-09 19:03:05 UTC (rev 23) @@ -0,0 +1,287 @@ +<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" + ValidateRequest="false" CodeFile="ActionItemEdit.aspx.cs" Inherits="ActionItemEdit" + Title="Action Item" %> + +<%@ Register Assembly="FreeTextBox" Namespace="FreeTextBoxControls" TagPrefix="FTB" %> +<%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="atlas" %> +<asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> + + <table border="0" cellpadding="0" cellspacing="0" width="100%"> + <tr> + <td width="*" valign="top"> + <asp:FormView ID="FormView1" runat="server" DataSourceID="myDS" DataKeyNames="id" + CellPadding=4 ForeColor="#333333" Height=348px> + <EditItemTemplate> + <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> + <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"> + + Due Date: <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("dateStamp") %>' Width=81px /> + </td> + </tr> + <tr> + <td colspan="4" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan="4" style="height: 197px"> + Description:<br /> + <FTB:FreeTextBox ID="FreeTextBox1" runat="server" SupportFolder="~" + Text='<%# Bind("description") %>' Height="100%" Width="100%" /> + </td> + </tr> + <tr> + <td colspan="4" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan=1 style="height: 23px; width: 239px;"> + <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 align=right colspan=1 style="width: 576px; height: 23px"> + Assigned To: + <asp:TextBox ID="assignedToTextBox" runat="server" Text='<%# Bind("assignedTo") %>'></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> + </table> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </EditItemTemplate> + <ItemTemplate> + <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> + <tr> + <td colspan=2 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"> + Due Date: + <asp:Label ID="dateStampLabel" runat="server" Text='<%# Eval("dateStamp") %>'></asp:Label></td> + </tr> + <tr> + <td colspan="4" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan=4 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"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan=1 style="height: 16px; width: 3048px;"> + <br /> + <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 align=right colspan=1 style="width: 1217px; 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> + Assigned By:<asp:Label ID="userIDLabel" runat="server" Text='<%# Eval("userID") %>'></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> + </ItemTemplate> + <HeaderTemplate> + <div id="ActionItem"> + <table> + <tr> + <td style="width: 179px; height: 37px"> + <h2> + Action Item</h2> + </td> + <td align=right style="width: 657px; height: 37px"> + <div id="radiolist"> + <asp:RadioButtonList ID="RadioButtonList1" runat="server" RepeatDirection="Horizontal" SelectedIndex='<%# Bind("percentFinished") %>' AutoPostBack=True OnSelectedIndexChanged=RadioButtonList1_SelectedIndexChanged> + <asp:ListItem Selected=True>0%</asp:ListItem> + <asp:ListItem>25%</asp:ListItem> + <asp:ListItem>50%</asp:ListItem> + <asp:ListItem>75%</asp:ListItem> + <asp:ListItem>100%</asp:ListItem> + </asp:RadioButtonList>| + <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" + SelectedValue='<%# Eval("state", "{0}") %>'> + <asp:ListItem Selected="True">Complete </asp:ListItem> + <asp:ListItem>Active </asp:ListItem> + <asp:ListItem>Inactive </asp:ListItem> + <asp:ListItem /> + </asp:DropDownList> + </div> + </td> + </tr> + </table> + </div> + </HeaderTemplate> + <InsertItemTemplate> + <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> + <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"> + Due Date: + <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("dateStamp") %>' Width=81px /> + </td> + </tr> + <tr> + <td colspan="4" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan="4" style="height: 197px"> + <FTB:FreeTextBox ID="FreeTextBox1" runat="server" SupportFolder="~" + Text='<%# Bind("description") %>' Height="100%" Width="100%" /> + </td> + </tr> + <tr> + <td colspan="4" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan=1 style="height: 23px; width: 239px;"> + <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 align=right colspan=1 style="width: 576px; height: 23px"> + Assigned To: + <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("assignedTo", "{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> + </tr> + </table> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </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> + <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/ActionItemEdit.aspx.cs =================================================================== --- WebPrototype/ActionItemEdit.aspx.cs (rev 0) +++ WebPrototype/ActionItemEdit.aspx.cs 2006-06-09 19:03:05 UTC (rev 23) @@ -0,0 +1,47 @@ +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; + +public partial class ActionItemEdit : System.Web.UI.Page +{ + private int id = System.Convert.ToInt32(HttpContext.Current.Request.QueryString["id"]); + + 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(); + } + protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) + { + RadioButtonList rbl = (RadioButtonList) FormView1.FindControl("RadioButtonList1"); + ObjectDataSource src = new ObjectDataSource("ActionItems","GetDummyActionItemData"); + + src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.UpdateMethod = "UpdatePercentByID"; + src.UpdateParameters.Add(new Parameter("percentFinished", TypeCode.Int32, rbl.SelectedIndex.ToString())); + src.UpdateParameters.Add(new Parameter("original_id", TypeCode.Int32, id.ToString())); + src.Update(); + } + protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) + { + DropDownList ddl = (DropDownList)FormView1.FindControl("DropDownList1"); + ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); + + src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.UpdateMethod = "UpdateStateByID"; + src.UpdateParameters.Add(new Parameter("state", TypeCode.String, ddl.SelectedValue)); + src.UpdateParameters.Add(new Parameter("original_id", TypeCode.Int32, id.ToString())); + src.Update(); + } +} Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-08 22:32:21 UTC (rev 22) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-06-09 19:03:05 UTC (rev 23) @@ -103,33 +103,14 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ActionItemsTableAdapter" GeneratorDataComponentClassName="ActionItemsTableAdapter" Name="ActionItems" UserDataComponentName="ActionItemsTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.ActionItems" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetDummyActionItemData" GetMethodModifier="Public" GetMethodName="GetDummyActionItemData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyActionItemData" UserSourceName="GetDummyActionItemData"> - <InsertCommand> - <DbCommand CommandType="Text" ModifiedByUser="False"> - <CommandText>INSERT INTO [ActionItems] ([id], [name], [description], [userID], [dateStamp], [percentFinished]) VALUES (@id, @name, @description, @userID, @dateStamp, @percentFinished)</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> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="userID" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateStamp" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - </Parameters> - </DbCommand> - </InsertCommand> + <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 + <CommandText>SELECT id, name, description, userID, dateStamp, percentFinished, state, assignedTo FROM ActionItems WHERE (id = @id)</CommandText> <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="id" DataSourceName="[D:\MATTHEW\WORK\VINTELA\TCDB 2006\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 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> @@ -140,11 +121,101 @@ <Mapping SourceColumn="id" DataSetColumn="id" /> <Mapping SourceColumn="name" DataSetColumn="name" /> <Mapping SourceColumn="description" DataSetColumn="description" /> - <Mapping SourceColumn="userID" DataSetColumn="userID" /> <Mapping SourceColumn="dateStamp" DataSetColumn="dateStamp" /> <Mapping SourceColumn="percentFinished" DataSetColumn="percentFinished" /> + <Mapping SourceColumn="state" DataSetColumn="state" /> + <Mapping SourceColumn="userID" DataSetColumn="userID" /> + <Mapping SourceColumn="assignedTo" DataSetColumn="assignedTo" /> </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 ActionItems +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.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> + </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="True"> + <CommandText>INSERT INTO ActionItems + (name, description, userID, dateStamp, percentFinished, state, assignedTo) +VALUES (@name,@description,@userID,@dateStamp,@percentFinished,@state,@assignedTo)</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> + <Parameter AllowDbNull="True" AutogeneratedName="description" ColumnName="description" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" 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="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> + <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> + </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"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE ActionItems +SET name = @name, description = @description, userID = @userID, dateStamp = @dateStamp, assignedTo = @assignedTo +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"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="description" ColumnName="description" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" 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="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> + <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"> + <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> + <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="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"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE ActionItems +SET state = @state +WHERE (id = @original_id)</CommandText> + <Parameters> + <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="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> </Sources> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FeatureTableAdapter" GeneratorDataComponentClassName="FeatureTableAdapter" Name="Feature" UserDataComponentName="FeatureTableAdapter"> @@ -316,36 +387,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_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" minOccurs="0"> + <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="Date" 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_ColumnPropNameInRow="Assignment" msprop:Generator_ColumnVarNameInTable="columnAssignment" msprop:Generator_ColumnPropNameInTable="AssignmentColumn" minOccurs="0"> + <xs:element name="Assignment" msprop:Generator_UserColumnName="Assignment" msprop:Generator_ColumnVarNameInTable="columnAssignment" msprop:Generator_ColumnPropNameInRow="Assignment" 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_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> + <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" 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_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: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:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> @@ -358,45 +429,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_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="platform" msprop:Generator_UserColumnName="platform" msprop:Generator_ColumnPropNameInRow="platform" msprop:Generator_ColumnVarNameInTable="columnplatform" msprop:Generator_ColumnPropNameInTable="platformColumn" minOccurs="0"> + <xs:element name="platform" msprop:Generator_UserColumnName="platform" msprop:Generator_ColumnVarNameInTable="columnplatform" msprop:Generator_ColumnPropNameInRow="platform" 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_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: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: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_ColumnVarNameInTable="columnWoName" msprop:Generator_ColumnPropNameInRow="WoName" msprop:Generator_ColumnPropNameInTable="WoNameColumn" minOccurs="0"> + <xs:element name="WoName" msprop:Generator_UserColumnName="WoName" msprop:Generator_ColumnPropNameInRow="WoName" msprop:Generator_ColumnVarNameInTable="columnWoName" 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_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> + <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" 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_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_ColumnPropNameInRow="steps" msprop:Generator_ColumnPropNameInTable="stepsColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> @@ -409,80 +480,94 @@ <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_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="descript... [truncated message content] |
