public async Task <IActionResult> ArchiveConfirmed(int id)
{
var chemInventory2 = await _context.ChemInventory2.SingleOrDefaultAsync(m => m.ChemInventoryMId == id);
ChemInventoryArc2 chemInventoryArc2 = new ChemInventoryArc2();
if (chemInventory2 != null)
{
chemInventoryArc2.Barcode = chemInventory2.ChemInventoryMId;
chemInventoryArc2.ChemID = chemInventory2.ChemID;
chemInventoryArc2.LocationID = chemInventory2.LocationID;
chemInventoryArc2.ExpiryDate = chemInventory2.ExpiryDate;
chemInventoryArc2.OrderID = chemInventory2.OrderID;
chemInventoryArc2.QtyLeft = chemInventory2.QtyLeft;
chemInventoryArc2.Units = chemInventory2.Units;
chemInventoryArc2.Department = chemInventory2.Department;
chemInventoryArc2.CAT = chemInventory2.CAT;
chemInventoryArc2.LOT = chemInventory2.LOT;
chemInventoryArc2.Manufacturer = chemInventory2.Manufacturer;
_context.ChemInventoryArc2.Add(chemInventoryArc2);
await _context.SaveChangesAsync();
}
_context.ChemInventory2.Remove(chemInventory2);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Create(int?formulainput, DateTime dateinput, int?storageinput, int?orderinput, string cat, string lot, float qtyinput, string unitstring, string deptstring, string manustring)
{
ViewData["Formula"] = formulainput;
ViewData["ExpiryDate"] = dateinput;
ViewData["StorageCode"] = storageinput;
ViewData["Order"] = orderinput;
ViewData["Qty"] = qtyinput;
ViewData["Unit"] = unitstring;
ViewData["Department"] = deptstring;
ViewData["CAT"] = cat;
ViewData["LOT"] = lot;
ViewData["Manufacturer"] = manustring;
ChemInventoryArc2 chemInventoryArc2 = null;
if (ModelState.IsValid)
{
chemInventoryArc2 = new ChemInventoryArc2();
chemInventoryArc2.ChemID = formulainput;
chemInventoryArc2.LocationID = storageinput;
chemInventoryArc2.ExpiryDate = dateinput;
chemInventoryArc2.OrderID = orderinput;
chemInventoryArc2.QtyLeft = qtyinput;
chemInventoryArc2.Units = unitstring;
chemInventoryArc2.Department = deptstring;
chemInventoryArc2.CAT = cat;
chemInventoryArc2.LOT = lot;
chemInventoryArc2.Manufacturer = manustring;
var temp = _context.Locations.First(m => m.LocationID == storageinput);
chemInventoryArc2.NormalizedLocation = temp.StorageCode;
_context.Add(chemInventoryArc2);
await _context.SaveChangesAsync();
// the three lines below are so that the Barcode matches the Primary Key upon creation, which doesn't exist until the item has been added to the _context
chemInventoryArc2.Barcode = chemInventoryArc2.ChemInventoryMIdArc;
_context.Update(chemInventoryArc2);
await _context.SaveChangesAsync();
Sp_Logging("2-Change", "Create", "User created a chemical archive item where ChemID=" + formulainput + ", OrderID=" + formulainput, "Success");
return(RedirectToAction("Index", new { barcodeFlag = true }));
}
ViewData["ChemID"] = new SelectList(_context.Chemical, "ChemID", "FormulaName", chemInventoryArc2.ChemID);
ViewData["LocationName"] = new SelectList(_context.Locations, "LocationID", "StorageCode", chemInventoryArc2.LocationID);
ViewData["OrderID"] = new SelectList(_context.Orders, "OrderID", "OrderID", chemInventoryArc2.OrderID);
return(View(chemInventoryArc2));
}
public async Task <IActionResult> Edit(int id, int?formulainput, DateTime dateinput, int?storageinput, int?orderinput, string cat, string lot, float qtyinput, string unitstring, string deptstring, string manustring)
{
ChemInventory2 chemInventory2 = await _context.ChemInventory2.SingleOrDefaultAsync(p => p.ChemInventoryMId == id);
if (id != chemInventory2.ChemInventoryMId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
if (qtyinput == 0)
{
ChemInventoryArc2 chemInventoryArc2 = null;
try
{
chemInventoryArc2 = new ChemInventoryArc2();
chemInventoryArc2.ChemID = formulainput;
chemInventoryArc2.LocationID = storageinput;
chemInventoryArc2.ExpiryDate = dateinput;
chemInventoryArc2.OrderID = orderinput;
chemInventoryArc2.QtyLeft = qtyinput;
chemInventoryArc2.Units = unitstring;
chemInventoryArc2.Department = deptstring;
chemInventoryArc2.CAT = cat;
chemInventoryArc2.LOT = lot;
chemInventoryArc2.Manufacturer = manustring;
chemInventoryArc2.Barcode = chemInventory2.Barcode;
var temp = _context.Locations.First(m => m.LocationID == storageinput);
chemInventoryArc2.NormalizedLocation = temp.StorageCode;
_context.Add(chemInventoryArc2);
await _context.SaveChangesAsync();
await DeleteConfirmed(id);
Sp_Logging("2-Archive", "Edit", "User archived a Chemical inventory item where ID= " + id.ToString(), "Success");
}
catch (DbUpdateConcurrencyException)
{
if (!ChemInventory2Exists(chemInventoryArc2.ChemInventoryMIdArc))
{
return(NotFound());
}
else
{
throw;
}
}
}
else
{
try
{
chemInventory2.ChemID = formulainput;
chemInventory2.LocationID = storageinput;
chemInventory2.ExpiryDate = dateinput;
chemInventory2.OrderID = orderinput;
chemInventory2.QtyLeft = qtyinput;
chemInventory2.Units = unitstring;
chemInventory2.Department = deptstring;
chemInventory2.CAT = cat;
chemInventory2.LOT = lot;
chemInventory2.Manufacturer = manustring;
var temp = _context.Locations.First(m => m.LocationID == storageinput);
chemInventory2.NormalizedLocation = temp.StorageCode;
_context.Update(chemInventory2);
await _context.SaveChangesAsync();
Sp_Logging("2-Change", "Edit", "User edited a Chemical inventory item where ID= " + id.ToString(), "Success");
}
catch (DbUpdateConcurrencyException)
{
if (!ChemInventory2Exists(chemInventory2.ChemInventoryMId))
{
return(NotFound());
}
else
{
throw;
}
}
}
return(RedirectToAction("Index"));
}
ViewData["ChemID"] = new SelectList(_context.Chemical, "ChemID", "FormulaName", chemInventory2.ChemID);
ViewData["LocationName"] = new SelectList(_context.Locations, "LocationID", "StorageCode", chemInventory2.LocationID);
ViewData["OrderID"] = new SelectList(_context.Orders, "OrderID", "OrderID", chemInventory2.OrderID);
return(View(chemInventory2));
}
