private PagedList<Employee> QueryListData(EmployeeSearch searchModel) { int recordCount = 0; int pageSize = ConstantManager.PageSize; EmployeeService service = new EmployeeService(); string Group = searchModel.IsAsc ? searchModel.SortBy : searchModel.SortBy + " Descending"; IList<Employee> allEntities = service.QueryByPage(this.GetSearchFilter(searchModel), Group, pageSize, searchModel.PageIndex + 1, out recordCount); var formCondition = "var condition=" + JsonConvert.SerializeObject(searchModel); return new PagedList<Employee>(allEntities, searchModel.PageIndex, pageSize, recordCount, "Id", "Id", formCondition); }
private void LoadSearchViewBag(EmployeeSearch searchModel) { #region sort ViewBag.IsAsc = !searchModel.IsAsc; ViewBag.SortBy = searchModel.SortBy; #endregion var departmentService = new DepartmentService(); if (!searchModel.DepartmentId.HasValue) { ViewBag.DepartmentId = new SelectList(departmentService.Query(p => p.IsActive=="1"), "Id", "Name"); } else { ViewBag.DepartmentId = new SelectList(departmentService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.DepartmentId); } }
public ActionResult SearchListPartialView(EmployeeSearch searchModel) { #region sort ViewBag.IsAsc = !searchModel.IsAsc; ViewBag.SortBy = searchModel.SortBy; #endregion return PartialView("SearchListPartialView",this.QueryListData(searchModel)); }
private Expression<Func<Employee, bool>> GetSearchFilter(EmployeeSearch searchModel) { Expression<Func<Employee, bool>> filter = p => p.IsActive=="1" ; if (searchModel.DepartmentId.HasValue) { filter = filter.And(q => q.DepartmentId == searchModel.DepartmentId.Value); } return filter; }
// // GET: /Employee/ //[PermissionFilter] public ViewResult Index(EmployeeSearch searchModel) { this.LoadSearchViewBag(searchModel); return View(this.QueryListData(searchModel)); }