public int GenreUpdateJust(
int GenreID,
string Name)
{
GenreDAL dal = new GenreDAL(_connection);
return(dal.GenreUpdateJust(GenreID, Name));
}
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);
}
