Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [38] WebPrototype
|
From: <ro...@us...> - 2006-06-16 21:33:17
|
Revision: 38 Author: rouquin Date: 2006-06-16 14:32:58 -0700 (Fri, 16 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=38&view=rev Log Message: ----------- Made assignments page consistent with current database schema design. Also enabled filtering. Modifying ActionItemEdit to be consistent with Assignment changes. 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 WebPrototype/Assignments.aspx WebPrototype/Assignments.aspx.cs Removed Paths: ------------- WebPrototype/Details.aspx WebPrototype/Details.aspx.cs Modified: WebPrototype/ActionItemEdit.aspx =================================================================== --- WebPrototype/ActionItemEdit.aspx 2006-06-16 00:29:32 UTC (rev 37) +++ WebPrototype/ActionItemEdit.aspx 2006-06-16 21:32:58 UTC (rev 38) @@ -11,8 +11,13 @@ <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> - <td width="*" valign="top"> - <asp:FormView ID="FormView1" runat="server" DataSourceID="myDS" DataKeyNames="id" + <td valign=top> + <asp:TreeView ID=TreeView1 runat="server" OnTreeNodePopulate=TreeView1_TreeNodePopulate> + <Nodes ><asp:TreeNode Text="Users" Value="Users" NavigateUrl="~/ActionItemEdit.aspx" /></Nodes> + </asp:TreeView> + </td> + <td width="700px" valign="top"> + <asp:FormView ID="FormView1" runat="server" DataSourceID="ActionItemDataSource" DataKeyNames="actionItemID" CellPadding=4 ForeColor="#333333" Height=348px OnItemUpdated=FormView1_ItemUpdated OnItemInserted=FormView1_ItemInserted> <EditItemTemplate> <div class="xsnazzy"> @@ -29,7 +34,7 @@ <cc1:DatePicker ID="DatePicker1" runat="server" - DateFormatString="MM/dd/yyyy" OnInit=DatePicker1_Init/> + DateFormatString="MM/dd/yyyy"/> </td> </tr> @@ -84,7 +89,7 @@ </td> <td align=right colspan=2 style="height: 19px; width: 179px;"> <strong>Due Date:</strong> - <asp:Label ID="dateStampLabel" runat="server" Text='<%# Eval("dateStamp") %>'></asp:Label></td> + <asp:Label ID="dateStampLabel" runat="server" Text='<%# Eval("dateAssigned") %>'></asp:Label></td> </tr> <tr> <td colspan="5" class="hr"> @@ -120,9 +125,9 @@ </td> <td align=right colspan=1 style="width: 25%; height: 16px"> <strong>Assigned To:</strong> - <asp:Label ID="Label1" runat="server" Text='<%# Eval("owner") %>'></asp:Label></td> + <asp:Label ID="Label1" runat="server"></asp:Label></td> <td colspan=1 style="width: 25%; height: 16px" align=right> - <strong>Assigned By:</strong><asp:Label ID="userIDLabel" runat="server" Text='<%# Eval("userID") %>'></asp:Label></td> + <strong>Assigned By:</strong><asp:Label ID="userIDLabel" runat="server" Text='<%# Eval("creatorID") %>'></asp:Label></td> </tr> </table> </div> @@ -140,20 +145,22 @@ </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> + <strong>Percent Complete: </strong> + <asp:RadioButtonList ID="RadioButtonList1" runat="server" RepeatDirection="Horizontal" AutoPostBack=True OnSelectedIndexChanged=RadioButtonList1_SelectedIndexChanged SelectedValue='<%# Bind("percentComplete", "{0:D}") %>'> + <asp:ListItem>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:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" DataSourceID=StatusDataSource DataTextField=stateName DataValueField=id SelectedValue='<%# Bind("statusID","{0}") %>'> <asp:ListItem /> - </asp:DropDownList> + </asp:DropDownList><asp:ObjectDataSource ID="StatusDataSource" runat="server" OldValuesParameterFormatString="original_{0}" + SelectMethod="GetStatusDataByGroup" TypeName="DummyDataSetTableAdapters.StatusTableAdapter"> + <SelectParameters> + <asp:Parameter DefaultValue="ActionItem" Name="groupName" Type="String" /> + </SelectParameters> + </asp:ObjectDataSource> </div> </td> </tr> @@ -214,35 +221,14 @@ </InsertItemTemplate> </asp:FormView> <asp:ObjectDataSource - ID="myDS" - runat="server" - DeleteMethod="DeleteById" - InsertMethod="InsertAll" + ID="ActionItemDataSource" + runat="server" 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> + SelectMethod="GetAssignmentDataByID" + TypeName="DummyDataSetTableAdapters.ActionItemTableAdapter"> <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"> Modified: WebPrototype/ActionItemEdit.aspx.cs =================================================================== --- WebPrototype/ActionItemEdit.aspx.cs 2006-06-16 00:29:32 UTC (rev 37) +++ WebPrototype/ActionItemEdit.aspx.cs 2006-06-16 21:32:58 UTC (rev 38) @@ -8,14 +8,16 @@ using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; +using System.Data.SqlClient; public partial class ActionItemEdit : System.Web.UI.Page { private 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(); + ActionItemDataSource.SelectParameters["id"].DefaultValue = id.ToString(); } protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) { @@ -24,9 +26,9 @@ RadioButtonList rbl = (RadioButtonList) sender; ObjectDataSource src = new ObjectDataSource("ActionItems","GetDummyActionItemData"); - src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.TypeName = "DummyDataSetTableAdapters.ActionItemTableAdapter"; src.UpdateMethod = "UpdatePercentByID"; - src.UpdateParameters.Add(new Parameter("percentFinished", TypeCode.Int32, rbl.SelectedIndex.ToString())); + src.UpdateParameters.Add(new Parameter("percentComplete", TypeCode.Int32, rbl.SelectedValue)); src.UpdateParameters.Add(new Parameter("original_id", TypeCode.Int32, id.ToString())); src.Update(); } @@ -37,39 +39,21 @@ DropDownList ddl = (DropDownList)sender; ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); - src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.TypeName = "DummyDataSetTableAdapters.ActionItemTableAdapter"; src.UpdateMethod = "UpdateStateByID"; - src.UpdateParameters.Add(new Parameter("state", TypeCode.String, ddl.SelectedValue)); + src.UpdateParameters.Add(new Parameter("statusID", TypeCode.String, ddl.SelectedValue)); 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.TypeName = "DummyDataSetTableAdapters.ActionItemTableAdapter"; src.UpdateMethod = "UpdateDateStampByID"; - src.UpdateParameters.Add(new Parameter("dateStamp", TypeCode.String, dp.DateValue.ToString(dp.DateFormatString))); + src.UpdateParameters.Add(new Parameter("dateAssigned", TypeCode.String, dp.DateValue.ToString(dp.DateFormatString))); src.UpdateParameters.Add(new Parameter("original_id", TypeCode.Int32, id.ToString())); src.Update(); } @@ -80,12 +64,119 @@ RadioButtonList rbl = (RadioButtonList)FormView1.FindControl("RadioButtonList1"); ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); - src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.TypeName = "DummyDataSetTableAdapters.ActionItemTableAdapter"; 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.UpdateParameters.Add(new Parameter("dateAssigned", TypeCode.String, dp.DateValue.ToString(dp.DateFormatString))); + src.UpdateParameters.Add(new Parameter("percentComplete", TypeCode.Int32, rbl.SelectedIndex.ToString())); + src.UpdateParameters.Add(new Parameter("statusID", TypeCode.String, ddl.SelectedValue)); src.Update(); Response.Redirect("~/Assignments.aspx"); } + protected void updateTree() + { + foreach (TreeNode node in TreeView1.Nodes) + { + node.ChildNodes.Clear(); + TreeView1_TreeNodePopulate(TreeView1, new TreeNodeEventArgs(node)); + } + TreeView1.ExpandAll(); + } + + protected void TreeView1_TreeNodePopulate(object sender, TreeNodeEventArgs e) + { + TreeView tv = (TreeView)sender; + DataSet ResultsDataSet = new DataSet(); + SqlDataAdapter DBAdapter; + String query; + + // Call the appropriate method to populate a node at a particular level. + switch (e.Node.Depth) + { + case 0: + // Populate the first-level nodes. + DBAdapter = new SqlDataAdapter("SELECT id,firstName,lastName FROM Users", DBConnection); + DBAdapter.Fill(ResultsDataSet); + + if (ResultsDataSet.Tables.Count > 0) + { + foreach (DataRow row in ResultsDataSet.Tables[0].Rows) + { + // Create the new node. + TreeNode newNode = new TreeNode(); + newNode.Text = row["firstName"]+" "+row["lastName"]; + newNode.Value = row["id"].ToString(); + + // Set the PopulateOnDemand property to true so that the child nodes can be + // dynamically populated. + newNode.PopulateOnDemand = true; + + // Set additional properties for the node. + newNode.SelectAction = TreeNodeSelectAction.Expand; + newNode.NavigateUrl = "~/ActionItemEdit.aspx" + newNode.Value; + + // Add the new node to the ChildNodes collection of the parent node. + e.Node.ChildNodes.Add(newNode); + } + } + break; + case 1: + // Populate the second-level nodes. + query = "SELECT ActionItem.actionItemID, ActionItem.name FROM ActionItem "+ + "INNER JOIN Assignments ON ActionItem.actionItemID = Assignments.actionItemID "+ + "WHERE (Assignments.creatorID = " + e.Node.Value + ")"; + DBAdapter = new SqlDataAdapter(query, DBConnection); + DBAdapter.Fill(ResultsDataSet); + + if (ResultsDataSet.Tables.Count > 0) + { + foreach (DataRow row in ResultsDataSet.Tables[0].Rows) + { + // Create the new node. + TreeNode newNode = new TreeNode(); + newNode.Text = row["name"].ToString(); + newNode.Value = row["actionItemID"].ToString(); + + // Set the PopulateOnDemand property to true so that the child nodes can be + // dynamically populated. + newNode.PopulateOnDemand = true; + + // Set additional properties for the node. + newNode.SelectAction = TreeNodeSelectAction.Expand; + newNode.NavigateUrl = "~/ActionItemEdit.aspx?id=" + newNode.Value; + + // Add the new node to the ChildNodes collection of the parent node. + e.Node.ChildNodes.Add(newNode); + } + } + query = "SELECT WorkOrder.WorkOrderID, WorkOrder.name FROM WorkOrder " + + "INNER JOIN Assignments ON WorkOrder.WorkOrderID = Assignments.workOrderID " + + "WHERE (Assignments.creatorID = " + e.Node.Value + ")"; + DBAdapter = new SqlDataAdapter(query, DBConnection); + DBAdapter.Fill(ResultsDataSet); + + if (ResultsDataSet.Tables.Count > 0) + { + foreach (DataRow row in ResultsDataSet.Tables[0].Rows) + { + // Create the new node. + TreeNode newNode = new TreeNode(); + newNode.Text = row["name"].ToString(); + newNode.Value = row["workOrderID"].ToString(); + + // Set the PopulateOnDemand property to true so that the child nodes can be + // dynamically populated. + newNode.PopulateOnDemand = true; + + // Set additional properties for the node. + newNode.SelectAction = TreeNodeSelectAction.Expand; + newNode.NavigateUrl = "~/WorkOrder.aspx?id=" + newNode.Value; + + // Add the new node to the ChildNodes collection of the parent node. + e.Node.ChildNodes.Add(newNode); + } + } + break; + + } + } } Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-16 00:29:32 UTC (rev 37) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-06-16 21:32:58 UTC (rev 38) @@ -8,225 +8,6 @@ </Connection> </Connections> <Tables> - <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AssignmentsTableAdapter" GeneratorDataComponentClassName="AssignmentsTableAdapter" Name="Assignments" UserDataComponentName="AssignmentsTableAdapter"> - <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Assignments" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="DummyGetAssignmentData" GetMethodModifier="Public" GetMethodName="DummyGetAssignmentData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="DummyGetAssignmentData" UserSourceName="DummyGetAssignmentData"> - <InsertCommand> - <DbCommand CommandType="Text" ModifiedByUser="False"> - <CommandText>INSERT INTO [Assignments] ([Date], [Assignment], [Status], [% Complete], [Total], [Pass Rate], [Pass], [Fail], [Error], [completed]) VALUES (@Date, @Assignment, @Status, @p3, @Total, @Pass_Rate, @Pass, @Fail, @Error, @completed)</CommandText> - <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Assignment" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Assignment" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="% Complete" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Total" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Total" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Pass_Rate" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="Pass Rate" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pass" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Fail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fail" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Error" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Error" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@completed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="completed" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - </Parameters> - </DbCommand> - </InsertCommand> - <SelectCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT Date, RTRIM(Type) AS Type, Assignment, Status, [% Complete], Total, [Pass Rate], Pass, Fail, Error, id, completed -FROM Assignments -WHERE (completed = @IsCompleted) OR - (completed = 'false')</CommandText> - <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="IsCompleted" ColumnName="completed" DataSourceName="[D:\MATTHEW\WORK\VINTELA\TCDB 2006\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Assignments" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsCompleted" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="completed" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - </Parameters> - </DbCommand> - </SelectCommand> - </DbSource> - </MainSource> - <Mappings> - <Mapping SourceColumn="Date" DataSetColumn="Date" /> - <Mapping SourceColumn="Assignment" DataSetColumn="Assignment" /> - <Mapping SourceColumn="Status" DataSetColumn="Status" /> - <Mapping SourceColumn="% Complete" DataSetColumn="% Complete" /> - <Mapping SourceColumn="Total" DataSetColumn="Total" /> - <Mapping SourceColumn="Pass Rate" DataSetColumn="Pass Rate" /> - <Mapping SourceColumn="Pass" DataSetColumn="Pass" /> - <Mapping SourceColumn="Fail" DataSetColumn="Fail" /> - <Mapping SourceColumn="Error" DataSetColumn="Error" /> - <Mapping SourceColumn="id" DataSetColumn="id" /> - <Mapping SourceColumn="completed" DataSetColumn="completed" /> - <Mapping SourceColumn="Type" DataSetColumn="Type" /> - </Mappings> - <Sources> - </Sources> - </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="False" 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"> - <SelectCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT id, name, description, userID, dateStamp, percentFinished, state, owner -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> - </MainSource> - <Mappings> - <Mapping SourceColumn="id" DataSetColumn="id" /> - <Mapping SourceColumn="name" DataSetColumn="name" /> - <Mapping SourceColumn="description" DataSetColumn="description" /> - <Mapping SourceColumn="percentFinished" DataSetColumn="percentFinished" /> - <Mapping SourceColumn="state" DataSetColumn="state" /> - <Mapping SourceColumn="userID" DataSetColumn="userID" /> - <Mapping SourceColumn="owner" DataSetColumn="owner" /> - <Mapping SourceColumn="dateStamp" DataSetColumn="dateStamp1" /> - </Mappings> - <Sources> - <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, description, id, name, owner, percentFinished, state, userID 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 -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="GetDataBy2" UserSourceName="InsertAll"> - <InsertCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>INSERT INTO ActionItems - (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> - <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="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> - <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="GetDataBy3" UserSourceName="UpdateByID"> - <UpdateCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>UPDATE ActionItems -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"> - </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="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="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="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 -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="GetDataBy5" UserSourceName="UpdatePercentByID"> - <UpdateCommand> - <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>UPDATE ActionItems SET percentFinished=@percentFinished WHERE id=@original_id</CommandText> - <Parameters> - <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> - </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="GetDataBy6" 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> - <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 -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"> <MainSource> <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Feature" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetFeatureData" GetMethodModifier="Public" GetMethodName="GetFeatureData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetFeatureData" UserSourceName="GetFeatureData"> @@ -886,7 +667,7 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkOrderTableAdapter" GeneratorDataComponentClassName="WorkOrderTableAdapter" Name="WorkOrder" UserDataComponentName="WorkOrderTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.WorkOrder" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllWorkOrderData" GetMethodModifier="Public" GetMethodName="GetAllWorkOrderData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllWorkOrderData" UserSourceName="Fill"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.WorkOrder" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllWorkOrderData" GetMethodModifier="Public" GetMethodName="GetAllWorkOrderData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllWorkOrderData" UserSourceName="GetAllWorkOrderData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT WorkOrder.* @@ -911,7 +692,7 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="testCaseTagsTableAdapter" GeneratorDataComponentClassName="testCaseTagsTableAdapter" Name="testCaseTags" UserDataComponentName="testCaseTagsTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.testCaseTags" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetTestCaseTagData" GetMethodModifier="Public" GetMethodName="GetTestCaseTagData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetTestCaseTagData" UserSourceName="Fill"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.testCaseTags" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetTestCaseTagData" GetMethodModifier="Public" GetMethodName="GetTestCaseTagData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetTestCaseTagData" UserSourceName="GetTestCaseTagData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT testCaseTags.* @@ -932,7 +713,7 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="versionTableAdapter" GeneratorDataComponentClassName="versionTableAdapter" Name="version" UserDataComponentName="versionTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.version" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllVersionData" GetMethodModifier="Public" GetMethodName="GetAllVersionData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllVersionData" UserSourceName="Fill"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.version" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllVersionData" GetMethodModifier="Public" GetMethodName="GetAllVersionData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllVersionData" UserSourceName="GetAllVersionData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT versionID, productID, number, dateCreated, active @@ -956,7 +737,7 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="versionTestCaseTableAdapter" GeneratorDataComponentClassName="versionTestCaseTableAdapter" Name="versionTestCase" UserDataComponentName="versionTestCaseTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.versionTestCase" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllVersionTestCaseData" GetMethodModifier="Public" GetMethodName="GetAllVersionTestCaseData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllVersionTestCaseData" UserSourceName="Fill"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.versionTestCase" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllVersionTestCaseData" GetMethodModifier="Public" GetMethodName="GetAllVersionTestCaseData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllVersionTestCaseData" UserSourceName="GetAllVersionTestCaseData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT vtc.versionTestCaseID, vtc.testCaseID, vtc.versionID @@ -979,7 +760,7 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="featureVersionTableAdapter" GeneratorDataComponentClassName="featureVersionTableAdapter" Name="featureVersion" UserDataComponentName="featureVersionTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.featureVersion" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllFeatureVersionData" GetMethodModifier="Public" GetMethodName="GetAllFeatureVersionData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllFeatureVersionData" UserSourceName="Fill"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.featureVersion" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllFeatureVersionData" GetMethodModifier="Public" GetMethodName="GetAllFeatureVersionData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllFeatureVersionData" UserSourceName="GetAllFeatureVersionData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT fv.featureVersionID, fv.featureID, fv.versionID @@ -1000,6 +781,156 @@ <Sources> </Sources> </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AssignmentsTableAdapter" GeneratorDataComponentClassName="AssignmentsTableAdapter" Name="Assignments" UserDataComponentName="AssignmentsTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Assignments" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllAssigmentData" GetMethodModifier="Public" GetMethodName="GetAllAssigmentData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllAssigmentData" UserSourceName="GetAllAssigmentData"> + <DeleteCommand> + <DbCommand CommandType="Text" ModifiedByUser="False"> + <CommandText>DELETE FROM [Assignments] WHERE (([assignmentID] = @Original_assignmentID))</CommandText> + <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_assignmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="assignmentID" SourceColumnNullMapping="False" SourceVersion="Original"> + </Parameter> + </Parameters> + </DbCommand> + </DeleteCommand> + <InsertCommand> + <DbCommand CommandType="Text" ModifiedByUser="False"> + <CommandText>INSERT INTO [Assignments] ([creatorID], [dateAssigned], [dateFinished], [dateDue], [workOrderID], [actionItemID], [highPriorityID]) VALUES (@creatorID, @dateAssigned, @dateFinished, @dateDue, @workOrderID, @actionItemID, @highPriorityID); +SELECT assignmentID, creatorID, dateAssigned, dateFinished, dateDue, workOrderID, actionItemID, highPriorityID FROM Assignments WHERE (assignmentID = SCOPE_IDENTITY())</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@creatorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="creatorID" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateAssigned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateAssigned" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateFinished" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateFinished" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateDue" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dateDue" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@workOrderID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="workOrderID" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@actionItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="actionItemID" SourceColumnNullMapping="False" SourceVers... [truncated message content] |
