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