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 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 ActionResult Create(string Type, [Bind(Include = "ID,CustomID,Brand,ItemName,Price,QuantityLeft,Type,GeneralDescription")] InventoryItem inventoryItem) { if (ModelState.IsValid) { inventoryItem.Type = Type; inventoryItem.LastShipmentRecieved = "Not Yet Stocked"; inventoryItem.ItemNumber = inventoryItem.ID; inventoryItem.ItemName = inventoryItem.ItemName.ToUpper(); inventoryItem.Brand = inventoryItem.Brand.ToUpper(); db.InventoryItemDatabase.Add(inventoryItem); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(inventoryItem)); }
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(); } }