public ActionResult Index()
{
AssignUserInfo();
qlXeBusiness = Get <QL_XEBusiness>();
XeBenhVienIndexViewModel viewModel = new XeBenhVienIndexViewModel();
XeSearchBO searchModel = new XeSearchBO();
searchModel.CCTC_THANHPHAN_ID = currentUser.DeptParentID.GetValueOrDefault();
viewModel.listXeBenhViens = qlXeBusiness.GetDataByPage(searchModel);
SessionManager.SetValue("SearchXeBenhVien", searchModel);
return(View(viewModel));
}
public JsonResult GetData(int pageIndex, string sortQuery, int pageSize)
{
AssignUserInfo();
qlXeBusiness = Get <QL_XEBusiness>();
XeSearchBO searchModel = (XeSearchBO)SessionManager.GetValue("SearchXeBenhVien");
if (searchModel == null)
{
searchModel = new XeSearchBO();
}
searchModel.sortQuery = sortQuery;
searchModel.CCTC_THANHPHAN_ID = currentUser.DeptParentID.GetValueOrDefault();
PageListResultBO <XeBO> data = qlXeBusiness.GetDataByPage(searchModel);
return(Json(data));
}
/// <summary>
/// @author: duynn
/// @description: lấy danh sách xe
/// </summary>
/// <returns></returns>
public PageListResultBO <XeBO> GetDataByPage(XeSearchBO searchModel, int pageIndex = 1, int pageSize = 20)
{
IQueryable <XeBO> queryResult = (from car in this.context.QL_XE.Where(x => x.IS_DELETE != true)
join trip in this.context.QL_DANGKYXE_LAIXE
on car.ID equals trip.XE_ID
into group1
select new XeBO()
{
ID = car.ID,
IMAGE_PATH = car.IMAGE_PATH,
TENXE = car.TENXE,
BIENSO = car.BIENSO,
SOCHO = car.SOCHO,
NGAYSUA = car.NGAYSUA,
CCTC_THANHPHAN_ID = car.CCTC_THANHPHAN_ID,
TRANGTHAI = group1.OrderByDescending(x => x.ID).Select(x => x.TRANGTHAI).FirstOrDefault() ?? TRANGTHAI_CHUYEN_CONSTANT.DA_HOANTHANH_ID,
});
if (searchModel != null)
{
if (!string.IsNullOrEmpty(searchModel.TENXE))
{
searchModel.TENXE = searchModel.TENXE.Trim().ToLower();
queryResult = queryResult.Where(x => !string.IsNullOrEmpty(x.TENXE) && x.TENXE.Trim().ToLower().Contains(searchModel.TENXE));
}
if (!string.IsNullOrEmpty(searchModel.BIENSO))
{
searchModel.BIENSO = searchModel.BIENSO.Trim().ToLower();
queryResult = queryResult.Where(x => !string.IsNullOrEmpty(x.BIENSO) && x.BIENSO.Trim().ToLower().Contains(searchModel.BIENSO));
}
if (searchModel.querySoChoStart != null)
{
queryResult = queryResult.Where(x => x.SOCHO >= searchModel.querySoChoStart);
}
if (searchModel.querySoChoEnd != null)
{
queryResult = queryResult.Where(x => x.SOCHO <= searchModel.querySoChoEnd);
}
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 <XeBO> result = new PageListResultBO <XeBO>();
IPagedList <XeBO> pagedList = queryResult.ToPagedList(pageIndex, pageSize);
result.Count = pagedList.TotalItemCount;
result.TotalPage = pagedList.PageCount;
result.ListItem = pagedList.ToList();
return(result);
}
