public async Task <IActionResult> Search(string search) { var h = from m in _context.TblHamper select m; if (!String.IsNullOrEmpty(search)) { h = h.Where(s => s.HamperName.Contains(search) || s.Details.Contains(search)); IEnumerable <Category> cat = _catDataService.GetAll(); IEnumerable <SelectListItem> items = _context.TblCategory.Select(c => new SelectListItem { Value = c.CategoryId.ToString(), Text = c.CategoryName }); ViewBag.CategoryName = items; HamperSearchViewModel vm = new HamperSearchViewModel { Hampers = h, SearchHamper = search, Categories = cat }; IEnumerable <Hamper> hamp = vm.Hampers; if (h.Select(a => a.HamperId).FirstOrDefault() == 0) { return(RedirectToAction("NotFound", "Hamper")); } return(View(vm)); } return(View()); }
public IEnumerable <Hamper> Get() { var h = from m in _context.TblHamper select m; HamperSearchViewModel vm = new HamperSearchViewModel { Hampers = h, }; return(h); }
public IEnumerable <Hamper> Get(string search) { var h = from m in _context.TblHamper select m; if (!String.IsNullOrEmpty(search)) { h = h.Where(s => s.HamperName.Contains(search) || s.Details.Contains(search)); HamperSearchViewModel vm = new HamperSearchViewModel { Hampers = h, }; return(h); } return(null); }
public IActionResult Search(int searchMin, int searchMax, HamperSearchViewModel vm) { var h = from m in _context.TblHamper select m; string search = vm.SearchHamper; if (vm.Categories.Select(c => c.CategoryId).FirstOrDefault() != 0) { vm.Hampers = h.Where(p => p.CategoryId == vm.CategoryId); } h = h.Where(s => s.HamperName.Contains(search) || s.Details.Contains(search)); vm.Hampers = h.Where((p => (p.Price >= searchMin) && (p.Price <= searchMax))); if (h.Select(a => a.HamperId).FirstOrDefault() == 0) { return(RedirectToAction("NotFound", "Hamper")); } return(View(vm)); }