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