public ActionResult addMoreB2BLC(short id, int?page) { USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission(); List <BACKTOBACKLC> b2bList = new List <BACKTOBACKLC>(); EXBOND exbond = db.EXBONDs.Find(id); int id1 = exbond.BONDER.BONDERSLNO; bool flag = false; var b2b = db.BACKTOBACKLCs.Where(eb => eb.BONDERID == id1 && (eb.BACKTOBACKPRODUCTs.Count() > 0)).ToList(); for (int i = 0; i < b2b.Count(); i++) { BACKTOBACKLC b2blc = db.BACKTOBACKLCs.Find(b2b[i].ID); if (b2blc != null && b2blc.EXBONDBACKTOBACKs.Count() < 1) { flag = true; b2bList.Add(b2blc); } } if (!flag) { return(RedirectToAction("Edit/" + id, new { error = "Sorry! There is no more Back to Back LC exist for this bonder" })); } ViewBag.ExbondID = id; ViewBag.resultofbonderID = exbond.BONDERID; ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", exbond.BONDER.BONDERNAME); int pageSize = recordNumbers; int pageNumber = (page ?? 1); return(View("Lcselector", b2bList.ToPagedList(pageNumber, pageSize))); // return View("Lcselector", b2bList); }
public ActionResult Addmore(string errorMessage, short id = 0) { BACKTOBACKLC backtobacklc = db.BACKTOBACKLCs.Find(id); if (backtobacklc == null) { return(HttpNotFound()); } ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backtobacklc.BUYERSBANKBRANCHID); ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backtobacklc.BUYERSBANKID); USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission(); if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == loggedinUser.BONDERID), "BONDERSLNO", "BONDERNAME", loggedinUser.BONDERID); } else { ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", backtobacklc.BONDERID); } //ViewBag.QUANTITYUNIT = new SelectList("Piece", "KG"); ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.QUANTITYUNIT); ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backtobacklc.PRICEUNIT); for (int i = 0; i < backtobacklc.BACKTOBACKPRODUCTs.Count(); i++) { ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.BACKTOBACKPRODUCTs[i].QUANTITYUNIT); } if (errorMessage != null && !errorMessage.Trim().Equals("")) { ModelState.AddModelError("editerror", errorMessage); return(View(backtobacklc)); } return(View(backtobacklc)); }
protected void Application_PostAuthenticateRequest(Object sender, EventArgs e) { if (FormsAuthentication.CookiesSupported == true) { if (Request.Cookies[FormsAuthentication.FormsCookieName] != null) { try { //let us take out the username now string username = FormsAuthentication.Decrypt(Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name; String userRole = ""; using (OracleEntitiesConnStr db = new OracleEntitiesConnStr()) { APPUSER appuser = db.APPUSERs.SingleOrDefault(u => u.USERNAME.Equals(username, StringComparison.OrdinalIgnoreCase)); USERPERMISSION userpermission = db.USERPERMISSIONs.SingleOrDefault(u => u.USERID == appuser.ID); string role = userpermission.ROLENAME; userRole = role; System.Web.HttpContext.Current.User = new System.Security.Principal.GenericPrincipal( new System.Security.Principal.GenericIdentity(username, "Forms"), new[] { userRole }); } } catch (Exception) { } } } }
public ActionResult DeleteConfirmed(short id) { USERPERMISSION userpermission = db.USERPERMISSIONs.Find(id); db.USERPERMISSIONs.Remove(userpermission); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Details(short id = 0) { USERPERMISSION userpermission = db.USERPERMISSIONs.Find(id); if (userpermission == null) { return(HttpNotFound()); } return(View(userpermission)); }
public ActionResult BondEntitlementList() { if (!(System.Web.HttpContext.Current.User.IsInRole("Bonder"))) // added By Mizan (18 Aug 2016)-- { var EntitlementList = from e in db.BONDERANNUALENTITLEMENTs group e by e.BONDERSLNO into g select new { bonderslno = g.Key, aeslno = (from t2 in g select t2.AESLNO).Max() }; List <BONDERANNUALENTITLEMENT> entlmntlst = new List <BONDERANNUALENTITLEMENT>(); foreach (var item in EntitlementList) { entlmntlst.Add( new BONDERANNUALENTITLEMENT { AESLNO = item.aeslno, BONDERSLNO = item.bonderslno, INPUTBY = (from t2 in db.BONDERs where t2.BONDERSLNO == item.bonderslno select t2.BONDERNAME).FirstOrDefault(), MODIFIEDBY = (from t2 in db.BONDERs where t2.BONDERSLNO == item.bonderslno select t2.BONDLICENSENO).FirstOrDefault() }); } return(View(entlmntlst)); } else // added By Mizan (18 Aug 2016)-- { USERPERMISSION permission = session.getStoredUserPermission(); var bonderName = permission.BONDER.BONDERNAME; var EntitlementList = from e in db.BONDERANNUALENTITLEMENTs.Where(e => e.BONDER.BONDERNAME == bonderName) group e by e.BONDERSLNO into g select new { bonderslno = g.Key, aeslno = (from t2 in g select t2.AESLNO).Max() }; List <BONDERANNUALENTITLEMENT> entlmntlst = new List <BONDERANNUALENTITLEMENT>(); foreach (var item in EntitlementList) { entlmntlst.Add( new BONDERANNUALENTITLEMENT { AESLNO = item.aeslno, BONDERSLNO = item.bonderslno, INPUTBY = (from t2 in db.BONDERs where t2.BONDERSLNO == item.bonderslno select t2.BONDERNAME).FirstOrDefault(), MODIFIEDBY = (from t2 in db.BONDERs where t2.BONDERSLNO == item.bonderslno select t2.BONDLICENSENO).FirstOrDefault() }); } return(View(entlmntlst)); } }
public ActionResult AddRawMaterial(BACKTOBACKPRODUCT backtobackProduct) { USERPERMISSION userpermission = sessionAttributeRetreival.getStoredUserPermission(); foreach (var item in backtobackProduct.RAWMATERIALs) { item.PRODUCTID = backtobackProduct.ID; } DateTime thisDay = DateTime.Now; var user = "******"; System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " ModelState.IsValid: " + ModelState.IsValid); // if (ModelState.IsValid) if (true) { try { foreach (var rawMaterial in backtobackProduct.RAWMATERIALs) { var productId = rawMaterial.PRODUCTID; System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " productId: " + productId); System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " backtobackProduct.BACKTOBACKLCID: " + backtobackProduct.BACKTOBACKLCID); using (var dbRawMaterial = new OracleEntitiesConnStr()) { RAWMATERIAL newRawMaterial = new RAWMATERIAL(); newRawMaterial.RAWMATERIALCODE = rawMaterial.RAWMATERIALCODE; newRawMaterial.QUANTITY = rawMaterial.QUANTITY; newRawMaterial.UNIT = rawMaterial.UNIT; newRawMaterial.PERMITTEDWASTE = rawMaterial.PERMITTEDWASTE; newRawMaterial.PRODUCTID = productId; if (userpermission != null) { newRawMaterial.CREATEDBY = userpermission.APPUSER.USERNAME; } newRawMaterial.CREATEDDATE = thisDay; dbRawMaterial.RAWMATERIALs.Add(newRawMaterial); dbRawMaterial.SaveChanges(); } } return(RedirectToAction("Details/" + backtobackProduct.BACKTOBACKLCID)); } catch (Exception e) { System.Diagnostics.Debug.WriteLine("Create(BACKTOBACKPRODUCTs): Time-" + thisDay + " Exception = " + e.StackTrace); } } return(View()); }
public ActionResult Edit(short id = 0) { USERPERMISSION userpermission = db.USERPERMISSIONs.Find(id); if (userpermission == null) { return(HttpNotFound()); } ViewBag.USERID = new SelectList(db.APPUSERs, "ID", "USERNAME", userpermission.USERID); ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", userpermission.BONDERID); ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME", userpermission.EMPLOYID); return(View(userpermission)); }
public ActionResult Edit(USERPERMISSION userpermission) { if (ModelState.IsValid) { db.Entry(userpermission).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.USERID = new SelectList(db.APPUSERs, "ID", "USERNAME", userpermission.USERID); ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", userpermission.BONDERID); ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME", userpermission.EMPLOYID); return(View(userpermission)); }
public USERPERMISSION getStoredUserPermission() { string username = FormsAuthentication.Decrypt(HttpContext.Current.Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name; APPUSER appuser = db.APPUSERs.SingleOrDefault(u => u.USERNAME.Equals(username, StringComparison.OrdinalIgnoreCase)); try { USERPERMISSION userpermission = db.USERPERMISSIONs.SingleOrDefault(u => u.USERID == appuser.ID); return(userpermission); } catch (NullReferenceException exp) { return(null); } }
//------------Mizan Work ---------------------- public ActionResult EntitlementReport() { if (!(System.Web.HttpContext.Current.User.IsInRole("Bonder"))) // added By Mizan (18 Aug 2016)-- { ViewBag.AESLNO = new SelectList(db.BONDERANNUALENTITLEMENTs, "AESLNO", "AESLNO"); } else // added By Mizan (18 Aug 2016)-- { USERPERMISSION permission = session.getStoredUserPermission(); var bonderName = permission.BONDER.BONDERNAME; ViewBag.AESLNO = new SelectList(db.BONDERANNUALENTITLEMENTs.Where(x => x.BONDER.BONDERNAME == bonderName), "AESLNO", "AESLNO"); } return(View("EntitlementDetailsCrReport")); }
public ActionResult Create() { ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME"); ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME"); USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission(); if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == loggedinUser.BONDERID), "BONDERSLNO", "BONDERNAME", loggedinUser.BONDERID); } else { ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); } ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text"); ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text"); return(View()); }
public ActionResult Login(LoginModel loginModel, string returnUrl) { if (loginModel.USERNAME == null || loginModel.PASSWARD == null || loginModel.USERNAME.Trim().Equals("") || loginModel.PASSWARD.Trim().Equals("")) { ModelState.AddModelError("", "Wrong Username or Password"); } List <APPUSER> appusers = db.APPUSERs.ToList(); foreach (var appuser in appusers) { if (appuser.USERNAME.Equals(loginModel.USERNAME) && encryptionDecryptionUtil.VerifyPassword(appuser.PASSWARD, loginModel.PASSWARD, appuser.SALT)) { FormsAuthentication.SetAuthCookie(loginModel.USERNAME, false); if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") && !returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\")) { return(Redirect(returnUrl)); } else { USERPERMISSION userpermission = db.USERPERMISSIONs.SingleOrDefault(u => u.USERID == appuser.ID); if (userpermission == null) { FormsAuthentication.SignOut(); return(RedirectToAction("AccessDenied", "Error", null)); } appuser.LASTLOGIN = DateTime.Now; db.Entry(appuser).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "Home")); } } } if (ModelState.IsValid) { ModelState.AddModelError("", "Wrong Username or Password"); } return(View(loginModel)); }
public ActionResult Create(APPUSER appuser) { USERPERMISSION userpermission = db.USERPERMISSIONs.SingleOrDefault(u => u.USERID == appuser.ID); if (userpermission == null) { List <APPUSER> appusers = new List <APPUSER>(); List <SelectListItem> listItem = new List <SelectListItem>(); listItem.Add(new SelectListItem { Text = "Bonder", Value = "Bonder", }); listItem.Add(new SelectListItem { Text = "Operation Admin", Value = "Operation Admin", }); appusers.Add(appuser); ViewBag.USERID = new SelectList(appusers, "ID", "USERNAME"); ViewBag.ROLENAME = listItem; ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME"); } else { List <APPUSER> appusers = new List <APPUSER>(); appusers.Add(appuser); List <SelectListItem> listItem = new List <SelectListItem>(); if (userpermission.ROLENAME.Equals("Bonder")) { listItem.Add(new SelectListItem { Text = "Bonder", Value = "Bonder", Selected = true, }); listItem.Add(new SelectListItem { Text = "Operation Admin", Value = "Operation Admin" }); } else if (userpermission.ROLENAME.Equals("Operation Admin")) { listItem.Add(new SelectListItem { Text = "Bonder", Value = "Bonder", }); listItem.Add(new SelectListItem { Text = "Operation Admin", Value = "Operation Admin", Selected = true }); } ViewBag.USERID = new SelectList(appusers, "ID", "USERNAME"); if (userpermission.BONDER != null) { ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", userpermission.BONDER.BONDERNAME); } else { ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); } if (userpermission.EMPLOYEE != null) { ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME", userpermission.EMPLOYEE.EMPLOYEENAME); } else { ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME"); } ViewBag.ROLENAME = listItem; ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME"); } return(View()); }
public ActionResult CreateorEditExbond(IList <BACKTOBACKLC> backtobacklcs, short ID = 0) { USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission(); IList <BACKTOBACKLC> b2bList = new List <BACKTOBACKLC>(); EXBOND exbond = new EXBOND(); if (backtobacklcs == null) { return(RedirectToAction("Create", new { error = "Please select at least one back to back lc" })); } bool flag = true; bool isanyselected = false; for (int i = 0; i < backtobacklcs.Count(); i++) { int id = backtobacklcs[i].ID; if (backtobacklcs[i].IsSelected) { isanyselected = true; BACKTOBACKLC back2backlc = db.BACKTOBACKLCs.Find(id); int productCount = back2backlc.BACKTOBACKPRODUCTs.Count(); if (productCount < 1) { flag = false; } else { exbond.BONDERID = backtobacklcs[i].BONDER.BONDERSLNO; b2bList.Add(back2backlc); } } } if (!isanyselected && ID <= 0) { return(RedirectToAction("Create", new { error = "Please select at least one back to back lc" })); } if (!flag && ID <= 0) { return(RedirectToAction("Create", new { error = "Sorry! please check all selected LC has at least one product" })); } else { short lastInserted = 0; //if (ModelState.IsValid) //{ if (ID <= 0) //add new exbond { if (loggedinUser != null) { exbond.CREATEDBY = loggedinUser.APPUSER.USERNAME; } //else //{ // exbond.CREATEDBY = "" + loggedinUser.USERID; //} exbond.CREATEDDATE = DateTime.Today; db.EXBONDs.Add(exbond); try { db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e.ToString()); } lastInserted = db.EXBONDs.Max(item => item.ID); } else //edit new exbond { using (var db2 = new OracleEntitiesConnStr()) { exbond = db.EXBONDs.Find(ID); EXBOND newExbond = new EXBOND(); newExbond.ID = ID; newExbond.BONDERID = exbond.BONDERID; newExbond.DESCRIPTION = exbond.DESCRIPTION; if (loggedinUser != null) { newExbond.MODIFIEDBY = loggedinUser.APPUSER.USERNAME; } newExbond.MODIFIEDDATE = DateTime.Today; newExbond.CREATEDDATE = exbond.CREATEDDATE; newExbond.CREATEDBY = exbond.CREATEDBY; db2.Entry(newExbond).State = EntityState.Modified; db2.SaveChanges(); } lastInserted = ID; } for (int x = 0; x < b2bList.Count(); x++) { using (var db1 = new OracleEntitiesConnStr()) { EXBONDBACKTOBACK exbondb2b = new EXBONDBACKTOBACK(); exbondb2b.BACKTOBACKID = b2bList[x].ID; exbondb2b.EXBONDID = lastInserted; db1.EXBONDBACKTOBACKs.Add(exbondb2b); db1.SaveChanges(); } } // } if (ID <= 0) { return(RedirectToAction("Index")); } else { return(RedirectToAction("Edit/" + ID)); } } }
private IQueryable <BACKTOBACKLC> GetBackToBackRolesBySearchCriterial(String LCNo, String FromDate, String ToDate, USERPERMISSION loggedinUser, int BONDERID) { var backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER); if (!string.IsNullOrEmpty(LCNo)) { LCNo = LCNo.Trim(); } System.Diagnostics.Debug.WriteLine("LCNo = " + LCNo + ", FromDate = " + FromDate + ", ToDate = " + ToDate); if ((LCNo != null && !LCNo.Equals(String.Empty)) && (FromDate != null && !FromDate.Equals(String.Empty)) && (ToDate != null && !ToDate.Equals(String.Empty))) { System.Diagnostics.Debug.WriteLine("else if 1"); DateTime fromLCDate = Convert.ToDateTime(FromDate); DateTime toLCDate = Convert.ToDateTime(ToDate); backtobacklcs = backtobacklcs.Where(b => b.LCNUMBER.Contains(LCNo) && (b.LCDATE >= fromLCDate && b.LCDATE <= toLCDate)).Include(b => b.BANKBRANCH).OrderByDescending(b => b.ID); } else if ((FromDate != null && !FromDate.Equals(String.Empty)) && (ToDate != null && !ToDate.Equals(String.Empty))) { System.Diagnostics.Debug.WriteLine("else if 2"); DateTime fromLCDate = Convert.ToDateTime(FromDate); DateTime toLCDate = Convert.ToDateTime(ToDate); backtobacklcs = backtobacklcs.Where(b => (b.LCDATE >= fromLCDate && b.LCDATE <= toLCDate)).Include(b => b.BANKBRANCH).OrderByDescending(b => b.ID); } else if (LCNo != null && !LCNo.Equals(String.Empty)) { System.Diagnostics.Debug.WriteLine("else if 3"); backtobacklcs = backtobacklcs.Where(b => b.LCNUMBER.Contains(LCNo)).Include(b => b.BANKBRANCH).OrderByDescending(b => b.ID); } else if (FromDate != null && !FromDate.Equals(String.Empty)) { System.Diagnostics.Debug.WriteLine("else if 4"); DateTime fromLCDate = Convert.ToDateTime(FromDate); backtobacklcs = backtobacklcs.Where(b => b.LCDATE >= fromLCDate).OrderByDescending(b => b.ID); } else if (ToDate != null && !ToDate.Equals(String.Empty)) { System.Diagnostics.Debug.WriteLine("else if 5"); DateTime toLCDate = Convert.ToDateTime(ToDate); backtobacklcs = backtobacklcs.Where(b => b.LCDATE <= toLCDate).OrderByDescending(b => b.ID); } if (loggedinUser.BONDERID > 0) { backtobacklcs = backtobacklcs.Where(e => e.BONDERID == loggedinUser.BONDERID).OrderByDescending(b => b.ID); } else if (BONDERID > 0) { backtobacklcs = backtobacklcs.Where(e => e.BONDERID == BONDERID).OrderByDescending(b => b.ID); } return(backtobacklcs); ; }
public ActionResult Create(BACKTOBACKLC backToBackLC) { USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission(); if (loggedinUser != null) { backToBackLC.CREATEDBY = loggedinUser.APPUSER.USERNAME; } if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == loggedinUser.BONDERID), "BONDERSLNO", "BONDERNAME", loggedinUser.BONDERID); } else { ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); } foreach (var item in backToBackLC.BACKTOBACKPRODUCTs) { item.BACKTOBACKLCID = backToBackLC.ID; } DateTime thisDay = DateTime.Now; System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " ModelState.IsValid: " + ModelState.IsValid); var errors = ModelState.Values.SelectMany(v => v.Errors); System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " errors: " + errors); //if (ModelState.IsValid) if (true) { try { if (backToBackLC.BACKTOBACKPRODUCTs != null && backToBackLC.BACKTOBACKPRODUCTs.Count > 0) { if (backToBackLC.BONDERID != null) { USERPERMISSION userpermission = sessionAttributeRetreival.getStoredUserPermission(); int bonderId = backToBackLC.BONDERID; if (userpermission != null) { List <INBONDRAWMATERIAL> inbondRawMaterials = db.INBONDRAWMATERIALs.Where(inb => inb.INBOND.BONDERID == bonderId).ToList(); if (inbondRawMaterials != null) { decimal bonderUsedQuantity = inbondRawMaterials.Sum(item => item.PRODUCTQUANTITY); decimal?bonderProvidedQuantity = backToBackLC.BACKTOBACKPRODUCTs.Sum(item => item.QUANTITY); if (bonderUsedQuantity < bonderProvidedQuantity) { ModelState.AddModelError("", "Your Remaining Inbond Raw Material Quantity " + bonderUsedQuantity); ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backToBackLC.BUYERSBANKBRANCHID); ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backToBackLC.BUYERSBANKID); if (userpermission != null && userpermission.BONDERID != null) { ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == userpermission.BONDERID), "BONDERSLNO", "BONDERNAME", userpermission.BONDERID); } else { ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", backToBackLC.BONDERID); } ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backToBackLC.QUANTITYUNIT); ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backToBackLC.PRICEUNIT); for (int i = 0; i < backToBackLC.BACKTOBACKPRODUCTs.Count(); i++) { ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backToBackLC.BACKTOBACKPRODUCTs[i].QUANTITYUNIT); } return(View(backToBackLC)); } } } } BACKTOBACKLC newBacktobacklc = new BACKTOBACKLC(); newBacktobacklc.BUYERSNAME = backToBackLC.BUYERSNAME; newBacktobacklc.BUYERSADDRESS = backToBackLC.BUYERSADDRESS; newBacktobacklc.LCNUMBER = backToBackLC.LCNUMBER; newBacktobacklc.LCDATE = backToBackLC.LCDATE; newBacktobacklc.BUYERSBANKID = backToBackLC.BUYERSBANKID; newBacktobacklc.BUYERSBANKBRANCHID = backToBackLC.BUYERSBANKBRANCHID; newBacktobacklc.SHIPPINGDATE = backToBackLC.SHIPPINGDATE; newBacktobacklc.CORRECTIONDATE = backToBackLC.CORRECTIONDATE; newBacktobacklc.PRODUCTQUANTITY = backToBackLC.PRODUCTQUANTITY; newBacktobacklc.QUANTITYUNIT = backToBackLC.QUANTITYUNIT; newBacktobacklc.LCUSEDPRICE = backToBackLC.LCUSEDPRICE; newBacktobacklc.PRICEUNIT = backToBackLC.PRICEUNIT; newBacktobacklc.MASTERLCNUMBER = backToBackLC.MASTERLCNUMBER; newBacktobacklc.MASTERLCCORRECTIONDATE = backToBackLC.MASTERLCCORRECTIONDATE; newBacktobacklc.UDNUMBER = backToBackLC.UDNUMBER; newBacktobacklc.UDDATE = backToBackLC.UDDATE; newBacktobacklc.UDCORRECTIONDATE = backToBackLC.UDCORRECTIONDATE; newBacktobacklc.UDPRODUCTDETAIL = backToBackLC.UDPRODUCTDETAIL; newBacktobacklc.BONDERID = backToBackLC.BONDERID; if (loggedinUser != null) { newBacktobacklc.CREATEDBY = loggedinUser.APPUSER.USERNAME; } newBacktobacklc.CREATEDDATE = thisDay; db.BACKTOBACKLCs.Add(newBacktobacklc); db.SaveChanges(); short lastBackToBackId = db.BACKTOBACKLCs.Max(item => item.ID); foreach (var product in backToBackLC.BACKTOBACKPRODUCTs) { using (var dbBackToBackProduct = new OracleEntitiesConnStr()) { BACKTOBACKPRODUCT newProduct = new BACKTOBACKPRODUCT(); newProduct.NAME = product.NAME; newProduct.SIZEANDDETAIL = product.SIZEANDDETAIL; newProduct.QUANTITY = product.QUANTITY; newProduct.QUANTITYUNIT = product.QUANTITYUNIT; newProduct.BACKTOBACKLCID = lastBackToBackId; newProduct.CREATEDBY = backToBackLC.CREATEDBY; newProduct.CREATEDDATE = thisDay; System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " BACKTOBACKPRODUCTs " + backToBackLC.BACKTOBACKPRODUCTs.Count()); dbBackToBackProduct.BACKTOBACKPRODUCTs.Add(newProduct); dbBackToBackProduct.SaveChanges(); short lastProductId = db.BACKTOBACKPRODUCTs.Max(itemBack2Back => itemBack2Back.ID); //System.Diagnostics.Debug.WriteLine("Time: " + thisDay + " lastProductId = " + lastProductId); foreach (var rawMaterial in product.RAWMATERIALs) { using (var dbRawMaterial = new OracleEntitiesConnStr()) { RAWMATERIAL newRawMaterial = new RAWMATERIAL(); newRawMaterial.RAWMATERIALCODE = rawMaterial.RAWMATERIALCODE; newRawMaterial.QUANTITY = rawMaterial.QUANTITY; newRawMaterial.UNIT = rawMaterial.UNIT; newRawMaterial.PERMITTEDWASTE = rawMaterial.PERMITTEDWASTE; newRawMaterial.PRODUCTID = lastProductId; newRawMaterial.CREATEDDATE = thisDay; dbRawMaterial.RAWMATERIALs.Add(newRawMaterial); dbRawMaterial.SaveChanges(); } } } } } else { backToBackLC.CREATEDDATE = thisDay; db.BACKTOBACKLCs.Add(backToBackLC); db.SaveChanges(); } return(RedirectToAction("Index")); } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult item in ex.EntityValidationErrors) { // Get entry DbEntityEntry entry = item.Entry; string entityTypeName = entry.Entity.GetType().Name; // Display or log error messages foreach (DbValidationError subItem in item.ValidationErrors) { string message = string.Format("Error '{0}' occurred in {1} at {2}", subItem.ErrorMessage, entityTypeName, subItem.PropertyName); System.Diagnostics.Debug.WriteLine("Create(BACKTOBACKPRODUCTs): Time-" + thisDay + " Exception = " + message); ViewBag.error = message; } } } catch (Exception e) { System.Diagnostics.Debug.WriteLine("Create(BACKTOBACKPRODUCTs): Time-" + thisDay + " Exception = " + e.StackTrace); } } ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backToBackLC.BUYERSBANKBRANCHID); ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backToBackLC.BUYERSBANKID); ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backToBackLC.QUANTITYUNIT); ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backToBackLC.PRICEUNIT); for (int i = 0; i < backToBackLC.BACKTOBACKPRODUCTs.Count(); i++) { ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backToBackLC.BACKTOBACKPRODUCTs[i].QUANTITYUNIT); } return(View(backToBackLC)); }
public ActionResult Create(USERPERMISSION userpermission, string type = "") { if (ModelState.IsValid) { USERPERMISSION userpermissionFound = db.USERPERMISSIONs.SingleOrDefault(u => u.USERID == userpermission.USERID); if (userpermissionFound != null) { if (userpermission.BONDERID != null) { if (userpermission.ROLENAME == "Bonder") { BONDER bonder = db.BONDERs.SingleOrDefault(u => u.BONDERSLNO == userpermission.BONDERID); userpermission.BONDER = bonder; } else { userpermission.BONDERID = null; } } else if (userpermission.EMPLOYID != null) { EMPLOYEE employee = db.EMPLOYEEs.SingleOrDefault(u => u.EMPLOYEESLNO == userpermission.EMPLOYID); userpermission.EMPLOYEE = employee; } if (userpermissionFound.EMPLOYID == null && userpermission.EMPLOYID != null) { userpermission.BONDER = null; userpermission.BONDERID = null; } if (userpermissionFound.BONDERID == null && userpermission.BONDERID != null) { userpermission.EMPLOYEE = null; userpermission.EMPLOYID = null; } if (userpermission.USERID > 0) { APPUSER appuser = db.APPUSERs.SingleOrDefault(u => u.ID == userpermission.USERID); userpermission.APPUSER = appuser; userpermissionFound.APPUSER = appuser; } ((IObjectContextAdapter)db).ObjectContext.Detach(userpermissionFound); USERPERMISSION userpermissionFnd = db.USERPERMISSIONs.Find(userpermissionFound.ID); db.USERPERMISSIONs.Remove(userpermissionFnd); db.SaveChanges(); //db.Entry(userpermission).State = EntityState.Modified; if (type.Equals("Operation Admin")) { userpermission.BONDER = null; userpermission.BONDERID = null; } else if (type.Equals("Bonder")) { userpermission.EMPLOYEE = null; userpermission.EMPLOYID = null; } db.USERPERMISSIONs.Add(userpermission); db.SaveChanges(); } else { if (type.Equals("Operation Admin")) { userpermission.BONDER = null; userpermission.BONDERID = null; } else if (type.Equals("Bonder")) { userpermission.EMPLOYEE = null; userpermission.EMPLOYID = null; } db.USERPERMISSIONs.Add(userpermission); db.SaveChanges(); } return(RedirectToAction("Index", "AppUser", null)); } ViewBag.USERID = new SelectList(db.APPUSERs, "ID", "USERNAME", userpermission.USERID); ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", userpermission.BONDERID); ViewBag.EMPLOYID = new SelectList(db.EMPLOYEEs, "EMPLOYEESLNO", "EMPLOYEENAME", userpermission.EMPLOYID); return(View(userpermission)); }
public ActionResult ProductAndRawMaterialStatus(int?BonderID, int?UPNO) { var requestType = this.HttpContext.Request.RequestType; System.Diagnostics.Debug.WriteLine("requestType = " + requestType); List <BonderProductRawMaterial> bonderProductRawMaterialList = null; if ("GET" == requestType) { } else if ("POST" == requestType) { if (null != BonderID && null != UPNO) { ViewBag.SearchBonderID = BonderID; ViewBag.SearchUPNO = UPNO; //Do the query based on parameters bonderProductRawMaterialList = getBonderProductRawMaterialQueryData(UPNO); if (null != bonderProductRawMaterialList && bonderProductRawMaterialList.Count == 0) { bonderProductRawMaterialList = null; ViewBag.ErrorMsg = "No data found!!!! "; } } else { ViewBag.ErrorMsg = "Please select Bonder and UP No!!!! "; } } else { // Error handel } USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission(); if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.BonderID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == loggedinUser.BONDERID), "BONDERSLNO", "BONDERNAME", loggedinUser.BONDERID); } else { ViewBag.BonderID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); } if (null != UPNO) { ViewBag.UPNO = new SelectList(db.UPs.Where(b => b.BONDERID == BonderID), "ID", "UPNO", UPNO); } else { ViewBag.UPNO = new SelectList(db.UPs.Where(b => b.BONDERID == 0), "ID", "UPNO"); } return(View(bonderProductRawMaterialList)); }
public ActionResult Edit(BACKTOBACKLC backtobacklc) { USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission(); if (loggedinUser != null) { backtobacklc.MODIFIEDBY = loggedinUser.APPUSER.USERNAME; } if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == loggedinUser.BONDERID), "BONDERSLNO", "BONDERNAME", backtobacklc.BONDERID); } else { ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", backtobacklc.BONDERID); } foreach (var item in backtobacklc.BACKTOBACKPRODUCTs) { item.BACKTOBACKLCID = backtobacklc.ID; } DateTime thisDay = DateTime.Now; bool isAddMore = false; if (true) { try { if (backtobacklc.BACKTOBACKPRODUCTs != null && backtobacklc.BACKTOBACKPRODUCTs.Count > 0) { if (backtobacklc.BONDERID != null) { USERPERMISSION userpermission = sessionAttributeRetreival.getStoredUserPermission(); int bonderId = backtobacklc.BONDERID; if (userpermission != null) { List <INBONDRAWMATERIAL> inbondRawMaterials = db.INBONDRAWMATERIALs.Where(inb => inb.INBOND.BONDERID == bonderId).ToList(); if (inbondRawMaterials != null) { decimal bonderUsedQuantity = inbondRawMaterials.Sum(item => item.PRODUCTQUANTITY); decimal?bonderProvidedQuantity = backtobacklc.BACKTOBACKPRODUCTs.Sum(item => item.QUANTITY); if (bonderUsedQuantity < bonderProvidedQuantity) { ModelState.AddModelError("", "Your Remaining Inbond Raw Material Quantity " + bonderUsedQuantity); ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backtobacklc.BUYERSBANKBRANCHID); ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backtobacklc.BUYERSBANKID); if (userpermission != null && userpermission.BONDERID != null) { ViewBag.BONDERID = new SelectList(db.BONDERs.Where(b => b.BONDERSLNO == userpermission.BONDERID), "BONDERSLNO", "BONDERNAME", userpermission.BONDERID); } else { ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME", backtobacklc.BONDERID); } ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.QUANTITYUNIT); ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backtobacklc.PRICEUNIT); for (int i = 0; i < backtobacklc.BACKTOBACKPRODUCTs.Count(); i++) { ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.BACKTOBACKPRODUCTs[i].QUANTITYUNIT); } for (int i = 0; i < backtobacklc.BACKTOBACKPRODUCTs.Count(); i++) { return(RedirectToAction("Addmore", new { errorMessage = "Your Remaining Inbond Raw Material Quantity " + bonderUsedQuantity, id = backtobacklc.ID })); } return(View(backtobacklc)); } } } } System.Diagnostics.Debug.WriteLine("Edit(BACKTOBACKPRODUCTs): Time-" + thisDay + " BACKTOBACKPRODUCTs count = " + backtobacklc.BACKTOBACKPRODUCTs.Count); foreach (var item in backtobacklc.BACKTOBACKPRODUCTs) { if (item.NAME != null) { System.Diagnostics.Debug.WriteLine("Edit(BACKTOBACKPRODUCTs): Time-" + thisDay + " item.ID = " + item.ID); if (item.ID == 0) { using (var db1 = new OracleEntitiesConnStr()) { BACKTOBACKPRODUCT newItem = new BACKTOBACKPRODUCT(); newItem.ID = item.ID; newItem.BACKTOBACKLCID = item.BACKTOBACKLCID; newItem.NAME = item.NAME; newItem.QUANTITY = item.QUANTITY; newItem.QUANTITYUNIT = item.QUANTITYUNIT; newItem.CREATEDDATE = thisDay; newItem.SIZEANDDETAIL = item.SIZEANDDETAIL; newItem.ID = item.ID; db1.BACKTOBACKPRODUCTs.Add(newItem); db1.SaveChanges(); } short lastProductId = db.BACKTOBACKPRODUCTs.Max(itemBack2Back => itemBack2Back.ID); foreach (var rawMaterial in item.RAWMATERIALs) { using (var dbRawMaterial = new OracleEntitiesConnStr()) { RAWMATERIAL newRawMaterial = new RAWMATERIAL(); newRawMaterial.RAWMATERIALCODE = rawMaterial.RAWMATERIALCODE; newRawMaterial.QUANTITY = rawMaterial.QUANTITY; newRawMaterial.UNIT = rawMaterial.UNIT; newRawMaterial.PERMITTEDWASTE = rawMaterial.PERMITTEDWASTE; newRawMaterial.PRODUCTID = lastProductId; newRawMaterial.CREATEDDATE = thisDay; dbRawMaterial.RAWMATERIALs.Add(newRawMaterial); dbRawMaterial.SaveChanges(); } } } if (item.ID > 0) { using (var db1 = new OracleEntitiesConnStr()) { BACKTOBACKPRODUCT newItem = new BACKTOBACKPRODUCT(); newItem.ID = item.ID; newItem.BACKTOBACKLCID = item.BACKTOBACKLCID; newItem.NAME = item.NAME; newItem.QUANTITY = item.QUANTITY; newItem.QUANTITYUNIT = item.QUANTITYUNIT; newItem.CREATEDDATE = thisDay; newItem.SIZEANDDETAIL = item.SIZEANDDETAIL; newItem.ID = item.ID; db1.Entry(newItem).State = EntityState.Modified; db1.SaveChanges(); } foreach (var rawMaterial in item.RAWMATERIALs) { using (var dbRawMaterial = new OracleEntitiesConnStr()) { RAWMATERIAL newRawMaterial = new RAWMATERIAL(); newRawMaterial.ID = rawMaterial.ID; newRawMaterial.RAWMATERIALCODE = rawMaterial.RAWMATERIALCODE; newRawMaterial.QUANTITY = rawMaterial.QUANTITY; newRawMaterial.UNIT = rawMaterial.UNIT; newRawMaterial.PERMITTEDWASTE = rawMaterial.PERMITTEDWASTE; newRawMaterial.PRODUCTID = item.ID; newRawMaterial.CREATEDDATE = thisDay; dbRawMaterial.Entry(newRawMaterial).State = EntityState.Modified; dbRawMaterial.SaveChanges(); } } } } } BACKTOBACKLC newBacktobacklc = new BACKTOBACKLC(); newBacktobacklc.BUYERSNAME = backtobacklc.BUYERSNAME; newBacktobacklc.BUYERSADDRESS = backtobacklc.BUYERSADDRESS; newBacktobacklc.LCNUMBER = backtobacklc.LCNUMBER; newBacktobacklc.LCDATE = backtobacklc.LCDATE; newBacktobacklc.BUYERSBANKID = backtobacklc.BUYERSBANKID; newBacktobacklc.BUYERSBANKBRANCHID = backtobacklc.BUYERSBANKBRANCHID; newBacktobacklc.SHIPPINGDATE = backtobacklc.SHIPPINGDATE; newBacktobacklc.CORRECTIONDATE = backtobacklc.CORRECTIONDATE; newBacktobacklc.PRODUCTQUANTITY = backtobacklc.PRODUCTQUANTITY; newBacktobacklc.QUANTITYUNIT = backtobacklc.QUANTITYUNIT; newBacktobacklc.LCUSEDPRICE = backtobacklc.LCUSEDPRICE; newBacktobacklc.PRICEUNIT = backtobacklc.PRICEUNIT; newBacktobacklc.MASTERLCNUMBER = backtobacklc.MASTERLCNUMBER; newBacktobacklc.MASTERLCCORRECTIONDATE = backtobacklc.MASTERLCCORRECTIONDATE; newBacktobacklc.UDNUMBER = backtobacklc.UDNUMBER; newBacktobacklc.UDDATE = backtobacklc.UDDATE; newBacktobacklc.UDCORRECTIONDATE = backtobacklc.UDCORRECTIONDATE; newBacktobacklc.UDPRODUCTDETAIL = backtobacklc.UDPRODUCTDETAIL; newBacktobacklc.BONDERID = backtobacklc.BONDERID; newBacktobacklc.CREATEDBY = backtobacklc.CREATEDBY; newBacktobacklc.CREATEDDATE = backtobacklc.CREATEDDATE; if (loggedinUser != null) { newBacktobacklc.MODIFIEDBY = loggedinUser.APPUSER.USERNAME; } newBacktobacklc.MODIFIEDDATE = thisDay; newBacktobacklc.ID = backtobacklc.ID; db.Entry(newBacktobacklc).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception e) { ViewBag.BUYERSBANKBRANCHID = new SelectList(db.BANKBRANCHes, "BBRANCHSLNO", "BRANCHNAME", backtobacklc.BUYERSBANKBRANCHID); ViewBag.BUYERSBANKID = new SelectList(db.BANKs, "BANKSLNO", "BANKNAME", backtobacklc.BUYERSBANKID); ViewData["QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.QUANTITYUNIT); ViewData["PRICEUNIT"] = new SelectList(model.COSTUNITLIST, "Value", "Text", backtobacklc.PRICEUNIT); for (int i = 0; i < backtobacklc.BACKTOBACKPRODUCTs.Count(); i++) { if (backtobacklc.BACKTOBACKPRODUCTs[i].ID <= 0) { isAddMore = true; } ViewData["BACKTOBACKPRODUCTs[" + i + "].QUANTITYUNIT"] = new SelectList(model.QUANTITYUNITLIST, "Value", "Text", backtobacklc.BACKTOBACKPRODUCTs[i].QUANTITYUNIT); } var message = string.Join(" | ", ModelState.Values .SelectMany(v => v.Errors) .Select(c => c.ErrorMessage)); ViewBag.error = "all field values are required for product!"; if (isAddMore) { return(RedirectToAction("Addmore", new { errorMessage = message, id = backtobacklc.ID })); } return(Redirect(ControllerContext.HttpContext.Request.UrlReferrer.ToString())); } } return(View(backtobacklc)); }
//public ActionResult Search() //{ // return View("Index"); //} //[HttpPost] public ActionResult Search(string BondLicenseNo) { if (!(System.Web.HttpContext.Current.User.IsInRole("Bonder"))) { var bonderslno = (from b in db.BONDERs where b.BONDLICENSENO == BondLicenseNo select b.BONDERSLNO).SingleOrDefault(); System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand(); System.Data.OracleClient.OracleConnection conn = ConnectBMS.Connection(); cmd.Connection = conn; System.Data.OracleClient.OracleTransaction bmsTransaction = conn.BeginTransaction(); cmd.Transaction = bmsTransaction; cmd.CommandText = "select STATUS,BSDATE,SUBMITTEDBYNM,REMARKS from BONDSTATUS where BONDERSLNO=:BONDERSLNO "; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("BONDERSLNO", bonderslno); System.Data.OracleClient.OracleDataReader drBondStatus = cmd.ExecuteReader(); if (drBondStatus.HasRows) { drBondStatus.Read(); ViewBag.STATUS = drBondStatus.GetValue(0); ViewBag.BSDATE = drBondStatus.GetValue(1); ViewBag.SUBMITTEDBYNM = drBondStatus.GetValue(2); ViewBag.REMARKS = drBondStatus.GetValue(3); } try { return(View(getRenewalInfo(bonderslno))); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } ViewBag.Message = "Insertion Failed"; return(View("RenewalForm")); } return(RedirectToAction("Index")); } else { USERPERMISSION permission = session.getStoredUserPermission(); var bonderName = permission.BONDER.BONDERNAME; var bonderslno = (from b in db.BONDERs where b.BONDLICENSENO == BondLicenseNo && b.BONDERNAME == bonderName select b.BONDERSLNO).SingleOrDefault(); System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand(); System.Data.OracleClient.OracleConnection conn = ConnectBMS.Connection(); cmd.Connection = conn; System.Data.OracleClient.OracleTransaction bmsTransaction = conn.BeginTransaction(); cmd.Transaction = bmsTransaction; cmd.CommandText = "select STATUS,BSDATE,SUBMITTEDBYNM,REMARKS from BONDSTATUS where BONDERSLNO=:BONDERSLNO"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("BONDERSLNO", bonderslno); System.Data.OracleClient.OracleDataReader drBondStatus = cmd.ExecuteReader(); if (drBondStatus.HasRows) { drBondStatus.Read(); ViewBag.STATUS = drBondStatus.GetValue(0); ViewBag.BSDATE = drBondStatus.GetValue(1); ViewBag.SUBMITTEDBYNM = drBondStatus.GetValue(2); ViewBag.REMARKS = drBondStatus.GetValue(3); } try { return(View(getRenewalInfo(bonderslno))); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } ViewBag.Message = "Insertion Failed"; return(View("RenewalForm")); } return(RedirectToAction("Index")); } }
public ActionResult Index(int?page, int filterBonderId = 0, int BONDERID = 0) { if (TempData["Message"] != null) { ViewBag.Message = TempData["Message"].ToString(); TempData.Remove("Message"); } int pageSize = recordNumbers; int pageNumber = (page ?? 1); ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission(); var exbonds = db.EXBONDs.Include(e => e.BONDER).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID); if (BONDERID == 0 && filterBonderId == 0 && !User.IsInRole("Bonder")) { List <EXBOND> exbond = new List <EXBOND>(); ViewBag.resultofbonderID = BONDERID; return(View(exbond.ToList().ToPagedList(pageNumber, pageSize))); } if (BONDERID != 0) { page = 1; } else { if (BONDERID == 0) { BONDERID = filterBonderId; } } ViewBag.filterBonderId = BONDERID; if (loggedinUser.BONDERID > 0) { ViewBag.resultofbonderID = loggedinUser.BONDERID; exbonds = db.EXBONDs.Include(e => e.BONDER).Where(e => e.BONDERID == loggedinUser.BONDERID).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID); } else if (BONDERID > 0) { ViewBag.resultofbonderID = BONDERID; exbonds = db.EXBONDs.Include(e => e.BONDER).Where(e => e.BONDERID == BONDERID).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID); } ViewBag.lcNo = db.BACKTOBACKLCs.Include(e => e.ID); ViewBag.userBonderId = loggedinUser.BONDERID; if (BONDERID != 0) { if (loggedinUser.BONDERID > 0) { ViewBag.resultofbonderID = loggedinUser.BONDERID; exbonds = db.EXBONDs.Include(e => e.BONDER).Where(e => e.BONDERID == loggedinUser.BONDERID).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID); } else if (BONDERID > 0) { ViewBag.resultofbonderID = BONDERID; exbonds = db.EXBONDs.Include(e => e.BONDER).Where(e => e.BONDERID == BONDERID).OrderBy(e => e.BONDERID).ThenByDescending(e => e.ID); } } return(View(exbonds.ToPagedList(pageNumber, pageSize))); }
public ActionResult CreateOREditUP(IList <UPREQUEST> requests, string UPNO, short ID = 0) { USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission(); IList <UPREQUEST> requestList = new List <UPREQUEST>(); UP up = new UP(); bool flag = true; bool isanyselected = false; if (UPNO == null || UPNO.Equals("")) { return(RedirectToAction("Create", new { error = "Please Provide UP NO" })); } else { UP duplicateUp = db.UPs.SingleOrDefault(u => u.UPNO.Equals(UPNO)); if (duplicateUp != null) { return(RedirectToAction("Create", new { error = "UP No Already Exists" })); } } for (int i = 0; i < requests.Count(); i++) { int id = requests[i].ID; if (requests[i].IsSelected) { isanyselected = true; UPREQUEST request = db.UPREQUESTs.Find(id); int productCount = request.UPEXBONDLISTs.Count(); if (productCount < 1) { flag = false; } else { requestList.Add(request); up.BONDERID = request.BONDERID; } } } if (!isanyselected && ID <= 0) { return(RedirectToAction("Create", new { error = "Please select at least one exbond" })); } if (!flag && ID <= 0) { return(RedirectToAction("Create", new { error = "Sorry! please check all selected Requests has at least one exbond" })); } else { short lastInserted = 0; if (ID <= 0)//add new UP { DateTime thisDay = DateTime.Today; up.CREATEDDATE = thisDay; if (loggedinUser != null) { up.CREATEDBY = loggedinUser.APPUSER.USERNAME; } up.UPNO = UPNO; db.UPs.Add(up); db.SaveChanges(); lastInserted = db.UPs.Max(item => item.ID); } else//Edit existing UP { if (loggedinUser != null) { up.MODIFIEDBY = loggedinUser.APPUSER.USERNAME; } up = db.UPs.Find(ID); UP newUp = new UP(); newUp.ID = ID; newUp.BONDERID = up.BONDERID; newUp.UPNO = up.UPNO; newUp.MODIFIEDDATE = DateTime.Today; newUp.CREATEDDATE = up.CREATEDDATE; newUp.CREATEDBY = up.CREATEDBY; using (var db2 = new OracleEntitiesConnStr()) { db2.Entry(newUp).State = EntityState.Modified; db2.SaveChanges(); } lastInserted = ID; } for (int x = 0; x < requestList.Count(); x++) { using (var db1 = new OracleEntitiesConnStr())//save value to relational table { UPREQUESTLIST uprequestList = new UPREQUESTLIST(); uprequestList.UPREQUESTID = requestList[x].ID; uprequestList.UPID = lastInserted; db1.UPREQUESTLISTs.Add(uprequestList); db1.SaveChanges(); } using (var db2 = new OracleEntitiesConnStr()) //change status of up request as approved { UPREQUEST request = new UPREQUEST(); // db.UPREQUESTs.Find(requestList[x].ID); request.ID = requestList[x].ID; request.BONDERID = requestList[x].BONDERID; request.STATUS = 20; //approved db2.Entry(request).State = EntityState.Modified; db2.SaveChanges(); } } return(RedirectToAction("Index")); } }
public ActionResult ApplicantsList() { if (!(System.Web.HttpContext.Current.User.IsInRole("Bonder"))) // added By Mizan (18 Aug 2016)-- { var docatt = db.DOCUMENTATTACHMENTs.Where(x => x.BONDER.BONDSTATUS == "R"). GroupBy(x => new { x.BONDERSLNO, x.BONDER.BONDLICENSENO, x.BONDER.BONDERNAME }). Select(x => new { x.Key.BONDERSLNO, x.Key.BONDLICENSENO, x.Key.BONDERNAME }).ToList(); List <BONDER> bonder = new List <BONDER>(); foreach (var item in docatt) { bonder.Add( new BONDER { BONDERSLNO = item.BONDERSLNO, BONDLICENSENO = item.BONDLICENSENO, BONDERNAME = item.BONDERNAME } ); } return(View(bonder)); } else // added By Mizan (18 Aug 2016)-- { USERPERMISSION permission = session.getStoredUserPermission(); var bonderName = permission.BONDER.BONDERNAME; var docatt = db.DOCUMENTATTACHMENTs.Where(x => x.BONDER.BONDSTATUS == "R" && x.BONDER.BONDERNAME == bonderName). GroupBy(x => new { x.BONDERSLNO, x.BONDER.BONDLICENSENO, x.BONDER.BONDERNAME }). Select(x => new { x.Key.BONDERSLNO, x.Key.BONDLICENSENO, x.Key.BONDERNAME }).ToList(); List <BONDER> bonder = new List <BONDER>(); foreach (var item in docatt) { bonder.Add( new BONDER { BONDERSLNO = item.BONDERSLNO, BONDLICENSENO = item.BONDLICENSENO, BONDERNAME = item.BONDERNAME } ); } return(View(bonder)); } //List<DOCUMENTATTACHMENT> documentattachment = new List<DOCUMENTATTACHMENT>(); //foreach (var item in docatt) //{ // documentattachment.Add( // new DOCUMENTATTACHMENT // { // BONDERSLNO = item.BONDERSLNO, // DOCHEADINGNAMEBG = item.BONDLICENSENO, // RGATTCHNAMEBG = item.BONDERNAME // } // ); //} }
public ActionResult Create(int?page, int BONDERID = 0, int filterBonderId = 0) { USERPERMISSION loggedinUser = sessionAttributeRetreival.getStoredUserPermission(); ViewBag.BONDERID = new SelectList(db.BONDERs, "BONDERSLNO", "BONDERNAME"); ViewBag.error = Request.QueryString["error"]; ViewBag.ExbondID = (short)0; ViewBag.userBonderId = loggedinUser.BONDERID; var requestType = this.HttpContext.Request.RequestType; var backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER).Where(b => b.EXBONDBACKTOBACKs.Count() < 1); int pageSize = recordNumbers; int pageNumber = (page ?? 1); if (loggedinUser.BONDERID > 0) { backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER).Where(b => b.EXBONDBACKTOBACKs.Count() < 1 && b.BONDERID == loggedinUser.BONDERID); } if (BONDERID == 0 && filterBonderId == 0 && !User.IsInRole("Bonder")) { List <BACKTOBACKLC> lcs = new List <BACKTOBACKLC>(); ViewBag.resultofbonderID = BONDERID; return(View("Lcselector", lcs.ToPagedList(pageNumber, pageSize))); } if (BONDERID != 0) { page = 1; } else { if (BONDERID == 0) { BONDERID = filterBonderId; } } ViewBag.filterBonderId = BONDERID; if (requestType == "GET") { if (BONDERID > 0) { backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER).Where(b => b.EXBONDBACKTOBACKs.Count() < 1 && b.BONDERID == BONDERID); ViewBag.resultofbonderID = BONDERID; } if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.resultofbonderID = loggedinUser.BONDERID; backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER).Where(b => b.EXBONDBACKTOBACKs.Count() < 1 && b.BONDERID == loggedinUser.BONDERID); } return(View("Lcselector", backtobacklcs.ToPagedList(pageNumber, pageSize))); } else if (requestType == "POST") { if (BONDERID > 0) { ViewBag.resultofbonderID = BONDERID; backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER).Where(b => b.EXBONDBACKTOBACKs.Count() < 1 && b.BONDERID == BONDERID); } } if (loggedinUser != null && loggedinUser.BONDERID != null) { ViewBag.resultofbonderID = loggedinUser.BONDERID; backtobacklcs = db.BACKTOBACKLCs.OrderByDescending(b => b.ID).Include(b => b.BANKBRANCH).Include(b => b.BANK).Include(b => b.BONDER).Where(b => b.EXBONDBACKTOBACKs.Count() < 1 && b.BONDERID == loggedinUser.BONDERID); } return(View("Lcselector", backtobacklcs.ToPagedList(pageNumber, pageSize))); }