public DataObjects.Project LoadProject(int projectID) { Database.Generics genDB = new Generics(); DataObjects.Project prj = new DataObjects.Project(); SqlParameter param = new SqlParameter("@ProjectID", typeof(System.Int32)); param.Value = projectID; List<SqlParameter> paramList = new List<SqlParameter>(); paramList.Add(param); using (DataSet dsProjectDetails = genDB.GetDataFromDB("Select * From SelectProject(@ProjectID)", CommandType.Text, paramList)) { if ((dsProjectDetails != null) && (dsProjectDetails.Tables.Count > 0)) { DataRow row = dsProjectDetails.Tables[0].Rows[0]; prj.ProjectID = Convert.ToInt32(row["ProjectID"]); prj.Name = string.IsNullOrEmpty(row["ProjectName"].ToString()) ? " " : row["ProjectName"].ToString(); prj.Description = string.IsNullOrEmpty(row["ProjectDescription"].ToString()) ? " " : row["ProjectDescription"].ToString(); prj.StartDate = string.IsNullOrEmpty(row["ProjectStartDate"].ToString()) ? System.DateTime.MinValue : Convert.ToDateTime(row["ProjectStartDate"].ToString()); prj.EndDate = string.IsNullOrEmpty(row["ProjectEndDate"].ToString()) ? System.DateTime.MinValue : Convert.ToDateTime(row["ProjectEndDate"].ToString()); prj.RevisedDate = string.IsNullOrEmpty(row["ProjectRevisedDate"].ToString()) ? System.DateTime.MinValue : Convert.ToDateTime(row["ProjectRevisedDate"].ToString()); prj.Client = Database.Client.GetClient(Convert.ToInt32(row["ClientID"])); prj.Administrator = Database.Person.LoadUser(Convert.ToInt32(row["AdminID"])); prj.AccountManager = Database.Person.LoadUser(Convert.ToInt32(row["AccountManagerID"])); prj.DeliveryManager = Database.Person.LoadUser(Convert.ToInt32(row["DeliverManagerID"])); prj.SogetiPractitioner = Database.Person.LoadUser(Convert.ToInt32(row["SogetiPractitionerID"])); prj.ProjectStatus = Database.ProjectStatus.GetAllStatusOfProject(projectID); } } return prj; }
public List<DataObjects.Project> GetAllProjects() { Database.Generics gen = new Generics(); List<DataObjects.Project> prjList = new List<DataObjects.Project>(); DataObjects.Project prj; using (DataSet ds = gen.GetDataFromDB("SELECT * FROM SelectProjects()", CommandType.Text)) { if (ds.Tables.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { prj = new DataObjects.Project(); prj.ProjectID = Convert.ToInt32(row["ProjectID"]); prj.Name = row["ProjectName"].ToString(); prj.Description = string.IsNullOrEmpty(row["ProjectDescription"].ToString()) ? " " : row["ProjectDescription"].ToString(); prj.StartDate = string.IsNullOrEmpty(row["ProjectStartDate"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(row["ProjectStartDate"].ToString()); prj.EndDate = string.IsNullOrEmpty(row["ProjectEndDate"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(row["ProjectEndDate"].ToString()); prj.RevisedDate = string.IsNullOrEmpty(row["ProjectRevisedDate"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(row["ProjectRevisedDate"].ToString()); prj.Client = Database.Client.GetClient(Convert.ToInt32(row["ClientID"])); prj.Administrator = Database.Person.LoadUser(Convert.ToInt32(row["AdminID"])); prj.AccountManager = Database.Person.LoadUser(Convert.ToInt32(row["AccountManagerID"])); prj.DeliveryManager = Database.Person.LoadUser(Convert.ToInt32(row["DeliverManagerID"])); prj.SogetiPractitioner = Database.Person.LoadUser(Convert.ToInt32(row["SogetiPractitionerID"])); prjList.Add(prj); } } } return prjList; }