public static void GetUserRoleName(string userName, out Guid?roleId, out string roleName)
{
roleId = null;
roleName = null;
if (string.IsNullOrEmpty(userName))
{
return;
}
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (User != null)
{
var x = User.Roles.Select(Rl => Rl.RoleId);
if (x.Count() > 0)
{
roleId = x.ToArray()[0];
roleName = User.Roles.Select(Rl => Rl.RoleName).ToArray()[0];
}
}
}
}
public override MembershipUser GetUser(string username, bool userIsOnline)
{
if (string.IsNullOrEmpty(username))
{
return(null);
}
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.FirstOrDefault(Usr => Usr.Username == username);
if (User != null)
{
if (userIsOnline)
{
User.LastActivityDate = DateTime.UtcNow;
Context.SaveChanges();
}
DateTime lastLockoutDate = DateTime.Now;
if (User.LastLockoutDate != null)
{
lastLockoutDate = User.LastLockoutDate.Value;
}
return(new MembershipUser(Membership.Provider.Name, User.Username, User.UserId, User.Email, null, null, User.IsApproved, User.IsLockedOut, User.CreateDate.Value, User.LastLoginDate.Value, User.LastActivityDate.Value, User.LastPasswordChangedDate.Value, lastLockoutDate));
}
else
{
return(null);
}
}
}
public override MembershipUser GetUser(object providerUserKey, bool userIsOnline)
{
if (providerUserKey is Guid)
{
}
else
{
return(null);
}
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.Find(providerUserKey);
if (User != null)
{
if (userIsOnline)
{
User.LastActivityDate = DateTime.UtcNow;
Context.SaveChanges();
}
DateTime lastLockoutDate = DateTime.Now;
if (User.LastLockoutDate != null)
{
lastLockoutDate = User.LastLockoutDate.Value;
}
return(new MembershipUser(Membership.Provider.Name, User.Username, User.UserId, User.Email, null, null, User.IsApproved, User.IsLockedOut, User.CreateDate.Value, User.LastLoginDate.Value, User.LastActivityDate.Value, User.LastPasswordChangedDate.Value, User.LastLockoutDate.Value));
}
else
{
return(null);
}
}
}
public override bool IsUserInRole(string username, string roleName)
{
if (string.IsNullOrEmpty(username))
{
return(false);
}
if (string.IsNullOrEmpty(roleName))
{
return(false);
}
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.FirstOrDefault(Usr => Usr.Username == username);
if (User == null)
{
return(false);
}
Role Role = Context.Roles.FirstOrDefault(Rl => Rl.RoleName == roleName);
if (Role == null)
{
return(false);
}
return(User.Roles.Contains(Role));
}
}
public override bool ValidateUser(string username, string password)
{
if (string.IsNullOrEmpty(username))
{
return(false);
}
if (string.IsNullOrEmpty(password))
{
return(false);
}
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.FirstOrDefault(Usr => Usr.Username == username);
if (User == null)
{
return(false);
}
if (!User.IsApproved)
{
return(false);
}
if (User.IsLockedOut)
{
return(false);
}
String HashedPassword = User.Password;
Boolean VerificationSucceeded = (HashedPassword != null && Crypto.VerifyHashedPassword(HashedPassword, password));
if (VerificationSucceeded)
{
User.PasswordFailuresSinceLastSuccess = 0;
User.LastLoginDate = DateTime.UtcNow;
User.LastActivityDate = DateTime.UtcNow;
}
else
{
int Failures = User.PasswordFailuresSinceLastSuccess;
if (Failures < MaxInvalidPasswordAttempts)
{
User.PasswordFailuresSinceLastSuccess += 1;
User.LastPasswordFailureDate = DateTime.UtcNow;
}
else if (Failures >= MaxInvalidPasswordAttempts)
{
User.LastPasswordFailureDate = DateTime.UtcNow;
User.LastLockoutDate = DateTime.UtcNow;
User.IsLockedOut = true;
}
}
Context.SaveChanges();
if (VerificationSucceeded)
{
return(true);
}
else
{
return(false);
}
}
}
public override bool DeleteRole(string roleName, bool throwOnPopulatedRole)
{
if (string.IsNullOrEmpty(roleName))
{
return(false);
}
using (SmizeeContext Context = new SmizeeContext())
{
Role Role = null;
Role = Context.Roles.FirstOrDefault(Rl => Rl.RoleName == roleName);
if (Role == null)
{
return(false);
}
if (throwOnPopulatedRole)
{
if (Role.Users.Any())
{
return(false);
}
}
else
{
Role.Users.Clear();
}
Context.Roles.Remove(Role);
Context.SaveChanges();
return(true);
}
}
public override string[] GetAllRoles()
{
using (SmizeeContext Context = new SmizeeContext())
{
return(Context.Roles.Select(Rl => Rl.RoleName).ToArray());
}
}
public override int GetNumberOfUsersOnline()
{
DateTime DateActive = DateTime.UtcNow.Subtract(TimeSpan.FromMinutes(Convert.ToDouble(Membership.UserIsOnlineTimeWindow)));
using (SmizeeContext Context = new SmizeeContext())
{
return(Context.Users.Where(Usr => Usr.LastActivityDate > DateActive).Count());
}
}
public override bool ChangePassword(string username, string oldPassword, string newPassword)
{
if (string.IsNullOrEmpty(username))
{
return(false);
}
if (string.IsNullOrEmpty(oldPassword))
{
return(false);
}
if (string.IsNullOrEmpty(newPassword))
{
return(false);
}
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.FirstOrDefault(Usr => Usr.Username == username);
if (User == null)
{
return(false);
}
String HashedPassword = User.Password;
Boolean VerificationSucceeded = (HashedPassword != null && Crypto.VerifyHashedPassword(HashedPassword, oldPassword));
if (VerificationSucceeded)
{
User.PasswordFailuresSinceLastSuccess = 0;
}
else
{
int Failures = User.PasswordFailuresSinceLastSuccess;
if (Failures < MaxInvalidPasswordAttempts)
{
User.PasswordFailuresSinceLastSuccess += 1;
User.LastPasswordFailureDate = DateTime.UtcNow;
}
else if (Failures >= MaxInvalidPasswordAttempts)
{
User.LastPasswordFailureDate = DateTime.UtcNow;
User.LastLockoutDate = DateTime.UtcNow;
User.IsLockedOut = true;
}
Context.SaveChanges();
return(false);
}
String NewHashedPassword = Crypto.HashPassword(newPassword);
if (NewHashedPassword.Length > 128)
{
return(false);
}
User.Password = NewHashedPassword;
User.LastPasswordChangedDate = DateTime.UtcNow;
Context.SaveChanges();
return(true);
}
}
public string CreateAccount(string userName, string password, bool requireConfirmationToken)
{
if (string.IsNullOrEmpty(userName))
{
throw new MembershipCreateUserException(MembershipCreateStatus.InvalidUserName);
}
if (string.IsNullOrEmpty(password))
{
throw new MembershipCreateUserException(MembershipCreateStatus.InvalidPassword);
}
string hashedPassword = Crypto.HashPassword(password);
if (hashedPassword.Length > 128)
{
throw new MembershipCreateUserException(MembershipCreateStatus.InvalidPassword);
}
using (SmizeeContext Context = new SmizeeContext())
{
if (Context.Users.Where(Usr => Usr.Username == userName).Any())
{
throw new MembershipCreateUserException(MembershipCreateStatus.DuplicateUserName);
}
string token = string.Empty;
if (requireConfirmationToken)
{
token = GenerateToken();
}
User NewUser = new User
{
UserId = Guid.NewGuid(),
Username = userName,
Password = hashedPassword,
IsApproved = !requireConfirmationToken,
Email = string.Empty,
CreateDate = DateTime.UtcNow,
LastPasswordChangedDate = DateTime.UtcNow,
PasswordFailuresSinceLastSuccess = 0,
LastLoginDate = DateTime.UtcNow,
LastActivityDate = DateTime.UtcNow,
LastLockoutDate = null,
IsLockedOut = false,
LastPasswordFailureDate = null,
ConfirmationToken = token
};
Context.Users.Add(NewUser);
Context.SaveChanges();
return(token);
}
}
public static User GetUserInfo(string userName)
{
User user = null;
if (string.IsNullOrEmpty(userName))
{
return(null);
}
using (SmizeeContext Context = new SmizeeContext())
{
user = Context.Users.FirstOrDefault(Usr => Usr.Username == userName);
}
return(user);
}
public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)
{
MembershipUserCollection MembershipUsers = new MembershipUserCollection();
using (SmizeeContext Context = new SmizeeContext())
{
totalRecords = Context.Users.Count();
IQueryable <User> Users = Context.Users.OrderBy(Usrn => Usrn.Username).Skip(pageIndex * pageSize).Take(pageSize);
foreach (User user in Users)
{
MembershipUsers.Add(new MembershipUser(Membership.Provider.Name, user.Username, user.UserId, user.Email, null, null, user.IsApproved, user.IsLockedOut, user.CreateDate.Value, user.LastLoginDate.Value, user.LastActivityDate.Value, user.LastPasswordChangedDate.Value, user.LastLockoutDate.Value));
}
}
return(MembershipUsers);
}
public override string GetUserNameByEmail(string email)
{
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.FirstOrDefault(Usr => Usr.Email == email);
if (User != null)
{
return(User.Username);
}
else
{
return(string.Empty);
}
}
}
public override string[] FindUsersInRole(string roleName, string usernameToMatch)
{
if (string.IsNullOrEmpty(roleName))
{
return(null);
}
if (string.IsNullOrEmpty(usernameToMatch))
{
return(null);
}
using (SmizeeContext Context = new SmizeeContext())
{
return((from Rl in Context.Roles from Usr in Rl.Users where Rl.RoleName == roleName && Usr.Username.Contains(usernameToMatch) select Usr.Username).ToArray());
}
}
public override void AddUsersToRoles(string[] usernames, string[] roleNames)
{
using (SmizeeContext Context = new SmizeeContext())
{
List <User> Users = Context.Users.Where(Usr => usernames.Contains(Usr.Username)).ToList();
List <Role> Roles = Context.Roles.Where(Rl => roleNames.Contains(Rl.RoleName)).ToList();
foreach (User user in Users)
{
foreach (Role role in Roles)
{
if (!user.Roles.Contains(role))
{
user.Roles.Add(role);
}
}
}
Context.SaveChanges();
}
}
public static Guid?GetUserRole(string userName)
{
Guid?userRole = null;
if (string.IsNullOrEmpty(userName))
{
return(null);
}
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (User != null)
{
userRole = User.Roles.Select(Rl => Rl.RoleId).ToArray()[0];
}
}
return(userRole);
}
public override bool UnlockUser(string userName)
{
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (User != null)
{
User.IsLockedOut = false;
User.PasswordFailuresSinceLastSuccess = 0;
Context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public override string[] GetRolesForUser(string username)
{
if (string.IsNullOrEmpty(username))
{
return(null);
}
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.FirstOrDefault(Usr => Usr.Username == username);
if (User != null)
{
return(User.Roles.Select(Rl => Rl.RoleName).ToArray());
}
else
{
return(null);
}
}
}
public override bool RoleExists(string roleName)
{
if (string.IsNullOrEmpty(roleName))
{
return(false);
}
using (SmizeeContext Context = new SmizeeContext())
{
Role Role = null;
Role = Context.Roles.FirstOrDefault(Rl => Rl.RoleName == roleName);
if (Role != null)
{
return(true);
}
else
{
return(false);
}
}
}
public override string[] GetUsersInRole(string roleName)
{
if (string.IsNullOrEmpty(roleName))
{
return(null);
}
using (SmizeeContext Context = new SmizeeContext())
{
Role Role = null;
Role = Context.Roles.FirstOrDefault(Rl => Rl.RoleName == roleName);
if (Role != null)
{
return(Role.Users.Select(Usr => Usr.Username).ToArray());
}
else
{
return(null);
}
}
}
public override void CreateRole(string roleName)
{
if (!string.IsNullOrEmpty(roleName))
{
using (SmizeeContext Context = new SmizeeContext())
{
Role Role = null;
Role = Context.Roles.FirstOrDefault(Rl => Rl.RoleName == roleName);
if (Role == null)
{
Role NewRole = new Role
{
RoleId = Guid.NewGuid(),
RoleName = roleName
};
Context.Roles.Add(NewRole);
Context.SaveChanges();
}
}
}
}
public static MembershipCreateStatus Register(string Username, string Password, string Email, bool IsApproved, string FirstName, string LastName, int?companyId, int?functionalAreaId, Boolean?isManager, Boolean?isExecutive)
{
MembershipCreateStatus CreateStatus;
MembershipUser user = Membership.CreateUser(Username, Password, Email, null, null, IsApproved, Guid.NewGuid(), out CreateStatus);
if (CreateStatus == MembershipCreateStatus.Success)
{
using (SmizeeContext Context = new SmizeeContext())
{
User User = Context.Users.FirstOrDefault(Usr => Usr.Username == Username);
User.CompanyID = companyId;
User.FunctionalAreaID = functionalAreaId;
User.FirstName = FirstName;
User.LastName = LastName;
User.IsManager = isManager;
User.IsExecutive = isExecutive;
Context.SaveChanges();
}
}
return(CreateStatus);
}
public override bool DeleteUser(string username, bool deleteAllRelatedData)
{
if (string.IsNullOrEmpty(username))
{
return(false);
}
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.FirstOrDefault(Usr => Usr.Username == username);
if (User != null)
{
Context.Users.Remove(User);
Context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public override string ResetPassword(string username, string answer)
{
string newPwd = Guid.NewGuid().ToString().Substring(0, 8).Replace("-", "");
string hashedPassword = Crypto.HashPassword(newPwd);
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.FirstOrDefault(Usr => Usr.Username == username);
if (User != null)
{
User.Password = hashedPassword;
Context.SaveChanges();
}
else
{
return(null);
}
}
return(newPwd);
//throw new NotSupportedException("Consider using methods from WebSecurity module.");
}
public static bool LockUser(string userName, bool isLockedOut)
{
using (SmizeeContext Context = new SmizeeContext())
{
User User = null;
User = Context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (User != null)
{
User.IsLockedOut = isLockedOut;
if (isLockedOut)
{
User.LastLockoutDate = DateTime.Now;
}
Context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public override void RemoveUsersFromRoles(string[] usernames, string[] roleNames)
{
using (SmizeeContext Context = new SmizeeContext())
{
foreach (String username in usernames)
{
String us = username;
User user = Context.Users.FirstOrDefault(U => U.Username == us);
if (user != null)
{
foreach (String roleName in roleNames)
{
String rl = roleName;
Role role = user.Roles.FirstOrDefault(R => R.RoleName == rl);
if (role != null)
{
user.Roles.Remove(role);
}
}
}
}
Context.SaveChanges();
}
}
public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status)
{
if (string.IsNullOrEmpty(username))
{
status = MembershipCreateStatus.InvalidUserName;
return(null);
}
if (string.IsNullOrEmpty(password))
{
status = MembershipCreateStatus.InvalidPassword;
return(null);
}
if (string.IsNullOrEmpty(email))
{
status = MembershipCreateStatus.InvalidEmail;
return(null);
}
string HashedPassword = Crypto.HashPassword(password);
if (HashedPassword.Length > 128)
{
status = MembershipCreateStatus.InvalidPassword;
return(null);
}
using (SmizeeContext Context = new SmizeeContext())
{
if (Context.Users.Where(Usr => Usr.Username == username).Any())
{
status = MembershipCreateStatus.DuplicateUserName;
return(null);
}
//if (Context.Users.Where(Usr => Usr.Email == email).Any())
//{
// status = MembershipCreateStatus.DuplicateEmail;
// return null;
//}
User NewUser = new User
{
UserId = Guid.NewGuid(),
Username = username,
Password = HashedPassword,
IsApproved = isApproved,
Email = email,
CreateDate = DateTime.UtcNow,
LastPasswordChangedDate = DateTime.UtcNow,
PasswordFailuresSinceLastSuccess = 0,
LastLoginDate = DateTime.UtcNow,
LastActivityDate = DateTime.UtcNow,
LastLockoutDate = null,
IsLockedOut = false,
LastPasswordFailureDate = null
};
Context.Users.Add(NewUser);
Context.SaveChanges();
status = MembershipCreateStatus.Success;
DateTime lastLockoutDate = DateTime.Now;
if (NewUser.LastLockoutDate != null)
{
lastLockoutDate = NewUser.LastLockoutDate.Value;
}
return(new MembershipUser(Membership.Provider.Name, NewUser.Username, NewUser.UserId, NewUser.Email, null, null, NewUser.IsApproved, NewUser.IsLockedOut, NewUser.CreateDate.Value, NewUser.LastLoginDate.Value, NewUser.LastActivityDate.Value, NewUser.LastPasswordChangedDate.Value, lastLockoutDate));
}
}