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