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 GetTableData(DTwithlimit dt) { JsonResult result = null; try { if (!string.IsNullOrWhiteSpace(dt.LookUpCategory)) { var dataList = (from eType in LookUpCodeService.GetLookUp <LookUp>(et => et.LookUpCategory == dt.LookUpCategory) select new { LookUpID = eType.LookUpID, LookUpCode = eType.LookUpCode, LookUpDescription = eType.LookUpDescription, IsActive = eType.IsActive }).Distinct(); var data = dataList.Select(x => new SortingViewModel() { employeeDescription = x.LookUpDescription, employeeDesignation = x.LookUpCode, IsActive = x.IsActive, LookUpID = x.LookUpID }).AsQueryable(); int totalCount = dataList.Count(); dt.sortType = dt.sortType ?? "asc"; dt.sortColumn = dt.sortColumn ?? "employeeDescription"; if (dt.sortType.ToLower() == "asc") { data = OrderBy(data, dt.sortColumn, false, false); } else { data = OrderBy(data, dt.sortColumn, true, false); } var lookups = data.Skip(dt.offset).Take(dt.limit).AsQueryable(); if (lookups.Any() && lookups != null) { result = Json(new { success = true, lookUpLists = lookups, total_count = totalCount, message = C.SUCCESSFUL_SAVE_MESSAGE }, JsonRequestBehavior.AllowGet); } else { result = Json(new { success = false, message = C.NO_DATA_FOUND }, JsonRequestBehavior.AllowGet); } } else { result = Json(new { success = false, message = C.NO_DATA_FOUND }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { throw ex; } return(result); }
private void PrepareEmployeeDocuments(HttpFileCollection hfc, EmployeeHeader employeeHeader, List <EmployeeDocument> employeeDocuments, List <EmployeeDocumentViewModel> employeeDocumentViewModel) { for (var i = 0; i < hfc.Count; i++) { HttpPostedFile httpPostedFileBase = hfc[i]; foreach (var item in employeeDocumentViewModel) { if (item.Name == httpPostedFileBase.FileName) { EmployeeDocument employeeDocument = new EmployeeDocument(); LookUp lookUp = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpCode == item.DocumentType).FirstOrDefault(); bool employeeHeaders = employeeHeader.EmployeeDocument != null?employeeHeader.EmployeeDocument.Any(e => e.DocumentType == lookUp.LookUpID && e.FileName == item.Name) : false; if (!employeeHeaders) { employeeDocument.CreatedBy = USER_OBJECT.UserID; employeeDocument.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); employeeDocument.FileName = httpPostedFileBase.FileName; employeeDocument.BranchId = USER_OBJECT.BranchId; employeeDocument.DocumentType = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpCode == item.DocumentType).Select(s => s.LookUpID).FirstOrDefault();; // employeeDocuments.Add(employeeDocument); SaveFile(httpPostedFileBase); employeeHeader.EmployeeDocument = employeeHeader.EmployeeDocument == null ? new List <EmployeeDocument>() : employeeHeader.EmployeeDocument; employeeHeader.EmployeeDocument.Add(employeeDocument); } } } } }
public JsonResult SaveAddressDetails(Address address) { JsonResult result = null; if (address != null) { try { if (address.AddressId > 0) { Address _address = PrepareEmployeeAddress(address, null); LookUpCodeService.Save(_address); 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 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 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 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); }
public ActionResult GetEmployeeList(string employeeName) { JsonResult jsonResult = new JsonResult(); if (!string.IsNullOrWhiteSpace(employeeName)) { try { var employeeDepartment = LookUpCodeService.GetLookUp <LookUp>(s => s.LookUpCategory == "EmployeeDesignation" && s.LookUpCode.Contains(employeeName)).Select(x => new { name = x.LookUpCode, description = x.LookUpDescription, id = x.LookUpID }).ToList(); // var managerData = employeeDepartment //var employees = (from employee in EmployeeProfileService.GetEmployeeProfileList<EmployeeHeader>(e => e.FirstName.ToLower(). // Contains(employeeName.ToLower()) // && (e.EmployeeWorkDetail.Any() && e.EmployeeWorkDetail.FirstOrDefault().DepartmentId == employeeDepartment.LookUpID ) // && e.BranchId == USER_OBJECT.BranchId) // select new // { // Id = employee.Id, // Name = employee.FirstName + " " + employee.MiddleName + " " + employee.LastName // }).ToList(); jsonResult = Json(new { sucess = true, employees = employeeDepartment }, 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); }
public JsonResult SaveLookUp(LookUp lookUpViewModel) { JsonResult result = null; try { if (lookUpViewModel != null) { LookUp lookUp = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpID == lookUpViewModel.LookUpID).FirstOrDefault(); if (lookUp != null) { lookUp.ModifiedBy = USER_OBJECT.UserID; lookUp.ModifiedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); } else { lookUp = new LookUp(); lookUp.CreatedBy = USER_OBJECT.UserID; lookUp.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); lookUp.ModifiedOn = null; } lookUp.LookUpCode = lookUpViewModel.LookUpCode; lookUp.LookUpDescription = lookUpViewModel.LookUpDescription; lookUp.IsActive = lookUpViewModel.IsActive; lookUp.LookUpCategory = lookUpViewModel.LookUpCategory; LookUpCodeService.Save(lookUp); result = Json(new { success = true, message = C.SUCCESSFUL_SAVE_MESSAGE }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { result = Json(new { success = true, message = ex.Message }, JsonRequestBehavior.AllowGet); } return(result); }
public JsonResult GetActiveLookUp(string LookUpCategory) { JsonResult result = null; try { if (!string.IsNullOrWhiteSpace(LookUpCategory)) { var lookUp = from eType in LookUpCodeService.GetLookUp <LookUp>(et => et.LookUpCategory == LookUpCategory && et.IsActive == true) select new { LookUpID = eType.LookUpID, LookUpCode = eType.LookUpCode, LookUpDescription = eType.LookUpDescription, IsActive = eType.IsActive }; if (lookUp.Any() && lookUp != null) { result = Json(new { success = true, lookUpLists = lookUp, message = C.SUCCESSFUL_SAVE_MESSAGE }, JsonRequestBehavior.AllowGet); } else { result = Json(new { success = false, message = C.NO_DATA_FOUND }, JsonRequestBehavior.AllowGet); } } else { result = Json(new { success = false, message = C.NO_DATA_FOUND }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { throw ex; } 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); }