Menu
▾
▴
tcdb-devel — Development Issues
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(5) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
(4) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2006 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(16) |
Jun
(41) |
Jul
(101) |
Aug
(71) |
Sep
|
Oct
|
Nov
|
Dec
|
|
From: <ro...@us...> - 2006-06-12 19:15:47
|
Revision: 27 Author: rouquin Date: 2006-06-12 12:15:21 -0700 (Mon, 12 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=27&view=rev Log Message: ----------- Added a DatePicker and fixed some database bugs I ran into. Modified Paths: -------------- WebPrototype/ActionItemEdit.aspx WebPrototype/ActionItemEdit.aspx.cs WebPrototype/App_Code/DummyDataSet.xsd WebPrototype/App_Code/DummyDataSet.xss WebPrototype/App_Data/ASPNETDB.MDF WebPrototype/App_Data/Database.mdf WebPrototype/App_Data/Database_log.LDF WebPrototype/App_Data/aspnetdb_log.ldf Added Paths: ----------- WebPrototype/Bin/EclipseWebSolutions.CustomControls.dll Modified: WebPrototype/ActionItemEdit.aspx =================================================================== --- WebPrototype/ActionItemEdit.aspx 2006-06-09 21:20:34 UTC (rev 26) +++ WebPrototype/ActionItemEdit.aspx 2006-06-12 19:15:21 UTC (rev 27) @@ -2,6 +2,9 @@ ValidateRequest="false" CodeFile="ActionItemEdit.aspx.cs" Inherits="ActionItemEdit" Title="Action Item" %> +<%@ Register Assembly="EclipseWebSolutions.CustomControls" Namespace="EclipseWebSolutions.CustomControls" + TagPrefix="cc1" %> + <%@ Register Assembly="FreeTextBox" Namespace="FreeTextBoxControls" TagPrefix="FTB" %> <%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="atlas" %> <asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> @@ -10,7 +13,7 @@ <tr> <td width="*" valign="top"> <asp:FormView ID="FormView1" runat="server" DataSourceID="myDS" DataKeyNames="id" - CellPadding=4 ForeColor="#333333" Height=348px> + CellPadding=4 ForeColor="#333333" Height=348px OnItemUpdated=FormView1_ItemUpdated OnItemInserted=FormView1_ItemInserted> <EditItemTemplate> <div class="xsnazzy"> <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> @@ -20,11 +23,13 @@ <tr> <td colspan="2" style="width: 239px; height: 11px;"> Name: <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width="100%" /></td> - <td align=right colspan=1 style="width: 576px; height: 11px"> - </td> - <td colspan="1" style="width: 576px; height: 11px;" align="right"> + <td align=right colspan=2 style="height: 11px"> + Due Date: + <cc1:DatePicker + ID="DatePicker1" + runat="server" + DateFormatString="MM/dd/yyyy" OnInit=DatePicker1_Init/> - Due Date: <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("dateStamp") %>' Width=81px /> </td> </tr> <tr> @@ -55,7 +60,7 @@ </td> <td align=right colspan=1 style="width: 576px; height: 23px"> Assigned To: - <asp:TextBox ID="assignedToTextBox" runat="server" Text='<%# Bind("assignedTo") %>'></asp:TextBox> </td> + <asp:TextBox ID="ownerTextBox" runat="server" Text='<%# Bind("owner") %>'></asp:TextBox> </td> <td colspan=1 style="width: 576px; height: 23px" align=right> Assigned By:<asp:TextBox ID="userIDTextBox" runat="server" Text='<%# Bind("userID") %>'></asp:TextBox></td> </tr> @@ -72,31 +77,31 @@ <div class="xboxcontent"> <table> <tr> - <td colspan=2 style="width: 3048px; height: 19px;"> + <td colspan=3 style="width: 3048px; height: 19px;"> <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' Style="font-size: large; color: black; font-family: Arial;"></asp:Label> </td> - <td align=right colspan=2 style="height: 19px"> + <td align=right colspan=2 style="height: 19px; width: 179px;"> Due Date: <asp:Label ID="dateStampLabel" runat="server" Text='<%# Eval("dateStamp") %>'></asp:Label></td> </tr> <tr> - <td colspan="4" class="hr"> + <td colspan="5" class="hr"> <img alt="" src="images/spacer.gif" height="5" /><br /> </td> </tr> <tr> - <td colspan=4 style="height: 197px" valign=top> + <td colspan=5 style="height: 197px" valign=top> <asp:Label ID="descriptionLabel" runat="server" Text='<%# Eval("description") %>'></asp:Label> </td> </tr> <tr> - <td colspan="4" class="hr" style="height: 1px"> + <td colspan="5" class="hr" style="height: 1px"> <img alt="" src="images/spacer.gif" height="5" /><br /> </td> </tr> <tr> - <td colspan=1 style="height: 16px; width: 3048px;"> + <td colspan=1 style="height: 16px; width: 15%;"> <br /> <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"> @@ -107,10 +112,12 @@ <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete"> </asp:LinkButton>| </td> - <td align=right colspan=1 style="width: 1217px; height: 16px"> + <td align=right colspan=1 style="width: 25%; height: 16px"> + </td> + <td align=right colspan=1 style="width: 25%; height: 16px"> Assigned To: - <asp:Label ID="Label1" runat="server" Text='<%# Eval("assignedTo", "{0}") %>'></asp:Label></td> - <td colspan=1 style="width: 594px; height: 16px" align=right> + <asp:Label ID="Label1" runat="server" Text='<%# Eval("owner") %>'></asp:Label></td> + <td colspan=1 style="width: 25%; height: 16px" align=right> Assigned By:<asp:Label ID="userIDLabel" runat="server" Text='<%# Eval("userID") %>'></asp:Label></td> </tr> </table> @@ -161,8 +168,8 @@ <td align=right colspan=1 style="width: 576px; height: 11px"> </td> <td colspan="1" style="width: 576px; height: 11px;" align="right"> - Due Date: - <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("dateStamp") %>' Width=81px /> + Due Date:<cc1:DatePicker ID="DatePicker2" runat="server" /> + </td> </tr> <tr> @@ -192,7 +199,7 @@ </td> <td align=right colspan=1 style="width: 576px; height: 23px"> Assigned To: - <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("assignedTo", "{0}") %>'></asp:TextBox> </td> + <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("owner", "{0}") %>'></asp:TextBox> </td> <td colspan=1 style="width: 576px; height: 23px" align=right> Assigned By: <asp:TextBox ID="TextBoxuserID" runat="server" Text='<%# Bind("userID") %>'></asp:TextBox></td> @@ -204,34 +211,38 @@ </div> </InsertItemTemplate> </asp:FormView> - </td> - <asp:ObjectDataSource ID="myDS" runat="server" SelectMethod="GetDummyActionItemData" - TypeName="DummyDataSetTableAdapters.ActionItemsTableAdapter" InsertMethod="InsertAll" - DeleteMethod="DeleteById" OldValuesParameterFormatString="original_{0}" UpdateMethod="UpdateByID"> - <SelectParameters> - <asp:Parameter Name="id" Type="Int32" /> - </SelectParameters> - <DeleteParameters> - <asp:Parameter Name="original_id" Type="Int32" /> - </DeleteParameters> - <InsertParameters> - <asp:Parameter Name="name" Type="String" /> - <asp:Parameter Name="description" Type="String" /> - <asp:Parameter Name="userID" Type="String" /> - <asp:Parameter Name="dateStamp" Type="String" /> - <asp:Parameter Name="percentFinished" Type="Int32" /> - <asp:Parameter Name="state" Type="String" /> - <asp:Parameter Name="assignedTo" Type="String" /> - </InsertParameters> - <UpdateParameters> - <asp:Parameter Name="name" Type="String" /> - <asp:Parameter Name="description" Type="String" /> - <asp:Parameter Name="userID" Type="String" /> - <asp:Parameter Name="dateStamp" Type="String" /> - <asp:Parameter Name="assignedTo" Type="String" /> - <asp:Parameter Name="original_ID" Type="Int32" /> - </UpdateParameters> - </asp:ObjectDataSource> + <asp:ObjectDataSource + ID="myDS" + runat="server" + DeleteMethod="DeleteById" + InsertMethod="InsertAll" + OldValuesParameterFormatString="original_{0}" + SelectMethod="GetDummyActionItemData" + TypeName="DummyDataSetTableAdapters.ActionItemsTableAdapter" + UpdateMethod="UpdateByID"> + <DeleteParameters> + <asp:Parameter Name="original_id" Type="Int32" /> + </DeleteParameters> + <UpdateParameters> + <asp:Parameter Name="name" Type="String" /> + <asp:Parameter Name="description" Type="String" /> + <asp:Parameter Name="userID" Type="String" /> + <asp:Parameter Name="owner" Type="String" /> + <asp:Parameter Name="original_ID" Type="Int32" /> + </UpdateParameters> + <SelectParameters> + <asp:Parameter DefaultValue="0" Name="id" Type="Int32" /> + </SelectParameters> + <InsertParameters> + <asp:Parameter Name="name" Type="String" /> + <asp:Parameter Name="description" Type="String" /> + <asp:Parameter Name="userID" Type="String" /> + <asp:Parameter Name="percentFinished" Type="Int32" /> + <asp:Parameter Name="state" Type="Int32" /> + <asp:Parameter Name="owner" Type="String" /> + </InsertParameters> + </asp:ObjectDataSource> + </td> <td width="300px" align="right" valign="top"> <table width="100%" cellpadding="0" cellspacing="0" border="0" style="padding: 10px;"> <tr> Modified: WebPrototype/ActionItemEdit.aspx.cs =================================================================== --- WebPrototype/ActionItemEdit.aspx.cs 2006-06-09 21:20:34 UTC (rev 26) +++ WebPrototype/ActionItemEdit.aspx.cs 2006-06-12 19:15:21 UTC (rev 27) @@ -21,10 +21,13 @@ src.Select(); myDS.SelectParameters["id"].DefaultValue = id.ToString(); + System.Convert.ToDateTime("06/13/2006"); } protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) { - RadioButtonList rbl = (RadioButtonList) FormView1.FindControl("RadioButtonList1"); + if (FormView1.CurrentMode == FormViewMode.Insert) return; + + RadioButtonList rbl = (RadioButtonList) sender; ObjectDataSource src = new ObjectDataSource("ActionItems","GetDummyActionItemData"); src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; @@ -35,7 +38,9 @@ } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { - DropDownList ddl = (DropDownList)FormView1.FindControl("DropDownList1"); + if (FormView1.CurrentMode == FormViewMode.Insert) return; + + DropDownList ddl = (DropDownList)sender; ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; @@ -44,4 +49,49 @@ src.UpdateParameters.Add(new Parameter("original_id", TypeCode.Int32, id.ToString())); src.Update(); } + protected void DatePicker1_Init(object sender, EventArgs e) + { + EclipseWebSolutions.CustomControls.DatePicker dp = (EclipseWebSolutions.CustomControls.DatePicker) sender; + ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); + + src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.SelectMethod = "dateQuery"; + src.SelectParameters.Add(new Parameter("id", TypeCode.Int32, id.ToString())); + IEnumerable obj = src.Select(); + IEnumerator num = null; + DateTime dt; + if (obj != null) + { + num = src.Select().GetEnumerator(); + num.MoveNext(); + dt = System.Convert.ToDateTime(num.Current); + dp.DateValue = dt; + } + } + protected void FormView1_ItemUpdated(object sender, FormViewUpdatedEventArgs e) + { + EclipseWebSolutions.CustomControls.DatePicker dp = (EclipseWebSolutions.CustomControls.DatePicker)FormView1.FindControl("DatePicker1"); + ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); + + src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.UpdateMethod = "UpdateDateStampByID"; + src.UpdateParameters.Add(new Parameter("dateStamp", TypeCode.String, dp.DateValue.ToString(dp.DateFormatString))); + src.UpdateParameters.Add(new Parameter("original_id", TypeCode.Int32, id.ToString())); + src.Update(); + } + protected void FormView1_ItemInserted(object sender, FormViewInsertedEventArgs e) + { + EclipseWebSolutions.CustomControls.DatePicker dp = (EclipseWebSolutions.CustomControls.DatePicker)FormView1.FindControl("DatePicker2"); + DropDownList ddl = (DropDownList)FormView1.FindControl("DropDownList1"); + RadioButtonList rbl = (RadioButtonList)FormView1.FindControl("RadioButtonList1"); + ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); + + src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.UpdateMethod = "UpdateThreeByID"; + src.UpdateParameters.Add(new Parameter("dateStamp", TypeCode.String, dp.DateValue.ToString(dp.DateFormatString))); + src.UpdateParameters.Add(new Parameter("percentFinished", TypeCode.Int32, rbl.SelectedIndex.ToString())); + src.UpdateParameters.Add(new Parameter("state", TypeCode.String, ddl.SelectedValue)); + src.Update(); + Response.Redirect("~/Assignments.aspx"); + } } Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-09 21:20:34 UTC (rev 26) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-06-12 19:15:21 UTC (rev 27) @@ -106,7 +106,7 @@ <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.ActionItems" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillDummyActionItemData" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetDummyActionItemData" GeneratorSourceName="FillDummyActionItemData" GetMethodModifier="Public" GetMethodName="GetDummyActionItemData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyActionItemData" UserSourceName="FillDummyActionItemData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT id, name, description, userID, dateStamp, percentFinished, state, assignedTo + <CommandText>SELECT id, name, description, userID, dateStamp, percentFinished, state, owner FROM ActionItems WHERE (id = @id)</CommandText> <Parameters> @@ -125,10 +125,23 @@ <Mapping SourceColumn="percentFinished" DataSetColumn="percentFinished" /> <Mapping SourceColumn="state" DataSetColumn="state" /> <Mapping SourceColumn="userID" DataSetColumn="userID" /> - <Mapping SourceColumn="assignedTo" DataSetColumn="assignedTo" /> + <Mapping SourceColumn="owner" DataSetColumn="owner" /> </Mappings> <Sources> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="DeleteById" Modifier="Public" Name="DeleteById" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="DeleteById"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.ActionItems" DbObjectType="Table" GenerateShortCommands="True" GeneratorSourceName="dateQuery" Modifier="Public" Name="dateQuery" QueryType="Scalar" ScalarCallRetval="System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="dateQuery"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT dateStamp +FROM ActionItems +WHERE (id = @id)</CommandText> + <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="DeleteById" Modifier="Public" Name="DeleteById" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="DeleteById"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>DELETE FROM ActionItems @@ -140,12 +153,12 @@ </DbCommand> </DeleteCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertAll" Modifier="Public" Name="InsertAll" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="InsertAll"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertAll" Modifier="Public" Name="InsertAll" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="InsertAll"> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>INSERT INTO ActionItems - (name, description, userID, dateStamp, percentFinished, state, assignedTo) -VALUES (@name,@description,@userID,@dateStamp,@percentFinished,@state,@assignedTo)</CommandText> + (name, description, userID, percentFinished, state, owner) +VALUES (@name,@description,@userID,@percentFinished,@state,@owner)</CommandText> <Parameters> <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(255)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="255" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> @@ -153,23 +166,21 @@ </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="userID" ColumnName="userID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(50)" DbType="String" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="NChar" Scale="0" Size="50" SourceColumn="userID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="dateStamp" ColumnName="dateStamp" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="dateStamp" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="percentFinished" ColumnName="percentFinished" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="percentFinished" ColumnName="percentFinished" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="state" ColumnName="state" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@state" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="state" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="assignedTo" ColumnName="assignedTo" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@assignedTo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="assignedTo" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="owner" ColumnName="owner" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@owner" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="owner" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> </Parameters> </DbCommand> </InsertCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="UpdateByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="UpdateByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE ActionItems -SET name = @name, description = @description, userID = @userID, dateStamp = @dateStamp, assignedTo = @assignedTo +SET name = @name, description = @description, userID = @userID, owner = @owner WHERE (id = @original_ID)</CommandText> <Parameters> <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(255)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="255" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> @@ -178,22 +189,35 @@ </Parameter> <Parameter AllowDbNull="True" AutogeneratedName="userID" ColumnName="userID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(50)" DbType="String" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="NChar" Scale="0" Size="50" SourceColumn="userID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="dateStamp" ColumnName="dateStamp" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="dateStamp" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="True" AutogeneratedName="owner" ColumnName="owner" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@owner" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="owner" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="assignedTo" ColumnName="assignedTo" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@assignedTo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="assignedTo" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> <Parameter AllowDbNull="False" AutogeneratedName="original_ID" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original"> </Parameter> </Parameters> </DbCommand> </UpdateCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdatePercentByID" Modifier="Public" Name="UpdatePercentByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="UpdatePercentByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateDateStampByID" Modifier="Public" Name="UpdateDateStampByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy7" UserSourceName="UpdateDateStampByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE ActionItems +SET dateStamp = @dateStamp +WHERE (id = @original_id)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="dateStamp" ColumnName="dateStamp" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dateStamp" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="False" AutogeneratedName="original_id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original"> + </Parameter> + </Parameters> + </DbCommand> + </UpdateCommand> + </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdatePercentByID" Modifier="Public" Name="UpdatePercentByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy4" UserSourceName="UpdatePercentByID"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE ActionItems SET percentFinished=@percentFinished WHERE id=@original_id</CommandText> <Parameters> - <Parameter AllowDbNull="True" AutogeneratedName="percentFinished" ColumnName="percentFinished" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="percentFinished" ColumnName="percentFinished" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> <Parameter AllowDbNull="False" AutogeneratedName="original_id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original"> </Parameter> @@ -201,7 +225,7 @@ </DbCommand> </UpdateCommand> </DbSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateStateByID" Modifier="Public" Name="UpdateStateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy4" UserSourceName="UpdateStateByID"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateStateByID" Modifier="Public" Name="UpdateStateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy5" UserSourceName="UpdateStateByID"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>UPDATE ActionItems @@ -216,6 +240,25 @@ </DbCommand> </UpdateCommand> </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy6" GeneratorSourceName="UpdateThreeByID" Modifier="Public" Name="UpdateThreeByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy6" UserSourceName="UpdateThreeByID"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE ActionItems +SET dateStamp = @dateStamp, percentFinished = @percentFinished, state = @state +WHERE (id IN + (SELECT MAX(id) AS Expr1 + FROM ActionItems AS ActionItems_1))</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="dateStamp" ColumnName="dateStamp" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dateStamp" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="False" AutogeneratedName="percentFinished" ColumnName="percentFinished" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="state" ColumnName="state" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@state" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="state" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </UpdateCommand> + </DbSource> </Sources> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FeatureTableAdapter" GeneratorDataComponentClassName="FeatureTableAdapter" Name="Feature" UserDataComponentName="FeatureTableAdapter"> @@ -498,11 +541,11 @@ <xs:element name="dateStamp" msprop:Generator_UserColumnName="dateStamp" msprop:Generator_ColumnPropNameInRow="dateStamp" msprop:Generator_ColumnVarNameInTable="columndateStamp" msprop:Generator_ColumnPropNameInTable="dateStampColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> - <xs:maxLength value="20" /> + <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="percentFinished" msprop:Generator_UserColumnName="percentFinished" msprop:Generator_ColumnPropNameInRow="percentFinished" msprop:Generator_ColumnVarNameInTable="columnpercentFinished" msprop:Generator_ColumnPropNameInTable="percentFinishedColumn" type="xs:int" minOccurs="0" /> + <xs:element name="percentFinished" msprop:Generator_UserColumnName="percentFinished" msprop:Generator_ColumnPropNameInRow="percentFinished" msprop:Generator_ColumnVarNameInTable="columnpercentFinished" msprop:Generator_ColumnPropNameInTable="percentFinishedColumn" type="xs:int" /> <xs:element name="state" msprop:Generator_UserColumnName="state" msprop:Generator_ColumnVarNameInTable="columnstate" msprop:Generator_ColumnPropNameInRow="state" msprop:Generator_ColumnPropNameInTable="stateColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> @@ -517,10 +560,10 @@ </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="assignedTo" msprop:Generator_UserColumnName="assignedTo" msprop:Generator_ColumnPropNameInRow="assignedTo" msprop:Generator_ColumnVarNameInTable="columnassignedTo" msprop:Generator_ColumnPropNameInTable="assignedToColumn" minOccurs="0"> + <xs:element name="owner" msprop:Generator_UserColumnName="owner" msprop:Generator_ColumnPropNameInRow="owner" msprop:Generator_ColumnVarNameInTable="columnowner" msprop:Generator_ColumnPropNameInTable="ownerColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> - <xs:maxLength value="10" /> + <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> Modified: WebPrototype/App_Code/DummyDataSet.xss =================================================================== --- WebPrototype/App_Code/DummyDataSet.xss 2006-06-09 21:20:34 UTC (rev 26) +++ WebPrototype/App_Code/DummyDataSet.xss 2006-06-12 19:15:21 UTC (rev 27) @@ -4,15 +4,15 @@ Changes to this file may cause incorrect behavior and will be lost if the code is regenerated. </autogenerated>--> -<DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="55" ViewPortY="-10" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout"> +<DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="54" ViewPortY="-10" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout"> <Shapes> <Shape ID="DesignTable:Assignments" ZOrder="7" X="70" Y="70" Height="275" Width="239" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="228" /> <Shape ID="DesignTable:WorkOrder" ZOrder="6" X="370" Y="311" Height="207" Width="204" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="22" SplitterPosition="160" /> - <Shape ID="DesignTable:ActionItems" ZOrder="5" X="425" Y="15" Height="275" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="22" OldDataTableHeight="22" SplitterPosition="160" /> - <Shape ID="DesignTable:Feature" ZOrder="4" X="111" Y="368" Height="207" Width="185" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="160" /> - <Shape ID="DesignTable:Objective" ZOrder="3" X="845" Y="115" Height="173" Width="195" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" /> - <Shape ID="DesignTable:TestCase" ZOrder="2" X="623" Y="349" Height="224" Width="192" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="177" /> - <Shape ID="DesignTable:Tags" ZOrder="1" X="937" Y="377" Height="105" Width="183" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="58" /> + <Shape ID="DesignTable:ActionItems" ZOrder="1" X="424" Y="17" Height="275" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="22" OldDataTableHeight="22" SplitterPosition="160" /> + <Shape ID="DesignTable:Feature" ZOrder="5" X="111" Y="368" Height="207" Width="185" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="160" /> + <Shape ID="DesignTable:Objective" ZOrder="4" X="845" Y="115" Height="173" Width="195" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" /> + <Shape ID="DesignTable:TestCase" ZOrder="3" X="623" Y="349" Height="224" Width="192" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="177" /> + <Shape ID="DesignTable:Tags" ZOrder="2" X="937" Y="377" Height="105" Width="183" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="58" /> </Shapes> <Connectors /> </DiagramLayout> \ No newline at end of file Modified: WebPrototype/App_Data/ASPNETDB.MDF =================================================================== (Binary files differ) Modified: WebPrototype/App_Data/Database.mdf =================================================================== (Binary files differ) Modified: WebPrototype/App_Data/Database_log.LDF =================================================================== (Binary files differ) Modified: WebPrototype/App_Data/aspnetdb_log.ldf =================================================================== (Binary files differ) Added: WebPrototype/Bin/EclipseWebSolutions.CustomControls.dll =================================================================== (Binary files differ) Property changes on: WebPrototype/Bin/EclipseWebSolutions.CustomControls.dll ___________________________________________________________________ Name: svn:mime-type + application/octet-stream This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <jon...@us...> - 2006-06-09 21:20:42
|
Revision: 26 Author: jon_r_johnson Date: 2006-06-09 14:20:34 -0700 (Fri, 09 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=26&view=rev Log Message: ----------- Removed columns include, minVersion, and maxVersion from the table tcdb_platformVersion for the same reasons as from tcdb_featureVersion a few minutes ago. Modified Paths: -------------- Schema/TCDBSQLServer2005.sql Modified: Schema/TCDBSQLServer2005.sql =================================================================== --- Schema/TCDBSQLServer2005.sql 2006-06-09 21:00:57 UTC (rev 25) +++ Schema/TCDBSQLServer2005.sql 2006-06-09 21:20:34 UTC (rev 26) @@ -594,9 +594,6 @@ |
|
From: <jon...@us...> - 2006-06-09 21:01:06
|
Revision: 25 Author: jon_r_johnson Date: 2006-06-09 14:00:57 -0700 (Fri, 09 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=25&view=rev Log Message: ----------- Removed columns include, minversion, maxversion from table tcdb_featureVersion. Faster queries will be achieved by using this table to include only features that apply to each individual version rather then running between statements. Modified Paths: -------------- Schema/TCDBSQLServer2005.sql Modified: Schema/TCDBSQLServer2005.sql =================================================================== --- Schema/TCDBSQLServer2005.sql 2006-06-09 19:11:14 UTC (rev 24) +++ Schema/TCDBSQLServer2005.sql 2006-06-09 21:00:57 UTC (rev 25) @@ -59,9 +59,6 @@ |
|
From: <sla...@us...> - 2006-06-09 19:11:26
|
Revision: 24 Author: slambson Date: 2006-06-09 12:11:14 -0700 (Fri, 09 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=24&view=rev Log Message: ----------- Flow diagram. Hopefully it is accurate. If I get feedback that it is not then I will update it. Added Paths: ----------- Design/UI/flow-diagram.jpg Added: Design/UI/flow-diagram.jpg =================================================================== (Binary files differ) Property changes on: Design/UI/flow-diagram.jpg ___________________________________________________________________ Name: svn:mime-type + application/octet-stream This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <ro...@us...> - 2006-06-09 19:03:32
|
Revision: 23 Author: rouquin Date: 2006-06-09 12:03:05 -0700 (Fri, 09 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=23&view=rev Log Message: ----------- Added changes for ActionItemEdit Modified Paths: -------------- WebPrototype/App_Code/DummyDataSet.xsd WebPrototype/App_Code/DummyDataSet.xss WebPrototype/App_Data/ASPNETDB.MDF WebPrototype/App_Data/Database.mdf WebPrototype/App_Data/Database_log.LDF WebPrototype/App_Data/aspnetdb_log.ldf WebPrototype/App_Themes/Python/python.css WebPrototype/Assignments.aspx WebPrototype/Details.aspx WebPrototype/MasterPage.master WebPrototype/Web.config WebPrototype/Web.sitemap Added Paths: ----------- WebPrototype/ActionItemEdit.aspx WebPrototype/ActionItemEdit.aspx.cs WebPrototype/Bin/FreeTextBox.dll Added: WebPrototype/ActionItemEdit.aspx =================================================================== --- WebPrototype/ActionItemEdit.aspx (rev 0) +++ WebPrototype/ActionItemEdit.aspx 2006-06-09 19:03:05 UTC (rev 23) @@ -0,0 +1,287 @@ +<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" + ValidateRequest="false" CodeFile="ActionItemEdit.aspx.cs" Inherits="ActionItemEdit" + Title="Action Item" %> + +<%@ Register Assembly="FreeTextBox" Namespace="FreeTextBoxControls" TagPrefix="FTB" %> +<%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="atlas" %> +<asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> + + <table border="0" cellpadding="0" cellspacing="0" width="100%"> + <tr> + <td width="*" valign="top"> + <asp:FormView ID="FormView1" runat="server" DataSourceID="myDS" DataKeyNames="id" + CellPadding=4 ForeColor="#333333" Height=348px> + <EditItemTemplate> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <table> + <tr> + <td colspan="2" style="width: 239px; height: 11px;"> + Name: <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width="100%" /></td> + <td align=right colspan=1 style="width: 576px; height: 11px"> + </td> + <td colspan="1" style="width: 576px; height: 11px;" align="right"> + + Due Date: <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("dateStamp") %>' Width=81px /> + </td> + </tr> + <tr> + <td colspan="4" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan="4" style="height: 197px"> + Description:<br /> + <FTB:FreeTextBox ID="FreeTextBox1" runat="server" SupportFolder="~" + Text='<%# Bind("description") %>' Height="100%" Width="100%" /> + </td> + </tr> + <tr> + <td colspan="4" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan=1 style="height: 23px; width: 239px;"> + <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" + Text="Update"> + </asp:LinkButton> + <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" + Text="Cancel"> + </asp:LinkButton> + </td> + <td align=right colspan=1 style="width: 576px; height: 23px"> + Assigned To: + <asp:TextBox ID="assignedToTextBox" runat="server" Text='<%# Bind("assignedTo") %>'></asp:TextBox> </td> + <td colspan=1 style="width: 576px; height: 23px" align=right> + Assigned By:<asp:TextBox ID="userIDTextBox" runat="server" Text='<%# Bind("userID") %>'></asp:TextBox></td> + </tr> + </table> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </EditItemTemplate> + <ItemTemplate> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <table> + <tr> + <td colspan=2 style="width: 3048px; height: 19px;"> + <asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' Style="font-size: large; + color: black; font-family: Arial;"></asp:Label> + </td> + <td align=right colspan=2 style="height: 19px"> + Due Date: + <asp:Label ID="dateStampLabel" runat="server" Text='<%# Eval("dateStamp") %>'></asp:Label></td> + </tr> + <tr> + <td colspan="4" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan=4 style="height: 197px" valign=top> + <asp:Label ID="descriptionLabel" runat="server" Text='<%# Eval("description") %>'></asp:Label> + </td> + </tr> + <tr> + <td colspan="4" class="hr" style="height: 1px"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan=1 style="height: 16px; width: 3048px;"> + <br /> + <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" + Text="Edit"> + </asp:LinkButton>| + <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" + Text="New"> + </asp:LinkButton>| + <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" + Text="Delete"> + </asp:LinkButton>| </td> + <td align=right colspan=1 style="width: 1217px; height: 16px"> + Assigned To: + <asp:Label ID="Label1" runat="server" Text='<%# Eval("assignedTo", "{0}") %>'></asp:Label></td> + <td colspan=1 style="width: 594px; height: 16px" align=right> + Assigned By:<asp:Label ID="userIDLabel" runat="server" Text='<%# Eval("userID") %>'></asp:Label></td> + </tr> + </table> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </ItemTemplate> + <HeaderTemplate> + <div id="ActionItem"> + <table> + <tr> + <td style="width: 179px; height: 37px"> + <h2> + Action Item</h2> + </td> + <td align=right style="width: 657px; height: 37px"> + <div id="radiolist"> + <asp:RadioButtonList ID="RadioButtonList1" runat="server" RepeatDirection="Horizontal" SelectedIndex='<%# Bind("percentFinished") %>' AutoPostBack=True OnSelectedIndexChanged=RadioButtonList1_SelectedIndexChanged> + <asp:ListItem Selected=True>0%</asp:ListItem> + <asp:ListItem>25%</asp:ListItem> + <asp:ListItem>50%</asp:ListItem> + <asp:ListItem>75%</asp:ListItem> + <asp:ListItem>100%</asp:ListItem> + </asp:RadioButtonList>| + <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" + SelectedValue='<%# Eval("state", "{0}") %>'> + <asp:ListItem Selected="True">Complete </asp:ListItem> + <asp:ListItem>Active </asp:ListItem> + <asp:ListItem>Inactive </asp:ListItem> + <asp:ListItem /> + </asp:DropDownList> + </div> + </td> + </tr> + </table> + </div> + </HeaderTemplate> + <InsertItemTemplate> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <table> + <tr> + <td colspan="2" style="width: 239px; height: 11px;"> + Name:<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("name") %>' Width="100%" /></td> + <td align=right colspan=1 style="width: 576px; height: 11px"> + </td> + <td colspan="1" style="width: 576px; height: 11px;" align="right"> + Due Date: + <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("dateStamp") %>' Width=81px /> + </td> + </tr> + <tr> + <td colspan="4" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan="4" style="height: 197px"> + <FTB:FreeTextBox ID="FreeTextBox1" runat="server" SupportFolder="~" + Text='<%# Bind("description") %>' Height="100%" Width="100%" /> + </td> + </tr> + <tr> + <td colspan="4" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td colspan=1 style="height: 23px; width: 239px;"> + <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" + Text="Insert"> + </asp:LinkButton> + <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" + Text="Cancel"> + </asp:LinkButton> + </td> + <td align=right colspan=1 style="width: 576px; height: 23px"> + Assigned To: + <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("assignedTo", "{0}") %>'></asp:TextBox> </td> + <td colspan=1 style="width: 576px; height: 23px" align=right> + Assigned By: + <asp:TextBox ID="TextBoxuserID" runat="server" Text='<%# Bind("userID") %>'></asp:TextBox></td> + </tr> + </table> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </InsertItemTemplate> + </asp:FormView> + </td> + <asp:ObjectDataSource ID="myDS" runat="server" SelectMethod="GetDummyActionItemData" + TypeName="DummyDataSetTableAdapters.ActionItemsTableAdapter" InsertMethod="InsertAll" + DeleteMethod="DeleteById" OldValuesParameterFormatString="original_{0}" UpdateMethod="UpdateByID"> + <SelectParameters> + <asp:Parameter Name="id" Type="Int32" /> + </SelectParameters> + <DeleteParameters> + <asp:Parameter Name="original_id" Type="Int32" /> + </DeleteParameters> + <InsertParameters> + <asp:Parameter Name="name" Type="String" /> + <asp:Parameter Name="description" Type="String" /> + <asp:Parameter Name="userID" Type="String" /> + <asp:Parameter Name="dateStamp" Type="String" /> + <asp:Parameter Name="percentFinished" Type="Int32" /> + <asp:Parameter Name="state" Type="String" /> + <asp:Parameter Name="assignedTo" Type="String" /> + </InsertParameters> + <UpdateParameters> + <asp:Parameter Name="name" Type="String" /> + <asp:Parameter Name="description" Type="String" /> + <asp:Parameter Name="userID" Type="String" /> + <asp:Parameter Name="dateStamp" Type="String" /> + <asp:Parameter Name="assignedTo" Type="String" /> + <asp:Parameter Name="original_ID" Type="Int32" /> + </UpdateParameters> + </asp:ObjectDataSource> + <td width="300px" align="right" valign="top"> + <table width="100%" cellpadding="0" cellspacing="0" border="0" style="padding: 10px;"> + <tr> + <td width="100%"> + <b class="notetop"><b class="noteb1"></b><b class="noteb2"></b><b class="noteb3"></b> + <b class="noteb4"></b></b> + <div class="noteboxcontent"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <asp:Panel ID="Panel3" runat="server" CssClass="collapsePanelHeader"> + <td align="left" valign="bottom"> + <h4> + Reminder:</h4> + 15 Apr 2006 </td> + <td align="right" valign="bottom"> + <img alt="Note2Arrow" src="App_Themes/Python/Images/ArrowUp.gif" id="Note2Arrow" /> + <a href="#" class="notedelete">x</a></td> + </asp:Panel> + </tr> + </table> + <atlas:CollapsiblePanelExtender ID="CollapsiblePanelExtender2" runat="server"> + <atlas:CollapsiblePanelProperties Collapsed="true" SuppressPostBack="true" CollapseControlID="Note2Arrow" + ExpandControlID="Note2Arrow" ExpandedImage="App_Themes/Python/Images/ArrowUp.gif" + CollapsedImage="App_Themes/Python/Images/ArrowDown.gif" TargetControlID="Note2Content" + AutoCollapse="false" AutoExpand="false" CollapsedSize="0" ImageControlID="Note2Arrow" /> + </atlas:CollapsiblePanelExtender> + <asp:Panel ID="Note2Content" runat="server" Height="0" Style="overflow: hidden; padding: 0px; + margin: 0px;"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <td class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + Integer lacus elit, consectetuer nec, rutrum at, pretium ac, risus. Sed semper massa + luctus mi. Donec placerat, diam vitae ultricies posuere, felis dui sollicitudin + nibh, eget blandit purus libero in elit. Aenean eget lectus eget ipsum rutrum scelerisque. + Nunc orci mauris, rhoncus ac, pellentesque sit amet, condimentum vel, nibh. Pellentesque + habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. + Suspendisse blandit. + </asp:Panel> + </div> + <b class="notebottom"><b class="noteb4"></b><b class="noteb3"></b><b class="noteb2"> + </b></b><b class="noteb1"></b></td> + </tr> + </table> + <div style="padding-left: 10px; text-align: left;"> + <a href="#" style="padding-left: 10px; text-align: left;">New Note</a></div> + </td> + </tr> + </table> +</asp:Content> Added: WebPrototype/ActionItemEdit.aspx.cs =================================================================== --- WebPrototype/ActionItemEdit.aspx.cs (rev 0) +++ WebPrototype/ActionItemEdit.aspx.cs 2006-06-09 19:03:05 UTC (rev 23) @@ -0,0 +1,47 @@ +using System; +using System.Data; +using System.Configuration; +using System.Collections; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; + +public partial class ActionItemEdit : System.Web.UI.Page +{ + private int id = System.Convert.ToInt32(HttpContext.Current.Request.QueryString["id"]); + + protected void Page_Load(object sender, EventArgs e) + { + ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); + src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.SelectParameters.Add(new Parameter("id", TypeCode.Int32, "1")); + src.Select(); + + myDS.SelectParameters["id"].DefaultValue = id.ToString(); + } + protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) + { + RadioButtonList rbl = (RadioButtonList) FormView1.FindControl("RadioButtonList1"); + ObjectDataSource src = new ObjectDataSource("ActionItems","GetDummyActionItemData"); + + src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.UpdateMethod = "UpdatePercentByID"; + src.UpdateParameters.Add(new Parameter("percentFinished", TypeCode.Int32, rbl.SelectedIndex.ToString())); + src.UpdateParameters.Add(new Parameter("original_id", TypeCode.Int32, id.ToString())); + src.Update(); + } + protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) + { + DropDownList ddl = (DropDownList)FormView1.FindControl("DropDownList1"); + ObjectDataSource src = new ObjectDataSource("ActionItems", "GetDummyActionItemData"); + + src.TypeName = "DummyDataSetTableAdapters.ActionItemsTableAdapter"; + src.UpdateMethod = "UpdateStateByID"; + src.UpdateParameters.Add(new Parameter("state", TypeCode.String, ddl.SelectedValue)); + src.UpdateParameters.Add(new Parameter("original_id", TypeCode.Int32, id.ToString())); + src.Update(); + } +} Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-08 22:32:21 UTC (rev 22) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-06-09 19:03:05 UTC (rev 23) @@ -103,33 +103,14 @@ </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ActionItemsTableAdapter" GeneratorDataComponentClassName="ActionItemsTableAdapter" Name="ActionItems" UserDataComponentName="ActionItemsTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.ActionItems" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetDummyActionItemData" GetMethodModifier="Public" GetMethodName="GetDummyActionItemData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyActionItemData" UserSourceName="GetDummyActionItemData"> - <InsertCommand> - <DbCommand CommandType="Text" ModifiedByUser="False"> - <CommandText>INSERT INTO [ActionItems] ([id], [name], [description], [userID], [dateStamp], [percentFinished]) VALUES (@id, @name, @description, @userID, @dateStamp, @percentFinished)</CommandText> - <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="userID" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateStamp" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> - </Parameter> - </Parameters> - </DbCommand> - </InsertCommand> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.ActionItems" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillDummyActionItemData" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetDummyActionItemData" GeneratorSourceName="FillDummyActionItemData" GetMethodModifier="Public" GetMethodName="GetDummyActionItemData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyActionItemData" UserSourceName="FillDummyActionItemData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT id, name, description, userID, dateStamp, percentFinished + <CommandText>SELECT id, name, description, userID, dateStamp, percentFinished, state, assignedTo FROM ActionItems WHERE (id = @id)</CommandText> <Parameters> - <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="id" DataSourceName="[D:\MATTHEW\WORK\VINTELA\TCDB 2006\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Current"> + <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> </Parameters> </DbCommand> @@ -140,11 +121,101 @@ <Mapping SourceColumn="id" DataSetColumn="id" /> <Mapping SourceColumn="name" DataSetColumn="name" /> <Mapping SourceColumn="description" DataSetColumn="description" /> - <Mapping SourceColumn="userID" DataSetColumn="userID" /> <Mapping SourceColumn="dateStamp" DataSetColumn="dateStamp" /> <Mapping SourceColumn="percentFinished" DataSetColumn="percentFinished" /> + <Mapping SourceColumn="state" DataSetColumn="state" /> + <Mapping SourceColumn="userID" DataSetColumn="userID" /> + <Mapping SourceColumn="assignedTo" DataSetColumn="assignedTo" /> </Mappings> <Sources> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="DeleteById" Modifier="Public" Name="DeleteById" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="DeleteById"> + <DeleteCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>DELETE FROM ActionItems +WHERE (id = @original_id)</CommandText> + <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="original_id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original"> + </Parameter> + </Parameters> + </DbCommand> + </DeleteCommand> + </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertAll" Modifier="Public" Name="InsertAll" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="InsertAll"> + <InsertCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>INSERT INTO ActionItems + (name, description, userID, dateStamp, percentFinished, state, assignedTo) +VALUES (@name,@description,@userID,@dateStamp,@percentFinished,@state,@assignedTo)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(255)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="255" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="description" ColumnName="description" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="description" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="userID" ColumnName="userID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(50)" DbType="String" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="NChar" Scale="0" Size="50" SourceColumn="userID" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="dateStamp" ColumnName="dateStamp" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="dateStamp" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="percentFinished" ColumnName="percentFinished" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="state" ColumnName="state" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@state" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="state" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="assignedTo" ColumnName="assignedTo" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@assignedTo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="assignedTo" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </InsertCommand> + </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="UpdateByID"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE ActionItems +SET name = @name, description = @description, userID = @userID, dateStamp = @dateStamp, assignedTo = @assignedTo +WHERE (id = @original_ID)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="name" ColumnName="name" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(255)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="255" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="description" ColumnName="description" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="description" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="userID" ColumnName="userID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(50)" DbType="String" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="NChar" Scale="0" Size="50" SourceColumn="userID" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="dateStamp" ColumnName="dateStamp" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="dateStamp" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="assignedTo" ColumnName="assignedTo" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@assignedTo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="assignedTo" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="False" AutogeneratedName="original_ID" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original"> + </Parameter> + </Parameters> + </DbCommand> + </UpdateCommand> + </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdatePercentByID" Modifier="Public" Name="UpdatePercentByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="UpdatePercentByID"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE ActionItems SET percentFinished=@percentFinished WHERE id=@original_id</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="percentFinished" ColumnName="percentFinished" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="False" AutogeneratedName="original_id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original"> + </Parameter> + </Parameters> + </DbCommand> + </UpdateCommand> + </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateStateByID" Modifier="Public" Name="UpdateStateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy4" UserSourceName="UpdateStateByID"> + <UpdateCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>UPDATE ActionItems +SET state = @state +WHERE (id = @original_id)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="state" ColumnName="state" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="nchar(10)" DbType="String" Direction="Input" ParameterName="@state" Precision="0" ProviderType="NChar" Scale="0" Size="10" SourceColumn="state" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="False" AutogeneratedName="original_id" ColumnName="id" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original"> + </Parameter> + </Parameters> + </DbCommand> + </UpdateCommand> + </DbSource> </Sources> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FeatureTableAdapter" GeneratorDataComponentClassName="FeatureTableAdapter" Name="Feature" UserDataComponentName="FeatureTableAdapter"> @@ -316,36 +387,36 @@ <xs:element name="Assignments" msprop:Generator_UserTableName="Assignments" msprop:Generator_RowDeletedName="AssignmentsRowDeleted" msprop:Generator_RowChangedName="AssignmentsRowChanged" msprop:Generator_RowClassName="AssignmentsRow" msprop:Generator_RowChangingName="AssignmentsRowChanging" msprop:Generator_RowEvArgName="AssignmentsRowChangeEvent" msprop:Generator_RowEvHandlerName="AssignmentsRowChangeEventHandler" msprop:Generator_TableClassName="AssignmentsDataTable" msprop:Generator_TableVarName="tableAssignments" msprop:Generator_RowDeletingName="AssignmentsRowDeleting" msprop:Generator_TablePropName="Assignments"> <xs:complexType> <xs:sequence> - <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" minOccurs="0"> + <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnPropNameInTable="DateColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="Assignment" msprop:Generator_UserColumnName="Assignment" msprop:Generator_ColumnPropNameInRow="Assignment" msprop:Generator_ColumnVarNameInTable="columnAssignment" msprop:Generator_ColumnPropNameInTable="AssignmentColumn" minOccurs="0"> + <xs:element name="Assignment" msprop:Generator_UserColumnName="Assignment" msprop:Generator_ColumnVarNameInTable="columnAssignment" msprop:Generator_ColumnPropNameInRow="Assignment" msprop:Generator_ColumnPropNameInTable="AssignmentColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> + <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="20" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="_x0025__x0020_Complete" msprop:Generator_UserColumnName="% Complete" msprop:Generator_ColumnPropNameInRow="___Complete" msprop:Generator_ColumnVarNameInTable="_column__Complete" msprop:Generator_ColumnPropNameInTable="___CompleteColumn" type="xs:float" minOccurs="0" /> - <xs:element name="Total" msprop:Generator_UserColumnName="Total" msprop:Generator_ColumnPropNameInRow="Total" msprop:Generator_ColumnVarNameInTable="columnTotal" msprop:Generator_ColumnPropNameInTable="TotalColumn" type="xs:int" minOccurs="0" /> - <xs:element name="Pass_x0020_Rate" msprop:Generator_UserColumnName="Pass Rate" msprop:Generator_ColumnPropNameInRow="Pass_Rate" msprop:Generator_ColumnVarNameInTable="columnPass_Rate" msprop:Generator_ColumnPropNameInTable="Pass_RateColumn" type="xs:float" minOccurs="0" /> - <xs:element name="Pass" msprop:Generator_UserColumnName="Pass" msprop:Generator_ColumnPropNameInRow="Pass" msprop:Generator_ColumnVarNameInTable="columnPass" msprop:Generator_ColumnPropNameInTable="PassColumn" type="xs:int" minOccurs="0" /> - <xs:element name="Fail" msprop:Generator_UserColumnName="Fail" msprop:Generator_ColumnPropNameInRow="Fail" msprop:Generator_ColumnVarNameInTable="columnFail" msprop:Generator_ColumnPropNameInTable="FailColumn" type="xs:int" minOccurs="0" /> - <xs:element name="Error" msprop:Generator_UserColumnName="Error" msprop:Generator_ColumnPropNameInRow="Error" msprop:Generator_ColumnVarNameInTable="columnError" msprop:Generator_ColumnPropNameInTable="ErrorColumn" type="xs:int" minOccurs="0" /> - <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="completed" msprop:Generator_UserColumnName="completed" msprop:Generator_ColumnVarNameInTable="columncompleted" msprop:Generator_ColumnPropNameInRow="completed" msprop:Generator_ColumnPropNameInTable="completedColumn" type="xs:boolean" minOccurs="0" /> - <xs:element name="Type" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0"> + <xs:element name="_x0025__x0020_Complete" msprop:Generator_UserColumnName="% Complete" msprop:Generator_ColumnVarNameInTable="_column__Complete" msprop:Generator_ColumnPropNameInRow="___Complete" msprop:Generator_ColumnPropNameInTable="___CompleteColumn" type="xs:float" minOccurs="0" /> + <xs:element name="Total" msprop:Generator_UserColumnName="Total" msprop:Generator_ColumnVarNameInTable="columnTotal" msprop:Generator_ColumnPropNameInRow="Total" msprop:Generator_ColumnPropNameInTable="TotalColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Pass_x0020_Rate" msprop:Generator_UserColumnName="Pass Rate" msprop:Generator_ColumnVarNameInTable="columnPass_Rate" msprop:Generator_ColumnPropNameInRow="Pass_Rate" msprop:Generator_ColumnPropNameInTable="Pass_RateColumn" type="xs:float" minOccurs="0" /> + <xs:element name="Pass" msprop:Generator_UserColumnName="Pass" msprop:Generator_ColumnVarNameInTable="columnPass" msprop:Generator_ColumnPropNameInRow="Pass" msprop:Generator_ColumnPropNameInTable="PassColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Fail" msprop:Generator_UserColumnName="Fail" msprop:Generator_ColumnVarNameInTable="columnFail" msprop:Generator_ColumnPropNameInRow="Fail" msprop:Generator_ColumnPropNameInTable="FailColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Error" msprop:Generator_UserColumnName="Error" msprop:Generator_ColumnVarNameInTable="columnError" msprop:Generator_ColumnPropNameInRow="Error" msprop:Generator_ColumnPropNameInTable="ErrorColumn" type="xs:int" minOccurs="0" /> + <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="completed" msprop:Generator_UserColumnName="completed" msprop:Generator_ColumnPropNameInRow="completed" msprop:Generator_ColumnVarNameInTable="columncompleted" msprop:Generator_ColumnPropNameInTable="completedColumn" type="xs:boolean" minOccurs="0" /> + <xs:element name="Type" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> @@ -358,45 +429,45 @@ <xs:element name="WorkOrder" msprop:Generator_UserTableName="WorkOrder" msprop:Generator_RowDeletedName="WorkOrderRowDeleted" msprop:Generator_RowChangedName="WorkOrderRowChanged" msprop:Generator_RowClassName="WorkOrderRow" msprop:Generator_RowChangingName="WorkOrderRowChanging" msprop:Generator_RowEvArgName="WorkOrderRowChangeEvent" msprop:Generator_RowEvHandlerName="WorkOrderRowChangeEventHandler" msprop:Generator_TableClassName="WorkOrderDataTable" msprop:Generator_TableVarName="tableWorkOrder" msprop:Generator_RowDeletingName="WorkOrderRowDeleting" msprop:Generator_TablePropName="WorkOrder"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="platform" msprop:Generator_UserColumnName="platform" msprop:Generator_ColumnPropNameInRow="platform" msprop:Generator_ColumnVarNameInTable="columnplatform" msprop:Generator_ColumnPropNameInTable="platformColumn" minOccurs="0"> + <xs:element name="platform" msprop:Generator_UserColumnName="platform" msprop:Generator_ColumnVarNameInTable="columnplatform" msprop:Generator_ColumnPropNameInRow="platform" msprop:Generator_ColumnPropNameInTable="platformColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="created" msdata:ReadOnly="true" msprop:Generator_UserColumnName="created" msprop:Generator_ColumnPropNameInRow="created" msprop:Generator_ColumnVarNameInTable="columncreated" msprop:Generator_ColumnPropNameInTable="createdColumn" type="xs:base64Binary" minOccurs="0" /> - <xs:element name="finished" msprop:Generator_UserColumnName="finished" msprop:Generator_ColumnPropNameInRow="finished" msprop:Generator_ColumnVarNameInTable="columnfinished" msprop:Generator_ColumnPropNameInTable="finishedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="userid" msprop:Generator_UserColumnName="userid" msprop:Generator_ColumnPropNameInRow="userid" msprop:Generator_ColumnVarNameInTable="columnuserid" msprop:Generator_ColumnPropNameInTable="useridColumn" minOccurs="0"> + <xs:element name="created" msdata:ReadOnly="true" msprop:Generator_UserColumnName="created" msprop:Generator_ColumnVarNameInTable="columncreated" msprop:Generator_ColumnPropNameInRow="created" msprop:Generator_ColumnPropNameInTable="createdColumn" type="xs:base64Binary" minOccurs="0" /> + <xs:element name="finished" msprop:Generator_UserColumnName="finished" msprop:Generator_ColumnVarNameInTable="columnfinished" msprop:Generator_ColumnPropNameInRow="finished" msprop:Generator_ColumnPropNameInTable="finishedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="userid" msprop:Generator_UserColumnName="userid" msprop:Generator_ColumnVarNameInTable="columnuserid" msprop:Generator_ColumnPropNameInRow="userid" msprop:Generator_ColumnPropNameInTable="useridColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="WoName" msprop:Generator_UserColumnName="WoName" msprop:Generator_ColumnVarNameInTable="columnWoName" msprop:Generator_ColumnPropNameInRow="WoName" msprop:Generator_ColumnPropNameInTable="WoNameColumn" minOccurs="0"> + <xs:element name="WoName" msprop:Generator_UserColumnName="WoName" msprop:Generator_ColumnPropNameInRow="WoName" msprop:Generator_ColumnVarNameInTable="columnWoName" msprop:Generator_ColumnPropNameInTable="WoNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> + <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="steps" msprop:Generator_UserColumnName="steps" msprop:Generator_ColumnPropNameInRow="steps" msprop:Generator_ColumnVarNameInTable="columnsteps" msprop:Generator_ColumnPropNameInTable="stepsColumn" minOccurs="0"> + <xs:element name="steps" msprop:Generator_UserColumnName="steps" msprop:Generator_ColumnVarNameInTable="columnsteps" msprop:Generator_ColumnPropNameInRow="steps" msprop:Generator_ColumnPropNameInTable="stepsColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> @@ -409,80 +480,94 @@ <xs:element name="ActionItems" msprop:Generator_UserTableName="ActionItems" msprop:Generator_RowDeletedName="ActionItemsRowDeleted" msprop:Generator_RowChangedName="ActionItemsRowChanged" msprop:Generator_RowClassName="ActionItemsRow" msprop:Generator_RowChangingName="ActionItemsRowChanging" msprop:Generator_RowEvArgName="ActionItemsRowChangeEvent" msprop:Generator_RowEvHandlerName="ActionItemsRowChangeEventHandler" msprop:Generator_TableClassName="ActionItemsDataTable" msprop:Generator_TableVarName="tableActionItems" msprop:Generator_RowDeletingName="ActionItemsRowDeleting" msprop:Generator_TablePropName="ActionItems"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="descript... [truncated message content] |
|
From: <jon...@us...> - 2006-06-08 22:32:29
|
Revision: 22 Author: jon_r_johnson Date: 2006-06-08 15:32:21 -0700 (Thu, 08 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=22&view=rev Log Message: ----------- Removed tcdb_assignmentStatus table, the purpose for that table was replaced by the tcdb_Status table. Modified Paths: -------------- Schema/TCDBSQLServer2005.sql Modified: Schema/TCDBSQLServer2005.sql =================================================================== --- Schema/TCDBSQLServer2005.sql 2006-06-08 14:05:21 UTC (rev 21) +++ Schema/TCDBSQLServer2005.sql 2006-06-08 22:32:21 UTC (rev 22) @@ -257,23 +257,6 @@ |
|
From: <m_h...@us...> - 2006-06-08 14:05:30
|
Revision: 21 Author: m_hildebrand Date: 2006-06-08 07:05:21 -0700 (Thu, 08 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=21&view=rev Log Message: ----------- Moved style information into theme style file (App_Themes/Python/python.css) Modified Paths: -------------- WebPrototype/App_Themes/Python/python.css WebPrototype/MasterPage.master Modified: WebPrototype/App_Themes/Python/python.css =================================================================== --- WebPrototype/App_Themes/Python/python.css 2006-06-07 19:04:14 UTC (rev 20) +++ WebPrototype/App_Themes/Python/python.css 2006-06-08 14:05:21 UTC (rev 21) @@ -63,6 +63,7 @@ right: 0px; text-align: right; position: absolute; + top: 23px; } #header #menu #options #tasks Modified: WebPrototype/MasterPage.master =================================================================== --- WebPrototype/MasterPage.master 2006-06-07 19:04:14 UTC (rev 20) +++ WebPrototype/MasterPage.master 2006-06-08 14:05:21 UTC (rev 21) @@ -23,7 +23,7 @@ <a href="Settings.aspx" class="header">Settings</a> | <a href="Admin.aspx" class="header"> Admin</a> | <a href="Logout.aspx" class="header">Logout</a></LoggedInTemplate> </asp:LoginView> - <div id="options" style="right: 0px; top: 23px"> + <div id="options"> <div id="build"> VSM | 1.1 | Alpha | 134</div> <div id="tasks"> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <ro...@us...> - 2006-06-08 02:11:13
|
Revision: 20 Author: rouquin Date: 2006-06-07 12:04:14 -0700 (Wed, 07 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=20&view=rev Log Message: ----------- Had to move the option division so that it looked right in my browser Modified Paths: -------------- WebPrototype/MasterPage.master Modified: WebPrototype/MasterPage.master =================================================================== --- WebPrototype/MasterPage.master 2006-06-06 21:40:45 UTC (rev 19) +++ WebPrototype/MasterPage.master 2006-06-07 19:04:14 UTC (rev 20) @@ -23,7 +23,7 @@ <a href="Settings.aspx" class="header">Settings</a> | <a href="Admin.aspx" class="header"> Admin</a> | <a href="Logout.aspx" class="header">Logout</a></LoggedInTemplate> </asp:LoginView> - <div id="options"> + <div id="options" style="right: 0px; top: 23px"> <div id="build"> VSM | 1.1 | Alpha | 134</div> <div id="tasks"> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <m_h...@us...> - 2006-06-06 21:41:52
|
Revision: 19 Author: m_hildebrand Date: 2006-06-06 14:40:45 -0700 (Tue, 06 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=19&view=rev Log Message: ----------- Lots of updates to the prototype Modified Paths: -------------- WebPrototype/App_Code/DummyDataSet.xsd WebPrototype/App_Code/DummyDataSet.xss WebPrototype/App_Data/ASPNETDB.MDF WebPrototype/App_Data/Database.mdf WebPrototype/App_Data/Database_log.LDF WebPrototype/App_Data/aspnetdb_log.ldf WebPrototype/App_Themes/Python/python.css WebPrototype/Assignments.aspx WebPrototype/Feature.aspx WebPrototype/MasterPage.master WebPrototype/Objective.aspx WebPrototype/Web.sitemap WebPrototype/WorkOrder.aspx Added Paths: ----------- WebPrototype/TestCase.aspx WebPrototype/TestCase.aspx.cs Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-05 22:24:50 UTC (rev 18) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-06-06 21:40:45 UTC (rev 19) @@ -75,7 +75,7 @@ <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT WorkOrder.id, WorkOrder.name AS WoName, WorkOrder.platform, WorkOrder.created, WorkOrder.finished, WorkOrder.userid, TestCase.name, - RTRIM(TestCase.Status) AS Status + RTRIM(TestCase.Status) AS Status, TestCase.steps FROM WorkOrder INNER JOIN TestCase ON WorkOrder.id = TestCase.workorder WHERE (WorkOrder.id = @id)</CommandText> @@ -96,6 +96,7 @@ <Mapping SourceColumn="userid" DataSetColumn="userid" /> <Mapping SourceColumn="WoName" DataSetColumn="WoName" /> <Mapping SourceColumn="Status" DataSetColumn="Status" /> + <Mapping SourceColumn="steps" DataSetColumn="steps" /> </Mappings> <Sources> </Sources> @@ -238,6 +239,71 @@ <Sources> </Sources> </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TestCaseTableAdapter" GeneratorDataComponentClassName="TestCaseTableAdapter" Name="TestCase" UserDataComponentName="TestCaseTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.TestCase" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetDummyTestCaseData" GetMethodModifier="Public" GetMethodName="GetDummyTestCaseData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyTestCaseData" UserSourceName="GetDummyTestCaseData"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT TestCase.id, TestCase.name, RTRIM(Objective.name) AS Objective, RTRIM(Feature.name) AS Feature, TestCase.steps, + LTRIM( RTRIM(TestCase.created)) AS created, LTRIM(RTRIM(TestCase.edited)) AS edited, RTRIM(TestCase.createdby) AS createdby, RTRIM(TestCase.editedby) AS editedby +FROM Feature INNER JOIN + Objective ON Feature.id = Objective.feature INNER JOIN + TestCase ON Objective.id = TestCase.objective +WHERE (TestCase.id = @id)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="id" ColumnName="id" DataSourceName="[D:\MATTHEW\WORK\VINTELA\TCDB 2006\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.TestCase" 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="Objective" DataSetColumn="Objective" /> + <Mapping SourceColumn="Feature" DataSetColumn="Feature" /> + <Mapping SourceColumn="steps" DataSetColumn="steps" /> + <Mapping SourceColumn="created" DataSetColumn="created" /> + <Mapping SourceColumn="edited" DataSetColumn="edited" /> + <Mapping SourceColumn="createdby" DataSetColumn="createdby" /> + <Mapping SourceColumn="editedby" DataSetColumn="editedby" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TagsTableAdapter" GeneratorDataComponentClassName="TagsTableAdapter" Name="Tags" UserDataComponentName="TagsTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Tags" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetDummyTagData" GetMethodModifier="Public" GetMethodName="GetDummyTagData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyTagData" UserSourceName="GetDummyTagData"> + <InsertCommand> + <DbCommand CommandType="Text" ModifiedByUser="False"> + <CommandText>INSERT INTO [Tags] ([id]) VALUES (@id)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </InsertCommand> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT id, RTRIM(tag) AS tag +FROM Tags +WHERE (testcase = @testcase)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="testcase" ColumnName="testcase" DataSourceName="[D:\MATTHEW\WORK\VINTELA\TCDB 2006\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Tags" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@testcase" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="testcase" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="id" DataSetColumn="id" /> + <Mapping SourceColumn="tag" DataSetColumn="tag" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> </Tables> <Sources> </Sources> @@ -330,6 +396,13 @@ </xs:restriction> </xs:simpleType> </xs:element> + <xs:element name="steps" msprop:Generator_UserColumnName="steps" msprop:Generator_ColumnPropNameInRow="steps" msprop:Generator_ColumnVarNameInTable="columnsteps" msprop:Generator_ColumnPropNameInTable="stepsColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="2147483647" /> + </xs:restriction> + </xs:simpleType> + </xs:element> </xs:sequence> </xs:complexType> </xs:element> @@ -461,6 +534,83 @@ </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="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="255" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="Objective" msprop:Generator_UserColumnName="Objective" msprop:Generator_ColumnVarNameInTable="columnObjective" msprop:Generator_ColumnPropNameInRow="Objective" msprop:Generator_ColumnPropNameInTable="ObjectiveColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="255" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="Feature" msprop:Generator_UserColumnName="Feature" msprop:Generator_ColumnVarNameInTable="columnFeature" msprop:Generator_ColumnPropNameInRow="Feature" msprop:Generator_ColumnPropNameInTable="FeatureColumn" 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:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="2147483647" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="created" msdata:ReadOnly="true" msprop:Generator_UserColumnName="created" msprop:Generator_ColumnVarNameInTable="columncreated" msprop:Generator_ColumnPropNameInRow="created" msprop:Generator_ColumnPropNameInTable="createdColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="25" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="edited" msdata:ReadOnly="true" msprop:Generator_UserColumnName="edited" msprop:Generator_ColumnVarNameInTable="columnedited" msprop:Generator_ColumnPropNameInRow="edited" msprop:Generator_ColumnPropNameInTable="editedColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="25" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="createdby" msprop:Generator_UserColumnName="createdby" msprop:Generator_ColumnVarNameInTable="columncreatedby" msprop:Generator_ColumnPropNameInRow="createdby" msprop:Generator_ColumnPropNameInTable="createdbyColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="25" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="editedby" msprop:Generator_UserColumnName="editedby" msprop:Generator_ColumnVarNameInTable="columneditedby" msprop:Generator_ColumnPropNameInRow="editedby" msprop:Generator_ColumnPropNameInTable="editedbyColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="25" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + </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="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" /> + <xs:element name="tag" msprop:Generator_UserColumnName="tag" msprop:Generator_ColumnVarNameInTable="columntag" msprop:Generator_ColumnPropNameInRow="tag" msprop:Generator_ColumnPropNameInTable="tagColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="25" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + </xs:sequence> + </xs:complexType> + </xs:element> </xs:choice> </xs:complexType> </xs:element> Modified: WebPrototype/App_Code/DummyDataSet.xss =================================================================== --- WebPrototype/App_Code/DummyDataSet.xss 2006-06-05 22:24:50 UTC (rev 18) +++ WebPrototype/App_Code/DummyDataSet.xss 2006-06-06 21:40:45 UTC (rev 19) @@ -4,13 +4,15 @@ Changes to this file may cause incorrect behavior and will be lost if the code is regenerated. </autogenerated>--> -<DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="-10" ViewPortY="-10" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout"> +<DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="1" ViewPortY="-10" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout"> <Shapes> - <Shape ID="DesignTable:Assignments" ZOrder="5" X="70" Y="70" Height="275" Width="239" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="228" /> - <Shape ID="DesignTable:WorkOrder" ZOrder="4" X="370" Y="311" Height="207" Width="204" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="160" /> - <Shape ID="DesignTable:ActionItems" ZOrder="3" X="508" Y="108" Height="173" Width="211" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" /> - <Shape ID="DesignTable:Feature" ZOrder="2" X="111" Y="368" Height="207" Width="185" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="160" /> - <Shape ID="DesignTable:Objective" ZOrder="1" X="411" Y="213" Height="173" Width="195" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" /> + <Shape ID="DesignTable:Assignments" ZOrder="7" X="70" Y="70" Height="275" Width="239" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="228" /> + <Shape ID="DesignTable:WorkOrder" ZOrder="6" X="370" Y="311" Height="207" Width="204" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="160" /> + <Shape ID="DesignTable:ActionItems" ZOrder="5" X="508" Y="108" Height="173" Width="211" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" /> + <Shape ID="DesignTable:Feature" ZOrder="4" X="111" Y="368" Height="207" Width="185" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="160" /> + <Shape ID="DesignTable:Objective" ZOrder="3" X="845" Y="115" Height="173" Width="195" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" /> + <Shape ID="DesignTable:TestCase" ZOrder="2" X="623" Y="349" Height="224" Width="192" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="177" /> + <Shape ID="DesignTable:Tags" ZOrder="1" X="937" Y="377" Height="105" Width="183" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="58" /> </Shapes> <Connectors /> </DiagramLayout> \ No newline at end of file Modified: WebPrototype/App_Data/ASPNETDB.MDF =================================================================== (Binary files differ) Modified: WebPrototype/App_Data/Database.mdf =================================================================== (Binary files differ) Modified: WebPrototype/App_Data/Database_log.LDF =================================================================== (Binary files differ) Modified: WebPrototype/App_Data/aspnetdb_log.ldf =================================================================== (Binary files differ) Modified: WebPrototype/App_Themes/Python/python.css =================================================================== --- WebPrototype/App_Themes/Python/python.css 2006-06-05 22:24:50 UTC (rev 18) +++ WebPrototype/App_Themes/Python/python.css 2006-06-06 21:40:45 UTC (rev 19) @@ -98,6 +98,11 @@ padding-right: 8px; } +.gridhover:hover +{ + background-color: #eee; +} + #radiolist TABLE { vertical-align: bottom; @@ -144,8 +149,6 @@ background-position: center 4px; } - - #footer A { color: White; Modified: WebPrototype/Assignments.aspx =================================================================== --- WebPrototype/Assignments.aspx 2006-06-05 22:24:50 UTC (rev 18) +++ WebPrototype/Assignments.aspx 2006-06-06 21:40:45 UTC (rev 19) @@ -24,7 +24,7 @@ <atlas:UpdatePanel ID="p1" runat="server"> <ContentTemplate> <asp:GridView ID="GridView1" runat="server" GridLines="None" AllowPaging="True" AllowSorting="True" - AutoGenerateColumns="False" DataSourceID="DummyObjectDataSource1"> + AutoGenerateColumns="False" DataSourceID="DummyObjectDataSource1" RowStyle-CssClass="gridhover"> <Columns> <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" ControlStyle-CssClass="gridleft" HeaderStyle-CssClass="gridleft" ItemStyle-CssClass="gridleft" /> Modified: WebPrototype/Feature.aspx =================================================================== --- WebPrototype/Feature.aspx 2006-06-05 22:24:50 UTC (rev 18) +++ WebPrototype/Feature.aspx 2006-06-06 21:40:45 UTC (rev 19) @@ -22,8 +22,8 @@ </asp:TreeNode> <asp:TreeNode Text="Feature 1.1" Expanded="false" Selected="true"> <asp:TreeNode Text="OBJECTIVES" Expanded="false"> - <asp:TreeNode Text="Objective 3" Expanded="false"> - <asp:TreeNode Text="5362"></asp:TreeNode> + <asp:TreeNode Text="Objective 3" Expanded="false" NavigateUrl="~/objective.aspx"> + <asp:TreeNode Text="5362" NavigateUrl="~/testCase.aspx"></asp:TreeNode> </asp:TreeNode> <asp:TreeNode Text="Objective 4" Expanded="false"> <asp:TreeNode Text="9456"></asp:TreeNode> Modified: WebPrototype/MasterPage.master =================================================================== --- WebPrototype/MasterPage.master 2006-06-05 22:24:50 UTC (rev 18) +++ WebPrototype/MasterPage.master 2006-06-06 21:40:45 UTC (rev 19) @@ -41,7 +41,7 @@ </PathSeparatorTemplate> </asp:SiteMapPath> <br /> - <div> + <div> <asp:ContentPlaceHolder ID="PageContent" runat="server"> </asp:ContentPlaceHolder> </div> Modified: WebPrototype/Objective.aspx =================================================================== --- WebPrototype/Objective.aspx 2006-06-05 22:24:50 UTC (rev 18) +++ WebPrototype/Objective.aspx 2006-06-06 21:40:45 UTC (rev 19) @@ -20,10 +20,10 @@ <asp:TreeNode Text="3827"></asp:TreeNode> </asp:TreeNode> </asp:TreeNode> - <asp:TreeNode Text="Feature 1.1" Expanded="true"> + <asp:TreeNode Text="Feature 1.1" Expanded="true" NavigateUrl="~/feature.aspx"> <asp:TreeNode Text="OBJECTIVES" Expanded="true"> <asp:TreeNode Text="Test join" Expanded="false" Selected="true"> - <asp:TreeNode Text="5362"></asp:TreeNode> + <asp:TreeNode Text="5362" NavigateUrl="~/testcase.aspx"></asp:TreeNode> </asp:TreeNode> <asp:TreeNode Text="Objective 4" Expanded="false"> <asp:TreeNode Text="9456"></asp:TreeNode> Added: WebPrototype/TestCase.aspx =================================================================== --- WebPrototype/TestCase.aspx (rev 0) +++ WebPrototype/TestCase.aspx 2006-06-06 21:40:45 UTC (rev 19) @@ -0,0 +1,297 @@ +<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" + CodeFile="TestCase.aspx.cs" Inherits="Feature" Title="Test Case" %> + +<%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="atlas" %> +<asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> + <asp:Label ID="lblID" runat="server" Text="6" Visible="false"></asp:Label> + <table border="0" cellpadding="0" cellspacing="0" width="100%"> + <tr> + <td valign="top" width="10px" style="padding-right: 30px;"> + <asp:TreeView ID="TreeView1" runat="server" SelectedNodeStyle-CssClass="selectednode"> + <Nodes> + <asp:TreeNode Text="Product A"> + <asp:TreeNode Text="Version 1.0"> + <asp:TreeNode Text="Feature 1" Expanded="True"> + <asp:TreeNode Text="OBJECTIVES" Expanded="false"> + <asp:TreeNode Text="Objective 1" Expanded="false"> + <asp:TreeNode Text="2560"></asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Objective 2" Expanded="false"> + <asp:TreeNode Text="3827"></asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Feature 1.1" Expanded="true" NavigateUrl="~/feature.aspx"> + <asp:TreeNode Text="OBJECTIVES" Expanded="true"> + <asp:TreeNode Text="Test join" Expanded="true" NavigateUrl="~/objective.aspx"> + <asp:TreeNode Text="5362" Selected="true"></asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Objective 4" Expanded="false"> + <asp:TreeNode Text="9456"></asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Feature 1.1.1" Expanded="false"> + <asp:TreeNode Text="OBJECTIVES" Expanded="false"> + <asp:TreeNode Text="Objective 5" Expanded="false"> + <asp:TreeNode Text="3654"></asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Objective 6" Expanded="false"> + <asp:TreeNode Text="1203"></asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Feature 1.2" Expanded="false"> + <asp:TreeNode Text="OBJECTIVES" Expanded="false"> + <asp:TreeNode Text="Objective 7" Expanded="false"> + <asp:TreeNode Text="1230"></asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Objective 8" Expanded="false"> + <asp:TreeNode Text="1524"></asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Feature 1.2.1" Expanded="false"> + <asp:TreeNode Text="OBJECTIVES" Expanded="false"> + <asp:TreeNode Text="Objective 9" Expanded="false"> + <asp:TreeNode Text="2531"></asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Objective 10" Expanded="false"> + <asp:TreeNode Text="1230"></asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Feature 1.2.2" Expanded="false"> + <asp:TreeNode Text="OBJECTIVES" Expanded="false"> + <asp:TreeNode Text="Objective 11" Expanded="false"> + <asp:TreeNode Text="5641"></asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Objective 12" Expanded="false"> + <asp:TreeNode Text="8542"></asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Feature 3" Expanded="false"> + <asp:TreeNode Text="OBJECTIVES" Expanded="false"> + <asp:TreeNode Text="Objective 13" Expanded="false"> + <asp:TreeNode Text="5641"></asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Objective 14" Expanded="false"> + <asp:TreeNode Text="8542"></asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Version 1.1"> + <asp:TreeNode Text="Feature 1" Expanded="false"> + <asp:TreeNode Text="OBJECTIVES" Expanded="false"> + <asp:TreeNode Text="Objective 1" Expanded="false"> + <asp:TreeNode Text="2560"></asp:TreeNode> + </asp:TreeNode> + <asp:TreeNode Text="Objective 2" Expanded="false"> + <asp:TreeNode Text="3827"></asp:TreeNode> + <asp:TreeNode Text="1234"></asp:TreeNode> + <asp:TreeNode Text="6528"></asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + </asp:TreeNode> + </Nodes> + </asp:TreeView> + </td> + <td width="*" valign="top"> + <div id="TestCase"> + <asp:Repeater ID="Repeater1" runat="server" DataSourceID="myDS"> + <ItemTemplate> + <table cellpadding="0" cellspacing="0" border="0" width="100%"> + <tr> + <td align="left" valign="bottom" colspan="2"> + <h2> + Test Case + </h2> + </td> + </tr> + <tr> + <td colspan="2"> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <table cellpadding="0" cellspacing="0" border="0" width="100%"> + <tr> + <td align="left" colspan="2"> + <h3> + <%# DataBinder.Eval(Container.DataItem, "name") %> + </h3> + </td> + </tr> + <tr> + <td align="left"> + Feature: + <a href="Feature.aspx"><%# DataBinder.Eval(Container.DataItem, "Feature") %></a> + </td> + <td align="right"> + Created: + <%# DataBinder.Eval(Container.DataItem, "created") %> + </td> + </tr> + <tr> + <td> + Objective: + <a href="Objective.aspx"><%# DataBinder.Eval(Container.DataItem, "Objective") %></a> + </td> + <td align="right"> + Last edited: + <%# DataBinder.Eval(Container.DataItem, "edited") %> + </td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td style="padding-bottom: 3px;"> + <b>Included versions:</b> All and new + </td> + <td style="padding-bottom: 3px;"> + <b>Excluded versions:</b> 1.2-2.0, 2.3 + </td> + </tr> + <tr> + <td style="padding-bottom: 3px;"> + <b>Included Platforms:</b> REAS 3.0, REAS 4.0, SLES 9 + </td> + <td style="padding-bottom: 3px;"> + <b>Excluded Platforms:</b> All and new + </td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td style="padding-bottom: 3px;" colspan="2"> + <div id="tags"> + <b>Tags:</b> + <asp:Repeater ID="Repeater1" runat="server" DataSourceID="myDS2"> + <ItemTemplate><%# DataBinder.Eval(Container.DataItem, "tag") %></ItemTemplate> + <SeparatorTemplate>, </SeparatorTemplate> + </asp:Repeater> + </div> + </td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + <b>Steps:</b> + <div id="ObjectiveData"> + <%# DataBinder.Eval(Container.DataItem, "steps") %> + </div> + <table cellpadding="0" cellspacing="0" border="0" width="100%" style="padding-top: 10px;"> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td align="left" valign="bottom"> + <asp:LinkButton ID="New" runat="server">New</asp:LinkButton> + | + <asp:LinkButton ID="Edit" runat="server">Edit</asp:LinkButton> + | + <asp:LinkButton ID="Delete" runat="server">Delete</asp:LinkButton></td> + <td align="right"> + Authored by: + <%# DataBinder.Eval(Container.DataItem, "createdby") %> + <br /> + Last Edited by: + <%# DataBinder.Eval(Container.DataItem, "editedby") %> + </td> + </tr> + </table> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </td> + </tr> + </table> + </ItemTemplate> + </asp:Repeater> + </div> + </td> + <asp:ObjectDataSource ID="myDS" runat="server" OldValuesParameterFormatString="original_{0}" + SelectMethod="GetDummyTestCaseData" TypeName="DummyDataSetTableAdapters.TestCaseTableAdapter"> + <SelectParameters> + <asp:ControlParameter ControlID="lblID" DefaultValue="0" Name="id" PropertyName="Text" + Type="String" /> + </SelectParameters> + </asp:ObjectDataSource> + <asp:ObjectDataSource ID="myDS2" runat="server" OldValuesParameterFormatString="original_{0}" + SelectMethod="GetDummyTagData" TypeName="DummyDataSetTableAdapters.TagsTableAdapter"> + <SelectParameters> + <asp:ControlParameter ControlID="lblID" DefaultValue="0" Name="testcase" PropertyName="Text" + Type="String" /> + </SelectParameters> + </asp:ObjectDataSource> + <td width="300px" align="right" valign="top"> + <table width="100%" cellpadding="0" cellspacing="0" border="0" style="padding: 10px;"> + <tr> + <td width="100%"> + <b class="notetop"><b class="noteb1"></b><b class="noteb2"></b><b class="noteb3"></b> + <b class="noteb4"></b></b> + <div class="noteboxcontent"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <asp:Panel ID="Panel3" runat="server" CssClass="collapsePanelHeader"> + <td align="left" valign="bottom"> + <h4> + Reminder:</h4> + 15 Apr 2006 + </td> + <td align="right" valign="bottom"> + <img alt="Note2Arrow" src="App_Themes/Python/Images/ArrowUp.gif" id="Note2Arrow" /> + <a href="#" class="notedelete">x</a></td> + </asp:Panel> + </tr> + </table> + <atlas:CollapsiblePanelExtender ID="CollapsiblePanelExtender2" runat="server"> + <atlas:CollapsiblePanelProperties Collapsed="true" SuppressPostBack="true" CollapseControlID="Note2Arrow" + ExpandControlID="Note2Arrow" ExpandedImage="App_Themes/Python/Images/ArrowUp.gif" + CollapsedImage="App_Themes/Python/Images/ArrowDown.gif" TargetControlID="Note2Content" + AutoCollapse="false" AutoExpand="false" CollapsedSize="0" ImageControlID="Note2Arrow" /> + </atlas:CollapsiblePanelExtender> + <asp:Panel ID="Note2Content" runat="server" Height="0" Style="overflow: hidden; padding: 0px; + margin: 0px;"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <td class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + Integer lacus elit, consectetuer nec, rutrum at, pretium ac, risus. Sed semper massa + luctus mi. Donec placerat, diam vitae ultricies posuere, felis dui sollicitudin + nibh, eget blandit purus libero in elit. Aenean eget lectus eget ipsum rutrum scelerisque. + Nunc orci mauris, rhoncus ac, pellentesque sit amet, condimentum vel, nibh. Pellentesque + habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. + Suspendisse blandit. + </asp:Panel> + </div> + <b class="notebottom"><b class="noteb4"></b><b class="noteb3"></b><b class="noteb2"> + </b></b><b class="noteb1"></b> + </td> + </tr> + </table> + <div style="padding-left: 10px; text-align: left;"> + <a href="#" style="padding-left: 10px; text-align: left;">New Note</a></div> + </td> + </tr> + </table> +</asp:Content> Added: WebPrototype/TestCase.aspx.cs =================================================================== --- WebPrototype/TestCase.aspx.cs (rev 0) +++ WebPrototype/TestCase.aspx.cs 2006-06-06 21:40:45 UTC (rev 19) @@ -0,0 +1,18 @@ +using System; +using System.Data; +using System.Configuration; +using System.Collections; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; + +public partial class Feature : System.Web.UI.Page +{ + protected void Page_Load(object sender, EventArgs e) + { + + } +} Modified: WebPrototype/Web.sitemap =================================================================== --- WebPrototype/Web.sitemap 2006-06-05 22:24:50 UTC (rev 18) +++ WebPrototype/Web.sitemap 2006-06-06 21:40:45 UTC (rev 19) @@ -1,17 +1,16 @@ <?xml version="1.0" encoding="utf-8" ?> <siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" > <siteMapNode url="Default.aspx" title="Home" description=""> - <siteMapNode url="Assignments.aspx" title="Assignments" description="" /> - <siteMapNode url="Admin.aspx" title="Admin" description=""> - <siteMapNode title="Testing" url="images/logo.gif" /> + <siteMapNode url="Assignments.aspx" title="Assignments" description=""> + <siteMapNode url="ActionItem.aspx" title="Action Item" description="" /> + <siteMapNode url="WorkOrder.aspx" title="Work Order" description=""> + <siteMapNode url="TestCase.aspx" title="Test Case" description="" /> + <siteMapNode url="Objective.aspx" title="Objective" description="" /> + <siteMapNode url="Feature.aspx" title="Feature" description="" /> + </siteMapNode> </siteMapNode> <siteMapNode url="Settings.aspx" title="Settings" description="" /> <siteMapNode url="Privacy.aspx" title="Privacy Policy" description="" /> - <siteMapNode title="Home" > - <siteMapNode title="Services" > - <siteMapNode title="Training" url="~/Training.aspx"/> - </siteMapNode> - </siteMapNode> </siteMapNode> Modified: WebPrototype/WorkOrder.aspx =================================================================== --- WebPrototype/WorkOrder.aspx 2006-06-05 22:24:50 UTC (rev 18) +++ WebPrototype/WorkOrder.aspx 2006-06-06 21:40:45 UTC (rev 19) @@ -3,7 +3,6 @@ <%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="atlas" %> <asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> - <asp:Label ID="lblID" runat="server" Text="6" Visible="false"></asp:Label> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> @@ -70,7 +69,7 @@ <atlas:UpdatePanel runat="server" ID="upWorkOrder"> <ContentTemplate> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="ObjectDataSource1" - AllowSorting="True" GridLines="none"> + AllowSorting="True" GridLines="none" RowStyle-CssClass="gridhover"> <Columns> <asp:TemplateField HeaderText="N&nbsp;&nbsp;&nbsp;&nbsp;P&nbsp;&nbsp;&nbsp;&nbsp;F&nbsp;&nbsp;&nbsp;&nbsp;E"> <ItemTemplate> @@ -86,6 +85,9 @@ <asp:HyperLinkField DataTextField="name" HeaderText="Test Case" SortExpression="name" NavigateUrl="~/TestCase.aspx" DataNavigateUrlFields="id" DataNavigateUrlFormatString="~\TestCase.aspx?id={0}" DataTextFormatString="{0:c}" HeaderStyle-CssClass="gridleft" ItemStyle-CssClass="gridleft" /> + <asp:BoundField DataField="Steps" HeaderText="" SortExpression="Steps" ControlStyle-CssClass="gridleft" + HeaderStyle-CssClass="gridleft" ItemStyle-CssClass="gridleft" HtmlEncode="true" /> + </Columns> </asp:GridView> </ContentTemplate> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <sla...@us...> - 2006-06-06 02:57:19
|
Revision: 17 Author: slambson Date: 2006-06-05 08:07:47 -0700 (Mon, 05 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=17&view=rev Log Message: ----------- Modified Paths: -------------- Design/UI/GUI subcomponent schedule.doc Modified: Design/UI/GUI subcomponent schedule.doc =================================================================== (Binary files differ) This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <sla...@us...> - 2006-06-05 23:24:45
|
Revision: 18 Author: slambson Date: 2006-06-05 15:24:50 -0700 (Mon, 05 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=18&view=rev Log Message: ----------- Added Paths: ----------- Design/UI/View Prototypes - feedback.doc Added: Design/UI/View Prototypes - feedback.doc =================================================================== (Binary files differ) Property changes on: Design/UI/View Prototypes - feedback.doc ___________________________________________________________________ Name: svn:mime-type + application/octet-stream This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <jon...@us...> - 2006-06-02 23:10:32
|
Revision: 16 Author: jon_r_johnson Date: 2006-06-02 16:10:27 -0700 (Fri, 02 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=16&view=rev Log Message: ----------- Added Column username to tcdb_users table, this will be used to help verify user authentication in the application. Modified Paths: -------------- Schema/TCDBSQLServer2005.sql Modified: Schema/TCDBSQLServer2005.sql =================================================================== --- Schema/TCDBSQLServer2005.sql 2006-06-01 00:03:40 UTC (rev 15) +++ Schema/TCDBSQLServer2005.sql 2006-06-02 23:10:27 UTC (rev 16) @@ -1,1218 +1,1220 @@ -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_userRights]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_userRights]( - [userRightsID] [int] IDENTITY(1,1) NOT NULL, - [userID] [int] NULL, - [rightsID] [int] NULL, - [dateCreated] [datetime] NULL, - [grantedBy] [int] NULL, - CONSTRAINT [PK_tcdb_userRights] PRIMARY KEY CLUSTERED -( - [userRightsID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_featureVersion]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_featureVersion]( - [featureVersionID] [int] IDENTITY(1,1) NOT NULL, - [featureID] [int] NULL, - [versionID] [int] NULL, - [include] [bit] NULL CONSTRAINT [DF_tcdb_featureVersion_include] DEFAULT ((0)), - [minVersion] [varchar](50) NULL, - [maxVersion] [varchar](50) NULL, - CONSTRAINT [PK_tcdb_featureVersion] PRIMARY KEY CLUSTERED -( - [featureVersionID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_platform]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_platform]( - [platformID] [int] IDENTITY(1,1) NOT NULL, - [architectureID] [int] NULL, - [osID] [int] NULL, - CONSTRAINT [PK_tcdb_platform] PRIMARY KEY CLUSTERED -( - [platformID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_testCaseTags]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_testCaseTags]( - [testcaseTagsID] [int] IDENTITY(1,1) NOT NULL, - [testcaseID] [int] NULL, - [tagID] [int] NULL, - CONSTRAINT [PK_tcdb_testcasetags] PRIMARY KEY CLUSTERED -( - [testcaseTagsID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_workOrderTestCase]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_workOrderTestCase]( - [workOrderTestCaseID] [int] IDENTITY(1,1) NOT NULL, - [workOrderID] [int] NULL, - [testCaseID] [int] NULL, - CONSTRAINT [PK_tcdb_workOrderTestCase] PRIMARY KEY CLUSTERED -( - [workOrderTestCaseID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_savedWorkOrderTestCase]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_savedWorkOrderTestCase]( - [savedWOTestCaseID] [int] IDENTITY(1,1) NOT NULL, - [savedWorkOrderID] [int] NULL, - [testCaseID] [int] NULL, - CONSTRAINT [PK_tcdb_savedWorkOrderTestCase] PRIMARY KEY CLUSTERED -( - [savedWOTestCaseID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_actionItem]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_actionItem]( - [actionItemID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - [creatorID] [int] NULL, - [dateCreated] [datetime] NULL, - [percentComplete] [int] NULL, - CONSTRAINT [PK_tcdb_actionItem] PRIMARY KEY CLUSTERED -( - [actionItemID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_testPass]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_testPass]( - [testPassID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [versionID] [int] NULL, - CONSTRAINT [PK_tcdb_testPass] PRIMARY KEY CLUSTERED -( - [testPassID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_result]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_result]( - [resultID] [bigint] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [statusEnum] [int] NULL, - [code] [text] NULL, - CONSTRAINT [PK_tcdb_result] PRIMARY KEY CLUSTERED -( - [resultID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_results]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_results]( - [resultsID] [bigint] IDENTITY(1,1) NOT NULL, - [testCaseID] [int] NULL, - [platformID] [int] NULL, - [dateStarted] [datetime] NULL, - [dateFinished] [datetime] NULL, - [assignedID] [int] NULL, - [testPassID] [int] NULL, - [resultID] [bigint] NULL, - [buildID] [int] NULL, - [workOrderID] [int] NULL -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_state]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_state]( - [stateID] [int] IDENTITY(1,1) NOT NULL, - [currentDomain] [varchar](15) NULL, - [vasClnt] [varchar](16) NULL, - [vasClnts] [varchar](16) NULL, - [vasDev] [varchar](16) NULL, - [vasDevi] [varchar](16) NULL, - [vasGps] [varchar](16) NULL, - [vasProxy] [varchar](16) NULL, - [vasYP] [varchar](16) NULL, - [nis] [varchar](4) NULL, - [openssh] [varchar](16) NULL, - CONSTRAINT [PK_tcdb_state] PRIMARY KEY CLUSTERED -( - [stateID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_architecture]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_architecture]( - [architectureID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - CONSTRAINT [PK_tcdb_architecture] PRIMARY KEY CLUSTERED -( - [architectureID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_assignmentStatus]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_assignmentStatus]( - [assignmentStatusID] [int] IDENTITY(1,1) NOT NULL, - [statusName] [varchar](255) NULL, - [statusEnum] [int] NULL, - CONSTRAINT [PK_tcdb_assignmentStatus] PRIMARY KEY CLUSTERED -( - [assignmentStatusID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_computer]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_computer]( - [computerID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [ipAddress] [varchar](15) NULL, - [hostname] [varchar](50) NULL, - [platformID] [int] NULL, - [labID] [int] NULL, - [stateID] [int] NULL, - CONSTRAINT [PK_tcdb_computer] PRIMARY KEY CLUSTERED -( - [computerID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_feature]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_feature]( - [featureID] [int] IDENTITY(1,1) NOT NULL, - [parentFeatureID] [int] NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - [userID] [int] NULL, - [dateCreated] [datetime] NULL, - [featureNumber] [varchar](20) NULL, - [orderNumber] [int] NULL, - CONSTRAINT [PK_tcdb_feature] PRIMARY KEY CLUSTERED -( - [featureID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_lab]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_lab]( - [labID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - [DNS] [varchar](15) NULL, - CONSTRAINT [PK_tcdb_lab] PRIMARY KEY CLUSTERED -( - [labID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_notes]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_notes]( - [noteID] [int] IDENTITY(1,1) NOT NULL, - [tableName] [varchar](50) NULL, - [tableID] [int] NULL, - [dateCreated] [datetime] NULL, - [noteField] [text] NULL, - [noteAuthor] [int] NULL, - CONSTRAINT [PK_tcdb_notes] PRIMARY KEY CLUSTERED -( - [noteID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_objective]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_objective]( - [objectiveID] [int] IDENTITY(1,1) NOT NULL, - [featureID] [int] NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - [userID] [int] NULL, - [dateEdited] [datetime] NULL, - [statusID] [int] NULL, - CONSTRAINT [PK_tcdb_objective] PRIMARY KEY CLUSTERED -( - [objectiveID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_os]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_os]( - [osID] [int] IDENTITY(1,1) NOT NULL, - [friendlyName] [varchar](255) NULL, - [codeName] [varchar](30) NULL, - CONSTRAINT [PK_tcdb_os] PRIMARY KEY CLUSTERED -( - [osID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_product]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_product]( - [productID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - [devManager] [int] NULL, - [qaManager] [int] NULL, - [devLead] [int] NULL, - [qaLead] [int] NULL, - [pm] [int] NULL, - [codeName] [varchar](10) NULL, - CONSTRAINT [PK_tcdb_product] PRIMARY KEY CLUSTERED -( - [productID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_rights]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_rights]( - [rightsID] [int] NOT NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - CONSTRAINT [PK_tcdb_rights] PRIMARY KEY CLUSTERED -( - [rightsID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_savedWorkOrder]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_savedWorkOrder]( - [savedWorkOrderID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [platformID] [int] NULL, - [creatorID] [int] NULL, - [versionID] [int] NULL, - CONSTRAINT [PK_tcdb_savedWorkOrder] PRIMARY KEY CLUSTERED -( - [savedWorkOrderID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_tags]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_tags]( - [tagID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - CONSTRAINT [PK_tcdb_tags] PRIMARY KEY CLUSTERED -( - [tagID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_testCase]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_testCase]( - [testCaseID] [int] IDENTITY(1,1) NOT NULL, - [objectiveID] [int] NULL, - [name] [varchar](255) NULL, - [number] [varchar](30) NULL, - [steps] [text] NULL, - [creatorID] [int] NULL, - [lastEditID] [int] NULL, - [dateCreated] [datetime] NULL, - [dateEdited] [datetime] NULL, - [statusID] [int] NULL, - CONSTRAINT [PK_tcdb_testcase] PRIMARY KEY CLUSTERED -( - [testCaseID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_version]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_version]( - [versionID] [int] IDENTITY(1,1) NOT NULL, - [productID] [int] NULL, - [number] [varchar](50) NULL, - [code] [varchar](50) NULL, - [active] [bit] NULL, - [dateCreated] [datetime] NULL, - [devManager] [int] NULL, - [qaManager] [int] NULL, - [devLead] [int] NULL, - [pm] [int] NULL, - CONSTRAINT [PK_tcdb_version] PRIMARY KEY CLUSTERED -( - [versionID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_workOrder]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_workOrder]( - [workorderID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [platformID] [int] NULL, - [dateCreated] [datetime] NULL, - [dateCompleted] [datetime] NULL, - [creatorID] [int] NULL, - [testPassID] [int] NULL, - CONSTRAINT [PK_tcdb_workorder] PRIMARY KEY CLUSTERED -( - [workorderID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_user]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_user --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/23/2006 --- Purpose: Insert a new user in the master users table. --- --- Input: @firstName -- User First Name --- @lastName -- User Last Name --- @email -- Email Address for User --- @officePhone -- Office Phone for User I.E. ''(xxx) xxx-xxxx'' --- @homePhone -- Office Phone for User I.E. ''(xxx) xxx-xxxx'' --- @cellPhone -- Office Phone for User I.E. ''(xxx) xxx-xxxx'' --- @automation -- 0 - Normal Person, 1 - Automation Account --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_user] ( - @firstName varchar(24), - @lastName varchar(24), - @email varchar(50), - @officePhone varchar(14) = null, - @homePhone varchar(14) = null, - @cellPhone varchar(14) = null, - @automation bit = null -) as - --- 2006/05/24 JRJ Default to Normal Person -if (@automation is null) - set @automation = 0 - --- 2006/05/24 JRJ Corrected table name -insert into tcdb_user -select - @email, - @officePhone, - @homePhone, - @cellPhone, - @firstName, - @lastName, - @automation' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_versionTestCase]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_versionTestCase]( - [versionTestCaseID] [int] IDENTITY(1,1) NOT NULL, - [testCaseID] [int] NULL, - [versionID] [int] NULL, - [include] [bit] NULL CONSTRAINT [DF_tcdb_versionTestCase_include] DEFAULT ((0)), - [minVersion] [varchar](50) NULL, - [maxVersion] [varchar](50) NULL, - CONSTRAINT [PK_tcdb_versionTestCase] PRIMARY KEY CLUSTERED -( - [versionTestCaseID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_platformVersion]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_platformVersion]( - [platformVersionID] [int] IDENTITY(1,1) NOT NULL, - [platformID] [int] NULL, - [versionID] [int] NULL, - [include] [bit] NULL CONSTRAINT [DF_tcdb_platformVersion_include] DEFAULT ((0)), - [minVersion] [varchar](50) NULL, - [maxVersion] [varchar](50) NULL, - CONSTRAINT [PK_tcdb_platformVersion] PRIMARY KEY CLUSTERED -( - [platformVersionID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_testcasePlatform]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_testcasePlatform]( - [testcasePlatformID] [int] IDENTITY(1,1) NOT NULL, - [testcaseID] [int] NULL, - [platformID] [int] NULL, - [include] [bit] NULL CONSTRAINT [DF_tcdb_testcasePlatform_include] DEFAULT ((0)), - CONSTRAINT [PK_tcdb_testcasePlatform] PRIMARY KEY CLUSTERED -( - [testcasePlatformID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_status]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_status]( - [statusID] [int] IDENTITY(1,1) NOT NULL, - [statusGroup] [varchar](50) NULL, - [statusName] [varchar](50) NULL, - [Description] [text] NULL, - CONSTRAINT [PK_tcdb_status] PRIMARY KEY CLUSTERED -( - [statusID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_assignment]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_assignment]( - [assignmentID] [int] IDENTITY(1,1) NOT NULL, - [creatorID] [int] NULL, - [assignedID] [int] NULL, - [dateAssigned] [datetime] NULL, - [dateFinished] [datetime] NULL, - [dateDue] [datetime] NULL, - [assignmentStatusID] [int] NULL, - [workOrderID] [int] NULL, - [actionItemID] [int] NULL, - [highPriority] [bit] NULL CONSTRAINT [DF_tcdb_assignment_highPriority] DEFAULT ((0)), - [statusID] [int] NULL, - CONSTRAINT [PK_tcdb_assignment] PRIMARY KEY CLUSTERED -( - [assignmentID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_user]( - [userID] [int] IDENTITY(1,1) NOT NULL, - [email] [varchar](50) NOT NULL, - [officePhone] [varchar](14) NULL, - [homePhone] [varchar](14) NULL, - [cellPhone] [varchar](14) NULL, - [firstName] [varchar](24) NOT NULL, - [lastName] [varchar](24) NOT NULL, - [automation] [bit] NOT NULL, - CONSTRAINT [PK_tcdb_user] PRIMARY KEY CLUSTERED -( - [email] ASC, - [firstName] ASC, - [lastName] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO - -IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND name = N'ix_userID') -CREATE UNIQUE NONCLUSTERED INDEX [ix_userID] ON [dbo].[tcdb_user] -( - [userID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_logs]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_logs]( - [logID] [bigint] IDENTITY(1,1) NOT NULL, - [resultID] [bigint] NULL, - [name] [varchar](255) NULL, - [dataLocation] [text] NULL, - CONSTRAINT [PK_tcdb_logs] PRIMARY KEY CLUSTERED -( - [logID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_build]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_build]( - [buildID] [int] IDENTITY(1,1) NOT NULL, - [versionID] [int] NULL, - [number] [varchar](20) NULL, - [active] [bit] NULL, - [dateCreated] [datetime] NULL, - CONSTRAINT [PK_tcdb_build] PRIMARY KEY CLUSTERED -( - [buildID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_platform]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_platform --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/30/2006 --- Purpose: Insert a new computer in the master computers table. --- --- Input: @architectureID -- Identity of the Architecture for this Platform --- @osID -- Identity of the OS for this Platform --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_platform] ( - @architectureID int, - @osID int -) as - -insert into tcdb_platform -select - @architectureID, - @osID - -' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_testCaseTags]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_testCaseTags --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/31/2006 --- Purpose: Insert a new test case tag in the test case tags table. --- --- Input: @testcaseID -- Identity of the Testcase for this Tag --- @tagID -- Identity of the Tag for this Testcase --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_testCaseTags] ( - @testcaseID int, - @tagID int -) as - -insert into tcdb_testCaseTags -select - @testcaseID, - @tagID - -' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_testPass]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_testPass --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/31/2006 --- Purpose: Insert a new computer in the master computers table. --- --- Input: @name -- Test Pass Name --- @versionID -- Identity of the Version for this test pass --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_testPass] ( - @name varchar(255), - @versionID int -) as - -insert into tcdb_testPass -select - @name, - @versionID - -' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_architecture]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_architecture --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/30/2006 --- Purpose: Insert a new architecture in the master architecture table. --- --- Input: @name -- Architecture Name --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_architecture] ( - @name varchar(255) -) as - -insert into tcdb_architecture -select - @name - -' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_computer]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_computer --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/30/2006 --- Purpose: Insert a new computer in the master computers table. --- --- Input: @name -- Computer Name --- @ipAddress -- Computer IP Address --- @hostname -- Computer Hostname --- @platformID -- Identity of the Platform for this Computer --- @labID -- Identity of the Lab for this Computer --- @stateID -- Identity of the State for this Computer --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_computer] ( - @name varchar(255), - @ipAddress varchar(15), - @hostname varchar(50), - @platformID int, - @labID int, - @stateID int -) as - -insert into tcdb_computer -select - @name, - @ipAddress, - @hostname, - @platformID, - @labID, - @stateID - -' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_lab]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_lab --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/30/2006 --- Purpose: Insert a new lab in the lab table. --- --- Input: @name -- Lab Name --- @description -- Description of the Lab --- @DNS -- LAB DNS (I.P.) --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_lab] ( - @name varchar(255), - @description text, - @DNS varchar(15) -) as - -insert into tcdb_lab -select - @name, - @description, - @DNS - -' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_os]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_os --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/30/2006 --- Purpose: Insert a new OS in the OS table. --- --- Input: @friendlyname -- OS Friendly Name --- @codeName -- OS Code Name --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_os] ( - @friendlyname varchar(255), - @codeName varchar(30) -) as - -insert into tcdb_os -select - @friendlyname, - @codeName - -' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_product]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_product --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/23/2006 --- Purpose: Insert a new product in the master products table. --- --- Input: @name -- Product Name --- @description -- Product Description --- @devManager -- Development Manager --- @qaManager -- Q.A. Manager --- @devLead -- Development Lead --- @qaLead -- Q.A. Lead --- @pm -- Product Manager --- @codeName -- Product Code Name --- --- Output: none ------------------------------------------------------------------- -create proc [dbo].[ins_product] ( - @name varchar(255), - @description text, - @devManager varchar(49), - @qaManager varchar(49), - @devLead varchar(49), - @qaLead varchar(49), - @pm varchar(49), - @codeName varchar(10) -) as - - -insert into tcdb_product -select - @name, - @description, - devManager=(select userID from tcdb_user where firstName+'' ''+lastName = @devManager), - qaManager=(select userID from tcdb_user where firstName+'' ''+lastName = @qaManager), - devLead=(select userID from tcdb_user where firstName+'' ''+lastName = @devLead), - qaLead=(select userID from tcdb_user where firstName+'' ''+lastName = @qaLead), - pm=(select userID from tcdb_user where firstName+'' ''+lastName = @pm), - @codeName - -' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_tags]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_tags --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/30/2006 --- Purpose: Insert a new tag in the tag table. --- --- Input: @name -- Tag Name --- @description -- Description of tag, which can apply to any test case --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_tags] ( - @name varchar(255), - @description text -) as - -insert into tcdb_tags -select - @name, - @description - -' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_testCase]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_testCase --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/30/2006 --- Purpose: Insert a new test case in the test case table. --- --- Input: @objectiveID -- Identity of the objective for this test case --- @name -- Test case name --- @number -- Test case number --- @steps -- Steps for this test case to execute --- @creatorID -- Identity of the creator of this test case --- @statusID -- Identity of the status for this test case --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_testCase] ( - @objectiveID int, - @name varchar(255), - @number varchar(30), - @steps text, - @creatorID int, - @statusID int -) as - -insert into tcdb_testCase -select - @objectiveID, - @name, - @number, - @steps, - @creatorID, - lastEditID=null, - dateCreated=getdate(), - dateEdited=null, - @statusID - -' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_version]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_version --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/31/2006 --- Purpose: Insert a new product version in the version table. --- --- Input: @productID -- Identity of the Product for this Version --- @number -- Product Version Number --- @code -- Product Code Version --- @active -- Is Version Active=1 / Inactive=0 --- @devManager -- Identity of the Dev Manager for this Version --- @qaManager -- Identity of the QA Manager for this Version --- @devLead -- Identity of the Dev Lead for this Version --- @pm -- Identity of the Product Manager for this Version --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_version] ( - @productID int, - @number varchar(50), - @code varchar(50), - @active bit, - @devManager int, - @qaManager int, - @devLead int, - @pm int -) as - -insert into tcdb_version -select - @productID, - @number, - @code, - @active, - dateCreated=getdate(), - @devManager, - @qaManager, - @devLead, - @pm - -' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_versionTestCase]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_versionTestCase --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/31/2006 --- Purpose: Insert a new product version specific test case in the version --- test case table. --- --- Input: @testCaseID -- Identity of the test case --- @versionID -- Identity of the Product Version Number --- @include -- Specialty Include=1 / Exclude=0 --- @minVersion -- Minimum product version test case applies to / null is everything up to maxversion --- @maxVersion -- Maximum product version test case applies to / null is everything above minversion --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_versionTestCase] ( - @testCaseID int, - @versionID int, - @include bit, - @minVersion varchar(50) = null, - @maxVersion varchar(50) = null -) as - -insert into tcdb_versionTestCase -select - @testCaseID, - @versionID, - @include, - @minVersion, - @maxVersion - -' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_build]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_build --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/30/2006 --- Purpose: Insert a new build in the build table. --- --- Input: @versionID -- Identity of the Version this build belongs to --- @number -- Build Number --- @active -- 0=Inactive Build 1=Active Build --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_build] ( - @versionID int, - @number varchar(20), - @active bit -) as - - -insert into tcdb_build -select - @versionID, - @number, - @active, - getdate() - -' -END +\xFF\xFES |
|
From: <jon...@us...> - 2006-06-01 00:03:52
|
Revision: 15 Author: jon_r_johnson Date: 2006-05-31 17:03:40 -0700 (Wed, 31 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=15&view=rev Log Message: ----------- Added stored procedures ins_testCaseTags, ins_testPass, ins_version, and ins_versionTestCase Modified Paths: -------------- Schema/TCDBSQLServer2005.sql Modified: Schema/TCDBSQLServer2005.sql =================================================================== --- Schema/TCDBSQLServer2005.sql 2006-05-31 23:01:33 UTC (rev 14) +++ Schema/TCDBSQLServer2005.sql 2006-06-01 00:03:40 UTC (rev 15) @@ -757,6 +757,70 @@ GO SET QUOTED_IDENTIFIER ON GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_testCaseTags]') AND type in (N'P', N'PC')) +BEGIN +EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ +-- Stored Procedure: ins_testCaseTags +-- +-- Database: TCDB +-- Author: Jon R. Johnson +-- Date: 05/31/2006 +-- Purpose: Insert a new test case tag in the test case tags table. +-- +-- Input: @testcaseID -- Identity of the Testcase for this Tag +-- @tagID -- Identity of the Tag for this Testcase +-- +-- Output: none +------------------------------------------------------------------ +CREATE proc [dbo].[ins_testCaseTags] ( + @testcaseID int, + @tagID int +) as + +insert into tcdb_testCaseTags +select + @testcaseID, + @tagID + +' +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_testPass]') AND type in (N'P', N'PC')) +BEGIN +EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ +-- Stored Procedure: ins_testPass +-- +-- Database: TCDB +-- Author: Jon R. Johnson +-- Date: 05/31/2006 +-- Purpose: Insert a new computer in the master computers table. +-- +-- Input: @name -- Test Pass Name +-- @versionID -- Identity of the Version for this test pass +-- +-- Output: none +------------------------------------------------------------------ +CREATE proc [dbo].[ins_testPass] ( + @name varchar(255), + @versionID int +) as + +insert into tcdb_testPass +select + @name, + @versionID + +' +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_architecture]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ @@ -1027,6 +1091,99 @@ GO SET QUOTED_IDENTIFIER ON GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_version]') AND type in (N'P', N'PC')) +BEGIN +EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ +-- Stored Procedure: ins_version +-- +-- Database: TCDB +-- Author: Jon R. Johnson +-- Date: 05/31/2006 +-- Purpose: Insert a new product version in the version table. +-- +-- Input: @productID -- Identity of the Product for this Version +-- @number -- Product Version Number +-- @code -- Product Code Version +-- @active -- Is Version Active=1 / Inactive=0 +-- @devManager -- Identity of the Dev Manager for this Version +-- @qaManager -- Identity of the QA Manager for this Version +-- @devLead -- Identity of the Dev Lead for this Version +-- @pm -- Identity of the Product Manager for this Version +-- +-- Output: none +------------------------------------------------------------------ +CREATE proc [dbo].[ins_version] ( + @productID int, + @number varchar(50), + @code varchar(50), + @active bit, + @devManager int, + @qaManager int, + @devLead int, + @pm int +) as + +insert into tcdb_version +select + @productID, + @number, + @code, + @active, + dateCreated=getdate(), + @devManager, + @qaManager, + @devLead, + @pm + +' +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_versionTestCase]') AND type in (N'P', N'PC')) +BEGIN +EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ +-- Stored Procedure: ins_versionTestCase +-- +-- Database: TCDB +-- Author: Jon R. Johnson +-- Date: 05/31/2006 +-- Purpose: Insert a new product version specific test case in the version +-- test case table. +-- +-- Input: @testCaseID -- Identity of the test case +-- @versionID -- Identity of the Product Version Number +-- @include -- Specialty Include=1 / Exclude=0 +-- @minVersion -- Minimum product version test case applies to / null is everything up to maxversion +-- @maxVersion -- Maximum product version test case applies to / null is everything above minversion +-- +-- Output: none +------------------------------------------------------------------ +CREATE proc [dbo].[ins_versionTestCase] ( + @testCaseID int, + @versionID int, + @include bit, + @minVersion varchar(50) = null, + @maxVersion varchar(50) = null +) as + +insert into tcdb_versionTestCase +select + @testCaseID, + @versionID, + @include, + @minVersion, + @maxVersion + +' +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_build]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <m_h...@us...> - 2006-05-31 23:02:22
|
Revision: 14 Author: m_hildebrand Date: 2006-05-31 16:01:33 -0700 (Wed, 31 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=14&view=rev Log Message: ----------- Continued work on the webprototype Modified Paths: -------------- WebPrototype/ActionItem.aspx WebPrototype/ActionItem.aspx.cs WebPrototype/App_Themes/Python/python.css WebPrototype/Web.config Added Paths: ----------- WebPrototype/App_Code/ WebPrototype/App_Code/DummyDataSet.xsd WebPrototype/App_Code/DummyDataSet.xss WebPrototype/App_Data/ WebPrototype/App_Data/ASPNETDB.MDF WebPrototype/App_Data/Database.mdf WebPrototype/App_Data/Database_log.LDF WebPrototype/App_Data/aspnetdb_log.ldf WebPrototype/Feature.aspx WebPrototype/Feature.aspx.cs WebPrototype/Objective.aspx WebPrototype/Objective.aspx.cs WebPrototype/WorkOrder.aspx WebPrototype/WorkOrder.aspx.cs Modified: WebPrototype/ActionItem.aspx =================================================================== --- WebPrototype/ActionItem.aspx 2006-05-31 05:28:53 UTC (rev 13) +++ WebPrototype/ActionItem.aspx 2006-05-31 23:01:33 UTC (rev 14) @@ -3,95 +3,94 @@ <%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="atlas" %> <asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> - <% - if (!IsPostBack) - { - lblID.Text = Request.Params["id"]; - } - %> - - <asp:ObjectDataSource ID="DummyObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}" - SelectMethod="GetDummyActionItemData" TypeName="DummyDataSetTableAdapters.ActionItemsTableAdapter"> - <SelectParameters> - <asp:ControlParameter ControlID="lblID" Name="id" - PropertyName="Text" Type="Boolean" /> - </SelectParameters> - </asp:ObjectDataSource> - - <asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px" DataSourceID="DummyObjectDataSource1"> - </asp:DetailsView> - - <asp:Label id="lblID" runat="server" Text="" Visible="false"></asp:Label> + + <asp:Label ID="lblID" runat="server" Text="1" Visible="false"></asp:Label> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td width="*" valign="top"> <div id="ActionItem"> - <table cellpadding="0" cellspacing="0" border="0" width="100%"> - <tr> - <td align="left" valign="bottom"> - <h2> - Action Item </h2> - </td> - <td align="right" valign="bottom" style="padding-right: 20px;"> - <div class="radiolist"> - <a href="#">Active</a> | - <asp:RadioButtonList ID="rdoAmountDone" runat="server" SkinID="rdoAmountDone" RepeatDirection="Horizontal" CssClass="radiocontrol"> - <asp:ListItem Selected="true" Text="0%" Value="0">0%</asp:ListItem> - <asp:ListItem Selected="true" Text="25%" Value="25">25%</asp:ListItem> - <asp:ListItem Selected="true" Text="50%" Value="50">50%</asp:ListItem> - <asp:ListItem Selected="true" Text="75%" Value="75">75%</asp:ListItem> - <asp:ListItem Selected="true" Text="100%" Value="100">100%</asp:ListItem> - </asp:RadioButtonList> - </div> - </td> - </tr> - <tr> - <td colspan="2"> - <div class="xsnazzy"> - <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> - </b></b> - <div class="xboxcontent"> - <table cellpadding="0" cellspacing="0" border="0" width="100%"> - <tr> - <td align="left"> - <h3> - Setup Personal Environment</h3> - </td> - <td align="right"> - 23 Dec 2006</td> - </tr> - <tr> + <asp:Repeater ID="Repeater1" runat="server" DataSourceID="myDS"> + <ItemTemplate> + <table cellpadding="0" cellspacing="0" border="0" width="100%"> + <tr> + <td align="left" valign="bottom"> + <h2> + Action Item + </h2> + </td> + <td align="right" valign="bottom" style="padding-right: 20px;"> + <div id="radiolist"> + <asp:RadioButtonList ID="rdoAmountDone" runat="server" RepeatDirection="Horizontal"> + <asp:ListItem Text="0%" Value="0">0%</asp:ListItem> + <asp:ListItem Selected="true" Text="25%" Value="25">25%</asp:ListItem> + <asp:ListItem Text="50%" Value="50">50%</asp:ListItem> + <asp:ListItem Text="75%" Value="75">75%</asp:ListItem> + <asp:ListItem Text="100%" Value="100">100%</asp:ListItem> + </asp:RadioButtonList> | <asp:LinkButton ID="Status" runat="server">Active</asp:LinkButton> + </div> + </td> + </tr> + <tr> + <td colspan="2"> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <table cellpadding="0" cellspacing="0" border="0" width="100%"> + <tr> + <td align="left"> + <h3> + <%# DataBinder.Eval(Container.DataItem, "Name") %> + </h3> + </td> + <td align="right"> + <%# DataBinder.Eval(Container.DataItem, "dateStamp") %> + </td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + <div id="ActionItemData"> + <%# DataBinder.Eval(Container.DataItem, "Description") %> + </div> + <table cellpadding="0" cellspacing="0" border="0" width="100%" style="padding-top: 10px;"> + <tr> <td colspan="2" class="hr"> <img alt="" src="images/spacer.gif" height="5" /><br /> </td> </tr> - </table> - <div id="ActionItemData"> - Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer fermentum laoreet - nunc. Maecenas consectetuer metus a justo. Donec semper. Proin tempor mauris non - arcu. Mauris nonummy convallis sapien. Aliquam erat volutpat. Ut eget ante a turpis - volutpat lobortis. Morbi accumsan justo eu massa. Nullam diam. Cras venenatis bibendum - diam. Suspendisse a erat tristique nunc consectetuer ultrices. + + <tr> + <td align="left"> + <asp:LinkButton ID="Edit" runat="server">Edit</asp:LinkButton> | + <asp:LinkButton ID="Delete" runat="server">Delete</asp:LinkButton> + <td align="right"> + <%# DataBinder.Eval(Container.DataItem, "userID") %> + </td> + </tr> + </table> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> </div> - <table cellpadding="0" cellspacing="0" border="0" width="100%" style="padding-top: 10px;"> - <tr> - <td align="left"> - <a href="#">Edit</a> | <a href="#">Delete</a></td> - <td align="right"> - Jason Corbett</td> - </tr> - </table> - </div> - <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> - </b></b> - </div> - </td> - </tr> - </table> + </td> + </tr> + </table> + </ItemTemplate> + </asp:Repeater> </div> - </td> + <asp:ObjectDataSource ID="myDS" runat="server" OldValuesParameterFormatString="original_{0}" + SelectMethod="GetDummyActionItemData" TypeName="DummyDataSetTableAdapters.ActionItemsTableAdapter"> + <SelectParameters> + <asp:ControlParameter ControlID="lblID" DefaultValue="0" Name="id" PropertyName="Text" + Type="String" /> + </SelectParameters> + </asp:ObjectDataSource> <td width="300px" align="right" valign="top"> <table width="100%" cellpadding="0" cellspacing="0" border="0" style="padding: 10px;"> <tr> @@ -141,7 +140,8 @@ </td> </tr> </table> - <div style="padding-left: 10px; text-align: left;"><a href="#" style="padding-left: 10px; text-align: left;">New Note</a></div> + <div style="padding-left: 10px; text-align: left;"> + <a href="#" style="padding-left: 10px; text-align: left;">New Note</a></div> </td> </tr> </table> Modified: WebPrototype/ActionItem.aspx.cs =================================================================== --- WebPrototype/ActionItem.aspx.cs 2006-05-31 05:28:53 UTC (rev 13) +++ WebPrototype/ActionItem.aspx.cs 2006-05-31 23:01:33 UTC (rev 14) @@ -15,7 +15,10 @@ private int id; protected void Page_Load(object sender, EventArgs e) - { + {/* + Repeater1.DataSource = myDS; + Repeater1.DataBind(); + //Repeater1.DataBind(); /* @@ -32,4 +35,5 @@ RepeaterControlID.DataBind() dtrCust.Close()*/ } + } Added: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd (rev 0) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-05-31 23:01:33 UTC (rev 14) @@ -0,0 +1,467 @@ +<?xml version="1.0" encoding="utf-8"?> +<xs:schema id="DummyDataSet" targetNamespace="http://tempuri.org/DummyDataSet.xsd" xmlns:mstns="http://tempuri.org/DummyDataSet.xsd" xmlns="http://tempuri.org/DummyDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified"> + <xs:annotation> + <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource"> + <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> + <Connections> + <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="DummyDatabaseConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="DummyDatabaseConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.DummyDatabaseConnectionString.ConnectionString" Provider="System.Data.SqlClient"> + </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="WorkOrderTableAdapter" GeneratorDataComponentClassName="WorkOrderTableAdapter" Name="WorkOrder" UserDataComponentName="WorkOrderTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetDummyWorkOrderData" GetMethodModifier="Public" GetMethodName="GetDummyWorkOrderData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyWorkOrderData" UserSourceName="GetDummyWorkOrderData"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT WorkOrder.id, WorkOrder.name AS WoName, WorkOrder.platform, WorkOrder.created, WorkOrder.finished, WorkOrder.userid, TestCase.name, + RTRIM(TestCase.Status) AS Status +FROM WorkOrder INNER JOIN + TestCase ON WorkOrder.id = TestCase.workorder +WHERE (WorkOrder.id = @id)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="id" ColumnName="id" DataSourceName="[D:\MATTHEW\WORK\VINTELA\TCDB 2006\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.WorkOrder" 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="platform" DataSetColumn="platform" /> + <Mapping SourceColumn="created" DataSetColumn="created" /> + <Mapping SourceColumn="finished" DataSetColumn="finished" /> + <Mapping SourceColumn="userid" DataSetColumn="userid" /> + <Mapping SourceColumn="WoName" DataSetColumn="WoName" /> + <Mapping SourceColumn="Status" DataSetColumn="Status" /> + </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="True" GeneratorGetMethodName="GetDummyActionItemData" GetMethodModifier="Public" GetMethodName="GetDummyActionItemData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyActionItemData" UserSourceName="GetDummyActionItemData"> + <InsertCommand> + <DbCommand CommandType="Text" ModifiedByUser="False"> + <CommandText>INSERT INTO [ActionItems] ([id], [name], [description], [userID], [dateStamp], [percentFinished]) VALUES (@id, @name, @description, @userID, @dateStamp, @percentFinished)</CommandText> + <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@userID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="userID" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dateStamp" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateStamp" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@percentFinished" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="percentFinished" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </InsertCommand> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT id, name, description, userID, dateStamp, percentFinished +FROM ActionItems +WHERE (id = @id)</CommandText> + <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="id" DataSourceName="[D:\MATTHEW\WORK\VINTELA\TCDB 2006\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.ActionItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="id" DataSetColumn="id" /> + <Mapping SourceColumn="name" DataSetColumn="name" /> + <Mapping SourceColumn="description" DataSetColumn="description" /> + <Mapping SourceColumn="userID" DataSetColumn="userID" /> + <Mapping SourceColumn="dateStamp" DataSetColumn="dateStamp" /> + <Mapping SourceColumn="percentFinished" DataSetColumn="percentFinished" /> + </Mappings> + <Sources> + </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="True" GeneratorGetMethodName="GetDummyFeatureData" GetMethodModifier="Public" GetMethodName="GetDummyFeatureData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyFeatureData" UserSourceName="GetDummyFeatureData"> + <InsertCommand> + <DbCommand CommandType="Text" ModifiedByUser="False"> + <CommandText>INSERT INTO [Feature] ([id], [parent_id], [description], [user], [time], [featureNumber]) VALUES (@id, @parent_id, @description, @user, @time, @featureNumber)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@parent_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parent_id" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@user" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="user" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@time" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="time" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@featureNumber" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="featureNumber" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </InsertCommand> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT Feature.id, Feature.parent_id, RTRIM(Feature.name) AS name, Feature.description, Feature.[user], Feature.time, Feature.featureNumber, RTRIM(Feature_1.name) AS Parent +FROM Feature INNER JOIN + Feature AS Feature_1 ON Feature.parent_id = Feature_1.id +WHERE (Feature.id = @id)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="id" ColumnName="id" DataSourceName="[D:\MATTHEW\WORK\VINTELA\TCDB 2006\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Feature" 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="parent_id" DataSetColumn="parent_id" /> + <Mapping SourceColumn="name" DataSetColumn="name" /> + <Mapping SourceColumn="description" DataSetColumn="description" /> + <Mapping SourceColumn="user" DataSetColumn="user" /> + <Mapping SourceColumn="time" DataSetColumn="time" /> + <Mapping SourceColumn="featureNumber" DataSetColumn="featureNumber" /> + <Mapping SourceColumn="Parent" DataSetColumn="Parent" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ObjectiveTableAdapter" GeneratorDataComponentClassName="ObjectiveTableAdapter" Name="Objective" UserDataComponentName="ObjectiveTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.Objective" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetDummyObjectiveData" GetMethodModifier="Public" GetMethodName="GetDummyObjectiveData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetDummyObjectiveData" UserSourceName="GetDummyObjectiveData"> + <InsertCommand> + <DbCommand CommandType="Text" ModifiedByUser="False"> + <CommandText>INSERT INTO [Objective] ([id], [name], [description], [user]) VALUES (@id, @name, @description, @user)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@user" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="user" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </InsertCommand> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT Objective.id, Objective.name, Objective.description, Objective.[user], RTRIM(Objective.time) AS time, RTRIM(Feature.name) AS feature +FROM Objective INNER JOIN + Feature ON Objective.feature = Feature.id +WHERE (Objective.id= @id)</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="id" ColumnName="id" DataSourceName="[D:\MATTHEW\WORK\VINTELA\TCDB 2006\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.Objective" 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="user" DataSetColumn="user" /> + <Mapping SourceColumn="time" DataSetColumn="time" /> + <Mapping SourceColumn="feature" DataSetColumn="feature" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> + </Tables> + <Sources> + </Sources> + </DataSource> + </xs:appinfo> + </xs:annotation> + <xs:element name="DummyDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DummyDataSet" msprop:Generator_DataSetName="DummyDataSet"> + <xs:complexType> + <xs:choice minOccurs="0" maxOccurs="unbounded"> + <xs:element name="Assignments" msprop:Generator_UserTableName="Assignments" msprop:Generator_RowDeletedName="AssignmentsRowDeleted" msprop:Generator_RowChangedName="AssignmentsRowChanged" msprop:Generator_RowClassName="AssignmentsRow" msprop:Generator_RowChangingName="AssignmentsRowChanging" msprop:Generator_RowEvArgName="AssignmentsRowChangeEvent" msprop:Generator_RowEvHandlerName="AssignmentsRowChangeEventHandler" msprop:Generator_TableClassName="AssignmentsDataTable" msprop:Generator_TableVarName="tableAssignments" msprop:Generator_RowDeletingName="AssignmentsRowDeleting" msprop:Generator_TablePropName="Assignments"> + <xs:complexType> + <xs:sequence> + <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="10" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="Assignment" msprop:Generator_UserColumnName="Assignment" msprop:Generator_ColumnPropNameInRow="Assignment" msprop:Generator_ColumnVarNameInTable="columnAssignment" msprop:Generator_ColumnPropNameInTable="AssignmentColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="2147483647" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="20" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="_x0025__x0020_Complete" msprop:Generator_UserColumnName="% Complete" msprop:Generator_ColumnPropNameInRow="___Complete" msprop:Generator_ColumnVarNameInTable="_column__Complete" msprop:Generator_ColumnPropNameInTable="___CompleteColumn" type="xs:float" minOccurs="0" /> + <xs:element name="Total" msprop:Generator_UserColumnName="Total" msprop:Generator_ColumnPropNameInRow="Total" msprop:Generator_ColumnVarNameInTable="columnTotal" msprop:Generator_ColumnPropNameInTable="TotalColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Pass_x0020_Rate" msprop:Generator_UserColumnName="Pass Rate" msprop:Generator_ColumnPropNameInRow="Pass_Rate" msprop:Generator_ColumnVarNameInTable="columnPass_Rate" msprop:Generator_ColumnPropNameInTable="Pass_RateColumn" type="xs:float" minOccurs="0" /> + <xs:element name="Pass" msprop:Generator_UserColumnName="Pass" msprop:Generator_ColumnPropNameInRow="Pass" msprop:Generator_ColumnVarNameInTable="columnPass" msprop:Generator_ColumnPropNameInTable="PassColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Fail" msprop:Generator_UserColumnName="Fail" msprop:Generator_ColumnPropNameInRow="Fail" msprop:Generator_ColumnVarNameInTable="columnFail" msprop:Generator_ColumnPropNameInTable="FailColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Error" msprop:Generator_UserColumnName="Error" msprop:Generator_ColumnPropNameInRow="Error" msprop:Generator_ColumnVarNameInTable="columnError" msprop:Generator_ColumnPropNameInTable="ErrorColumn" type="xs:int" minOccurs="0" /> + <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="completed" msprop:Generator_UserColumnName="completed" msprop:Generator_ColumnVarNameInTable="columncompleted" msprop:Generator_ColumnPropNameInRow="completed" msprop:Generator_ColumnPropNameInTable="completedColumn" type="xs:boolean" minOccurs="0" /> + <xs:element name="Type" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="10" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + </xs:sequence> + </xs:complexType> + </xs:element> + <xs:element name="WorkOrder" msprop:Generator_UserTableName="WorkOrder" msprop:Generator_RowDeletedName="WorkOrderRowDeleted" msprop:Generator_RowChangedName="WorkOrderRowChanged" msprop:Generator_RowClassName="WorkOrderRow" msprop:Generator_RowChangingName="WorkOrderRowChanging" msprop:Generator_RowEvArgName="WorkOrderRowChangeEvent" msprop:Generator_RowEvHandlerName="WorkOrderRowChangeEventHandler" msprop:Generator_TableClassName="WorkOrderDataTable" msprop:Generator_TableVarName="tableWorkOrder" msprop:Generator_RowDeletingName="WorkOrderRowDeleting" msprop:Generator_TablePropName="WorkOrder"> + <xs:complexType> + <xs:sequence> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="255" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="platform" msprop:Generator_UserColumnName="platform" msprop:Generator_ColumnPropNameInRow="platform" msprop:Generator_ColumnVarNameInTable="columnplatform" msprop:Generator_ColumnPropNameInTable="platformColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="255" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="created" msdata:ReadOnly="true" msprop:Generator_UserColumnName="created" msprop:Generator_ColumnPropNameInRow="created" msprop:Generator_ColumnVarNameInTable="columncreated" msprop:Generator_ColumnPropNameInTable="createdColumn" type="xs:base64Binary" minOccurs="0" /> + <xs:element name="finished" msprop:Generator_UserColumnName="finished" msprop:Generator_ColumnPropNameInRow="finished" msprop:Generator_ColumnVarNameInTable="columnfinished" msprop:Generator_ColumnPropNameInTable="finishedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="userid" msprop:Generator_UserColumnName="userid" msprop:Generator_ColumnPropNameInRow="userid" msprop:Generator_ColumnVarNameInTable="columnuserid" msprop:Generator_ColumnPropNameInTable="useridColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="50" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="WoName" msprop:Generator_UserColumnName="WoName" msprop:Generator_ColumnVarNameInTable="columnWoName" msprop:Generator_ColumnPropNameInRow="WoName" msprop:Generator_ColumnPropNameInTable="WoNameColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="255" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="50" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + </xs:sequence> + </xs:complexType> + </xs:element> + <xs:element name="ActionItems" msprop:Generator_UserTableName="ActionItems" msprop:Generator_RowDeletedName="ActionItemsRowDeleted" msprop:Generator_RowChangedName="ActionItemsRowChanged" msprop:Generator_RowClassName="ActionItemsRow" msprop:Generator_RowChangingName="ActionItemsRowChanging" msprop:Generator_RowEvArgName="ActionItemsRowChangeEvent" msprop:Generator_RowEvHandlerName="ActionItemsRowChangeEventHandler" msprop:Generator_TableClassName="ActionItemsDataTable" msprop:Generator_TableVarName="tableActionItems" msprop:Generator_RowDeletingName="ActionItemsRowDeleting" msprop:Generator_TablePropName="ActionItems"> + <xs:complexType> + <xs:sequence> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs: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:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="2147483647" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="userID" msprop:Generator_UserColumnName="userID" msprop:Generator_ColumnVarNameInTable="columnuserID" msprop:Generator_ColumnPropNameInRow="userID" msprop:Generator_ColumnPropNameInTable="userIDColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="50" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="dateStamp" msprop:Generator_UserColumnName="dateStamp" msprop:Generator_ColumnVarNameInTable="columndateStamp" msprop:Generator_ColumnPropNameInRow="dateStamp" msprop:Generator_ColumnPropNameInTable="dateStampColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="10" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="percentFinished" msprop:Generator_UserColumnName="percentFinished" msprop:Generator_ColumnVarNameInTable="columnpercentFinished" msprop:Generator_ColumnPropNameInRow="percentFinished" msprop:Generator_ColumnPropNameInTable="percentFinishedColumn" type="xs:float" minOccurs="0" /> + </xs:sequence> + </xs:complexType> + </xs:element> + <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" minOccurs="0" /> + <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: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:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="2147483647" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="25" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnPropNameInTable="timeColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="25" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="featureNumber" msprop:Generator_UserColumnName="featureNumber" msprop:Generator_ColumnVarNameInTable="columnfeatureNumber" msprop:Generator_ColumnPropNameInRow="featureNumber" msprop:Generator_ColumnPropNameInTable="featureNumberColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="10" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="Parent" msprop:Generator_UserColumnName="Parent" msprop:Generator_ColumnVarNameInTable="columnParent" msprop:Generator_ColumnPropNameInRow="Parent" msprop:Generator_ColumnPropNameInTable="ParentColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="255" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + </xs:sequence> + </xs:complexType> + </xs:element> + <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="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" minOccurs="0" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="255" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" 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="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="25" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="time" msdata:ReadOnly="true" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnPropNameInTable="timeColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="25" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + <xs:element name="feature" msdata:ReadOnly="true" msprop:Generator_UserColumnName="feature" msprop:Generator_ColumnVarNameInTable="columnfeature" msprop:Generator_ColumnPropNameInRow="feature" msprop:Generator_ColumnPropNameInTable="featureColumn" minOccurs="0"> + <xs:simpleType> + <xs:restriction base="xs:string"> + <xs:maxLength value="255" /> + </xs:restriction> + </xs:simpleType> + </xs:element> + </xs:sequence> + </xs:complexType> + </xs:element> + </xs:choice> + </xs:complexType> + </xs:element> +</xs:schema> \ No newline at end of file Added: WebPrototype/App_Code/DummyDataSet.xss =================================================================== --- WebPrototype/App_Code/DummyDataSet.xss (rev 0) +++ WebPrototype/App_Code/DummyDataSet.xss 2006-05-31 23:01:33 UTC (rev 14) @@ -0,0 +1,16 @@ +<?xml version="1.0" encoding="utf-8"?> +<!--<autogenerated> + This code was generated by a tool to store the dataset designer's layout information. + Changes to this file may cause incorrect behavior and will be lost if + the code is regenerated. +</autogenerated>--> +<DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="-10" ViewPortY="-10" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout"> + <Shapes> + <Shape ID="DesignTable:Assignments" ZOrder="5" X="70" Y="70" Height="275" Width="239" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="228" /> + <Shape ID="DesignTable:WorkOrder" ZOrder="4" X="370" Y="311" Height="207" Width="204" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="160" /> + <Shape ID="DesignTable:ActionItems" ZOrder="3" X="508" Y="108" Height="173" Width="211" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" /> + <Shape ID="DesignTable:Feature" ZOrder="2" X="111" Y="368" Height="207" Width="185" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="160" /> + <Shape ID="Desig... [truncated message content] |
|
From: <m_h...@us...> - 2006-05-31 05:29:06
|
Revision: 13 Author: m_hildebrand Date: 2006-05-30 22:28:53 -0700 (Tue, 30 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=13&view=rev Log Message: ----------- Continuing work on making working pages in the web prototype Modified Paths: -------------- WebPrototype/ActionItem.aspx WebPrototype/ActionItem.aspx.cs WebPrototype/App_Themes/Python/python.css WebPrototype/Assignments.aspx WebPrototype/MasterPage.master Added Paths: ----------- WebPrototype/Details.aspx WebPrototype/Details.aspx.cs Property Changed: ---------------- Graphics/Python/ Property changes on: Graphics/Python ___________________________________________________________________ Name: svn:ignore + Thumbs.db Modified: WebPrototype/ActionItem.aspx =================================================================== --- WebPrototype/ActionItem.aspx 2006-05-31 00:58:57 UTC (rev 12) +++ WebPrototype/ActionItem.aspx 2006-05-31 05:28:53 UTC (rev 13) @@ -1,8 +1,28 @@ <%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" - CodeFile="ActionItem.aspx.cs" Inherits="ActionItem" Title="Untitled Page" %> + CodeFile="ActionItem.aspx.cs" Inherits="ActionItem" Title="Action Item" %> <%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="atlas" %> <asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> + <% + if (!IsPostBack) + { + lblID.Text = Request.Params["id"]; + } + %> + + <asp:ObjectDataSource ID="DummyObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}" + SelectMethod="GetDummyActionItemData" TypeName="DummyDataSetTableAdapters.ActionItemsTableAdapter"> + <SelectParameters> + <asp:ControlParameter ControlID="lblID" Name="id" + PropertyName="Text" Type="Boolean" /> + </SelectParameters> + </asp:ObjectDataSource> + + + <asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px" DataSourceID="DummyObjectDataSource1"> + </asp:DetailsView> + + <asp:Label id="lblID" runat="server" Text="" Visible="false"></asp:Label> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td width="*" valign="top"> @@ -11,7 +31,7 @@ <tr> <td align="left" valign="bottom"> <h2> - Action Item</h2> + Action Item </h2> </td> <td align="right" valign="bottom" style="padding-right: 20px;"> <div class="radiolist"> @@ -70,10 +90,9 @@ </tr> </table> </div> + </td> <td width="300px" align="right" valign="top"> - <atlas:ScriptManager ID="ScriptManager1" runat="server" EnablePartialRendering="true" /> - <table width="100%" cellpadding="0" cellspacing="0" border="0" style="padding: 10px;"> <tr> <td width="100%"> Modified: WebPrototype/ActionItem.aspx.cs =================================================================== --- WebPrototype/ActionItem.aspx.cs 2006-05-31 00:58:57 UTC (rev 12) +++ WebPrototype/ActionItem.aspx.cs 2006-05-31 05:28:53 UTC (rev 13) @@ -11,8 +11,25 @@ public partial class ActionItem : System.Web.UI.Page { + + private int id; + protected void Page_Load(object sender, EventArgs e) { + //Repeater1.DataBind(); + /* + Dim conCust As SqlConnection + Dim cmdSelectRows As SqlCommand + Dim dtrCust As SqlDataReader + conCust = New SqlConnection( "Server=server;UID=userID; + PWD=password; + Database=database" ) + cmdSelectRows = New SqlCommand( "query", conCust) + conCust.Open() + dtrCust = cmdSelectRows.ExecuteReader() + RepeaterControlID.DataSource = dtrCust + RepeaterControlID.DataBind() + dtrCust.Close()*/ } } Modified: WebPrototype/App_Themes/Python/python.css =================================================================== --- WebPrototype/App_Themes/Python/python.css 2006-05-31 00:58:57 UTC (rev 12) +++ WebPrototype/App_Themes/Python/python.css 2006-05-31 05:28:53 UTC (rev 13) @@ -84,6 +84,20 @@ color: White; } +.gridleft +{ + text-align: left; + padding-left: 8px; + padding-right: 8px; +} + +.gridcenter +{ + text-align: center; + padding-left: 8px; + padding-right: 8px; +} + .radiolist { display: inline; @@ -167,11 +181,6 @@ margin: -1.8em auto 0 auto; } -#MyAssignmentsData TD -{ - text-align: center; -} - /* A CSS hack that only applies to IE -- specifies a different height for the footer */ * html #footer Modified: WebPrototype/Assignments.aspx =================================================================== --- WebPrototype/Assignments.aspx 2006-05-31 00:58:57 UTC (rev 12) +++ WebPrototype/Assignments.aspx 2006-05-31 05:28:53 UTC (rev 13) @@ -11,7 +11,8 @@ My Assignments</h2> </td> <td align="right" valign="bottom" style="padding-right: 20px;"> - <asp:CheckBox ID="cboShowCompleted" runat="server" Text="Show Completed" TextAlign="Left" AutoPostBack="true" /></td> + <asp:CheckBox ID="cboShowCompleted" runat="server" Text="Show Completed" TextAlign="Left" + AutoPostBack="true" /></td> </tr> <tr> <td colspan="2"> @@ -19,108 +20,46 @@ <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> </b></b> <div class="xboxcontent"> - <div id="MyAssignmentsData"> - <asp:GridView ID="GridView1" runat="server" GridLines="None" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="DummyObjectDataSource1"> - <Columns> - <asp:CommandField ShowSelectButton="True" /> - <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" /> - <asp:BoundField DataField="Type" HeaderText="Type" SortExpression="Type" /> - <asp:BoundField DataField="Assignment" HeaderText="Assignment" SortExpression="Assignment" /> - <asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" /> - <asp:BoundField DataField="% Complete" HeaderText="% Complete" SortExpression="% Complete" /> - <asp:BoundField DataField="Total" HeaderText="Total" SortExpression="Total" /> - <asp:BoundField DataField="Pass Rate" HeaderText="Pass Rate" SortExpression="Pass Rate" /> - <asp:BoundField DataField="Pass" HeaderText="Pass" SortExpression="Pass" /> - <asp:BoundField DataField="Fail" HeaderText="Fail" SortExpression="Fail" /> - <asp:BoundField DataField="Error" HeaderText="Error" SortExpression="Error" /> - <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True" - SortExpression="id" /> - <asp:CheckBoxField DataField="completed" HeaderText="completed" SortExpression="completed" - Visible="False" /> - </Columns> - </asp:GridView> - <asp:ObjectDataSource ID="DummyObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}" - SelectMethod="DummyGetAssignmentData" TypeName="DummyDataSetTableAdapters.AssignmentsTableAdapter"> - <SelectParameters> - <asp:ControlParameter ControlID="cboShowCompleted" DefaultValue="false" Name="IsCompleted" - PropertyName="Checked" Type="Boolean" /> - </SelectParameters> - </asp:ObjectDataSource> - <!--<table> - <tr> - <td style="text-align: left; width: 60px;"> - <a href="#">Date</a></td> - <td style="text-align: left; width: 50px;"> - <a href="#">Type</a></td> - <td style="text-align: left; width: 200px;"> - <a href="#">Assignment</a></td> - <td style="text-align: left; width: 85px;"> - <a href="#">Status</a></td> - <td> - <a href="#">% Complete</a></td> - <td> - <a href="#">Total</a></td> - <td> - <a href="#">Run</a></td> - <td> - <a href="#">Pass Rate</a></td> - <td> - <a href="#">Pass</a></td> - <td> - <a href="#">Fail</a></td> - <td> - <a href="#">Error</a></td> - </tr> - <tr> - <td style="text-align: left;"> - 23 Dec</td> - <td style="text-align: left;"> - AI</td> - <td style="text-align: left;"> - <a href="ActionItem.aspx">Setup Personal Environment</a></td> - <td style="text-align: left;"> - Started</td> - <td> - 25%</td> - <td> - </td> - <td> - </td> - <td> - </td> - <td> - </td> - <td> - </td> - <td> - </td> - </tr> - <tr> - <td style="text-align: left;"> - 18 Jan</td> - <td style="text-align: left;"> - WO</td> - <td style="text-align: left;"> - <a href="WorkOrder.aspx">1847 on REAS 3.0</a></td> - <td style="text-align: left;"> - Not Started</td> - <td> - 50%</td> - <td> - 8</td> - <td> - 4</td> - <td> - 25%</td> - <td> - 1</td> - <td> - 2</td> - <td> - 1</td> - </tr> - </table>--> - </div> + <div id="MyAssignmentsData"> + <atlas:UpdatePanel ID="p1" runat="server"> + <ContentTemplate> + <asp:GridView ID="GridView1" runat="server" GridLines="None" AllowPaging="True" AllowSorting="True" + AutoGenerateColumns="False" DataSourceID="DummyObjectDataSource1"> + <Columns> + <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" ControlStyle-CssClass="gridleft" + HeaderStyle-CssClass="gridleft" ItemStyle-CssClass="gridleft" /> + <asp:BoundField DataField="Type" HeaderText="Type" SortExpression="Type" ControlStyle-CssClass="gridleft" + HeaderStyle-CssClass="gridcenter" ItemStyle-CssClass="gridcenter"></asp:BoundField> + <asp:HyperLinkField DataTextField="Assignment" HeaderText="Assignment" SortExpression="Assignment" + NavigateUrl="~/ActionItem.aspx" DataNavigateUrlFields="type,id" DataNavigateUrlFormatString="~\Details.aspx?type={0}&id={1}" + DataTextFormatString="{0:c}" HeaderStyle-CssClass="gridleft" ItemStyle-CssClass="gridleft" /> + <asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" ControlStyle-CssClass="gridleft" + HeaderStyle-CssClass="gridleft" ItemStyle-CssClass="gridleft" /> + <asp:BoundField DataField="% Complete" HeaderText="% Done" SortExpression="% Complete" HeaderStyle-CssClass="gridcenter" ItemStyle-CssClass="gridcenter" /> + <asp:BoundField DataField="Total" HeaderText="Total" SortExpression="Total" HeaderStyle-CssClass="gridcenter" ItemStyle-CssClass="gridcenter" /> + <asp:BoundField DataField="Pass Rate" HeaderText="Pass Rate" SortExpression="Pass Rate" HeaderStyle-CssClass="gridcenter" ItemStyle-CssClass="gridcenter" /> + <asp:BoundField DataField="Pass" HeaderText="Pass" SortExpression="Pass" HeaderStyle-CssClass="gridcenter" ItemStyle-CssClass="gridcenter" /> + <asp:BoundField DataField="Fail" HeaderText="Fail" SortExpression="Fail" HeaderStyle-CssClass="gridcenter" ItemStyle-CssClass="gridcenter" /> + <asp:BoundField DataField="Error" HeaderText="Error" SortExpression="Error" HeaderStyle-CssClass="gridcenter" ItemStyle-CssClass="gridcenter" /> + <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True" + SortExpression="id" HeaderStyle-CssClass="gridcenter" ItemStyle-CssClass="gridcenter" /> + <asp:CheckBoxField DataField="completed" HeaderText="completed" SortExpression="completed" + Visible="False" HeaderStyle-CssClass="gridcenter" ItemStyle-CssClass="gridcenter" /> + </Columns> + </asp:GridView> + </ContentTemplate> + <Triggers> + <atlas:ControlValueTrigger ControlID="cboShowCompleted" PropertyName="Checked" /> + </Triggers> + </atlas:UpdatePanel> + <asp:ObjectDataSource ID="DummyObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}" + SelectMethod="DummyGetAssignmentData" TypeName="DummyDataSetTableAdapters.AssignmentsTableAdapter"> + <SelectParameters> + <asp:ControlParameter ControlID="cboShowCompleted" DefaultValue="false" Name="IsCompleted" + PropertyName="Checked" Type="Boolean" /> + </SelectParameters> + </asp:ObjectDataSource> + </div> </div> <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> </b></b> @@ -159,24 +98,33 @@ </td> </tr> <tr> - <td>From:</td><td><asp:DropDownList ID="startMonth" runat="server"> - <asp:ListItem Selected="True" Text="Jan">Jan</asp:ListItem> - </asp:DropDownList> - <asp:DropDownList ID="startDay" runat="server"> - <asp:ListItem Selected="True" Text="1">01</asp:ListItem> - </asp:DropDownList> - <asp:DropDownList ID="startYear" runat="server"> - <asp:ListItem Selected="True" Text="2006">2006</asp:ListItem> - </asp:DropDownList></td></tr> - <tr><td>To:</td><td><asp:DropDownList ID="stopMonth" runat="server"> - <asp:ListItem Selected="True" Text="Jan">Jan</asp:ListItem> - </asp:DropDownList> - <asp:DropDownList ID="stopDay" runat="server"> - <asp:ListItem Selected="True" Text="1">01</asp:ListItem> - </asp:DropDownList> - <asp:DropDownList ID="stopYear" runat="server"> - <asp:ListItem Selected="True" Text="2007">2007</asp:ListItem> - </asp:DropDownList></td></tr> + <td> + From:</td> + <td> + <asp:DropDownList ID="startMonth" runat="server"> + <asp:ListItem Selected="True" Text="Jan">Jan</asp:ListItem> + </asp:DropDownList> + <asp:DropDownList ID="startDay" runat="server"> + <asp:ListItem Selected="True" Text="1">01</asp:ListItem> + </asp:DropDownList> + <asp:DropDownList ID="startYear" runat="server"> + <asp:ListItem Selected="True" Text="2006">2006</asp:ListItem> + </asp:DropDownList></td> + </tr> + <tr> + <td> + To:</td> + <td> + <asp:DropDownList ID="stopMonth" runat="server"> + <asp:ListItem Selected="True" Text="Jan">Jan</asp:ListItem> + </asp:DropDownList> + <asp:DropDownList ID="stopDay" runat="server"> + <asp:ListItem Selected="True" Text="1">01</asp:ListItem> + </asp:DropDownList> + <asp:DropDownList ID="stopYear" runat="server"> + <asp:ListItem Selected="True" Text="2007">2007</asp:ListItem> + </asp:DropDownList></td> + </tr> </table> </div> <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> Added: WebPrototype/Details.aspx =================================================================== --- WebPrototype/Details.aspx (rev 0) +++ WebPrototype/Details.aspx 2006-05-31 05:28:53 UTC (rev 13) @@ -0,0 +1,13 @@ +<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Details.aspx.cs" Inherits="Details" Title="Untitled Page" %> +<asp:Content ID="Content1" ContentPlaceHolderID="PageContent" Runat="Server"> +<h3>Loading details...</h3> +<% + if (!IsPostBack) + { + if (Request.Params["type"] == "WO") + Response.Redirect("~/WorkOrder.aspx?id=" + Request.Params["id"]); + else if (Request.Params["type"] == "AI") + Response.Redirect("~/ActionItem.aspx?id=" + Request.Params["id"]); + } %> + <br /><br />Unable to locate information. Please press the back button on your browser and try again. +</asp:Content> \ No newline at end of file Added: WebPrototype/Details.aspx.cs =================================================================== --- WebPrototype/Details.aspx.cs (rev 0) +++ WebPrototype/Details.aspx.cs 2006-05-31 05:28:53 UTC (rev 13) @@ -0,0 +1,18 @@ +using System; +using System.Data; +using System.Configuration; +using System.Collections; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; + +public partial class Details : System.Web.UI.Page +{ + protected void Page_Load(object sender, EventArgs e) + { + + } +} Modified: WebPrototype/MasterPage.master =================================================================== --- WebPrototype/MasterPage.master 2006-05-31 00:58:57 UTC (rev 12) +++ WebPrototype/MasterPage.master 2006-05-31 05:28:53 UTC (rev 13) @@ -5,6 +5,7 @@ <title>TCDB</title> </head> <body class="master"> +<atlas:ScriptManager ID="scriptManager" EnablePartialRendering="true" runat="server"></atlas:ScriptManager> <div id="nonFooter"> <div id="header"> <div id="logo"> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <m_h...@us...> - 2006-05-31 00:59:10
|
Revision: 12 Author: m_hildebrand Date: 2006-05-30 17:58:57 -0700 (Tue, 30 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=12&view=rev Log Message: ----------- Starting to add "real" data (it comes from a dummy DB) to some of the pages. Also starting to remove all tables for proper CSS usages Modified Paths: -------------- WebPrototype/ActionItem.aspx WebPrototype/App_Themes/Python/python.css WebPrototype/Assignments.aspx WebPrototype/Default.aspx WebPrototype/Default.aspx.cs WebPrototype/MasterPage.master WebPrototype/Web.config Modified: WebPrototype/ActionItem.aspx =================================================================== --- WebPrototype/ActionItem.aspx 2006-05-30 23:55:42 UTC (rev 11) +++ WebPrototype/ActionItem.aspx 2006-05-31 00:58:57 UTC (rev 12) @@ -1,7 +1,7 @@ <%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="ActionItem.aspx.cs" Inherits="ActionItem" Title="Untitled Page" %> -<%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="cc1" %> +<%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="atlas" %> <asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> @@ -14,14 +14,16 @@ Action Item</h2> </td> <td align="right" valign="bottom" style="padding-right: 20px;"> - <a href="#">Active</a> | - <asp:RadioButtonList ID="rdoAmountDone" runat="server" SkinID="rdoAmountDone"> - <asp:ListItem Selected="true" Text="0%" Value="0">0%</asp:ListItem> - <asp:ListItem Selected="true" Text="25%" Value="25">25%</asp:ListItem> - <asp:ListItem Selected="true" Text="50%" Value="50">50%</asp:ListItem> - <asp:ListItem Selected="true" Text="75%" Value="75">75%</asp:ListItem> - <asp:ListItem Selected="true" Text="100%" Value="100">100%</asp:ListItem> + <div class="radiolist"> + <a href="#">Active</a> | + <asp:RadioButtonList ID="rdoAmountDone" runat="server" SkinID="rdoAmountDone" RepeatDirection="Horizontal" CssClass="radiocontrol"> + <asp:ListItem Selected="true" Text="0%" Value="0">0%</asp:ListItem> + <asp:ListItem Selected="true" Text="25%" Value="25">25%</asp:ListItem> + <asp:ListItem Selected="true" Text="50%" Value="50">50%</asp:ListItem> + <asp:ListItem Selected="true" Text="75%" Value="75">75%</asp:ListItem> + <asp:ListItem Selected="true" Text="100%" Value="100">100%</asp:ListItem> </asp:RadioButtonList> + </div> </td> </tr> <tr> @@ -69,97 +71,58 @@ </table> </div> </td> - <td width="300px" align="right"> - <!--<iframe src="Notes.aspx" frameborder="0" width="100%" height="100%" scrolling="auto"></iframe>--> - <atlas:ScriptManager ID="ScriptManager1" runat="server" /> - <table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td width="100%"> - <b class="notetop"><b class="noteb1"></b><b class="noteb2"></b><b class="noteb3"></b> - <b class="noteb4"></b></b> - <div class="noteboxcontent"> - <table width="100%" cellpadding="0" cellspacing="0" border="0"> - <tr> - <asp:Panel ID="Panel2" runat="server" CssClass="collapsePanelHeader"> - <td align="left" valign="bottom"> - <h4> - Don't Forget!:</h4> - 12 May 2006 - </td> - <td align="right" valign="bottom"> - <asp:Image ID="Image1" runat="server" ImageUrl="images/ArrowUp.gif" /> - <!--<asp:Image ID="Image2" runat="server" ImageUrl="images/ArrowDown.gif" />--> - <a href="#" class="notedelete">x</a></td> - </asp:Panel> - </tr> + <td width="300px" align="right" valign="top"> + <atlas:ScriptManager ID="ScriptManager1" runat="server" EnablePartialRendering="true" /> - </table> - <asp:Panel ID="Panel1" runat="server" Height="0"> - <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> - Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer fermentum laoreet - nunc. Maecenas consectetuer metus a justo. Donec semper. Proin tempor mauris non - arcu. Mauris nonummy convallis sapien. Aliquam erat volutpat. Ut eget ante a turpis - volutpat lobortis. Morbi accumsan justo eu massa. Nullam diam. Cras venenatis bibendum - diam. Suspendisse a erat tristique nunc consectetuer ultrices. - </asp:Panel> - </div> - <b class="notebottom"><b class="noteb4"></b><b class="noteb3"></b><b class="noteb2"> - </b></b> - </td></tr> + <table width="100%" cellpadding="0" cellspacing="0" border="0" style="padding: 10px;"> + <tr> + <td width="100%"> + <b class="notetop"><b class="noteb1"></b><b class="noteb2"></b><b class="noteb3"></b> + <b class="noteb4"></b></b> + <div class="noteboxcontent"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <asp:Panel ID="Panel3" runat="server" CssClass="collapsePanelHeader"> + <td align="left" valign="bottom"> + <h4> + Reminder:</h4> + 15 Apr 2006 + </td> + <td align="right" valign="bottom"> + <img alt="Note2Arrow" src="App_Themes/Python/Images/ArrowUp.gif" id="Note2Arrow" /> + <a href="#" class="notedelete">x</a></td> + </asp:Panel> + </tr> + </table> + <atlas:CollapsiblePanelExtender ID="CollapsiblePanelExtender2" runat="server"> + <atlas:CollapsiblePanelProperties Collapsed="true" SuppressPostBack="true" CollapseControlID="Note2Arrow" + ExpandControlID="Note2Arrow" ExpandedImage="App_Themes/Python/Images/ArrowUp.gif" + CollapsedImage="App_Themes/Python/Images/ArrowDown.gif" TargetControlID="Note2Content" + AutoCollapse="false" AutoExpand="false" CollapsedSize="0" ImageControlID="Note2Arrow" /> + </atlas:CollapsiblePanelExtender> + <asp:Panel ID="Note2Content" runat="server" Height="0" Style="overflow: hidden; padding: 0px; + margin: 0px;"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <td class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + Integer lacus elit, consectetuer nec, rutrum at, pretium ac, risus. Sed semper massa + luctus mi. Donec placerat, diam vitae ultricies posuere, felis dui sollicitudin + nibh, eget blandit purus libero in elit. Aenean eget lectus eget ipsum rutrum scelerisque. + Nunc orci mauris, rhoncus ac, pellentesque sit amet, condimentum vel, nibh. Pellentesque + habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. + Suspendisse blandit. + </asp:Panel> + </div> + <b class="notebottom"><b class="noteb4"></b><b class="noteb3"></b><b class="noteb2"> + </b></b><b class="noteb1"></b> + </td> + </tr> </table> - <cc1:CollapsiblePanelExtender ID="CollapsiblePanelExtender1" runat="server"> - <cc1:CollapsiblePanelProperties Collapsed="true" SuppressPostBack="true" CollapseControlID="Image1" - ExpandControlID="Image1" ExpandedImage="images/ArrowUp.gif" CollapsedImage="images/ArrowUp.gif" - TargetControlID="Panel1" AutoCollapse="false" AutoExpand="false" CollapsedSize="0" - ImageControlID="Image1" /> - </cc1:CollapsiblePanelExtender> - <!-- - - - </asp:Panel> - --> - <div class="note"> - <div id="note1"> - </div> - <div id="note2"> - <b class="noteb1"></b> - <br /> - <b class="notetop"><b class="noteb1"></b><b class="noteb2"></b><b class="noteb3"></b> - <b class="noteb4"></b></b> - <div class="noteboxcontent"> - <table width="100%" cellpadding="0" cellspacing="0" border="0"> - <tr> - <td align="left" valign="bottom"> - <h4> - Reminder:</h4> - 01 Apr 2006 - </td> - <td align="right" valign="bottom"> - <a href="#" class="notedelete">x</a></td> - </tr> - <tr> - <td colspan="2" 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. - </div> - <b class="notebottom"><b class="noteb4"></b><b class="noteb3"></b><b class="noteb2"> - </b><b class="noteb1"></b></b> - </div> - <br /> - <a href="#" style="padding-left: 10px; text-align: right;">New Note</a> - </div> + <div style="padding-left: 10px; text-align: left;"><a href="#" style="padding-left: 10px; text-align: left;">New Note</a></div> </td> </tr> </table> Modified: WebPrototype/App_Themes/Python/python.css =================================================================== --- WebPrototype/App_Themes/Python/python.css 2006-05-30 23:55:42 UTC (rev 11) +++ WebPrototype/App_Themes/Python/python.css 2006-05-31 00:58:57 UTC (rev 12) @@ -16,40 +16,109 @@ { background-image: url(images/Header-Background.gif); background-repeat: repeat-x; - } -.logo + +#header A { - border: none; - padding-top: 7px; - padding-left: 10px; + color: White; } -TD.hr + +#header A:hover, #header A:active { - background-image: url(images/hrdot.gif); - background-repeat: repeat-x; - height: 1px; - margin: 4px 0px 2px 0px; - padding: 4px 0px 2px 0px; - background-position: center 4px; + color: #FDB928; } -#header TD + +#header #logo { - color: white; + background-position: left top; + left: 0px; + background-image: url(Images/TCDB-2006-Logo-on-Blue.gif); + width: 200px; + background-repeat: no-repeat; + position: absolute; + top: 4px; + left: 10px; + height: 50px; } -.username + +#header #menu { + text-align: right; + color: White; + padding-right: 10px; + padding-top: 5px; +} + +#header #menu .username +{ color: #FDB928; display: inline; } -#header A + +#header #menu #options { + border-top: red thin solid; + margin-top: 6px; + padding-top: 3px; + right: 0px; + text-align: right; + position: absolute; +} + +#header #menu #options #tasks +{ + text-align: right; color: White; + margin-left: 0px; + padding-left: 0px; + padding-right: 10px; + display: inline; } -#header A:hover, #header A:active + +#header #menu #options #build { - color: #FDB928; + text-align: left; + padding-right: 30px; + margin-right: 0px; + display: inline; + color: White; } + +.radiolist +{ + display: inline; + vertical-align: middle; + padding: 0px; + margin: 0px; + border-right: thin solid; + border-top: thin solid; + border-left: thin solid; + border-bottom: thin solid; +} + +.radiocontrol +{ + display: inline; +} + +TD.radiocontrol, INPUT.radiocontrol +{ + border: thin solid; +} + + +TD.hr +{ + background-image: url(images/hrdot.gif); + background-repeat: repeat-x; + height: 1px; + margin: 4px 0px 2px 0px; + padding: 4px 0px 2px 0px; + background-position: center 4px; +} + + + #footer A { color: White; @@ -61,6 +130,7 @@ #content { padding-left: 10px; + margin-top: 45px; } html Modified: WebPrototype/Assignments.aspx =================================================================== --- WebPrototype/Assignments.aspx 2006-05-30 23:55:42 UTC (rev 11) +++ WebPrototype/Assignments.aspx 2006-05-31 00:58:57 UTC (rev 12) @@ -11,7 +11,7 @@ My Assignments</h2> </td> <td align="right" valign="bottom" style="padding-right: 20px;"> - <asp:CheckBox ID="cboShowCompleted" runat="server" Text="Show Completed" TextAlign="Left" /></td> + <asp:CheckBox ID="cboShowCompleted" runat="server" Text="Show Completed" TextAlign="Left" AutoPostBack="true" /></td> </tr> <tr> <td colspan="2"> @@ -20,7 +20,33 @@ </b></b> <div class="xboxcontent"> <div id="MyAssignmentsData"> - <table> + <asp:GridView ID="GridView1" runat="server" GridLines="None" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="DummyObjectDataSource1"> + <Columns> + <asp:CommandField ShowSelectButton="True" /> + <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" /> + <asp:BoundField DataField="Type" HeaderText="Type" SortExpression="Type" /> + <asp:BoundField DataField="Assignment" HeaderText="Assignment" SortExpression="Assignment" /> + <asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" /> + <asp:BoundField DataField="% Complete" HeaderText="% Complete" SortExpression="% Complete" /> + <asp:BoundField DataField="Total" HeaderText="Total" SortExpression="Total" /> + <asp:BoundField DataField="Pass Rate" HeaderText="Pass Rate" SortExpression="Pass Rate" /> + <asp:BoundField DataField="Pass" HeaderText="Pass" SortExpression="Pass" /> + <asp:BoundField DataField="Fail" HeaderText="Fail" SortExpression="Fail" /> + <asp:BoundField DataField="Error" HeaderText="Error" SortExpression="Error" /> + <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True" + SortExpression="id" /> + <asp:CheckBoxField DataField="completed" HeaderText="completed" SortExpression="completed" + Visible="False" /> + </Columns> + </asp:GridView> + <asp:ObjectDataSource ID="DummyObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}" + SelectMethod="DummyGetAssignmentData" TypeName="DummyDataSetTableAdapters.AssignmentsTableAdapter"> + <SelectParameters> + <asp:ControlParameter ControlID="cboShowCompleted" DefaultValue="false" Name="IsCompleted" + PropertyName="Checked" Type="Boolean" /> + </SelectParameters> + </asp:ObjectDataSource> + <!--<table> <tr> <td style="text-align: left; width: 60px;"> <a href="#">Date</a></td> @@ -93,7 +119,7 @@ <td> 1</td> </tr> - </table> + </table>--> </div> </div> <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> Modified: WebPrototype/Default.aspx =================================================================== --- WebPrototype/Default.aspx 2006-05-30 23:55:42 UTC (rev 11) +++ WebPrototype/Default.aspx 2006-05-31 00:58:57 UTC (rev 12) @@ -1,5 +1,6 @@ <%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Assignments" Title="TCDB: Home" %> <asp:Content ID="Content1" ContentPlaceHolderID="PageContent" Runat="Server"> + <asp:Button ID="btnSave" runat="server" Text="Save!" OnClick="btnSave_Click" /> </asp:Content> Modified: WebPrototype/Default.aspx.cs =================================================================== --- WebPrototype/Default.aspx.cs 2006-05-30 23:55:42 UTC (rev 11) +++ WebPrototype/Default.aspx.cs 2006-05-31 00:58:57 UTC (rev 12) @@ -15,4 +15,8 @@ { } + protected void btnSave_Click(object sender, EventArgs e) + { + btnSave.Text = "I've been saved!"; + } } Modified: WebPrototype/MasterPage.master =================================================================== --- WebPrototype/MasterPage.master 2006-05-30 23:55:42 UTC (rev 11) +++ WebPrototype/MasterPage.master 2006-05-31 00:58:57 UTC (rev 12) @@ -7,46 +7,31 @@ <body class="master"> <div id="nonFooter"> <div id="header"> - <table border="0" cellpadding="0" cellspacing="0" width="100%"> - <tr> - <td align="left" valign="top"> - <a href="Default.aspx"><img src="App_Themes/Python/Images/TCDB-2006-Logo-on-Blue.gif" alt="Logo" class="logo" style="padding-top: 4px; padding-left: 10px" /></a></td> - <td align="right" style="padding-right: 10px" width="500" valign="middle"> - <table border="0" cellpadding="0" cellspacing="0" width="100%"> - <tr> - <td colspan="2" align="right"> - Welcome - <div class="username"> - <asp:Label ID="lblWelcome" runat="server"></asp:Label></div> - | - <asp:LoginView ID="MenuLoginView" runat="server"> - <AnonymousTemplate> - <a href="Register.aspx" class="header">Register</a> | <a href="Login.aspx" class="header"> - Login</a></AnonymousTemplate> - <LoggedInTemplate> - <a href="Settings.aspx" class="header">Settings</a> | <a href="Admin.aspx" class="header"> - Admin</a> | <a href="Logout.aspx" class="header">Logout</a></LoggedInTemplate> - </asp:LoginView> - </td> - </tr> - <tr> - <td colspan="2" class="hr"> - <img alt="" src="images/spacer.gif" height="1" /><br /> - </td> - </tr> - <tr> - <td align="left"> - VSM | 1.1 | Alpha | 134</td> - <td align="right"> - <a href="Assignments.aspx" class="header">Assignments</a> | <a href="Execution.aspx" - class="header">Execution</a> | <a href="Management.aspx" class="header">Test Management</a></td> - </tr> - </table> - </td> - </tr> - </table> + <div id="logo"> + </div> + <div id="menu"> + Welcome + <div class="username"> + <asp:Label ID="lblWelcome" runat="server"></asp:Label></div> + | + <asp:LoginView ID="MenuLoginView" runat="server"> + <AnonymousTemplate> + <a href="Register.aspx" class="header">Register</a> | <a href="Login.aspx" class="header"> + Login</a></AnonymousTemplate> + <LoggedInTemplate> + <a href="Settings.aspx" class="header">Settings</a> | <a href="Admin.aspx" class="header"> + Admin</a> | <a href="Logout.aspx" class="header">Logout</a></LoggedInTemplate> + </asp:LoginView> + <div id="options"> + <div id="build"> + VSM | 1.1 | Alpha | 134</div> + <div id="tasks"> + <a href="Assignments.aspx" class="header">Assignments</a> | <a href="Execution.aspx" + class="header">Execution</a> | <a href="Management.aspx" class="header">Test Management</a> + </div> + </div> + </div> </div> - <br /> <div id="content" class="fullheight"> <form id="form1" runat="server"> <asp:SiteMapPath ID="SiteMapPath1" runat="server"> Modified: WebPrototype/Web.config =================================================================== --- WebPrototype/Web.config 2006-05-30 23:55:42 UTC (rev 11) +++ WebPrototype/Web.config 2006-05-31 00:58:57 UTC (rev 12) @@ -44,7 +44,10 @@ --> </microsoft.web> <appSettings/> - <connectionStrings/> + <connectionStrings> + <add name="DummyDatabaseConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True" + providerName="System.Data.SqlClient" /> + </connectionStrings> <system.web> <pages theme="Python" styleSheetTheme="Python"> <controls> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <jon...@us...> - 2006-05-30 23:55:46
|
Revision: 11 Author: jon_r_johnson Date: 2006-05-30 16:55:42 -0700 (Tue, 30 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=11&view=rev Log Message: ----------- Added the stored procedures ins_computer, ins_architecture, ins_build, ins_lab, ins_os, ins_platform, ins_tags, and ins_testCase Modified Paths: -------------- Schema/TCDBSQLServer2005.sql Modified: Schema/TCDBSQLServer2005.sql =================================================================== --- Schema/TCDBSQLServer2005.sql 2006-05-30 20:10:17 UTC (rev 10) +++ Schema/TCDBSQLServer2005.sql 2006-05-30 23:55:42 UTC (rev 11) @@ -1,774 +1,1061 @@ -\xFF\xFES |
|
From: <sla...@us...> - 2006-05-30 20:10:22
|
Revision: 10 Author: slambson Date: 2006-05-30 13:10:17 -0700 (Tue, 30 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=10&view=rev Log Message: ----------- Added the info on the naming convention for the stored procedures. Modified Paths: -------------- Design/Schema/DB Schema.doc Modified: Design/Schema/DB Schema.doc =================================================================== (Binary files differ) This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <jon...@us...> - 2006-05-28 21:44:25
|
Revision: 9 Author: jon_r_johnson Date: 2006-05-28 14:44:22 -0700 (Sun, 28 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=9&view=rev Log Message: ----------- Added Primary Key / Identity to the Table tcdb_logs. Modified Paths: -------------- Schema/TCDBSQLServer2005.sql Modified: Schema/TCDBSQLServer2005.sql =================================================================== --- Schema/TCDBSQLServer2005.sql 2006-05-27 00:53:13 UTC (rev 8) +++ Schema/TCDBSQLServer2005.sql 2006-05-28 21:44:22 UTC (rev 9) @@ -1,769 +1,774 @@ -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_userRights]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_userRights]( - [userRightsID] [int] IDENTITY(1,1) NOT NULL, - [userID] [int] NULL, - [rightsID] [int] NULL, - [dateCreated] [datetime] NULL, - [grantedBy] [int] NULL, - CONSTRAINT [PK_tcdb_userRights] PRIMARY KEY CLUSTERED -( - [userRightsID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_featureVersion]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_featureVersion]( - [featureVersionID] [int] IDENTITY(1,1) NOT NULL, - [featureID] [int] NULL, - [versionID] [int] NULL, - [include] [bit] NULL CONSTRAINT [DF_tcdb_featureVersion_include] DEFAULT ((0)), - [minVersion] [varchar](50) NULL, - [maxVersion] [varchar](50) NULL, - CONSTRAINT [PK_tcdb_featureVersion] PRIMARY KEY CLUSTERED -( - [featureVersionID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_platform]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_platform]( - [platformID] [int] IDENTITY(1,1) NOT NULL, - [architectureID] [int] NULL, - [osID] [int] NULL, - CONSTRAINT [PK_tcdb_platform] PRIMARY KEY CLUSTERED -( - [platformID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_testCaseTags]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_testCaseTags]( - [testcaseTagsID] [int] IDENTITY(1,1) NOT NULL, - [testcaseID] [int] NULL, - [tagID] [int] NULL, - CONSTRAINT [PK_tcdb_testcasetags] PRIMARY KEY CLUSTERED -( - [testcaseTagsID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_workOrderTestCase]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_workOrderTestCase]( - [workOrderTestCaseID] [int] IDENTITY(1,1) NOT NULL, - [workOrderID] [int] NULL, - [testCaseID] [int] NULL, - CONSTRAINT [PK_tcdb_workOrderTestCase] PRIMARY KEY CLUSTERED -( - [workOrderTestCaseID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_savedWorkOrderTestCase]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_savedWorkOrderTestCase]( - [savedWOTestCaseID] [int] IDENTITY(1,1) NOT NULL, - [savedWorkOrderID] [int] NULL, - [testCaseID] [int] NULL, - CONSTRAINT [PK_tcdb_savedWorkOrderTestCase] PRIMARY KEY CLUSTERED -( - [savedWOTestCaseID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_actionItem]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_actionItem]( - [actionItemID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - [creatorID] [int] NULL, - [dateCreated] [datetime] NULL, - [percentComplete] [int] NULL, - CONSTRAINT [PK_tcdb_actionItem] PRIMARY KEY CLUSTERED -( - [actionItemID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_testPass]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_testPass]( - [testPassID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [versionID] [int] NULL, - CONSTRAINT [PK_tcdb_testPass] PRIMARY KEY CLUSTERED -( - [testPassID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_result]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_result]( - [resultID] [bigint] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [statusEnum] [int] NULL, - [code] [text] NULL, - CONSTRAINT [PK_tcdb_result] PRIMARY KEY CLUSTERED -( - [resultID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_results]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_results]( - [resultsID] [bigint] IDENTITY(1,1) NOT NULL, - [testCaseID] [int] NULL, - [platformID] [int] NULL, - [dateStarted] [datetime] NULL, - [dateFinished] [datetime] NULL, - [assignedID] [int] NULL, - [testPassID] [int] NULL, - [resultID] [bigint] NULL, - [buildID] [int] NULL, - [workOrderID] [int] NULL -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_logs]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_logs]( - [logID] [bigint] NULL, - [resultID] [bigint] NULL, - [name] [varchar](255) NULL, - [dataLocation] [text] NULL -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_state]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_state]( - [stateID] [int] IDENTITY(1,1) NOT NULL, - [currentDomain] [varchar](15) NULL, - [vasClnt] [varchar](16) NULL, - [vasClnts] [varchar](16) NULL, - [vasDev] [varchar](16) NULL, - [vasDevi] [varchar](16) NULL, - [vasGps] [varchar](16) NULL, - [vasProxy] [varchar](16) NULL, - [vasYP] [varchar](16) NULL, - [nis] [varchar](4) NULL, - [openssh] [varchar](16) NULL, - CONSTRAINT [PK_tcdb_state] PRIMARY KEY CLUSTERED -( - [stateID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_architecture]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_architecture]( - [architectureID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - CONSTRAINT [PK_tcdb_architecture] PRIMARY KEY CLUSTERED -( - [architectureID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_assignmentStatus]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_assignmentStatus]( - [assignmentStatusID] [int] IDENTITY(1,1) NOT NULL, - [statusName] [varchar](255) NULL, - [statusEnum] [int] NULL, - CONSTRAINT [PK_tcdb_assignmentStatus] PRIMARY KEY CLUSTERED -( - [assignmentStatusID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_computer]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_computer]( - [computerID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [ipAddress] [varchar](15) NULL, - [hostname] [varchar](50) NULL, - [platformID] [int] NULL, - [labID] [int] NULL, - [stateID] [int] NULL, - CONSTRAINT [PK_tcdb_computer] PRIMARY KEY CLUSTERED -( - [computerID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_feature]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_feature]( - [featureID] [int] IDENTITY(1,1) NOT NULL, - [parentFeatureID] [int] NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - [userID] [int] NULL, - [dateCreated] [datetime] NULL, - [featureNumber] [varchar](20) NULL, - [orderNumber] [int] NULL, - CONSTRAINT [PK_tcdb_feature] PRIMARY KEY CLUSTERED -( - [featureID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_lab]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_lab]( - [labID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - [DNS] [varchar](15) NULL, - CONSTRAINT [PK_tcdb_lab] PRIMARY KEY CLUSTERED -( - [labID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_notes]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_notes]( - [noteID] [int] IDENTITY(1,1) NOT NULL, - [tableName] [varchar](50) NULL, - [tableID] [int] NULL, - [dateCreated] [datetime] NULL, - [noteField] [text] NULL, - [noteAuthor] [int] NULL, - CONSTRAINT [PK_tcdb_notes] PRIMARY KEY CLUSTERED -( - [noteID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_objective]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_objective]( - [objectiveID] [int] IDENTITY(1,1) NOT NULL, - [featureID] [int] NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - [userID] [int] NULL, - [dateEdited] [datetime] NULL, - [statusID] [int] NULL, - CONSTRAINT [PK_tcdb_objective] PRIMARY KEY CLUSTERED -( - [objectiveID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_os]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_os]( - [osID] [int] IDENTITY(1,1) NOT NULL, - [friendlyName] [varchar](255) NULL, - [codeName] [varchar](30) NULL, - CONSTRAINT [PK_tcdb_os] PRIMARY KEY CLUSTERED -( - [osID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_product]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_product]( - [productID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - [devManager] [int] NULL, - [qaManager] [int] NULL, - [devLead] [int] NULL, - [qaLead] [int] NULL, - [pm] [int] NULL, - [codeName] [varchar](10) NULL, - CONSTRAINT [PK_tcdb_product] PRIMARY KEY CLUSTERED -( - [productID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_rights]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_rights]( - [rightsID] [int] NOT NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - CONSTRAINT [PK_tcdb_rights] PRIMARY KEY CLUSTERED -( - [rightsID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_savedWorkOrder]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_savedWorkOrder]( - [savedWorkOrderID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [platformID] [int] NULL, - [creatorID] [int] NULL, - [versionID] [int] NULL, - CONSTRAINT [PK_tcdb_savedWorkOrder] PRIMARY KEY CLUSTERED -( - [savedWorkOrderID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_tags]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_tags]( - [tagID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [description] [text] NULL, - CONSTRAINT [PK_tcdb_tags] PRIMARY KEY CLUSTERED -( - [tagID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_testCase]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_testCase]( - [testCaseID] [int] IDENTITY(1,1) NOT NULL, - [objectiveID] [int] NULL, - [name] [varchar](255) NULL, - [number] [varchar](30) NULL, - [steps] [text] NULL, - [creatorID] [int] NULL, - [lastEditID] [int] NULL, - [dateCreated] [datetime] NULL, - [dateEdited] [datetime] NULL, - [statusID] [int] NULL, - CONSTRAINT [PK_tcdb_testcase] PRIMARY KEY CLUSTERED -( - [testCaseID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_version]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_version]( - [versionID] [int] IDENTITY(1,1) NOT NULL, - [productID] [int] NULL, - [number] [varchar](50) NULL, - [code] [varchar](50) NULL, - [active] [bit] NULL, - [dateCreated] [datetime] NULL, - [devManager] [int] NULL, - [qaManager] [int] NULL, - [devLead] [int] NULL, - [pm] [int] NULL, - CONSTRAINT [PK_tcdb_version] PRIMARY KEY CLUSTERED -( - [versionID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_workOrder]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_workOrder]( - [workorderID] [int] IDENTITY(1,1) NOT NULL, - [name] [varchar](255) NULL, - [platformID] [int] NULL, - [dateCreated] [datetime] NULL, - [dateCompleted] [datetime] NULL, - [creatorID] [int] NULL, - [testPassID] [int] NULL, - CONSTRAINT [PK_tcdb_workorder] PRIMARY KEY CLUSTERED -( - [workorderID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_user]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_user --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/23/2006 --- Purpose: Insert a new user in the master users table. --- --- Input: @firstName -- User First Name --- @lastName -- User Last Name --- @email -- Email Address for User --- @officePhone -- Office Phone for User I.E. ''(xxx) xxx-xxxx'' --- @homePhone -- Office Phone for User I.E. ''(xxx) xxx-xxxx'' --- @cellPhone -- Office Phone for User I.E. ''(xxx) xxx-xxxx'' --- @automation -- 0 - Normal Person, 1 - Automation Account --- --- Output: none ------------------------------------------------------------------- -CREATE proc [dbo].[ins_user] ( - @firstName varchar(24), - @lastName varchar(24), - @email varchar(50), - @officePhone varchar(14) = null, - @homePhone varchar(14) = null, - @cellPhone varchar(14) = null, - @automation bit = null -) as - --- 2006/05/24 JRJ Default to Normal Person -if (@automation is null) - set @automation = 0 - --- 2006/05/24 JRJ Corrected table name -insert into tcdb_user -select - @email, - @officePhone, - @homePhone, - @cellPhone, - @firstName, - @lastName, - @automation' -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_versionTestCase]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_versionTestCase]( - [versionTestCaseID] [int] IDENTITY(1,1) NOT NULL, - [testCaseID] [int] NULL, - [versionID] [int] NULL, - [include] [bit] NULL CONSTRAINT [DF_tcdb_versionTestCase_include] DEFAULT ((0)), - [minVersion] [varchar](50) NULL, - [maxVersion] [varchar](50) NULL, - CONSTRAINT [PK_tcdb_versionTestCase] PRIMARY KEY CLUSTERED -( - [versionTestCaseID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_platformVersion]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_platformVersion]( - [platformVersionID] [int] IDENTITY(1,1) NOT NULL, - [platformID] [int] NULL, - [versionID] [int] NULL, - [include] [bit] NULL CONSTRAINT [DF_tcdb_platformVersion_include] DEFAULT ((0)), - [minVersion] [varchar](50) NULL, - [maxVersion] [varchar](50) NULL, - CONSTRAINT [PK_tcdb_platformVersion] PRIMARY KEY CLUSTERED -( - [platformVersionID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_testcasePlatform]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_testcasePlatform]( - [testcasePlatformID] [int] IDENTITY(1,1) NOT NULL, - [testcaseID] [int] NULL, - [platformID] [int] NULL, - [include] [bit] NULL CONSTRAINT [DF_tcdb_testcasePlatform_include] DEFAULT ((0)), - CONSTRAINT [PK_tcdb_testcasePlatform] PRIMARY KEY CLUSTERED -( - [testcasePlatformID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_status]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_status]( - [statusID] [int] IDENTITY(1,1) NOT NULL, - [statusGroup] [varchar](50) NULL, - [statusName] [varchar](50) NULL, - [Description] [text] NULL, - CONSTRAINT [PK_tcdb_status] PRIMARY KEY CLUSTERED -( - [statusID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_assignment]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_assignment]( - [assignmentID] [int] IDENTITY(1,1) NOT NULL, - [creatorID] [int] NULL, - [assignedID] [int] NULL, - [dateAssigned] [datetime] NULL, - [dateFinished] [datetime] NULL, - [dateDue] [datetime] NULL, - [assignmentStatusID] [int] NULL, - [workOrderID] [int] NULL, - [actionItemID] [int] NULL, - [highPriority] [bit] NULL CONSTRAINT [DF_tcdb_assignment_highPriority] DEFAULT ((0)), - [statusID] [int] NULL, - CONSTRAINT [PK_tcdb_assignment] PRIMARY KEY CLUSTERED -( - [assignmentID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_user]( - [userID] [int] IDENTITY(1,1) NOT NULL, - [email] [varchar](50) NOT NULL, - [officePhone] [varchar](14) NULL, - [homePhone] [varchar](14) NULL, - [cellPhone] [varchar](14) NULL, - [firstName] [varchar](24) NOT NULL, - [lastName] [varchar](24) NOT NULL, - [automation] [bit] NOT NULL, - CONSTRAINT [PK_tcdb_user] PRIMARY KEY CLUSTERED -( - [email] ASC, - [firstName] ASC, - [lastName] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO - -IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND name = N'ix_userID') -CREATE UNIQUE NONCLUSTERED INDEX [ix_userID] ON [dbo].[tcdb_user] -( - [userID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_build]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_build]( - [buildID] [int] IDENTITY(1,1) NOT NULL, - [versionID] [int] NULL, - [number] [varchar](20) NULL, - [active] [bit] NULL, - [dateCreated] [datetime] NULL, - CONSTRAINT [PK_tcdb_build] PRIMARY KEY CLUSTERED -( - [buildID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_product]') AND type in (N'P', N'PC')) -BEGIN -EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ --- Stored Procedure: ins_product --- --- Database: TCDB --- Author: Jon R. Johnson --- Date: 05/23/2006 --- Purpose: Insert a new product in the master products table. --- --- Input: @name -- Product Name --- @description -- Product Description --- @devManager -- Development Manager --- @qaManager -- Q.A. Manager --- @devLead -- Development Lead --- @qaLead -- Q.A. Lead --- @pm -- Product Manager --- @codeName -- Product Code Name --- --- Output: none ------------------------------------------------------------------- -create proc [dbo].[ins_product] ( - @name varchar(255), - @description text, - @devManager varchar(49), - @qaManager varchar(49), - @devLead varchar(49), - @qaLead varchar(49), - @pm varchar(49), - @codeName varchar(10) -) as - - -insert into tcdb_product -select - @name, - @description, - devManager=(select userID from tcdb_user where firstName+'' ''+lastName = @devManager), - qaManager=(select userID from tcdb_user where firstName+'' ''+lastName = @qaManager), - devLead=(select userID from tcdb_user where firstName+'' ''+lastName = @devLead), - qaLead=(select userID from tcdb_user where firstName+'' ''+lastName = @qaLead), - pm=(select userID from tcdb_user where firstName+'' ''+lastName = @pm), - @codeName - -' -END +\xFF\xFES |
|
From: <m_h...@us...> - 2006-05-27 00:53:33
|
Revision: 8 Author: m_hildebrand Date: 2006-05-26 17:53:13 -0700 (Fri, 26 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=8&view=rev Log Message: ----------- Cleaned up the Python theme logo a little bit. Still needs some work though. Modified Paths: -------------- Graphics/Python/TCDB 2006 Logo.psd Graphics/Python/TCDB-2006-Logo-on-Blue.gif Graphics/Python/TCDB-2006-Logo-on-White.gif WebPrototype/App_Themes/Python/Images/Thumbs.db WebPrototype/App_Themes/Python/python.css WebPrototype/MasterPage.master Added Paths: ----------- WebPrototype/App_Themes/Python/Images/ArrowDown.gif WebPrototype/App_Themes/Python/Images/ArrowUp.gif WebPrototype/App_Themes/Python/Images/Header-Background.gif WebPrototype/App_Themes/Python/Images/TCDB-2006-Logo-on-Blue.gif WebPrototype/App_Themes/Python/Images/reddot.gif Removed Paths: ------------- WebPrototype/App_Themes/Python/Images/background.gif Modified: Graphics/Python/TCDB 2006 Logo.psd =================================================================== (Binary files differ) Modified: Graphics/Python/TCDB-2006-Logo-on-Blue.gif =================================================================== (Binary files differ) Modified: Graphics/Python/TCDB-2006-Logo-on-White.gif =================================================================== (Binary files differ) Copied: WebPrototype/App_Themes/Python/Images/ArrowDown.gif (from rev 6, Graphics/Python/ArrowDown.gif) =================================================================== (Binary files differ) Copied: WebPrototype/App_Themes/Python/Images/ArrowUp.gif (from rev 6, Graphics/Python/ArrowUp.gif) =================================================================== (Binary files differ) Copied: WebPrototype/App_Themes/Python/Images/Header-Background.gif (from rev 6, Graphics/Python/Header-Background.gif) =================================================================== (Binary files differ) Copied: WebPrototype/App_Themes/Python/Images/TCDB-2006-Logo-on-Blue.gif (from rev 6, Graphics/Python/TCDB-2006-Logo-on-Blue.gif) =================================================================== (Binary files differ) Modified: WebPrototype/App_Themes/Python/Images/Thumbs.db =================================================================== (Binary files differ) Deleted: WebPrototype/App_Themes/Python/Images/background.gif =================================================================== (Binary files differ) Copied: WebPrototype/App_Themes/Python/Images/reddot.gif (from rev 6, Graphics/Python/reddot.gif) =================================================================== (Binary files differ) Modified: WebPrototype/App_Themes/Python/python.css =================================================================== --- WebPrototype/App_Themes/Python/python.css 2006-05-26 19:12:46 UTC (rev 7) +++ WebPrototype/App_Themes/Python/python.css 2006-05-27 00:53:13 UTC (rev 8) @@ -1,6 +1,6 @@ .master { - background-image: url(images/background.gif); + background-image: url(images/Header-Background.gif); background-repeat: repeat-x; margin: 0; padding: 0; @@ -14,7 +14,7 @@ #header { - background-image: url(images/background.gif); + background-image: url(images/Header-Background.gif); background-repeat: repeat-x; } Modified: WebPrototype/MasterPage.master =================================================================== --- WebPrototype/MasterPage.master 2006-05-26 19:12:46 UTC (rev 7) +++ WebPrototype/MasterPage.master 2006-05-27 00:53:13 UTC (rev 8) @@ -10,7 +10,7 @@ <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td align="left" valign="top"> - <a href="Default.aspx"><img src="images/logo.gif" alt="Logo" class="logo" style="padding-top: 7px; padding-left: 10px" /></a></td> + <a href="Default.aspx"><img src="App_Themes/Python/Images/TCDB-2006-Logo-on-Blue.gif" alt="Logo" class="logo" style="padding-top: 4px; padding-left: 10px" /></a></td> <td align="right" style="padding-right: 10px" width="500" valign="middle"> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <jon...@us...> - 2006-05-26 19:12:53
|
Revision: 7 Author: jon_r_johnson Date: 2006-05-26 12:12:46 -0700 (Fri, 26 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=7&view=rev Log Message: ----------- Modified Paths: -------------- Schema/TCDBSQLServer2005.sql Modified: Schema/TCDBSQLServer2005.sql =================================================================== --- Schema/TCDBSQLServer2005.sql 2006-05-26 18:51:10 UTC (rev 6) +++ Schema/TCDBSQLServer2005.sql 2006-05-26 19:12:46 UTC (rev 7) @@ -152,11 +152,12 @@ [resultID] [bigint] IDENTITY(1,1) NOT NULL, [name] [varchar](255) NULL, [statusEnum] [int] NULL, + [code] [text] NULL, CONSTRAINT [PK_tcdb_result] PRIMARY KEY CLUSTERED ( [resultID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON @@ -543,12 +544,16 @@ @firstName varchar(24), @lastName varchar(24), @email varchar(50), - @officePhone varchar(14), - @homePhone varchar(14), - @cellPhone varchar(14), - @automation bit + @officePhone varchar(14) = null, + @homePhone varchar(14) = null, + @cellPhone varchar(14) = null, + @automation bit = null ) as +-- 2006/05/24 JRJ Default to Normal Person +if (@automation is null) + set @automation = 0 + -- 2006/05/24 JRJ Corrected table name insert into tcdb_user select @@ -585,37 +590,6 @@ GO SET QUOTED_IDENTIFIER ON GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_user]( - [userID] [int] IDENTITY(1,1) NOT NULL, - [email] [varchar](50) NOT NULL, - [officePhone] [varchar](14) NULL, - [homePhone] [varchar](14) NULL, - [cellPhone] [varchar](14) NULL, - [firstName] [varchar](24) NOT NULL, - [lastName] [varchar](24) NOT NULL, - [automation] [bit] NULL, - CONSTRAINT [PK_tcdb_user] PRIMARY KEY CLUSTERED -( - [email] ASC, - [firstName] ASC, - [lastName] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO - -IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND name = N'ix_userID') -CREATE UNIQUE NONCLUSTERED INDEX [ix_userID] ON [dbo].[tcdb_user] -( - [userID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_platformVersion]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tcdb_platformVersion]( @@ -697,6 +671,37 @@ GO SET QUOTED_IDENTIFIER ON GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_user]( + [userID] [int] IDENTITY(1,1) NOT NULL, + [email] [varchar](50) NOT NULL, + [officePhone] [varchar](14) NULL, + [homePhone] [varchar](14) NULL, + [cellPhone] [varchar](14) NULL, + [firstName] [varchar](24) NOT NULL, + [lastName] [varchar](24) NOT NULL, + [automation] [bit] NOT NULL, + CONSTRAINT [PK_tcdb_user] PRIMARY KEY CLUSTERED +( + [email] ASC, + [firstName] ASC, + [lastName] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO + +IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND name = N'ix_userID') +CREATE UNIQUE NONCLUSTERED INDEX [ix_userID] ON [dbo].[tcdb_user] +( + [userID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_build]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tcdb_build]( This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <m_h...@us...> - 2006-05-26 18:51:23
|
Revision: 6 Author: m_hildebrand Date: 2006-05-26 11:51:10 -0700 (Fri, 26 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=6&view=rev Log Message: ----------- Added a logo for the Python theme and relocated all theme-related graphics from Graphics to Graphics/Python Added Paths: ----------- Graphics/Python/ Graphics/Python/ArrowDown.gif Graphics/Python/ArrowUp.gif Graphics/Python/Header-Background.gif Graphics/Python/TCDB 2006 Logo.psd Graphics/Python/TCDB-2006-Logo-on-Blue.gif Graphics/Python/TCDB-2006-Logo-on-White.gif Graphics/Python/reddot.gif Removed Paths: ------------- Graphics/ArrowDown.gif Graphics/ArrowUp.gif Graphics/Header-Background.gif Graphics/reddot.gif Deleted: Graphics/ArrowDown.gif =================================================================== (Binary files differ) Deleted: Graphics/ArrowUp.gif =================================================================== (Binary files differ) Deleted: Graphics/Header-Background.gif =================================================================== (Binary files differ) Copied: Graphics/Python/ArrowDown.gif (from rev 2, Graphics/ArrowDown.gif) =================================================================== (Binary files differ) Copied: Graphics/Python/ArrowUp.gif (from rev 2, Graphics/ArrowUp.gif) =================================================================== (Binary files differ) Copied: Graphics/Python/Header-Background.gif (from rev 2, Graphics/Header-Background.gif) =================================================================== (Binary files differ) Added: Graphics/Python/TCDB 2006 Logo.psd =================================================================== (Binary files differ) Property changes on: Graphics/Python/TCDB 2006 Logo.psd ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Graphics/Python/TCDB-2006-Logo-on-Blue.gif =================================================================== (Binary files differ) Property changes on: Graphics/Python/TCDB-2006-Logo-on-Blue.gif ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Graphics/Python/TCDB-2006-Logo-on-White.gif =================================================================== (Binary files differ) Property changes on: Graphics/Python/TCDB-2006-Logo-on-White.gif ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Copied: Graphics/Python/reddot.gif (from rev 2, Graphics/reddot.gif) =================================================================== (Binary files differ) Deleted: Graphics/reddot.gif =================================================================== (Binary files differ) This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <sla...@us...> - 2006-05-26 17:55:43
|
Revision: 5 Author: slambson Date: 2006-05-26 10:55:30 -0700 (Fri, 26 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=5&view=rev Log Message: ----------- This is all of the documentation I have kept thus far. Added Paths: ----------- Design/Features/ Design/Features/Required Features.doc Design/Schema/DB Schema.bmp Design/Schema/DB Schema.doc Design/UI/GUI DESIGN.doc Design/UI/GUI subcomponent schedule.doc Added: Design/Features/Required Features.doc =================================================================== (Binary files differ) Property changes on: Design/Features/Required Features.doc ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Design/Schema/DB Schema.bmp =================================================================== (Binary files differ) Property changes on: Design/Schema/DB Schema.bmp ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Design/Schema/DB Schema.doc =================================================================== (Binary files differ) Property changes on: Design/Schema/DB Schema.doc ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Design/UI/GUI DESIGN.doc =================================================================== (Binary files differ) Property changes on: Design/UI/GUI DESIGN.doc ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Design/UI/GUI subcomponent schedule.doc =================================================================== (Binary files differ) Property changes on: Design/UI/GUI subcomponent schedule.doc ___________________________________________________________________ Name: svn:mime-type + application/octet-stream This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <jon...@us...> - 2006-05-25 21:38:51
|
Revision: 4 Author: jon_r_johnson Date: 2006-05-25 14:38:46 -0700 (Thu, 25 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=4&view=rev Log Message: ----------- Modified Paths: -------------- Schema/TCDBSQLServer2005.sql Modified: Schema/TCDBSQLServer2005.sql =================================================================== --- Schema/TCDBSQLServer2005.sql 2006-05-25 20:24:12 UTC (rev 3) +++ Schema/TCDBSQLServer2005.sql 2006-05-25 21:38:46 UTC (rev 4) @@ -2,28 +2,6 @@ GO SET QUOTED_IDENTIFIER ON GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_user]( - [userID] [int] IDENTITY(1,1) NOT NULL, - [email] [varchar](50) NULL, - [officePhone] [varchar](14) NULL, - [homePhone] [varchar](14) NULL, - [cellPhone] [varchar](14) NULL, - [firstName] [varchar](24) NULL, - [lastName] [varchar](24) NULL, - [automation] [bit] NULL, - CONSTRAINT [PK_tcdb_user] PRIMARY KEY CLUSTERED -( - [userID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_userRights]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tcdb_userRights]( @@ -49,6 +27,9 @@ [featureVersionID] [int] IDENTITY(1,1) NOT NULL, [featureID] [int] NULL, [versionID] [int] NULL, + [include] [bit] NULL CONSTRAINT [DF_tcdb_featureVersion_include] DEFAULT ((0)), + [minVersion] [varchar](50) NULL, + [maxVersion] [varchar](50) NULL, CONSTRAINT [PK_tcdb_featureVersion] PRIMARY KEY CLUSTERED ( [featureVersionID] ASC @@ -128,28 +109,6 @@ GO SET QUOTED_IDENTIFIER ON GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_assignment]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_assignment]( - [assignmentID] [int] IDENTITY(1,1) NOT NULL, - [creatorID] [int] NULL, - [assignedID] [int] NULL, - [dateAssigned] [datetime] NULL, - [dateFinished] [datetime] NULL, - [assignmentStatusID] [int] NULL, - [workOrderID] [int] NULL, - [actionItemID] [int] NULL, - CONSTRAINT [PK_tcdb_assignment] PRIMARY KEY CLUSTERED -( - [assignmentID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_actionItem]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tcdb_actionItem]( @@ -327,6 +286,7 @@ [userID] [int] NULL, [dateCreated] [datetime] NULL, [featureNumber] [varchar](20) NULL, + [orderNumber] [int] NULL, CONSTRAINT [PK_tcdb_feature] PRIMARY KEY CLUSTERED ( [featureID] ASC @@ -385,6 +345,7 @@ [description] [text] NULL, [userID] [int] NULL, [dateEdited] [datetime] NULL, + [statusID] [int] NULL, CONSTRAINT [PK_tcdb_objective] PRIMARY KEY CLUSTERED ( [objectiveID] ASC @@ -501,6 +462,7 @@ [lastEditID] [int] NULL, [dateCreated] [datetime] NULL, [dateEdited] [datetime] NULL, + [statusID] [int] NULL, CONSTRAINT [PK_tcdb_testcase] PRIMARY KEY CLUSTERED ( [testCaseID] ASC @@ -557,45 +519,6 @@ GO SET QUOTED_IDENTIFIER ON GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_versionTestCase]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_versionTestCase]( - [versionTestCaseID] [int] IDENTITY(1,1) NOT NULL, - [testCaseID] [int] NULL, - [versionID] [int] NULL, - [include] [bit] NULL, - [minVersion] [varchar](50) NULL, - [maxVersion] [varchar](50) NULL, - CONSTRAINT [PK_tcdb_versionTestCase] PRIMARY KEY CLUSTERED -( - [versionTestCaseID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO -IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_build]') AND type in (N'U')) -BEGIN -CREATE TABLE [dbo].[tcdb_build]( - [buildID] [int] IDENTITY(1,1) NOT NULL, - [versionID] [int] NULL, - [number] [varchar](20) NULL, - [active] [bit] NULL, - [dateCreated] [datetime] NULL, - CONSTRAINT [PK_tcdb_build] PRIMARY KEY CLUSTERED -( - [buildID] ASC -)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] -) ON [PRIMARY] -END -GO -SET ANSI_NULLS ON -GO -SET QUOTED_IDENTIFIER ON -GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_user]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ @@ -642,6 +565,157 @@ GO SET QUOTED_IDENTIFIER ON GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_versionTestCase]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_versionTestCase]( + [versionTestCaseID] [int] IDENTITY(1,1) NOT NULL, + [testCaseID] [int] NULL, + [versionID] [int] NULL, + [include] [bit] NULL CONSTRAINT [DF_tcdb_versionTestCase_include] DEFAULT ((0)), + [minVersion] [varchar](50) NULL, + [maxVersion] [varchar](50) NULL, + CONSTRAINT [PK_tcdb_versionTestCase] PRIMARY KEY CLUSTERED +( + [versionTestCaseID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_user]( + [userID] [int] IDENTITY(1,1) NOT NULL, + [email] [varchar](50) NOT NULL, + [officePhone] [varchar](14) NULL, + [homePhone] [varchar](14) NULL, + [cellPhone] [varchar](14) NULL, + [firstName] [varchar](24) NOT NULL, + [lastName] [varchar](24) NOT NULL, + [automation] [bit] NULL, + CONSTRAINT [PK_tcdb_user] PRIMARY KEY CLUSTERED +( + [email] ASC, + [firstName] ASC, + [lastName] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO + +IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND name = N'ix_userID') +CREATE UNIQUE NONCLUSTERED INDEX [ix_userID] ON [dbo].[tcdb_user] +( + [userID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_platformVersion]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_platformVersion]( + [platformVersionID] [int] IDENTITY(1,1) NOT NULL, + [platformID] [int] NULL, + [versionID] [int] NULL, + [include] [bit] NULL CONSTRAINT [DF_tcdb_platformVersion_include] DEFAULT ((0)), + [minVersion] [varchar](50) NULL, + [maxVersion] [varchar](50) NULL, + CONSTRAINT [PK_tcdb_platformVersion] PRIMARY KEY CLUSTERED +( + [platformVersionID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_testcasePlatform]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_testcasePlatform]( + [testcasePlatformID] [int] IDENTITY(1,1) NOT NULL, + [testcaseID] [int] NULL, + [platformID] [int] NULL, + [include] [bit] NULL CONSTRAINT [DF_tcdb_testcasePlatform_include] DEFAULT ((0)), + CONSTRAINT [PK_tcdb_testcasePlatform] PRIMARY KEY CLUSTERED +( + [testcasePlatformID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_status]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_status]( + [statusID] [int] IDENTITY(1,1) NOT NULL, + [statusGroup] [varchar](50) NULL, + [statusName] [varchar](50) NULL, + [Description] [text] NULL, + CONSTRAINT [PK_tcdb_status] PRIMARY KEY CLUSTERED +( + [statusID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_assignment]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_assignment]( + [assignmentID] [int] IDENTITY(1,1) NOT NULL, + [creatorID] [int] NULL, + [assignedID] [int] NULL, + [dateAssigned] [datetime] NULL, + [dateFinished] [datetime] NULL, + [dateDue] [datetime] NULL, + [assignmentStatusID] [int] NULL, + [workOrderID] [int] NULL, + [actionItemID] [int] NULL, + [highPriority] [bit] NULL CONSTRAINT [DF_tcdb_assignment_highPriority] DEFAULT ((0)), + [statusID] [int] NULL, + CONSTRAINT [PK_tcdb_assignment] PRIMARY KEY CLUSTERED +( + [assignmentID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_build]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_build]( + [buildID] [int] IDENTITY(1,1) NOT NULL, + [versionID] [int] NULL, + [number] [varchar](20) NULL, + [active] [bit] NULL, + [dateCreated] [datetime] NULL, + CONSTRAINT [PK_tcdb_build] PRIMARY KEY CLUSTERED +( + [buildID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_product]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <m_h...@us...> - 2006-05-25 20:24:20
|
Revision: 3 Author: m_hildebrand Date: 2006-05-25 13:24:12 -0700 (Thu, 25 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=3&view=rev Log Message: ----------- Modified Paths: -------------- Design/UI/Thumbs.db Added Paths: ----------- Design/UI/Python Swatches.aco Removed Paths: ------------- Design/UI/Quest Swatches.aco Copied: Design/UI/Python Swatches.aco (from rev 2, Design/UI/Quest Swatches.aco) =================================================================== (Binary files differ) Deleted: Design/UI/Quest Swatches.aco =================================================================== (Binary files differ) Modified: Design/UI/Thumbs.db =================================================================== (Binary files differ) This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
2 messages has been excluded from this view by a project administrator.
