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