public JsonResult InsertEmployeLeaveHistory(EmployeeLeaveHistory LeaveStory) { int leaveHistories = db.EmployeeLeaveHistories.Count(); try { LeaveStory.Status = AppUtils.TableStatusIsActive; db.EmployeeLeaveHistories.Add(LeaveStory); db.SaveChanges(); EmployeeLeaveViewModel LeaveHistoryInfo = new EmployeeLeaveViewModel { ID = LeaveStory.EmployeeLeaveHistoryID, LoginName = db.Employee.Find(LeaveStory.EmployeeID).LoginName, Reason = LeaveStory.Reason, StartDate = LeaveStory.EndDate, EndDate = LeaveStory.EndDate, LeaveTypeName = db.LeaveSallaryTypes.Find(LeaveStory.LeaveType).LeaveTypeName, }; return(Json(new { SuccessInsert = true, LeaveHistoryInfo = LeaveHistoryInfo, leaveHistories = leaveHistories }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { SuccessInsert = false }, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateLeaveHistoryType(EmployeeLeaveHistory LeaveHistoryIformation) { try { var leaveHistory = db.EmployeeLeaveHistories.Where(s => s.EmployeeLeaveHistoryID == LeaveHistoryIformation.EmployeeLeaveHistoryID); LeaveHistoryIformation.Status = AppUtils.TableStatusIsActive; db.Entry(leaveHistory.SingleOrDefault()).CurrentValues.SetValues(LeaveHistoryIformation); db.SaveChanges(); var LeaveHistory = new EmployeeLeaveViewModel() { ID = LeaveHistoryIformation.EmployeeLeaveHistoryID, Reason = LeaveHistoryIformation.Reason, LeaveTypeName = db.LeaveSallaryTypes.Find(LeaveHistoryIformation.LeaveType).LeaveTypeName, StartDate = LeaveHistoryIformation.StartDate, EndDate = LeaveHistoryIformation.EndDate, LoginName = db.Employee.Find(LeaveHistoryIformation.EmployeeID).LoginName, }; var JSON = Json(new { UpdateSuccess = true, EMPLH = LeaveHistory }, JsonRequestBehavior.AllowGet); JSON.MaxJsonLength = int.MaxValue; return(JSON); } catch { return(Json(new { UpdateSuccess = false, EMPLH = "" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetAppliedLeaveList() { JsonResult result = null; try { LookUp employeeDepartment = LookUpCodeService.GetLookUp <LookUp>(s => s.LookUpCategory == "EmployeeDesignation" && s.LookUpCode == "Manager").FirstOrDefault(); EmployeeHeader employeeHeader = EmployeeProfileService.GetEmployeeProfileList <EmployeeHeader>(e => e.Id == USER_OBJECT.EmployeeId && e.EmployeeWorkDetail.FirstOrDefault().DesignationId == employeeDepartment.LookUpID).FirstOrDefault(); List <EmployeeLeaveList> employeeLeaveList = Leaveservice.GetLeaveList <EmployeeLeaveList>(e => e.ManagerId == employeeHeader.Id).OrderBy(o => o.EmployeeId).ToList(); List <EmployeeLeaveViewModel> employeeLeaveViewModelList = new List <EmployeeLeaveViewModel>(); foreach (EmployeeLeaveList employeeLeave in employeeLeaveList) { LookUp leaveType = LookUpCodeService.GetLookUpType(employeeLeave.LeaveTypeId); EmployeeLeaveViewModel employeeLeaveViewModel = new EmployeeLeaveViewModel(); employeeLeaveViewModel.Id = employeeLeave.Id; employeeLeaveViewModel.EmployeeName = employeeLeave.Employee.FirstName + " " + employeeLeave.Employee.LastName; employeeLeaveViewModel.EmployeeId = employeeLeave.Employee.Id; employeeLeaveViewModel.EmployeeNumber = employeeLeave.Employee.IDNumber; employeeLeaveViewModel.LeaveType = leaveType.LookUpCode; employeeLeaveViewModel.LeaveTypeId = leaveType.LookUpID; employeeLeaveViewModel.FromDate = employeeLeave.FromDate; employeeLeaveViewModel.Days = employeeLeave.Days; employeeLeaveViewModel.ToDate = employeeLeave.ToDate; employeeLeaveViewModel.ApplyDate = employeeLeave.ApplyDate; employeeLeaveViewModel.Status = employeeLeave.Status; employeeLeaveViewModel.Reason = employeeLeave.Reason; employeeLeaveViewModel.Remarks = employeeLeave.Remarks; employeeLeaveViewModel.BranchId = employeeLeave.BranchId; employeeLeaveViewModel.TeamLeadId = employeeLeave.ManagerId; employeeLeaveViewModelList.Add(employeeLeaveViewModel); } if (employeeLeaveViewModelList != null && employeeLeaveViewModelList.Any()) { result = Json(new { employeeLeaveList = employeeLeaveViewModelList, sucess = true }, JsonRequestBehavior.AllowGet); } else { result = Json(new { sucess = false, message = "No Data Found." }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message)) { return(Json(new { success = false, message = ex.InnerException.Message }, JsonRequestBehavior.DenyGet)); } } return(result); }