Beispiel #1
0
 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);
 }