public IActionResult Gets() { var draw = HttpContext.Request.Form["draw"].FirstOrDefault(); // Skiping number of Rows count var start = Request.Form["start"].FirstOrDefault(); // Paging Length 10,20 var length = Request.Form["length"].FirstOrDefault(); // Sort Column Name var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"].FirstOrDefault(); // Sort Column Direction ( asc ,desc) var sortColumnDirection = Request.Form["order[0][dir]"].FirstOrDefault(); // Search Value from (Search box) var searchValue = Request.Form["search[value]"].FirstOrDefault(); //Paging Size (10,20,50,100) int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int recordsTotal = 0; var model = new GetEmployeeList() { ManagerId = 1 }; var responseData = _managerRepository.GetEmployeeList(model); //Sorting if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDirection))) { var prop = GetProperty(sortColumn); if (sortColumnDirection == "asc") { responseData = responseData.OrderBy(prop.GetValue).ToList(); } else { responseData = responseData.OrderByDescending(prop.GetValue).ToList(); } } //Search if (!string.IsNullOrEmpty(searchValue)) { responseData = (from e in responseData where e.FullName.Contains(searchValue) || e.PhoneNumber.Contains(searchValue) || e.Email.Contains(searchValue) select e).ToList(); } //total number of rows count recordsTotal = responseData.Count(); //Paging var data = responseData.Skip(skip).Take(pageSize).ToList(); //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data })); }
//public bool UpdateLeaveApplication(UpdateLeaveApplication model) //{ // var list = new List<TimeSheetList>(); // try // { // int DepartmentId = _dbContext.Employee.FirstOrDefault(e => e.Id == model.ManagerId && e.IsActive == true && e.IsDelete == false).DepartmentId; // list = (from e in _dbContext.Employee // join t in _dbContext.TimeSheet on e.Id equals t.EmployeeId // where e.Id == model.EmployeeId && e.DepartmentId == DepartmentId && e.IsDelete == false // orderby t.Date descending // select new TimeSheetList // { // EmployeeId = e.Id, // ManagerId = t.ManagerId, // FullName = e.FullName, // Status = t.Status == 1 ? "Có mặt" : // (t.Status == 2 ? "Trễ" : // (t.Status == 3 ? "Vắng không phép" : // (t.Status == 4 ? "Vắng có phép" : // (t.Status == 5 ? "Vắng không lương" : "" // )))), // Date = t.Date.ToString() // }).ToList(); // } // catch (Exception ex) // { // throw ex; // } // return list; //} #endregion #region Information public IList <EmployeeList> GetEmployeeList(GetEmployeeList model) { var list = new List <EmployeeList>(); try { int DepartmentId = _dbContext.Employee.FirstOrDefault(e => e.Id == model.ManagerId && e.IsActive == true && e.IsDelete == false).DepartmentId; list = (from e in _dbContext.Employee join p in _dbContext.Position on e.PositionId equals p.Id where e.DepartmentId == DepartmentId && e.IsDelete == false select new EmployeeList { EmployeeId = e.Id, FullName = e.FullName, Sex = e.Sex, Dob = e.Dob.ToString(), PhoneNumber = e.PhoneNumber, Email = e.Email, Image = e.Image, PositionName = p.Name }).ToList(); } catch (Exception ex) { throw ex; } return(list); }
public ActionResult _EmployeeFilter(GetEmployeeList getEmployeeList) { FilterModel filterModel = new FilterModel() { Id = "FilterEmployeeId", SelectAllCaption = "All Providers", SelectListItemList = new SelectList(getEmployeeList.ExecuteList(), "Id", "FullName").ToList() }; return(View("_Filter", filterModel)); }
public ActionResult Appointment(GetEmployeeList getEmployeeList) { this.ViewData["employeeList"] = getEmployeeList.ExecuteList(); return(View(new List <SchedulerInfo>())); }
// GET: Settings/Employee public ActionResult Index(GetEmployeeList getEmployeeList) { return(View(getEmployeeList.ExecuteList())); }