public static void CanGetDVDByIdADO() { var repo = new DVDRepositoryADO(); var dvd = repo.GetById(1); Assert.IsNotNull(dvd); Assert.AreEqual(1, dvd.DvdId); Assert.AreEqual("A Great Tale", dvd.Title); Assert.AreEqual(2015, dvd.RealeaseYear); Assert.AreEqual("Sam Jones", dvd.Director); Assert.AreEqual("This really is a great tale!", dvd.Notes); }
public static void CanEditDVDADO() { DVD dvdToEdit = new DVD(); var repo = new DVDRepositoryADO(); dvdToEdit.DvdId = 7; dvdToEdit.Title = "2001: A Space Odyssey"; dvdToEdit.RealeaseYear = 1968; dvdToEdit.Director = "Stanley Kubrick"; dvdToEdit.Rating = "G"; dvdToEdit.Notes = "Classic sci-fi."; repo.Edit(dvdToEdit); var dvd = repo.GetById(7); Assert.AreEqual(7, dvd.DvdId); Assert.AreEqual("2001: A Space Odyssey", dvd.Title); Assert.AreEqual(1968, dvd.RealeaseYear); Assert.AreEqual("Stanley Kubrick", dvd.Director); Assert.AreEqual("G", dvd.Rating); Assert.AreEqual("Classic sci-fi.", dvd.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")); }