public static void SyncUsers()
{
var r3musDB = new r3musDbContext();
var r3musForum = new r3mus_ForumDBEntities();
try
{
var siteUsers = r3musDB.Users.ToList();
var forumUsers = r3musForum.MembershipUsers.ToList();
var forumRole = r3musForum.MembershipRoles.Where(role => role.RoleName == "Standard Members").FirstOrDefault();
siteUsers.ForEach(siteUser =>
{
var forumUser = forumUsers.Where(user => user.UserName == siteUser.UserName).FirstOrDefault();
if (forumUser == null)
{
forumUser = new MembershipUser()
{
Id = new Guid(siteUser.Id),
UserName = siteUser.UserName,
Password = string.Concat("R3MUSUser_", siteUser.UserName.Substring(0, siteUser.UserName.IndexOf(" "))),
Email = siteUser.EmailAddress,
PasswordSalt = string.Concat("R3MUS_", siteUser.UserName.Substring(0, siteUser.UserName.IndexOf(" "))),
IsApproved = true,
IsLockedOut = false,
CreateDate = DateTime.Now,
LastLoginDate = DateTime.Now,
LastPasswordChangedDate = DateTime.Now,
LastLockoutDate = DateTime.Now,
FailedPasswordAttemptCount = 3,
FailedPasswordAnswerAttempt = 3,
Slug = string.Empty,
DisableEmailNotifications = true,
IsExternalAccount = true
};
forumUser.Password = GenerateSaltedHash(forumUser.Password, forumUser.PasswordSalt);
r3musForum.MembershipUsers.Add(forumUser);
var role = new MembershipUsersInRole()
{
Id = Guid.NewGuid(),
UserIdentifier = forumUser.Id,
RoleIdentifier = forumRole.Id,
MembershipUser = forumUser,
MembershipRole = forumRole
};
r3musForum.MembershipUsersInRoles.Add(role);
}
}
);
r3musForum.SaveChanges();
}
catch (DbEntityValidationException ex)
{
Console.WriteLine(ex.Message);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public static void SyncUsers()
{
var r3musDB = new r3musDbContext();
var r3musForum = new r3mus_ForumDBEntities();
try
{
var siteUsers = r3musDB.Users.ToList();
var forumUsers = r3musForum.MembershipUsers.ToList();
var forumRole = r3musForum.MembershipRoles.Where(role => role.RoleName == "Standard Members").FirstOrDefault();
siteUsers.ForEach(siteUser =>
{
var forumUser = forumUsers.Where(user => user.UserName == siteUser.UserName).FirstOrDefault();
if (forumUser == null)
{
forumUser = new MembershipUser()
{
Id = new Guid(siteUser.Id),
UserName = siteUser.UserName,
Password = string.Concat("R3MUSUser_", siteUser.UserName.Substring(0, siteUser.UserName.IndexOf(" "))),
Email = siteUser.EmailAddress,
PasswordSalt = string.Concat("R3MUS_", siteUser.UserName.Substring(0, siteUser.UserName.IndexOf(" "))),
IsApproved = true,
IsLockedOut = false,
CreateDate = DateTime.Now,
LastLoginDate = DateTime.Now,
LastPasswordChangedDate = DateTime.Now,
LastLockoutDate = DateTime.Now,
FailedPasswordAttemptCount = 3,
FailedPasswordAnswerAttempt = 3,
Slug = string.Empty,
DisableEmailNotifications = true,
IsExternalAccount = true
};
forumUser.Password = GenerateSaltedHash(forumUser.Password, forumUser.PasswordSalt);
r3musForum.MembershipUsers.Add(forumUser);
var role = new MembershipUsersInRole()
{
Id = Guid.NewGuid(),
UserIdentifier = forumUser.Id,
RoleIdentifier = forumRole.Id,
MembershipUser = forumUser,
MembershipRole = forumRole
};
r3musForum.MembershipUsersInRoles.Add(role);
}
}
);
r3musForum.SaveChanges();
}
catch (DbEntityValidationException ex)
{
Console.WriteLine(ex.Message);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
