public ActionResult EditCoefficientMas(CoefficientMasterDetailViewModel coefficientmasterdetailviewmodeledt, int?MachineList) { BONDERANNUALENTITLEMENTCOM bonderannualentitlementcom = new BONDERANNUALENTITLEMENTCOM(); //CoefficientMasterDetailViewModel coefficientmasterdetailviewmodel = new CoefficientMasterDetailViewModel(); if (ModelState.IsValid) { try { bonderannualentitlementcom.AESLNO = coefficientmasterdetailviewmodeledt.Bonderannualentitlementcoms.AESLNO; bonderannualentitlementcom.BONDERSLNO = coefficientmasterdetailviewmodeledt.Bonderannualentitlementcoms.BONDERSLNO; bonderannualentitlementcom.MSLNO = coefficientmasterdetailviewmodeledt.Bonderannualentitlementcoms.MSLNO; bonderannualentitlementcom.WEIGHT = coefficientmasterdetailviewmodeledt.Bonderannualentitlementcoms.WEIGHT; bonderannualentitlementcom.MSIZE = coefficientmasterdetailviewmodeledt.Bonderannualentitlementcoms.MSIZE; bonderannualentitlementcom.MEASUREMENT = coefficientmasterdetailviewmodeledt.Bonderannualentitlementcoms.MEASUREMENT; bonderannualentitlementcom.MACHINESLNO = (Int16)MachineList; db.Entry(bonderannualentitlementcom).State = EntityState.Modified; db.SaveChanges(); ViewBag.Products = new SelectList(db.MATERIALS.Where(r => r.MTYPE == "F"), "MSLNO", "MATERIALNAME", bonderannualentitlementcom.MSLNO); ViewBag.Rawmaterilas = new SelectList(db.MATERIALS.Where(r => r.MTYPE == "r"), "MSLNO", "MATERIALNAME"); return(RedirectToAction("EntitlementDetails", new { id = bonderannualentitlementcom.AESLNO })); } catch (Exception e) { } } ViewBag.MachineList = new SelectList(db.MACHINEINFORMATIONs, "MACHINESLNO", "MODELNM", coefficientmasterdetailviewmodeledt.Bonderannualentitlementcoms.MACHINESLNO); return(View(bonderannualentitlementcom)); }
public ActionResult EditCoefficientMas(int?id, int?id2, int?id3) { CoefficientMasterDetailViewModel coefficientmasterdetailviewmodel = new CoefficientMasterDetailViewModel(); coefficientmasterdetailviewmodel.Bonderannualentitlementcoms = db.BONDERANNUALENTITLEMENTCOMs.Where(x => x.AESLNO == id && x.BONDERSLNO == id2 && x.MSLNO == id3).FirstOrDefault(); //coefficientmasterdetailviewmodel.Bonderannualentitlementcoedets = db.BONDERANNUALENTITLEMENTCOEDETs.Where(x => x.AESLNO == id && x.BONDERSLNO == id2 && x.MSLNO == id3).ToList(); var List = (from r in db.BONDERANNUALENTITLEMENTCOEDETs where r.AESLNO == id && r.BONDERSLNO == id2 && r.MSLNO == id3 select new { aeslno = r.AESLNO, bonderslno = r.BONDERSLNO, mslno = r.MSLNO, rawslno = r.RMSLNO, gross = r.GROSSQT, wastage = r.WASTAGEQT, shrinkage = r.SHRINKAGEQT, net = r.NETQT }).ToList(); List <BONDERANNUALENTITLEMENTCOEDET> rawdetlist = new List <BONDERANNUALENTITLEMENTCOEDET>(); foreach (var item in List) { rawdetlist.Add( new BONDERANNUALENTITLEMENTCOEDET { AESLNO = item.aeslno, BONDERSLNO = item.bonderslno, MSLNO = item.mslno, RMSLNO = item.rawslno, INPUTBY = (from t2 in db.MATERIALS where t2.MSLNO == item.rawslno select t2.MATERIALNAME).FirstOrDefault().ToString(), MODIFIEDBY = (from t2 in db.MATERIALS where t2.MSLNO == item.rawslno select t2.MHSCODE).FirstOrDefault().ToString(), GROSSQT = item.gross, WASTAGEQT = item.wastage, SHRINKAGEQT = item.shrinkage, NETQT = item.net } ); } coefficientmasterdetailviewmodel.Bonderannualentitlementcoedets = rawdetlist; if (coefficientmasterdetailviewmodel == null) { return(HttpNotFound()); } ViewBag.Products = new SelectList(db.MATERIALS.Where(r => r.MTYPE == "F"), "MSLNO", "MATERIALNAME", coefficientmasterdetailviewmodel.Bonderannualentitlementcoms.MSLNO); ViewBag.Rawmaterilas = new SelectList(db.MATERIALS.Where(r => r.MTYPE == "r"), "MSLNO", "MATERIALNAME"); //ViewBag.Unit = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME", bonderannualentitlementcoedet.MUSLNO); ViewBag.MachineList = new SelectList(db.MACHINEINFORMATIONs, "MACHINESLNO", "MODELNM", coefficientmasterdetailviewmodel.Bonderannualentitlementcoms.MACHINESLNO); return(View(coefficientmasterdetailviewmodel)); }