// Inherited from RoleProvider ==> Forwarded to previous provider if this provider hasn't been initialized
public override string[] GetRolesForUser(string username)
{
if (!InitializeCalled)
{
return(PreviousProvider.GetRolesForUser(username));
}
using (var db = ConnectToDatabase()) {
int userId = SimpleMembershipProvider.GetUserId(db, SafeUserTableName, SafeUserNameColumn, SafeUserIdColumn, username);
if (userId == -1)
{
throw new InvalidOperationException(String.Format(CultureInfo.CurrentCulture, WebDataResources.Security_NoUserFound, username));
}
string query = @"SELECT r.RoleName FROM " + UsersInRoleTableName + " u, " + RoleTableName + " r Where (u.UserId = @0 and u.RoleId = r.RoleId) GROUP BY RoleName";
return(db.Query(query, new object[] { userId }).Select <dynamic, string>(d => (string)d[0]).ToArray());
}
}
/// <summary>
/// Gets a list of the roles that a specified user is in for the configured applicationName.
/// </summary>
/// <remarks>Inherited from RoleProvider ==> Forwarded to previous provider if this provider hasn't been initialized</remarks>
/// <param name="username">The user to return a list of roles for.</param>
/// <returns>A string array containing the names of all the roles that the specified user is in for the configured applicationName.</returns>
/// <exception cref="System.InvalidOperationException"></exception>
public override string[] GetRolesForUser(string username)
{
if (!InitializeCalled)
{
return(PreviousProvider.GetRolesForUser(username));
}
using (var db = NewMySqlSecurityDbContext)
{
int userId = MySqlSimpleMembershipProvider.GetUserId(db, username);
if (userId == -1)
{
throw new InvalidOperationException(String.Format(CultureInfo.CurrentCulture, Resources.Security_NoUserFound, username));
}
var roleNames = db.UsersInRoles.Where(x => x.UserId == userId)
.Select(x => x.Role.RoleName)
.ToArray();
return(roleNames);
}
}
