public ActionResult RateMovie(RateMovieCarrier rateMovie) { var ops = new DVDLibraryOperations(); ops.AddUserReview(rateMovie.Rating, rateMovie.MovieID, rateMovie.UserID, rateMovie.Note); var userRentalsVM = new RentalListViewModel(ops.GetUserOutForRent(rateMovie.UserID)); return View("UserRentalList", userRentalsVM); }
public void AddUserReviewTests(int Rating, int MovieID, int UserID, string NoteDescription, int noteCountAdder) { var ops = new DVDLibraryOperations(); var ratingCountBefore = 0; var ratingCountAfter = 0; var noteCountBefore = 0; var noteCountAfter = 0; using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { ratingCountBefore = cn.Query<RatingModel>("SELECT * FROM MovieRatings").Count(); noteCountBefore = cn.Query<Note>("SELECT * FROM Notes").Count(); ops.AddUserReview(Rating, MovieID, UserID, NoteDescription); ratingCountAfter = cn.Query<RatingModel>("SELECT * FROM MovieRatings").Count(); noteCountAfter = cn.Query<Note>("SELECT * FROM Notes").Count(); } // Rating count should increase in both cases Assert.AreEqual(ratingCountBefore + 1, ratingCountAfter); // Note count should only increase with a valid note. Assert.AreEqual(noteCountBefore + noteCountAdder, noteCountAfter); }