public JsonResult SaveEmployeeUser(User EmployeeUser, Int32 employeeId) { JsonResult result = null; if (EmployeeUser != null) { try { if (EmployeeUser.Id > 0) { User _user = EmployeeUser; EmployeeHeader _employeeHeader = EmployeeProfileService.GetEmployeeProfileDetailsById(employeeId); _user.ModifiedOn = _employeeHeader.ModifiedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); _user.ModifiedBy = _employeeHeader.ModifiedBy = USER_OBJECT.UserID; _user.UserName = _employeeHeader.UserEmailId = EmployeeUser.UserName; _user.Password = _employeeHeader.Password = _employeeHeader.ConfirmPassword = EmployeeUser.Password; LogInLogOutService.Save(EmployeeUser, true); EmployeeProfileService.SaveEmployeeProfile(_employeeHeader, true); result = Json(new { sucess = true, message = C.SUCCESSFUL_SAVE_MESSAGE }, 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 SaveEmployeeHeader(EmployeeHeader employeeHeader) { JsonResult result = null; if (employeeHeader != null) { try { if (employeeHeader.Id > 0) { EmployeeHeader _employeeHeader = employeeHeader; _employeeHeader.ModifiedBy = USER_OBJECT.UserID; _employeeHeader.ModifiedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); _employeeHeader.FirstName = employeeHeader.FirstName; _employeeHeader.MiddleName = employeeHeader.MiddleName; _employeeHeader.LastName = employeeHeader.LastName; _employeeHeader.EmployeePersonalInfo.Add(PrepareEmployeePersonalInfo(employeeHeader.EmployeePersonalInfo.FirstOrDefault(), employeeHeader)); _employeeHeader.Nationality = employeeHeader.Nationality; EmployeeProfileService.SaveEmployeeProfile(_employeeHeader); result = Json(new { sucess = true, message = C.SUCCESSFUL_SAVE_MESSAGE }, 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 SaveEmlployee() { EmployeeHeader employeeHeader = JsonConvert.DeserializeObject <EmployeeHeader>(System.Web.HttpContext.Current.Request["EmployeeDetails"]); List <EmployeeDocumentViewModel> employeeDocumentViewModel = JsonConvert.DeserializeObject <List <EmployeeDocumentViewModel> >(System.Web.HttpContext.Current.Request["EmployeeDocument"]); HttpFileCollection hfc = System.Web.HttpContext.Current.Request.Files; JsonResult result = new JsonResult(); if (employeeHeader != null) { try { EmployeeHeader _employeeHeader = new EmployeeHeader(); _employeeHeader = PrepareEmployeeHeader(employeeHeader, hfc, employeeDocumentViewModel); EmployeeProfileService.SaveEmployeeProfile(_employeeHeader); PrepareEmail(_employeeHeader); result = Json(new { sucess = true, message = C.SUCCESSFUL_SAVE_MESSAGE }, 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 SaveEmployeeLeaveForm(EmployeeLeaveList employeeLeaveList) { JsonResult result = new JsonResult(); if (employeeLeaveList != null) { try { EmployeeLeaveList _employeeLeaveList = new EmployeeLeaveList(); if (employeeLeaveList.Id > 0) { _employeeLeaveList = Leaveservice.GetLeaveListById(employeeLeaveList.Id); _employeeLeaveList.ModifiedBy = USER_OBJECT.UserName; _employeeLeaveList.ModifiedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); } else { _employeeLeaveList.CreatedBy = USER_OBJECT.UserName; _employeeLeaveList.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); _employeeLeaveList.ApplyDate = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); } EmployeeHeader employeeHeader = EmployeeProfileService.GetEmployeeProfileList <EmployeeHeader>(e => e.Id == employeeLeaveList.EmployeeId).FirstOrDefault(); _employeeLeaveList.EmployeeId = employeeHeader.Id; _employeeLeaveList.FromDate = employeeLeaveList.FromDate; _employeeLeaveList.ToDate = employeeLeaveList.ToDate; _employeeLeaveList.Days = employeeLeaveList.Days; _employeeLeaveList.Reason = employeeLeaveList.Reason; _employeeLeaveList.Remarks = employeeLeaveList.Remarks; _employeeLeaveList.LeaveTypeId = employeeLeaveList.LeaveTypeId; _employeeLeaveList.Status = employeeLeaveList.Status; _employeeLeaveList.ManagerId = employeeHeader.ManagerId.HasValue ? employeeHeader.ManagerId.Value : 0; Leaveservice.SaveLeaveList(_employeeLeaveList); result = Json(new { sucess = true, message = "Sent successfully" }, 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)); } } } else { result = Json(new { sucess = false, message = "No Data Found" }, JsonRequestBehavior.AllowGet); } 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 SaveEmployeeDocuments() { var employeeId = Convert.ToInt16(System.Web.HttpContext.Current.Request["employeeId"]); HttpFileCollection hfc = System.Web.HttpContext.Current.Request.Files; JsonResult result = null; try { EmployeeDocument employeeDocument = null; HttpPostedFile file = hfc[0]; employeeDocument = EmployeeProfileService.GetEmployeeDocuments <EmployeeDocument>(ed => ed.EmployeeHeaderId == employeeId).FirstOrDefault(); //EmployeeHeader employeeHeader = EmployeeProfileService.GetEmployeeDocuments(Convert.ToInt16(employeeId)); if (employeeDocument != null) { employeeDocument.ModifiedBy = USER_OBJECT.UserID; employeeDocument.ModifiedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); } else { employeeDocument = new EmployeeDocument(); employeeDocument.CreatedBy = USER_OBJECT.UserID; employeeDocument.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); } EmployeeHeader EmployeeHeader = EmployeeProfileService.GetEmployeeProfileList <EmployeeHeader>(s => s.Id == employeeId).FirstOrDefault(); employeeDocument.FileName = System.IO.Path.GetFileName(file.FileName); employeeDocument.BranchId = USER_OBJECT.BranchId; employeeDocument.EmployeeHeaderId = Convert.ToInt32(employeeId); employeeDocument.DocumentType = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpCode == "ProfilePic").Select(s => s.LookUpID).FirstOrDefault(); SaveFile(file); EmployeeHeader.EmployeeDocument.Add(employeeDocument); if (employeeDocument != null) { EmployeeProfileService.SaveEmployeeDocuments(employeeDocument); } } 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 GetEmployeeNumber() { JsonResult result = new JsonResult(); try { string employeeNumber = EmployeeProfileService.GetNewEmployeeNumber(USER_OBJECT.BranchId, "Employee", USER_OBJECT.UserID); result = Json(employeeNumber, 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); }
private EmployeeHeader PrepareEmployeeHeader(EmployeeHeader employeeHeader, HttpFileCollection hfc = null, List <EmployeeDocumentViewModel> employeeDocumentViewModel = null) { EmployeeHeader _employeeHeader = null; if (employeeHeader.Id > 0) { _employeeHeader = EmployeeProfileService.GetEmployeeProfileDetailsById(employeeHeader.Id); _employeeHeader.ModifiedBy = USER_OBJECT.UserName; _employeeHeader.ModifiedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); } else { _employeeHeader = new EmployeeHeader(); _employeeHeader.CreatedBy = USER_OBJECT.UserName; _employeeHeader.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); } EmployeePersonalInfo employeePersonalInfo = employeeHeader.EmployeePersonalInfo.FirstOrDefault(); _employeeHeader.BranchId = employeeHeader.BranchId; _employeeHeader.ManagerId = employeeHeader.ManagerId; _employeeHeader.FirstName = !string.IsNullOrWhiteSpace(employeeHeader.FirstName) ? employeeHeader.FirstName.ToUpper() : string.Empty; _employeeHeader.MiddleName = !string.IsNullOrWhiteSpace(employeeHeader.MiddleName) ? employeeHeader.MiddleName.ToUpper() : string.Empty; _employeeHeader.LastName = !string.IsNullOrWhiteSpace(employeeHeader.LastName) ? employeeHeader.LastName.ToUpper() : string.Empty; _employeeHeader.Nationality = !string.IsNullOrWhiteSpace(employeeHeader.Nationality) ? employeeHeader.Nationality : string.Empty; _employeeHeader.IDNumber = !string.IsNullOrWhiteSpace(employeeHeader.IDNumber) ? employeeHeader.IDNumber : string.Empty; _employeeHeader.IDType = employeeHeader.IDType; _employeeHeader.UserEmailId = employeeHeader.UserEmailId; _employeeHeader.Password = employeeHeader.Password; _employeeHeader.IsActive = employeeHeader.IsActive; _employeeHeader.ConfirmPassword = employeeHeader.ConfirmPassword; _employeeHeader.EmployeePersonalInfo.Add(PrepareEmployeePersonalInfo(employeePersonalInfo, _employeeHeader)); _employeeHeader.Address.Add(PrepareEmployeeAddress(employeeHeader.Address.FirstOrDefault(), _employeeHeader)); _employeeHeader.EmployeeWorkDetail.Add(PrepareEmployeeWorkDetail(employeeHeader.EmployeeWorkDetail.FirstOrDefault(), _employeeHeader)); employeeHeader.User = employeeHeader.User == null ? new User() : employeeHeader.User; _employeeHeader.User = PrepareUserDetails(employeeHeader.User, _employeeHeader); List <EmployeeDocument> employeeDocument = employeeHeader.EmployeeDocument != null ? employeeHeader.EmployeeDocument : new List <EmployeeDocument>(); PrepareEmployeeDocuments(hfc, _employeeHeader, employeeDocument, employeeDocumentViewModel); return(_employeeHeader); }
public EmployeeProfileController(EmployeeProfileService employeeProfileService) { this.employeeProfileService = employeeProfileService; }
public JsonResult GetRegionWiseEmployees() { JsonResult result = null; try { List <EmployeeHeader> EmployeeHeader = EmployeeProfileService.GetEmployeeProfileList <EmployeeHeader>().ToList(); var regionWiseEmployees = EmployeeHeader.GroupBy(g => g.Branch.BranchName).ToList() .Select(n => new { y = n.Count(), name = n.Key }).OrderByDescending(o => o.y); //var designationWiseEmployees = EmployeeHeader.Select(g => g.EmployeeWorkDetail).GroupBy(g => g.Select(s => s.DesignationId.Value).FirstOrDefault()).ToList() // .Select(n => new // { // y = n.Count(), // name = n.Key > 0? LookUpCodeService.GetLookUpType(n.Key).LookUpCode:string.Empty // }); var genderWiseEmployees = EmployeeHeader.GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender).FirstOrDefault()).ToList() .Select(n => new { y = n.Count(), name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : "" }); //var genderWiseEmployees = EmployeeHeader. // GroupBy(g => g.Branch.BranchName).ToList() // .Select(n => new // { // y= n.Count(), // name = n.Key, // male = n.Where(s => s.EmployeePersonalInfo.FirstOrDefault().Gender == 0).Count(), // female = n.Where(s => s.EmployeePersonalInfo.FirstOrDefault().Gender == 1).Count() // }).OrderByDescending(o=>o.y); var indiawiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "INDIA") .GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender) .FirstOrDefault()).ToList() .Select(n => new { y = n.Count(), name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : "" }).OrderByDescending(n => n.name); var singaporewiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "SINGAPORE") .GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender) .FirstOrDefault()).ToList() .Select(n => new { y = n.Count(), name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : "" }).OrderByDescending(n => n.name); var hongkongwiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "HONGKONG") .GroupBy(x => x.EmployeePersonalInfo.Select(s => s.Gender) .FirstOrDefault()).ToList() .Select(n => new { y = n.Count(), name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : "" }).OrderByDescending(n => n.name); var mayanmarwiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "MAYANMAR") .GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender) .FirstOrDefault()).ToList() .Select(n => new { y = n.Count(), name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : "" }).OrderByDescending(n => n.name); var pakistanwiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "PAKISTAN") .GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender) .FirstOrDefault()).ToList() .Select(n => new { y = n.Count(), name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : "" }).OrderByDescending(n => n.name); var srilankawiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "SRILANKA") .GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender) .FirstOrDefault()).ToList() .Select(n => new { y = n.Count(), name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : "" }).OrderByDescending(n => n.name); var cambodiawiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "CAMBODIA") .GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender) .FirstOrDefault()).ToList() .Select(n => new { y = n.Count(), name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : "" }).OrderByDescending(n => n.name); var bangladeshwiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "BANGLADESH") .GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender) .FirstOrDefault()).ToList() .Select(n => new { y = n.Count(), name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : "" }).OrderByDescending(n => n.name); //var countryWiseGender = EmployeeHeader.GroupBy(g => g.Address.CountryCode && g.EmployeePersonalInfo.Gender).ToList(); result = Json(new { sucess = true, regionWiseEmployees = regionWiseEmployees, genderWiseEmployees = genderWiseEmployees, indiawiseGenders = indiawiseGenders, bangladeshwiseGenders = bangladeshwiseGenders, cambodiawiseGenders = cambodiawiseGenders, srilankawiseGenders = srilankawiseGenders, pakistanwiseGenders = pakistanwiseGenders, mayanmarwiseGenders = mayanmarwiseGenders, hongkongwiseGenders = hongkongwiseGenders, singaporewiseGenders = singaporewiseGenders }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { result = Json(new { sucess = false, message = ex.Message }, JsonRequestBehavior.AllowGet); } return(result); }
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); }