public async Task <IActionResult> Edit(int id, [Bind("Id,ReportStatusId,Month,FromDate,ToDate,WeeklyTimeReportId,WeeklyTimeReportId1,WeeklyTimeReportId2,WeeklyTimeReportId3,WeeklyTimeReportId4,TotalTimeWorked")] MonthlyTimeReport monthlyTimeReport) { if (id != monthlyTimeReport.Id) { return(NotFound()); } if (ModelState.IsValid) { try { // Sum of all worked hours during the Month ! var applicationDbContext = _context.MonthlyTimeReport .Include(m => m.ReportStatus) .Include(m => m.WTR1) .Include(m => m.WTR1.Emloyee) .Include(m => m.WTR2) .Include(m => m.WTR2.Emloyee) .Include(m => m.WTR3) .Include(m => m.WTR3.Emloyee) .Include(m => m.WTR4) .Include(m => m.WTR4.Emloyee) .Include(m => m.WTR5) .Include(m => m.WTR5.Emloyee); //monthlyTimeReport.TotalTimeWorked = // monthlyTimeReport.WTR1.WorkedHoursTotal // + monthlyTimeReport.WTR2.WorkedHoursTotal // + monthlyTimeReport.WTR3.WorkedHoursTotal // + monthlyTimeReport.WTR4.WorkedHoursTotal // + monthlyTimeReport.WTR5.WorkedHoursTotal; _context.Update(monthlyTimeReport); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MonthlyTimeReportExists(monthlyTimeReport.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(ListMonthlyTimeReports))); } ViewData["ReportStatusId"] = new SelectList(_context.ReportStatus, "ReportStatusName", "Id", monthlyTimeReport.ReportStatusId); ViewData["WeeklyTimeReportId"] = new SelectList(_context.WeeklyTimeReport, "Id", "WTRName", monthlyTimeReport.WeeklyTimeReportId); ViewData["WeeklyTimeReportId1"] = new SelectList(_context.WeeklyTimeReport, "Id", "WTRName", monthlyTimeReport.WeeklyTimeReportId1); ViewData["WeeklyTimeReportId2"] = new SelectList(_context.WeeklyTimeReport, "Id", "WTRName", monthlyTimeReport.WeeklyTimeReportId2); ViewData["WeeklyTimeReportId3"] = new SelectList(_context.WeeklyTimeReport, "Id", "WTRName", monthlyTimeReport.WeeklyTimeReportId3); ViewData["WeeklyTimeReportId4"] = new SelectList(_context.WeeklyTimeReport, "Id", "WTRName", monthlyTimeReport.WeeklyTimeReportId4); return(View(monthlyTimeReport)); }
public async Task <IActionResult> Create([Bind("Id,ReportStatusId,Month,FromDate,ToDate,WeeklyTimeReportId,WeeklyTimeReportId1,WeeklyTimeReportId2,WeeklyTimeReportId3,WeeklyTimeReportId4,TotalTimeWorked")] MonthlyTimeReport monthlyTimeReport) { if (ModelState.IsValid) { // Sum of all worked hours during the Month ! var applicationDbContext = _context.MonthlyTimeReport .Include(m => m.ReportStatus) .Include(m => m.WTR1) .Include(m => m.WTR1.Emloyee) .Include(m => m.WTR1.WorkedHoursTotal) .Include(m => m.WTR2) .Include(m => m.WTR2.Emloyee) .Include(m => m.WTR2.WorkedHoursTotal) .Include(m => m.WTR3) .Include(m => m.WTR3.Emloyee) .Include(m => m.WTR3.WorkedHoursTotal) .Include(m => m.WTR4) .Include(m => m.WTR4.Emloyee) .Include(m => m.WTR4.WorkedHoursTotal) .Include(m => m.WTR5) .Include(m => m.WTR5.Emloyee) .Include(m => m.WTR5.WorkedHoursTotal); //monthlyTimeReport.TotalTimeWorked = // monthlyTimeReport.WTR1.WorkedHoursTotal // + monthlyTimeReport.WTR2.WorkedHoursTotal // + monthlyTimeReport.WTR3.WorkedHoursTotal // + monthlyTimeReport.WTR4.WorkedHoursTotal // + monthlyTimeReport.WTR5.WorkedHoursTotal; _context.Add(monthlyTimeReport); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(ListMonthlyTimeReports))); } ViewData["ReportStatusId"] = new SelectList(_context.ReportStatus, "ReportStatusName", "Id", monthlyTimeReport.ReportStatusId); ViewData["WeeklyTimeReportId"] = new SelectList(_context.WeeklyTimeReport, "Id", "WTRName", monthlyTimeReport.WeeklyTimeReportId); ViewData["WeeklyTimeReportId1"] = new SelectList(_context.WeeklyTimeReport, "Id", "WTRName", monthlyTimeReport.WeeklyTimeReportId1); ViewData["WeeklyTimeReportId2"] = new SelectList(_context.WeeklyTimeReport, "Id", "WTRName", monthlyTimeReport.WeeklyTimeReportId2); ViewData["WeeklyTimeReportId3"] = new SelectList(_context.WeeklyTimeReport, "Id", "WTRName", monthlyTimeReport.WeeklyTimeReportId3); ViewData["WeeklyTimeReportId4"] = new SelectList(_context.WeeklyTimeReport, "Id", "WTRName", monthlyTimeReport.WeeklyTimeReportId4); return(View(monthlyTimeReport)); }
public IActionResult Index(MonthlyTimeReport montlyTimeReport) { // Sum of all worked hours during the Month ! var applicationDbContext = _context.MonthlyTimeReport .Include(m => m.ReportStatus) .Include(m => m.WTR1) .Include(m => m.WTR1.Emloyee) .Include(m => m.WTR2) .Include(m => m.WTR2.Emloyee) .Include(m => m.WTR3) .Include(m => m.WTR3.Emloyee) .Include(m => m.WTR4) .Include(m => m.WTR4.Emloyee) .Include(m => m.WTR5) .Include(m => m.WTR5.Emloyee); //montlyTimeReport.TotalTimeWorked = // montlyTimeReport.WTR1.WorkedHoursTotal // + montlyTimeReport.WTR2.WorkedHoursTotal // + montlyTimeReport.WTR3.WorkedHoursTotal // + montlyTimeReport.WTR4.WorkedHoursTotal // + montlyTimeReport.WTR5.WorkedHoursTotal; return(View(montlyTimeReport)); }