public JsonResult GetData(int pageIndex, string sortQuery, int pageSize)
{
AssignUserInfo();
bool canReceiveRegistration = currentUser.ListThaoTac
.Where(x => x.MA_THAOTAC == CONFIRM_CAR_REGISTRATION).FirstOrDefault() != null;
qlDangKyXeBusiness = Get <QL_DANGKY_XEBusiness>();
DangKyXeSearchBO searchModel = (DangKyXeSearchBO)SessionManager.GetValue("SearchDangKyXeBenhVien");
if (searchModel == null)
{
searchModel = new DangKyXeSearchBO();
}
if (canReceiveRegistration)
{
searchModel.TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.MOITAO_ID;
searchModel.USER_ID = currentUser.ID;
searchModel.HAS_ROLE_CONFIRM = true;
}
searchModel.sortQuery = sortQuery;
searchModel.CCTC_THANHPHAN_ID = currentUser.DeptParentID.GetValueOrDefault();
PageListResultBO <DangKyXeBO> data = qlDangKyXeBusiness.GetDataByPage(searchModel);
return(Json(data));
}
public ActionResult Index()
{
AssignUserInfo();
bool canReceiveRegistration = currentUser.ListThaoTac
.Where(x => x.MA_THAOTAC == CONFIRM_CAR_REGISTRATION).FirstOrDefault() != null;
qlDangKyXeBusiness = Get <QL_DANGKY_XEBusiness>();
DangKyXeIndexViewModel viewModel = new DangKyXeIndexViewModel();
DangKyXeSearchBO searchModel = new DangKyXeSearchBO();
searchModel.CCTC_THANHPHAN_ID = currentUser.DeptParentID.GetValueOrDefault();
if (canReceiveRegistration)
{
searchModel.TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.MOITAO_ID;
searchModel.USER_ID = currentUser.ID;
searchModel.HAS_ROLE_CONFIRM = true;
viewModel.canReceiveRegistration = canReceiveRegistration;
}
viewModel.currentUserId = currentUser.ID;
viewModel.listDangKyXeBenhViens = qlDangKyXeBusiness.GetDataByPage(searchModel);
SessionManager.SetValue("SearchDangKyXeBenhVien", searchModel);
return(View(viewModel));
}
/// <summary>
/// @author: duynn
/// @description: lấy danh sách đăng ký xe
/// </summary>
/// <param name="searchModel"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public PageListResultBO <DangKyXeBO> GetDataByPage(DangKyXeSearchBO searchModel, int pageIndex = 1, int pageSize = 20)
{
IQueryable <DangKyXeBO> queryResult = (from register in this.context.QL_DANGKY_XE.Where(x => x.IS_DELETE != true)
join user in this.context.DM_NGUOIDUNG
on register.NGUOITAO equals user.ID
into group1
from g1 in group1.DefaultIfEmpty()
select new DangKyXeBO()
{
ID = register.ID,
SONGUOI = register.SONGUOI,
MUCDICH = register.MUCDICH,
NGAY_XUATPHAT = register.NGAY_XUATPHAT,
GIO_XUATPHAT = register.GIO_XUATPHAT,
PHUT_XUATPHAT = register.PHUT_XUATPHAT,
NGAYSUA = register.NGAYSUA,
TRANGTHAI = register.TRANGTHAI ?? 0,
NGUOITAO = register.NGUOITAO,
NGUOIDANGKY = g1.HOTEN,
CCTC_THANHPHAN_ID = register.CCTC_THANHPHAN_ID
});
if (searchModel != null)
{
if (!string.IsNullOrEmpty(searchModel.MUCDICH))
{
searchModel.MUCDICH = searchModel.MUCDICH.Trim().ToLower();
queryResult = queryResult.Where(x => !string.IsNullOrEmpty(x.MUCDICH) && x.MUCDICH.Trim().ToLower().Contains(searchModel.MUCDICH));
}
if (searchModel.queryThoiGianXuatPhatStart != null)
{
queryResult = queryResult.Where(x => x.NGAY_XUATPHAT >= searchModel.queryThoiGianXuatPhatStart);
}
if (searchModel.queryThoiGianXuatPhatEnd != null)
{
queryResult = queryResult.Where(x => x.NGAY_XUATPHAT <= searchModel.queryThoiGianXuatPhatEnd);
}
if (searchModel.querySoNguoiStart != null)
{
queryResult = queryResult.Where(x => x.SONGUOI >= searchModel.querySoNguoiStart);
}
if (searchModel.querySoNguoiEnd != null)
{
queryResult = queryResult.Where(x => x.SONGUOI <= searchModel.querySoNguoiEnd);
}
if (searchModel.CCTC_THANHPHAN_ID != null)
{
queryResult = queryResult.Where(x => x.CCTC_THANHPHAN_ID == searchModel.CCTC_THANHPHAN_ID.Value);
}
if (searchModel.HAS_ROLE_CONFIRM)
{
if (searchModel.TRANGTHAI != null && searchModel.USER_ID != null)
{
queryResult = queryResult.Where(x => x.TRANGTHAI != searchModel.TRANGTHAI || x.NGUOITAO == searchModel.USER_ID);
}
}
if (!string.IsNullOrEmpty(searchModel.sortQuery))
{
queryResult = queryResult.OrderBy(searchModel.sortQuery);
}
else
{
queryResult = queryResult.OrderByDescending(x => x.ID).ThenByDescending(x => x.NGAYSUA);
}
}
PageListResultBO <DangKyXeBO> result = new PageListResultBO <DangKyXeBO>();
IPagedList <DangKyXeBO> pagedList = queryResult.ToPagedList(pageIndex, pageSize);
result.Count = pagedList.TotalItemCount;
result.TotalPage = pagedList.PageCount;
result.ListItem = pagedList.ToList();
result.ListItem.ForEach(x =>
{
if (x.NGAY_XUATPHAT != null)
{
x.THOIGIAN_XUATPHAT = string.Format("{0:dd/MM/yyyy}", x.NGAY_XUATPHAT);
if (x.GIO_XUATPHAT != null)
{
x.THOIGIAN_XUATPHAT += " " + x.GIO_XUATPHAT.Value.ToString("D2") + "h";
if (x.PHUT_XUATPHAT != null)
{
x.THOIGIAN_XUATPHAT += x.PHUT_XUATPHAT.Value.ToString("D2");
}
}
}
switch (x.TRANGTHAI.Value)
{
case TRANGTHAI_DANGKY_XE_CONSTANT.MOITAO_ID:
x.TEN_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.MOITAO_TEXT;
x.MAU_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.MOITAO_COLOR;
break;
case TRANGTHAI_DANGKY_XE_CONSTANT.DAGUI_ID:
x.TEN_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DAGUI_TEXT;
x.MAU_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DAGUI_COLOR;
break;
case TRANGTHAI_DANGKY_XE_CONSTANT.DA_HUY_ID:
x.TEN_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DA_HUY_TEXT;
x.MAU_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DA_HUY_COLOR;
break;
case TRANGTHAI_DANGKY_XE_CONSTANT.DANG_THUCHIEN_ID:
x.TEN_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DANG_THUCHIEN_TEXT;
x.MAU_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DANG_THUCHIEN_COLOR;
break;
case TRANGTHAI_DANGKY_XE_CONSTANT.DA_TIEPNHAN_ID:
x.TEN_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DA_TIEPNHAN_TEXT;
x.MAU_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DA_TIEPNHAN_COLOR;
break;
case TRANGTHAI_DANGKY_XE_CONSTANT.DA_HOANTHANH_ID:
x.TEN_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DA_HOANTHANH_TEXT;
x.MAU_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DA_HOANTHANH_COLOR;
break;
default:
break;
}
});
return(result);
}
