// GET: Brewery public ActionResult Index(string sortOrder) { IEnumerable <Brewery> breweries; BreweryRepo breweryRepo = new BreweryRepo(); ViewBag.Cities = ListOfCities(); using (breweryRepo) { breweries = breweryRepo.SelectAll() as IList <Brewery>; } switch (sortOrder) { case "Name": breweries = breweries.OrderBy(Brewery => Brewery.Name); break; case "City": breweries = breweries.OrderBy(Brewry => Brewry.City); break; case "URL": breweries = breweries.OrderBy(Brewry => Brewry.URL); break; } return(View(breweries)); }
private IEnumerable <string> ListOfCities() { BreweryRepo breweries = new BreweryRepo(); IEnumerable <Brewery> brewerys; using (breweries) { brewerys = breweries.SelectAll() as IList <Brewery>; } var cities = brewerys.Select(b => b.City).Distinct().OrderBy(x => x); return(cities); }
public ActionResult Index(string searchCriteria, string cityFilter) { BreweryRepo brew = new BreweryRepo(); ViewBag.Cities = ListOfCities(); IEnumerable <Brewery> brewery; using (brew) { brewery = brew.SelectAll() as IList <Brewery>; } if (searchCriteria != null) { brewery = brewery.Where(b => b.Name.ToUpper().Contains(searchCriteria.ToUpper())); } return(View(brewery)); }