Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [92] Website
|
From: <m_h...@us...> - 2006-07-11 00:16:26
|
Revision: 92 Author: m_hildebrand Date: 2006-07-10 17:16:13 -0700 (Mon, 10 Jul 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=92&view=rev Log Message: ----------- Cleaned up AssignmentsTree and worked on some backend code. Started work on notes. Modified Paths: -------------- Website/App_Code/AD_Authentication.cs Website/App_Code/TCDB_Products.cs Website/App_Code/TCDB_Users.cs Website/App_Code/dadDataSet.xsd Website/App_Code/dadDataSet.xss Website/Assignments.aspx Website/Includes/AssignmentsTree.ascx Website/Includes/Authenticate.ascx Website/Includes/Header.ascx Website/Includes/Header_User.ascx Website/TCDB.master Website/web.config Added Paths: ----------- Website/App_Code/TCDB_Assignments.cs Website/App_Code/TCDB_Common.cs Website/App_Code/TCDB_Notes.cs Website/App_Code/TCDB_Statuses.cs Removed Paths: ------------- Website/App_Code/TCDB_Constants.cs Modified: Website/App_Code/AD_Authentication.cs =================================================================== --- Website/App_Code/AD_Authentication.cs 2006-07-10 19:09:08 UTC (rev 91) +++ Website/App_Code/AD_Authentication.cs 2006-07-11 00:16:13 UTC (rev 92) @@ -9,6 +9,7 @@ using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using TCDB_Users; +using TCDB_Common; namespace AD_Auth { @@ -63,7 +64,7 @@ ds.SearchScope = SearchScope.Subtree; ds.Filter = "(&(objectClass=user)(sAMAccountName=" + UserName[1] + "))"; - user.USERID = TCDB_Constants.TCDB_Constant.USER_NEWUSER; + user.ID = TCDB_Constant.USER_NEWUSER; user.AUTOMATION = false; user.ISAUTHENTICATED = true; user.USERNAME = UserName[1]; Added: Website/App_Code/TCDB_Assignments.cs =================================================================== --- Website/App_Code/TCDB_Assignments.cs (rev 0) +++ Website/App_Code/TCDB_Assignments.cs 2006-07-11 00:16:13 UTC (rev 92) @@ -0,0 +1,354 @@ +using System; +using System.Data; +using System.Collections.Generic; +using System.Configuration; +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; +using TCDB_Statuses; +using TCDB_Common; +using TCDB_Users; + +namespace TCDB_Assignments +{ + /// <summary> + /// Summary description for TCDB_Assignments + /// </summary> + public class TCDB_AssignmentDB : Page + { + public static List<TCDB_Assignment> TCDB_GetAssignmentList(string aType, int finished, int assignedID, string highPriority) + { + dadDataSet ds = new dadDataSet(); + dadDataSetTableAdapters.db_assignmentsTableAdapter ta = new dadDataSetTableAdapters.db_assignmentsTableAdapter(); + // TODO: figure out the high priority stuff! + ta.GetData(aType, finished, assignedID, null); + ta.Fill(ds.db_assignments, aType, finished, assignedID, null); + + List<TCDB_Assignment> assignmentList = new List<TCDB_Assignment>(); + + DataTableReader dr = ds.db_assignments.CreateDataReader(); + if (dr.HasRows) + { + while (dr.Read()) + { + TCDB_Assignment assignment = new TCDB_Assignment(); + + string type = TCDB_Help.TCDB_DB_StringParse(dr["aType"], TCDB_Constant.ASSIGNMENT_DEFAULTTYPE); + if (type == TCDB_Constant.ASSIGNMENT_TYPE_ACTIONITEM) + { + assignment.ACTIONITEM = TCDB_ActionItemDB.TCDB_GetActionItem(TCDB_Help.TCDB_DB_IntParse(dr["childID"], TCDB_Constant.ACTIONITEM_DEFAULTID)); + assignment.WOTOTALTEST = 0; + assignment.WOPASSRATE = 0; + assignment.WOPASS = 0; + assignment.WOFAIL = 0; + assignment.WOERROR = 0; + } + else if (type == TCDB_Constant.ASSIGNMENT_TYPE_WORKORDER) + { + assignment.WORKORDER = TCDB_WorkOrderDB.TCDB_GetWorkOrder(TCDB_Help.TCDB_DB_IntParse(dr["childID"], TCDB_Constant.WORKORDER_DEFAULTID)); + assignment.WOTOTALTEST = TCDB_Help.TCDB_DB_IntParse(dr["WOTotalTest"], 0); + assignment.WOPASSRATE = TCDB_Help.TCDB_DB_IntParse(dr["WOPassRate"], 0); + assignment.WOPASS = TCDB_Help.TCDB_DB_IntParse(dr["WOPass"], 0); + assignment.WOFAIL = TCDB_Help.TCDB_DB_IntParse(dr["WOFail"], 0); + assignment.WOERROR = TCDB_Help.TCDB_DB_IntParse(dr["WOError"], 0); + } + + assignment.CREATOR = TCDB_Help.TCDB_DB_StringParse(dr["creator"], ""); + assignment.ASSIGNED = TCDB_Help.TCDB_DB_StringParse(dr["assigned"], ""); + assignment.DATEASSIGNED = TCDB_Help.TCDB_DB_DateTimeParse(dr["dateAssigned"], TCDB_Constant.ASSIGNMENT_DEFAULTDATEASSIGNED); + assignment.DUEDATE = TCDB_Help.TCDB_DB_DateTimeParse(dr["dueDate"], TCDB_Constant.ASSIGNMENT_DEFAULTDUEDATE); + assignment.DATEFINISHED = TCDB_Help.TCDB_DB_DateTimeParse(dr["dateFinished"], TCDB_Constant.ASSIGNMENT_DEFAULTDATEFINISHED); + assignment.HIGHPRIORITY = TCDB_Help.TCDB_DB_BoolParse(dr["highPriority"], TCDB_Constant.ASSIGNMENT_DEFAULTHIGHPRIORITY); + assignment.STATUSNAME = TCDB_Help.TCDB_DB_StringParse(dr["statusName"], ""); + + assignmentList.Add(assignment); + } + } + + return assignmentList; + } + } + + public class TCDB_ActionItemDB : Page + { + public static TCDB_ActionItem TCDB_GetActionItem(int id) + { + dadDataSet ds = new dadDataSet(); + dadDataSetTableAdapters.db_actionItemsTableAdapter ta = new dadDataSetTableAdapters.db_actionItemsTableAdapter(); + ta.GetData(id); + ta.Fill(ds.db_actionItems, id); + + TCDB_ActionItem ai = new TCDB_ActionItem(); + + DataTableReader dr = ds.db_users.CreateDataReader(); + if (dr.HasRows && dr.Read()) + { + ai.ID = TCDB_Help.TCDB_DB_IntParse(dr["actionItemID"], TCDB_Constant.ACTIONITEM_DEFAULTID); + ai.NAME = TCDB_Help.TCDB_DB_StringParse(dr["name"], TCDB_Constant.ACTIONITEM_DEFAULTNAME); + ai.DESCRIPTION = TCDB_Help.TCDB_DB_StringParse(dr["description"], TCDB_Constant.ACTIONITEM_DEFAULTDESCRIPTION); + ai.CREATORID = TCDB_Help.TCDB_DB_IntParse(dr["creatorID"], TCDB_Constant.ACTIONITEM_DEFAULTCREATORID); + ai.PERCENTCOMPLETE = TCDB_Help.TCDB_DB_IntParse(dr["percentComplete"], TCDB_Constant.ACTIONITEM_DEFAULTPERCENTCOMPLETE); + } + + return ai; + } + } + + public class TCDB_WorkOrderDB : Page + { + public static TCDB_WorkOrder TCDB_GetWorkOrder(int id) + { + /* + dadDataSet ds = new dadDataSet(); + dadDataSetTableAdapters.db_actionItemsTableAdapter ta = new dadDataSetTableAdapters.db_actionItemsTableAdapter(); + ta.GetData(id); + ta.Fill(ds.db_actionItems, id); + + TCDB_ActionItem ai = new TCDB_ActionItem(); + + DataTableReader dr = ds.db_users.CreateDataReader(); + if (dr.HasRows && dr.Read()) + { + ai.ID = TCDB_Help.TCDB_DB_IntParse(dr["actionItemID"], TCDB_Constant.ACTIONITEM_DEFAULTID); + ai.NAME = TCDB_Help.TCDB_DB_StringParse(dr["name"], TCDB_Constant.ACTIONITEM_DEFAULTNAME); + ai.DESCRIPTION = TCDB_Help.TCDB_DB_StringParse(dr["description"], TCDB_Constant.ACTIONITEM_DEFAULTDESCRIPTION); + ai.CREATORID = TCDB_Help.TCDB_DB_IntParse(dr["creatorID"], TCDB_Constant.ACTIONITEM_DEFAULTCREATORID); + ai.PERCENTCOMPLETE = TCDB_Help.TCDB_DB_IntParse(dr["percentComplete"], TCDB_Constant.ACTIONITEM_DEFAULTPERCENTCOMPLETE); + } + + return ai; + * */ + return new TCDB_WorkOrder(); + } + } + + public class TCDB_Assignment + { + private int p_id; + private string p_name; + private string p_creator; + private string p_assigned; + private DateTime p_dateAssigned; + private DateTime p_dateFinished; + private DateTime p_dueDate; + private TCDB_WorkOrder p_workOrder; + private TCDB_ActionItem p_actionItem; + private bool p_highPriority; + private string p_statusName; + private int p_woTotalTest; + private int p_woPassRate; + private int p_woPass; + private int p_woFail; + private int p_woError; + + public TCDB_Assignment() + { + p_id = 0; + p_name = ""; + p_creator = ""; + p_assigned = ""; + p_dateAssigned = TCDB_Constant.ASSIGNMENT_DEFAULTDATEASSIGNED; + p_dateFinished = TCDB_Constant.ASSIGNMENT_DEFAULTDATEFINISHED; + p_dueDate = TCDB_Constant.ASSIGNMENT_DEFAULTDUEDATE; + p_workOrder = null; + p_actionItem = null; + p_highPriority = false; + p_statusName = ""; + p_woTotalTest = 0; + p_woPassRate = 0; + p_woPass = 0; + p_woFail = 0; + p_woError = 0; + } + + public int ID + { + get { return p_id; } + set { p_id = value; } + } + + public string NAME + { + get { return p_name; } + set { p_name = value; } + } + + public string CREATOR + { + get { return p_creator; } + set { p_creator = value; } + } + + public string ASSIGNED + { + get { return p_assigned; } + set { p_assigned = value; } + } + + public DateTime DATEASSIGNED + { + get { return p_dateAssigned; } + set { p_dateAssigned = value; } + } + + public DateTime DATEFINISHED + { + get { return p_dateFinished; } + set { p_dateFinished = value; } + } + + public DateTime DUEDATE + { + get { return p_dueDate; } + set { p_dueDate = value; } + } + + public TCDB_WorkOrder WORKORDER + { + get { return p_workOrder; } + set { p_workOrder = value; } + } + + public TCDB_ActionItem ACTIONITEM + { + get { return p_actionItem; } + set { p_actionItem = value; } + } + + public bool HIGHPRIORITY + { + get { return p_highPriority; } + set { p_highPriority = value; } + } + + public string STATUSNAME + { + get { return p_statusName; } + set { p_statusName = value; } + } + + public bool ISWORKORDER + { + get { + if (p_workOrder == null) + return false; + else + return true; + } + } + + public bool ISACTIONITEM + { + get + { + if (p_actionItem == null) + return false; + else + return true; + } + } + + public int WOTOTALTEST + { + get { return p_woTotalTest; } + set { p_woTotalTest = value; } + } + + public int WOPASSRATE + { + get { return p_woPassRate; } + set { p_woPassRate = value; } + } + + public int WOPASS + { + get { return p_woPass; } + set { p_woPass = value; } + } + + public int WOFAIL + { + get { return p_woFail; } + set { p_woFail = value; } + } + + public int WOERROR + { + get { return p_woError; } + set { p_woError = value; } + } + + } + + public class TCDB_ActionItem + { + private int p_id; + private string p_name; + private string p_description; + private int p_creatorID; + private int p_percentComplete; + + public TCDB_ActionItem() + { + p_id = 0; + p_name = ""; + p_description = ""; + p_creatorID = 0; + p_percentComplete = 0; + } + + public TCDB_ActionItem(int id, string name, string description, int creatorID, int percentComplete) + { + p_id = id; + p_name = name; + p_description = description; + p_creatorID = creatorID; + p_percentComplete = percentComplete; + } + + public int ID + { + get { return p_id; } + set { p_id = value; } + } + + public string NAME + { + get { return p_name; } + set { p_name = value; } + } + + public string DESCRIPTION + { + get { return p_description; } + set { p_description = value; } + } + + public int CREATORID + { + get { return p_creatorID; } + set { p_creatorID = value; } + } + + public int PERCENTCOMPLETE + { + get { return p_percentComplete; } + set { p_percentComplete = value; } + } + + public override string ToString() + { + return NAME; + } + } + + public class TCDB_WorkOrder + { + public TCDB_WorkOrder() + { + } + } +} \ No newline at end of file Copied: Website/App_Code/TCDB_Common.cs (from rev 89, Website/App_Code/TCDB_Constants.cs) =================================================================== --- Website/App_Code/TCDB_Common.cs (rev 0) +++ Website/App_Code/TCDB_Common.cs 2006-07-11 00:16:13 UTC (rev 92) @@ -0,0 +1,142 @@ +using System; +using System.Data; +using System.Configuration; +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; +using TCDB_Users; + +namespace TCDB_Common +{ + /// <summary> + /// Summary description for TCDB_Constant + /// </summary> + public static class TCDB_Constant + { + // TODO: Load the values from the DB where appropriate + public static int USER_FAILEDLOGIN = -2; + public static int USER_NOTREGISTERED = -1; + public static int USER_NEWUSER = -1; + + public static int USER_ANONYMOUSUSERID = 0; + public static string USER_ANONYMOUSUSERNAME = "Guest"; + public static string USER_ANONYMOUSFIRSTNAME = "Guest"; + public static string USER_ANONYMOUSLASTNAME = "User"; + public static string USER_ANONYMOUSEMAIL = ""; + public static string USER_ANONYMOUSOFFICEPHONE = ""; + public static string USER_ANONYMOUSHOMEPHONE = ""; + public static string USER_ANONYMOUSCELLPHONE = ""; + public static bool USER_ANONYMOUSAUTOMATION = false; + + public static int ACTIONITEM_DEFAULTID = 0; + public static string ACTIONITEM_DEFAULTNAME = ""; + public static string ACTIONITEM_DEFAULTDESCRIPTION = ""; + public static int ACTIONITEM_DEFAULTCREATORID = USER_ANONYMOUSUSERID; + public static int ACTIONITEM_DEFAULTPERCENTCOMPLETE = 0; + + public static int PRODUCT_DEFAULTID = 0; + public static string PRODUCT_DEFAULTNAME = ""; + public static string PRODUCT_DEFAULTDESCRIPTION = ""; + public static string PRODUCT_DEFAULTCODENAME = ""; + public static int PRODUCT_DEFAULTDEVMANAGERID = USER_ANONYMOUSUSERID; + public static int PRODUCT_DEFAULTQAMANAGERID = USER_ANONYMOUSUSERID; + public static int PRODUCT_DEFAULTDEVLEADID = USER_ANONYMOUSUSERID; + public static int PRODUCT_DEFAULTQALEADID = USER_ANONYMOUSUSERID; + public static int PRODUCT_DEFAULTPMID = USER_ANONYMOUSUSERID; + public static bool PRODUCT_DEFAULTACTIVE = false; + + public static int STATUS_DEFAULTID = 0; + public static string STATUS_DEFAULTGROUP = ""; + public static string STATUS_DEFAULTNAME = ""; + public static string STATUS_DEFAULTDESCRIPTION = ""; + + public static int NOTE_DEFAULTID = 0; + public static DateTime NOTE_DEFAULTDATE = new DateTime(1, 1, 1); + public static string NOTE_DEFAULTNOTEFIELD = ""; + public static int NOTE_DEFAULTAUTHOR = USER_ANONYMOUSUSERID; + + public static string ASSIGNMENT_TYPE_WORKORDER = "WO"; + public static string ASSIGNMENT_TYPE_ACTIONITEM = "AI"; + public static string ASSIGNMENT_TYPE_BOTH = null; + public static string ASSIGNMENT_DEFAULTTYPE = ""; + // TODO: figure this one out + //public static bool ASSIGNMENT_PRIORITY_ALL = null; + public static bool ASSIGNMENT_PRIORITY_HIGH = true; + public static bool ASSIGNMENT_PRIORITY_NORMAL = false; + public static int ASSIGNMENT_FINISHEDANDUNFINISHED = 0; + public static int ASSIGNMENT_FINISHED = 1; + public static int ASSIGNMENT_UNFINISHED = 2; + + public static int ASSIGNMENT_DEFAULTCREATOR = USER_ANONYMOUSUSERID; + public static int ASSIGNMENT_DEFAULTASSIGNEDID = USER_ANONYMOUSUSERID; + public static DateTime ASSIGNMENT_DEFAULTDATEASSIGNED = NOTE_DEFAULTDATE; + public static DateTime ASSIGNMENT_DEFAULTDUEDATE = NOTE_DEFAULTDATE; + public static DateTime ASSIGNMENT_DEFAULTDATEFINISHED = NOTE_DEFAULTDATE; + public static bool ASSIGNMENT_DEFAULTHIGHPRIORITY = false; + + public static int WORKORDER_DEFAULTID = 0; + } + + public static class TCDB_Help + { + + public static int TCDB_DB_IntParse(object value, int defaultValue) + { + int result = defaultValue; + try + { + result = int.Parse(value.ToString()); + } + catch + { + result = defaultValue; + } + return result; + } + + public static string TCDB_DB_StringParse(object value, string defaultValue) + { + string result = defaultValue; + try + { + result = value.ToString(); + } + catch + { + result = defaultValue; + } + return result; + } + + public static bool TCDB_DB_BoolParse(object value, bool defaultValue) + { + bool result = defaultValue; + try + { + result = (bool)value; + } + catch + { + result = defaultValue; + } + return result; + } + + public static DateTime TCDB_DB_DateTimeParse(object value, DateTime defaultValue) + { + DateTime result = defaultValue; + try + { + result = new DateTime(long.Parse(value.ToString())); + } + catch + { + result = defaultValue; + } + return result; + } + } +} \ No newline at end of file Deleted: Website/App_Code/TCDB_Constants.cs =================================================================== --- Website/App_Code/TCDB_Constants.cs 2006-07-10 19:09:08 UTC (rev 91) +++ Website/App_Code/TCDB_Constants.cs 2006-07-11 00:16:13 UTC (rev 92) @@ -1,29 +0,0 @@ -using System; -using System.Data; -using System.Configuration; -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; - -namespace TCDB_Constants -{ - /// <summary> - /// Summary description for TCDB_Constant - /// </summary> - public static class TCDB_Constant - { - // TODO: Load the strings from the DB where appropriate - public static int USER_FAILEDLOGIN = -2; - public static int USER_NOTREGISTERED = -1; - public static int USER_NEWUSER = -1; - public static int USER_ANONYMOUSUSERID = 0; - public static string USER_ANONYMOUSUSERNAME = "Guest"; - public static string USER_ANONYMOUSFIRSTNAME = "Guest"; - public static string USER_ANONYMOUSLASTNAME = "User"; - - public static string ACTION_NEWUSER = "nu"; - } -} \ No newline at end of file Added: Website/App_Code/TCDB_Notes.cs =================================================================== --- Website/App_Code/TCDB_Notes.cs (rev 0) +++ Website/App_Code/TCDB_Notes.cs 2006-07-11 00:16:13 UTC (rev 92) @@ -0,0 +1,97 @@ +using System; +using System.Data; +using System.Configuration; +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; +using TCDB_Users; +using TCDB_Common; + +namespace TCDB_Notes +{ + /// <summary> + /// Summary description for TCDB_Notes + /// </summary> + public class TCDB_NoteDB : Page + { + public static TCDB_Note TCDB_GetNote(int id) + { + dadDataSet ds = new dadDataSet(); + dadDataSetTableAdapters.db_notesTableAdapter ta = new dadDataSetTableAdapters.db_notesTableAdapter(); + ta.GetData(null, id); + ta.Fill(ds.db_notes, null, id); + + TCDB_Note note = null; + + DataTableReader dr = ds.CreateDataReader(); + if (dr.HasRows && dr.Read()) + { + int noteid = TCDB_Help.TCDB_DB_IntParse(dr["noteID"], TCDB_Constant.NOTE_DEFAULTID); + DateTime dateCreated = TCDB_Help.TCDB_DB_DateTimeParse(dr["dateCreated"], TCDB_Constant.NOTE_DEFAULTDATE); + string noteField = TCDB_Help.TCDB_DB_StringParse(dr["noteField"], TCDB_Constant.NOTE_DEFAULTNOTEFIELD); + int noteAuthor = TCDB_Help.TCDB_DB_IntParse(dr["noteAuthor"], TCDB_Constant.NOTE_DEFAULTAUTHOR); + + note = new TCDB_Note(noteid, dateCreated, noteField, noteAuthor); + } + + return note; + } + + } + + public class TCDB_Note + { + private int p_id; + private DateTime p_dateCreated; + private string p_noteField; + private TCDB_User p_noteAuthor; + + public TCDB_Note(int id, DateTime dateCreated, string noteField, TCDB_User noteAuthor) + { + p_id = id; + p_dateCreated = dateCreated; + p_noteField = noteField; + p_noteAuthor = noteAuthor; + } + + public TCDB_Note(int id, DateTime dateCreated, string noteField, int noteAuthor) + { + p_id = id; + p_dateCreated = dateCreated; + p_noteField = noteField; + p_noteAuthor = TCDB_UserDB.TCDB_GetUserInfo(noteAuthor); + } + + public TCDB_Note() + { + p_id = TCDB_Constant.NOTE_DEFAULTID; + p_dateCreated = TCDB_Constant.NOTE_DEFAULTDATE; + p_noteField = TCDB_Constant.NOTE_DEFAULTNOTEFIELD; + p_noteAuthor = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Constant.NOTE_DEFAULTAUTHOR); + } + + public int ID + { + get { return p_id; } + } + + public DateTime DATECREATED + { + get { return p_dateCreated; } + } + + public string NOTEFIELD + { + get { return p_noteField; } + set { p_noteField = value; } + } + + public TCDB_User NOTEAUTHOR + { + get { return p_noteAuthor; } + } + } +} \ No newline at end of file Modified: Website/App_Code/TCDB_Products.cs =================================================================== --- Website/App_Code/TCDB_Products.cs 2006-07-10 19:09:08 UTC (rev 91) +++ Website/App_Code/TCDB_Products.cs 2006-07-11 00:16:13 UTC (rev 92) @@ -9,6 +9,7 @@ using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using TCDB_Users; +using TCDB_Common; namespace TCDB_Products { @@ -29,16 +30,18 @@ DataTableReader dr = ds.CreateDataReader(); if (dr.HasRows && dr.Read()) { - product.PRODUCTID = int.Parse(dr["productID"].ToString()); - product.NAME = dr["name"].ToString(); - product.DESCRIPTION = dr["description"].ToString(); - product.CODENAME = dr["codeName"].ToString(); - product.DEVMANAGER = TCDB_UserDB.TCDB_GetUserInfo(int.Parse(dr["devManager"].ToString())); - product.QAMANAGER = TCDB_UserDB.TCDB_GetUserInfo(int.Parse(dr["qaManager"].ToString())); - product.DEVLEAD = TCDB_UserDB.TCDB_GetUserInfo(int.Parse(dr["devLead"].ToString())); - product.QALEAD = TCDB_UserDB.TCDB_GetUserInfo(int.Parse(dr["qaLead"].ToString())); - product.PM = TCDB_UserDB.TCDB_GetUserInfo(int.Parse(dr["pm"].ToString())); - product.ACTIVE = (bool)(dr["active"]); + int id = TCDB_Help.TCDB_DB_IntParse(dr["productID"], TCDB_Constant.PRODUCT_DEFAULTID); + string name = TCDB_Help.TCDB_DB_StringParse(dr["name"], TCDB_Constant.PRODUCT_DEFAULTNAME); + string description = TCDB_Help.TCDB_DB_StringParse(dr["description"], TCDB_Constant.PRODUCT_DEFAULTDESCRIPTION); + string codeName = TCDB_Help.TCDB_DB_StringParse(dr["codeName"], TCDB_Constant.PRODUCT_DEFAULTCODENAME); + TCDB_User devManager = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Help.TCDB_DB_IntParse(dr["devManager"], TCDB_Constant.PRODUCT_DEFAULTDEVMANAGERID)); + TCDB_User qaManager = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Help.TCDB_DB_IntParse(dr["qaManager"], TCDB_Constant.PRODUCT_DEFAULTQAMANAGERID)); + TCDB_User devLead = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Help.TCDB_DB_IntParse(dr["devLead"], TCDB_Constant.PRODUCT_DEFAULTDEVLEADID)); + TCDB_User qaLead = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Help.TCDB_DB_IntParse(dr["qaLead"], TCDB_Constant.PRODUCT_DEFAULTQALEADID)); + TCDB_User pm = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Help.TCDB_DB_IntParse(dr["pm"], TCDB_Constant.PRODUCT_DEFAULTPMID)); + bool active = TCDB_Help.TCDB_DB_BoolParse(dr["active"], TCDB_Constant.PRODUCT_DEFAULTACTIVE); + + product = new TCDB_Product(id, name, description, codeName, devManager, qaManager, devLead, qaLead, pm, active); } return product; @@ -53,22 +56,35 @@ List<TCDB_Product> productList = new List<TCDB_Product>(); - DataTableReader dr = ds.CreateDataReader(); + DataTableReader dr = ds.db_products.CreateDataReader(); if (dr.HasRows) { + int id = TCDB_Constant.PRODUCT_DEFAULTID; + string name = TCDB_Constant.PRODUCT_DEFAULTNAME; + string description = TCDB_Constant.PRODUCT_DEFAULTDESCRIPTION; + string codeName = TCDB_Constant.PRODUCT_DEFAULTCODENAME; + TCDB_User devManager = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Constant.PRODUCT_DEFAULTDEVMANAGERID); + TCDB_User qaManager = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Constant.PRODUCT_DEFAULTQAMANAGERID); + TCDB_User devLead = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Constant.PRODUCT_DEFAULTDEVLEADID); + TCDB_User qaLead = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Constant.PRODUCT_DEFAULTQALEADID); + TCDB_User pm = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Constant.PRODUCT_DEFAULTPMID); + bool active = TCDB_Constant.PRODUCT_DEFAULTACTIVE; + while (dr.Read()) { TCDB_Product product = new TCDB_Product(); - product.PRODUCTID = int.Parse(dr["productID"].ToString()); - product.NAME = dr["name"].ToString(); - product.DESCRIPTION = dr["description"].ToString(); - product.CODENAME = dr["codeName"].ToString(); - product.DEVMANAGER = TCDB_UserDB.TCDB_GetUserInfo(int.Parse(dr["devManager"].ToString())); - product.QAMANAGER = TCDB_UserDB.TCDB_GetUserInfo(int.Parse(dr["qaManager"].ToString())); - product.DEVLEAD = TCDB_UserDB.TCDB_GetUserInfo(int.Parse(dr["devLead"].ToString())); - product.QALEAD = TCDB_UserDB.TCDB_GetUserInfo(int.Parse(dr["qaLead"].ToString())); - product.PM = TCDB_UserDB.TCDB_GetUserInfo(int.Parse(dr["pm"].ToString())); - product.ACTIVE = (bool)(dr["active"]); + id = TCDB_Help.TCDB_DB_IntParse(dr["productID"], TCDB_Constant.PRODUCT_DEFAULTID); + name = TCDB_Help.TCDB_DB_StringParse(dr["name"], TCDB_Constant.PRODUCT_DEFAULTNAME); + description = TCDB_Help.TCDB_DB_StringParse(dr["description"], TCDB_Constant.PRODUCT_DEFAULTDESCRIPTION); + codeName = TCDB_Help.TCDB_DB_StringParse(dr["codeName"], TCDB_Constant.PRODUCT_DEFAULTCODENAME); + devManager = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Help.TCDB_DB_IntParse(dr["devManager"], TCDB_Constant.PRODUCT_DEFAULTDEVMANAGERID)); + qaManager = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Help.TCDB_DB_IntParse(dr["qaManager"], TCDB_Constant.PRODUCT_DEFAULTQAMANAGERID)); + devLead = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Help.TCDB_DB_IntParse(dr["devLead"], TCDB_Constant.PRODUCT_DEFAULTDEVLEADID)); + qaLead = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Help.TCDB_DB_IntParse(dr["qaLead"], TCDB_Constant.PRODUCT_DEFAULTQALEADID)); + pm = TCDB_UserDB.TCDB_GetUserInfo(TCDB_Help.TCDB_DB_IntParse(dr["pm"], TCDB_Constant.PRODUCT_DEFAULTPMID)); + active = TCDB_Help.TCDB_DB_BoolParse(dr["active"], TCDB_Constant.PRODUCT_DEFAULTACTIVE); + + product = new TCDB_Product(id, name, description, codeName, devManager, qaManager, devLead, qaLead, pm, active); productList.Add(product); } } @@ -79,95 +95,111 @@ public class TCDB_Product { - private int productid; - private string name; - private string description; - private string codeName; - private TCDB_User devManager; - private TCDB_User qaManager; - private TCDB_User devLead; - private TCDB_User qaLead; - private TCDB_User pm; - private bool active; + private int p_productid; + private string p_name; + private string p_description; + private string p_codeName; + private TCDB_User p_devManager; + private TCDB_User p_qaManager; + private TCDB_User p_devLead; + private TCDB_User p_qaLead; + private TCDB_User p_pm; + private bool p_active; // TODO: Implement these as the time is right //private List<TCDB_Tag> tags; public TCDB_Product() { - productid = 0; - name = null; - description = null; - codeName = null; - devManager = null; - qaManager = null; - devLead = null; - qaLead = null; - pm = null; - active = false; + p_productid = 0; + p_name = null; + p_description = null; + p_codeName = null; + p_devManager = null; + p_qaManager = null; + p_devLead = null; + p_qaLead = null; + p_pm = null; + p_active = false; } - - public TCDB_Product(int id) + + public TCDB_Product(int id, string name, string description, string codeName, TCDB_User devManager, + TCDB_User qaManager, TCDB_User devLead, TCDB_User qaLead, TCDB_User pm, bool active) { + p_productid = id; + p_name = name; + p_description = description; + p_codeName = codeName; + p_devManager = devManager; + p_qaManager = qaManager; + p_devLead = devLead; + p_qaLead = qaLead; + p_pm = pm; + p_active = active; } - public int PRODUCTID + public int ID { - get { return productid; } - set { productid = value; } + get { return p_productid; } + set { p_productid = value; } } public string NAME { - get { return name; } - set { name = value; } + get { return p_name; } + set { p_name = value; } } public string DESCRIPTION { - get { return description; } - set { description = value; } + get { return p_description; } + set { p_description = value; } } public string CODENAME { - get { return codeName; } - set { codeName = value; } + get { return p_codeName; } + set { p_codeName = value; } } public TCDB_User DEVMANAGER { - get { return devManager; } - set { devManager = value; } + get { return p_devManager; } + set { p_devManager = value; } } public TCDB_User QAMANAGER { - get { return qaManager; } - set { qaManager = value; } + get { return p_qaManager; } + set { p_qaManager = value; } } public TCDB_User DEVLEAD { - get { return devLead; } - set { devLead = value; } + get { return p_devLead; } + set { p_devLead = value; } } public TCDB_User QALEAD { - get { return qaLead; } - set { qaLead = value; } + get { return p_qaLead; } + set { p_qaLead = value; } } public TCDB_User PM { - get { return pm; } - set { pm = value; } + get { return p_pm; } + set { p_pm = value; } } public bool ACTIVE { - get { return active; } - set { active = value; } + get { return p_active; } + set { p_active = value; } } + + public override string ToString() + { + return NAME; + } } } \ No newline at end of file Added: Website/App_Code/TCDB_Statuses.cs =================================================================== --- Website/App_Code/TCDB_Statuses.cs (rev 0) +++ Website/App_Code/TCDB_Statuses.cs 2006-07-11 00:16:13 UTC (rev 92) @@ -0,0 +1,92 @@ +using System; +using System.Data; +using System.Configuration; +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; +using TCDB_Common; + +namespace TCDB_Statuses +{ + public class TCDB_StatusDB : Page + { + public static TCDB_Status GetStatus(string statusGroup, string statusName, int id) + { + // TODO: Load a status type from the DB + // TODO: Check against the DB for user information + dadDataSet ds = new dadDataSet(); + dadDataSetTableAdapters.db_statusTableAdapter ta = new dadDataSetTableAdapters.db_statusTableAdapter(); + ta.GetData(statusGroup, statusName, id); + ta.Fill(ds.db_status, statusGroup, statusName, id); + + TCDB_Status status = new TCDB_Status(); + + DataTableReader dr = ds.db_status.CreateDataReader(); + if (dr.HasRows && dr.Read()) + { + status.ID = TCDB_Help.TCDB_DB_IntParse(dr["statusID"], TCDB_Constant.STATUS_DEFAULTID); + status.GROUP = TCDB_Help.TCDB_DB_StringParse(dr["statusGroup"], TCDB_Constant.STATUS_DEFAULTGROUP); + status.NAME = TCDB_Help.TCDB_DB_StringParse(dr["statusName"], TCDB_Constant.STATUS_DEFAULTNAME); + status.DESCRIPTION = TCDB_Help.TCDB_DB_StringParse(dr["description"], TCDB_Constant.STATUS_DEFAULTDESCRIPTION); + } + + return status; + } + } + + public class TCDB_Status + { + private int p_id; + private string p_group; + private string p_name; + private string p_description; + + public TCDB_Status() + { + p_id = 0; + p_group = null; + p_name = null; + p_description = null; + } + + public TCDB_Status(int id, string group, string name, string description) + { + p_id = id; + p_group = group; + p_name = name; + p_description = description; + } + + public int ID + { + get { return p_id; } + set { p_id = value; } + } + + public string GROUP + { + get { return p_group; } + set { p_group = value; } + } + + public string NAME + { + get { return p_name; } + set { p_name = value; } + } + + public string DESCRIPTION + { + get { return p_description; } + set { p_description = value; } + } + + public override string ToString() + { + return NAME; + } + } +} \ No newline at end of file Modified: Website/App_Code/TCDB_Users.cs =================================================================== --- Website/App_Code/TCDB_Users.cs 2006-07-10 19:09:08 UTC (rev 91) +++ Website/App_Code/TCDB_Users.cs 2006-07-11 00:16:13 UTC (rev 92) @@ -11,13 +11,15 @@ using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Security; -using TCDB_Constants; using System.Collections; using System.Collections.Generic; using System.Collections.Specialized; +using TCDB_Assignments; +using TCDB_Common; using AD_Auth; + namespace TCDB_Users { /// <summary> @@ -58,7 +60,7 @@ // Determine if the user exists in the DB or not. If not, we need to get // the basic info TCDB_User user = TCDB_GetUserInfo(cleanUserName); - if (user.USERID > 1) + if (user.ID > 1) { user.ISAUTHENTICATED = true; return user; @@ -82,15 +84,15 @@ DataTableReader dr = ds.CreateDataReader(); if (dr.HasRows && dr.Read()) { - user.USERID = int.Parse(dr["userID"].ToString()); - user.USERNAME = dr["username"].ToString(); - user.FIRSTNAME = dr["firstName"].ToString(); - user.LASTNAME = dr["lastName"].ToString(); - user.EMAIL = dr["email"].ToString(); - user.OFFICEPHONE = dr["officePhone"].ToString(); - user.HOMEPHONE = dr["homePhone"].ToString(); - user.CELLPHONE = dr["cellPhone"].ToString(); - user.AUTOMATION = (bool)(dr["automation"]); + user.ID = TCDB_Help.TCDB_DB_IntParse(dr["userID"], TCDB_Constant.USER_ANONYMOUSUSERID); + user.USERNAME = TCDB_Help.TCDB_DB_StringParse(dr["username"], TCDB_Constant.USER_ANONYMOUSUSERNAME); + user.FIRSTNAME = TCDB_Help.TCDB_DB_StringParse(dr["firstName"], TCDB_Constant.USER_ANONYMOUSFIRSTNAME); + user.LASTNAME = TCDB_Help.TCDB_DB_StringParse(dr["lastName"], TCDB_Constant.USER_ANONYMOUSLASTNAME); + user.EMAIL = TCDB_Help.TCDB_DB_StringParse(dr["email"], TCDB_Constant.USER_ANONYMOUSEMAIL); + user.OFFICEPHONE = TCDB_Help.TCDB_DB_StringParse(dr["officePhone"], TCDB_Constant.USER_ANONYMOUSOFFICEPHONE); + user.HOMEPHONE = TCDB_Help.TCDB_DB_StringParse(dr["homePhone"], TCDB_Constant.USER_ANONYMOUSHOMEPHONE); + user.CELLPHONE = TCDB_Help.TCDB_DB_StringParse(dr["cellPhone"], TCDB_Constant.USER_ANONYMOUSCELLPHONE); + user.AUTOMATION = TCDB_Help.TCDB_DB_BoolParse(dr["automation"], TCDB_Constant.USER_ANONYMOUSAUTOMATION); } return user; @@ -106,22 +108,75 @@ TCDB_User user = new TCDB_User(); - DataTableReader dr = ds.CreateDataReader(); + DataTableReader dr = ds.db_users.CreateDataReader(); if (dr.HasRows && dr.Read()) { - user.USERID = int.Parse(dr["userID"].ToString()); - user.USERNAME = dr["username"].ToString(); - user.FIRSTNAME = dr["firstName"].ToString(); - user.LASTNAME = dr["lastName"].ToString(); - user.EMAIL = dr["email"].ToString(); - user.OFFICEPHONE = dr["officePhone"].ToString(); - user.HOMEPHONE = dr["homePhone"].ToString(); - user.CELLPHONE = dr["cellPhone"].ToString(); - user.AUTOMATION = (bool)(dr["automation"]); + user.ID = TCDB_Help.TCDB_DB_IntParse(dr["userID"], TCDB_Constant.USER_ANONYMOUSUSERID); + user.USERNAME = TCDB_Help.TCDB_DB_StringParse(dr["username"], TCDB_Constant.USER_ANONYMOUSUSERNAME); + user.FIRSTNAME = TCDB_Help.TCDB_DB_StringParse(dr["firstName"], TCDB_Constant.USER_ANONYMOUSFIRSTNAME); + user.LASTNAME = TCDB_Help.TCDB_DB_StringParse(dr["lastName"], TCDB_Constant.USER_ANONYMOUSLASTNAME); + user.EMAIL = TCDB_Help.TCDB_DB_StringParse(dr["email"], TCDB_Constant.USER_ANONYMOUSEMAIL); + user.OFFICEPHONE = TCDB_Help.TCDB_DB_StringParse(dr["officePhone"], TCDB_Constant.USER_ANONYMOUSOFFICEPHONE); + user.HOMEPHONE = TCDB_Help.TCDB_DB_StringParse(dr["homePhone"], TCDB_Constant.USER_ANONYMOUSHOMEPHONE); + user.CELLPHONE = TCDB_Help.TCDB_DB_StringParse(dr["cellPhone"], TCDB_Constant.USER_ANONYMOUSCELLPHONE); + user.AUTOMATION = TCDB_Help.TCDB_DB_BoolParse(dr["automation"], TCDB_Constant.USER_ANONYMOUSAUTOMATION); } return user; } + + public static List<TCDB_User> TCDB_GetUserList() + { + // TODO: Check against the DB for user information + dadDataSet ds = new dadDataSet(); + dadDataSetTableAdapters.db_usersTableAdapter ta = new dadDataSetTableAdapters.db_usersTableAdapter(); + ta.GetData(null, null); + ta.Fill(ds.db_users, null, null); + + List<TCDB_User> userList = new List<TCDB_User>(); + + DataTableReader dr = ds.db_users.CreateDataReader(); + if (dr.HasRows) + { + while (dr.Read()) + { + TCDB_User user = new TCDB_User(); + + user.ID = TCDB_Help.TCDB_DB_IntParse(dr["userID"], TCDB_Constant.USER_ANONYMOUSUSERID); + user.USERNAME = TCDB_Help.TCDB_DB_StringParse(dr["username"], TCDB_Constant.USER_ANONYMOUSUSERNAME); + user.FIRSTNAME = TCDB_Help.TCDB_DB_StringParse(dr["firstName"], TCDB_Constant.USER_ANONYMOUSFIRSTNAME); + user.LASTNAME = TCDB_Help.TCDB_DB_StringParse(dr["lastName"], TCDB_Constant.USER_ANONYMOUSLASTNAME); + user.EMAIL = TCDB_Help.TCDB_DB_StringParse(dr["email"], TCDB_Constant.USER_ANONYMOUSEMAIL); + user.OFFICEPHONE = TCDB_Help.TCDB_DB_StringParse(dr["officePhone"], TCDB_Constant.USER_ANONYMOUSOFFICEPHONE); + user.HOMEPHONE = TCDB_Help.TCDB_DB_StringParse(dr["homePhone"], TCDB_Constant.USER_ANONYMOUSHOMEPHONE); + user.CELLPHONE = TCDB_Help.TCDB_DB_StringParse(dr["cellPhone"], TCDB_Constant.USER_ANONYMOUSCELLPHONE); + user.AUTOMATION = TCDB_Help.TCDB_DB_BoolParse(dr["automation"], TCDB_Constant.USER_ANONYMOUSAUTOMATION); + + userList.Add(user); + } + } + + return userList; + } + + public static bool TCDB_SaveUser(TCDB_User user) + { + dadDataSet ds = new dadDataSet(); + dadDataSetTableAdapters.db_usersTableAdapter ta = new dadDataSetTableAdapters.db_usersTableAdapter(); + try + { + ta.Insert(user.USERNAME, user.FIRSTNAME, user.LASTNAME, user.EMAIL, user.OFFICEPHONE, user.HOMEPHONE, user.CELLPHONE, user.AUTOMATION); + } + catch + { + return false; + } + + if (ds.db_users.HasErrors) + return false; + + return true; + } } @@ -143,20 +198,31 @@ private bool isAuthenticated; private List<TCDB_Right> rights; private List<TCDB_Config> config; + private List<TCDB_Assignment> assignments; /* TODO: Implement these as the time is right private List<TCDB_Feature> features; private List<TCDB_Assignment> assignmentsCreated; - private List<TCDB_Assignment> assignments; private List<TCDB_Objective> objectives; private List<TCDB_WorkOrderTemplate> savedWorkOrders; private List<TCDB_TestCase> testCasesCreated; private List<TCDB_TestCase> testCasesEdited; */ - /// <summary> - /// Default constructor, returns an anonymous user - /// TODO: Make this information come from the database rather than being hard coded here - /// </summary> + public List<TCDB_Assignment> ASSIGNMENTS + { + // TODO: This list needs to be able to reflect filters! + get + { + List<TCDB_Assignment> assignments = new List<TCDB_Assignment>(); + if (assignments == null) + { + assignments = TCDB_AssignmentDB.TCDB_GetAssignmentList(TCDB_Constant.ASSIGNMENT_TYPE_BOTH, + TCDB_Constant.ASSIGNMENT_FINISHEDANDUNFINISHED, ID, null); + } + return assignments; + } + } + public TCDB_User() { userid = TCDB_Constant.USER_ANONYMOUSUSERID; @@ -171,28 +237,38 @@ isAuthenticated = false; rights = null; config = null; + assignments = null; } - /// <summary> - /// Load a specific user based on username - /// </summary> - /// <param name="username"></param> public TCDB_User(string username) { - // TODO: Write this function + TCDB_BuildUser(TCDB_UserDB.TCDB_GetUserInfo(username)); } - /// <summary> - /// Load a specific user based on id - /// </summary> - /// <param name="id"></param> public TCDB_User(int id) { - // TODO: Write this function + TCDB_BuildUser(TCDB_UserDB.TCDB_GetUserInfo(id)); } - public int USERID + private void TCDB_BuildUser(TCDB_User user) { + userid = user.ID; + username = user.USERNAME; + email = user.EMAIL; + officePhone = user.OFFICEPHONE; + homePhone = user.HOMEPHONE; + cellPhone = user.CELLPHONE; + firstName = user.FIRSTNAME; + lastName = user.LASTNAME; + automation = user.AUTOMATION; + isAuthenticated = user.ISAUTHENTICATED; + rights = user.rights; + config = user.config; + assignments = null; + } + + public int ID + { get { return userid; } set { userid = value; } } Modified: Website/App_Code/dadDataSet.xsd =================================================================== --- Website/App_Code/dadDataSet.xsd 2006-07-10 19:09:08 UTC (rev 91) +++ Website/App_Code/dadDataSet.xsd 2006-07-11 00:16:13 UTC (rev 92) @@ -2,10 +2,12 @@ <xs:schema id="dadDataSet" targetNamespace="http://tempuri.org/dadDataSet.xsd" xmlns:mstns="http://tempuri.org/dadDataSet.xsd" xmlns="http://tempuri.org/dadDataSet.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" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> + <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <Connections> <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="dadConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="dadConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.dadConnectionString.ConnectionString" Provider="System.Data.SqlClient"> </Connection> + <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="tcdbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="tcdbConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.tcdbConnectionString.ConnectionString" Provider="System.Data.SqlClient"> + </Connection> </Connections> <Tables> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="db_usersTableAdapter" GeneratorDataComponentClassName="db_usersTableAdapter" Name="db_users" UserDataComponentName="db_usersTableAdapter"> @@ -182,6 +184,156 @@ <Sources> </Sources> </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="db_actionItemsTableAdapter" GeneratorDataComponentClassName="db_actionItemsTableAdapter" Name="db_actionItems" UserDataComponentName="db_actionItemsTableAdapter"> + <MainSource> + <DbSource ConnectionRef="dadConnectionString (Web.config)" DbObjectName="tcdb.dbo.sel_actionItems" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill"> + <InsertCommand> + <DbCommand CommandType="StoredProcedure" ModifiedByUser="False"> + <CommandText>dbo.ins_actionItem</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="name" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" 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="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@creatorID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@assignedID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateDue" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="dateDue" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@testPassID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@highPriority" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumn="highPriority" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </InsertCommand> + <SelectCommand> + <DbCommand CommandType="StoredProcedure" ModifiedByUser="False"> + <CommandText>dbo.sel_actionItems</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@actionItemID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="actionItemID" DataSetColumn="actionItemID" /> + <Mapping SourceColumn="name" DataSetColumn="name" /> + <Mapping SourceColumn="description" DataSetColumn="description" /> + <Mapping SourceColumn="dateAssigned" DataSetColumn="dateAssigned" /> + <Mapping SourceColumn="dateDue" DataSetColumn="dateDue" /> + <Mapping SourceColumn="percentComplete" DataSetColumn="percentComplete" /> + <Mapping SourceColumn="statusName" DataSetColumn="statusName" /> + <Mapping SourceColumn="createdBy" DataSetColumn="createdBy" /> + <Mapping SourceColumn="highPriority" DataSetColumn="highPriority" /> + <Mapping SourceColumn="createdById" DataSetColumn="createdById" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="db_statusTableAdapter" GeneratorDataComponentClassName="db_statusTableAdapter" Name="db_status" UserDataComponentName="db_statusTableAdapter"> + <MainSource> + <DbSource ConnectionRef="dadConnectionString (Web.config)" DbObjectName="tcdb.dbo.sel_status" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill"> + <SelectCommand> + <DbCommand CommandType="StoredProcedure" ModifiedByUser="False"> + <CommandText>dbo.sel_status</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@statusGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@statusName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@statusID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="statusID" DataSetColumn="statusID" /> + <Mapping SourceColumn="Description" DataSetColumn="Description" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="db_notesTableAdapter" GeneratorDataComponentClassName="db_notesTableAdapter" Name="db_notes" UserDataComponentName="db_notesTableAdapter"> + <MainSource> + <DbSource ConnectionRef="tcdbConnectionString (Web.config)" DbObjectName="tcdb.dbo.sel_notes" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill"> + <SelectCommand> + <DbCommand CommandType="StoredProcedure" ModifiedByUser="False"> + <CommandText>dbo.sel_notes</CommandText> + <Parameters> + <Parameter AllowDbNull="True" AutogeneratedName="" Data... [truncated message content] |
