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