public static IEnumerable <SelectListItem> ListCategories()
{
FEEDbContext db = new FEEDbContext();
List <SelectListItem> lstSub = db.Categories
.Select(m =>
new SelectListItem
{
Text = m.Name,
Value = m.CategoryId.ToString()
}
).ToList();
return(lstSub);
}
public static List <string> GetProfileService(int userId)
{
FEEDbContext _db = new FEEDbContext();
var query = from u in _db.Users
join r in _db.Roles on u.RoleId equals r.RoleId
join p in _db.Permissions on r.RoleId equals p.RoleId
join f in _db.Functions on p.FunctionId equals f.FunctionId
join c in _db.Commands on p.CommandId equals c.CommandId
where u.Id == userId
select f.FunctionId + "_" + c.CommandId;
var permissions = query.Distinct().ToList();
return(permissions);
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
if (HttpContext.Current.User.Identity.IsAuthenticated && HttpContext.Current.Session["UserID"] == null)
{
FEEDbContext db = new FEEDbContext();
bool Exist = db.Users.Any(e => e.Username == HttpContext.Current.User.Identity.Name);
if (Exist)
{
var user = db.Users.Where(e => e.Username == HttpContext.Current.User.Identity.Name).First();
var userSession = new UserSession();
userSession.Id = user.Id;
userSession.Name = user.Name;
userSession.RoleId = user.RoleId;
userSession.Username = user.Username;
userSession.DepartmentId = user.DepartmentId;
HttpContext.Current.Session.Add("USER", userSession);
HttpContext.Current.Session.Add("PERMISSION", AuthPermission.GetProfileService(user.Id));
}
}
base.OnActionExecuting(filterContext);
}
