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 ActionResult MovieToRepo(AddMovieCarrier newMovie)
{
var ops = new DVDLibraryOperations();
ops.AddMovie(newMovie);
return RedirectToAction("ViewCollection");
}
public void AddMovie(AddMovieCarrier amc)
{
int id = _repo.AddMovieToDB(amc.Title, amc.DateReleased, int.Parse(amc.RunTime), amc.Synopsis, amc.ImageURL,
int.Parse(amc.GenreID), int.Parse(amc.OwnerRatingID), int.Parse(amc.MPAARatingID),
int.Parse(amc.StudioID));
foreach (var director in amc.DirectorID)
{
_repo.AddMovieDirectorToDB(id, int.Parse(director));
}
foreach (var actor in amc.ActorID)
{
_repo.AddMovieActorToDB(id, int.Parse(actor));
}
for (int i = 0; i < int.Parse(amc.Copies); i++)
{
_repo.AddMovieToInventoryDB(id, 0);
}
}
