//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); } }