public void GenreTest() { // arrange GenreDAL dal = new GenreDAL(MagicSetup.Connection); // act create int rv1 = dal.GenreCreate("Test1"); Assert.IsTrue(rv1 > 0, $"GenreCreate failed rv = {rv1}"); Genre a = dal.GenreFindByID(rv1); Assert.IsNotNull(a, $"GenreFindByID for ID {rv1} (just created) returned null"); Assert.IsTrue(a.GenreName == "Test1", $"GenreName was expected to be 'Test1' but found {a.GenreName}"); int countofGenres = dal.GenresObtainCount(); Assert.IsTrue(countofGenres > 0, $"GenresObtainCount should be greater than 0 it is {countofGenres}"); List <Genre> Genres = dal.GenresGetAll(); Assert.IsTrue(Genres.Count == countofGenres, $"GenresGetAll should have brought back {countofGenres} records, but it only found {Genres.Count}"); DateTime now = DateTime.Now; int number = dal.GenreUpdateJust(rv1, "Test1New"); Assert.IsTrue(number == 1, $"GenreUpdateJust was expected to return 1, but actually returned {number}"); a = dal.GenreFindByID(rv1); Assert.IsNotNull(a, $"GenreFindByID for ID {rv1} (just updated) returned null"); Assert.IsTrue(a.GenreName == "Test1New", $"GenreName after update was expected to be 'Test1New' but was actually '{a.GenreName}'"); number = dal.GenreUpdateSafe(rv1, "Test1New", "1"); Assert.IsTrue(number == 1, $"GenreUpdateSafe was expected to return 1 but actually returned {number}"); a = dal.GenreFindByID(rv1); Assert.IsNotNull(a, $"GenreFindByID for ID {rv1} (just safe updated) returned null"); Assert.IsTrue(a.GenreName == "1", $"Genrename after safeupdate was expected to be '1', but was '{a.GenreName}"); number = dal.GenreUpdateSafe(rv1, "2", "4"); Assert.IsTrue(number == 0, $"Genreupdatesafe was expected to return 0, but it actually returned {number}"); dal.GenreDelete(rv1); }
public List <Genre> GenreGetAll(int skip = 0, int take = 0) { GenreDAL dal = new GenreDAL(_connection); return(dal.GenresGetAll(skip, take)); }