public static void CanGetAllDVDsADO()
{
var repo = new DVDRepositoryADO();
var dvds = repo.GetAll().ToList();
Assert.AreEqual(7, dvds.Count);
Assert.AreEqual(2, dvds[1].DvdId);
Assert.AreEqual("A Good Tale", dvds[1].Title);
Assert.AreEqual(2012, dvds[1].RealeaseYear);
Assert.AreEqual("Joe Smith", dvds[1].Director);
Assert.AreEqual("This is a good tale!", dvds[1].Notes);
}
public static void CanAddAndDeleteDVDADO()
{
DVD dvdToAdd = new DVD();
var repo = new DVDRepositoryADO();
dvdToAdd.Title = "A Null Test";
dvdToAdd.RealeaseYear = null;
dvdToAdd.Director = null;
dvdToAdd.Rating = null;
dvdToAdd.Notes = null;
repo.Add(dvdToAdd);
var dvds = repo.GetAll().ToList();
var dvd = repo.GetById(8);
Assert.IsNotNull(dvd);
Assert.AreEqual(8, dvds.Count);
Assert.AreEqual(8, dvd.DvdId);
Assert.AreEqual("A Null Test", dvd.Title);
Assert.AreEqual(null, dvd.RealeaseYear);
Assert.AreEqual("", dvd.Director);
Assert.AreEqual("", dvd.Rating);
Assert.AreEqual("", dvd.Notes);
DVD dvdToAdd2 = new DVD();
dvdToAdd2.Title = "A New Tale";
dvdToAdd2.RealeaseYear = 2016;
dvdToAdd2.Director = "Jack Jameson";
dvdToAdd2.Rating = "PG-13";
dvdToAdd2.Notes = "Brand new!";
repo.Add(dvdToAdd2);
dvds = repo.GetAll().ToList();
dvd = repo.GetById(9);
Assert.IsNotNull(dvd);
Assert.AreEqual(9, dvds.Count);
Assert.AreEqual(9, dvd.DvdId);
Assert.AreEqual("A New Tale", dvd.Title);
Assert.AreEqual(2016, dvd.RealeaseYear);
Assert.AreEqual("Jack Jameson", dvd.Director);
Assert.AreEqual("PG-13", dvd.Rating);
Assert.AreEqual("Brand new!", dvd.Notes);
repo.Delete(8);
dvds = repo.GetAll().ToList();
dvd = repo.GetById(8);
Assert.IsNull(dvd);
Assert.AreEqual(8, dvds.Count);
repo.Delete(9);
dvds = repo.GetAll().ToList();
dvd = repo.GetById(9);
Assert.IsNull(dvd);
Assert.AreEqual(7, dvds.Count);
repo.Delete(6);
dvds = repo.GetAll().ToList();
dvd = repo.GetById(6);
Assert.IsNull(dvd);
Assert.AreEqual(6, dvds.Count);
Assert.AreEqual(5, repo.GetDirectorId("Joe Baker"));
}
