public static string getBonderName(short id = 0) { using (OracleEntitiesConnStr db = new OracleEntitiesConnStr()){ BONDER bonder = db.BONDERs.Find(id); if (bonder == null) { return(String.Empty); } return(bonder.BONDERNAME); } }
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)); }