private Item GetItemFromDbContext(DbInventoryContext db, int id) { var query = from c in db.Items select c; Item item = query.FirstOrDefault(c => c.ItemId == id); return item; }
public int DbAddItem(string name, int quantity) { DbInventoryContext context = new DbInventoryContext(); Item item = new Item { ItemName = name, Quantity = quantity }; context.Items.Add(item); context.SaveChanges(); return item.ItemId; }
public void DbSaveItem(Item newItem) { DbInventoryContext db = new DbInventoryContext(); Item item = GetItemFromDbContext(db, newItem.ItemId); item.ItemName = newItem.ItemName; item.Quantity = newItem.Quantity; db.SaveChanges(); }
public void DbRemoveItem(int id) { DbInventoryContext db = new DbInventoryContext(); var query = from c in db.Items select c; Item item = query.FirstOrDefault(c => c.ItemId == id); db.Items.Remove(item); db.SaveChanges(); }
public int DbAddQuantity(int itemId, int quantity) { DbInventoryContext db = new DbInventoryContext(); var query = from c in db.Items select c; Item item = query.FirstOrDefault(c => c.ItemId == itemId); item.Quantity += quantity; db.SaveChanges(); return item.ItemId; }
public List<Item> DbGetItems() { DbInventoryContext db = new DbInventoryContext(); return db.Items.ToList(); }
public Item DbGetItem(int id) { DbInventoryContext db = new DbInventoryContext(); return GetItemFromDbContext(db, id); }
public void DbClearItems() { DbInventoryContext db = new DbInventoryContext(); db.Database.ExecuteSqlCommand("Truncate Table dbo.Items"); }