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));
}
