public ActionResult Index(string searchCriteria, string cityFilter, int?page) { SkiResortRepository SkiResortRepository = new SkiResortRepository(); ViewBag.Cities = ListOfCities(); IEnumerable <SkiResort> skiResorts; using (SkiResortRepository) { skiResorts = SkiResortRepository.SelectAll() as IList <SkiResort>; } if (searchCriteria != null) { skiResorts = skiResorts.Where(SkiResort => SkiResort.Name.ToUpper().Contains(searchCriteria.ToUpper())); } if (cityFilter != "" || cityFilter == null) { skiResorts = skiResorts.Where(s => s.City == cityFilter); } int pageSize = 5; int pageNumber = (page ?? 1); skiResorts = skiResorts.ToPagedList(pageNumber, pageSize); return(View(skiResorts)); }
public ActionResult Delete(int id) { SkiResortRepository srRepository = new SkiResortRepository(); SkiResort skiResort = new SkiResort(); using (srRepository) { skiResort = srRepository.SelectOne(id); } return(View(skiResort)); }
private IEnumerable <string> ListOfCities() { SkiResortRepository skiResortRepository = new SkiResortRepository(); IEnumerable <SkiResort> skiResorts; using (skiResortRepository) { skiResorts = skiResortRepository.SelectAll() as IList <SkiResort>; } var cities = skiResorts.Select(skiResort => skiResort.City).Distinct().OrderBy(x => x); return(cities); }
public ActionResult Delete(int id, SkiResort skiResort) { try { SkiResortRepository srRepository = new SkiResortRepository(); using (srRepository) { srRepository.Delete(id); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(SkiResort skiResort) { try { SkiResortRepository srRepository = new SkiResortRepository(); using (srRepository) { srRepository.Update(skiResort); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(SkiResort skiResortCollection) { try { SkiResortRepository Repository = new SkiResortRepository(); using (Repository) { Repository.Insert(skiResortCollection); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Index(string sortOrder, int?page) { SkiResortRepository skiResortRepository = new SkiResortRepository(); ViewBag.Cities = ListOfCities(); IEnumerable <SkiResort> skiResorts; using (skiResortRepository) { skiResorts = skiResortRepository.SelectAll() as IList <SkiResort>; } switch (sortOrder) { case "Name": skiResorts = skiResorts.OrderBy(s => s.Name); break; case "City": skiResorts = skiResorts.OrderBy(s => s.City); break; case "State": skiResorts = skiResorts.OrderBy(s => s.State); break; default: skiResorts = skiResorts.OrderBy(s => s.Name); break; } int pageSize = 5; int pageNumber = (page ?? 1); skiResorts = skiResorts.ToPagedList(pageNumber, pageSize); return(View(skiResorts)); }