public ActionResult CalculateStorageInfo(AnnualCoefficientEntitlementViewModelList bonderannualentitlementedt, int?UnitTS, int?UnitOT, int?UnitET)
{
try
{
List <ANNUALENTLRAWMATERIAL> annualentlrawmaterial = db.ANNUALENTLRAWMATERIALs.Where(x => x.AESLNO == bonderannualentitlementedt.BonderAnnualEntitlement.AESLNO && x.BONDERSLNO == bonderannualentitlementedt.BonderAnnualEntitlement.BONDERSLNO).ToList();
decimal totalentitlement = 0;
decimal entitlementepercentage = 0;
decimal percentage = 100;
if (bonderannualentitlementedt.BonderAnnualEntitlement.PERCENTVAL != null)
{
percentage = (Int64)bonderannualentitlementedt.BonderAnnualEntitlement.PERCENTVAL;
}
foreach (var ae in annualentlrawmaterial)
{
totalentitlement = totalentitlement + (Int64)ae.AEQTY;
}
entitlementepercentage = percentage / 100 * totalentitlement;
BONDERANNUALENTITLEMENT bonderannualentitlement = new BONDERANNUALENTITLEMENT();
bonderannualentitlement.AESLNO = bonderannualentitlementedt.BonderAnnualEntitlement.AESLNO;
bonderannualentitlement.BONDERSLNO = bonderannualentitlementedt.BonderAnnualEntitlement.BONDERSLNO;
bonderannualentitlement.TOTALSTORAGEQTY = totalentitlement;
bonderannualentitlement.TSMUSLNO = (Int16)UnitTS;
bonderannualentitlement.TOTALSTORAGEQTYEN = bonderannualentitlementedt.BonderAnnualEntitlement.TOTALSTORAGEQTYEN;
bonderannualentitlement.ONETIMESTORAGEQTY = bonderannualentitlementedt.BonderAnnualEntitlement.ONETIMESTORAGEQTY;
bonderannualentitlement.OTMUSLNO = (Int16)UnitOT;
bonderannualentitlement.ONETIMESTORAGEQTYEN = bonderannualentitlementedt.BonderAnnualEntitlement.ONETIMESTORAGEQTYEN;
bonderannualentitlement.ENTITLEPERCENTQTY = (Int32)entitlementepercentage;
bonderannualentitlement.ETMUSLNO = (Int16)UnitET;
bonderannualentitlement.ENTITLEPERCENTEN = bonderannualentitlementedt.BonderAnnualEntitlement.ENTITLEPERCENTEN;
bonderannualentitlement.PERCENTVAL = bonderannualentitlementedt.BonderAnnualEntitlement.PERCENTVAL;
bonderannualentitlement.ENTITLEFROM = bonderannualentitlementedt.BonderAnnualEntitlement.ENTITLEFROM;
bonderannualentitlement.ENTITLETO = bonderannualentitlementedt.BonderAnnualEntitlement.ENTITLETO;
db.Entry(bonderannualentitlement).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("EntitlementDetails", new { id = bonderannualentitlementedt.BonderAnnualEntitlement.AESLNO }));
}
catch (Exception e)
{
return(RedirectToAction("EntitlementDetails", new { id = bonderannualentitlementedt.BonderAnnualEntitlement.AESLNO }));
}
}
public ActionResult EditStorageInfo(int?aeslno, int?bonderslno)
{
BONDERANNUALENTITLEMENT bonderannualentitlement = db.BONDERANNUALENTITLEMENTs.Find(aeslno, bonderslno);
ViewBag.UnitTS = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME", bonderannualentitlement.TSMUSLNO);
ViewBag.UnitOT = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME", bonderannualentitlement.OTMUSLNO);
ViewBag.UnitET = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME", bonderannualentitlement.ETMUSLNO);
return(View(bonderannualentitlement));
}
public ActionResult EditStorageInfo(BONDERANNUALENTITLEMENT bonderannualentitlementedited, int?aeslno, int?blsno, int?UnitTS, int?UnitOT, int?UnitET)
{
BONDERANNUALENTITLEMENT bonderannualentitlement = new BONDERANNUALENTITLEMENT();
if (ModelState.IsValid)
{
try
{
bonderannualentitlement.AESLNO = bonderannualentitlementedited.AESLNO;
bonderannualentitlement.BONDERSLNO = bonderannualentitlementedited.BONDERSLNO;
bonderannualentitlement.TOTALSTORAGEQTY = bonderannualentitlementedited.TOTALSTORAGEQTY;
bonderannualentitlement.TSMUSLNO = (Int16)UnitTS;
bonderannualentitlement.TOTALSTORAGEQTYEN = bonderannualentitlementedited.TOTALSTORAGEQTYEN;
bonderannualentitlement.ONETIMESTORAGEQTY = bonderannualentitlementedited.ONETIMESTORAGEQTY;
bonderannualentitlement.TSMUSLNO = (Int16)UnitOT;
bonderannualentitlement.ONETIMESTORAGEQTY = bonderannualentitlementedited.ONETIMESTORAGEQTY;
bonderannualentitlement.ENTITLEPERCENTQTY = bonderannualentitlementedited.ENTITLEPERCENTQTY;
bonderannualentitlement.TSMUSLNO = (Int16)UnitET;
bonderannualentitlement.ENTITLEPERCENTEN = bonderannualentitlementedited.ENTITLEPERCENTEN;
bonderannualentitlement.PERCENTVAL = bonderannualentitlementedited.PERCENTVAL;
bonderannualentitlement.ENTITLEFROM = bonderannualentitlementedited.ENTITLEFROM;
bonderannualentitlement.ENTITLETO = bonderannualentitlementedited.ENTITLETO;
db.Entry(bonderannualentitlement).State = EntityState.Modified;
db.SaveChanges();
//return RedirectToAction("EntitlementDetails", new { id = bonderannualentitlement.AESLNO });
return(RedirectToAction("EntitlementDetails", new { id = bonderannualentitlement.AESLNO, bonderSlNo = bonderannualentitlement.BONDERSLNO }));
}
catch (Exception e)
{
}
}
//ViewBag.MachineList = new SelectList(db.MACHINEINFORMATIONs, "MACHINESLNO", "MODELNM", bonderannualentitlementedited.MACHINESLNO);
return(View());
}
public int AddBonderAnnualEntitlement(string entitlementtype, int?BonderSlno, decimal?totalentitlement, int?totalentitlementunit, string totalentitlementinword,
decimal?onetimestoragequantity, int?onetimestoragequantitytunit, string onetimestoragequantityinwords,
decimal?entitlementpercentaccordingtoproduction, int?entitlementpercentaccordingtoproductionunit,
string entitlementpercentaccordingtoproductioninword,
string entitlementdatefrom, string entitlementdateto)
{
BONDERANNUALENTITLEMENT BonderAnnualEntitlement = new BONDERANNUALENTITLEMENT();
//BonderAnnualEntitlement.AESLNO = 200;
BonderAnnualEntitlement.BONDERSLNO = (Int16)BonderSlno;
BonderAnnualEntitlement.ENTLTYPE = entitlementtype;
BonderAnnualEntitlement.TOTALSTORAGEQTY = totalentitlement;
BonderAnnualEntitlement.TSMUSLNO = (Int16)totalentitlementunit;
BonderAnnualEntitlement.TOTALSTORAGEQTYEN = totalentitlementinword;
BonderAnnualEntitlement.TOTALSTORAGEQTYBG = "BG";
BonderAnnualEntitlement.ONETIMESTORAGEQTY = onetimestoragequantity;
BonderAnnualEntitlement.OTMUSLNO = (Int16)onetimestoragequantitytunit;
BonderAnnualEntitlement.ONETIMESTORAGEQTYEN = onetimestoragequantityinwords;
BonderAnnualEntitlement.ONETIMESTORAGEQTYBG = "BG";
BonderAnnualEntitlement.ENTITLEPERCENTQTY = entitlementpercentaccordingtoproduction;
BonderAnnualEntitlement.ETMUSLNO = (Int16)entitlementpercentaccordingtoproductionunit;
BonderAnnualEntitlement.ENTITLEPERCENTEN = entitlementpercentaccordingtoproductioninword;
//BonderAnnualEntitlement.ENTITLEFROM = DateTime.Now ;
//BonderAnnualEntitlement.ENTITLETO = DateTime.Now ;
BonderAnnualEntitlement.ENTITLEFROM = DateTime.Parse(entitlementdatefrom);
BonderAnnualEntitlement.ENTITLETO = DateTime.Parse(entitlementdateto);
db.BONDERANNUALENTITLEMENTs.Add(BonderAnnualEntitlement);
db.SaveChanges();
return(db.BONDERANNUALENTITLEMENTs.Max(b => b.AESLNO));
}
