// GET: Movies
public async Task <IActionResult> Index(string searchString, string movieGenre)
{
IQueryable <string> genreQuery = from m in _context.Movie
orderby m.Genre
select m.Genre;
var movies = from m in _context.Movie select m;
if (!String.IsNullOrEmpty(searchString))
{
movies = movies.Where(s => s.Title.Contains(searchString));
}
if (!String.IsNullOrEmpty(movieGenre))
{
movies = movies.Where(x => x.Genre == movieGenre);
}
var movieGenreVM = new MovieGenreModel {
Genres = new SelectList(await genreQuery.Distinct().ToListAsync()),
Movies = await movies.ToListAsync()
};
return(View(movieGenreVM));
}
public IActionResult Index(string movieGenre, string search)
{
IEnumerable <string> genreList = from m in _repository.Get()
orderby m.Genre
select m.Genre;
var movies = from m in _repository.Get()
select m;
if (!string.IsNullOrEmpty(search))
{
movies = movies.Where(s => s.Title.Contains(search));
}
if (!string.IsNullOrEmpty(movieGenre))
{
movies = movies.Where(x => x.Genre == movieGenre);
}
var genreModel = new MovieGenreModel
{
Genres = new SelectList(genreList.Distinct().ToList()),
Movies = movies.ToList()
};
return(View(genreModel));
}
public bool UpdateMovieGenre(MovieGenreModel movieGenre)
{
var updateMovieGenre = _context.MovieGenres.OrderByDescending(a => a.Id == movieGenre._id).FirstOrDefault();
updateMovieGenre.Id = movieGenre._id;
updateMovieGenre.Name = movieGenre.name;
_context.MovieGenres.Update(updateMovieGenre);
return(true);
}
public bool AddMovieGenre(MovieGenreModel movieGenre)
{
var newId = _context.MovieGenres.OrderByDescending(a => a.Id).FirstOrDefault().Id + 1;
_context.MovieGenres.Add(new MovieGenre {
Id = movieGenre._id, Name = movieGenre.name
});
return(true);
}
public IActionResult UpdateMovieGenre([FromBody] MovieGenreModel model)
{
if (_MovieGenreService.UpdateMovieGenre(model))
{
return(Ok());
}
else
{
return(BadRequest(new { message = "Movie Genre could not be updated." }));
}
}
public MovieGenreModel GetSingle(int id)
{
var gen = _context.MovieGenres.Find(id);
var genre = new MovieGenreModel
{
_id = gen.Id,
name = gen.Name,
};
return(genre);
}
public IEnumerable <MovieGenreModel> GetAll()
{
var genres = new List <MovieGenreModel>();
foreach (var genre in _context.MovieGenres.OrderBy(a => a.Id))
{
var gen = new MovieGenreModel
{
_id = genre.Id,
name = genre.Name,
};
genres.Add(gen);
}
return(genres);
}
