public override MembershipUser GetUser(string username, bool userIsOnline) { if (string.IsNullOrEmpty(username)) { return(null); } using (PMToolContext Context = new PMToolContext()) { UserProfile User = null; User = Context.UserProfiles.FirstOrDefault(Usr => Usr.UserName == username); if (User != null) { if (userIsOnline) { //User.LastActivityDate = DateTime.UtcNow; Context.SaveChanges(); } 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 ValidateUser(string username, string password) { if (string.IsNullOrEmpty(username)) { return(false); } if (string.IsNullOrEmpty(password)) { return(false); } using (PMToolContext Context = new PMToolContext()) { UserProfile User = null; User = Context.UserProfiles.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 (PMToolContext Context = new PMToolContext()) { 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 MembershipUser GetUser(object providerUserKey, bool userIsOnline) { if (providerUserKey is Guid) { } else { return(null); } using (PMToolContext Context = new PMToolContext()) { UserProfile User = null; User = Context.UserProfiles.Find(providerUserKey); if (User != null) { if (userIsOnline) { User.LastActivityDate = DateTime.UtcNow; Context.SaveChanges(); } 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 string[] GetAllRoles() { using (PMToolContext Context = new PMToolContext()) { return(Context.Roles.Select(Rl => Rl.RoleName).ToArray()); } }
public override bool IsUserInRole(string username, string roleName) { if (string.IsNullOrEmpty(username)) { return(false); } if (string.IsNullOrEmpty(roleName)) { return(false); } using (PMToolContext Context = new PMToolContext()) { UserProfile User = null; User = Context.UserProfiles.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 int GetNumberOfUsersOnline() { DateTime DateActive = DateTime.UtcNow.Subtract(TimeSpan.FromMinutes(Convert.ToDouble(Membership.UserIsOnlineTimeWindow))); using (PMToolContext Context = new PMToolContext()) { return(Context.UserProfiles.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 (PMToolContext Context = new PMToolContext()) { UserProfile User = null; User = Context.UserProfiles.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 (PMToolContext Context = new PMToolContext()) { if (Context.UserProfiles.Where(Usr => Usr.UserName == userName).Any()) { throw new MembershipCreateUserException(MembershipCreateStatus.DuplicateUserName); } string token = string.Empty; if (requireConfirmationToken) { token = GenerateToken(); } UserProfile NewUser = new UserProfile { //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 = DateTime.UtcNow, //IsLockedOut = false, //LastPasswordFailureDate = DateTime.UtcNow, //ConfirmationToken = token }; Context.UserProfiles.Add(NewUser); Context.SaveChanges(); return(token); } }
public static void Register() { PMToolContext context = new PMToolContext(); context.Database.Initialize(true); if (!WebMatrix.WebData.WebSecurity.Initialized) { WebMatrix.WebData.WebSecurity.InitializeDatabaseConnection("PMToolContext", "UserProfile", "UserId", "UserName", autoCreateTables: true); } }
public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords) { MembershipUserCollection MembershipUsers = new MembershipUserCollection(); using (PMToolContext Context = new PMToolContext()) { totalRecords = Context.UserProfiles.Count(); IQueryable <UserProfile> Users = Context.UserProfiles.OrderBy(Usrn => Usrn.UserName).Skip(pageIndex * pageSize).Take(pageSize); foreach (UserProfile 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 (PMToolContext Context = new PMToolContext()) { UserProfile User = null; User = Context.UserProfiles.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 (PMToolContext Context = new PMToolContext()) { 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 (PMToolContext Context = new PMToolContext()) { List <UserProfile> Users = Context.UserProfiles.Where(Usr => usernames.Contains(Usr.Username)).ToList(); List <Role> Roles = Context.Roles.Where(Rl => roleNames.Contains(Rl.RoleName)).ToList(); foreach (UserProfile user in Users) { foreach (Role role in Roles) { if (!user.Roles.Contains(role)) { user.Roles.Add(role); } } } Context.SaveChanges(); } }
public override bool UnlockUser(string userName) { using (PMToolContext Context = new PMToolContext()) { UserProfile User = null; User = Context.UserProfiles.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 (PMToolContext Context = new PMToolContext()) { UserProfile User = null; User = Context.UserProfiles.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 (PMToolContext Context = new PMToolContext()) { 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 (PMToolContext Context = new PMToolContext()) { 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 (PMToolContext Context = new PMToolContext()) { 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 override bool DeleteUser(string username, bool deleteAllRelatedData) { if (string.IsNullOrEmpty(username)) { return(false); } using (PMToolContext Context = new PMToolContext()) { UserProfile User = null; User = Context.UserProfiles.FirstOrDefault(Usr => Usr.UserName == username); if (User != null) { Context.UserProfiles.Remove(User); Context.SaveChanges(); return(true); } else { return(false); } } }
public SimpleMembershipInitializer() { // Database.SetInitializer<UsersContext>(null); try { using (var context = new PMToolContext()) { if (!context.Database.Exists()) { // Create the SimpleMembership database without Entity Framework migration schema ((IObjectContextAdapter)context).ObjectContext.CreateDatabase(); } } WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true); } catch (Exception ex) { throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex); } }
public override void RemoveUsersFromRoles(string[] usernames, string[] roleNames) { using (PMToolContext Context = new PMToolContext()) { foreach (String username in usernames) { String us = username; UserProfile user = Context.UserProfiles.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 SprintRepository(PMToolContext context) { this.context = context; }