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