public ActionResult Index(string searchCriteria, string enemyFilter, int?page) { WWEnemyRepository enemyRepository = new WWEnemyRepository(); ViewBag.Comics = ListOfComics(); IEnumerable <WWEnemy> wwEnemies; using (enemyRepository) { wwEnemies = enemyRepository.SelectAll() as IList <WWEnemy>; } //enemy name search if (searchCriteria != null) { wwEnemies = wwEnemies.Where(wwEnemy => wwEnemy.Name.ToUpper().Contains(searchCriteria.ToUpper())); } //comic search if (enemyFilter != "" || enemyFilter == null) { wwEnemies = wwEnemies.Where(wwEnemy => wwEnemy.Comic == enemyFilter); } int pageSize = 50; int pageNumber = (page ?? 1); wwEnemies = wwEnemies.ToPagedList(pageNumber, pageSize); return(View(wwEnemies)); }
private IEnumerable <string> ListOfComics() { // //instantiate the repository // WWEnemyRepository wwEnemyRepository = new WWEnemyRepository(); // //return as IEnumerable // IEnumerable <WWEnemy> wwEnemies; using (wwEnemyRepository) { wwEnemies = wwEnemyRepository.SelectAll() as IList <WWEnemy>; } // //distinct comic list // //var comics = wwEnemies.Select(w => w.Comic).Distinct().OrderBy(c => c); var comics = wwEnemies.Select(w => w.Comic).Distinct(); return(comics); }
public ActionResult Edit(int id) { WWEnemyRepository enemyRepository = new WWEnemyRepository(); WWEnemy wwEnemy = new WWEnemy(); using (enemyRepository) { wwEnemy = enemyRepository.SelectOne(id); } return(View(wwEnemy)); }
// GET: Enemies/Details/5 public ActionResult Details(int id) { //instantiate repository WWEnemyRepository wwEnemyRepository = new WWEnemyRepository(); WWEnemy wwEnemy = new WWEnemy(); using (wwEnemyRepository) { wwEnemy = wwEnemyRepository.SelectOne(id); } return(View(wwEnemy)); }
private int NextID() { WWEnemyRepository enemyRepository = new WWEnemyRepository(); IEnumerable <WWEnemy> wwEnemies; using (enemyRepository) { wwEnemies = enemyRepository.SelectAll() as IList <WWEnemy>; } int maxId = wwEnemies.Max(s => s.Id); return(maxId + 1); }
public ActionResult Delete(int id, FormCollection collection) { try { WWEnemyRepository enemyRepository = new WWEnemyRepository(); using (enemyRepository) { enemyRepository.Delete(id); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(WWEnemy wwEnemy) { try { WWEnemyRepository enemyRepository = new WWEnemyRepository(); using (enemyRepository) { enemyRepository.Update(wwEnemy); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(WWEnemy wwEnemy) { try { WWEnemyRepository enemyRepository = new WWEnemyRepository(); using (enemyRepository) { enemyRepository.Insert(wwEnemy); } return(RedirectToAction("Index")); } catch (Exception) { //Need Error message return(View()); } }
public ActionResult Index(string sortOrder, int?page) { WWEnemyRepository enemyRepository = new WWEnemyRepository(); // //create distinct comic list // ViewBag.Comics = ListOfComics(); IEnumerable <WWEnemy> wwEnemies; using (enemyRepository) { wwEnemies = enemyRepository.SelectAll() as IList <WWEnemy>; } switch (sortOrder) { case "Id": wwEnemies = wwEnemies.OrderBy(wwEnemy => wwEnemy.Id); break; case "Name": wwEnemies = wwEnemies.OrderBy(wwEnemy => wwEnemy.Name); break; default: wwEnemies = wwEnemies.OrderBy(wwEnemy => wwEnemy.Name); break; } int pageSize = 50; int pageNumber = (page ?? 1); wwEnemies = wwEnemies.ToPagedList(pageNumber, pageSize); return(View(wwEnemies)); }