public void initialCategorySearchAction(ViewModelSearchNT_THIETHAI searchModel, ref string ma_Tinh)
{
ViewBag.DM_DOITUONG_NUOIs = new SelectList(db.DM_DOITUONG_NUOI_THIETHAI, "ID", "Name");
//ViewBag.DTINHTPs = new SelectList(db.DTINHTP, "MA_TINHTP", "TEN_TINHTP");
ApplicationUser curUser = getCurrentUser();
var tinh = db.DTINHTP.Where(u => curUser.MA_TINHTP.StartsWith("Z") || u.MA_TINHTP == curUser.MA_TINHTP).Except(db.DTINHTP.Where(d => d.MA_TINHTP.StartsWith("Z") == true));
ViewBag.DTINHTPs = new SelectList(tinh, "MA_TINHTP", "TEN_TINHTP");
ViewBag.DNGUYENNHAN_THIETHAIs = new SelectList(db.DNGUYENNHAN_THIETHAI, "ID", "Name");
ViewBag.DTYLE_THIETHAIs = new SelectList(db.DTYLE_THIETHAI, "ID", "Name");
var quanhuyen = db.DQUANHUYEN.Where(d => d.MA_TINHTP == searchModel.MA_TINHTP);
var phuongxa = db.DPHUONGXA.Where(d => d.MA_QUANHUYEN == searchModel.MA_QUANHUYEN);
ViewBag.QUAN_HUYENs = new SelectList(quanhuyen, "MA_QUANHUYEN", "TEN_QUANHUYEN");
ViewBag.PHUONG_XAs = new SelectList(phuongxa, "MA_PHUONGXA", "TEN_PHUONGXA");
ViewBag.DEFAULT_VALUE_DDL = CategoryCommon.DEFAULT_VALUE_DDL;
ma_Tinh = curUser.MA_TINHTP;
}
public ActionResult Search(ViewModelSearchNT_THIETHAI SearchModel)
{
string ma_TinhTP = string.Empty;
initialCategorySearchAction(SearchModel, ref ma_TinhTP);
var NT_THIETHAIs = db.NT_THIETHAI.Where(o =>
(SearchModel.DM_DOITUONG_NUOI_THIETHAIID == null || o.DM_DOITUONG_NUOI_THIETHAIID == SearchModel.DM_DOITUONG_NUOI_THIETHAIID) &&
((string.IsNullOrEmpty(SearchModel.MA_TINHTP) && ma_TinhTP.StartsWith("Z")) || (string.IsNullOrEmpty(SearchModel.MA_TINHTP) && o.MA_TINHTP == ma_TinhTP) || o.MA_TINHTP == SearchModel.MA_TINHTP) &&
(SearchModel.MA_QUANHUYEN == null || o.MA_QUANHUYEN == SearchModel.MA_QUANHUYEN) &&
(SearchModel.MA_PHUONGXA == null || o.MA_PHUONGXA == SearchModel.MA_PHUONGXA) &&
(SearchModel.DTYLE_THIETHAIID == null || o.DTYLE_THIETHAIID == SearchModel.DTYLE_THIETHAIID) &&
(SearchModel.THANG == null || o.THANG == SearchModel.THANG) &&
(SearchModel.NAM == null || o.NAM == SearchModel.NAM) &&
(SearchModel.DO_MOITRUONG == null || o.DO_MOITRUONG == SearchModel.DO_MOITRUONG) &&
(SearchModel.DO_DICHBENH == null || o.DO_DICHBENH == SearchModel.DO_DICHBENH)
// && (SearchModel.DNGUYENNHAN_THIETHAIID == null || o.DNGUYENNHAN_THIETHAIID == SearchModel.DNGUYENNHAN_THIETHAIID)
).Select(x => new { x.ID, x.DM_DOITUONG_NUOI_THIETHAI, x.DIENTICH_THIETHAI, x.SANLUONG_THIETHAI, x.THIETHAI_UOCTINH, x.DTYLE_THIETHAI, x.DTINHTP, x.DQUANHUYEN, x.DPHUONGXA, x.THANG, x.NAM }).OrderByDescending(x => x.ID)
;
List <NT_THIETHAI> DSNT_THIETHAI = new List <NT_THIETHAI>();
foreach (var nt_thiethai in NT_THIETHAIs)
{
DSNT_THIETHAI.Add(new NT_THIETHAI
{
ID = nt_thiethai.ID,
DM_DOITUONG_NUOI_THIETHAI = nt_thiethai.DM_DOITUONG_NUOI_THIETHAI,
DIENTICH_THIETHAI = nt_thiethai.DIENTICH_THIETHAI,
SANLUONG_THIETHAI = nt_thiethai.SANLUONG_THIETHAI,
THIETHAI_UOCTINH = nt_thiethai.THIETHAI_UOCTINH,
DTYLE_THIETHAI = nt_thiethai.DTYLE_THIETHAI,
//DNGUYENNHAN_THIETHAI = nt_thiethai.DNGUYENNHAN_THIETHAI,
DTINHTP = nt_thiethai.DTINHTP,
DQUANHUYEN = nt_thiethai.DQUANHUYEN,
DPHUONGXA = nt_thiethai.DPHUONGXA,
THANG = nt_thiethai.THANG,
NAM = nt_thiethai.NAM
});
}
ViewBag.TotalRow = DSNT_THIETHAI.Count().ToString();
//Phân trang ở đây:
var pageIndex = SearchModel.Page ?? 1;
SearchModel.SearchResults = DSNT_THIETHAI.ToPagedList(pageIndex, FDB.Common.Constants.PageSize);
return(View(SearchModel));
}
