public Model.Movie GetMovie(int movieId) { using (var db = new MoviesContext()) { return db.Movies.Where(x => x.MovieId == movieId).FirstOrDefault(); } }
public bool AddMovie(Model.Movie movie) { if (movie != null) { using (var db = new MoviesContext()) { db.Movies.Add(movie); db.SaveChanges(); return true; } } else return false; }
public bool DeleteMovie(int movieId) { using (var db = new MoviesContext()) { var movie = db.Movies.Where(x => x.MovieId == movieId).FirstOrDefault(); if (movie != null) { db.Movies.Remove(movie); db.SaveChanges(); return true; } else return false; } }
public ICollection<Model.Movie> GetAllMovies() { IQueryable<Movie> movies; using (var db = new MoviesContext()) { movies = db.Movies; if (movies.Any() == false) { return null; } else { return movies.ToList(); } } }
public bool UpdateMovie(int movieId, Model.Movie movie) { if (movie == null) { throw new ArgumentNullException("movie"); } using (var db = new MoviesContext()) { var movieToUpdate = db.Movies.Where(x => x.MovieId == movie.MovieId).FirstOrDefault(); if (movieToUpdate != null) { movieToUpdate.Title = movie.Title;//perform validations. movieToUpdate.Genre = movie.Genre; movieToUpdate.ReleaseDate = movie.ReleaseDate; movieToUpdate.Rating = movie.Rating; db.Entry(movieToUpdate).State = EntityState.Modified; db.SaveChanges(); return true; } else return false; } }