public void Create_Collection_Test()
{
ICollectionDAL dal = new CollectionSqlDAL(ConnectionString);
int result = dal.CreateCollection(1, "Test Collection", true);
Assert.AreEqual(3, result);
}
public void Create_Test_Collection_Test()
{
ICollectionDAL dal = new CollectionSqlDAL(ConnectionString);
Collection result = dal.CreateTestCollection();
Assert.AreEqual("Image", result.ComicsInCollection);
}
public void Get_All_Collections_For_A_User_Test()
{
ICollectionDAL dal = new CollectionSqlDAL(ConnectionString);
List <Collection> result = dal.GetAllCollectionsFromUser(1);
Assert.AreEqual("Comics from Middle School", result[1].CollectionName);
}
public void Get_All_Comics_In_A_Collection_Test()
{
ICollectionDAL dal = new CollectionSqlDAL(ConnectionString);
List <Comic> result = dal.GetAllComicsInACollection(2);
Assert.AreEqual("Image", result[0].Publisher);
}
public void Check_For_Value_Test()
{
bool expected = true;
ICollectionDAL dal = new CollectionSqlDAL(ConnectionString);
bool result = dal.CheckForValue("characters", "character_name", "Spawn");
Assert.AreEqual(expected, result);
}
public void Get_Collection_Data_Test()
{
ICollectionDAL dal = new CollectionSqlDAL(ConnectionString);
Collection result = dal.GetCollectionData(1);
Assert.AreEqual("testUser", result.UserName);
result = dal.GetCollectionData(9);
Assert.AreEqual("What The F David Blaine", result.CollectionName);
}
public void Create_Comic_Test()
{
IComicDAL comicDal = new ComicSqlDAL(ConnectionString);
ICollectionDAL collectionDal = new CollectionSqlDAL(ConnectionString);
int userID = 1;
int collectionID = 1;
string author = "Tom Jones";
string title = "Whatever";
DateTime publishDate = Convert.ToDateTime("11-05-2006");
string publisher = "Garage Comics";
string description = "Seriously, like, whatever";
List <string> characters = new List <string>()
{
"Mean Girl", "Mean Mom", "Nice Dad", "Out-of-control Kid"
};
int result = comicDal.CreateComic(userID, collectionID, author, title, publishDate, description, publisher, characters);
Comic comic = comicDal.GetComicData(result);
comic.Characters = comicDal.GetAllCharactersInAComic(comic.ComicId);
Assert.AreEqual(title, comic.Title);
}