public override string[] GetAllRoles() { using (var usersContext = new ESTGestDbEntities2()) { return usersContext.Roles.Select(r => r.RoleName).ToArray(); } }
public override bool IsUserInRole(string username, string roleName) { using (var usersContext = new ESTGestDbEntities2()) { var user = usersContext.Users.SingleOrDefault(u => u.u_name == username); if (user == null) return false; return user.UserRoles != null && user.UserRoles.Select(u => u.Role).Any(r => r.RoleName == roleName); } }
public override string[] GetRolesForUser(string username) { using (var usersContext = new ESTGestDbEntities2()) { var user = usersContext.Users.SingleOrDefault(u => u.u_name == username); if (user == null) return new string[] { }; return user.UserRoles == null ? new string[] { } : user.UserRoles.Select(u => u.Role).Select(u => u.RoleName).ToArray(); } }
public SQLMemberShipProvider() { _db = new ESTGestDbEntities2(); }