public ActionResult EditItem(int id)
{
OrderItem vm = new OrderItem();
vm = OrderService.fnFillOrderItem(id);
return PartialView("~/Views/Orders/_OrderItemModal.cshtml", vm);
}
public ActionResult SaveItem(OrderItem incoming, string productdetailid)
{
if (productdetailid == "0" || productdetailid == "")
{
return Content("Please Select a Product");
}
int pk = OrderService.fnSaveItem(incoming);
return Content("Item Saved at " + System.DateTime.Now.ToString());
}
public static OrderItem fnFillOrderItem(int id)
{
// id=itemid
// Fill all the fields from the tblOrderItem record
using (var db = new EF.CMCSQL03Entities())
{
OrderItem vm = new OrderItem();
var q = (from t in db.tblOrderItem
where t.ItemID == id
select t).FirstOrDefault();
var cl = db.tblOrderMaster.Find(q.OrderID);
vm.CrudMode = "RW"; // default value
// Hidden fields to persist for postback
vm.ItemID = q.ItemID;
vm.OrderID = q.OrderID;
vm.ClientID = Convert.ToInt32(cl.ClientID);
vm.CreateDate = q.CreateDate;
vm.CreateUser = q.CreateUser;
vm.UpdateDate = q.UpdateDate;
vm.UpdateUser = q.UpdateUser;
vm.ProductDetailID = q.ProductDetailID;
vm.ListOfProductDetailIDs = fnListOfProductCodes(vm.ClientID);
vm.ProductCode = q.ProductCode;
vm.ProductName = q.ProductName;
vm.ShelfID = q.ShelfID;
vm.ListOfShelfIDs = fnProductCodeSizes(Convert.ToInt32(vm.ProductDetailID));
vm.Size = q.Size;
vm.Qty = q.Qty;
vm.LotNumber = q.LotNumber;
vm.ShipDate = q.ShipDate;
vm.CSAllocate = q.CSAllocate;
vm.AllocateStatus = q.AllocateStatus;
vm.NonCMCDelay = q.NonCMCDelay;
vm.CarrierInvoiceRcvd = q.CarrierInvoiceRcvd;
vm.DelayReason = q.DelayReason;
vm.Status = q.Status;
vm.StatusID = null;
vm.ListOfStatusNotesIDs = fnListOfStatusNotesIDs();
vm.ItemNotes = q.ItemNotes;
vm.AlertNotesShipping = q.AlertNotesShipping;
vm.AlertNotesPackOut = q.AlertNotesPackout;
vm.AlertNotesOrderEntry = q.AlertNotesOrderEntry;
vm.AlertNotesOther = q.AlertNotesOther;
// Look for a reason to set the item R/O
if (q.ShipDate != null || q.AllocateStatus == "A")
{
vm.CrudMode = "RO";
}
return vm;
}
}
public static OrderItem fnCreateItem(int id)
{
// id=OrderID
using (var db = new EF.CMCSQL03Entities())
{
OrderItem vm = new OrderItem();
vm.CrudMode = "RW";
vm.ItemID = -1;
vm.OrderID = id;
var dbOrder = db.tblOrderMaster.Find(id);
vm.ClientID = dbOrder.ClientID;
vm.CreateDate = System.DateTime.Now;
vm.CreateUser = HttpContext.Current.User.Identity.Name;
vm.ProductDetailID = -1;
vm.ListOfProductDetailIDs = fnListOfProductCodes(vm.ClientID);
vm.ProductCode = null;
vm.ProductName = null;
vm.ShelfID = -1;
vm.Size = null;
vm.SRSize = null;
vm.Qty = 1;
vm.LotNumber = null;
vm.ShipDate = null;
vm.CSAllocate = true;
vm.AllocateStatus = null;
vm.NonCMCDelay = false;
vm.CarrierInvoiceRcvd = false;
vm.DelayReason = null;
vm.StatusID = -1;
vm.ListOfStatusNotesIDs = fnListOfStatusNotesIDs();
vm.AlertNotesShipping = "<< AlertNotesShipping >>";
vm.AlertNotesPackOut = "<< AlertNotesPackOut >>";
vm.AlertNotesOrderEntry = "<< AlertNotesOrderEntry >>";
vm.AlertNotesOther = "<< AlertNotesOther >>";
return vm;
}
}
public static void fnSaveItemPostUpdate(OrderItem vm)
{
// pull values for ProductCode, ProductName, Size
using (var db = new EF.CMCSQL03Entities())
{
var q = (from t in db.tblOrderItem
where t.ItemID == vm.ItemID
select t).FirstOrDefault();
var dbPD = (from t in db.tblProductDetail
where t.ProductDetailID == vm.ProductDetailID
select t).FirstOrDefault();
q.ProductCode = dbPD.ProductCode;
q.ProductName = dbPD.ProductName;
if (vm.ShelfID == 99 && !String.IsNullOrEmpty(vm.SRSize))
{
q.Size = vm.SRSize;
}
else
{
var dbSM = (from t in db.tblShelfMaster
where t.ShelfID == vm.ShelfID
select t).FirstOrDefault();
if (dbSM != null)
{
q.Size = dbSM.Size;
q.Weight = dbSM.UnitWeight;
}
}
q.AlertNotesShipping = dbPD.AlertNotesShipping;
var dbPM = db.tblProductMaster.Find(dbPD.ProductMasterID);
q.AlertNotesPackout = dbPM.AlertNotesPackout;
q.AlertNotesOrderEntry = dbPD.AlertNotesOrderEntry; // comes from profiles
if (dbPD.AIRUNNUMBER == "UN3082" | dbPD.AIRUNNUMBER == "UN3077" | dbPD.GRNUNNUMBER == "UN3082" | dbPD.GRNUNNUMBER == "UN3077")
{
q.AlertNotesOther = "Products with UN3082 and UN3077 may be shipped as non hazardous if under 5 kg";
}
db.SaveChanges();
}
}
public static int fnSaveItem(OrderItem vm)
{
fnArchiveOrderItem(vm.ItemID);
using (var db = new EF.CMCSQL03Entities())
{
if (vm.ItemID == -1)
{
vm.ItemID = fnNewItemID();
vm.CreateDate = System.DateTime.Now;
vm.CreateUser = HttpContext.Current.User.Identity.Name;
}
var q = (from t in db.tblOrderItem
where t.ItemID == vm.ItemID
select t).FirstOrDefault();
q.OrderID = vm.OrderID;
q.CreateDate = vm.CreateDate;
q.CreateUser = vm.CreateUser;
q.UpdateDate = System.DateTime.Now;
q.UpdateUser = HttpContext.Current.User.Identity.Name;
q.ProductDetailID = vm.ProductDetailID;
q.ShelfID = vm.ShelfID;
q.Qty = vm.Qty;
q.LotNumber = vm.LotNumber;
q.ShipDate = vm.ShipDate;
q.CSAllocate = vm.CSAllocate;
q.AllocateStatus = vm.AllocateStatus;
q.NonCMCDelay = vm.NonCMCDelay;
q.CarrierInvoiceRcvd = vm.CarrierInvoiceRcvd;
q.Status = vm.Status;
q.DelayReason = vm.DelayReason;
q.ItemNotes = vm.ItemNotes;
db.SaveChanges();
// update the row from other tables
fnSaveItemPostUpdate(vm);
// Go do the Order Trans work....
fnGenerateOrderTransactions(vm.ItemID);
return vm.ItemID;
}
}
