public ActionResult Edit_Privilege(IList <SelectUserAccess> model)
{
if (ModelState.IsValid)
{
foreach (SelectUserAccess item in model)
{
if (item.Selected)
{
var uACCESSVal = (from C in db.USERS_ACCESS
where (C.LVL_1_MENU.Equals(item.AccessList.LVL_1_MENU) && C.USRS_ID == item.AccessList.USRS_ID)
select new { id = C.ID, usr_id = C.USRS_ID, usr_role = C.USR_ROLE, l_item = C.LIST_ITEM, l_1_menu = C.LVL_1_MENU, l_2_menu = C.LVL_2_MENU, ctl = C.CTL, act = C.ACTN, is_accble = C.IS_ACCBLE }).FirstOrDefault();
USERS_ACCESS uSERaCCCESS = db.USERS_ACCESS.Find(uACCESSVal.id);
uSERaCCCESS.IS_ACCBLE = "Y";
db.SaveChanges();
}
else
{
var uACCESSVal = (from C in db.USERS_ACCESS
where (C.LVL_1_MENU.Equals(item.AccessList.LVL_1_MENU) && C.USRS_ID == item.AccessList.USRS_ID)
select new { id = C.ID, usr_id = C.USRS_ID, usr_role = C.USR_ROLE, l_item = C.LIST_ITEM, l_1_menu = C.LVL_1_MENU, l_2_menu = C.LVL_2_MENU, ctl = C.CTL, act = C.ACTN, is_accble = C.IS_ACCBLE }).FirstOrDefault();
USERS_ACCESS uSERaCCCESS = db.USERS_ACCESS.Find(uACCESSVal.id);
uSERaCCCESS.IS_ACCBLE = "N";
db.SaveChanges();
}
}
}
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.ID }).Distinct().Where(a => a.USRS_ID.Equals(id)).ToList())
{
USERS_ACCESS uSERaCCCESS = db.USERS_ACCESS.Find(entity.ID);
db.USERS_ACCESS.Remove(uSERaCCCESS);
db.SaveChanges();
}
USER uSER = db.USERS.Find(id);
db.USERS.Remove(uSER);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "ID,USRNAME,FIRST_NAME,LAST_NAME,EML,ADMIN_IND,STDNT_IND,EMP_IND,HASHED_PSWRD,SALT,RST_PSWRD_CODE,RST_PSWRD_CODE_UNTL,CREATED_AT,UPDATED_AT,PARNT_IND")] USER uSER)
{
if (ModelState.IsValid)
{
db.USERS.Add(uSER);
db.SaveChanges();
if (uSER.ADMIN_IND.Equals("Y"))
{
foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(1)).ToList())
{
var UserAccess = new USERS_ACCESS()
{
USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE
};
db.USERS_ACCESS.Add(UserAccess);
db.SaveChanges();
}
}
else if (uSER.EMP_IND.Equals("Y"))
{
foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(2)).ToList())
{
var UserAccess = new USERS_ACCESS()
{
USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE
};
db.USERS_ACCESS.Add(UserAccess);
db.SaveChanges();
}
}
else if (uSER.STDNT_IND.Equals("Y"))
{
foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(4)).ToList())
{
var UserAccess = new USERS_ACCESS()
{
USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE
};
db.USERS_ACCESS.Add(UserAccess);
db.SaveChanges();
}
}
else if (uSER.PARNT_IND.Equals("Y"))
{
foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(3)).ToList())
{
var UserAccess = new USERS_ACCESS()
{
USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE
};
db.USERS_ACCESS.Add(UserAccess);
db.SaveChanges();
}
}
else
{
foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(3)).ToList())
{
var UserAccess = new USERS_ACCESS()
{
USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE
};
db.USERS_ACCESS.Add(UserAccess);
db.SaveChanges();
}
}
return(RedirectToAction("Edit_Privilege", "USERs", new { id = uSER.ID }));
}
return(View(uSER));
}
