public void GetItemByType()
{
DataBase dataBase = new DataBase();
string itemTypeName1 = Guid.NewGuid().ToString();
string itemTypeName2 = Guid.NewGuid().ToString();
string itemTypeName3 = Guid.NewGuid().ToString();
int rowsInserted =
dataBase.ItemTypeInsert(new ItemType {Name = itemTypeName1, Description = "item type description 1",});
Assert.AreEqual(1, rowsInserted);
rowsInserted =
dataBase.ItemTypeInsert(new ItemType {Name = itemTypeName2, Description = "item type description 2",});
Assert.AreEqual(1, rowsInserted);
rowsInserted =
dataBase.ItemTypeInsert(new ItemType {Name = itemTypeName3, Description = "item type description 3",});
Assert.AreEqual(1, rowsInserted);
List<ItemType> itemTypes = dataBase.ItemTypeGetAll();
string itemName1 = Guid.NewGuid().ToString();
string itemName2 = Guid.NewGuid().ToString();
string itemName3 = Guid.NewGuid().ToString();
int itemTypeId1 = itemTypes.Find(n => n.Name == itemTypeName1).Id;
int itemTypeId2 = itemTypes.Find(n => n.Name == itemTypeName2).Id;
int itemTypeId3 = itemTypes.Find(n => n.Name == itemTypeName3).Id;
rowsInserted =
dataBase.ItemInsert(new Item
{
Name = itemName1,
Description = "item description 1",
ItemTypeId = itemTypeId1,
});
Assert.AreEqual(1, rowsInserted);
rowsInserted =
dataBase.ItemInsert(new Item
{
Name = itemName2,
Description = "item description 2",
ItemTypeId = itemTypeId2,
});
Assert.AreEqual(1, rowsInserted);
rowsInserted =
dataBase.ItemInsert(new Item
{
Name = itemName3,
Description = "item description 3",
ItemTypeId = itemTypeId2,
});
Assert.AreEqual(1, rowsInserted);
List<Item> items = dataBase.ItemGetByType(itemTypeId1);
Assert.IsNotNull(items);
Assert.IsTrue(items.Count == 1, "Expected: {0}, Actual:{1}", 1, items.Count);
items = dataBase.ItemGetByType(itemTypeId2);
Assert.IsNotNull(items);
Assert.IsTrue(items.Count == 2, "Expected: {0}, Actual:{1}", 2, items.Count);
items = dataBase.ItemGetByType(itemTypeId3);
Assert.IsNotNull(items);
Assert.IsTrue(items.Count == 0, "Expected: {0}, Actual:{1}", 0, items.Count);
}
