public ActionResult DeleteConfirmation(int movieId)
 {
     Movie movieToShow = null;
     using (var db = new MovieReviewsEntities())
     {
         movieToShow = db.Movies.SingleOrDefault(m => m.MovieID == movieId);
     }
     return View(movieToShow);
 }
 public ActionResult Add(Movie model)
 {
     using (var db = new MovieReviewsEntities())
     {
         db.Movies.Add(model);
         db.SaveChanges();
     }
     return RedirectToAction("index", new { idOfChangedMovie = model.MovieID });
 }
 public ActionResult Edit(Movie movie)
 {
     if (ModelState.IsValid)
     {
         using (var db = new MovieReviewsEntities())
         {
             db.Movies.Attach(movie);
             db.Entry<Movie>(movie).State = System.Data.EntityState.Modified;
             db.SaveChanges();
         }
     }
     return View(movie);
 }
            public ActionResult Edit(int id)
            {
                Movie movie = null;

                using (var db = new MovieReviewsEntities())
                {
                    movie = db.Movies.Find(id);
                }

                if (movie == null)
                {
                    return HttpNotFound();
                }

                return View(movie);
            }
            public ActionResult Delete(int movieId)
            {
                using (var db = new MovieReviewsEntities())
                {
                    var movieToDelete = new Movie
                    {
                        MovieID = movieId
                    };

                    db.Movies.Attach(movieToDelete);

                    db.Movies.Remove(movieToDelete);
                    db.SaveChanges();
                }
                return RedirectToAction("Index");
            }
            //ALL OF THIS CODE IS FOR MOVIES ONLY
            public ActionResult Index(int? idOfChangedMovie)
            {
                /*
                var listOfMovies = new List<Movie>();
                foreach (var movie in (new MovieReviewsEntities()).Movies)
                {
                    listOfMovies.Add(movie);
                }*/
                using (var db = new MovieReviewsEntities())
                {
                    var Movies = db.Movies.ToList();
                }

                var view = new MovieIndexView
                {
                    Movies = (new MovieReviewsEntities()).Movies.ToList(),
                    IdOfChangedMovie = idOfChangedMovie
                };

                return View(view);
            }