public void getClient(ObservableCollection <ViewModel.ClientBinder> Actifclient, ObservableCollection <ViewModel.ClientBinder> Actifadmin, string pseudo, string password)
{
//Model.ClientBinder recupclient = new ClientBinder(-1,"","","","","");
ConnectionBdd bdd = new ConnectionBdd();
MySqlConnection connection = bdd.getConnection();
MySqlCommand cmd = connection.CreateCommand();
// Requête SQL
cmd.CommandText = "SELECT * from client where pseudo=@pseudo AND password=@password";
cmd.Parameters.AddWithValue("@pseudo", pseudo);
cmd.Parameters.AddWithValue("@password", password);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
//redirection user exist
int Id = reader.GetInt32(0);
string NomProperty = reader.GetString(1);
string PrenomProperty = reader.GetString(2);
string PseudoProperty = reader.GetString(3);
string MailProperty = reader.GetString(4);
string PasswordProperty = reader.GetString(5);
int AdminProperty = reader.GetInt32(6);
if (AdminProperty == 1)
{
ViewModel.ClientBinder recupclient = new ViewModel.ClientBinder(Id, NomProperty, PrenomProperty, PseudoProperty, MailProperty, PasswordProperty, AdminProperty);
Actifadmin.Add(recupclient);
}
else
{
ViewModel.ClientBinder recupclient = new ViewModel.ClientBinder(Id, NomProperty, PrenomProperty, PseudoProperty, MailProperty, PasswordProperty, AdminProperty);
Actifclient.Add(recupclient);
}
}
}
reader.Close();
connection.Close();
// return listeavions;
}
public void UpdateClient(ViewModel.ClientBinder c)
{
ConnectionBdd bdd = new ConnectionBdd();
MySqlConnection connection = bdd.getConnection();
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "UPDATE client SET `nom`=@nom,`prenom`=@prenom,`password`=@password WHERE id=@id";
cmd.Parameters.AddWithValue("@nom", c.NomProperty);
cmd.Parameters.AddWithValue("@prenom", c.PrenomProperty);
cmd.Parameters.AddWithValue("@password", c.PasswordProperty);
cmd.Parameters.AddWithValue("@id", c.IdProperty);
cmd.ExecuteNonQuery();
connection.Close();
}
public void SelectClient(ObservableCollection <ViewModel.ClientBinder> listeclients)
{
try
{
ConnectionBdd bdd = new ConnectionBdd();
MySqlConnection connection = bdd.getConnection();
// Requête SQL
string query = "SELECT * from client";
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int Id = reader.GetInt32(0);
string NomProperty = reader.GetString(1);
string PrenomProperty = reader.GetString(2);
string PseudoProperty = reader.GetString(3);
string MailProperty = reader.GetString(4);
string PasswordProperty = reader.GetString(5);
int AdminProperty = reader.GetInt32(6);
ViewModel.ClientBinder unclient = new ViewModel.ClientBinder(Id, NomProperty, PrenomProperty, PseudoProperty, MailProperty, PasswordProperty, AdminProperty);
listeclients.Add(unclient);
}
//Fermeture de la connexion
reader.Close();
connection.Close();
}
catch
{
// Gestion des erreurs :
// Possibilité de créer un Logger pour les exceptions SQL reçus
// Possibilité de créer une méthode avec un booléan en retour pour savoir si le contact à été ajouté correctement.
}
// return listeavions;
}
public void AddClient(ObservableCollection <ViewModel.ClientBinder> UserExist, string nom, string prenom, string pseudo, string mail, string password)
{
try
{
ConnectionBdd bdd = new ConnectionBdd();
MySqlConnection connection = bdd.getConnection();
// Ouverture de la connexion SQL
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * from client where pseudo=@pseudo or mail=@mail";
cmd.Parameters.AddWithValue("@pseudo", pseudo);
cmd.Parameters.AddWithValue("@mail", mail);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
//redirection user exist
int Id = reader.GetInt32(0);
string NomProperty = reader.GetString(1);
string PrenomProperty = reader.GetString(2);
string PseudoProperty = reader.GetString(3);
string MailProperty = reader.GetString(4);
string PasswordProperty = reader.GetString(5);
int AdminProperty = reader.GetInt32(6);
ViewModel.ClientBinder recupclient = new ViewModel.ClientBinder(Id, NomProperty, PrenomProperty, PseudoProperty, MailProperty, PasswordProperty, AdminProperty);
UserExist.Add(recupclient);
}
}
else
{
connection.Close();
ConnectionBdd bdd2 = new ConnectionBdd();
MySqlConnection connection2 = bdd2.getConnection();
MySqlCommand insert = connection2.CreateCommand();
insert.CommandText = "INSERT INTO client (nom,prenom,mail,pseudo,password) VALUES (@nom,@prenom,@mail,@pseudo,@password)";
insert.Parameters.AddWithValue("@nom", nom);
insert.Parameters.AddWithValue("@prenom", prenom);
insert.Parameters.AddWithValue("@mail", mail);
insert.Parameters.AddWithValue("@pseudo", pseudo);
insert.Parameters.AddWithValue("@password", password);
// Exécution de la commande SQL
insert.ExecuteNonQuery();
// Fermeture de la connexion
connection2.Close();
}
// Création d'une commande SQL en fonction de l'objet connexion
connection.Close();
}
catch (MySqlException ex)
{
switch (ex.Number)
{
case 0:
MessageBox.Show("Impossible de se connecter au serveur");
break;
case 1045:
MessageBox.Show("Utilisateur ou mot de passe invalide");
break;
}
// Gestion des erreurs :
// Possibilité de créer un Logger pour les exceptions SQL reçus
// Possibilité de créer une méthode avec un booléan en retour pour savoir si le contact à été ajouté correctement.
}
}
