public override bool DeleteRole(string roleName, bool throwOnPopulatedRole)
{
if (string.IsNullOrEmpty(roleName))
{
throw CreateArgumentNullOrEmptyException("roleName");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic role = context.Roles.FirstOrDefault(Rl => Rl.RoleName == roleName);
if (role == null)
{
throw new InvalidOperationException("Role not found");
}
if (throwOnPopulatedRole)
{
dynamic usersInRole = role.Users.Any;
if (usersInRole)
{
throw new InvalidOperationException(string.Format("Role populated: {0}", roleName));
}
}
else
{
foreach (User usr_loopVariable in role.Users)
{
var usr = usr_loopVariable;
context.Users.Remove(usr);
}
}
context.Roles.Remove(role);
context.SaveChanges();
return true;
}
}
public override void AddUsersToRoles(string[] usernames, string[] roleNames)
{
using (ShoelaceContext context = new ShoelaceContext())
{
var users = context.Users.Where(usr => usernames.Contains(usr.Username)).ToList();
var roles = context.Roles.Where(rl => roleNames.Contains(rl.RoleName)).ToList();
foreach (User user_loopVariable in users)
{
var user = user_loopVariable;
foreach (Role role_loopVariable in roles)
{
var role = role_loopVariable;
if (!user.Roles.Contains(role))
{
user.Roles.Add(role);
}
}
}
context.SaveChanges();
}
}
public override void CreateRole(string roleName)
{
if (string.IsNullOrEmpty(roleName))
{
throw CreateArgumentNullOrEmptyException("roleName");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic role = context.Roles.FirstOrDefault(Rl => Rl.RoleName == roleName);
if (role != null)
{
throw new InvalidOperationException(string.Format("Role exists: {0}", roleName));
}
Role NewRole = new Role
{
RoleId = Guid.NewGuid(),
RoleName = roleName
};
context.Roles.Add(NewRole);
context.SaveChanges();
}
}
public override System.DateTime GetPasswordChangedDate(string userName)
{
if (string.IsNullOrEmpty(userName))
{
throw CreateArgumentNullOrEmptyException("userName");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic user = context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (user == null)
{
throw new InvalidOperationException(string.Format("User not found: {0}", userName));
}
return user.PasswordChangedDate;
}
}
public override string GeneratePasswordResetToken(string userName, int tokenExpirationInMinutesFromNow)
{
if (string.IsNullOrEmpty(userName))
{
throw CreateArgumentNullOrEmptyException("userName");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic user = context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (user == null)
{
throw new InvalidOperationException(string.Format("User not found: {0}", userName));
}
if (!user.IsConfirmed)
{
throw new InvalidOperationException(string.Format("User not found: {0}", userName));
}
string token = null;
if (user.PasswordVerificationTokenExpirationDate > DateTime.UtcNow)
{
token = user.PasswordVerificationToken;
}
else
{
token = CodeFirstCrypto.GenerateToken();
}
user.PasswordVerificationToken = token;
user.PasswordVerificationTokenExpirationDate = DateTime.UtcNow.AddMinutes(tokenExpirationInMinutesFromNow);
context.SaveChanges();
return token;
}
}
public override string ExtendedValidateUser(string userNameOrEmail, string password)
{
if (string.IsNullOrEmpty(userNameOrEmail))
{
throw CreateArgumentNullOrEmptyException("userNameOrEmail");
}
if (string.IsNullOrEmpty(password))
{
throw CreateArgumentNullOrEmptyException("password");
}
using (ShoelaceContext context = new ShoelaceContext())
{
User user = null;
user = context.Users.FirstOrDefault(Usr => Usr.Username == userNameOrEmail);
if (user == null)
{
user = context.Users.FirstOrDefault(Usr => Usr.Email == userNameOrEmail);
}
if (user == null)
{
return string.Empty;
}
if (!user.IsConfirmed)
{
return string.Empty;
}
dynamic hashedPassword = user.Password;
bool verificationSucceeded = (hashedPassword != null && CodeFirstCrypto.VerifyHashedPassword(hashedPassword, password));
if (verificationSucceeded)
{
user.PasswordFailuresSinceLastSuccess = 0;
}
else
{
int failures = user.PasswordFailuresSinceLastSuccess;
if (failures != -1)
{
user.PasswordFailuresSinceLastSuccess += 1;
user.LastPasswordFailureDate = DateTime.UtcNow;
}
}
context.SaveChanges();
if (verificationSucceeded)
{
return user.Username;
}
else
{
return string.Empty;
}
}
}
public override bool DeleteAccount(string userName)
{
if (string.IsNullOrEmpty(userName))
{
throw CreateArgumentNullOrEmptyException("userName");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic user = context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (user == null)
{
return false;
}
context.Users.Remove(user);
context.SaveChanges();
return true;
}
}
public override string[] GetAllRoles()
{
using (ShoelaceContext context = new ShoelaceContext())
{
return context.Roles.Select(Rl => Rl.RoleName).ToArray();
}
}
public override bool ResetPasswordWithToken(string token, string newPassword)
{
if (string.IsNullOrEmpty(newPassword))
{
throw CreateArgumentNullOrEmptyException("newPassword");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic user = context.Users.FirstOrDefault(Usr => Usr.PasswordVerificationToken == token && Usr.PasswordVerificationTokenExpirationDate > DateTime.UtcNow);
if (user != null)
{
dynamic newhashedPassword = CodeFirstCrypto.HashPassword(newPassword);
if (newhashedPassword.Length > 128)
{
throw new ArgumentException("Password too long");
}
user.Password = newhashedPassword;
user.PasswordChangedDate = DateTime.UtcNow;
user.PasswordVerificationToken = null;
user.PasswordVerificationTokenExpirationDate = null;
context.SaveChanges();
return true;
}
else
{
return false;
}
}
}
public override System.Guid GetUserIdFromPasswordResetToken(string token)
{
if (string.IsNullOrEmpty(token))
{
throw CreateArgumentNullOrEmptyException("token");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic result = context.Users.FirstOrDefault(Usr => Usr.PasswordVerificationToken == token);
if (result != null)
{
return result.UserId;
}
return Guid.Empty;
}
}
public override bool RoleExists(string roleName)
{
if (string.IsNullOrEmpty(roleName))
{
throw CreateArgumentNullOrEmptyException("roleName");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic result = context.Roles.FirstOrDefault(Rl => Rl.RoleName == roleName);
if (result != null)
{
return true;
}
else
{
return false;
}
}
}
public override void RemoveUsersFromRoles(string[] usernames, string[] roleNames)
{
using (ShoelaceContext context = new ShoelaceContext())
{
foreach (string username_loopVariable in usernames)
{
var username = username_loopVariable;
string us = username;
User user = context.Users.FirstOrDefault(u => u.Username == us);
if (user != null)
{
foreach (string rolename_loopVariable in roleNames)
{
var rolename = rolename_loopVariable;
var rl = rolename;
Role role = user.Roles.FirstOrDefault(r => r.RoleName == rl);
if (role != null)
{
user.Roles.Remove(role);
}
}
}
}
context.SaveChanges();
}
}
public override bool IsUserInRole(string userName, string roleName)
{
if (string.IsNullOrEmpty(userName))
{
throw CreateArgumentNullOrEmptyException("userName");
}
if (string.IsNullOrEmpty(roleName))
{
throw CreateArgumentNullOrEmptyException("roleName");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic user = context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (user == null)
{
return false;
}
dynamic role = context.Roles.FirstOrDefault(Rl => Rl.RoleName == roleName);
if (role == null)
{
return false;
}
return user.Roles.Contains(role);
}
}
public override string[] GetUsersInRole(string roleName)
{
if (string.IsNullOrEmpty(roleName))
{
throw CreateArgumentNullOrEmptyException("roleName");
}
using (ShoelaceContext context = new ShoelaceContext())
{
var role = context.Roles.FirstOrDefault(Rl => Rl.RoleName == roleName);
if (role == null)
{
throw new InvalidOperationException("Role not found");
}
return role.Users.Select(Usr => Usr.Username).ToArray();
}
}
public override string[] GetRolesForUser(string userName)
{
if (string.IsNullOrEmpty(userName))
{
throw CreateArgumentNullOrEmptyException("userName");
}
using (ShoelaceContext context = new ShoelaceContext())
{
var user = context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (user == null)
{
throw new InvalidOperationException(string.Format("User not found: {0}", userName));
}
return user.Roles.Select(Rl => Rl.RoleName).ToArray();
}
}
public override int GetPasswordFailuresSinceLastSuccess(string userName)
{
if (string.IsNullOrEmpty(userName))
{
throw CreateArgumentNullOrEmptyException("userName");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic user = context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (user == null)
{
throw new InvalidOperationException(string.Format("User not found: {0}", userName));
}
return user.PasswordFailuresSinceLastSuccess;
}
}
public override System.Web.Security.MembershipUser GetUser(string userName, bool userIsOnline)
{
if (string.IsNullOrEmpty(userName))
{
throw CreateArgumentNullOrEmptyException("userName");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic user = context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (user == null)
{
return null;
}
return new MembershipUser(System.Web.Security.Membership.Provider.Name, userName, user.UserId, user.Email, null, null, true, false, user.CreateDate, DateTime.MinValue,
DateTime.MinValue, DateTime.MinValue, DateTime.MinValue);
}
}
public override bool ConfirmAccount(string accountConfirmationToken)
{
if (string.IsNullOrEmpty(accountConfirmationToken))
{
throw CreateArgumentNullOrEmptyException("accountConfirmationToken");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic row = context.Users.FirstOrDefault(Usr => Usr.ConfirmationToken == accountConfirmationToken);
if (row != null)
{
row.IsConfirmed = true;
context.SaveChanges();
return true;
}
return false;
}
}
public override bool IsConfirmed(string userName)
{
if (string.IsNullOrEmpty(userName))
{
throw CreateArgumentNullOrEmptyException("userName");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic user = context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (user == null)
{
return false;
}
if (user.IsConfirmed)
{
return true;
}
else
{
return false;
}
}
}
public override string CreateAccount(string userName, string password, string email, bool requireConfirmationToken)
{
if (string.IsNullOrEmpty(password))
{
throw new MembershipCreateUserException(MembershipCreateStatus.InvalidPassword);
}
string hashedPassword = CodeFirstCrypto.HashPassword(password);
if (hashedPassword.Length > 128)
{
throw new MembershipCreateUserException(MembershipCreateStatus.InvalidPassword);
}
if (string.IsNullOrEmpty(userName))
{
throw new MembershipCreateUserException(MembershipCreateStatus.InvalidUserName);
}
if (string.IsNullOrEmpty(email))
{
throw new MembershipCreateUserException(MembershipCreateStatus.InvalidEmail);
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic user = context.Users.FirstOrDefault(Usr => Usr.Username == userName);
dynamic emailuser = context.Users.FirstOrDefault(Usr => Usr.Email == email);
if (user != null)
{
throw new MembershipCreateUserException(MembershipCreateStatus.DuplicateUserName);
}
if (emailuser != null)
{
throw new MembershipCreateUserException(MembershipCreateStatus.DuplicateEmail);
}
string token = null;
if (requireConfirmationToken)
{
token = CodeFirstCrypto.GenerateToken();
}
int defaultNumPasswordFailures = 0;
User NewUser = new User
{
UserId = Guid.NewGuid(),
Username = userName,
Password = hashedPassword,
IsConfirmed = !requireConfirmationToken,
Email = email,
ConfirmationToken = token,
CreateDate = DateTime.UtcNow,
PasswordChangedDate = DateTime.UtcNow,
PasswordFailuresSinceLastSuccess = defaultNumPasswordFailures,
LastPasswordFailureDate = DateTime.UtcNow
};
context.Users.Add(NewUser);
context.SaveChanges();
return token;
}
}
public override bool ChangePassword(string userName, string oldPassword, string newPassword)
{
if (string.IsNullOrEmpty(userName))
{
throw CreateArgumentNullOrEmptyException("userName");
}
if (string.IsNullOrEmpty(oldPassword))
{
throw CreateArgumentNullOrEmptyException("oldPassword");
}
if (string.IsNullOrEmpty(newPassword))
{
throw CreateArgumentNullOrEmptyException("newPassword");
}
using (ShoelaceContext context = new ShoelaceContext())
{
dynamic user = context.Users.FirstOrDefault(Usr => Usr.Username == userName);
if (user == null)
{
return false;
}
dynamic hashedPassword = user.Password;
bool verificationSucceeded = (hashedPassword != null && CodeFirstCrypto.VerifyHashedPassword(hashedPassword, oldPassword));
if (verificationSucceeded)
{
user.PasswordFailuresSinceLastSuccess = 0;
}
else
{
int failures = user.PasswordFailuresSinceLastSuccess;
if (failures != -1)
{
user.PasswordFailuresSinceLastSuccess += 1;
user.LastPasswordFailureDate = DateTime.UtcNow;
}
context.SaveChanges();
return false;
}
dynamic newhashedPassword = CodeFirstCrypto.HashPassword(newPassword);
if (newhashedPassword.Length > 128)
{
throw new ArgumentException("Password too long");
}
user.Password = newhashedPassword;
user.PasswordChangedDate = DateTime.UtcNow;
context.SaveChanges();
return true;
}
}
public override string[] FindUsersInRole(string roleName, string usernameToMatch)
{
if (string.IsNullOrEmpty(roleName)) {
throw CreateArgumentNullOrEmptyException("roleName");
}
if (string.IsNullOrEmpty(usernameToMatch)) {
throw CreateArgumentNullOrEmptyException("usernameToMatch");
}
using (ShoelaceContext context = new ShoelaceContext()) {
var query = from Rl in context.Roles from Usr in Rl.Users where Rl.RoleName == roleName && Usr.Username.Contains(usernameToMatch) select Usr.Username;
return query.ToArray();
}
}