// GET: ProjectCharter/Create
public ActionResult Create(int id)
{
Project_Charter project_Charter = new Project_Charter();
project_Charter.TQMID = id;
ViewBag.MethodologyID = new SelectList(db.TQM_Methodology, "AutoID", "MethodologyDescription");
ViewBag.FinanceName = new SelectList(db.TQM_Officials.Where(x => x.RoleID == 1), "EmpName", "EmpName");
ViewBag.EmployeeName = new SelectList(eleave.v_eLeave_EmployeeDetails, "empFullName", "empFullName");
ViewBag.ChampionSelection = new SelectList(eleave.v_eLeave_EmployeeDetails, "empFullName", "empFullName");
return(View(project_Charter));
}
public ActionResult Create([Bind(Include = "TQMID,Business_Case,Opportunity,Risk_Assessment,Goal,Scope,MethodologyID,CurrentStep")] Project_Charter project_Charter)
{
ViewBag.MethodologyID = new SelectList(db.TQM_Methodology, "AutoID", "MethodologyDescription");
ViewBag.FinanceName = new SelectList(db.TQM_Officials.Where(x => x.RoleID == 1), "EmpName", "EmpName");
ViewBag.EmployeeName = new SelectList(eleave.v_eLeave_EmployeeDetails, "empFullName", "empFullName");
ViewBag.ChampionSelection = new SelectList(eleave.v_eLeave_EmployeeDetails, "empFullName", "empFullName");
System.Diagnostics.Debug.WriteLine(Request.Form["FinanceName"]);
project_Charter.Risk_Assessment = Request.Form["riskAssessment"];
project_Charter.MethodologyID = Int32.Parse(Request.Form["projectMethod"]);
if (ModelState.IsValid)
{
string[] stepList = Request.Form.GetValues("stepNo");
string[] dateStartList = Request.Form.GetValues("dateStart");
string[] dateEndList = Request.Form.GetValues("dateEnd");
int i = 0;
foreach (var row in stepList)
{
var step = stepList[i];
var sDate = dateStartList[i];
var eDate = dateEndList[i];
TQM_Project_Plan project_plan = new TQM_Project_Plan();
project_plan.TQMID = Int32.Parse(Request.Form["TQMID"]);
project_plan.MethodologyStepID = Int32.Parse(step);
project_plan.PlanStart = Convert.ToDateTime(sDate);
project_plan.PlanEnd = Convert.ToDateTime(eDate);
db.TQM_Project_Plan.Add(project_plan);
i++;
}
db.Project_Charter.Add(project_Charter);
string[] memberName = Request.Form.GetValues("memberName");
string[] memberID = Request.Form.GetValues("memberID");
string[] memberEmail = Request.Form.GetValues("memberEmail");
int x = 0;
foreach (var row in stepList)
{
var mName = memberName[x];
var mID = memberID[x];
var mEmail = memberEmail[x];
TQM_Member tqm_member = new TQM_Member();
tqm_member.TQMID = Int32.Parse(Request.Form["TQMID"]);
tqm_member.EmpName = mName;
tqm_member.EmpNo = Int32.Parse(mID);
tqm_member.Email = mEmail;
tqm_member.RoleID = 7;
db.TQM_Member.Add(tqm_member);
x++;
}
string sponsorDropOptVal = Request.Form["sponsorDropOpt"];
if (sponsorDropOptVal == "1")
{
sponsorName = Request.Form["sponsorEmpNameDrop"];
}
else
{
sponsorName = Request.Form["sponsorEmpName"];
}
TQM_Member tqm_member_sponsor = new TQM_Member();
tqm_member_sponsor.TQMID = Int32.Parse(Request.Form["TQMID"]);
tqm_member_sponsor.EmpName = sponsorName;
tqm_member_sponsor.EmpNo = Int32.Parse(Request.Form["sponsorEmpID"]);
tqm_member_sponsor.Email = Request.Form["sponsorEmail"];
tqm_member_sponsor.RoleID = 2;
db.TQM_Member.Add(tqm_member_sponsor);
TQM_Member tqm_member_champion = new TQM_Member();
tqm_member_champion.TQMID = Int32.Parse(Request.Form["TQMID"]);
tqm_member_champion.EmpName = Request.Form["ChampionSelection"];
tqm_member_champion.EmpNo = Int32.Parse(Request.Form["championEmpID"]);
tqm_member_champion.Email = Request.Form["championEmail"];
tqm_member_champion.RoleID = 4;
db.TQM_Member.Add(tqm_member_champion);
TQM_Member tqm_member_finance = new TQM_Member();
tqm_member_finance.TQMID = Int32.Parse(Request.Form["TQMID"]);
tqm_member_finance.EmpName = Request.Form["FinanceEmail"];
tqm_member_finance.EmpNo = Int32.Parse(Request.Form["financeEmpID"]);
tqm_member_finance.Email = Request.Form["financeEmail"];
tqm_member_finance.RoleID = 1;
db.TQM_Member.Add(tqm_member_finance);
TQM_Member tqm_member_leader = new TQM_Member();
tqm_member_leader.TQMID = Int32.Parse(Request.Form["TQMID"]);
tqm_member_leader.EmpName = Request.Form["leaderName"];
tqm_member_leader.EmpNo = Int32.Parse(Request.Form["leaderEmpID"]);
tqm_member_leader.Email = Request.Form["leaderEmail"];
tqm_member_leader.RoleID = 6;
db.TQM_Member.Add(tqm_member_leader);
TQM_Details tqm_details_edit = db.TQM_Details.Find(Int32.Parse(Request.Form["TQMID"]));
tqm_details_edit.Status = "4";
db.Entry(tqm_details_edit).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(project_Charter));
}
public ActionResult Amendment(int?id)
{
Project_Charter project_Charter = db.Project_Charter.Find(id);
return(View(project_Charter));
}
