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