public JsonResult getData(int indexPage, string sortQuery, int pageSize)
{
var searchModel = SessionManager.GetValue(KeySearchModelSession) as HoSoUngVienSearchDTO;
if (!string.IsNullOrEmpty(sortQuery))
{
if (searchModel == null)
{
searchModel = new HoSoUngVienSearchDTO();
}
searchModel.sortQuery = sortQuery;
if (pageSize > 0)
{
searchModel.pageSize = pageSize;
}
SessionManager.SetValue(KeySearchModelSession, searchModel);
}
var data = _hoSoUngVienService.GetDaTaByPage(searchModel, indexPage, pageSize);
return(Json(data));
}
public JsonResult searchData(FormCollection form)
{
var searchModel = SessionManager.GetValue(KeySearchModelSession) as HoSoUngVienSearchDTO;
if (searchModel == null)
{
searchModel = new HoSoUngVienSearchDTO();
searchModel.pageSize = 20;
}
searchModel.sea_HOTEN = form["sea_HOTEN"];
searchModel.sea_EMAIL = form["sea_EMAIL"];
searchModel.sea_DIENTHOAI = form["sea_DIENTHOAI"];
searchModel.sea_GIOITINH = form["sea_GIOITINH"];
searchModel.sea_NGAYSINH = form["sea_NGAYSINH"].ToDateTime();
searchModel.sea_YEUCAU = form["sea_YEUCAU"].ToIntOrZero();
searchModel.sea_DOT_ID = form["sea_DOT_ID"].ToIntOrZero();
SessionManager.SetValue(KeySearchModelSession, searchModel);
var data = _hoSoUngVienService.GetDaTaByPage(searchModel, 1, searchModel.pageSize);
return(Json(data));
}
public PageListResultBO <HoSoUngVienDTO> GetDaTaByPage(HoSoUngVienSearchDTO searchModel, int pageIndex = 1, int pageSize = 20)
{
var query = _HoSoUngVienRepository.GetAllAsQueryable();
if (searchModel != null)
{
if (!string.IsNullOrEmpty(searchModel.sea_HOTEN))
{
searchModel.sea_HOTEN = searchModel.sea_HOTEN.Trim().ToLower();
query = query.Where(x => x.HoTen.Trim().ToLower().Contains(searchModel.sea_HOTEN));
}
if (!string.IsNullOrEmpty(searchModel.sea_EMAIL))
{
searchModel.sea_EMAIL = searchModel.sea_EMAIL.Trim().ToLower();
query = query.Where(x => x.Email.Trim().ToLower().Contains(searchModel.sea_EMAIL));
}
if (!string.IsNullOrEmpty(searchModel.sea_DIENTHOAI))
{
searchModel.sea_DIENTHOAI = searchModel.sea_DIENTHOAI.Trim().ToLower();
query = query.Where(x => x.DienThoai.Trim().ToLower().Contains(searchModel.sea_DIENTHOAI));
}
if (searchModel.sea_GIOITINH != "")
{
query = query.Where(x => x.GioiTinh == searchModel.sea_GIOITINH);
}
if (searchModel.sea_NGAYSINH != null)
{
query = query.Where(x => x.NgaySinh == searchModel.sea_NGAYSINH);
}
if (searchModel.sea_DOT_ID > 0)
{
query = query.Where(x => x.IDDotTuyenDung == searchModel.sea_DOT_ID);
}
if (searchModel.sea_YEUCAU > 0)
{
query = query.Where(x => x.IdYeuCauTuyenDung == searchModel.sea_YEUCAU);
}
if (!string.IsNullOrEmpty(searchModel.sortQuery))
{
query = query.OrderBy(searchModel.sortQuery);
}
else
{
query = query.OrderByDescending(x => x.Id);
}
}
else
{
query = query.OrderByDescending(x => x.Id);
}
var resultmodel = new PageListResultBO <TD_HoSoUngVien>();
if (pageSize == -1)
{
var dataPageList = query.ToList();
resultmodel.Count = dataPageList.Count;
resultmodel.TotalPage = 1;
resultmodel.ListItem = dataPageList;
}
else
{
var dataPageList = query.ToPagedList(pageIndex, pageSize);
resultmodel.Count = dataPageList.TotalItemCount;
resultmodel.TotalPage = dataPageList.PageCount;
resultmodel.ListItem = dataPageList.ToList();
}
return(_imapper.Map <PageListResultBO <HoSoUngVienDTO> >(resultmodel));
}
