public ActionResult EnterPrePack(FormCollection fc) { // Take clientid and productdetailid from POST and build ViewModel, return data entry view int fc_clientid = Convert.ToInt32(fc["ClientID"]); int fc_productdetailid = Convert.ToInt32(fc["productdetailid"]); PrePackViewModel obj = new PrePackViewModel(); obj = ReceivingService.fnNewBulkContainerForPrePack(fc_clientid, fc_productdetailid); return View("~/Views/Receiving/EnterPrePack.cshtml", obj); }
public static bool fnSavePrePack(PrePackViewModel vm, FormCollection fc) { bool retval = true; try { using (var db = new EF.CMCSQL03Entities()) { var newbulk = new EF.tblBulk(); newbulk.ProductMasterID = vm.productmasterid; newbulk.ReceiveDate = vm.receivedate; newbulk.LotNumber = vm.lotnumber; newbulk.CeaseShipDate = vm.ceaseshipdate; newbulk.Carrier = vm.carrier; newbulk.ReceivedBy = vm.receivedby; newbulk.QCDate = vm.qcdate; newbulk.Warehouse = vm.warehouse; newbulk.MfgDate = vm.mfgdate; newbulk.COAIncluded = vm.coaincluded; newbulk.EnteredBy = vm.enteredby; newbulk.ExpirationDate = vm.expirationdate; newbulk.MSDSIncluded = vm.msdsincluded; newbulk.BulkStatus = "PP"; db.tblBulk.Add(newbulk); db.SaveChanges(); int newBulkID = newbulk.BulkID; for (int i = 1; i <= vm.ItemsCount; i++) { string sThisShelfID = fc["Key" + i.ToString()]; int ThisShelfID = Convert.ToInt32(sThisShelfID); string sThisQty = fc["Value" + i.ToString()]; int ThisQty = Convert.ToInt32(sThisQty); //System.Diagnostics.Debug.WriteLine("Shelfid=" + ThisShelfID + " | Qty=" + ThisQty); var newstock = new EF.tblStock(); newstock.BulkID = newBulkID; newstock.ShelfID = ThisShelfID; newstock.CreateDate = DateTime.Now; newstock.Warehouse = vm.warehouse; newstock.QtyOnHand = ThisQty; //newStock.Bin = null; // ??? newstock.ShelfStatus = "PP"; db.tblStock.Add(newstock); db.SaveChanges(); } } } catch { retval = false; throw new Exception("Error occurred saving Pre Packs"); } return retval; }
public static PrePackViewModel fnNewBulkContainerForPrePack(int clientid, int productdetailid) { PrePackViewModel obj = new PrePackViewModel(); using (var db = new CMCSQL03Entities()) { var dbClient = db.tblClient.Find(clientid); var dbProductDetail = db.tblProductDetail.Find(productdetailid); obj.productmasterid = dbProductDetail.ProductMasterID; obj.isknownmaterial = true; obj.clientid = clientid; obj.clientname = dbClient.ClientName; obj.logofilename = dbClient.LogoFileName; obj.bulkid = -1; // for insert later obj.receivedate = DateTime.Now; obj.carrier = null; obj.ListOfCarriers = fnCarriers(); obj.warehouse = null; obj.ListOfWareHouses = fnWarehouseIDs(); obj.enteredby = null; obj.lotnumber = null; obj.receivedby = null; obj.mfgdate = null; obj.expirationdate = null; obj.ceaseshipdate = null; obj.qcdate = null; obj.msdsincluded = null; obj.coaincluded = null; obj.productcode = dbProductDetail.ProductCode; obj.productname = dbProductDetail.ProductName; obj.ListOfShelfMasters = (from t in db.tblShelfMaster orderby t.ShelfID where t.ProductDetailID == productdetailid select new ItemForPrePackViewModel { shelfid = t.ShelfID, size = t.Size, bin = t.Bin }).ToList(); obj.ItemsCount = obj.ListOfShelfMasters.Count(); return obj; } }
public ActionResult SavePrePack(PrePackViewModel vm, FormCollection fc) { bool bSave = ReceivingService.fnSavePrePack(vm, fc); return Content("Items Added to Shelf Stock: " + DateTime.Now.ToString()); }