public async Task <IActionResult> Index() { var movies = from m in _context.Movie orderby m.MovieReleaseDate descending select m; //-------------------------------------------------------------------------------------------------------------- ControllerBase BaseMethod = new ControllerBase(_context); var MovieVM = new List <Movie>(); MovieVM = await movies.ToListAsync(); var moviesCateg = from m in _context.MovieCategory select m; var categ = from m in _context.Category select m; var MovieCategoryVM = new List <Movie_Category>(); MovieCategoryVM = await moviesCateg.ToListAsync(); var CategoryVM = new List <Category>(); CategoryVM = await categ.ToListAsync(); List <MovieWCategories> movieWCategories = new List <MovieWCategories>(); movieWCategories = await BaseMethod.JoinMovies(null, null, true); //-------------------------------------------------------------------------------------------------------------- List <CategoryCount> CategoryCounts = new List <CategoryCount>(); CategoryCounts = await BaseMethod.NumberOfCategories(MovieCategoryVM, CategoryVM); var movieGenreVM = new ShowMovieModel { Movies = movieWCategories, Categories = CategoryCounts }; return(View(movieGenreVM)); }
// GET: Movie public async Task <IActionResult> Index(string MovieGenre, string searchString) { //Use LINQ to get list of genres. IQueryable <string> genreQuery = from m in _context.Category orderby m.CategoryName select m.CategoryName; ControllerBase BaseMethod = new ControllerBase(_context); List <MovieWCategories> movieWCategories = new List <MovieWCategories>(); movieWCategories = await BaseMethod.JoinMovies(MovieGenre, searchString, false); var movieGenreVM = new ShowMovieModel { SelectCategories = new SelectList(await genreQuery.Distinct().ToListAsync()), Movies = movieWCategories }; return(View(movieGenreVM)); }