/// <summary>
/// Checks if user with given password exists in the database
/// </summary>
/// <param name="_username">User name</param>
/// <param name="_password">User password</param>
/// <returns>True if user exist and password is correct</returns>
public bool Authenticate(string _username, string _password, string IP)
{
bool authenticated = false;
using (EfQualityMeterBaseDb db = new EfQualityMeterBaseDb())
{
try
{
string encodedPassword = TextEncoding.EncodeString(_password);
QualityMeter.Core.Models.User loginUser = db.Users
.FirstOrDefault(u => u.UserName == _username && u.Password == encodedPassword && u.Active);
if (loginUser == null)
{
authenticated = false;
}
else
{
authenticated = true;
}
}
catch (Exception ex)
{
authenticated = false;
}
}
return(authenticated);
}
public long GetUserId(string _username)
{
long userId = 0;
using (EfQualityMeterBaseDb db = new EfQualityMeterBaseDb())
{
var user = (from u in db.Users
where u.UserName == _username
select u).SingleOrDefault();
if (user != default(QualityMeter.Core.Models.User))
{
userId = user.Id;
}
}
return(userId);
}
public override bool IsUserInRole(string username, string roleName)
{
bool isUserInRole = false;
if (!string.IsNullOrEmpty(username) && !string.IsNullOrEmpty(roleName))
{
using (EfQualityMeterBaseDb db = new EfQualityMeterBaseDb())
{
try
{
isUserInRole = db.UserRoles
.Any(obj => obj.User.UserName == username && obj.User.Active && obj.Role.Roles == roleName);
}
catch (Exception)
{
throw new Exception("IsUserInRole User: "******" Role: " + roleName);
}
}
}
return(isUserInRole);
}
public override string[] GetRolesForUser(string username)
{
List <string> _Roles = new List <string>();
using (EfQualityMeterBaseDb db = new EfQualityMeterBaseDb())
{
if (!string.IsNullOrEmpty(username))
{
try
{
_Roles = db.UserRoles
.Where(obj => obj.User.UserName == username && obj.User.Active)
.Select(obj => obj.Role.Roles).ToList();
}
catch (Exception)
{
throw new Exception("GetRolesForUser " + username);
}
}
}
return(_Roles.ToArray());
}
