public async Task <IActionResult> Create([Bind("ScorecardActivityID,ActivityNo,SerialNo,ComponentID,ActivityName,Target,Achived,Responsibility,SectionID,StartDate,EndDate,Comments,BaselineStartDate,BaselineEndDate,Duration,Progress,Predecessor,ParentID,IsHead,Status,IsUpdated,meetingStatusList")] ScorecardActivity scorecardActivity) { if (ModelState.IsValid) { scorecardActivity.BaselineStartDate = scorecardActivity.StartDate; scorecardActivity.BaselineEndDate = scorecardActivity.EndDate; if (scorecardActivity.IsHead == false) { scorecardActivity.SerialNo = _context.ScorecardActivity.Where(a => a.ScorecardActivityID == scorecardActivity.ParentID).Select(a => a.SerialNo).FirstOrDefault().ToString() + ".0"; } _context.Add(scorecardActivity); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Create))); } ViewData["SectionID"] = new SelectList(_context.Section.Where(a => a.SectionID < 10), "SectionID", "Name", scorecardActivity.SectionID); ViewData["ComponentID"] = new SelectList(_context.Component.Where(a => a.ComponentID > 2).Select(a => new { ComponentName = a.ComponentCode + " - " + a.ComponentName, a.ComponentID }), "ComponentID", "ComponentName"); ViewData["Colors"] = new List <SelectListItem> { new SelectListItem { Text = "ON-TRACK", Value = "1" }, new SelectListItem { Text = "FALLING BEHIND", Value = "2" }, new SelectListItem { Text = "DELAY ALERT", Value = "3" }, new SelectListItem { Text = "COMPLETE", Value = "4" } }; return(View(scorecardActivity)); }
// GET: ScorecardActivities/Create public IActionResult Create() { ScorecardActivity scorecard = new ScorecardActivity(); scorecard.ParentNode = this.GetParentNode(); scorecard.StartDate = DateTime.Now.Date; scorecard.EndDate = DateTime.Now.Date; scorecard.IsHead = true; scorecard.Status = 1; scorecard.SectionID = 1; scorecard.IsUpdated = true; ViewData["SectionID"] = new SelectList(_context.Section.Where(a => a.SectionID < 10), "SectionID", "Name"); ViewData["ComponentID"] = new SelectList(_context.Component.Where(a => a.ComponentID > 2).Select(a => new { ComponentName = a.ComponentCode + " - " + a.ComponentName, a.ComponentID }), "ComponentID", "ComponentName"); ViewData["Colors"] = new List <SelectListItem> { new SelectListItem { Text = "ON-TRACK", Value = "1" }, new SelectListItem { Text = "FALLING BEHIND", Value = "2" }, new SelectListItem { Text = "DELAY ALERT", Value = "3" }, new SelectListItem { Text = "COMPLETE", Value = "4" } }; int ANo = _context.ScorecardActivity.Count(); scorecard.ActivityNo = (short)++ANo; return(View(scorecard)); }
public async Task <IActionResult> Edit(short id, [Bind("ScorecardActivityID,ActivityNo,SerialNo,ComponentID,ActivityName,Target,Achived,Responsibility,SectionID,StartDate,EndDate,Comments,BaselineStartDate,BaselineEndDate,Duration,Progress,Predecessor,ParentID,IsHead,Status,IsUpdated,meetingStatusList")] ScorecardActivity scorecardActivity) { if (id != scorecardActivity.ScorecardActivityID) { return(NotFound()); } if (ModelState.IsValid) { try { scorecardActivity.meetingStatusList = scorecardActivity.meetingStatusList + "," + scorecardActivity.Status.ToString(); scorecardActivity.IsUpdated = true; _context.Update(scorecardActivity); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ScorecardActivityExists(scorecardActivity.ScorecardActivityID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["SectionID"] = new SelectList(_context.Section.Where(a => a.SectionID < 10), "SectionID", "Name", scorecardActivity.SectionID); ViewData["ComponentID"] = new SelectList(_context.Component.Where(a => a.ComponentID > 2).Select(a => new { ComponentName = a.ComponentCode + " - " + a.ComponentName, a.ComponentID }), "ComponentID", "ComponentName", scorecardActivity.ComponentID); ViewData["Colors"] = new List <SelectListItem> { new SelectListItem { Text = "ON-TRACK", Value = "1" }, new SelectListItem { Text = "FALLING BEHIND", Value = "2" }, new SelectListItem { Text = "DELAY ALERT", Value = "3" }, new SelectListItem { Text = "COMPLETE", Value = "4" } }; return(View(scorecardActivity)); }