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 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 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 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); }