public JsonResult SubmitLeave(int id, short val, string remarks, int emplyeeID) { LeaveRequest Obj = _context.LeaveRequest.Find(id); if (IsSpervisor) { Obj.ApprovedBySection = val; Obj.ApprovedBySectionDate = DateTime.Now.Date; Obj.SupervisorRemarks = remarks; } if (IsHRAdmin) { Obj.ApprovedByHR = val; Obj.ApprovedByHRDate = DateTime.Now.Date; Obj.HRRemarks = remarks; } if (IsPD) { Obj.ApprovedByPD = val; Obj.ApprovedByPDDate = DateTime.Now.Date; Obj.PDRemarks = remarks; EmpLeaveSummary leaveSummaryObj = _context.EmpLeaveSummary.Where(a => a.EmployeeID == emplyeeID && a.LeaveTypeID == id).FirstOrDefault(); leaveSummaryObj.Pending = 0; if (val == 2) { leaveSummaryObj.Availed = leaveSummaryObj.Availed - Obj.TotalDays; } _context.Update(leaveSummaryObj); _context.SaveChanges(); } _context.Update(Obj); _context.SaveChanges(); return(Json("Success")); }
public async Task <IActionResult> Create([Bind("EmpLeaveSummaryID,Total,Availed,Pending,EmployeeID,LeaveTypeID")] EmpLeaveSummary empLeaveSummary) { if (ModelState.IsValid) { empLeaveSummary.Pending = 0; _context.Add(empLeaveSummary); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["EmployeeID"] = new SelectList(_context.Employee, "EmployeeID", "EmployeeID", empLeaveSummary.EmployeeID); ViewData["LeaveTypeID"] = new SelectList(_context.Set <LeaveType>(), "LeaveTypeID", "LeaveTypeID", empLeaveSummary.LeaveTypeID); return(View(empLeaveSummary)); }