public ActionResult Search(ViewModelSearchDM_CANGCA SearchModel) { string ma_TinhTP = string.Empty; initialCategorySearchAction(SearchModel, ref ma_TinhTP); var DM_CANGCAs = db.DM_CANGCA.Where(o => (SearchModel.TEN_CANG == null || o.TEN_CANG.ToUpper().Contains(SearchModel.TEN_CANG.ToUpper())) && (SearchModel.DIA_CHI == null || o.DIA_CHI.ToUpper().Contains(SearchModel.DIA_CHI.ToUpper())) && ((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.DPHAN_LOAI_CANGID == null || o.DPHAN_LOAI_CANGID == SearchModel.DPHAN_LOAI_CANGID) ).Select(x => new { x.ID, x.MA_TINHTP, x.TEN_CANG, x.DIA_CHI, x.DIEN_THOAI, x.DPHAN_LOAI_CANG, x.DTINHTP, x.DQUANHUYEN, x.DPHUONGXA, x.Status }).OrderByDescending(x => x.ID) ; List <DM_CANGCA> DSDM_CANGCA = new List <DM_CANGCA>(); foreach (var dm_cangca in DM_CANGCAs) { DSDM_CANGCA.Add(new DM_CANGCA { ID = dm_cangca.ID, MA_TINHTP = dm_cangca.MA_TINHTP, TEN_CANG = dm_cangca.TEN_CANG, DIA_CHI = dm_cangca.DIA_CHI, DPHAN_LOAI_CANG = dm_cangca.DPHAN_LOAI_CANG, DIEN_THOAI = dm_cangca.DIEN_THOAI, DTINHTP = dm_cangca.DTINHTP, DQUANHUYEN = dm_cangca.DQUANHUYEN, DPHUONGXA = dm_cangca.DPHUONGXA, Status = dm_cangca.Status }); } ViewBag.TotalRow = DSDM_CANGCA.Count().ToString(); //Phân trang ở đây: var pageIndex = SearchModel.Page ?? 1; SearchModel.SearchResults = DSDM_CANGCA.ToPagedList(pageIndex, FDB.Common.Constants.PageSize); return(View(SearchModel)); }
public void initialCategorySearchAction(ViewModelSearchDM_CANGCA searchModel, ref string ma_Tinh) { ViewBag.PHAN_LOAI_CANG_CAs = new SelectList(db.DPHAN_LOAI_CANG, "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"); 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; }