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); }
public void OrderGetAll() { DataBase dataBase = new DataBase(); string itemTypeName = Guid.NewGuid().ToString(); ItemType itemType = new ItemType {Name = itemTypeName,}; dataBase.ItemTypeInsert(itemType); ItemType itemTypeGet = dataBase.ItemTypeGet(itemTypeName); Assert.IsNotNull(itemTypeGet); string itemName = Guid.NewGuid().ToString(); Item item = new Item { Name = itemName, ItemTypeId = itemTypeGet.Id, }; dataBase.ItemInsert(item); Item itemGet = dataBase.ItemGet(itemName); Assert.IsNotNull(itemGet); string itemStatusName = Guid.NewGuid().ToString(); ItemStatus itemStatus = new ItemStatus {Name = itemStatusName}; dataBase.ItemStatusInsert(itemStatus); ItemStatus itemStatusGet = dataBase.ItemStatusGet(itemStatusName); Assert.IsNotNull(itemStatusGet); string personInfoName = Guid.NewGuid().ToString(); string personInfoSurName = Guid.NewGuid().ToString(); PersonInfo personInfo = new PersonInfo {Name = personInfoName, SurName = personInfoSurName,}; dataBase.PersonInfoInsert(personInfo); PersonInfo personInfoGet = dataBase.PersonInfoGet(personInfoName, personInfoSurName); Assert.IsNotNull(personInfoGet); Order order = new Order { ItemId = itemGet.Id, Count = 1, ItemStatusId = itemStatusGet.Id, LegalEntity = true, PersonInfoId = personInfoGet.Id, Postage = 0M.DecimalToString(), Price = 1M.DecimalToString(), BankId = -1, }; int rowsInserted = dataBase.OrderInsert(order); Assert.AreEqual(1, rowsInserted); List<Order> orders = dataBase.OrderGetAll(); Assert.IsNotNull(orders); Order find = orders.Find(o => o.ItemId == itemGet.Id); Assert.IsNotNull(find); }
public void UpdateItem() { DataBase dataBase = new DataBase(); string name = Guid.NewGuid().ToString(); Item item = new Item { Name = name, Description = Guid.NewGuid().ToString(), ItemTypeId = 0, Image = new byte[] {1, 2, 3, 4, 5}, }; int rowsInserted = dataBase.ItemInsert(item); Assert.AreEqual(1, rowsInserted); List<Item> items = dataBase.ItemGetAll(@"SELECT Id, Name, Description, ItemType, Image FROM Item"); Assert.IsNotNull(items); Item find = items.Find(i => i.Name == name); Assert.IsNotNull(find); string newName = Guid.NewGuid().ToString(); find.Name = newName; int rowsUpdated = dataBase.ItemUpdate(find); Assert.AreEqual(1, rowsUpdated); Item updatedItem = dataBase.ItemGet(find.Id); Assert.AreEqual(newName, updatedItem.Name); Assert.AreEqual(item.Description, updatedItem.Description); Assert.AreEqual(item.ItemTypeId, updatedItem.ItemTypeId); }
public void ItemGetByName() { DataBase dataBase = new DataBase(); string name = Guid.NewGuid().ToString(); Item item = new Item { Name = name, ItemTypeId = 0, }; int rowsInserted = dataBase.ItemInsert(item); Assert.AreEqual(1, rowsInserted); Item itemGet = dataBase.ItemGet(name); Assert.IsNotNull(itemGet); }
public void InsertItemWitPicture() { DataBase dataBase = new DataBase(); string name = Guid.NewGuid().ToString(); const string imagePath = "Untitled.png"; byte[] imageData = Misc.GetImageData(imagePath); Assert.IsNotNull(imageData, "No image '{0}'!", imagePath); Item item = new Item { Name = name, Description = Guid.NewGuid().ToString(), ItemTypeId = 0, Image = imageData, }; int rowsInserted = dataBase.ItemInsert(item); Assert.AreEqual(1, rowsInserted); List<Item> items = dataBase.ItemGetAll(@"SELECT Id, Name, Description, ItemType, Image FROM Item"); Assert.IsNotNull(items, "Ites is null"); Item find = items.Find(i => i.Name == name); Assert.IsNotNull(find, "Item {0} not found!", name); Assert.AreEqual(imageData.Length, find.Image.Length, "Wrong Image!"); }