public JsonResult GetLeaveStatus() { JsonResult result = null; try { EmployeeLeaveDetails employeeLeaveDetails = new EmployeeLeaveDetails(); employeeLeaveDetails.AppliedStatusCount = Leaveservice.GetLeaveList <EmployeeLeaveList>(s => s.Status == "Applied" && s.BranchId == USER_OBJECT.BranchId && s.EmployeeId == USER_OBJECT.EmployeeId).Count(); var GrantedLeavesList = Leaveservice.GetLeaveList <EmployeeLeaveList> (s => s.EmployeeId == USER_OBJECT.EmployeeId && s.BranchId == USER_OBJECT.BranchId) .GroupBy(g => g.LeaveTypeId).ToList().Select(s => new { count = s.Count(), name = LookUpCodeService.GetLookUpType(s.Key).LookUpCode }); employeeLeaveDetails.GrantedLeaves = Leaveservice.GetLeaveList <EmployeeLeaveList>(s => s.Status == "Grant" && s.BranchId == USER_OBJECT.BranchId && s.EmployeeId == USER_OBJECT.EmployeeId).Count(); List <LeaveHeader> LeaveHeaders = GrantLeaveService.GetAll <LeaveHeader>(l => l.BranchID == USER_OBJECT.BranchId).ToList(); var TotalLeaves = LeaveHeaders.Select(l => l.LeaveDetail.Sum(s => s.TotalLeaves)).Count(); employeeLeaveDetails.RemaingStatusCount = Math.Abs(employeeLeaveDetails.GrantedLeaves - TotalLeaves); result = Json(new { employeeLeaveDetails = employeeLeaveDetails, GrantedLeavesList = GrantedLeavesList }, 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); }
public JsonResult SaveGrantLeaves(LeaveHeader LeaveHeader) { JsonResult jsonResult = new JsonResult(); if (LeaveHeader != null) { LeaveHeader _LeaveHeader = null; if (LeaveHeader.Id > 0) { _LeaveHeader = GrantLeaveService.Get(LeaveHeader.Id); _LeaveHeader.ModifiedOn = Core.Utilities.DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); _LeaveHeader.ModifiedBy = USER_OBJECT.UserName; } else { _LeaveHeader = new LeaveHeader(); _LeaveHeader.CreatedBy = USER_OBJECT.UserName; _LeaveHeader.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); _LeaveHeader.BranchID = LeaveHeader.BranchID; } _LeaveHeader.LeaveYear = LeaveHeader.LeaveYear; string leaveYear = LeaveHeader.LeaveYear > 0 ? LookUpCodeService.GetLookUpType(LeaveHeader.LeaveYear).LookUpCode : ""; _LeaveHeader.PeriodicityType = LeaveHeader.PeriodicityType; _LeaveHeader.PeriodType = LeaveHeader.PeriodType; _LeaveHeader.StartDate = (LeaveHeader.PeriodType != 0 && LeaveHeader.PeriodType == 1108) ? DateTimeConverter.SingaporeDateTimeConversion(LeaveHeader.StartDate = new DateTime(Convert.ToInt32(leaveYear), 1, 01)) : DateTimeConverter.SingaporeDateTimeConversion(LeaveHeader.StartDate = new DateTime(Convert.ToInt32(leaveYear), 07, 01)); if (LeaveHeader.EndDate != null) { _LeaveHeader.EndDate = (LeaveHeader.PeriodType != 0 && LeaveHeader.PeriodType == 1108) ? DateTimeConverter.SingaporeDateTimeConversion(LeaveHeader.EndDate = new DateTime(Convert.ToInt32(leaveYear), 06, 01)) : DateTimeConverter.SingaporeDateTimeConversion(LeaveHeader.StartDate = new DateTime(Convert.ToInt32(leaveYear), 12, 01)); } Prepareleavedetails(LeaveHeader, _LeaveHeader); _LeaveHeader.LeaveSchemeType = LeaveHeader.LeaveSchemeType; GrantLeaveService.Save(_LeaveHeader); } return(jsonResult = Json(new { sucess = true, message = C.SUCCESSFUL_SAVE_MESSAGE }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetGrantLeave(int Id) { JsonResult result = null; try { if (Id > 0) { LeaveHeader leaveHeader = GrantLeaveService.Get(Id); result = Json(new { sucess = true, leaveHeader = leaveHeader }, 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); }
public JsonResult GetGrantLeaves() { JsonResult result = null; try { List <LeaveHeader> leaveHeaders = GrantLeaveService.GetAll <LeaveHeader>().ToList(); List <LeaveHeaderViewModel> LeaveHeaderVMList = new List <LeaveHeaderViewModel>(); List <LookUp> LeaveTypeLookUp = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpCategory == "LeaveType").ToList(); foreach (LeaveHeader leaveHeader in leaveHeaders) { LeaveHeaderViewModel LeaveHeaderVM = new LeaveHeaderViewModel() { Id = leaveHeader.Id, BranchId = leaveHeader.BranchID, LeaveSchemeType = leaveHeader.LeaveSchemeType, LeaveSchemeTypeDescription = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpID == leaveHeader.LeaveSchemeType).Select(s => s.LookUpCode).FirstOrDefault(), LeaveYear = leaveHeader.LeaveYear, LeaveYearType = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpID == leaveHeader.LeaveYear).Select(l => l.LookUpCode).FirstOrDefault(), PeriodicityType = leaveHeader.PeriodicityType, PeriodicityTypeDescription = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpID == leaveHeader.PeriodicityType).Select(l => l.LookUpCode).FirstOrDefault(), PeriodType = leaveHeader.PeriodType, PeriodTypeDescription = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpID == leaveHeader.PeriodType).Select(l => l.LookUpCode).FirstOrDefault(), }; PrepareleavedetailsViewModel(leaveHeader, LeaveHeaderVM, LeaveTypeLookUp); LeaveHeaderVMList.Add(LeaveHeaderVM); } result = Json(new { sucess = true, LeaveHeaderVMList = LeaveHeaderVMList }, 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); }