public static void CanGetDirectorADO()
{
var repo = new DVDRepositoryADO();
var directorName = "Murphy";
var result = repo.GetDirectorId(directorName);
Assert.AreEqual(4, result);
directorName = "Ponce de Leon";
result = repo.GetDirectorId(directorName);
Assert.AreEqual(5, result);
directorName = "John Doe";
result = repo.GetDirectorId(directorName);
Assert.AreEqual(6, result);
directorName = "Sam Jones";
result = repo.GetDirectorId(directorName);
Assert.AreEqual(1, result);
directorName = "";
result = repo.GetDirectorId(directorName);
Assert.AreEqual(null, result);
}
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 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 DVDController()
{
DVDRepositoryMock mock = new DVDRepositoryMock();
DVDRepositoryEF ef = new DVDRepositoryEF();
DVDRepositoryADO ado = new DVDRepositoryADO();
if (manager.newDVDRepository.GetType() == mock.GetType())
{
_repository = manager.newDVDRepository;
}
else if (manager.newDVDRepository.GetType() == ef.GetType())
{
_repository = ef;
}
else
{
_repository = ado;
}
}
public static void CanSearchDVDsADO()
{
var repo = new DVDRepositoryADO();
var dvds = repo.Search("title", "A Super Tale").ToList();
Assert.AreEqual(2, dvds.Count);
dvds = repo.Search("year", "2015").ToList();
Assert.AreEqual(4, dvds.Count);
dvds = repo.Search("director", "Sam Jones").ToList();
Assert.AreEqual(2, dvds.Count);
dvds = repo.Search("rating", "PG").ToList();
Assert.AreEqual(4, dvds.Count);
}
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"));
}
public static void CanGetRatingIdADO()
{
var repo = new DVDRepositoryADO();
Assert.AreEqual(4, Helpers.GetRatingId("R"));
}
