public ActionResult AddEntitlementRawMaterial(int?aeslno, int?bonderslno, int?rawmaterilas,
string hscode, string description, string specificationorgrade, int?quantity,
int?unitslno)
{
try
{
ANNUALENTLRAWMATERIAL annualentlrawmaterial = new ANNUALENTLRAWMATERIAL();
// annualentlrawmaterial.AESLNO = (Int16)aeslno;
annualentlrawmaterial.BONDERSLNO = (Int16)bonderslno;
annualentlrawmaterial.MSLNO = (Int16)rawmaterilas;
annualentlrawmaterial.MUSLNO = (Int16)unitslno;
annualentlrawmaterial.AEQTY = quantity;
db.ANNUALENTLRAWMATERIALs.Add(annualentlrawmaterial);
db.SaveChanges();
return(RedirectToAction("EntitlementDetails", new { ID = aeslno }));
}
catch (Exception e)
{
ViewBag.Rawmaterilas = new SelectList(db.MATERIALS.Where(r => r.MTYPE == "r"), "MSLNO", "MHSCODE");
ViewBag.Error = "Same Product Exist !!";
return(View());
}
}
public void AddAnnualEntitlementRawMaterilas(int?BonderSlno, int[] hscodes, decimal[] quantitys, int[] units, int id)
{
if (hscodes != null)
{
for (int i = 0; i < hscodes.Length; i++)
{
ANNUALENTLRAWMATERIAL AnnuaRawMaterialEntitlement = new ANNUALENTLRAWMATERIAL();
//-----------Mizan Work (20 july 2016)----------------
var mslno = hscodes[i];
units[i] = (Int16)(from a in db.MATERIALS where a.MSLNO == mslno select a.MUSLNO).SingleOrDefault();
//-----------Mizan Work (20 july 2016)----------------
AnnuaRawMaterialEntitlement.AESLNO = (Int16)id;
AnnuaRawMaterialEntitlement.BONDERSLNO = (Int16)BonderSlno;
AnnuaRawMaterialEntitlement.MSLNO = (Int16)hscodes[i];
AnnuaRawMaterialEntitlement.AEQTY = (Decimal)quantitys[i];
AnnuaRawMaterialEntitlement.MUSLNO = (Int16)units[i];
db.ANNUALENTLRAWMATERIALs.Add(AnnuaRawMaterialEntitlement);
db.SaveChanges();
}
}
}
public ActionResult EditEntitlement(ANNUALENTLRAWMATERIAL annualentlrawmaterialedited, int?rawmaterilas, int?unit)
{
ANNUALENTLRAWMATERIAL annualentlrawmaterial = new ANNUALENTLRAWMATERIAL();
if (ModelState.IsValid)
{
try
{
annualentlrawmaterial.AESLNO = annualentlrawmaterialedited.AESLNO;
annualentlrawmaterial.BONDERSLNO = annualentlrawmaterialedited.BONDERSLNO;
annualentlrawmaterial.MSLNO = annualentlrawmaterialedited.MSLNO;
//annualentlrawmaterial.MATERIAL.MDESCRIPTION = annualentlrawmaterialedited.MATERIAL.MDESCRIPTION;
//annualentlrawmaterial.MATERIAL.SPGRADE = annualentlrawmaterialedited.MATERIAL.SPGRADE;
annualentlrawmaterial.AEQTY = annualentlrawmaterialedited.AEQTY;
annualentlrawmaterial.MUSLNO = (Int16)unit;
db.Entry(annualentlrawmaterial).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("EntitlementDetails", new { id = annualentlrawmaterialedited.AESLNO }));
}
catch (Exception e)
{
}
}
ViewBag.Rawmaterilas = new SelectList(db.MATERIALS.Where(r => r.MTYPE == "r"), "MSLNO", "MHSCODE", annualentlrawmaterial.MSLNO);
ViewBag.Unit = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME", annualentlrawmaterial.MUSLNO);
return(View(annualentlrawmaterial));
}
public ActionResult DeleteConfirmed(short id)
{
ANNUALENTLRAWMATERIAL annualentlrawmaterial = db.ANNUALENTLRAWMATERIALs.Find(id);
db.ANNUALENTLRAWMATERIALs.Remove(annualentlrawmaterial);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteAnnualEntlRawmaterial(int?id, int?id2, int?id3)
{
ANNUALENTLRAWMATERIAL annualentlrawmaterial = db.ANNUALENTLRAWMATERIALs.Find(id, id2, id3);
db.ANNUALENTLRAWMATERIALs.Remove(annualentlrawmaterial);
db.SaveChanges();
return(RedirectToAction("EntitlementDetails", new { ID = id }));
}
//
// GET: /AnnualEntitlement/Delete/5
public ActionResult Delete(short id = 0)
{
ANNUALENTLRAWMATERIAL annualentlrawmaterial = db.ANNUALENTLRAWMATERIALs.Find(id);
if (annualentlrawmaterial == null)
{
return(HttpNotFound());
}
return(View(annualentlrawmaterial));
}
public ActionResult Edit(ANNUALENTLRAWMATERIAL annualentlrawmaterial)
{
if (ModelState.IsValid)
{
db.Entry(annualentlrawmaterial).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MSLNO = new SelectList(db.MATERIALS, "MSLNO", "MHSCODE", annualentlrawmaterial.MSLNO);
ViewBag.MUSLNO = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME", annualentlrawmaterial.MUSLNO);
return(View(annualentlrawmaterial));
}
//
// GET: /AnnualEntitlement/Edit/5
public ActionResult Edit(short id = 0)
{
ANNUALENTLRAWMATERIAL annualentlrawmaterial = db.ANNUALENTLRAWMATERIALs.Find(id);
if (annualentlrawmaterial == null)
{
return(HttpNotFound());
}
ViewBag.MSLNO = new SelectList(db.MATERIALS, "MSLNO", "MHSCODE", annualentlrawmaterial.MSLNO);
ViewBag.MUSLNO = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME", annualentlrawmaterial.MUSLNO);
return(View(annualentlrawmaterial));
}
//--------------------------------------Mizan Work (25 Oct 16)------------------------------------------------------------------------
//public ActionResult EntitlementDetails(int? id)
//{
// AnnualCoefficientEntitlementViewModelList annualcoefficiententitlementviewmodellst = new AnnualCoefficientEntitlementViewModelList();
// annualcoefficiententitlementviewmodellst.BonderAnnualEntitlement = db.BONDERANNUALENTITLEMENTs.Where(x => x.AESLNO == id).SingleOrDefault();
// annualcoefficiententitlementviewmodellst.AnnualEntitlementRawMaterials = db.ANNUALENTLRAWMATERIALs.Where(x => x.AESLNO == id).ToList();
// annualcoefficiententitlementviewmodellst.BonderannualEntitlementCoEDets = db.BONDERANNUALENTITLEMENTCOEDETs.Where(x => x.AESLNO == id).ToList();
// var List = (from r in db.BONDERANNUALENTITLEMENTCOEDETs
// where r.AESLNO == id
// select new
// {
// rawslno = r.RMSLNO,
// mslno = r.MSLNO
// }).ToList();
// List<BONDERANNUALENTITLEMENTCOEDET> rawdetlist = new List<BONDERANNUALENTITLEMENTCOEDET>();
// foreach (var item in List)
// {
// rawdetlist.Add(
// new BONDERANNUALENTITLEMENTCOEDET
// {
// MSLNO = item.mslno,
// INPUTBY = (from t2 in db.MATERIALS where t2.MSLNO == item.rawslno select t2.MDESCRIPTION).FirstOrDefault().ToString(),
// }
// );
// }
// annualcoefficiententitlementviewmodellst.BonderannualEntitlementCoEDets = rawdetlist;
// ViewBag.Rawmaterilas = new SelectList(db.MATERIALS.Where(r => r.MTYPE == "r"), "MSLNO", "MHSCODE");
// ViewBag.Products = new SelectList(db.MATERIALS.Where(p => p.MTYPE == "F"), "MSLNO", "MHSCODE");
// ViewBag.Unit = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME");
// ViewBag.UnitTS = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME", annualcoefficiententitlementviewmodellst.BonderAnnualEntitlement.TSMUSLNO);
// ViewBag.UnitOT = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME", annualcoefficiententitlementviewmodellst.BonderAnnualEntitlement.OTMUSLNO);
// ViewBag.UnitET = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME", annualcoefficiententitlementviewmodellst.BonderAnnualEntitlement.ETMUSLNO);
// ViewBag.MachineList = new SelectList(db.MACHINEINFORMATIONs, "MACHINESLNO", "MODELNM");
// return View(annualcoefficiententitlementviewmodellst);
//}
public ActionResult EditEntitlement(int?id, int?id2, int?id3)
{
ANNUALENTLRAWMATERIAL annualentlrawmaterial = db.ANNUALENTLRAWMATERIALs.Where(x => x.AESLNO == id && x.BONDERSLNO == id2 && x.MSLNO == id3).SingleOrDefault();
if (annualentlrawmaterial == 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", annualentlrawmaterial.MUSLNO);
return(View(annualentlrawmaterial));
}
