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