public void AddMovieToDBTest()
{
var movie = new AddMovieCarrier();
movie.Title = "Friday";
movie.DateReleased = DateTime.Parse("11/02/1995");
movie.MPAARatingID = "4";
movie.GenreID = "5";
movie.RunTime = "120";
movie.StudioID = "1";
movie.Synopsis =
"Two homies, Smokey and Craig, smoke up a dope dealers weed and try to figure a way to get the $200 they owe the dope dealer by 10:00pm that night. In that time they smoke weed, get jacked, and they get shot at in a drive-by.";
movie.OwnerRatingID = "5";
movie.Copies = "2";
movie.ImageURL = "http://www.imdb.com/media/rm3404111360/tt0113118?ref_=tt_ov_i";
movie.DirectorID = new List<string>() {"1", "2"};
movie.ActorID = new List<string>() {"1", "2", "3"};
var ops = new DVDLibraryOperations();
ops.AddMovie(movie);
var movieAdded = new ViewMovieCarrier();
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
movieAdded = cn.Query<ViewMovieCarrier>("SELECT * FROM Movies m WHERE m.Title = 'Friday'").FirstOrDefault();
}
Assert.AreEqual(movieAdded.Title, movie.Title);
}
public RentMovieLongViewModel(MovieReviewsNotes ratings, ViewMovieCarrier movie)
{
Movie = movie;
RatingsPackage = ratings;
NumberOfReviews = RatingsPackage.RatingsList.Count();
try
{
UserRatingsAverage = Math.Truncate(RatingsPackage.RatingsList.Average()*100)/100;
}
catch
{
UserRatingsAverage = 0;
}
}
public ViewMovieViewModel(ViewMovieCarrier movie)
{
this.movie = movie;
}
public ViewMovieCarrier GetMovieDetails(int Id)
{
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
ViewMovieCarrier movie = new ViewMovieCarrier();
var p = new DynamicParameters();
p.Add("MovieID", Id);
movie =
cn.Query<ViewMovieCarrier>("GetMovieByID", p, commandType: CommandType.StoredProcedure).FirstOrDefault();
movie.Synopsis =
cn.Query<string>("SELECT m.Synopsis FROM Movies m WHERE m.MovieID = @MovieID", new {MovieID = Id})
.FirstOrDefault();
movie.ImageURL =
cn.Query<string>("SELECT m.ImageURL FROM Movies m WHERE m.MovieID = @MovieID", new {MovieID = Id})
.FirstOrDefault();
movie.Director = GetDirectorListByMovieID(Id);
movie.Actor = GetActorListByMovieID(Id);
return movie;
}
}
