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