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