Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [91] Website
|
From: <ro...@us...> - 2006-07-10 19:09:15
|
Revision: 91 Author: rouquin Date: 2006-07-10 12:09:08 -0700 (Mon, 10 Jul 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=91&view=rev Log Message: ----------- Started porting AssignmentsTree.ascx to Website. Not fully working yet. Still waiting for stored procedures, but testing it with manual queries for now. Modified Paths: -------------- Website/Assignments.aspx Website/Includes/AssignmentsTree.ascx Website/Includes/Header.ascx Website/Includes/Header_Menu.ascx Website/TCDB.master Modified: Website/Assignments.aspx =================================================================== --- Website/Assignments.aspx 2006-07-10 17:12:54 UTC (rev 90) +++ Website/Assignments.aspx 2006-07-10 19:09:08 UTC (rev 91) @@ -1,8 +1,10 @@ <%@ Page Language="C#" MasterPageFile="~/TCDB.master" AutoEventWireup="true" Title="Untitled Page" %> -<asp:Content ID="TreeContent" ContentPlaceHolderID="TreeContentPlaceHolder" Runat="Server"> + +<%@ Register Src="~/Includes/AssignmentsTree.ascx" TagPrefix="assignment" TagName="Tree" %> +<asp:Content ID="TreeContent" ContentPlaceHolderID="TreeContentPlaceHolder" runat="Server"> + <assignment:Tree ID=tree runat=server /> </asp:Content> -<asp:Content ID="MainContent" ContentPlaceHolderID="MainContentPlaceHolder" Runat="Server"> +<asp:Content ID="MainContent" ContentPlaceHolderID="MainContentPlaceHolder" runat="Server"> </asp:Content> -<asp:Content ID="NotesContent" ContentPlaceHolderID="NotesContentPlaceHolder" Runat="Server"> +<asp:Content ID="NotesContent" ContentPlaceHolderID="NotesContentPlaceHolder" runat="Server"> </asp:Content> - Modified: Website/Includes/AssignmentsTree.ascx =================================================================== --- Website/Includes/AssignmentsTree.ascx 2006-07-10 17:12:54 UTC (rev 90) +++ Website/Includes/AssignmentsTree.ascx 2006-07-10 19:09:08 UTC (rev 91) @@ -1 +1,133 @@ <%@ Control Language="C#" AutoEventWireup="true" %> +<%@ Import Namespace=System.Data.SqlClient %> +<%@ Import Namespace=System.Data %> + +<script runat=server > + + private SqlConnection _DBConnection = new SqlConnection("Data Source=DAD\\SQLSERVER2005;Initial Catalog=tcdb;Persist Security Info=True;User ID=tcdb;Password=tcdbpw"); + + protected void Page_Load(object sender, EventArgs e) + { + DBConnection.Open(); + + } + public SqlConnection DBConnection { + get { return _DBConnection; } + } + public void updateTree() + { + foreach (TreeNode node in TreeView1.Nodes) + { + node.ChildNodes.Clear(); + TreeView1_TreeNodePopulate(TreeView1, new TreeNodeEventArgs(node)); + } + TreeView1.ExpandAll(); + } + protected void TreeView1_TreeNodePopulate(object sender, TreeNodeEventArgs e) + { + TreeView tv = (TreeView)sender; + DataSet ResultsDataSet = new DataSet(); + SqlDataAdapter DBAdapter; + String query; + + // Call the appropriate method to populate a node at a particular level. + switch (e.Node.Depth) + { + case 0: + // Populate the first-level nodes. + DBAdapter = new SqlDataAdapter("SELECT userID,firstName,lastName FROM tcdb_user", DBConnection); + DBAdapter.Fill(ResultsDataSet); + + if (ResultsDataSet.Tables.Count > 0) + { + foreach (DataRow row in ResultsDataSet.Tables[0].Rows) + { + // Create the new node. + TreeNode newNode = new TreeNode(); + newNode.Text = row["firstName"] + " " + row["lastName"]; + newNode.Value = row["userID"].ToString(); + + // Set the PopulateOnDemand property to true so that the child nodes can be + // dynamically populated. + newNode.PopulateOnDemand = true; + + // Set additional properties for the node. + newNode.SelectAction = TreeNodeSelectAction.Expand; + newNode.NavigateUrl = "~/Assignments.aspx?id=" + row["userID"]; + + // Add the new node to the ChildNodes collection of the parent node. + e.Node.ChildNodes.Add(newNode); + } + } + break; + case 1: + // Populate the second-level nodes. + query = "SELECT ai.actionItemID, ai.name FROM tcdb_actionItem ai" + + "INNER JOIN tcdb_assignment a ON ai.actionItemID = a.actionItemID " + + "WHERE (NOT a.statusID=12) AND (a.assignedID = " + e.Node.Value + ") ORDER BY a.highPriority DESC"; + DBAdapter = new SqlDataAdapter(query, DBConnection); + DBAdapter.Fill(ResultsDataSet); + + if (ResultsDataSet.Tables.Count > 0) + { + foreach (DataRow row in ResultsDataSet.Tables[0].Rows) + { + // Create the new node. + TreeNode newNode = new TreeNode(); + newNode.Text = row["name"].ToString(); + newNode.Value = row["actionItemID"].ToString(); + + // Set the PopulateOnDemand property to true so that the child nodes can be + // dynamically populated. + newNode.PopulateOnDemand = true; + + // Set additional properties for the node. + newNode.SelectAction = TreeNodeSelectAction.Expand; + newNode.NavigateUrl = "~/ActionItemEdit.aspx?id=" + newNode.Value; + + // Add the new node to the ChildNodes collection of the parent node. + e.Node.ChildNodes.Add(newNode); + } + } + ResultsDataSet.Clear(); + query = "SELECT wo.WorkOrderID, wo.name FROM tcdb_workOrder wo" + + "INNER JOIN tcdb_assignment a ON wo.WorkOrderID = a.workOrderID " + + "WHERE (NOT a.statusID=16) AND (a.assignedID = " + e.Node.Value + ")"; + DBAdapter = new SqlDataAdapter(query, DBConnection); + DBAdapter.Fill(ResultsDataSet); + + if (ResultsDataSet.Tables.Count > 0) + { + foreach (DataRow row in ResultsDataSet.Tables[0].Rows) + { + // Create the new node. + TreeNode newNode = new TreeNode(); + newNode.Text = row["name"].ToString(); + newNode.Value = row["workOrderID"].ToString(); + + // Set the PopulateOnDemand property to true so that the child nodes can be + // dynamically populated. + newNode.PopulateOnDemand = true; + + // Set additional properties for the node. + newNode.SelectAction = TreeNodeSelectAction.Expand; + newNode.NavigateUrl = "~/WorkOrderEdit.aspx?id=" + newNode.Value; + + // Add the new node to the ChildNodes collection of the parent node. + e.Node.ChildNodes.Add(newNode); + } + } + break; + + } + } +</script> + +<asp:TreeView ID=TreeView1 runat="server" SelectedNodeStyle-CssClass="selectednode" + OnTreeNodePopulate=TreeView1_TreeNodePopulate> + <Nodes> + <asp:TreeNode Text="User Assignments" Value="Users" PopulateOnDemand="True" SelectAction=Expand + NavigateUrl="~/Assignments.aspx" /> + </Nodes> + <SelectedNodeStyle CssClass="selectednode" /> +</asp:TreeView> Modified: Website/Includes/Header.ascx =================================================================== --- Website/Includes/Header.ascx 2006-07-10 17:12:54 UTC (rev 90) +++ Website/Includes/Header.ascx 2006-07-10 19:09:08 UTC (rev 91) @@ -1,5 +1,5 @@ <%@ Control Language="C#" AutoEventWireup="true" %> -<%@ Register TagPrefix="TCDB" TagName="User" src="~/Includes/Header_User.ascx" %> +<%@ Register TagPrefix="TCDB" TagName="User" src="~/Includes/Header_User.ascx" %> <%@ Register TagPrefix="TCDB" TagName="CurrentInfo" src="~/Includes/Header_CurrentInfo.ascx" %> <%@ Register TagPrefix="TCDB" TagName="Menu" src="~/Includes/Header_Menu.ascx" %> <%@ Import Namespace="TCDB_Users" %> @@ -12,13 +12,13 @@ <% if (Request.IsAuthenticated) { %> <div id="MainMenu"> <div id="User"> - <TCDB:User runat="server" /> + <TCDB:User id=user runat="server" /> </div> <div id="CurrentInfo"> - <TCDB:CurrentInfo runat="server" /> + <TCDB:CurrentInfo id=currentInfo runat="server" /> </div> <div id="Menu"> - <TCDB:Menu runat="server" /> + <TCDB:Menu ID=menu runat="server" /> </div> </div> <% } %> Modified: Website/Includes/Header_Menu.ascx =================================================================== --- Website/Includes/Header_Menu.ascx 2006-07-10 17:12:54 UTC (rev 90) +++ Website/Includes/Header_Menu.ascx 2006-07-10 19:09:08 UTC (rev 91) @@ -1,2 +1,2 @@ <%@ Control Language="C#" AutoEventWireup="true" %> -Assignments | Execute | Management \ No newline at end of file +<a href="Assignments.aspx">Assignments</a> | Execute | Management \ No newline at end of file Modified: Website/TCDB.master =================================================================== --- Website/TCDB.master 2006-07-10 17:12:54 UTC (rev 90) +++ Website/TCDB.master 2006-07-10 19:09:08 UTC (rev 91) @@ -12,7 +12,7 @@ <div id="NonFooter"> <form id="Form1" runat="server"> <div id="HeaderContent"> - <TCDB:Header runat="server" /> + <TCDB:Header id=header runat="server" /> </div> <% if (Request.IsAuthenticated) { %> @@ -32,13 +32,13 @@ else {%> <div id="Login"> - <TCDB:Authenticate runat="server" /> + <TCDB:Authenticate id=authenticate runat="server" /> </div> <% } %> </form> </div> <div id="FooterContent"> - <TCDB:Footer runat="server" /> + <TCDB:Footer id=footer runat="server" /> </div> </body> </html> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
