public ActionResult DeleteConfirmed(decimal id) { SET_ROLE set_role = db.SET_ROLE.Single(s => s.ROLE_NO == id); db.SET_ROLE.DeleteObject(set_role); db.SaveChanges(); return(RedirectToAction("Index")); }
// // GET: /Roles/Delete/5 public ActionResult Delete(decimal id = 0) { SET_ROLE set_role = db.SET_ROLE.Single(s => s.ROLE_NO == id); if (set_role == null) { return(HttpNotFound()); } return(View(set_role)); }
public ActionResult Edit(SET_ROLE set_role) { if (ModelState.IsValid) { db.SET_ROLE.Attach(set_role); db.ObjectStateManager.ChangeObjectState(set_role, EntityState.Modified); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(set_role)); }
public ActionResult Create(SET_ROLE set_role) { if (ModelState.IsValid) { db.SET_ROLE.AddObject(set_role); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.USER_TYPE_NO = new SelectList(db.GEN_USER_TYPES, "USER_TYPE_NO", "USER_TYPE", set_role.USER_TYPE_NO); return(View(set_role)); }
public ActionResult Permissions(long id = 0) { SET_ROLE role = db.SET_ROLE.Where(a => a.ROLE_NO == id).FirstOrDefault(); ViewBag.ROLE_NAME = role.ROLE_NAME; List <GEN_CONTROLLER_ACTION> controllerList = db.GEN_CONTROLLER_ACTION .Where(a => a.IS_ACTIVE == 1 && a.IS_AUTO_INCLUDE == 0 && a.PARENT_ACTION_NO == null && (a.IS_PUBLIC == null || a.IS_PUBLIC == 0)) .OrderBy(a => a.ACTION_NAME).OrderBy(a => a.CONTROLLER_NAME) .ToList(); List <SET_ROLE_ACTION> permit_list = db.SET_ROLE_ACTION.Where(a => a.ROLE_NO == id).ToList(); foreach (var item in controllerList) { SET_ROLE_ACTION actionPerm = (from p in permit_list where p.ACTION_NO == item.ACTION_NO select p).FirstOrDefault(); if (actionPerm == null) { item.IS_ACTIVE = 0; } else { item.IS_ACTIVE = actionPerm.IS_ACTIVE; } } ViewBag.controllerList = controllerList; ViewBag.userType = id; TempData["USER_ROLE"] = id; TempData.Keep(); return(View()); }
public ActionResult Login(SEC_USERS sec_user) { SEC_USERS_LOGIN_Result1 user = db.SEC_USERS_LOGIN(sec_user.USER_NAME, sec_user.USER_PWD, null).FirstOrDefault(); if (user != null && user.USER_NO > 0) { Session["sess_sec_users"] = user; Session["sess_USER_NO"] = user.USER_NO; if (user.USER_TYPE_NO == (decimal)EUserTypes.Agent) { Session["sess_entry_user_no"] = user.USER_NO; Session["sess_zm_user_no"] = user.USER_PARENT_NO; Session["sess_agent_user_no"] = user.USER_NO; } else { Session["sess_entry_user_no"] = user.USER_NO; Session["sess_zm_user_no"] = user.USER_NO; Session["sess_agent_user_no"] = null; } bool Is_ZonalOrAgent = ((decimal)user.USER_TYPE_NO == (decimal)EUserTypes.ZonalManager || (decimal)user.USER_TYPE_NO == (decimal)EUserTypes.Agent); Session["sess_Is_ZonalOrAgent"] = Is_ZonalOrAgent; string sess_id = Session.SessionID; string ip_addr = CustomValidator.GetRequestIpAddress(); string device_id = CustomValidator.GetDeviceId(); string login_mobile = sec_user.USER_MOBILE; string ws_id = CustomValidator.GetWebServerId(); string app_version = sec_user.APP_VERSION; decimal LOGON_NO = db.SEC_USER_LOGONS_INSERT(user.USER_NO, ip_addr, device_id, null, null, null, (decimal)ApproveType.Approved, null, null, sess_id, login_mobile, ws_id, app_version, login_mobile).First().Value; Session["sess_LOGON_NO"] = LOGON_NO; if (user.USER_TYPE_NO == (decimal)EUserTypes.GeneralUser) { List <SET_USER_ACTION> per_list = new List <SET_USER_ACTION>(); per_list = db.SET_USER_ACTION.Include(a => a.GEN_CONTROLLER_ACTION) .Where(a => (a.USER_NO == user.USER_NO) && (a.IS_ACTIVE == 1)) .ToList(); List <GEN_CONTROLLER_ACTION> menu_list = (from c in per_list where (c.GEN_CONTROLLER_ACTION.IS_MENU == 1 && c.GEN_CONTROLLER_ACTION.IS_ACTIVE == 1 ) orderby c.GEN_CONTROLLER_ACTION.SL_NUM select c.GEN_CONTROLLER_ACTION).ToList(); Session["sess_MENU_LIST"] = menu_list; Session["sess_PERMISSION_LIST"] = per_list; if (menu_list != null) { GEN_CONTROLLER_ACTION redirect_action = menu_list.First(); return(RedirectToAction(redirect_action.ACTION_NAME, redirect_action.CONTROLLER_NAME)); } } else { SET_ROLE role = db.SET_ROLE.Where(r => r.USER_TYPE_NO == user.USER_TYPE_NO).FirstOrDefault(); decimal?ROLE_NO = null; if (role != null) { ROLE_NO = role.ROLE_NO; Session["ROLE_NO"] = role.ROLE_NO; } //ROLE_NO = decimal.Parse(Session["ROLE_NO"].ToString()); List <SET_ROLE_ACTION> per_list = new List <SET_ROLE_ACTION>(); if (ROLE_NO.HasValue) { per_list = db.SET_ROLE_ACTION.Include(a => a.GEN_CONTROLLER_ACTION) .Where(a => (a.ROLE_NO == ROLE_NO.Value) && (a.IS_ACTIVE == 1)) .ToList(); List <GEN_CONTROLLER_ACTION> menu_list = (from c in per_list where (c.GEN_CONTROLLER_ACTION.IS_MENU == 1 && c.GEN_CONTROLLER_ACTION.IS_ACTIVE == 1 ) orderby c.GEN_CONTROLLER_ACTION.SL_NUM select c.GEN_CONTROLLER_ACTION).ToList(); Session["sess_MENU_LIST"] = menu_list; Session["sess_PERMISSION_LIST"] = per_list; if (menu_list != null) { GEN_CONTROLLER_ACTION redirect_action = menu_list.First(); return(RedirectToAction(redirect_action.ACTION_NAME, redirect_action.CONTROLLER_NAME)); } } } } return(View()); }
public ActionResult Permissions(SET_ROLE_ACTION[] permissions) { decimal?USER_NO = Session["sess_USER_NO"] as decimal?; decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?; SET_ROLE_ACTION permission = permissions.FirstOrDefault(); if (permission != null) { List <GEN_CONTROLLER_ACTION> allowedControllerList = db.GEN_CONTROLLER_ACTION .Where(a => a.IS_ACTIVE == 1 && (a.IS_AUTO_INCLUDE == 1 || a.IS_PUBLIC == 1)).ToList(); foreach (var allowed in allowedControllerList) { SET_ROLE_ACTION allowedRecord = db.SET_ROLE_ACTION. Where(a => a.ACTION_NO == allowed.ACTION_NO && a.ROLE_NO == permission.ROLE_NO). FirstOrDefault(); if (allowedRecord == null) { db.SET_ROLE_ACTION_INSERT(USER_NO, LOGON_NO, permission.ROLE_NO, allowed.ACTION_NO, 1, "Automatically Allowed"); } } } foreach (var perm in permissions) { SET_ROLE_ACTION record = db.SET_ROLE_ACTION. Where(a => a.ACTION_NO == perm.ACTION_NO && a.ROLE_NO == perm.ROLE_NO). FirstOrDefault(); if (record == null) { SET_ROLE_ACTION rolac = new SET_ROLE_ACTION(); rolac.ACTION_NO = perm.ACTION_NO; rolac.ROLE_NO = perm.ROLE_NO; rolac.IS_ACTIVE = perm.IS_ACTIVE; //db.GEN_USERS_PERMISSIONS.Add(gen_user_permission); db.SET_ROLE_ACTION_INSERT(USER_NO, LOGON_NO, rolac.ROLE_NO, rolac.ACTION_NO, rolac.IS_ACTIVE, rolac.DETAILS); } else { record.IS_ACTIVE = perm.IS_ACTIVE; //db.Entry(record).State = EntityState.Modified; db.SET_ROLE_ACTION_UPDATE(record.ROLE_ACTION_NO, USER_NO, LOGON_NO, record.ROLE_NO, record.ACTION_NO, record.IS_ACTIVE, record.DETAILS); } List <GEN_CONTROLLER_ACTION> childActions = db.GEN_CONTROLLER_ACTION .Where(a => a.PARENT_ACTION_NO == perm.ACTION_NO).ToList(); foreach (var child in childActions) { SET_ROLE_ACTION childRecord = db.SET_ROLE_ACTION. Where(a => a.ACTION_NO == child.ACTION_NO && a.ROLE_NO == perm.ROLE_NO). FirstOrDefault(); if (childRecord == null) { db.SET_ROLE_ACTION_INSERT(USER_NO, LOGON_NO, perm.ROLE_NO, child.ACTION_NO, perm.IS_ACTIVE, "Child Perms"); } else { db.SET_ROLE_ACTION_UPDATE(childRecord.ROLE_ACTION_NO, USER_NO, LOGON_NO, perm.ROLE_NO, childRecord.ACTION_NO, perm.IS_ACTIVE, "Child Perms"); } } } ViewBag.userRole = TempData.Peek("USER_ROLE"); decimal userRole = ViewBag.userRole; SET_ROLE role = db.SET_ROLE.Where(a => a.ROLE_NO == userRole).FirstOrDefault(); ViewBag.ROLE_NAME = role.ROLE_NAME; //db.SaveChanges(); List <GEN_CONTROLLER_ACTION> controllerList = db.GEN_CONTROLLER_ACTION .Where(a => a.IS_ACTIVE == 1 && a.IS_AUTO_INCLUDE == 0 && a.PARENT_ACTION_NO == null && (a.IS_PUBLIC == null || a.IS_PUBLIC == 0)) .OrderBy(a => a.ACTION_NAME).OrderBy(a => a.CONTROLLER_NAME) .ToList(); ViewBag.controllerList = controllerList; return(View()); }