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