public ActionResult CreateItem(int id) { // id = bulkorderid ..create a new line item to an existing bulkorderid BulkOrderItem obj = new BulkOrderItem(); obj = ReplenishmentsService.fnCreateItem(id); return PartialView("~/Views/Replenishments/_BulkOrderItemModal.cshtml", obj); }
public ActionResult SaveItem(BulkOrderItem obj) { // Catch form if no master code is selected if (obj.productmasterid == 0) { return Content("Please Select Master Code"); } else { int pk = ReplenishmentsService.fnSaveItem(obj); return Content("Item Saved at " + DateTime.Now.ToString()); } }
public ActionResult EditItem(int id) { BulkOrderItem obj = new BulkOrderItem(); obj = ReplenishmentsService.fnFillItemFromDB(id); return PartialView("~/Views/Replenishments/_BulkOrderItemModal.cshtml", obj); }
public static int fnSaveItem(BulkOrderItem obj) { System.Threading.Thread.Sleep(1500); using (var db = new MvcPhoenix.EF.CMCSQL03Entities()) { if (obj.bulkorderitemid == -1) { obj.bulkorderitemid = fnNewBulkOrderItemID(); } var dbrow = (from t in db.tblBulkOrderItem where t.BulkOrderItemID == obj.bulkorderitemid select t).FirstOrDefault(); dbrow.BulkOrderID = obj.bulkorderid; dbrow.ProductMasterID = obj.productmasterid; dbrow.Weight = obj.weight; dbrow.Status = obj.itemstatus; dbrow.ETA = obj.eta; dbrow.DateReceived = obj.datereceived; dbrow.ItemNotes = obj.itemnotes; db.SaveChanges(); return obj.bulkorderitemid; } }
public static BulkOrderItem fnFillItemFromDB(int id) { // build object and return using (var db = new MvcPhoenix.EF.CMCSQL03Entities()) { BulkOrderItem obj = new BulkOrderItem(); obj = (from t in db.tblBulkOrderItem where t.BulkOrderItemID == id select new BulkOrderItem { bulkorderitemid = t.BulkOrderItemID, bulkorderid = t.BulkOrderID, productmasterid = t.ProductMasterID, weight = t.Weight, itemstatus = t.Status, eta = t.ETA, datereceived = t.DateReceived, itemnotes = t.ItemNotes, }).FirstOrDefault(); var dbBulkOrder = db.tblBulkOrder.Find(obj.bulkorderid); obj.ListOfProductMasters = fnProductMasterIDs(Convert.ToInt32(dbBulkOrder.ClientID)); obj.ListOfItemStatusIDs = fnOrderItemStatusIDs(); return obj; } }
public static BulkOrderItem fnCreateItem(int id) { using (var db = new MvcPhoenix.EF.CMCSQL03Entities()) { BulkOrderItem obj = new BulkOrderItem(); var dbBulkOrder = db.tblBulkOrder.Find(id); obj.bulkorderitemid = -1; obj.bulkorderid = id; obj.productmasterid = null; obj.weight = null; obj.itemstatus = "OP"; obj.eta = null; obj.datereceived = null; obj.itemnotes = null; obj.ListOfProductMasters = fnProductMasterIDs(Convert.ToInt32(dbBulkOrder.ClientID)); obj.ListOfItemStatusIDs = fnOrderItemStatusIDs(); return obj; } }