Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [39] WebPrototype
|
From: <ro...@us...> - 2006-06-17 01:31:16
|
Revision: 39 Author: rouquin Date: 2006-06-16 18:31:03 -0700 (Fri, 16 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=39&view=rev Log Message: ----------- Updated ActionItemEdit to work with updated DB schema and refactored some old code. I also decided to add a TreeView of what assignments each user has. Fixed a few things with Assignments also. 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 Modified: WebPrototype/ActionItemEdit.aspx =================================================================== --- WebPrototype/ActionItemEdit.aspx 2006-06-16 21:32:58 UTC (rev 38) +++ WebPrototype/ActionItemEdit.aspx 2006-06-17 01:31:03 UTC (rev 39) @@ -4,7 +4,6 @@ <%@ Register Assembly="EclipseWebSolutions.CustomControls" Namespace="EclipseWebSolutions.CustomControls" TagPrefix="cc1" %> - <%@ Register Assembly="FreeTextBox" Namespace="FreeTextBoxControls" TagPrefix="FTB" %> <%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="atlas" %> <asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> @@ -12,13 +11,17 @@ <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <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 ID=TreeView1 runat="server" SelectedNodeStyle-CssClass="selectednode" + OnTreeNodePopulate=TreeView1_TreeNodePopulate> + <Nodes> + <asp:TreeNode Text="User Assignments" Value="Users" PopulateOnDemand="true" SelectAction=Expand /> + </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> + CellPadding=4 ForeColor="#333333" Height=348px OnItemUpdated=FormView1_ItemUpdated + OnItemInserted=FormView1_ItemInserted OnDataBound=FormView1_DataBound OnItemDeleted=FormView1_ItemDeleted> <EditItemTemplate> <div class="xsnazzy"> <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> @@ -26,16 +29,22 @@ <div class="xboxcontent"> <table> <tr> - <td colspan="2" style="width: 239px; height: 11px;"> - <strong> Name: </strong> - <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width="100%" /></td> - <td align=right colspan=2 style="height: 11px"> - <strong> Due Date: </strong> - <cc1:DatePicker - ID="DatePicker1" - runat="server" - DateFormatString="MM/dd/yyyy"/> - + <td colspan="2" width="55%"> + <strong> Name:</strong><br /> + <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width="80%" /> + <br /> + <asp:CheckBox ID="priorityBox" runat="server" Checked='<%# Eval("highPriorityID") %>' />: + <strong>High Priority</strong></td> + <td align=right colspan=2 width="45%"> + <strong>Assigned: + </strong> + <cc1:DatePicker ID="assignedDate" runat="server" DateFormatString="MM/dd/yyyy" DateValue='<%# Eval("dateAssigned") %>' /><br /> + <strong>Due: + </strong> + <cc1:DatePicker ID="dueDate" runat="server" DateFormatString="MM/dd/yyyy" DateValue='<%# Eval("dateDue") %>'/><br /> + <strong>Finished: + </strong> + <cc1:DatePicker ID="finishedDate" runat="server" DateFormatString="MM/dd/yyyy" DateValue='<%# Eval("dateFinished") %>'/> </td> </tr> <tr> @@ -46,8 +55,8 @@ <tr> <td colspan="4" style="height: 197px"> <strong>Description:</strong><br /> - <FTB:FreeTextBox ID="FreeTextBox1" runat="server" SupportFolder="~" - Text='<%# Bind("description") %>' Height="100%" Width="100%" /> + <FTB:FreeTextBox ID="FreeTextBox1" runat="server" SupportFolder="~" Text='<%# Bind("description") %>' + Height="100%" Width="100%" /> </td> </tr> <tr> @@ -56,7 +65,7 @@ </td> </tr> <tr> - <td colspan=1 style="height: 23px; width: 239px;"> + <td colspan=2 width="60%"> <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update"> </asp:LinkButton> | @@ -64,11 +73,21 @@ Text="Cancel"> </asp:LinkButton> </td> - <td align=right colspan=1 style="width: 576px; height: 23px"> - <strong>Assigned To:</strong> - <asp:TextBox ID="ownerTextBox" runat="server" Text='<%# Bind("owner") %>'></asp:TextBox> </td> - <td colspan=1 style="width: 576px; height: 23px" align=right> - <strong>Assigned By:</strong><asp:TextBox ID="userIDTextBox" runat="server" Text='<%# Bind("userID") %>'></asp:TextBox></td> + <td align=right colspan=2 width="%40"> + <strong>Created By: + <asp:DropDownList ID="createdBy" runat="server" DataSourceID="UserDataSource" + DataTextField="Name" DataValueField="id" SelectedValue='<%# Eval("creatorID","{0}") %>'> + </asp:DropDownList> + </strong> + <br /> + <strong>Assigned To: + <asp:DropDownList ID="assignedTo" runat="server" DataSourceID="UserDataSource" + DataTextField="Name" DataValueField="id" SelectedValue='<%# Eval("assignedID","{0}") %>'> + </asp:DropDownList></strong> + <asp:ObjectDataSource ID="UserDataSource" runat="server" OldValuesParameterFormatString="original_{0}" + SelectMethod="GetUserNames" TypeName="DummyDataSetTableAdapters.UsersTableAdapter"> + </asp:ObjectDataSource> + </td> </tr> </table> </div> @@ -83,32 +102,42 @@ <div class="xboxcontent"> <table> <tr> - <td colspan=3 style="width: 3048px; height: 19px;"> + <td colspan=2 style="width: 55%"> <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' Style="font-size: large; color: black; font-family: Arial;"></asp:Label> + <br /> + <asp:CheckBox ID="priorityBox" runat="server" Checked='<%# Eval("highPriorityID") %>' + Enabled="False" />: <strong>High Priority</strong></td> + <td align=right colspan=2 width="40%"> + <strong>Assigned: + </strong> + <cc1:DatePicker ID="assignedDate" runat="server" DateFormatString="MM/dd/yyyy" Enabled=False /><br /> + <strong>Due: + </strong> + <cc1:DatePicker ID="dueDate" runat="server" DateFormatString="MM/dd/yyyy" Enabled=False/><br /> + <strong>Finished: + </strong> + <cc1:DatePicker ID="finishedDate" runat="server" DateFormatString="MM/dd/yyyy" Enabled=False/> </td> - <td align=right colspan=2 style="height: 19px; width: 179px;"> - <strong>Due Date:</strong> - <asp:Label ID="dateStampLabel" runat="server" Text='<%# Eval("dateAssigned") %>'></asp:Label></td> </tr> <tr> - <td colspan="5" class="hr"> + <td colspan="4" class="hr"> <img alt="" src="images/spacer.gif" height="5" /><br /> </td> </tr> <tr> - <td colspan=5 style="height: 197px" valign=top> + <td colspan=4 style="height: 197px" valign=top> <strong>Description:</strong><br /> <asp:Label ID="descriptionLabel" runat="server" Text='<%# Eval("description") %>'></asp:Label> </td> </tr> <tr> - <td colspan="5" class="hr" style="height: 1px"> + <td colspan="4" class="hr"> <img alt="" src="images/spacer.gif" height="5" /><br /> </td> </tr> <tr> - <td colspan=1 style="height: 16px; width: 15%;"> + <td colspan=2 style="width: 55%"> <br /> <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"> @@ -121,13 +150,21 @@ <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete"> </asp:LinkButton></td> - <td align=right colspan=1 style="width: 25%; height: 16px"> + <td align=right colspan=2 width="45%"> + <strong>Created By: + <asp:DropDownList ID="createdBy" runat="server" DataSourceID="UserDataSource" + DataTextField="Name" DataValueField="id" SelectedValue='<%# Eval("creatorID","{0}") %>' Enabled=False> + </asp:DropDownList> + </strong> + <br /> + <strong>Assigned To: + <asp:DropDownList ID="assignedTo" runat="server" DataSourceID="UserDataSource" + DataTextField="Name" DataValueField="id" SelectedValue='<%# Eval("assignedID","{0}") %>' Enabled=False> + </asp:DropDownList></strong> + <asp:ObjectDataSource ID="UserDataSource" runat="server" OldValuesParameterFormatString="original_{0}" + SelectMethod="GetUserNames" TypeName="DummyDataSetTableAdapters.UsersTableAdapter"> + </asp:ObjectDataSource> </td> - <td align=right colspan=1 style="width: 25%; height: 16px"> - <strong>Assigned To:</strong> - <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("creatorID") %>'></asp:Label></td> </tr> </table> </div> @@ -145,17 +182,21 @@ </td> <td align=right style="width: 657px; height: 37px"> <div id="radiolist"> + <strong>Status: </strong> <asp:DropDownList ID="statusList" runat="server" + AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" + DataSourceID=StatusDataSource DataTextField=stateName DataValueField=id AppendDataBoundItems=True> + <asp:ListItem Selected=True /> + </asp:DropDownList><br /> <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:RadioButtonList ID="percentList" runat="server" RepeatDirection="Horizontal" + 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" DataSourceID=StatusDataSource DataTextField=stateName DataValueField=id SelectedValue='<%# Bind("statusID","{0}") %>'> - <asp:ListItem /> - </asp:DropDownList><asp:ObjectDataSource ID="StatusDataSource" runat="server" OldValuesParameterFormatString="original_{0}" + </asp:RadioButtonList> + <asp:ObjectDataSource ID="StatusDataSource" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetStatusDataByGroup" TypeName="DummyDataSetTableAdapters.StatusTableAdapter"> <SelectParameters> <asp:Parameter DefaultValue="ActionItem" Name="groupName" Type="String" /> @@ -174,11 +215,21 @@ <div class="xboxcontent"> <table> <tr> - <td align=left colspan=3 style="height: 11px"> - <strong> Name:</strong><asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width="80%" /></td> - <td colspan="1" style="width: 576px; height: 11px;" align="right"> - <strong> Due Date:</strong><cc1:DatePicker ID="DatePicker2" runat="server" /> - + <td colspan="2" width="55%"> + <strong> Name:</strong><br /> + <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width="80%" /> + <br /> + <asp:CheckBox ID="priorityBox" runat="server" />: <strong>High Priority</strong></td> + <td align=right colspan=2 width="45%"> + <strong>Assigned: + </strong> + <cc1:DatePicker ID="assignedDate" runat="server" DateFormatString="MM/dd/yyyy" /><br /> + <strong>Due: + </strong> + <cc1:DatePicker ID="dueDate" runat="server" DateFormatString="MM/dd/yyyy" /><br /> + <strong>Finished: + </strong> + <cc1:DatePicker ID="finishedDate" runat="server" DateFormatString="MM/dd/yyyy" /> </td> </tr> <tr> @@ -188,8 +239,8 @@ </tr> <tr> <td colspan="4" style="height: 197px"> - <FTB:FreeTextBox ID="FreeTextBox1" runat="server" SupportFolder="~" - Text='<%# Bind("description") %>' Height="100%" Width="100%" /> + <FTB:FreeTextBox ID="FreeTextBox1" runat="server" SupportFolder="~" Text='<%# Bind("description") %>' + Height="100%" Width="100%" /> </td> </tr> <tr> @@ -198,7 +249,7 @@ </td> </tr> <tr> - <td colspan=2 style="height: 23px; width: 239px;"> + <td colspan=2 width="60%"> <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert"> </asp:LinkButton> | @@ -206,12 +257,21 @@ Text="Cancel"> </asp:LinkButton> </td> - <td align=right colspan=1 style="width: 576px; height: 23px"> - <strong>Assigned To:</strong> - <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("owner", "{0}") %>'></asp:TextBox> </td> - <td colspan=1 style="width: 576px; height: 23px" align=right> - <strong>Assigned By:</strong> - <asp:TextBox ID="TextBoxuserID" runat="server" Text='<%# Bind("userID") %>'></asp:TextBox></td> + <td align=right colspan=2 width="40%"> + <strong>Created By: + <asp:DropDownList ID="createdBy" runat="server" DataSourceID="UserDataSource" + DataTextField="Name" DataValueField="id" AppendDataBoundItems=True > + </asp:DropDownList> + </strong> + <br /> + <strong>Assigned To: + <asp:DropDownList ID="assignedTo" runat="server" DataSourceID="UserDataSource" + DataTextField="Name" DataValueField="id" AppendDataBoundItems=True > + </asp:DropDownList></strong> + <asp:ObjectDataSource ID="UserDataSource" runat="server" OldValuesParameterFormatString="original_{0}" + SelectMethod="GetUserNames" TypeName="DummyDataSetTableAdapters.UsersTableAdapter"> + </asp:ObjectDataSource> + </td> </tr> </table> </div> @@ -220,15 +280,29 @@ </div> </InsertItemTemplate> </asp:FormView> - <asp:ObjectDataSource - ID="ActionItemDataSource" - runat="server" - OldValuesParameterFormatString="original_{0}" - SelectMethod="GetAssignmentDataByID" - TypeName="DummyDataSetTableAdapters.ActionItemTableAdapter"> + <asp:ObjectDataSource ID="ActionItemDataSource" + runat="server" + OldValuesParameterFormatString="original_{0}" + SelectMethod="GetAssignmentDataByID" + TypeName="DummyDataSetTableAdapters.ActionItemTableAdapter" + DeleteMethod=DeleteByID + InsertMethod=InsertActionItem + UpdateMethod=UpdateActionItemByID> <SelectParameters> - <asp:Parameter DefaultValue="0" Name="id" Type="Int32" /> + <asp:Parameter Name="id" Type="Int32" /> </SelectParameters> + <DeleteParameters> + <asp:Parameter Name="original_actionItemID" Type="Object" /> + </DeleteParameters> + <UpdateParameters> + <asp:Parameter Name="name" Type="String" /> + <asp:Parameter Name="description" Type="String" /> + <asp:Parameter Name="original_actionItemID" Type="Int32" /> + </UpdateParameters> + <InsertParameters> + <asp:Parameter Name="name" Type="String" /> + <asp:Parameter Name="description" 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 21:32:58 UTC (rev 38) +++ WebPrototype/ActionItemEdit.aspx.cs 2006-06-17 01:31:03 UTC (rev 39) @@ -9,6 +9,7 @@ using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; +using EclipseWebSolutions.CustomControls; public partial class ActionItemEdit : System.Web.UI.Page { @@ -18,60 +19,94 @@ protected void Page_Load(object sender, EventArgs e) { ActionItemDataSource.SelectParameters["id"].DefaultValue = id.ToString(); + DBConnection.Open(); } protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) { - if (FormView1.CurrentMode == FormViewMode.Insert) return; - - RadioButtonList rbl = (RadioButtonList) sender; - ObjectDataSource src = new ObjectDataSource("ActionItems","GetDummyActionItemData"); - - src.TypeName = "DummyDataSetTableAdapters.ActionItemTableAdapter"; - src.UpdateMethod = "UpdatePercentByID"; - src.UpdateParameters.Add(new Parameter("percentComplete", TypeCode.Int32, rbl.SelectedValue)); - src.UpdateParameters.Add(new Parameter("original_id", TypeCode.Int32, id.ToString())); - src.Update(); + if (FormView1.CurrentMode != FormViewMode.Insert) + { + RadioButtonList percentList = (RadioButtonList)sender; + SqlCommand cmd = new SqlCommand("UPDATE ActionItem SET percentComplete="+percentList.SelectedValue+" WHERE actionItemID="+id, DBConnection); + cmd.ExecuteNonQuery(); + } } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { - if (FormView1.CurrentMode == FormViewMode.Insert) return; - - DropDownList ddl = (DropDownList)sender; - ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); - - src.TypeName = "DummyDataSetTableAdapters.ActionItemTableAdapter"; - src.UpdateMethod = "UpdateStateByID"; - src.UpdateParameters.Add(new Parameter("statusID", TypeCode.String, ddl.SelectedValue)); - src.UpdateParameters.Add(new Parameter("original_id", TypeCode.Int32, id.ToString())); - src.Update(); + if (FormView1.CurrentMode != FormViewMode.Insert) + { + DropDownList statusList = (DropDownList)sender; + SqlCommand cmd = new SqlCommand("UPDATE Assignments SET statusID=" + statusList.SelectedValue + " WHERE actionItemID=" + id, DBConnection); + cmd.ExecuteNonQuery(); + } } protected void FormView1_ItemUpdated(object sender, FormViewUpdatedEventArgs e) { - EclipseWebSolutions.CustomControls.DatePicker dp = (EclipseWebSolutions.CustomControls.DatePicker)FormView1.FindControl("DatePicker1"); - ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); + DatePicker assignedDate = (DatePicker)FormView1.FindControl("assignedDate"); + DatePicker dueDate = (DatePicker)FormView1.FindControl("dueDate"); + DatePicker finishedDate = (DatePicker)FormView1.FindControl("finishedDate"); + DropDownList createdBy = (DropDownList)FormView1.FindControl("createdBy"); + DropDownList assignedTo = (DropDownList)FormView1.FindControl("assignedTo"); + CheckBox priorityBox = (CheckBox)FormView1.FindControl("priorityBox"); - src.TypeName = "DummyDataSetTableAdapters.ActionItemTableAdapter"; - src.UpdateMethod = "UpdateDateStampByID"; - 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(); + SqlCommand cmd = new SqlCommand("UPDATE Assignments SET " + + "dateAssigned='" + assignedDate.DateValue + + "',dateDue='" + dueDate.DateValue + + "',dateFinished='" + finishedDate.DateValue + + "',creatorID='" + createdBy.SelectedValue + + "',assignedID='" + assignedTo.SelectedValue + + "',highPriorityID='" + priorityBox.Checked + + "' WHERE actionItemID=" + id, DBConnection); + cmd.ExecuteNonQuery(); + + updateTree(); } protected void FormView1_ItemInserted(object sender, FormViewInsertedEventArgs e) { - EclipseWebSolutions.CustomControls.DatePicker dp = (EclipseWebSolutions.CustomControls.DatePicker)FormView1.FindControl("DatePicker2"); - DropDownList ddl = (DropDownList)FormView1.FindControl("DropDownList1"); - RadioButtonList rbl = (RadioButtonList)FormView1.FindControl("RadioButtonList1"); - ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); + DatePicker assignedDate = (DatePicker)FormView1.FindControl("assignedDate"); + DatePicker dueDate = (DatePicker)FormView1.FindControl("dueDate"); + DatePicker finishedDate = (DatePicker)FormView1.FindControl("finishedDate"); + DropDownList createdBy = (DropDownList)FormView1.FindControl("createdBy"); + DropDownList assignedTo = (DropDownList)FormView1.FindControl("assignedTo"); + DropDownList statusList = (DropDownList)FormView1.FindControl("statusList"); + RadioButtonList percentList = (RadioButtonList)FormView1.FindControl("percentList"); + CheckBox priorityBox = (CheckBox)FormView1.FindControl("priorityBox"); + + // Get inserted ActionItem + SqlDataAdapter DBAdapter = new SqlDataAdapter("SELECT MAX(actionItemID) AS newID FROM ActionItem",DBConnection); + DataSet data = new DataSet(); + DBAdapter.Fill(data); + id = Convert.ToInt32(data.Tables[0].Rows[0]["newID"]); - src.TypeName = "DummyDataSetTableAdapters.ActionItemTableAdapter"; - src.UpdateMethod = "UpdateThreeByID"; - 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"); + String assigned = "null", due = "null", finished = "null"; + if (assignedDate.DateValue != DateTime.MinValue) + assigned = "'" + assignedDate.DateValue + "'"; + if (dueDate.DateValue != DateTime.MinValue) + due = "'" + dueDate.DateValue + "'"; + if (finishedDate.DateValue != DateTime.MinValue) + finished = "'" + finishedDate.DateValue + "'"; + + SqlCommand cmd = new SqlCommand("INSERT INTO Assignments (actionItemID,dateAssigned,dateDue,dateFinished,creatorID,assignedID,statusID,highPriorityID) VALUES ('" + + id + "'," + + assigned + "," + + due + "," + + finished + ",'" + + createdBy.SelectedValue + "','" + + assignedTo.SelectedValue + "','" + + statusList.SelectedValue + "','" + + priorityBox.Checked + "')", DBConnection); + cmd.ExecuteNonQuery(); + cmd.CommandText = "UPDATE ActionItem SET percentComplete=" + percentList.SelectedValue + " WHERE actionItemID=" + id; + cmd.ExecuteNonQuery(); + updateTree(); + Response.Redirect("~/ActionItemEdit.aspx?id=" + id); } + protected void FormView1_ItemDeleted(object sender, FormViewDeletedEventArgs e) + { + SqlCommand cmd = new SqlCommand("DELETE FROM Assignments WHERE actionItemID=" + id, DBConnection); + cmd.ExecuteNonQuery(); + updateTree(); + } protected void updateTree() { foreach (TreeNode node in TreeView1.Nodes) @@ -112,7 +147,6 @@ // 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); @@ -123,7 +157,7 @@ // 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 + ")"; + "WHERE (Assignments.assignedID = " + e.Node.Value + ")"; DBAdapter = new SqlDataAdapter(query, DBConnection); DBAdapter.Fill(ResultsDataSet); @@ -148,9 +182,10 @@ e.Node.ChildNodes.Add(newNode); } } + ResultsDataSet.Clear(); query = "SELECT WorkOrder.WorkOrderID, WorkOrder.name FROM WorkOrder " + "INNER JOIN Assignments ON WorkOrder.WorkOrderID = Assignments.workOrderID " + - "WHERE (Assignments.creatorID = " + e.Node.Value + ")"; + "WHERE (Assignments.assignedID = " + e.Node.Value + ")"; DBAdapter = new SqlDataAdapter(query, DBConnection); DBAdapter.Fill(ResultsDataSet); @@ -179,4 +214,35 @@ } } + protected void FormView1_DataBound(object sender, EventArgs e) + { + DatePicker assignedDate = (DatePicker)FormView1.FindControl("assignedDate"); + DatePicker dueDate = (DatePicker)FormView1.FindControl("dueDate"); + DatePicker finishedDate = (DatePicker)FormView1.FindControl("finishedDate"); + DropDownList statusList = (DropDownList) FormView1.FindControl("statusList"); + RadioButtonList percentList = (RadioButtonList)FormView1.FindControl("percentList"); + DataRowView data = (DataRowView)FormView1.DataItem; + + if (data != null) + { + String assigned = data["dateAssigned"].ToString(); + String due = data["dateDue"].ToString(); + String finished = data["dateFinished"].ToString(); + String status = data["statusID"].ToString(); + String percent = data["percentComplete"].ToString(); + + if (assigned != "") + assignedDate.DateValue = Convert.ToDateTime(assigned); + if (due != "") + dueDate.DateValue = Convert.ToDateTime(due); + if (finished != "") + finishedDate.DateValue = Convert.ToDateTime(finished); + if (status != "") + statusList.SelectedValue = status; + if (percent != "") + percentList.SelectedValue = percent; + } + + } + } Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-16 21:32:58 UTC (rev 38) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-06-17 01:31:03 UTC (rev 39) @@ -784,70 +784,14 @@ <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" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@highPriorityID" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="highPriorityID" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - </Parameters> - </DbCommand> - </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT assignmentID, creatorID, dateAssigned, dateFinished, dateDue, workOrderID, actionItemID, highPriorityID FROM Assignments</CommandText> + <CommandText>SELECT assignmentID, creatorID, dateAssigned, dateFinished, dateDue, workOrderID, actionItemID, highPriorityID, assignedID +FROM Assignments</CommandText> <Parameters> </Parameters> </DbCommand> </SelectCommand> - <UpdateCommand> - <DbCommand CommandType="Text" ModifiedByUser="False"> - <CommandText>UPDATE [Assignments] SET [creatorID] = @creatorID, [dateAssigned] = @dateAssigned, [dateFinished] = @dateFinished, [dateDue] = @dateDue, [workOrderID] = @workOrderID, [actionItemID] = @actionItemID, [highPriorityID] = @highPriorityID WHERE (([assignmentID] = @Original_assignmentID)); -SELECT assignmentID, creatorID, dateAssigned, dateFinished, dateDue, workOrderID, actionItemID, highPriorityID FROM Assignments WHERE (assignmentID = @assignmentID)</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" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@highPriorityID" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="highPriorityID" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <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> - <Parameter AllowDbNull="False" AutogeneratedName="assignmentID" ColumnName="assignmentID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Assignments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@assignmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="assignmentID" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - </Parameters> - </DbCommand> - </UpdateCommand> </DbSource> </MainSource> <Mappings> @@ -860,17 +804,18 @@ <Mapping SourceColumn="highPriorityID" DataSetColumn="highPriorityID" /> <Mapping SourceColumn="creatorID" DataSetColumn="creatorID" /> <Mapping SourceColumn="assignmentStatusID" DataSetColumn="statusID" /> + <Mapping SourceColumn="assignedID" DataSetColumn="assignedID" /> </Mappings> <Sources> <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAllActionItemNames" GetMethodModifier="Public" GetMethodName="GetAllActionItemNames" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAllActionItemNames" UserSourceName="GetAllActionItemNames1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT ActionItem.name AS ActionItem, Assignments.assignmentID, Users.firstName + ' ' + Users.lastName AS UserName, Assignments.dateAssigned, - Assignments.dateFinished, Assignments.dateDue, Assignments.statusID, Status.stateName, Assignments.actionItemID, - Assignments.highPriorityID + <CommandText>SELECT ActionItem.name AS ActionItem, Assignments.assignmentID, u1.firstName + ' ' + u1.lastName AS Creator, u2.firstName + ' ' + u2.lastName AS Assignee, Assignments.dateAssigned, + Assignments.dateFinished, Assignments.dateDue, Assignments.statusID, Status.stateName, Assignments.actionItemID, Assignments.highPriorityID FROM Assignments INNER JOIN ActionItem ON ActionItem.actionItemID = Assignments.actionItemID LEFT OUTER JOIN - Users ON Users.id = Assignments.creatorID LEFT OUTER JOIN + Users AS u1 ON u1.id = Assignments.creatorID LEFT OUTER JOIN + Users AS u2 ON u2.id = Assignments.assignedID LEFT OUTER JOIN Status ON Status.id = Assignments.statusID</CommandText> <Parameters> </Parameters> @@ -880,12 +825,13 @@ <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAllWorkOrderNames" GetMethodModifier="Public" GetMethodName="GetAllWorkOrderNames" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAllWorkOrderNames" UserSourceName="GetAllWorkOrderNames1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT WorkOrder.name AS WorkOrder, Assignments.assignmentID, Users.firstName + ' ' + Users.lastName AS UserName, Assignments.dateAssigned, - Assignments.dateFinished, Assignments.dateDue, Assignments.statusID, Status.stateName, Assignments.workOrderID, - Assignments.highPriorityID + <CommandText>SELECT WorkOrder.name AS WorkOrder, Assignments.assignmentID, u1.firstName + ' ' + u1.lastName AS Creator, + u2.firstName + ' ' + u2.lastName AS Assignee, Assignments.dateAssigned, Assignments.dateFinished, Assignments.dateDue, Assignments.statusID, + Status.stateName, Assignments.workOrderID, Assignments.highPriorityID FROM Assignments INNER JOIN WorkOrder ON WorkOrder.workOrderID = Assignments.workOrderID LEFT OUTER JOIN - Users ON Users.id = Assignments.creatorID LEFT OUTER JOIN + Users AS u1 ON u1.id = Assignments.creatorID LEFT OUTER JOIN + Users AS u2 ON u2.id = Assignments.assignedID LEFT OUTER JOIN Status ON Status.id = Assignments.statusID</CommandText> <Parameters> </Parameters> @@ -914,11 +860,23 @@ <Mapping SourceColumn="percentComplete" DataSetColumn="percentComplete" /> </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="GetDataBy1" UserSourceName="DeleteByID"> + <DeleteCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>DELETE FROM ActionItem +WHERE (actionItemID = @original_actionItemID)</CommandText> + <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="original_actionItemID" ColumnName="actionItemID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItem" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_actionItemID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="actionItemID" SourceColumnNullMapping="False" SourceVersion="Original"> + </Parameter> + </Parameters> + </DbCommand> + </DeleteCommand> + </DbSource> <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAssignmentDataByID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetAssignmentDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAssignmentDataByID" UserSourceName="GetAssignmentDataByID1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT ActionItem.actionItemID, ActionItem.name, ActionItem.description, ActionItem.percentComplete, Assignments.dateAssigned, Assignments.dateFinished, - Assignments.dateDue, Assignments.statusID, Assignments.highPriorityID, Assignments.creatorID + Assignments.dateDue, Assignments.statusID, Assignments.highPriorityID, Assignments.creatorID, Assignments.assignedID FROM Assignments INNER JOIN ActionItem ON ActionItem.actionItemID = Assignments.actionItemID WHERE (ActionItem.actionItemID = @id)</CommandText> @@ -929,6 +887,38 @@ </DbCommand> </SelectCommand> </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertActionItem" Modifier="Public" Name="InsertActionItem" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="InsertActionItem"> + <InsertCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>INSERT INTO ActionItem + (name, description) +VALUES (@name,@description)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItem" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" 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.ActionItem" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="description" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </InsertCommand> + </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateActionItemByID" Modifier="Public" Name="UpdateActionItemByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="UpdateActionItemByID"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE ActionItem +SET name = @name, description = @description +WHERE (actionItemID = @original_actionItemID)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItem" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" 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.ActionItem" 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="False" AutogeneratedName="original_actionItemID" ColumnName="actionItemID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItem" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_actionItemID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="actionItemID" SourceColumnNullMapping="False" SourceVersion="Original"> + </Parameter> + </Parameters> + </DbCommand> + </UpdateCommand> + </DbSource> </Sources> </TableAdapter> </Tables> @@ -943,117 +933,117 @@ <xs:element name="Feature" msprop:Generator_UserTableName="Feature" msprop:Generator_RowDeletedName="FeatureRowDeleted" msprop:Generator_RowChangedName="FeatureRowChanged" msprop:Generator_RowClassName="FeatureRow" msprop:Generator_RowChangingName="FeatureRowChanging" msprop:Generator_RowEvArgName="FeatureRowChangeEvent" msprop:Generator_RowEvHandlerName="FeatureRowChangeEventHandler" msprop:Generator_TableClassName="FeatureDataTable" msprop:Generator_TableVarName="tableFeature" msprop:Generator_RowDeletingName="FeatureRowDeleting" msprop:Generator_TablePropName="Feature"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="parent_id" msprop:Generator_UserColumnName="parent_id" msprop:Generator_ColumnVarNameInTable="columnparent_id" msprop:Generator_ColumnPropNameInRow="parent_id" msprop:Generator_ColumnPropNameInTable="parent_idColumn" type="xs:int" minOccurs="0" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="parent_id" msprop:Generator_UserColumnName="parent_id" msprop:Generator_ColumnPropNameInRow="parent_id" msprop:Generat... [truncated message content] |
