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();
}
