public static void fnSavePrePackStock(PrePackStock vm, FormCollection fc) { using (var db = new CMCSQL03Entities()) { // for each sm, insert tblStock vm.BulkContainer.bulkid = fnNewBulkID(); var dbBulk = db.tblBulk.Find(vm.BulkContainer.bulkid); var dbPD = db.tblProductDetail.Find(vm.ProductDetailID); dbBulk.ProductMasterID = dbPD.ProductMasterID; dbBulk.Qty = 1; dbBulk.ReceiveDate = vm.BulkContainer.receivedate; dbBulk.LotNumber = vm.BulkContainer.lotnumber; dbBulk.MfgDate = vm.BulkContainer.mfgdate; dbBulk.ExpirationDate = vm.BulkContainer.expirationdate; dbBulk.CeaseShipDate = vm.BulkContainer.ceaseshipdate; dbBulk.QCDate = vm.BulkContainer.qcdate; dbBulk.BulkStatus = vm.BulkContainer.bulkstatus; dbBulk.Bin = vm.BulkContainer.bin; dbBulk.Warehouse = vm.BulkContainer.warehouse; dbBulk.CreateDate = System.DateTime.Now; dbBulk.CreateUser = System.Web.HttpContext.Current.User.Identity.Name; dbBulk.ReceiveWeight = 0; dbBulk.CurrentWeight = 0; for (int i = 1; i <= vm.ShelfMasterCount; i++) { // this will always have a value string sThisShelfID = fc["Key" + i.ToString()]; Int32 ThisShelfID = Convert.ToInt32(sThisShelfID); string sThisQty = fc["Value" + i.ToString()]; if (!String.IsNullOrEmpty(sThisQty)) { Int32 ThisQty = Convert.ToInt32(sThisQty); var newstock = new EF.tblStock(); newstock.ShelfID = ThisShelfID; newstock.BulkID = vm.BulkContainer.bulkid; newstock.Warehouse = vm.BulkContainer.warehouse; newstock.QtyOnHand = ThisQty; var sm = (from t in db.tblShelfMaster where t.ShelfID == ThisShelfID select t).FirstOrDefault(); // needed for default bin dbBulk.ReceiveWeight = dbBulk.ReceiveWeight + (ThisQty * sm.UnitWeight); newstock.Bin = sm.Bin; newstock.ShelfStatus = "AVAIL"; newstock.CreateDate = DateTime.Now; newstock.CreateUser = HttpContext.Current.User.Identity.Name; db.tblStock.Add(newstock); db.SaveChanges(); } } } }
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; }