public void AddActor(Actor actorToAdd) { using (var db = new MovieReviewsEntities()) { db.Actors.Add(actorToAdd); db.SaveChanges(); } }
public void AddMovie(Movie movieToAdd) { using (var db = new MovieReviewsEntities()) { db.Movies.Add(movieToAdd); db.SaveChanges(); } }
public void UpdateActor(Actor actorToEdit) { using (var db = new MovieReviewsEntities()) { db.Actors.Attach(actorToEdit); db.Entry<Actor>(actorToEdit).State = System.Data.EntityState.Modified; db.SaveChanges(); } }
public Movie findOneMovie(int movieId) { Movie movie = null; using (var db = new MovieReviewsEntities()) { movie = db.Movies.SingleOrDefault(m => m.MovieID == movieId); } return movie; }
public Movie Find(int movieId) { Movie movieToShow = null; using (var db = new MovieReviewsEntities()) { movieToShow = db.Movies.SingleOrDefault(m => m.MovieID == movieId); } return movieToShow; }
public ActionResult Add(MovieReview model) { using (var db = new MovieReviewsEntities()) { db.MovieReviews.Add(model); db.SaveChanges(); } return RedirectToAction("index", new { movieId = model.MovieID }); //How do I return this to a view operated by a different controller? Or would I never really want to? }
public Actor Find(int id) { Actor actorToShow = null; using (var db = new MovieReviewsEntities()) { actorToShow = db.Actors.Find(id); } return actorToShow; }
public List<Movie> findAllMovies() { List<Movie> allMovies = new List<Movie>(); using (var db = new MovieReviewsEntities()) { allMovies = (new MovieReviewsEntities()).Movies.ToList(); } return allMovies; }
public ActionResult deleteConfirmation(int reviewId) { MovieReview reviewToShow = null; using (var db = new MovieReviewsEntities()) { reviewToShow = db.MovieReviews.SingleOrDefault(m => m.MovieReviewID == reviewId); } return View(reviewToShow); }
//Can I use some of these methods with movies and reviews? public List<Actor> ListAll() { List<Actor> actorList = new List<Actor>(); using (var db = new MovieReviewsEntities()) { var actors = from a in db.Actors select a; foreach(var a in actors) actorList.Add(a); }; return actorList; }
public void DeleteActor(int actorId) { using (var db = new MovieReviewsEntities()) { var actorToDelete = new Actor { ActorID = actorId }; db.Actors.Attach(actorToDelete); db.Actors.Remove(actorToDelete); db.SaveChanges(); } }
public ActionResult Add(int movieId) { //Note difference anonymous and defined type as below //var movie = (var db ) ReviewsAddView view = new ReviewsAddView(); view.MovieReview.MovieID = movieId; using(var db = new MovieReviewsEntities()){ view.MovieTitle = db.Movies.Single(m => m.MovieID == movieId).Title; } return View(view); //movieTitle); }
public ActionResult Delete(int moviereviewId) { using (var db = new MovieReviewsEntities()) { var reviewToDelete = new MovieReview { MovieReviewID = moviereviewId }; db.MovieReviews.Attach(reviewToDelete); db.MovieReviews.Remove(reviewToDelete); db.SaveChanges(); } return RedirectToAction("Index"); }
public void addActorToMovie(int movieId, int actorId) { MovieActor movieActorEntity = new MovieActor { MovieID = movieId, ActorID = actorId }; using (var db = new MovieReviewsEntities()) { db.MovieActors.Add(movieActorEntity); db.SaveChanges(); } }
public void Delete(int movieId) { using (var db = new MovieReviewsEntities()) { var movieToDelete = new Movie { MovieID = movieId }; db.Movies.Attach(movieToDelete); db.Movies.Remove(movieToDelete); db.SaveChanges(); } }
/* public Movie findOneMovie(int movieId) { Movie movie = null; using (var db = new MovieReviewsEntities()) { movie = db.Movies.SingleOrDefault(m => m.MovieID == movieId); } return movie; }*/ public List<Actor> findActorsInmovie(int movieId) { List<Actor> listOfActors = null; using (var db = new MovieReviewsEntities()) { listOfActors = (from ma in db.MovieActors where ma.MovieID == movieId select ma.Actor).ToList(); //NOTE EVERYTHING BELOW AS TO WAYS TO SOLVE SAME PROBLEM //listOfActors = db.MovieActors.Where(ma => ma.MovieID == movieId).Select(ma => ma.Actor).ToList(); //var foo = db.MovieActors // .Include(ma => ma.Actor) // .Include(ma => ma.MovieID) // .Where(ma => ma.MovieID == movieId) // .ToList(); } return listOfActors; }
public ActionResult About() { string longMovieString = ""; MovieReviewsEntities movies1 = new MovieReviewsEntities(); using (var context = new MovieReviewsEntities()) { var contacts = context.Movies; foreach (var movie in contacts) { longMovieString += movie.Title + ", "; } } ViewBag.Message = longMovieString; return View(); }
public int removeActorFrommovie(int movieId, int actorId) { MovieActor actorToRemoveFromMovie = new MovieActor(); using (var db = new MovieReviewsEntities()) { actorToRemoveFromMovie.MovieActorID = db.MovieActors.First(m => m.MovieID == movieId & m.ActorID == actorId).MovieActorID; //} //using (var db = new MovieReviewsEntities()) //{ // //listOfActors = db.MovieActors.Where(ma => ma.MovieID == movieId).Select(ma => ma.Actor).ToList(); //db.MovieActors.Attach(actorToRemoveFromMovie); db.MovieActors.Remove(actorToRemoveFromMovie); db.SaveChanges(); } return actorToRemoveFromMovie.MovieID; }
public List<Actor> displayAllActorsInMovie(int movieId) { List<Actor> AllActors = null; using (var db = new MovieReviewsEntities()) { var allActors = from a in db.Actors select a; var allMovieActorsInMovie = from a in db.MovieActors where a.MovieID == movieId select a; foreach (var actor in allActors) { foreach (var movieactor in allMovieActorsInMovie) if (actor.ActorID == movieactor.ActorID) AllActors.Add(actor); } } return AllActors; }
// // GET: /Reviews/ public ActionResult Index(int movieId) { var reviewsIndex = new ReviewsIndexView(); using (var db = new MovieReviewsEntities()) { reviewsIndex.Movie = db.Movies.SingleOrDefault(m => m.MovieID == movieId); var rev = from r in db.MovieReviews where r.MovieID == movieId select r; reviewsIndex.Reviews = new List<MovieReview>(); foreach (var r in rev) { reviewsIndex.Reviews.Add(r); } //db.MovieReviews.Where(m => m.MovieID == movieId).Select(); //reviewsIndex.Reviews = db.MovieReviews.Where(m => m.MovieID == movieId).Select(m => m.Review).ToList(); } return View(reviewsIndex); }
public void Update(Movie movieToUpdate) { using (var db = new MovieReviewsEntities()) { db.Movies.Attach(movieToUpdate); db.Entry<Movie>(movieToUpdate).State = System.Data.EntityState.Modified; db.SaveChanges(); } }