private void PersistNewUser(UserTable user)
{
UserPersistant newUser = new UserPersistant(null, DatabaseOptionConfigRetriever.DatabaseOptionAppSetting);
newUser.AddToPending(user);
newUser.SaveChange();
}
//[TestMethod]
public void CreateUserMysql()
{
Random randomNumber = new Random();
string firstName = "UnitTestOne" + randomNumber.Next(1000000);
string secondName = "UnitTestMYSQL" + randomNumber.Next(1000000);
UserTable user = new UserTable()
{
FirstName = firstName,
Surname = secondName,
Dob = DateTime.Now,
Gender = UserDataConstants.Male,
UserName = firstName + "_" + secondName,
Password = "******" + firstName + "_" + secondName
};
AdvancedUser advancedUser = new AdvancedUser()
{
FirstName = "advance " + firstName,
Surname = "advance " + secondName,
Dob = DateTime.Now,
Gender = UserDataConstants.Male,
UserName = "******" + firstName + "_" + secondName,
Password = "******" + firstName + "_" + secondName,
AdvanceStartDatetime = DateTime.Now,
AdvanceEndDatetime = DateTime.Now.AddDays(50)
};
UserPersistant createUser = new UserPersistant(null, DbContextConstant.MySqlDbContext);
createUser.AddToPending(user);
createUser.AddToPending(advancedUser);
createUser.SaveChange();
}
//[TestMethod]
public void MigrateUserFromMssqlUserToMysqlUser()
{
RetrieveUserClass retrieveUser = new RetrieveUserClass(DbContextConstant.MsSqlDbContext);
IList <UserTable> allCurrentMsUsers = retrieveUser.GetAllEntities().Take(10).ToList();
Console.WriteLine("msuser count: " + allCurrentMsUsers.Count);
UserPersistant userPersistant = new UserPersistant(allCurrentMsUsers, DbContextConstant.MySqlDbContext);
userPersistant.SaveChange();
}
