//ACCOUNT EXIST
public int Connection(RequestFrontConnexion request)
{
try
{
string queryConnexion = nameBdd.connection(request);
int Count = 0;
if (this.OpenConnection() == true)
{
//Create Mysql Command
MySqlCommand cmd = new MySqlCommand(queryConnexion, connection);
//ExecuteScalar will return one value
Count = int.Parse(cmd.ExecuteScalar().ToString());
//close Connection
this.CloseConnection();
return(Count);
}
else
{
return(Count);
}
}catch (Exception ex)
{
log.Error(ex);
return(0);
}
}
public string connection(RequestFrontConnexion request)
{
return(String.Format("SELECT COUNT(*) FROM {0} WHERE {1} = '{2}' AND {3} = '{4}'",
NAME_TABLE_ACCOUNT,
NAME_FIELD_ACCOUNT_EMAIL,
request.email,
NAME_FIELD_ACCOUNT_PASSWORD,
request.password));
}
public string retrieveUserIdConnection(RequestFrontConnexion request)
{
return(String.Format("SELECT {0} FROM {1} WHERE {2} = '{3}' AND {4} = '{5}'",
NAME_FIELD_ACCOUNT_ID,
NAME_TABLE_ACCOUNT,
NAME_FIELD_ACCOUNT_EMAIL,
request.email,
NAME_FIELD_ACCOUNT_PASSWORD,
request.password));
}
//RECUP ID ACCOUNT
public int RetrieveIdAccount(RequestFrontConnexion request)
{
stopwatch.Start();
try
{
string queryRecupID = nameBdd.retrieveUserIdConnection(request);
int id = 0;
if (this.OpenConnection() == true)
{
MySqlCommand cmd2 = new MySqlCommand(queryRecupID, connection);
MySqlDataReader dataReader = cmd2.ExecuteReader();
while (dataReader.Read())
{
id = nameBdd.retrieveFieldAccountIdConnection(dataReader);
}
dataReader.Close();
this.CloseConnection();
stopwatch.Stop();
log.Info("api.CONNECTION.RetrieveIdAccount ... (" + stopwatch.Elapsed.TotalSeconds + " ms)");
return(id);
}
else
{
return(0);
}
}
catch (Exception ex)
{
log.Error(ex);
return(0);
}
}
