//[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();
}
private UserTable RetrieveUser(string userName)
{
RetrieveUserClass retrieveUser = new RetrieveUserClass(DatabaseOptionConfigRetriever.DatabaseOptionAppSetting);
var user = retrieveUser.GetEntityMatchingFunc(u => u.UserName == userName);
if (user == null)
{
throw new Exception();
}
return(user);
}
public List <UserTable> GetAllUsers()
{
try
{
RetrieveUserClass retrieveUser = new RetrieveUserClass(DatabaseOptionConfigRetriever.DatabaseOptionAppSetting);
IList <UserTable> user = retrieveUser.GetAllEntities();
return(user.ToList());
}
catch (Exception exception)
{
var error = new EntityErrorContract
{
Message = exception.Message
};
throw new FaultException <EntityErrorContract>(error);
}
}
public List <MessageTransactionInfoContract> GetMessageTransactionsMatchingUsernameAndReceiverEmail(string username, string recieverEmail)
{
try
{
RetrieveUserClass retrieveUser = new RetrieveUserClass(DbContextConstant.MsSqlDbContext);
long senderId = retrieveUser.GetEntityMatchingFunc(u => u.UserName == username).Id;
RetrieveMessageTransactionClass retrieveMessageTransaction = new RetrieveMessageTransactionClass(DbContextConstant.MsSqlDbContext);
return(retrieveMessageTransaction.GetAllEntitiesMatchingCondtionsEagerLoadAssociatedEntitiesFunc(t => t.Message, t => t.Message.SenderId == senderId)
.Select(m => CreateRetrieveMessageContract(username, m.EmailAddress, m.Message.MessageCreated.Value))
.ToList());
}
catch (Exception exception)
{
var error = new EntityErrorContract
{
Message = exception.Message
};
throw new FaultException <EntityErrorContract>(error);
}
}
public bool ExecuteEncryptedLoginIn(string encryptedUser, string encryptedPassword)
{
try
{
string decryptedUsername = encryptedUser;
string decryptedPassword = encryptedPassword;
IDbRetrieveUser <UserTable> retrieveUsers = new RetrieveUserClass(DatabaseOptionConfigRetriever.DatabaseOptionAppSetting);
if (retrieveUsers.EntityExistMatchingUsernameAndPassword(decryptedUsername, decryptedPassword) == true)
{
return(true);
}
}
catch (Exception exception)
{
ThrowErrorMessage <LoginErrorContract>(exception.Message);
}
return(false);
}
private bool UsernameAlreadyExist(string userName)
{
RetrieveUserClass retrieveUser = new RetrieveUserClass(DatabaseOptionConfigRetriever.DatabaseOptionAppSetting);
return(retrieveUser.EntityExistMatchingFunc(u => u.UserName == userName) == true);
}
