public ActionResult DanhSachTinRao()
        {
            if (TempData["success"] != null)
            {
                ViewBag.Success = TempData["success"].ToString();
                TempData.Remove("success");
            }
            if (TempData["error"] != null)
            {
                ViewBag.Error = TempData["error"].ToString();
                TempData.Remove("error");
            }
            var userId = User.Identity.GetUserId();

            var viewModel = new DanhSachTinRaoViewModel
            {
                TinRaoBDSs = _context.TinRaoBDSs.Include(x => x.TinhThanhPho).Include(x => x.QuanHuyen)
                             .Include(x => x.LoaiNhaDat).Where(x => x.Account.Id == userId).ToList(),
                TinhThanhPhos   = _context.TinhThanhPhos.ToList(),
                QuanHuyens      = _context.QuanHuyens.ToList(),
                LoaiTinRaoBDS   = SelectOptions.getLoaiTinRaoBDS,
                LoaiNhaDats     = _context.LoaiNhaDats.ToList(),
                TrangThaiTinRao = SelectOptions.getTrangThaiTinRao,
                ThoiHanDangTins = SelectOptions.getThoiHanDangTin,
                DienTichs       = SelectOptions.getDienTich,
                KhoangGias      = SelectOptions.getKhoangGia
            };

            return(View("DanhSachTinRao", viewModel));
        }
        // GET: TinRao
        public ActionResult Index()
        {
            var viewModel = new DanhSachTinRaoViewModel
            {
                TinRaoBDSs      = _context.TinRaoBDSs.Include(x => x.LoaiNhaDat).ToList(),
                TinhThanhPhos   = _context.TinhThanhPhos.ToList(),
                QuanHuyens      = _context.QuanHuyens.ToList(),
                LoaiTinRaoBDS   = SelectOptions.getLoaiTinRaoBDS,
                LoaiNhaDats     = _context.LoaiNhaDats.ToList(),
                TrangThaiTinRao = SelectOptions.getTrangThaiTinRao,
                DienTichs       = SelectOptions.getDienTich,
                KhoangGias      = SelectOptions.getKhoangGia
            };

            return(View(viewModel));
        }
        public ActionResult GetByLoaiTinRao(int?loaiTinRaoId)
        {
            var viewModel = new DanhSachTinRaoViewModel
            {
                TinRaoBDSs = _context.TinRaoBDSs.Include(x => x.TinhThanhPho).Include(x => x.QuanHuyen)
                             .Include(x => x.LoaiNhaDat)
                             .Where(x => x.LoaiTinRao == loaiTinRaoId).ToList(),
                TinhThanhPhos   = _context.TinhThanhPhos.ToList(),
                QuanHuyens      = _context.QuanHuyens.ToList(),
                LoaiTinRaoBDS   = SelectOptions.getLoaiTinRaoBDS,
                LoaiNhaDats     = _context.LoaiNhaDats.ToList(),
                TrangThaiTinRao = SelectOptions.getTrangThaiTinRao,
                ThoiHanDangTins = SelectOptions.getThoiHanDangTin,
                DienTichs       = SelectOptions.getDienTich,
                KhoangGias      = SelectOptions.getKhoangGia
            };

            return(View("Index", viewModel));
        }
        // GET: Admin/QuanLyTinRao
        public ActionResult Index()
        {
            if (TempData["success"] != null)
            {
                ViewBag.Success = TempData["success"].ToString();
                TempData.Remove("success");
            }
            if (TempData["error"] != null)
            {
                ViewBag.Error = TempData["error"].ToString();
                TempData.Remove("error");
            }

            var viewModel = new DanhSachTinRaoViewModel
            {
                TinRaoBDSs      = _context.TinRaoBDSs.Include(x => x.LoaiNhaDat).ToList(),
                TinhThanhPhos   = _context.TinhThanhPhos.ToList(),
                QuanHuyens      = _context.QuanHuyens.ToList(),
                LoaiTinRaoBDS   = SelectOptions.getLoaiTinRaoBDS,
                TrangThaiTinRao = SelectOptions.getTrangThaiTinRao
            };

            return(View(viewModel));
        }
        public ActionResult Search(string keyWord, int?loaiNhaDatId, int?tinhThanhPhoId, int?quanHuyenId, int?dienTichId, int?khoangGiaId)
        {
            var viewModel = new DanhSachTinRaoViewModel
            {
                TinhThanhPhos = _context.TinhThanhPhos.ToList(),
                QuanHuyens    = _context.QuanHuyens.Include(x => x.TinhThanhPho).ToList(),
                LoaiNhaDats   = _context.LoaiNhaDats.ToList(),
                DienTichs     = SelectOptions.getDienTich,
                KhoangGias    = SelectOptions.getKhoangGia
            };

            //if (keyWord != null)
            //{
            //    viewModel.KeyWord = keyWord;
            //    viewModel.NhaDats = viewModel.NhaDats.Where(x => x.Ten.Contains(keyWord) || x.ThongTinMoTa.Contains(keyWord)
            //    || x.TuKhoa.Contains(keyWord) || x.DuAn.TenDuAn.Contains(keyWord) || x.LoaiNhaDat.TenLoai.Contains(keyWord));
            //}

            if (!string.IsNullOrWhiteSpace(keyWord))
            {
                viewModel.KeyWord    = keyWord;
                viewModel.TinRaoBDSs = viewModel.TinRaoBDSs.Where(x => x.ThongTinMoTa.Contains(keyWord));
            }

            if (loaiNhaDatId.HasValue)
            {
                viewModel.LoaiNhaDatId = loaiNhaDatId.Value;
                viewModel.TinRaoBDSs   = viewModel.TinRaoBDSs.Where(x => x.LoaiNhaDat.Id == loaiNhaDatId);
            }

            if (tinhThanhPhoId.HasValue)
            {
                viewModel.TinhThanhPhoId = tinhThanhPhoId.Value;
                viewModel.TinRaoBDSs     = viewModel.TinRaoBDSs.Where(x => x.TinhThanhPho.Id == tinhThanhPhoId);
            }

            if (quanHuyenId.HasValue)
            {
                viewModel.QuanHuyenId = quanHuyenId.Value;
                viewModel.TinRaoBDSs  = viewModel.TinRaoBDSs.Where(x => x.QuanHuyen.Id == quanHuyenId);
            }

            if (dienTichId.HasValue)
            {
                viewModel.DienTichId = dienTichId.Value;
                switch (dienTichId)
                {
                case 1:
                    viewModel.TinRaoBDSs = viewModel.TinRaoBDSs.Where(x => x.DienTich < 20);
                    break;

                case 2:
                    viewModel.TinRaoBDSs = viewModel.TinRaoBDSs.Where(x => x.DienTich >= 20 && x.DienTich <= 50);
                    break;

                case 3:
                    viewModel.TinRaoBDSs = viewModel.TinRaoBDSs.Where(x => x.DienTich >= 50 && x.DienTich <= 100);
                    break;

                case 4:
                    viewModel.TinRaoBDSs = viewModel.TinRaoBDSs.Where(x => x.DienTich > 100);
                    break;
                }
            }

            if (khoangGiaId.HasValue)
            {
                viewModel.KhoangGiaId = khoangGiaId.Value;
                switch (khoangGiaId)
                {
                case 1:
                    viewModel.TinRaoBDSs = viewModel.TinRaoBDSs.Where(x => x.GiaTien < 2000000);
                    break;

                case 2:
                    viewModel.TinRaoBDSs = viewModel.TinRaoBDSs.Where(x => x.GiaTien >= 2000000 || x.GiaTien <= 5000000);
                    break;

                case 3:
                    viewModel.TinRaoBDSs = viewModel.TinRaoBDSs.Where(x => x.GiaTien > 5000000 && x.GiaTien < 500000000);
                    break;

                case 4:
                    viewModel.TinRaoBDSs = viewModel.TinRaoBDSs.Where(x => x.GiaTien < 500000000 || x.GiaTien < 500000000);
                    break;

                case 5:
                    viewModel.TinRaoBDSs = viewModel.TinRaoBDSs.Where(x => (x.GiaTien >= 500000000 && x.GiaTien < 2000000000) || (x.GiaTien >= 500000000 && x.GiaTien < 2000000000));
                    break;

                case 6:
                    viewModel.TinRaoBDSs = viewModel.TinRaoBDSs.Where(x => x.GiaTien > 2000000000);
                    break;
                }
            }

            return(View("Index", viewModel));
        }