public MainWindow()
{
InitializeComponent();
ClientStatic.ClientStatic1();
Panier.PanierVide();
mot_de_passe.mot_de_passe_changement("4F10e6bff@");
}
private void conexion(object sender, RoutedEventArgs e)
{
MySqlConnection maConnexion = null;
try
{
string connexionString = "SERVER=localhost;PORT=3306;DATABASE=tableprojet;UID=root;PASSWORD="******";convert zero datetime=True";
maConnexion = new MySqlConnection(connexionString);
maConnexion.Open();
}
catch (MySqlException er)
{
Console.WriteLine(" ErreurConnexion : " + er.ToString());
return;
}
if (mail.Text.Trim() != "" && mdp.Text.Trim() != "")
{
string p = mail.Text;
string requete = "SELECT * FROM client WHERE client.adresseEmail='" + p + "';";
MySqlCommand command_all = maConnexion.CreateCommand();
command_all.CommandText = requete;
MySqlDataReader reader = command_all.ExecuteReader(); //reader a les valeurs retourner par la requette
reader.Read();
if (mdp.Text == reader["motDePasse"].ToString()) //Verification avec le mdp
{
ClientStatic.idClient = int.Parse(reader["idClient"].ToString());
ClientStatic.nom = reader["nom"].ToString();
ClientStatic.prenom = reader["prenom"].ToString();
ClientStatic.adresse = reader["adresse"].ToString();
ClientStatic.ville = reader["ville"].ToString();
DateTime date = (DateTime)reader["date_naissance"];
ClientStatic.d_naissance = date;
ClientStatic.tel = int.Parse(reader["numeroDeTelephone"].ToString());
ClientStatic.mail = reader["adresseEmail"].ToString();
ClientStatic.estCreateur = int.Parse(reader["estCreateur"].ToString());
ClientStatic.capitalCooks = int.Parse(reader["capitalCooks"].ToString());
ClientStatic.mdp = reader["motDePasse"].ToString();
string affichage_client = ClientStatic.affichage();
command_all.Dispose();
reader.Close();
if (ClientStatic.estCreateur == 1)
{
ClientStatic.idCreateur = recupt_idcreateur();
Acceuil page = new Acceuil();
page.Show();
this.Close();
}
else
{
Acceuil_commande page = new Acceuil_commande();
page.Show();
this.Close();
}
}
else
{
erreur_connexion a = new erreur_connexion();
a.Show();
}
}
else
{
erreur_connexion a = new erreur_connexion();
a.Show();
}
}
