// 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));
}
public BreweryManager(BaseRepo <Brewery> repo) : base(repo)
{
this.repo = repo as BreweryRepo;
}
