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