public async Task <IActionResult> Create([Bind("Id,ReportStatusId,WeekNumber,FromDate,ToDate,PersonId,Day1,Day1Started,Day1Ended,WorkedDay1,Day2,Day2Started,Day2Ended,WorkedDay2,Day3,Day3Started,Day3Ended,WorkedDay3,Day4,Day4Started,Day4Ended,WorkedDay4,Day5,Day5Started,Day5Ended,WorkedDay5,Day6,Day6Started,Day6Ended,WorkedDay6,Day7,Day7Started,Day7Ended,WorkedDay7,WorkedHoursTotal")] WeeklyTimeReport weeklyTimeReport) { if (ModelState.IsValid) { // Sum of all worked hours during the Week ! var applicationDbContext = _context.WeeklyTimeReport .Include(wtr => wtr.Emloyee) .Include(wtr => wtr.ReportStatus); weeklyTimeReport.WorkedHoursTotal = weeklyTimeReport.WorkedDay1 + weeklyTimeReport.WorkedDay2 + weeklyTimeReport.WorkedDay3 + weeklyTimeReport.WorkedDay4 + weeklyTimeReport.WorkedDay5 + weeklyTimeReport.WorkedDay6 + weeklyTimeReport.WorkedDay7; _context.Add(weeklyTimeReport); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(ListWeeklyTimeReports))); } ViewData["PersonId"] = new SelectList(_context.Person, "Id", "CName", weeklyTimeReport.PersonId); ViewData["ReportStatusId"] = new SelectList(_context.ReportStatus, "Id", "ReportStatusName", weeklyTimeReport.ReportStatusId); return(View(weeklyTimeReport)); }
public IActionResult Index(WeeklyTimeReport weeklyTimeReport) { // Sum of all worked hours during the Week ! var applicationDbContext = _context.WeeklyTimeReport .Include(wtr => wtr.Emloyee) .Include(wtr => wtr.ReportStatus); weeklyTimeReport.WorkedHoursTotal = weeklyTimeReport.WorkedDay1 + weeklyTimeReport.WorkedDay2 + weeklyTimeReport.WorkedDay3 + weeklyTimeReport.WorkedDay4 + weeklyTimeReport.WorkedDay5 + weeklyTimeReport.WorkedDay6 + weeklyTimeReport.WorkedDay7; return(View(weeklyTimeReport)); }
public async Task <IActionResult> Edit(int id, [Bind("Id,ReportStatusId,WeekNumber,FromDate,ToDate,PersonId,Day1,Day1Started,Day1Ended,WorkedDay1,Day2,Day2Started,Day2Ended,WorkedDay2,Day3,Day3Started,Day3Ended,WorkedDay3,Day4,Day4Started,Day4Ended,WorkedDay4,Day5,Day5Started,Day5Ended,WorkedDay5,Day6,Day6Started,Day6Ended,WorkedDay6,Day7,Day7Started,Day7Ended,WorkedDay7,WorkedHoursTotal")] WeeklyTimeReport weeklyTimeReport) { if (id != weeklyTimeReport.Id) { return(NotFound()); } if (ModelState.IsValid) { try { // Sum of all worked hours during the Week ! var applicationDbContext = _context.WeeklyTimeReport .Include(wtr => wtr.Emloyee) .Include(wtr => wtr.ReportStatus); weeklyTimeReport.WorkedHoursTotal = weeklyTimeReport.WorkedDay1 + weeklyTimeReport.WorkedDay2 + weeklyTimeReport.WorkedDay3 + weeklyTimeReport.WorkedDay4 + weeklyTimeReport.WorkedDay5 + weeklyTimeReport.WorkedDay6 + weeklyTimeReport.WorkedDay7; _context.Update(weeklyTimeReport); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!WeeklyTimeReportExists(weeklyTimeReport.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(ListWeeklyTimeReports))); } ViewData["PersonId"] = new SelectList(_context.Person, "Id", "CName", weeklyTimeReport.PersonId); ViewData["ReportStatusId"] = new SelectList(_context.ReportStatus, "Id", "ReportStatusName", weeklyTimeReport.ReportStatusId); return(View(weeklyTimeReport)); }