public static Models.AccountsModel LoadAccount(int accountID)
{
DatabaseProvider.CheckConnection();
lock (DatabaseProvider.ConnectionLocker)
{
var account = new Models.AccountsModel();
var sqlText = "SELECT * FROM dyn_accounts WHERE id=@id";
var sqlCommand = new MySqlCommand(sqlText, DatabaseProvider.Connection);
sqlCommand.Parameters.Add(new MySqlParameter("@id", accountID));
var sqlReader = sqlCommand.ExecuteReader();
if (sqlReader.Read())
{
account.ID = sqlReader.GetInt16("id");
account.Username = sqlReader.GetString("username");
account.Password = sqlReader.GetString("password");
account.Pseudo = sqlReader.GetString("pseudo");
account.Communauty = sqlReader.GetInt16("communauty");
account.Level = sqlReader.GetInt16("gmLevel");
account.Question = sqlReader.GetString("question");
account.Answer = sqlReader.GetString("answer");
account.SubscriptionDate = sqlReader.GetDateTime("subscription");
}
sqlReader.Close();
return account;
}
}
private Entities.Accounts ModelToEntityMapper(Models.AccountsModel Account)
{
Entities.Accounts AccountEntity = new Entities.Accounts
{
AccountID = Account.AccountID,
Name = Account.Name,
ManagerID = Account.ManagerID
};
return(AccountEntity);
}
public static Models.AccountsModel LoadAccount(string username)
{
Models.AccountsModel account = null;
DatabaseProvider.CheckConnection();
lock (DatabaseProvider.Locker)
{
var sqlText = "SELECT * FROM accounts WHERE username=@username";
var sqlCommand = new MySqlCommand(sqlText, DatabaseProvider.Connection);
sqlCommand.Parameters.Add(new MySqlParameter("@username", username));
var sqlReader = sqlCommand.ExecuteReader();
if (sqlReader.Read())
{
account = new Models.AccountsModel()
{
ID = sqlReader.GetInt16("id"),
Username = sqlReader.GetString("username"),
Password = sqlReader.GetString("password"),
Pseudo = sqlReader.GetString("pseudo"),
Communauty = sqlReader.GetInt16("communauty"),
Level = sqlReader.GetInt16("gmLevel"),
Question = sqlReader.GetString("question"),
Answer = sqlReader.GetString("answer"),
SubscriptionDate = sqlReader.GetDateTime("subscription"),
};
}
sqlReader.Close();
if (account != null)
{
account.Characters = LoadCharacters(account.ID);
account.Friends = LoadFriends(account.ID);
account.Enemies = LoadEnemies(account.ID);
}
}
return account;
}