public ActionResult EditCoefficientDet(BONDERANNUALENTITLEMENTCOEDET bonderannualentitlementcoedetedited) { BONDERANNUALENTITLEMENTCOEDET bonderannualentitlementcoedet = new BONDERANNUALENTITLEMENTCOEDET(); if (ModelState.IsValid) { try { bonderannualentitlementcoedet.AESLNO = bonderannualentitlementcoedetedited.AESLNO; bonderannualentitlementcoedet.BONDERSLNO = bonderannualentitlementcoedetedited.BONDERSLNO; bonderannualentitlementcoedet.MSLNO = bonderannualentitlementcoedetedited.MSLNO; bonderannualentitlementcoedet.RMSLNO = bonderannualentitlementcoedetedited.RMSLNO; bonderannualentitlementcoedet.GROSSQT = bonderannualentitlementcoedetedited.GROSSQT; bonderannualentitlementcoedet.WASTAGEQT = bonderannualentitlementcoedetedited.WASTAGEQT; bonderannualentitlementcoedet.SHRINKAGEQT = bonderannualentitlementcoedetedited.SHRINKAGEQT; bonderannualentitlementcoedet.NETQT = bonderannualentitlementcoedetedited.NETQT; db.Entry(bonderannualentitlementcoedet).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("EditCoefficientMas", new { id = bonderannualentitlementcoedetedited.AESLNO, id2 = bonderannualentitlementcoedetedited.BONDERSLNO, id3 = bonderannualentitlementcoedetedited.MSLNO })); } catch (Exception e) { } } return(View(bonderannualentitlementcoedet)); }
public void AddBonderAnnualEntitlementCoE(int?BonderSlno, int id, int[] ProductCoE, string[] ProductWeightCoE, string[] ProductDescriptionCoE, string[] ProductSizeCoE, string[] ProductMeasurementCoE, string[] ProductRawmaterialsCoE, int[] ProductMachineCoE, int[] hscodesCoE, int[] RawmaterialProductID, int[] measuementoCoE, int[] grossCoEs, int[] wastageCoEs, int[] shrinkageCoEs, int[] netCoEs) { if (ProductCoE != null) { int lenth = ProductCoE.Length; for (int i = 0; i < lenth; i++) { BONDERANNUALENTITLEMENTCOM bonderannualentitlementcom = new BONDERANNUALENTITLEMENTCOM(); bonderannualentitlementcom.AESLNO = (Int16)id; bonderannualentitlementcom.BONDERSLNO = (Int16)BonderSlno; bonderannualentitlementcom.MSLNO = (Int16)ProductCoE[i]; bonderannualentitlementcom.WEIGHT = ProductWeightCoE[i]; bonderannualentitlementcom.MSIZE = ProductSizeCoE[i]; bonderannualentitlementcom.MEASUREMENT = ProductMeasurementCoE[i]; //bonderannualentitlementcom.MDESC = ProductDescriptionCoE[i]; bonderannualentitlementcom.MACHINESLNO = (Int16)ProductMachineCoE[i]; for (int j = 0; j < hscodesCoE.Length; j++) { BONDERANNUALENTITLEMENTCOEDET bonderannualentitlementcoedet = new BONDERANNUALENTITLEMENTCOEDET(); OracleEntitiesConnStr db2 = new OracleEntitiesConnStr(); if (ProductCoE[i] == RawmaterialProductID[j]) { bonderannualentitlementcoedet.AESLNO = (Int16)id; bonderannualentitlementcoedet.BONDERSLNO = (Int16)BonderSlno; bonderannualentitlementcoedet.MSLNO = (Int16)ProductCoE[i]; bonderannualentitlementcoedet.RMSLNO = (Int16)hscodesCoE[j]; bonderannualentitlementcoedet.GROSSQT = (Int16)grossCoEs[j]; bonderannualentitlementcoedet.WASTAGEQT = (Int16)wastageCoEs[j]; bonderannualentitlementcoedet.SHRINKAGEQT = (Int16)shrinkageCoEs[j]; bonderannualentitlementcoedet.NETQT = (Int16)netCoEs[j]; db2.BONDERANNUALENTITLEMENTCOEDETs.Add(bonderannualentitlementcoedet); } db2.SaveChanges(); } db.BONDERANNUALENTITLEMENTCOMs.Add(bonderannualentitlementcom); } db.SaveChanges(); //db.SaveChanges(); } }
public ActionResult EditCoefficientDet(int?id, int?id2, int?id3, int?id4) { BONDERANNUALENTITLEMENTCOEDET bonderannualentitlementcoedet = db.BONDERANNUALENTITLEMENTCOEDETs.Where(x => x.AESLNO == id && x.BONDERSLNO == id2 && x.MSLNO == id3 && x.RMSLNO == id4).FirstOrDefault(); if (bonderannualentitlementcoedet == null) { return(HttpNotFound()); } //ViewBag.Rawmaterilas = new SelectList(db.MATERIALS.Where(r => r.MTYPE == "R"), "MSLNO", "MHSCODE", annualentlrawmaterial.MSLNO); //ViewBag.Unit = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME", bonderannualentitlementcoedet.MUSLNO); return(View(bonderannualentitlementcoedet)); }
public ActionResult AddCoefficientRawMaterials(BONDERANNUALENTITLEMENTCOEDET bonderannualentitlementcoedetedited, int?aeslno, int?bonderslno, int?mslno, int?Rawmaterilas) { BONDERANNUALENTITLEMENTCOEDET bonderannualentitlementcoedet = new BONDERANNUALENTITLEMENTCOEDET(); bonderannualentitlementcoedet.AESLNO = (Int16)aeslno; bonderannualentitlementcoedet.BONDERSLNO = (Int16)bonderslno; bonderannualentitlementcoedet.MSLNO = (Int16)mslno; bonderannualentitlementcoedet.RMSLNO = (Int16)Rawmaterilas; bonderannualentitlementcoedet.GROSSQT = (Int32)bonderannualentitlementcoedetedited.GROSSQT; bonderannualentitlementcoedet.WASTAGEQT = (Int32)bonderannualentitlementcoedetedited.WASTAGEQT; bonderannualentitlementcoedet.SHRINKAGEQT = (Int32)bonderannualentitlementcoedetedited.SHRINKAGEQT; bonderannualentitlementcoedet.NETQT = (Int32)bonderannualentitlementcoedetedited.NETQT; db.BONDERANNUALENTITLEMENTCOEDETs.Add(bonderannualentitlementcoedet); db.SaveChanges(); return(RedirectToAction("EditCoefficientMas", new { id = aeslno, id2 = bonderslno, id3 = mslno })); }
public ActionResult AddEntitlementCoefficient(int?aeslno, int?bonderslno, int[] ProductCoE, string[] ProductWeightCoE, string[] ProductDescriptionCoE, string[] ProductSizeCoE, string[] ProductMeasurementCoE, string[] ProductRawmaterialsCoE, int[] ProductMachineCoE, int[] hscodesCoE , int[] measuementoCoE, int[] grossCoEs, int[] wastageCoEs, int[] shrinkageCoEs, int[] netCoEs, int[] RawmaterialProductID) { try { if (ProductCoE != null) { int lenth = ProductCoE.Length; for (int i = 0; i < lenth; i++) { BONDERANNUALENTITLEMENTCOM bonderannualentitlementcom = new BONDERANNUALENTITLEMENTCOM(); bonderannualentitlementcom.AESLNO = (Int16)aeslno; bonderannualentitlementcom.BONDERSLNO = (Int16)bonderslno; bonderannualentitlementcom.MSLNO = (Int16)ProductCoE[i]; bonderannualentitlementcom.WEIGHT = ProductWeightCoE[i]; bonderannualentitlementcom.MSIZE = ProductSizeCoE[i]; bonderannualentitlementcom.MEASUREMENT = ProductMeasurementCoE[i]; //bonderannualentitlementcom.MDESC = ProductDescriptionCoE[i]; bonderannualentitlementcom.MACHINESLNO = (Int16)ProductMachineCoE[i]; for (int j = 0; j < hscodesCoE.Length; j++) { BONDERANNUALENTITLEMENTCOEDET bonderannualentitlementcoedet = new BONDERANNUALENTITLEMENTCOEDET(); OracleEntitiesConnStr db2 = new OracleEntitiesConnStr(); if (ProductCoE[i] == RawmaterialProductID[j]) { bonderannualentitlementcoedet.AESLNO = (Int16)aeslno; bonderannualentitlementcoedet.BONDERSLNO = (Int16)bonderslno; bonderannualentitlementcoedet.MSLNO = (Int16)ProductCoE[i]; bonderannualentitlementcoedet.RMSLNO = (Int16)hscodesCoE[j]; bonderannualentitlementcoedet.GROSSQT = (Int16)grossCoEs[j]; bonderannualentitlementcoedet.WASTAGEQT = (Int16)wastageCoEs[j]; bonderannualentitlementcoedet.SHRINKAGEQT = (Int16)shrinkageCoEs[j]; bonderannualentitlementcoedet.NETQT = (Int16)netCoEs[j]; db2.BONDERANNUALENTITLEMENTCOEDETs.Add(bonderannualentitlementcoedet); } db2.SaveChanges(); } db.BONDERANNUALENTITLEMENTCOMs.Add(bonderannualentitlementcom); } db.SaveChanges(); } return(RedirectToAction("EntitlementDetails", new { ID = aeslno })); } catch { ViewBag.MachineList = new SelectList(db.MACHINEINFORMATIONs, "MACHINESLNO", "MODELNM"); ViewBag.Products = new SelectList(db.MATERIALS.Where(p => p.MTYPE == "F"), "MSLNO", "MHSCODE"); ViewBag.Rawmaterilas = new SelectList(db.MATERIALS.Where(r => r.MTYPE == "r"), "MSLNO", "MHSCODE"); ViewBag.AeSlno = aeslno; ViewBag.BonderSlno = bonderslno; return(View()); } }