public string registrationRecupIdAccount(RequestFrontInscription request)
{
return(String.Format("SELECT MAX({0}) as MAX_ID FROM {1} WHERE {2} = '{3}'",
NAME_FIELD_ACCOUNT_ID,
NAME_TABLE_ACCOUNT,
NAME_FIELD_ACCOUNT_EMAIL,
request.registerAccount.registerEmail));
}
public string registrationAddAccount(RequestFrontInscription request)
{
return(String.Format("INSERT INTO {0} ({1}, {2}) VALUES ('{3}', '{4}')",
NAME_TABLE_ACCOUNT,
NAME_FIELD_ACCOUNT_EMAIL,
NAME_FIELD_ACCOUNT_PASSWORD,
request.registerAccount.registerEmail,
request.registerAccount.registerPassword));
}
public string registrationAddUser(int idAccount, RequestFrontInscription request)
{
return(String.Format("INSERT INTO {0} ({1}, {2}, {3}) VALUES ({4}, '{5}', {6})",
NAME_TABLE_UTILISATEUR,
NAME_FIELD_UTILISATEUR_ID_ACCOUNT,
NAME_FIELD_UTILISATEUR_PSEUDO,
NAME_FIELD_UTILISATEUR_AVATAR,
idAccount,
request.registerUser.registerNickname,
0));
}
public bool Registration(RequestFrontInscription request)
{
stopwatch.Start();
try
{
string queryAddAccount = nameBdd.registrationAddAccount(request);
string quertRecupIdAccount = nameBdd.registrationRecupIdAccount(request);
int id = 0;
bool isRegistered = false;
if (this.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(queryAddAccount, connection);
cmd.ExecuteNonQuery();
MySqlCommand recupId = new MySqlCommand(quertRecupIdAccount, connection);
recupId.ExecuteNonQuery();
MySqlDataReader dataReader = recupId.ExecuteReader();
while (dataReader.Read())
{
id = int.Parse(dataReader["MAX_ID"].ToString());
}
dataReader.Close();
string queryAddUtilisateur = nameBdd.registrationAddUser(id, request);
MySqlCommand cmd2 = new MySqlCommand(queryAddUtilisateur, connection);
cmd2.ExecuteNonQuery();
this.CloseConnection();
stopwatch.Stop();
log.Info("api.INSCRIPTION.Registration ... (" + stopwatch.Elapsed.TotalSeconds + " ms)");
return(isRegistered = true);
}
else
{
return(isRegistered);
}
}
catch (Exception ex)
{
log.Error(ex);
return(false);
}
}
