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 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); }
public JsonResult GetEmployeeById(int employeeId, bool IsfromIndividualEmployee) { JsonResult result = null; try { EmployeeHeader employeeHeader = null; string imagePathName = string.Empty; LookUpDescriptions lookUpDescriptions = null; if (!IsfromIndividualEmployee) { employeeHeader = EmployeeProfileService.GetEmployeeProfileDetailsById(employeeId); } else if (employeeId == 0) { employeeHeader = EmployeeProfileService.GetEmployeeProfileList <EmployeeHeader>(e => e.UserId == USER_OBJECT.Id).FirstOrDefault(); EmployeeDocument employeeDocument = EmployeeProfileService.GetEmployeeDocuments <EmployeeDocument>(ed => ed.EmployeeHeaderId == employeeHeader.Id).FirstOrDefault(); if (employeeDocument != null) { imagePathName = employeeDocument.FileName; } lookUpDescriptions = new LookUpDescriptions(); foreach (var employeePersonalInfo in employeeHeader.EmployeePersonalInfo) { lookUpDescriptions.MarriedStatus = LookUpCodeService.GetLookUpType(employeePersonalInfo.MaritalStatus).LookUpCode; } foreach (var employeeWorkDetail in employeeHeader.EmployeeWorkDetail) { lookUpDescriptions.Designation = LookUpCodeService.GetLookUpType(employeeWorkDetail.DesignationId.Value).LookUpCode; lookUpDescriptions.Department = LookUpCodeService.GetLookUpType(employeeWorkDetail.DepartmentId.Value).LookUpCode; } lookUpDescriptions.Country = CompanyService.GetCountries <Country>(c => c.CountryCode == employeeHeader.Address.FirstOrDefault().CountryCode).FirstOrDefault().CountryName; lookUpDescriptions.Nationality = CompanyService.GetCountries <Country>(c => c.CountryCode == employeeHeader.Nationality).FirstOrDefault().CountryName; } List <EmployeeDocument> employeeDocuments = EmployeeProfileService.GetEmployeeDocuments <EmployeeDocument>(e => e.EmployeeHeaderId == employeeHeader.Id).ToList(); employeeHeader.EmployeeDocument = employeeDocuments != null ? employeeDocuments : null; result = Json(new { employeeHeader = employeeHeader, imagePathName = imagePathName, LookUpDescriptions = lookUpDescriptions }, 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 GetEmployeeDetails(SearchViewModel searchViewModel) { JsonResult jsonResult = new JsonResult(); try { List <EmployeeHeader> employeeHeader = EmployeeProfileService.GetEmployeeProfileList <EmployeeHeader>(e => e.Address.Select(s => s.CountryCode == USER_OBJECT.CountryCode).FirstOrDefault()).ToList(); List <EmployeeViewModel> employeeViewModelList = new List <EmployeeViewModel>(); foreach (var item in employeeHeader) { EmployeeViewModel employeeViewModel = new EmployeeViewModel(); employeeViewModel.Id = item.Id; employeeViewModel.EmployeeName = string.Empty; if (!string.IsNullOrEmpty(item.FirstName)) { employeeViewModel.EmployeeName += item.FirstName; } if (!string.IsNullOrEmpty(item.MiddleName)) { employeeViewModel.EmployeeName += " " + item.MiddleName; } if (!string.IsNullOrEmpty(item.LastName)) { employeeViewModel.EmployeeName += " " + item.LastName; } foreach (var employeeWorkDetail in item.EmployeeWorkDetail) { employeeViewModel.JoiningDate = item.EmployeeWorkDetail != null ? employeeWorkDetail.JoiningDate.Value.Date : DateTime.Now.Date; employeeViewModel.JoiningDate = employeeViewModel.JoiningDate.Date; employeeViewModel.Designation = item.EmployeeWorkDetail != null && employeeWorkDetail.DesignationId.HasValue ? employeeWorkDetail.DesignationId.Value : 0; employeeViewModel.DesignationName = item.EmployeeWorkDetail != null && employeeWorkDetail.DesignationId.HasValue ? (LookUpCodeService.GetLookUpType(employeeWorkDetail.DesignationId.Value)).LookUpDescription : string.Empty; } foreach (var employeePersonalInfo in item.EmployeePersonalInfo) { employeeViewModel.DOB = Convert.ToDateTime(employeePersonalInfo.DOB); } foreach (var address in item.Address) { employeeViewModel.MobileNo = address.MobileNo; employeeViewModel.Email = address.Email; employeeViewModel.CountryCode = address.CountryCode; } employeeViewModel.EmployeeId = item.IDNumber; employeeViewModel.EmployeeType = item.IDType; employeeViewModelList.Add(employeeViewModel); } var employees = employeeViewModelList.AsQueryable(); int totalCount = employees.Count(); if (searchViewModel.FilterViewModel != null) { foreach (FilterViewModel item in searchViewModel.FilterViewModel) { employees = ApplyWhere(item, employees); } } if (!string.IsNullOrWhiteSpace(searchViewModel.sortType)) { if (searchViewModel.sortType.ToLower() == "asc") { employees = OrderBy(employees, searchViewModel.sortColumn, false, false); } else { employees = OrderBy(employees, searchViewModel.sortColumn, true, false); } } employees = employees.Skip(searchViewModel.offset).Take(searchViewModel.limit).AsQueryable(); if (searchViewModel.FilterViewModel == null) { jsonResult = Json(new { sucess = true, employees = employees, total_count = totalCount }, JsonRequestBehavior.AllowGet); } else { jsonResult = Json(new { sucess = true, employees = employees, total_count = employees.Count() }, 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(jsonResult); }