public ActionResult Index() { AssignUserInfo(); qlLaiXeBusiness = Get <QL_LAIXEBusiness>(); LaiXeBenhVienIndexViewModel viewModel = new LaiXeBenhVienIndexViewModel(); LaiXeSearchBO searchModel = new LaiXeSearchBO(); searchModel.CCTC_THANHPHAN_ID = currentUser.DeptParentID.GetValueOrDefault(); viewModel.listLaiXeBenhViens = qlLaiXeBusiness.GetDataByPage(searchModel); SessionManager.SetValue("SearchLaiXeBenhVien", searchModel); return(View(viewModel)); }
public JsonResult GetData(int pageIndex, string sortQuery, int pageSize) { AssignUserInfo(); qlLaiXeBusiness = Get <QL_LAIXEBusiness>(); LaiXeSearchBO searchModel = (LaiXeSearchBO)SessionManager.GetValue("SearchLaiXeBenhVien"); if (searchModel == null) { searchModel = new LaiXeSearchBO(); } searchModel.sortQuery = sortQuery; searchModel.CCTC_THANHPHAN_ID = currentUser.DeptParentID.GetValueOrDefault(); PageListResultBO <LaiXeBO> data = qlLaiXeBusiness.GetDataByPage(searchModel); return(Json(data)); }
/// <summary> /// @author: duynn /// @since: 27/08/2018 /// </summary> /// <param name="searchModel"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public PageListResultBO <LaiXeBO> GetDataByPage(LaiXeSearchBO searchModel, int pageIndex = 1, int pageSize = 20) { IQueryable <LaiXeBO> queryResult = (from driver in this.context.QL_LAIXE.Where(x => x.IS_DELETE != true) select new LaiXeBO() { ID = driver.ID, GIOITINH = driver.GIOITINH, HOTEN = driver.HOTEN, CMND = driver.CMND, SODIENTHOAI = driver.SODIENTHOAI, EMAIL = driver.EMAIL, NGAYSUA = driver.NGAYSUA, CCTC_THANHPHAN_ID = driver.CCTC_THANHPHAN_ID, }); if (searchModel != null) { if (!string.IsNullOrEmpty(searchModel.HOTEN)) { searchModel.HOTEN = searchModel.HOTEN.Trim().ToLower(); queryResult = queryResult.Where(x => !string.IsNullOrEmpty(x.HOTEN) && x.HOTEN.Trim().ToLower().Contains(searchModel.HOTEN)); } if (!string.IsNullOrEmpty(searchModel.CMND)) { searchModel.CMND = searchModel.CMND.Trim().ToLower(); queryResult = queryResult.Where(x => !string.IsNullOrEmpty(x.CMND) && x.CMND.Trim().ToLower().Contains(searchModel.CMND)); } if (!string.IsNullOrEmpty(searchModel.SODIENTHOAI)) { searchModel.SODIENTHOAI = searchModel.SODIENTHOAI.Trim().ToLower(); queryResult = queryResult.Where(x => !string.IsNullOrEmpty(x.SODIENTHOAI) && x.SODIENTHOAI.Trim().ToLower().Contains(searchModel.SODIENTHOAI)); } if (!string.IsNullOrEmpty(searchModel.EMAIL)) { searchModel.EMAIL = searchModel.EMAIL.Trim().ToLower(); queryResult = queryResult.Where(x => !string.IsNullOrEmpty(x.EMAIL) && x.EMAIL.Trim().ToLower().Contains(searchModel.EMAIL)); } if (searchModel.GIOITINH != null) { queryResult = queryResult.Where(x => x.GIOITINH == searchModel.GIOITINH.Value); } if (searchModel.CCTC_THANHPHAN_ID != null) { queryResult = queryResult.Where(x => x.CCTC_THANHPHAN_ID == searchModel.CCTC_THANHPHAN_ID.Value); } if (!string.IsNullOrEmpty(searchModel.sortQuery)) { queryResult = queryResult.OrderBy(searchModel.sortQuery); } else { queryResult = queryResult.OrderByDescending(x => x.ID).ThenByDescending(x => x.NGAYSUA); } } PageListResultBO <LaiXeBO> result = new PageListResultBO <LaiXeBO>(); IPagedList <LaiXeBO> pagedList = queryResult.ToPagedList(pageIndex, pageSize); result.Count = pagedList.TotalItemCount; result.TotalPage = pagedList.PageCount; result.ListItem = pagedList.ToList(); return(result); }