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