public override string[] GetRolesForUser(string login)
{
string[] role = new string[] { };
using (EFDbContext _db = new EFDbContext())
{
try
{
// Получаем пользователя
/*Users user = (from u in _db.Users
where u.login == login
select u).FirstOrDefault();*/
Users user = _db.Users.FirstOrDefault(x => x.login == login);
if (user != null)
{
// получаем роль
Role userRole = _db.Roles.Find(user.role_id);
if (userRole != null)
{
role = new string[] { userRole.name };
}
}
}
catch
{
role = new string[] { };
}
}
return role;
}
public override bool IsUserInRole(string username, string roleName)
{
bool outputResult = false;
// Находим пользователя
using (EFDbContext _db = new EFDbContext())
{
try
{
// Получаем пользователя
Users user = (from u in _db.Users
where u.login == username
select u).FirstOrDefault();
if (user != null)
{
// получаем роль
Role userRole = _db.Roles.Find(user.role_id);
//сравниваем
if (userRole != null && userRole.name == roleName)
{
outputResult = true;
}
}
}
catch
{
outputResult = false;
}
}
return outputResult;
}
private bool ValidateUser(string login, string password)
{
bool isValid = false;
using (EFDbContext _db = new EFDbContext())
{
try
{
Users user = (from u in _db.Users
where u.login == login && u.password == password
select u).FirstOrDefault();
if (user != null)
{
isValid = true;
}
}
catch
{
isValid = false;
}
}
return isValid;
}