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