Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [84] WebPrototype
|
From: <ro...@us...> - 2006-07-07 18:13:08
|
Revision: 84 Author: rouquin Date: 2006-07-07 11:12:39 -0700 (Fri, 07 Jul 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=84&view=rev Log Message: ----------- Added note functionality. Seems to be working well. Applied to all currently finished pages. Modified Paths: -------------- WebPrototype/ActionItemEdit.aspx WebPrototype/ActionItemEdit.aspx.cs WebPrototype/Admin.aspx.cs WebPrototype/AdminMaster.master WebPrototype/AdminMaster.master.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/AssignmentMaster.master WebPrototype/AssignmentMaster.master.cs WebPrototype/Assignments.aspx WebPrototype/Assignments.aspx.cs WebPrototype/FeatureEdit.aspx WebPrototype/FeatureEdit.aspx.cs WebPrototype/ObjectiveEdit.aspx WebPrototype/ObjectiveEdit.aspx.cs WebPrototype/ProductEdit.aspx WebPrototype/ProductEdit.aspx.cs WebPrototype/TestCaseEdit.aspx WebPrototype/TestCaseEdit.aspx.cs WebPrototype/TestManagement.aspx.cs WebPrototype/TestMaster.master WebPrototype/TestMaster.master.cs WebPrototype/WorkOrderEdit.aspx WebPrototype/WorkOrderEdit.aspx.cs WebPrototype/buildEdit.aspx.cs WebPrototype/statusEdit.aspx.cs WebPrototype/userRightsEdit.aspx.cs WebPrototype/versionEdit.aspx.cs Added Paths: ----------- WebPrototype/testpassEdit.aspx WebPrototype/testpassEdit.aspx.cs Modified: WebPrototype/ActionItemEdit.aspx =================================================================== --- WebPrototype/ActionItemEdit.aspx 2006-07-07 00:04:33 UTC (rev 83) +++ WebPrototype/ActionItemEdit.aspx 2006-07-07 18:12:39 UTC (rev 84) @@ -10,7 +10,7 @@ <asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> <asp:FormView ID="FormView1" runat="server" DataSourceID="ActionItemDataSource" DataKeyNames="actionItemID" CellPadding=4 ForeColor="#333333" OnItemUpdated=FormView1_ItemUpdated - OnItemInserted=FormView1_ItemInserted OnDataBound=FormView1_DataBound OnItemDeleted=FormView1_ItemDeleted> + OnItemInserted=FormView1_ItemInserted OnDataBound=FormView1_DataBound OnItemDeleted=FormView1_ItemDeleted OnItemCommand=FormView1_ItemCommand> <HeaderTemplate> <div id="ActionItem"> <table width=700> @@ -205,8 +205,7 @@ Text="Insert"> </asp:LinkButton> | <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" - Text="Cancel"> - </asp:LinkButton> + Text="Cancel"></asp:LinkButton> </td> <td align=right colspan=2 width="40%"> <strong>Created By: <asp:Label ID="createdByLbl" runat="server" Font-Bold="False" Modified: WebPrototype/ActionItemEdit.aspx.cs =================================================================== --- WebPrototype/ActionItemEdit.aspx.cs 2006-07-07 00:04:33 UTC (rev 83) +++ WebPrototype/ActionItemEdit.aspx.cs 2006-07-07 18:12:39 UTC (rev 84) @@ -13,20 +13,26 @@ public partial class ActionItemEdit : System.Web.UI.Page { - private String id = (String) HttpContext.Current.Request.QueryString["id"]; + String id = HttpContext.Current.Request.QueryString["id"]; + String mode = HttpContext.Current.Request.QueryString["mode"]; bool priority; protected void Page_Load(object sender, EventArgs e) { if (!User.Identity.IsAuthenticated || Profile.userID == "") Response.Redirect("default.aspx"); + if (id == null && mode == null) + Response.Redirect("Assignments.aspx"); + Session.Add("id", id); + + if (mode != null && mode == "new") + FormView1.ChangeMode(FormViewMode.Insert); ImageButton priorityImg = (ImageButton)FormView1.FindControl("priorityImg"); + if (priorityImg != null && priorityImg.ImageUrl == "~/Images/exclamation.jpg") priority = true; - if (id == null) - id = "0"; - Session.Add("id",id); - if (priorityImg != null && priorityImg.ImageUrl == "~/Images/exclamation.jpg") priority = true; + ObjectDataSource notes = (ObjectDataSource)Master.FindControl("NoteDataSource"); + notes.SelectParameters["tableName"].DefaultValue = "ActionItem"; } protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) { @@ -186,4 +192,9 @@ } } } + protected void FormView1_ItemCommand(object sender, FormViewCommandEventArgs e) + { + if (e.CommandName == "Cancel" && FormView1.CurrentMode == FormViewMode.Insert) + Response.Redirect("Assignments.aspx?id=" + Profile.userID); + } } Modified: WebPrototype/Admin.aspx.cs =================================================================== --- WebPrototype/Admin.aspx.cs 2006-07-07 00:04:33 UTC (rev 83) +++ WebPrototype/Admin.aspx.cs 2006-07-07 18:12:39 UTC (rev 84) @@ -14,8 +14,6 @@ protected void Page_Load(object sender, EventArgs e) { if (!User.Identity.IsAuthenticated || Profile.userID == "") - { Response.Redirect("Default.aspx"); - } } } Modified: WebPrototype/AdminMaster.master =================================================================== --- WebPrototype/AdminMaster.master 2006-07-07 00:04:33 UTC (rev 83) +++ WebPrototype/AdminMaster.master 2006-07-07 18:12:39 UTC (rev 84) @@ -1,6 +1,7 @@ <%@ Master Language="C#" AutoEventWireup="true" CodeFile="AdminMaster.master.cs" Inherits="AdminMaster" %> <%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="atlas" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> + <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>TCDB</title> @@ -96,59 +97,130 @@ <td align="right" valign="top"> <atlas:UpdatePanel ID=noteViewUpdatePanel runat="server" Mode=Conditional> <ContentTemplate> - <div style="padding-left: 10px; text-align: left;"> - <a href="#" style="padding-left: 10px; text-align: left;">New Note</a></div> - <table width="225" cellpadding="0" cellspacing="0" border="0" style="padding: 10px;"> - <tr> - <td> - <b class="notetop"><b class="noteb1"></b><b class="noteb2"></b><b class="noteb3"></b> - <b class="noteb4"></b></b> - <div class="noteboxcontent"> - <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <asp:DataList ID="DataList1" runat="server" DataKeyField="noteID" DataSourceID="NoteDataSource" + ShowFooter="False" OnDeleteCommand=DataList1_DeleteCommand OnEditCommand="DataList1_EditCommand" + OnCancelCommand="DataList1_CancelCommand" OnUpdateCommand="DataList1_UpdateCommand"> + <ItemTemplate> + <b class="notetop"><b class="noteb1"></b><b class="noteb2"></b><b class="noteb3"></b> + <b class="noteb4"></b></b> + <div class="noteboxcontent"> + <table width="200" cellpadding="0" cellspacing="0" border="0"> + <tr> + <asp:Panel ID="Panel3" runat="server" CssClass="collapsePanelHeader"> + <td align="left" valign="bottom"> + <h4> + Reminder:</h4> + <asp:Label ID="dateCreatedLabel" runat="server" Text='<%# Eval("dateCreated","{0:d}") %>'></asp:Label> + <td align="right" valign="bottom"> + <asp:Image ID="Note2Arrow" runat=server ImageUrl="App_Themes/Python/Images/ArrowUp.gif" /> + <asp:LinkButton ID=Delete runat="server" CommandName="delete">x</asp:LinkButton> + </asp:Panel> + </tr> + </table> + <atlas:CollapsiblePanelExtender ID="CollapsiblePanelExtender2" runat="server"> + <atlas:CollapsiblePanelProperties Collapsed="True" SuppressPostBack="True" CollapseControlID="Note2Arrow" + ExpandControlID="Note2Arrow" ExpandedImage="App_Themes/Python/Images/ArrowUp.gif" + CollapsedImage="App_Themes/Python/Images/ArrowDown.gif" TargetControlID="Note2Content" + CollapsedSize="0" ImageControlID="Note2Arrow" /> + </atlas:CollapsiblePanelExtender> + <asp:Panel ID="Note2Content" runat="server" Height="0" Style="overflow: hidden; padding: 0px; + margin: 0px;"> + <table width="200" cellpadding="0" cellspacing="0" border="0"> <tr> - <asp:Panel ID="Panel3" runat="server" CssClass="collapsePanelHeader"> - <td align="left" valign="bottom"> - <h4> - Reminder:</h4> - 15 Apr 2006 </td> - <td align="right" valign="bottom"> - <img alt="Note2Arrow" src="App_Themes/Python/Images/ArrowUp.gif" id="Note2Arrow" /> - <a href="#" class="notedelete">x</a></td> - </asp:Panel> + <td class="hr"> + </td> </tr> + <tr> + <td> + <asp:Label ID="noteFieldLabel" runat="server" Text='<%# Eval("noteField") %>'></asp:Label><br /> + <asp:LinkButton ID=Edit runat="server" CommandName="edit"><i>Edit</i></asp:LinkButton> + </td> + </tr> + <tr> + <td class="hr"> + </td> + </tr> + <tr> + <td> + <strong>Author:</strong> + <asp:Label ID="noteAuthorLabel" runat="server" Text='<%# Eval("noteAuthorName") %>'></asp:Label> + </td> + </tr> </table> - <atlas:CollapsiblePanelExtender ID="CollapsiblePanelExtender2" runat="server"> - <atlas:CollapsiblePanelProperties Collapsed="true" SuppressPostBack="true" CollapseControlID="Note2Arrow" - ExpandControlID="Note2Arrow" ExpandedImage="App_Themes/Python/Images/ArrowUp.gif" - CollapsedImage="App_Themes/Python/Images/ArrowDown.gif" TargetControlID="Note2Content" - AutoCollapse="false" AutoExpand="false" CollapsedSize="0" ImageControlID="Note2Arrow" /> - </atlas:CollapsiblePanelExtender> - <asp:Panel ID="Note2Content" runat="server" Height="0" Style="overflow: hidden; padding: 0px; - margin: 0px;"> - <table width="100%" cellpadding="0" cellspacing="0" border="0"> - <tr> - <td class="hr"> - <img alt="" src="images/spacer.gif" height="5" /><br /> - </td> - </tr> - </table> - Integer lacus elit, consectetuer nec, rutrum at, pretium ac, risus. Sed semper massa - luctus mi. Donec placerat, diam vitae ultricies posuere, felis dui sollicitudin - nibh, eget blandit purus libero in elit. Aenean eget lectus eget ipsum rutrum scelerisque. - Nunc orci mauris, rhoncus ac, pellentesque sit amet, condimentum vel, nibh. Pellentesque - habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. - Suspendisse blandit. - </asp:Panel> - </div> - <b class="notebottom"><b class="noteb4"></b><b class="noteb3"></b><b class="noteb2"> - </b></b><b class="noteb1"></b></td> - </tr> - </table> + </asp:Panel> + </div> + <b class="notebottom"><b class="noteb4"></b><b class="noteb3"></b><b class="noteb2"> + </b></b><b class="noteb1"></b> + </ItemTemplate> + <EditItemTemplate> + <b class="notetop"><b class="noteb1"></b><b class="noteb2"></b><b class="noteb3"></b> + <b class="noteb4"></b></b> + <div class="noteboxcontent"> + <table width="200" cellpadding="0" cellspacing="0" border="0"> + <tr> + <asp:Panel ID="Panel3" runat="server" CssClass="collapsePanelHeader"> + <td align="left" valign="bottom"> + <h4> + Reminder:</h4> + <asp:Label ID="dateCreatedLabel" runat="server" Text='<%# Eval("dateCreated","{0:d}") %>'></asp:Label> + <td align="right" valign="bottom"> + <asp:Image ID="Note2Arrow" runat=server ImageUrl="App_Themes/Python/Images/ArrowUp.gif" /> + <asp:LinkButton ID=Delete runat="server" CommandName="delete">x</asp:LinkButton> + </asp:Panel> + </tr> + </table> + <asp:Panel ID="Note2Content" runat="server" Style="overflow: hidden; padding: 0px; + margin: 0px;"> + <table width="200" cellpadding="0" cellspacing="0" border="0"> + <tr> + <td class="hr"> + </td> + </tr> + <tr> + <td> + <asp:TextBox ID="noteFieldBox" runat="server" width=100% Height=100 Text='<%# Bind("noteField") %>' Rows=5 TextMode=MultiLine /> + </td> + </tr> + <tr> + <td class="hr"> + </td> + </tr> + <tr> + <td> + <asp:LinkButton ID=Update runat="server" CommandName="update" Text="Update"></asp:LinkButton> + <asp:LinkButton ID=Cancel runat="server" CommandName="cancel" Text="Cancel"></asp:LinkButton> + </td> + </tr> + </table> + </asp:Panel> + </div> + <b class="notebottom"><b class="noteb4"></b><b class="noteb3"></b><b class="noteb2"> + </b></b><b class="noteb1"></b> + </EditItemTemplate> + <HeaderTemplate> + <asp:LinkButton ID=newNote runat="server" CommandName="newNote" OnCommand=newNote>New Note</asp:LinkButton> + </HeaderTemplate> + </asp:DataList> </ContentTemplate> <Triggers> <atlas:ControlEventTrigger ControlID="PageContent" EventName="Load" /> </Triggers> </atlas:UpdatePanel> + <asp:ObjectDataSource ID="NoteDataSource" runat="server" OldValuesParameterFormatString="original_{0}" + SelectMethod="GetNotesByTable" TypeName="DummyDataSetTableAdapters.notesTableAdapter" + DeleteMethod=DeleteByID UpdateMethod=UpdateNoteByID> + <SelectParameters> + <asp:Parameter DefaultValue="Assignments" Name="tableName" Type="String" /> + <asp:SessionParameter DefaultValue="" Name="tableID" SessionField="id" Type="Int32" /> + </SelectParameters> + <DeleteParameters> + <asp:Parameter Name="original_noteID" Type="Int32" /> + </DeleteParameters> + <UpdateParameters> + <asp:Parameter Name="noteField" Type="String" /> + <asp:Parameter Name="original_noteID" Type="Int32" /> + </UpdateParameters> + </asp:ObjectDataSource> </td> </tr> </table> Modified: WebPrototype/AdminMaster.master.cs =================================================================== --- WebPrototype/AdminMaster.master.cs 2006-07-07 00:04:33 UTC (rev 83) +++ WebPrototype/AdminMaster.master.cs 2006-07-07 18:12:39 UTC (rev 84) @@ -9,6 +9,7 @@ using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; +using AtlasControlToolkit; public partial class AdminMaster : System.Web.UI.MasterPage { @@ -324,5 +325,55 @@ break; } } + protected void newNote(object sender, CommandEventArgs e) + { + String table = NoteDataSource.SelectParameters["tableName"].DefaultValue; + String row = Session["id"].ToString(); + SqlCommand cmd = new SqlCommand("INSERT INTO notes (tableName,tableID,noteField,dateCreated,noteAuthor) VALUES ('" + table + "'," + row + ",'','" + DateTime.Today + "'," + Profile.userID + ")", DBConnection); + cmd.ExecuteNonQuery(); + + // Edit note + DataList1.EditItemIndex = DataList1.Items.Count; + DataList1.DataBind(); + } + protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e) + { + NoteDataSource.DeleteParameters["original_noteID"].DefaultValue = DataList1.DataKeys[e.Item.ItemIndex].ToString(); + NoteDataSource.Delete(); + } + + protected void DataList1_EditCommand(object source, DataListCommandEventArgs e) + { + DataList1.EditItemIndex = e.Item.ItemIndex; + DataList1.DataBind(); + } + + protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e) + { + DataList1.EditItemIndex = -1; + DataList1.DataBind(); + + // Delete note if empty + String noteField = ((TextBox)e.Item.FindControl("noteFieldBox")).Text; + if (noteField == "") + { + NoteDataSource.DeleteParameters["original_noteID"].DefaultValue = DataList1.DataKeys[e.Item.ItemIndex].ToString(); + NoteDataSource.Delete(); + DataList1.DataBind(); + } + } + + protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e) + { + String noteID = DataList1.DataKeys[e.Item.ItemIndex].ToString(); + String noteField = ((TextBox)e.Item.FindControl("noteFieldBox")).Text; + + NoteDataSource.UpdateParameters["original_noteID"].DefaultValue = noteID; + NoteDataSource.UpdateParameters["noteField"].DefaultValue = noteField; + NoteDataSource.Update(); + + DataList1.EditItemIndex = -1; + DataList1.DataBind(); + } } Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-07-07 00:04:33 UTC (rev 83) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-07-07 18:12:39 UTC (rev 84) @@ -573,7 +573,7 @@ </DbCommand> </DeleteCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetVersionByID" GetMethodModifier="Public" GetMethodName="GetVersionByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetVersionByID" UserSourceName="FillBy"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetVersionByID" GetMethodModifier="Public" GetMethodName="GetVersionByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetVersionByID" UserSourceName="GetVersionByID1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT version.versionID, version.productID, product.name AS productName, version.number, version.dateCreated, version.active @@ -614,7 +614,7 @@ </DbCommand> </SelectCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertVersion" Modifier="Public" Name="InsertVersion" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="InsertVersion"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertVersion" Modifier="Public" Name="InsertVersion" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="InsertVersion"> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>INSERT INTO version @@ -631,7 +631,7 @@ </DbCommand> </InsertCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="UpdateVersionByID" Modifier="Public" Name="UpdateVersionByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="UpdateVersionByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="UpdateVersionByID" Modifier="Public" Name="UpdateVersionByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="UpdateVersionByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE version @@ -757,7 +757,8 @@ WorkOrder ON WorkOrder.workOrderID = Assignments.workOrderID LEFT OUTER JOIN Users AS u1 ON u1.userID = Assignments.creatorID LEFT OUTER JOIN Users AS u2 ON u2.userID = Assignments.assignedID LEFT OUTER JOIN - Status ON Status.statusID = Assignments.statusID</CommandText> + Status ON Status.statusID = Assignments.statusID +ORDER BY Assignments.highPriorityID DESC</CommandText> <Parameters> </Parameters> </DbCommand> @@ -784,7 +785,8 @@ Users AS u1 ON u1.userID = Assignments_1.creatorID LEFT OUTER JOIN Users AS u2 ON u2.userID = Assignments_1.assignedID LEFT OUTER JOIN Status AS Status_1 ON Status_1.statusID = Assignments_1.statusID -WHERE (Assignments_1.assignedID = @assignedID)</CommandText> +WHERE (Assignments_1.assignedID = @assignedID) +ORDER BY Assignments.highPriorityID DESC</CommandText> <Parameters> <Parameter AllowDbNull="True" AutogeneratedName="assignedID" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@assignedID" Precision="0" Scale="0" Size="4" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> @@ -1181,6 +1183,72 @@ </DbSource> </Sources> </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="notesTableAdapter" GeneratorDataComponentClassName="notesTableAdapter" Name="notes" UserDataComponentName="notesTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.notes" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllNotes" GetMethodModifier="Public" GetMethodName="GetAllNotes" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllNotes" UserSourceName="Fill"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT * FROM notes</CommandText> + <Parameters> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="noteID" DataSetColumn="noteID" /> + <Mapping SourceColumn="tableName" DataSetColumn="tableName" /> + <Mapping SourceColumn="tableID" DataSetColumn="tableID" /> + <Mapping SourceColumn="dateCreated" DataSetColumn="dateCreated" /> + <Mapping SourceColumn="noteField" DataSetColumn="noteField" /> + <Mapping SourceColumn="noteAuthor" DataSetColumn="noteAuthor" /> + </Mappings> + <Sources> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="DeleteByID" Modifier="Public" Name="DeleteByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="DeleteByID"> + <DeleteCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>DELETE FROM notes WHERE noteID=@original_noteID</CommandText> + <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="original_noteID" ColumnName="noteID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.notes" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_noteID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="noteID" SourceColumnNullMapping="False" SourceVersion="Original"> + </Parameter> + </Parameters> + </DbCommand> + </DeleteCommand> + </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.notes" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetNotesByTable" GetMethodModifier="Public" GetMethodName="GetNotesByTable" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetNotesByTable" UserSourceName="FillBy"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT notes.dateCreated, notes.noteAuthor, Users.firstName + ' ' + Users.lastName AS noteAuthorName, notes.noteField, notes.noteID, notes.tableID, + notes.tableName +FROM notes LEFT OUTER JOIN + Users ON Users.userID = notes.noteAuthor +WHERE (notes.tableName = @tableName) AND (notes.tableID = @tableID)</CommandText> + <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="tableName" ColumnName="tableName" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.notes" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@tableName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="tableName" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="False" AutogeneratedName="tableID" ColumnName="tableID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.notes" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@tableID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="tableID" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateNoteByID" Modifier="Public" Name="UpdateNoteByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="UpdateNoteByID"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE notes +SET noteField = @noteField +WHERE (noteID = @original_noteID)</CommandText> + <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="noteField" ColumnName="noteField" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.notes" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@noteField" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="noteField" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="False" AutogeneratedName="original_noteID" ColumnName="noteID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.notes" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_noteID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="noteID" SourceColumnNullMapping="False" SourceVersion="Original"> + </Parameter> + </Parameters> + </DbCommand> + </UpdateCommand> + </DbSource> + </Sources> + </TableAdapter> </Tables> <Sources> </Sources> @@ -1193,102 +1261,102 @@ <xs:element name="Objective" msprop:Generator_UserTableName="Objective" msprop:Generator_RowDeletedName="ObjectiveRowDeleted" msprop:Generator_RowChangedName="ObjectiveRowChanged" msprop:Generator_RowClassName="ObjectiveRow" msprop:Generator_RowChangingName="ObjectiveRowChanging" msprop:Generator_RowEvArgName="ObjectiveRowChangeEvent" msprop:Generator_RowEvHandlerName="ObjectiveRowChangeEventHandler" msprop:Generator_TableClassName="ObjectiveDataTable" msprop:Generator_TableVarName="tableObjective" msprop:Generator_RowDeletingName="ObjectiveRowDeleting" msprop:Generator_TablePropName="Objective"> <xs:complexType> <xs:sequence> - <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="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="objectiveID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="objectiveID" msprop:Generator_ColumnVarNameInTable="columnobjectiveID" msprop:Generator_ColumnPropNameInRow="objectiveID" msprop:Generator_ColumnPropNameInTable="objectiveIDColumn" type="xs:int" /> - <xs:element name="featureID" msprop:Generator_UserColumnName="featureID" msprop:Generator_ColumnVarNameInTable="columnfeatureID" msprop:Generator_ColumnPropNameInRow="featureID" msprop:Generator_ColumnPropNameInTable="featureIDColumn" type="xs:int" /> - <xs:element name="userID" msprop:Generator_UserColumnName="userID" msprop:Generator_ColumnVarNameInTable="columnuserID" msprop:Generator_ColumnPropNameInRow="userID" msprop:Generator_ColumnPropNameInTable="userIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="dateCreated" msprop:Generator_UserColumnName="dateCreated" msprop:Generator_ColumnVarNameInTable="columndateCreated" msprop:Generator_ColumnPropNameInRow="dateCreated" msprop:Generator_ColumnPropNameInTable="dateCreatedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="statusID" msprop:Generator_UserColumnName="statusID" msprop:Generator_ColumnVarNameInTable="columnstatusID" msprop:Generator_ColumnPropNameInRow="statusID" msprop:Generator_ColumnPropNameInTable="statusIDColumn" type="xs:int" default="0" minOccurs="0" /> + <xs:element name="objectiveID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="objectiveID" msprop:Generator_ColumnPropNameInRow="objectiveID" msprop:Generator_ColumnVarNameInTable="columnobjectiveID" msprop:Generator_ColumnPropNameInTable="objectiveIDColumn" type="xs:int" /> + <xs:element name="featureID" msprop:Generator_UserColumnName="featureID" msprop:Generator_ColumnPropNameInRow="featureID" msprop:Generator_ColumnVarNameInTable="columnfeatureID" msprop:Generator_ColumnPropNameInTable="featureIDColumn" type="xs:int" /> + <xs:element name="userID" msprop:Generator_UserColumnName="userID" msprop:Generator_ColumnPropNameInRow="userID" msprop:Generator_ColumnVarNameInTable="columnuserID" msprop:Generator_ColumnPropNameInTable="userIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="dateCreated" msprop:Generator_UserColumnName="dateCreated" msprop:Generator_ColumnPropNameInRow="dateCreated" msprop:Generator_ColumnVarNameInTable="columndateCreated" msprop:Generator_ColumnPropNameInTable="dateCreatedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="statusID" msprop:Generator_UserColumnName="statusID" msprop:Generator_ColumnPropNameInRow="statusID" msprop:Generator_ColumnVarNameInTable="columnstatusID" msprop:Generator_ColumnPropNameInTable="statusIDColumn" type="xs:int" default="0" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="TestCase" msprop:Generator_UserTableName="TestCase" msprop:Generator_RowDeletedName="TestCaseRowDeleted" msprop:Generator_RowChangedName="TestCaseRowChanged" msprop:Generator_RowClassName="TestCaseRow" msprop:Generator_RowChangingName="TestCaseRowChanging" msprop:Generator_RowEvArgName="TestCaseRowChangeEvent" msprop:Generator_RowEvHandlerName="TestCaseRowChangeEventHandler" msprop:Generator_TableClassName="TestCaseDataTable" msprop:Generator_TableVarName="tableTestCase" msprop:Generator_RowDeletingName="TestCaseRowDeleting" msprop:Generator_TablePropName="TestCase"> <xs:complexType> <xs:sequence> - <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="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="steps" msprop:Generator_UserColumnName="steps" msprop:Generator_ColumnVarNameInTable="columnsteps" msprop:Generator_ColumnPropNameInRow="steps" msprop:Generator_ColumnPropNameInTable="stepsColumn" minOccurs="0"> + <xs:element name="steps" msprop:Generator_UserColumnName="steps" msprop:Generator_ColumnPropNameInRow="steps" msprop:Generator_ColumnVarNameInTable="columnsteps" msprop:Generator_ColumnPropNameInTable="stepsColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="number" msprop:Generator_UserColumnName="number" msprop:Generator_ColumnVarNameInTable="columnnumber" msprop:Generator_ColumnPropNameInRow="number" msprop:Generator_ColumnPropNameInTable="numberColumn" type="xs:int" minOccurs="0" /> - <xs:element name="dateCreated" msprop:Generator_UserColumnName="dateCreated" msprop:Generator_ColumnVarNameInTable="columndateCreated" msprop:Generator_ColumnPropNameInRow="dateCreated" msprop:Generator_ColumnPropNameInTable="dateCreatedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="dateEdited" msprop:Generator_UserColumnName="dateEdited" msprop:Generator_ColumnVarNameInTable="columndateEdited" msprop:Generator_ColumnPropNameInRow="dateEdited" msprop:Generator_ColumnPropNameInTable="dateEditedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="objectiveID" msprop:Generator_UserColumnName="objectiveID" msprop:Generator_ColumnVarNameInTable="columnobjectiveID" msprop:Generator_ColumnPropNameInRow="objectiveID" msprop:Generator_ColumnPropNameInTable="objectiveIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="statusID" msprop:Generator_UserColumnName="statusID" msprop:Generator_ColumnVarNameInTable="columnstatusID" msprop:Generator_ColumnPropNameInRow="statusID" msprop:Generator_ColumnPropNameInTable="statusIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="testcaseID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="testcaseID" msprop:Generator_ColumnPropNameInRow="testcaseID" msprop:Generator_ColumnVarNameInTable="columntestcaseID" msprop:Generator_ColumnPropNameInTable="testcaseIDColumn" type="xs:int" /> - <xs:element name="creatorID" msprop:Generator_UserColumnName="creatorID" msprop:Generator_ColumnPropNameInRow="creatorID" msprop:Generator_ColumnVarNameInTable="columncreatorID" msprop:Generator_ColumnPropNameInTable="creatorIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="lastEditID" msprop:Generator_UserColumnName="lastEditID" msprop:Generator_ColumnPropNameInRow="lastEditID" msprop:Generator_ColumnVarNameInTable="columnlastEditID" msprop:Generator_ColumnPropNameInTable="lastEditIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="number" msprop:Generator_UserColumnName="number" msprop:Generator_ColumnPropNameInRow="number" msprop:Generator_ColumnVarNameInTable="columnnumber" msprop:Generator_ColumnPropNameInTable="numberColumn" type="xs:int" minOccurs="0" /> + <xs:element name="dateCreated" msprop:Generator_UserColumnName="dateCreated" msprop:Generator_ColumnPropNameInRow="dateCreated" msprop:Generator_ColumnVarNameInTable="columndateCreated" msprop:Generator_ColumnPropNameInTable="dateCreatedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="dateEdited" msprop:Generator_UserColumnName="dateEdited" msprop:Generator_ColumnPropNameInRow="dateEdited" msprop:Generator_ColumnVarNameInTable="columndateEdited" msprop:Generator_ColumnPropNameInTable="dateEditedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="objectiveID" msprop:Generator_UserColumnName="objectiveID" msprop:Generator_ColumnPropNameInRow="objectiveID" msprop:Generator_ColumnVarNameInTable="columnobjectiveID" msprop:Generator_ColumnPropNameInTable="objectiveIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="statusID" msprop:Generator_UserColumnName="statusID" msprop:Generator_ColumnPropNameInRow="statusID" msprop:Generator_ColumnVarNameInTable="columnstatusID" msprop:Generator_ColumnPropNameInTable="statusIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="testcaseID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="testcaseID" msprop:Generator_ColumnVarNameInTable="columntestcaseID" msprop:Generator_ColumnPropNameInRow="testcaseID" msprop:Generator_ColumnPropNameInTable="testcaseIDColumn" type="xs:int" /> + <xs:element name="creatorID" msprop:Generator_UserColumnName="creatorID" msprop:Generator_ColumnVarNameInTable="columncreatorID" msprop:Generator_ColumnPropNameInRow="creatorID" msprop:Generator_ColumnPropNameInTable="creatorIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="lastEditID" msprop:Generator_UserColumnName="lastEditID" msprop:Generator_ColumnVarNameInTable="columnlastEditID" msprop:Generator_ColumnPropNameInRow="lastEditID" msprop:Generator_ColumnPropNameInTable="lastEditIDColumn" type="xs:int" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Tags" msprop:Generator_UserTableName="Tags" msprop:Generator_RowDeletedName="TagsRowDeleted" msprop:Generator_RowChangedName="TagsRowChanged" msprop:Generator_RowClassName="TagsRow" msprop:Generator_RowChangingName="TagsRowChanging" msprop:Generator_RowEvArgName="TagsRowChangeEvent" msprop:Generator_RowEvHandlerName="TagsRowChangeEventHandler" msprop:Generator_TableClassName="TagsDataTable" msprop:Generator_TableVarName="tableTags" msprop:Generator_RowDeletingName="TagsRowDeleting" msprop:Generator_TablePropName="Tags"> <xs:complexType> <xs:sequence> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn"> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="tagID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="tagID" msprop:Generator_ColumnPropNameInRow="tagID" msprop:Generator_ColumnVarNameInTable="columntagID" msprop:Generator_ColumnPropNameInTable="tagIDColumn" type="xs:int" /> - <xs:element name="productID" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" /> + <xs:element name="tagID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="tagID" msprop:Generator_ColumnVarNameInTable="columntagID" msprop:Generator_ColumnPropNameInRow="tagID" msprop:Generator_ColumnPropNameInTable="tagIDColumn" type="xs:int" /> + <xs:element name="productID" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="product" msprop:Generator_UserTableName="product" msprop:Generator_RowDeletedName="productRowDeleted" msprop:Generator_RowChangedName="productRowChanged" msprop:Generator_RowClassName="productRow" msprop:Generator_RowChangingName="productRowChanging" msprop:Generator_RowEvArgName="productRowChangeEvent" msprop:Generator_RowEvHandlerName="productRowChangeEventHandler" msprop:Generator_TableClassName="productDataTable" msprop:Generator_TableVarName="tableproduct" msprop:Generator_RowDeletingName="productRowDeleting" msprop:Generator_TablePropName="product"> <xs:complexType> <xs:sequence> - <xs:element name="productID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="productID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="devManager" msprop:Generator_UserColumnName="devManager" msprop:Generator_ColumnVarNameInTable="columndevManager" msprop:Generator_ColumnPropNameInRow="devManager" msprop:Generator_ColumnPropNameInTable="devManagerColumn" type="xs:int" minOccurs="0" /> - <xs:element name="qaManager" msprop:Generator_UserColumnName="qaManager" msprop:Generator_ColumnVarNameInTable="columnqaManager" msprop:Generator_ColumnPropNameInRow="qaManager" msprop:Generator_ColumnPropNameInTable="qaManagerColumn" type="xs:int" minOccurs="0" /> - <xs:element name="devLead" msprop:Generator_UserColumnName="devLead" msprop:Generator_ColumnVarNameInTable="columndevLead" msprop:Generator_ColumnPropNameInRow="devLead" msprop:Generator_ColumnPropNameInTable="devLeadColumn" type="xs:int" minOccurs="0" /> - <xs:element name="qaLead" msprop:Generator_UserColumnName="qaLead" msprop:Generator_ColumnVarNameInTable="columnqaLead" msprop:Generator_ColumnPropNameInRow="qaLead" msprop:Generator_ColumnPropNameInTable="qaLeadColumn" type="xs:int" minOccurs="0" /> - <xs:element name="pm" msprop:Generator_UserColumnName="pm" msprop:Generator_ColumnVarNameInTable="columnpm" msprop:Generator_ColumnPropNameInRow="pm" msprop:Generator_ColumnPropNameInTable="pmColumn" type="xs:int" minOccurs="0" /> - <xs:element name="codeName" msprop:Generator_UserColumnName="codeName" msprop:Generator_ColumnVarNameInTable="columncodeName" msprop:Generator_ColumnPropNameInRow="codeName" msprop:Generator_ColumnPropNameInTable="codeNameColumn" minOccurs="0"> + <xs:element name="devManager" msprop:Generator_UserColumnName="devManager" msprop:Generator_ColumnPropNameInRow="devManager" msprop:Generator_ColumnVarNameInTable="columndevManager" msprop:Generator_ColumnPropNameInTable="devManagerColumn" type="xs:int" minOccurs="0" /> + <xs:element name="qaManager" msprop:Generator_UserColumnName="qaManager" msprop:Generator_ColumnPropNameInRow="qaManager" msprop:Generator_ColumnVarNameInTable="columnqaManager" msprop:Generator_ColumnPropNameInTable="qaManagerColumn" type="xs:int" minOccurs="0" /> + <xs:element name="devLead" msprop:Generator_UserColumnName="devLead" msprop:Generator_ColumnPropNameInRow="devLead" msprop:Generator_ColumnVarNameInTable="columndevLead" msprop:Generator_ColumnPropNameInTable="devLeadColumn" type="xs:int" minOccurs="0" /> + <xs:element name="qaLead" msprop:Generator_UserColumnName="qaLead" msprop:Generator_ColumnPropNameInRow="qaLead" msprop:Generator_ColumnVarNameInTable="columnqaLead" msprop:Generator_ColumnPropNameInTable="qaLeadColumn" type="xs:int" minOccurs="0" /> + <xs:element name="pm" msprop:Generator_UserColumnName="pm" msprop:Generator_ColumnPropNameInRow="pm" msprop:Generator_ColumnVarNameInTable="columnpm" msprop:Generator_ColumnPropNameInTable="pmColumn" type="xs:int" minOccurs="0" /> + <xs:element name="codeName" msprop:Generator_UserColumnName="codeName" msprop:Generator_ColumnPropNameInRow="codeName" msprop:Generator_ColumnVarNameInTable="columncodeName" msprop:Generator_ColumnPropNameInTable="codeNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> @@ -1301,51 +1369,51 @@ <xs:element name="Users" msprop:Generator_UserTableName="Users" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowClassName="UsersRow" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_TablePropName="Users"> <xs:complexType> <xs:sequence> - <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInTable="emailColumn" minOccurs="0"> + <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="officePhone" msprop:Generator_UserColumnName="officePhone" msprop:Generator_ColumnPropNameInRow="officePhone" msprop:Generator_ColumnVarNameInTable="columnofficePhone" msprop:Generator_ColumnPropNameInTable="officePhoneColumn" minOccurs="0"> + <xs:element name="officePhone" msprop:Generator_UserColumnName="officePhone" msprop:Generator_ColumnVarNameInTable="columnofficePhone" msprop:Generator_ColumnPropName... [truncated message content] |
