// Inherited from RoleProvider ==> Forwarded to previous provider if this provider hasn't been initialized
public override bool IsUserInRole(string username, string roleName)
{
if (!InitializeCalled)
{
return(PreviousProvider.IsUserInRole(username, roleName));
}
using (var db = ConnectToDatabase())
{
var count = db.QuerySingle(
"SELECT COUNT(*) FROM "
+ SafeUserTableName
+ " u, "
+ UsersInRoleTableName
+ " ur, "
+ RoleTableName
+ " r Where (u."
+ SafeUserNameColumn
+ " = @0 and r.RoleName = @1 and ur.RoleId = r.RoleId and ur.UserId = u."
+ SafeUserIdColumn
+ ")",
username,
roleName
);
return(count[0] == 1);
}
}
/// <summary>
/// Gets a value indicating whether the specified user is in the specified role 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 name to search for.</param>
/// <param name="roleName">The role to search in.</param>
/// <returns>true if the specified user is in the specified role for the configured applicationName; otherwise, false.</returns>
public override bool IsUserInRole(string username, string roleName)
{
if ((_previousProvider != null) && !InitializeCalled)
{
return(PreviousProvider.IsUserInRole(username, roleName));
}
using (var db = NewMySqlSecurityDbContext)
{
var count = db.UsersInRoles.Count(x => x.UserProfile.UserName.Equals(username, StringComparison.CurrentCultureIgnoreCase) && x.Role.RoleName == roleName);
return(count == 1);
}
}
/// <summary>
/// Gets a value indicating whether the specified user is in the specified role 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 name to search for.</param>
/// <param name="roleName">The role to search in.</param>
/// <returns>true if the specified user is in the specified role for the configured applicationName; otherwise, false.</returns>
public override bool IsUserInRole(string username, string roleName)
{
if (!InitializeCalled)
{
return(PreviousProvider.IsUserInRole(username, roleName));
}
using (var db = NewMySqlMembershipContext)
{
var count = db.UsersInRoles.Count(x => x.UserProfile.UserName == username && x.Role.RoleName == roleName);
return(count == 1);
}
}
