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 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!"); }