public ActionResult AddNewProject() { BAL.Project prj = new Project(); prj.ProjectID = 0; prj.Name = Request.Form["ProjectName"]; prj.Client = BAL.Client.GetClient(Convert.ToInt32(Request.Form["ClientList"])); prj.ProjectLead = BAL.Person.GetPerson(Convert.ToInt32(Request.Form["ProjectLeadList"])); String department = Request.Form["DepartmentList"]; if (department == "A") prj.SogetiDepartment = SogetiDepartments.ADNT; else if (department == "T") prj.SogetiDepartment = SogetiDepartments.Test; else if (department == "S") prj.SogetiDepartment = SogetiDepartments.SAP; prj.Description = Request.Form["ProjectDescription"]; String terms = Request.Form["CommercialTermsList"]; if (terms == "F") prj.CommercialTermsAndConditions = CommercialTerms.Fixed_Price; else if (terms == "V") prj.CommercialTermsAndConditions = CommercialTerms.Time_And_Material; String frequency = Request.Form["ReviewFrequencyList"]; if (frequency == "D") prj.ReviewFrequency = Frequency.Daily; else if (frequency == "W") prj.ReviewFrequency = Frequency.Weekly; else if (frequency == "M") prj.ReviewFrequency = Frequency.Monthly; else if (frequency == "Q") prj.ReviewFrequency = Frequency.Quaterly; else if (frequency == "A") prj.ReviewFrequency = Frequency.Annually; prj.RevisedDate = Convert.ToDateTime(Request.Form["ProjectStartDate"]); prj.SogetiPractitioner = BAL.Person.GetPerson(Convert.ToInt32(Request.Form["SogetiPractitionerList"])); prj.AccountManager = BAL.Person.GetPerson(Convert.ToInt32(Request.Form["AccountManagerList"])); prj.DeliveryManager = BAL.Person.GetPerson(Convert.ToInt32(Request.Form["DeliveryManagerList"])); prj.Administrator = BAL.Person.GetPerson(Convert.ToInt32(Request.Form["AdministratorList"])); prj.StartDate = Convert.ToDateTime(Request.Form["ProjectStartDate"]); prj.EndDate = Convert.ToDateTime(Request.Form["ProjectEndDate"]); prj.InsertProject(); return RedirectToAction("Dashboard", "Home"); }
public static Project GetProjectWithStatusHistory(int projectID) { Project prj = null; using (DataSet prjDetails = DAL.Project.GetProjectDetails(projectID)) { if ((prjDetails != null) && (prjDetails.Tables.Count > 0)) { prj = new Project(Convert.ToInt32(prjDetails.Tables[0].Rows[0]["ProjectID"]), prjDetails.Tables[0].Rows[0]["Name"].ToString(), prjDetails.Tables[0].Rows[0]["Description"].ToString(), Person.GetPerson(Convert.ToInt32(prjDetails.Tables[0].Rows[0]["SogetiPractitioner_PersonID"])), Person.GetPerson(Convert.ToInt32(prjDetails.Tables[0].Rows[0]["AccountManager_PersonID"])), Person.GetPerson(Convert.ToInt32(prjDetails.Tables[0].Rows[0]["DeliveryManager_PersonID"])), Person.GetPerson(Convert.ToInt32(prjDetails.Tables[0].Rows[0]["Administrator_PersonID"])), Client.GetClient(Convert.ToInt32(prjDetails.Tables[0].Rows[0]["Client_ClientID"])), Convert.ToDateTime(prjDetails.Tables[0].Rows[0]["StartDate"].ToString()), Convert.ToDateTime(prjDetails.Tables[0].Rows[0]["EndDate"].ToString()), Convert.ToDateTime(prjDetails.Tables[0].Rows[0]["RevisedDate"].ToString()), Person.GetPerson(Convert.ToInt32(prjDetails.Tables[0].Rows[0]["Lead_PersonID"])), (CommercialTerms)Convert.ToChar(prjDetails.Tables[0].Rows[0]["CommercialTerms"]), (Frequency)Convert.ToChar(prjDetails.Tables[0].Rows[0]["ReviewFrequency"]), (SogetiDepartments)Convert.ToChar(prjDetails.Tables[0].Rows[0]["SogetiServiceLine"])); prj.ProjectStatusList = ProjectStatus.GetAllStatus(prj.ProjectID); } } return prj; }
public static List<Project> GetAllProjects(int clientID, int accountManager, int deliveryManager, int lead, char serviceLine, char commTerms, char reviewFrequency) { List<Project> prjList = new List<Project>(); Project prj; using (DataSet dsProjects = DAL.Project.GetAllProjects(clientID, accountManager, deliveryManager, lead, serviceLine, commTerms, reviewFrequency)) { if ((dsProjects != null) && (dsProjects.Tables.Count > 0)) { foreach (DataRow row in dsProjects.Tables[0].Rows) { prj = new Project(); prj = new Project(Convert.ToInt32(row["ProjectID"]), row["Name"].ToString(), row["Description"].ToString(), Person.GetPerson(Convert.ToInt32(row["SogetiPractitioner_PersonID"])), Person.GetPerson(Convert.ToInt32(row["AccountManager_PersonID"])), Person.GetPerson(Convert.ToInt32(row["DeliveryManager_PersonID"])), Person.GetPerson(Convert.ToInt32(row["Administrator_PersonID"])), Client.GetClient(Convert.ToInt32(row["Client_ClientID"])), Convert.ToDateTime(row["StartDate"].ToString()), Convert.ToDateTime(row["EndDate"].ToString()), Convert.ToDateTime(row["RevisedDate"].ToString()), Person.GetPerson(Convert.ToInt32(row["Lead_PersonID"])), (CommercialTerms)Convert.ToChar(row["CommercialTerms"]), (Frequency)Convert.ToChar(row["ReviewFrequency"]), (SogetiDepartments)Convert.ToChar(row["SogetiServiceLine"])); prj.ProjectStatusList = new List<ProjectStatus>(); prj.ProjectStatusList.Add(BAL.ProjectStatus.GetRecentProjectStatus(prj.ProjectID)); prjList.Add(prj); } } } return prjList; }
public void Add(Project project) { context.Project.Add(project); context.SaveChanges(); }