public ActionResult Create(BONDTYPE bondtype)
{
if (ModelState.IsValid)
{
db.BONDTYPEs.Add(bondtype);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bondtype));
}
public ActionResult Create(FINISHEDPRODUCT finishedproduct)
{
if (ModelState.IsValid)
{
db.FINISHEDPRODUCTS.Add(finishedproduct);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(finishedproduct));
}
public ActionResult Create(BONDDIVISION bonddivision)
{
if (ModelState.IsValid)
{
db.BONDDIVISIONs.Add(bonddivision);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bonddivision));
}
public ActionResult Create(BONDCATEGORY bondcategory)
{
if (ModelState.IsValid)
{
db.BONDCATEGORies.Add(bondcategory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bondcategory));
}
public ActionResult Create(MATERIALSGROUP materialsgroup)
{
if (ModelState.IsValid)
{
db.MATERIALSGROUPs.Add(materialsgroup);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(materialsgroup));
}
public ActionResult Edit(UP up)
{
if (ModelState.IsValid)
{
db.Entry(up).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERSLNO", up.BONDERID);
return(View(up));
}
public ActionResult Create(DESIGNATION designation)
{
if (ModelState.IsValid)
{
db.DESIGNATIONs.Add(designation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(designation));
}
public ActionResult Create(BANK bank)
{
if (ModelState.IsValid)
{
db.BANKs.Add(bank);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bank));
}
public ActionResult Create(COUNTRY country)
{
if (ModelState.IsValid)
{
db.COUNTRies.Add(country);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(country));
}
public ActionResult Create(CURRENCY currency)
{
if (ModelState.IsValid)
{
db.CURRENCies.Add(currency);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(currency));
}
public ActionResult Create(BONDAREA bondarea)
{
if (ModelState.IsValid)
{
db.BONDAREAs.Add(bondarea);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BONDDIVISIONSLNO = new SelectList(db.BONDDIVISIONs, "BONDDIVISIONSLNO", "BONDDIVISIONNAME", bondarea.BONDDIVISIONSLNO);
return(View(bondarea));
}
public ActionResult Create(MEASUREMENTUNIT measurementunit)
{
if (ModelState.IsValid)
{
db.MEASUREMENTUNITs.Add(measurementunit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(measurementunit));
}
public ActionResult Create(BONDERPRODUCT bonderproduct)
{
if (ModelState.IsValid)
{
db.BONDERPRODUCTs.Add(bonderproduct);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.FPSLNO = new SelectList(db.MATERIALS, "MSLNO", "MHSCODE", bonderproduct.FPSLNO);
return(View(bonderproduct));
}
public ActionResult Create(RAWMATERIAL rawmaterial)
{
if (ModelState.IsValid)
{
db.RAWMATERIALs.Add(rawmaterial);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PRODUCTID = new SelectList(db.BACKTOBACKPRODUCTs, "ID", "NAME", rawmaterial.PRODUCTID);
return(View(rawmaterial));
}
public ActionResult Create(BACKTOBACKPRODUCT backtobackproduct)
{
if (ModelState.IsValid)
{
db.BACKTOBACKPRODUCTs.Add(backtobackproduct);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BACKTOBACKLCID = new SelectList(db.BACKTOBACKLCs, "ID", "BUYERSNAME", backtobackproduct.BACKTOBACKLCID);
return(View(backtobackproduct));
}
public ActionResult Create(BANKBRANCH bankbranch)
{
if (ModelState.IsValid)
{
db.BANKBRANCHes.Add(bankbranch);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BANKSLNO = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", bankbranch.BANKSLNO);
return(View(bankbranch));
}
public ActionResult Create(DISTRICT district)
{
if (ModelState.IsValid)
{
db.DISTRICTs.Add(district);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.COUNTRYSLNO = new SelectList(db.COUNTRies, "COUNTRYSLNO", "COUNTRYCODE", district.COUNTRYSLNO);
return(View(district));
}
public ActionResult Create(UPAZILA upazila)
{
if (ModelState.IsValid)
{
db.UPAZILAs.Add(upazila);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DISTRICTSLNO = new SelectList(db.DISTRICTs, "DISTRICTSLNO", "DISTRICTNAME", upazila.DISTRICTSLNO);
return(View(upazila));
}
public ActionResult Create(INBONDRAWMATERIAL inbondrawmaterial)
{
if (ModelState.IsValid)
{
db.INBONDRAWMATERIALs.Add(inbondrawmaterial);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.INBONDID = new SelectList(db.INBONDs, "ID", "ID", inbondrawmaterial.INBONDID);
return(View(inbondrawmaterial));
}
public ActionResult Create(BONDSTATU bondstatu)
{
if (ModelState.IsValid)
{
db.BONDSTATUS.Add(bondstatu);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BONDERSLNO = new SelectList(db.BONDERs, "BONDERSLNO", "BONDLICENSENO", bondstatu.BONDERSLNO);
return(View(bondstatu));
}
public ActionResult Create(ATTACHMENT attachment)
{
if (ModelState.IsValid)
{
db.ATTACHMENTs.Add(attachment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UPREQUESTID = new SelectList(db.UPREQUESTs, "ID", "CREATEDBY", attachment.UPREQUESTID);
return(View(attachment));
}
public ActionResult Create(MATERIAL material)
{
if (ModelState.IsValid)
{
db.MATERIALS.Add(material);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MGSLNO = new SelectList(db.MATERIALSGROUPs, "MGSLNO", "MGROUPCODE", material.MGSLNO);
ViewBag.MUSLNO = new SelectList(db.MEASUREMENTUNITs, "MUSLNO", "MUNAME", material.MUSLNO);
return(View(material));
}
public ActionResult Create(ANNUALENTLRAWMATERIAL annualentlrawmaterial)
{
if (ModelState.IsValid)
{
db.ANNUALENTLRAWMATERIALs.Add(annualentlrawmaterial);
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));
}
public ActionResult Create(BONDAPPLICATIONPROGRESS bondapplicationprogress)
{
if (ModelState.IsValid)
{
db.BONDAPPLICATIONPROGRESSes.Add(bondapplicationprogress);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BONDERSLNO = new SelectList(db.BONDERs, "BONDERSLNO", "BONDLICENSENO", bondapplicationprogress.BONDERSLNO);
ViewBag.BSNO = new SelectList(db.BONDSTATUS, "BSNO", "REFNO", bondapplicationprogress.BSNO);
return(View(bondapplicationprogress));
}
public ActionResult Create(ASSOCIATIONENROLL associationenroll)
{
if (ModelState.IsValid)
{
db.ASSOCIATIONENROLLs.Add(associationenroll);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BONDERSLNO = new SelectList(db.BONDERs, "BONDERSLNO", "BONDLICENSENO", associationenroll.BONDERSLNO);
ViewBag.OFFICESLNO = new SelectList(db.OFFICEs, "OFFICESLNO", "OFFICENAME", associationenroll.OFFICESLNO);
return(View(associationenroll));
}
public ActionResult Create(BONDERLIENBANK bonderlienbank)
{
if (ModelState.IsValid)
{
db.BONDERLIENBANKs.Add(bonderlienbank);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BANKSLNO = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", bonderlienbank.BANKSLNO);
ViewBag.BBRANCHSLNO = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", bonderlienbank.BBRANCHSLNO);
ViewBag.BONDERSLNO = new SelectList(db.BONDERs, "BONDERSLNO", "BONDLICENSENO", bonderlienbank.BONDERSLNO);
return(View(bonderlienbank));
}
public ActionResult Create(OFFICE office)
{
if (ModelState.IsValid)
{
db.OFFICEs.Add(office);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.COUNTRYSLNO = new SelectList(db.COUNTRies, "COUNTRYSLNO", "COUNTRYCODE", office.COUNTRYSLNO);
ViewBag.DESSLNO = new SelectList(db.DESIGNATIONs, "DESSLNO", "DESCODE", office.DESSLNO);
ViewBag.DISTRICTSLNO = new SelectList(db.DISTRICTs, "DISTRICTSLNO", "DISTRICTNAME", office.DISTRICTSLNO);
return(View(office));
}
public ActionResult DeleteRequest(string rejectMessage, int id = 0)
{
UPREQUEST request = db.UPREQUESTs.Find(id);
UPREQUEST newRequest = new UPREQUEST();
newRequest.ID = request.ID;
newRequest.STATUS = 10;
newRequest.BONDERID = request.BONDERID;
newRequest.CREATEDBY = request.CREATEDBY;
newRequest.CREATEDDATE = request.CREATEDDATE;
newRequest.MODIFIEDBY = request.MODIFIEDBY;
newRequest.MODIFIEDDATE = request.MODIFIEDDATE;
newRequest.REJECTCOMMENT = rejectMessage;
if (newRequest != null)
{
using (var db2 = new OracleEntitiesConnStr())
{
db2.Entry(newRequest).State = EntityState.Modified;
db2.SaveChanges();
}
}
return(Redirect(ControllerContext.HttpContext.Request.UrlReferrer.ToString()));
}
public ActionResult Create(APPUSER appuser)
{
if (ModelState.IsValid)
{
appuser.PASSWARD = encryptionDecryptionUtil.CreatePasswordHash(appuser.PASSWARD, appuser.SALT);
appuser.ISACTIVE = 1;
APPUSER duplicateUser = db.APPUSERs.SingleOrDefault(u => u.USERNAME.Equals(appuser.USERNAME, StringComparison.OrdinalIgnoreCase));
if (duplicateUser != null)
{
ModelState.AddModelError("", "User Already Exists");
appuser.PASSWARD = "";
return(View(appuser));
}
db.APPUSERs.Add(appuser);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(appuser));
}
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();
}
}
