public static List <Role> GetUserRoles(string userName)
{
EmployeeLoginDataContext dataContext = new EmployeeLoginDataContext();
var result = from e in dataContext.Employee
join er in dataContext.EmployeeRole on e.EmployeeID equals er.EmployeeID
join r in dataContext.Role on er.RoleID equals r.RoleID
where e.Email == userName
select r;
return(result.ToList());
}
public static bool UserHasRole(string username, string roleName)
{
EmployeeLoginDataContext dataContext = new EmployeeLoginDataContext();
var result = (from e in dataContext.Employee
join er in dataContext.EmployeeRole on e.EmployeeID equals er.EmployeeID
join r in dataContext.Role on er.RoleID equals r.RoleID
where e.Email == username && r.Name == roleName
select r).Any();
return(result);
}
public static Employee LoginUser(string username, string password)
{
if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password))
{
throw new MissingFieldException("kullanıcı adı yada şifreyi boş gönderemezsiniz");
}
EmployeeLoginDataContext dataContext = new EmployeeLoginDataContext();
var employee = dataContext.Employee.Where(e => e.Email == username && e.Password == password).FirstOrDefault();
return(employee);
}
