public void SelectCategory()
{
CategoryConnector sc = new CategoryConnector();
Category result = sc.SelectCategory("book");
Assert.AreEqual("book", result.CategoryName, "correct");
//sc.DeleteCategory("book");
}
public void DeleteCategory()
{
CategoryConnector sc = new CategoryConnector();
sc.DeleteCategory("hello");
List <Category> result = sc.SelectAllCategory();
Assert.AreEqual(0, result.Count, "correct");
}
public void InsertCategory()
{
CategoryConnector sc = new CategoryConnector();
sc.InsertCategory("book", 4);
List <Category> result = sc.SelectAllCategory();
Assert.AreEqual("book", result[0].CategoryName, "correct");
//sc.DeleteCategory("book");
}
public void UpdateCategory()
{
CategoryConnector sc = new CategoryConnector();
sc.UpdateCategory("book", "hello", 5);
List <Category> result = sc.SelectAllCategory();
Assert.AreEqual("hello", result[0].CategoryName, "correct");
Assert.AreEqual(5, result[0].Duration, "correct");
}
public void InsertItem()
{
ItemConnector itemCn = new ItemConnector();
CategoryConnector CateCn = new CategoryConnector();
CateCn.InsertCategory("books", 4);
itemCn.InsertItem("1231231", "hello", "books");
Item item1 = itemCn.SelectItem("1231231");
Assert.AreEqual("books", item1.ItemCategory.CategoryName, "correct");
Assert.AreEqual("1231231", item1.Barcode, "correct");
Assert.AreEqual("hello", item1.ItemDescription, "correct");
Assert.AreEqual(true, item1.Status, "correct");
//Assert.AreEqual("book", item1.ItemCategory, "correct");
itemCn.DeleteItem("1231231");
CateCn.DeleteCategory("books");
Item item2 = itemCn.SelectItem("1231231");
Assert.AreEqual(null, item2.Barcode, "correct");
}
