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