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