public void ADOInvalidDvdIDReturnsNull()
{
var repo = new DvdRepoADO();
var dvd = repo.GetByID(20000000);
Assert.IsNull(dvd);
}
public void ADOCanDeleteDvd()
{
var repo = new DvdRepoADO();
var dvdToAdd = new DvdDetails();
dvdToAdd.Title = "Test";
dvdToAdd.Year = 2020;
dvdToAdd.Note = "Test, test";
dvdToAdd.DirectorName = "Tester";
dvdToAdd.RatingValue = "X";
//dvdToAdd.DirectorID = 15;
//dvdToAdd.RatingID = 15;
//dvdToAdd.ReleaseID = 15;
repo.Insert(dvdToAdd);
var loaded = repo.GetByID(7);
Assert.IsNotNull(loaded);
repo.Delete(7);
loaded = repo.GetByID(7);
Assert.IsNull(loaded);
}
public void ADOCanEditDvd()
{
var repo = new DvdRepoADO();
var dvdToAdd = new DvdDetails();
dvdToAdd.Title = "Test";
dvdToAdd.Year = 2020;
dvdToAdd.Note = "Test, test";
dvdToAdd.DirectorName = "Tester";
dvdToAdd.RatingValue = "X";
//dvdToAdd.DirectorID = 15;
//dvdToAdd.RatingID = 15;
//dvdToAdd.ReleaseID = 15;
repo.Insert(dvdToAdd);
dvdToAdd.Title = "Test2";
dvdToAdd.Year = 2022;
dvdToAdd.Note = "Test, test2";
dvdToAdd.DirectorName = "Tester2";
dvdToAdd.RatingValue = "X2";
repo.Update(dvdToAdd);
Assert.AreEqual(7, dvdToAdd.DvdID);
Assert.AreEqual("Test2", dvdToAdd.Title);
Assert.AreEqual(2022, dvdToAdd.Year);
Assert.AreEqual("Tester2", dvdToAdd.DirectorName);
Assert.AreEqual("X2", dvdToAdd.RatingValue);
Assert.AreEqual("Test, test2", dvdToAdd.Note);
}
public void ADOCanGetDvdByID()
{
var repo = new DvdRepoADO();
var dvd = repo.GetByID(6);
Assert.AreEqual(6, dvd.DvdID);
Assert.AreEqual("Pumpkinhead 2", dvd.Title);
Assert.AreEqual(1993, dvd.Year);
Assert.AreEqual("Jeff Burr", dvd.DirectorName);
Assert.AreEqual("R", dvd.RatingValue);
Assert.AreEqual(null, dvd.Note);
Assert.AreEqual(1, dvd.DirectorID);
Assert.AreEqual(4, dvd.RatingID);
Assert.AreEqual(5, dvd.ReleaseID);
}
public void ADOCanGetDvdsByYear()
{
var repo = new DvdRepoADO();
var dvds = repo.GetByYear(201).ToList();
Assert.AreEqual(2, dvds.Count());
Assert.AreEqual(2, dvds[0].DvdID);
Assert.AreEqual("Pacific Rim", dvds[0].Title);
Assert.AreEqual(2013, dvds[0].Year);
Assert.AreEqual("Guillermo Del Toro", dvds[0].DirectorName);
Assert.AreEqual("PG-13", dvds[0].RatingValue);
Assert.AreEqual("Well we are moving on up to the east side.", dvds[0].Note);
Assert.AreEqual(2, dvds[0].DirectorID);
Assert.AreEqual(3, dvds[0].RatingID);
Assert.AreEqual(2, dvds[0].ReleaseID);
}
public void ADOCanGetDvdsByTitle()
{
var repo = new DvdRepoADO();
var dvds = repo.GetByTitle("e").ToList();
Assert.AreEqual(4, dvds.Count());
Assert.AreEqual(3, dvds[1].DvdID);
Assert.AreEqual("HellBoy", dvds[1].Title);
Assert.AreEqual(2004, dvds[1].Year);
Assert.AreEqual("Guillermo Del Toro", dvds[1].DirectorName);
Assert.AreEqual("R", dvds[1].RatingValue);
Assert.AreEqual("Its time to light the lights.", dvds[1].Note);
Assert.AreEqual(2, dvds[1].DirectorID);
Assert.AreEqual(4, dvds[1].RatingID);
Assert.AreEqual(3, dvds[1].ReleaseID);
}
public void ADOCanGetDvdsByRating()
{
var repo = new DvdRepoADO();
var dvds = repo.GetByRating("-").ToList();
Assert.AreEqual(3, dvds.Count());
Assert.AreEqual(4, dvds[1].DvdID);
Assert.AreEqual("Ready Player One", dvds[1].Title);
Assert.AreEqual(2018, dvds[1].Year);
Assert.AreEqual("Steven Spielberg", dvds[1].DirectorName);
Assert.AreEqual("PG-13", dvds[1].RatingValue);
Assert.AreEqual("Its time to play the music.", dvds[1].Note);
Assert.AreEqual(3, dvds[1].DirectorID);
Assert.AreEqual(3, dvds[1].RatingID);
Assert.AreEqual(4, dvds[1].ReleaseID);
}
