// GET: Albums
public async Task <IActionResult> Index(string albumGenre, string searchString)
{
// Use LINQ to get list of genres.
IQueryable <string> genreQuery = from a in _context.Album
orderby a.Genre
select a.Genre;
var albums = from a in _context.Album
select a;
if (!String.IsNullOrEmpty(searchString))
{
albums = albums.Where(s => s.Title.Contains(searchString));
}
if (!String.IsNullOrEmpty(albumGenre))
{
albums = albums.Where(x => x.Genre == albumGenre);
}
var albumGenreVM = new AlbumGenreViewModel();
albumGenreVM.genres = new SelectList(await genreQuery.Distinct().ToListAsync());
albumGenreVM.albums = await albums.ToListAsync();
return(View(albumGenreVM));
}
// GET: StoreManager
public async Task <IActionResult> Index(string searchString, string albumGenre)
{
var albums = from a in _dbContext.Albums select a;
var genreQuery = from a in _dbContext.Albums orderby a.Genre select a.Genre;
if (!String.IsNullOrEmpty(searchString))
{
albums = albums.Where(a => a.Title.Contains(searchString));
}
if (!string.IsNullOrEmpty(albumGenre))
{
albums = albums.Where(x => x.Genre == albumGenre);
}
var albumGenreVM = new AlbumGenreViewModel
{
Genres = new SelectList(await genreQuery.Distinct().ToListAsync()),
Albums = await albums.ToListAsync()
};
return(View(albumGenreVM));
}
