public static void UpdateInventoryItem(int Id) { InventoryItem item; using (var db = new InventoryItemDbContext()) { var items = db.Items; item = items.First(i => i.InventoryId == Id); try { Console.WriteLine("CURRENT INFO: "); PrintItemDescription(item); Console.WriteLine("Description:"); item.ItemDescription = Console.ReadLine(); Console.WriteLine("Amount in stock:"); item.InStock = int.Parse(Console.ReadLine()); Console.WriteLine("List Price:"); item.ListPrice = double.Parse(Console.ReadLine()); Console.WriteLine("Acquisition Cost: "); item.AcquisitionCost = double.Parse(Console.ReadLine()); db.SaveChanges(); } catch (Exception ex) { Console.WriteLine("Error: " + ex.Message); throw; } } }
public static void CreateInventoryItem() { Console.WriteLine("Description:"); var desc = Console.ReadLine(); Console.WriteLine("Amount in stock:"); var inStock = int.Parse(Console.ReadLine()); Console.WriteLine("List Price:"); var list = double.Parse(Console.ReadLine()); Console.WriteLine("Acquisition Cost: "); var cost = double.Parse(Console.ReadLine()); using (var db = new InventoryItemDbContext()) { var item = new InventoryItem() { ItemDescription = desc, InStock = inStock, ListPrice = list, AcquisitionCost = cost }; db.Items.Add(item); db.SaveChanges(); } }
public static void GetItems() { using (var db = new InventoryItemDbContext()) { var items = db.Items; foreach (var item in items) { PrintItemDescription(item, true); } } }
public static void DeleteInventoryItem(int itemId) { using (var db = new InventoryItemDbContext()) { var item = GetItem(itemId, false); //because the item returns from a different DB context, you must attach that context to this one. db.Items.Attach(item); db.Items.Remove(item); db.SaveChanges(); } }
public static InventoryItem GetItem(int Id, bool print = true) { InventoryItem item; using (var db = new InventoryItemDbContext()) { item = db.Items.Find(Id); } if (print) { PrintItemDescription(item); } return(item); }