//
// GET: /Back2BackProduct/Edit/5
public ActionResult Edit(short id = 0)
{
BACKTOBACKPRODUCT backtobackproduct = db.BACKTOBACKPRODUCTs.Find(id);
if (backtobackproduct == null)
{
return(HttpNotFound());
}
ViewBag.BACKTOBACKLCID = new SelectList(db.BACKTOBACKLCs, "ID", "BUYERSNAME", backtobackproduct.BACKTOBACKLCID);
return(View(backtobackproduct));
}
public ActionResult Edit(BACKTOBACKPRODUCT backtobackproduct)
{
if (ModelState.IsValid)
{
db.Entry(backtobackproduct).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BACKTOBACKLCID = new SelectList(db.BACKTOBACKLCs, "ID", "BUYERSNAME", backtobackproduct.BACKTOBACKLCID);
return(View(backtobackproduct));
}
public ActionResult RawMaterialEntry(short productId = 0)
{
System.Diagnostics.Debug.WriteLine("RawMaterialEntry(BACKTOBACKPRODUCTs): productId = " + productId);
BACKTOBACKPRODUCT backtobackProduct = db.BACKTOBACKPRODUCTs.Find(productId);
if (backtobackProduct == null)
{
return(HttpNotFound());
}
return(View(backtobackProduct));
}
public ActionResult Create(BACKTOBACKPRODUCT backtobackproduct)
{
if (ModelState.IsValid)
{
db.BACKTOBACKPRODUCTs.Add(backtobackproduct);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BACKTOBACKLCID = new SelectList(db.BACKTOBACKLCs, "ID", "BUYERSNAME", backtobackproduct.BACKTOBACKLCID);
return(View(backtobackproduct));
}
public ActionResult AddRawMaterial(BACKTOBACKPRODUCT backtobackProduct)
{
USERPERMISSION userpermission = sessionAttributeRetreival.getStoredUserPermission();
foreach (var item in backtobackProduct.RAWMATERIALs)
{
item.PRODUCTID = backtobackProduct.ID;
}
DateTime thisDay = DateTime.Now;
var user = "******";
System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " ModelState.IsValid: " + ModelState.IsValid);
// if (ModelState.IsValid)
if (true)
{
try
{
foreach (var rawMaterial in backtobackProduct.RAWMATERIALs)
{
var productId = rawMaterial.PRODUCTID;
System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " productId: " + productId);
System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " backtobackProduct.BACKTOBACKLCID: " + backtobackProduct.BACKTOBACKLCID);
using (var dbRawMaterial = new OracleEntitiesConnStr())
{
RAWMATERIAL newRawMaterial = new RAWMATERIAL();
newRawMaterial.RAWMATERIALCODE = rawMaterial.RAWMATERIALCODE;
newRawMaterial.QUANTITY = rawMaterial.QUANTITY;
newRawMaterial.UNIT = rawMaterial.UNIT;
newRawMaterial.PERMITTEDWASTE = rawMaterial.PERMITTEDWASTE;
newRawMaterial.PRODUCTID = productId;
if (userpermission != null)
{
newRawMaterial.CREATEDBY = userpermission.APPUSER.USERNAME;
}
newRawMaterial.CREATEDDATE = thisDay;
dbRawMaterial.RAWMATERIALs.Add(newRawMaterial);
dbRawMaterial.SaveChanges();
}
}
return(RedirectToAction("Details/" + backtobackProduct.BACKTOBACKLCID));
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine("Create(BACKTOBACKPRODUCTs): Time-" + thisDay + " Exception = " + e.StackTrace);
}
}
return(View());
}
public ActionResult Details(short id = 0)
{
ApprovedUPViewModel viewModel = new ApprovedUPViewModel();
UP up = db.UPs.Find(id);
if (up == null)
{
return(HttpNotFound());
}
List <UPREQUEST> uprequestList = new List <UPREQUEST>();
List <EXBOND> exbondList = new List <EXBOND>();
List <BACKTOBACKLC> b2bList = new List <BACKTOBACKLC>();
List <BACKTOBACKPRODUCT> productList = new List <BACKTOBACKPRODUCT>();
List <RAWMATERIAL> rawmaterialList = new List <RAWMATERIAL>();
List <ATTACHMENT> attachments = new List <ATTACHMENT>();
var uprequests = db.UPREQUESTLISTs.Where(eb => eb.UPID == id).ToList();
for (int i = 0; i < uprequests.Count(); i++)
{
UPREQUEST uprequest = db.UPREQUESTs.Find(uprequests[i].UPREQUESTID);
if (uprequest != null)
{
for (int j = 0; j < uprequest.UPEXBONDLISTs.Count(); j++)
{
EXBOND exbond = db.EXBONDs.Find(uprequest.UPEXBONDLISTs[j].EXBONDID);
if (exbond != null)
{
for (int k = 0; k < exbond.EXBONDBACKTOBACKs.Count(); k++)
{
BACKTOBACKLC backtoback = db.BACKTOBACKLCs.Find(exbond.EXBONDBACKTOBACKs.ElementAt(k).BACKTOBACKID);
if (backtoback != null)
{
for (int l = 0; l < backtoback.BACKTOBACKPRODUCTs.Count(); l++)
{
BACKTOBACKPRODUCT product = db.BACKTOBACKPRODUCTs.Find(backtoback.BACKTOBACKPRODUCTs[l].ID);
if (product != null)
{
if (product.RAWMATERIALs.Count() > 0)
{
rawmaterialList = product.RAWMATERIALs.ToList();
}
productList.Add(product);
}
}
b2bList.Add(backtoback);
}
}
exbondList.Add(exbond);
}
}
if (uprequest.ATTACHMENTs.Count() > 0)
{
attachments = uprequest.ATTACHMENTs.ToList();
}
uprequestList.Add(uprequest);
}
}
viewModel.UP = up;
viewModel.UPREQUESTs = uprequestList;
viewModel.BACKTOBACKLCs = b2bList;
viewModel.BACKTOBACKPRODUCTs = productList;
viewModel.EXBONDs = exbondList;
viewModel.RAWMATERIALs = rawmaterialList;
viewModel.ATTACHMENTs = attachments;
return(View(viewModel));
}
public ActionResult Edit(BACKTOBACKLC backtobacklc)
{
USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission();
if (loggedinUser != null)
{
backtobacklc.MODIFIEDBY = loggedinUser.APPUSER.USERNAME;
}
if (loggedinUser != null && loggedinUser.BONDERID != null)
{
ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == loggedinUser.BONDERID), "BONDERSLNO", "BONDERNAME", backtobacklc.BONDERID);
}
else
{
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", backtobacklc.BONDERID);
}
foreach (var item in backtobacklc.BACKTOBACKPRODUCTs)
{
item.BACKTOBACKLCID = backtobacklc.ID;
}
DateTime thisDay = DateTime.Now;
bool isAddMore = false;
if (true)
{
try
{
if (backtobacklc.BACKTOBACKPRODUCTs != null && backtobacklc.BACKTOBACKPRODUCTs.Count > 0)
{
if (backtobacklc.BONDERID != null)
{
USERPERMISSION userpermission = sessionAttributeRetreival.getStoredUserPermission();
int bonderId = backtobacklc.BONDERID;
if (userpermission != null)
{
List <INBONDRAWMATERIAL> inbondRawMaterials = db.INBONDRAWMATERIALs.Where(inb => inb.INBOND.BONDERID == bonderId).ToList();
if (inbondRawMaterials != null)
{
decimal bonderUsedQuantity = inbondRawMaterials.Sum(item => item.PRODUCTQUANTITY);
decimal?bonderProvidedQuantity = backtobacklc.BACKTOBACKPRODUCTs.Sum(item => item.QUANTITY);
if (bonderUsedQuantity < bonderProvidedQuantity)
{
ModelState.AddModelError("", "Your Remaining Inbond Raw Material Quantity " + bonderUsedQuantity);
ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backtobacklc.BUYERSBANKBRANCHID);
ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backtobacklc.BUYERSBANKID);
if (userpermission != null && userpermission.BONDERID != null)
{
ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == userpermission.BONDERID), "BONDERSLNO", "BONDERNAME", userpermission.BONDERID);
}
else
{
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", backtobacklc.BONDERID);
}
ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.QUANTITYUNIT);
ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backtobacklc.PRICEUNIT);
for (int i = 0; i < backtobacklc.BACKTOBACKPRODUCTs.Count(); i++)
{
ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.BACKTOBACKPRODUCTs[i].QUANTITYUNIT);
}
for (int i = 0; i < backtobacklc.BACKTOBACKPRODUCTs.Count(); i++)
{
return(RedirectToAction("Addmore", new { errorMessage = "Your Remaining Inbond Raw Material Quantity " + bonderUsedQuantity, id = backtobacklc.ID }));
}
return(View(backtobacklc));
}
}
}
}
System.Diagnostics.Debug.WriteLine("Edit(BACKTOBACKPRODUCTs): Time-" + thisDay + " BACKTOBACKPRODUCTs count = " + backtobacklc.BACKTOBACKPRODUCTs.Count);
foreach (var item in backtobacklc.BACKTOBACKPRODUCTs)
{
if (item.NAME != null)
{
System.Diagnostics.Debug.WriteLine("Edit(BACKTOBACKPRODUCTs): Time-" + thisDay + " item.ID = " + item.ID);
if (item.ID == 0)
{
using (var db1 = new OracleEntitiesConnStr())
{
BACKTOBACKPRODUCT newItem = new BACKTOBACKPRODUCT();
newItem.ID = item.ID;
newItem.BACKTOBACKLCID = item.BACKTOBACKLCID;
newItem.NAME = item.NAME;
newItem.QUANTITY = item.QUANTITY;
newItem.QUANTITYUNIT = item.QUANTITYUNIT;
newItem.CREATEDDATE = thisDay;
newItem.SIZEANDDETAIL = item.SIZEANDDETAIL;
newItem.ID = item.ID;
db1.BACKTOBACKPRODUCTs.Add(newItem);
db1.SaveChanges();
}
short lastProductId = db.BACKTOBACKPRODUCTs.Max(itemBack2Back => itemBack2Back.ID);
foreach (var rawMaterial in item.RAWMATERIALs)
{
using (var dbRawMaterial = new OracleEntitiesConnStr())
{
RAWMATERIAL newRawMaterial = new RAWMATERIAL();
newRawMaterial.RAWMATERIALCODE = rawMaterial.RAWMATERIALCODE;
newRawMaterial.QUANTITY = rawMaterial.QUANTITY;
newRawMaterial.UNIT = rawMaterial.UNIT;
newRawMaterial.PERMITTEDWASTE = rawMaterial.PERMITTEDWASTE;
newRawMaterial.PRODUCTID = lastProductId;
newRawMaterial.CREATEDDATE = thisDay;
dbRawMaterial.RAWMATERIALs.Add(newRawMaterial);
dbRawMaterial.SaveChanges();
}
}
}
if (item.ID > 0)
{
using (var db1 = new OracleEntitiesConnStr())
{
BACKTOBACKPRODUCT newItem = new BACKTOBACKPRODUCT();
newItem.ID = item.ID;
newItem.BACKTOBACKLCID = item.BACKTOBACKLCID;
newItem.NAME = item.NAME;
newItem.QUANTITY = item.QUANTITY;
newItem.QUANTITYUNIT = item.QUANTITYUNIT;
newItem.CREATEDDATE = thisDay;
newItem.SIZEANDDETAIL = item.SIZEANDDETAIL;
newItem.ID = item.ID;
db1.Entry(newItem).State = EntityState.Modified;
db1.SaveChanges();
}
foreach (var rawMaterial in item.RAWMATERIALs)
{
using (var dbRawMaterial = new OracleEntitiesConnStr())
{
RAWMATERIAL newRawMaterial = new RAWMATERIAL();
newRawMaterial.ID = rawMaterial.ID;
newRawMaterial.RAWMATERIALCODE = rawMaterial.RAWMATERIALCODE;
newRawMaterial.QUANTITY = rawMaterial.QUANTITY;
newRawMaterial.UNIT = rawMaterial.UNIT;
newRawMaterial.PERMITTEDWASTE = rawMaterial.PERMITTEDWASTE;
newRawMaterial.PRODUCTID = item.ID;
newRawMaterial.CREATEDDATE = thisDay;
dbRawMaterial.Entry(newRawMaterial).State = EntityState.Modified;
dbRawMaterial.SaveChanges();
}
}
}
}
}
BACKTOBACKLC newBacktobacklc = new BACKTOBACKLC();
newBacktobacklc.BUYERSNAME = backtobacklc.BUYERSNAME;
newBacktobacklc.BUYERSADDRESS = backtobacklc.BUYERSADDRESS;
newBacktobacklc.LCNUMBER = backtobacklc.LCNUMBER;
newBacktobacklc.LCDATE = backtobacklc.LCDATE;
newBacktobacklc.BUYERSBANKID = backtobacklc.BUYERSBANKID;
newBacktobacklc.BUYERSBANKBRANCHID = backtobacklc.BUYERSBANKBRANCHID;
newBacktobacklc.SHIPPINGDATE = backtobacklc.SHIPPINGDATE;
newBacktobacklc.CORRECTIONDATE = backtobacklc.CORRECTIONDATE;
newBacktobacklc.PRODUCTQUANTITY = backtobacklc.PRODUCTQUANTITY;
newBacktobacklc.QUANTITYUNIT = backtobacklc.QUANTITYUNIT;
newBacktobacklc.LCUSEDPRICE = backtobacklc.LCUSEDPRICE;
newBacktobacklc.PRICEUNIT = backtobacklc.PRICEUNIT;
newBacktobacklc.MASTERLCNUMBER = backtobacklc.MASTERLCNUMBER;
newBacktobacklc.MASTERLCCORRECTIONDATE = backtobacklc.MASTERLCCORRECTIONDATE;
newBacktobacklc.UDNUMBER = backtobacklc.UDNUMBER;
newBacktobacklc.UDDATE = backtobacklc.UDDATE;
newBacktobacklc.UDCORRECTIONDATE = backtobacklc.UDCORRECTIONDATE;
newBacktobacklc.UDPRODUCTDETAIL = backtobacklc.UDPRODUCTDETAIL;
newBacktobacklc.BONDERID = backtobacklc.BONDERID;
newBacktobacklc.CREATEDBY = backtobacklc.CREATEDBY;
newBacktobacklc.CREATEDDATE = backtobacklc.CREATEDDATE;
if (loggedinUser != null)
{
newBacktobacklc.MODIFIEDBY = loggedinUser.APPUSER.USERNAME;
}
newBacktobacklc.MODIFIEDDATE = thisDay;
newBacktobacklc.ID = backtobacklc.ID;
db.Entry(newBacktobacklc).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception e)
{
ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backtobacklc.BUYERSBANKBRANCHID);
ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backtobacklc.BUYERSBANKID);
ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.QUANTITYUNIT);
ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backtobacklc.PRICEUNIT);
for (int i = 0; i < backtobacklc.BACKTOBACKPRODUCTs.Count(); i++)
{
if (backtobacklc.BACKTOBACKPRODUCTs[i].ID <= 0)
{
isAddMore = true;
}
ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.BACKTOBACKPRODUCTs[i].QUANTITYUNIT);
}
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(c => c.ErrorMessage));
ViewBag.error = "all field values are required for product!";
if (isAddMore)
{
return(RedirectToAction("Addmore", new { errorMessage = message, id = backtobacklc.ID }));
}
return(Redirect(ControllerContext.HttpContext.Request.UrlReferrer.ToString()));
}
}
return(View(backtobacklc));
}
public ActionResult Create(BACKTOBACKLC backToBackLC)
{
USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission();
if (loggedinUser != null)
{
backToBackLC.CREATEDBY = loggedinUser.APPUSER.USERNAME;
}
if (loggedinUser != null && loggedinUser.BONDERID != null)
{
ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == loggedinUser.BONDERID), "BONDERSLNO", "BONDERNAME", loggedinUser.BONDERID);
}
else
{
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME");
}
foreach (var item in backToBackLC.BACKTOBACKPRODUCTs)
{
item.BACKTOBACKLCID = backToBackLC.ID;
}
DateTime thisDay = DateTime.Now;
System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " ModelState.IsValid: " + ModelState.IsValid);
var errors = ModelState.Values.SelectMany(v => v.Errors);
System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " errors: " + errors);
//if (ModelState.IsValid)
if (true)
{
try
{
if (backToBackLC.BACKTOBACKPRODUCTs != null && backToBackLC.BACKTOBACKPRODUCTs.Count > 0)
{
if (backToBackLC.BONDERID != null)
{
USERPERMISSION userpermission = sessionAttributeRetreival.getStoredUserPermission();
int bonderId = backToBackLC.BONDERID;
if (userpermission != null)
{
List <INBONDRAWMATERIAL> inbondRawMaterials = db.INBONDRAWMATERIALs.Where(inb => inb.INBOND.BONDERID == bonderId).ToList();
if (inbondRawMaterials != null)
{
decimal bonderUsedQuantity = inbondRawMaterials.Sum(item => item.PRODUCTQUANTITY);
decimal?bonderProvidedQuantity = backToBackLC.BACKTOBACKPRODUCTs.Sum(item => item.QUANTITY);
if (bonderUsedQuantity < bonderProvidedQuantity)
{
ModelState.AddModelError("", "Your Remaining Inbond Raw Material Quantity " + bonderUsedQuantity);
ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backToBackLC.BUYERSBANKBRANCHID);
ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backToBackLC.BUYERSBANKID);
if (userpermission != null && userpermission.BONDERID != null)
{
ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == userpermission.BONDERID), "BONDERSLNO", "BONDERNAME", userpermission.BONDERID);
}
else
{
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", backToBackLC.BONDERID);
}
ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backToBackLC.QUANTITYUNIT);
ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backToBackLC.PRICEUNIT);
for (int i = 0; i < backToBackLC.BACKTOBACKPRODUCTs.Count(); i++)
{
ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backToBackLC.BACKTOBACKPRODUCTs[i].QUANTITYUNIT);
}
return(View(backToBackLC));
}
}
}
}
BACKTOBACKLC newBacktobacklc = new BACKTOBACKLC();
newBacktobacklc.BUYERSNAME = backToBackLC.BUYERSNAME;
newBacktobacklc.BUYERSADDRESS = backToBackLC.BUYERSADDRESS;
newBacktobacklc.LCNUMBER = backToBackLC.LCNUMBER;
newBacktobacklc.LCDATE = backToBackLC.LCDATE;
newBacktobacklc.BUYERSBANKID = backToBackLC.BUYERSBANKID;
newBacktobacklc.BUYERSBANKBRANCHID = backToBackLC.BUYERSBANKBRANCHID;
newBacktobacklc.SHIPPINGDATE = backToBackLC.SHIPPINGDATE;
newBacktobacklc.CORRECTIONDATE = backToBackLC.CORRECTIONDATE;
newBacktobacklc.PRODUCTQUANTITY = backToBackLC.PRODUCTQUANTITY;
newBacktobacklc.QUANTITYUNIT = backToBackLC.QUANTITYUNIT;
newBacktobacklc.LCUSEDPRICE = backToBackLC.LCUSEDPRICE;
newBacktobacklc.PRICEUNIT = backToBackLC.PRICEUNIT;
newBacktobacklc.MASTERLCNUMBER = backToBackLC.MASTERLCNUMBER;
newBacktobacklc.MASTERLCCORRECTIONDATE = backToBackLC.MASTERLCCORRECTIONDATE;
newBacktobacklc.UDNUMBER = backToBackLC.UDNUMBER;
newBacktobacklc.UDDATE = backToBackLC.UDDATE;
newBacktobacklc.UDCORRECTIONDATE = backToBackLC.UDCORRECTIONDATE;
newBacktobacklc.UDPRODUCTDETAIL = backToBackLC.UDPRODUCTDETAIL;
newBacktobacklc.BONDERID = backToBackLC.BONDERID;
if (loggedinUser != null)
{
newBacktobacklc.CREATEDBY = loggedinUser.APPUSER.USERNAME;
}
newBacktobacklc.CREATEDDATE = thisDay;
db.BACKTOBACKLCs.Add(newBacktobacklc);
db.SaveChanges();
short lastBackToBackId = db.BACKTOBACKLCs.Max(item => item.ID);
foreach (var product in backToBackLC.BACKTOBACKPRODUCTs)
{
using (var dbBackToBackProduct = new OracleEntitiesConnStr())
{
BACKTOBACKPRODUCT newProduct = new BACKTOBACKPRODUCT();
newProduct.NAME = product.NAME;
newProduct.SIZEANDDETAIL = product.SIZEANDDETAIL;
newProduct.QUANTITY = product.QUANTITY;
newProduct.QUANTITYUNIT = product.QUANTITYUNIT;
newProduct.BACKTOBACKLCID = lastBackToBackId;
newProduct.CREATEDBY = backToBackLC.CREATEDBY;
newProduct.CREATEDDATE = thisDay;
System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " BACKTOBACKPRODUCTs " + backToBackLC.BACKTOBACKPRODUCTs.Count());
dbBackToBackProduct.BACKTOBACKPRODUCTs.Add(newProduct);
dbBackToBackProduct.SaveChanges();
short lastProductId = db.BACKTOBACKPRODUCTs.Max(itemBack2Back => itemBack2Back.ID);
//System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " lastProductId = " + lastProductId);
foreach (var rawMaterial in product.RAWMATERIALs)
{
using (var dbRawMaterial = new OracleEntitiesConnStr())
{
RAWMATERIAL newRawMaterial = new RAWMATERIAL();
newRawMaterial.RAWMATERIALCODE = rawMaterial.RAWMATERIALCODE;
newRawMaterial.QUANTITY = rawMaterial.QUANTITY;
newRawMaterial.UNIT = rawMaterial.UNIT;
newRawMaterial.PERMITTEDWASTE = rawMaterial.PERMITTEDWASTE;
newRawMaterial.PRODUCTID = lastProductId;
newRawMaterial.CREATEDDATE = thisDay;
dbRawMaterial.RAWMATERIALs.Add(newRawMaterial);
dbRawMaterial.SaveChanges();
}
}
}
}
}
else
{
backToBackLC.CREATEDDATE = thisDay;
db.BACKTOBACKLCs.Add(backToBackLC);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult item in ex.EntityValidationErrors)
{
// Get entry
DbEntityEntry entry = item.Entry;
string entityTypeName = entry.Entity.GetType().Name;
// Display or log error messages
foreach (DbValidationError subItem in item.ValidationErrors)
{
string message = string.Format("Error '{0}' occurred in {1} at {2}", subItem.ErrorMessage, entityTypeName, subItem.PropertyName);
System.Diagnostics.Debug.WriteLine("Create(BACKTOBACKPRODUCTs): Time-" + thisDay + " Exception = " + message);
ViewBag.error = message;
}
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine("Create(BACKTOBACKPRODUCTs): Time-" + thisDay + " Exception = " + e.StackTrace);
}
}
ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backToBackLC.BUYERSBANKBRANCHID);
ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backToBackLC.BUYERSBANKID);
ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backToBackLC.QUANTITYUNIT);
ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backToBackLC.PRICEUNIT);
for (int i = 0; i < backToBackLC.BACKTOBACKPRODUCTs.Count(); i++)
{
ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backToBackLC.BACKTOBACKPRODUCTs[i].QUANTITYUNIT);
}
return(View(backToBackLC));
}
