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