public ActionResult CreateSuggestedItem(int ClientID) { SuggestedBulkOrderItem vm = new SuggestedBulkOrderItem(); vm = ReplenishmentsService.fnCreateSuggestedBulkOrderItem(ClientID); return PartialView("~/Views/Replenishments/_SuggestedItemModal.cshtml", vm); }
public ActionResult SaveSuggestedItem(SuggestedBulkOrderItem obj) { int pk = ReplenishmentsService.fnSaveSuggestedItem(obj); return Content("Item Saved at " + DateTime.Now.ToString()); }
public ActionResult EditSuggestedItem(int id) { SuggestedBulkOrderItem vm = new SuggestedBulkOrderItem(); vm = ReplenishmentsService.fnFillSuggestedItemfromDB(id); // limit the drop down items so user cannot change mastercode using (db) { var q = (from t in db.tblSuggestedBulk where t.id == id select t).FirstOrDefault(); vm.ListOfProductMasters = (from t in vm.ListOfProductMasters where Convert.ToInt32(t.Value) == q.ProductMasterID select t).ToList(); } return PartialView("~/Views/Replenishments/_SuggestedItemModal.cshtml", vm); }
public static int fnSaveSuggestedItem(SuggestedBulkOrderItem obj) { using (var db = new MvcPhoenix.EF.CMCSQL03Entities()) { if (obj.id == -1) { obj.id = fnNewSuggestedOrderItemID(); } var dbrow = db.tblSuggestedBulk.Find(obj.id); if (obj.reorderweight == null) { obj.reorderweight = 0; } dbrow.ClientID = obj.clientid; dbrow.ProductMasterID = obj.productmasterid; dbrow.ReorderWeight = obj.reorderweight; dbrow.ReorderNotes = obj.reordernotes; var dbMaster = db.tblProductMaster.Find(obj.productmasterid); dbrow.SupplyID = dbMaster.SUPPLYID; dbrow.UserName = HttpContext.Current.User.Identity.Name; db.SaveChanges(); return obj.id; } }
public static SuggestedBulkOrderItem fnFillSuggestedItemfromDB(int id) { using (var db = new EF.CMCSQL03Entities()) { SuggestedBulkOrderItem obj = new SuggestedBulkOrderItem(); obj = (from t in db.tblSuggestedBulk where t.id == id orderby t.ProductMasterID select new SuggestedBulkOrderItem { id = t.id, clientid = t.ClientID, productmasterid = t.ProductMasterID, supplyid = t.SupplyID, reorderweight = t.ReorderWeight, reordernotes = t.ReorderNotes }).FirstOrDefault(); obj.ListOfProductMasters = fnProductMasterIDs(Convert.ToInt32(obj.clientid)); return obj; } }
public static SuggestedBulkOrderItem fnCreateSuggestedBulkOrderItem(int ClientID) { // a new suggested item needs the client id to get started SuggestedBulkOrderItem obj = new SuggestedBulkOrderItem(); obj.id = -1; // important obj.clientid = ClientID; obj.ListOfProductMasters = ReplenishmentsService.fnProductMasterIDs(obj.clientid); return obj; }