public async Task <IActionResult> Edit(int id, [Bind("ID,Department,Hours,Cost,Submitter,SubmissionDate")] LabourReport labourReport)
{
if (id != labourReport.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(labourReport);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LabourReportExists(labourReport.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(labourReport));
}
public IActionResult LabourReport(LabourReport labourReport)
{
var lab = _context.LabourExpenses.Include(o => o.ExpenseType).Include(o => o.Labour).ThenInclude(o => o.EmployeeCategory).Include("Site");
if (Request.Form["SiteId"] != "")
{
int s = Convert.ToInt32(Request.Form["SiteId"]);
PopulateSiteDropDownList(s);
lab = _context.LabourExpenses.Include(o => o.ExpenseType).Include(o => o.Labour).ThenInclude(o => o.EmployeeCategory).Include("Site").Where(o => o.SiteId == s);
}
else
{
PopulateSiteDropDownList();
}
if (Request.Form["LabourId"] != "")
{
int l = Convert.ToInt32(Request.Form["LabourId"]);
PopulateLabourDropDownList(l);
lab = lab.Where(o => o.LabourId == l);
}
else
{
PopulateLabourDropDownList();
}
PopulateCategoryDropDownList();
return(View(lab));
}
public IActionResult SiteSummary(LabourReport labourReport)
{
IEnumerable <LabourReport> LabSum = _context.labours
.Include(p => p.MaterilaExpenses).ThenInclude(o => o.Site)
.Include(p => p.LabourExpenses).ThenInclude(o => o.Site)
.Select(p => new LabourReport()
{
labour = p,
materialExpense = p.MaterilaExpenses,
labourExpense = p.LabourExpenses
}
).ToList();
if (Request.Form["SiteId"] != "")
{
int siteId = Convert.ToInt32(Request.Form["SiteId"]);
LabSum = _context.labours
.Include(p => p.MaterilaExpenses).ThenInclude(o => o.Site)
.Include(p => p.LabourExpenses).ThenInclude(o => o.Site)
.Select(p => new LabourReport()
{
labour = p,
materialExpense = p.MaterilaExpenses.Where(s => s.SiteId == siteId),
labourExpense = p.LabourExpenses.Where(s => s.SiteId == siteId)
}
).ToList();
PopulateSiteDropDownList(siteId);
}
else
{
PopulateSiteDropDownList();
}
return(View(LabSum));
}
public async Task <IActionResult> Edit(int id, [Bind("ID,Department,Hours,TaskName,TaskDescription,Submitter,SubmissionDate,ProjectID")] LabourReport labourReport)
{
if (id != labourReport.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(labourReport);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LabourReportExists(labourReport.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ProjectID"] = new SelectList(_context.Projects, "ID", "Name", labourReport.ProjectID);
return(View(labourReport));
}
public async Task <IActionResult> Create([Bind("ID,Department,Hours,Cost,Submitter,SubmissionDate")] LabourReport labourReport)
{
if (ModelState.IsValid)
{
_context.Add(labourReport);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(labourReport));
}
public async Task <IActionResult> Create([Bind("ID,Department,Hours,TaskName,TaskDescription,Submitter,SubmissionDate,ProjectID")] LabourReport labourReport)
{
if (ModelState.IsValid)
{
_context.Add(labourReport);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ProjectID"] = new SelectList(_context.Projects, "ID", "Name", labourReport.ProjectID);
return(View(labourReport));
}
