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));
}
