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