private void Enrigstrer_Click(object sender, RoutedEventArgs e)
{
methodes m = new WpfApplication12.methodes();
string motdepass = this.user.getmotdepasse();
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\bdd.mdf;Integrated Security=True");
con.Open();
SqlDataReader adapter;
SqlCommand cmd = new SqlCommand("Select * From Utilisateurs Where Pseudo='" + Pseudo2.Text + "'", con);
adapter = cmd.ExecuteReader();
if (adapter.Read() && (int)(adapter["id_utilisateur"]) != user.getid_utilis())
{
pseu_ext.Visibility = System.Windows.Visibility.Visible;
}
else
{
if ((Password.Password != "") && (Password2.Password != ""))
{
if (Password.Password == user.getmotdepasse())
{
MessageBoxResult reslt = MessageBox.Show("Voulez-vous vraiment modifier vos informations", "Confirmation", MessageBoxButton.YesNo);
if (reslt == MessageBoxResult.Yes)
{
motdepass = Password2.Password;
user.Modifer_utilisateur(this.user, Nom2.Text, Prenom2.Text, motdepass, Pseudo2.Text);
user.modifier_utilis(user, this.user.getid_utilis());
con.Close();
}
}
else
{
incorect.Visibility = Visibility.Visible;
}
}
else
{
MessageBoxResult reslt = MessageBox.Show("Voulez-vous vraiment modifier vos informations", "Confirmation", MessageBoxButton.YesNo);
if (reslt == MessageBoxResult.Yes)
{
user.Modifer_utilisateur(this.user, Nom2.Text, Prenom2.Text, motdepass, Pseudo2.Text);
user.modifier_utilis(user, this.user.getid_utilis());
con.Close();
}
}
}
}
/* public void Modifier_pseudo(utilisateur_class user, string pseudo)
* {
* user.setpseudo(pseudo);
* }
* public void Modifier_motdepasse(utilisateur_class user, string mot_de_passe)
* {
* user.setmotdepasse(mot_de_passe);
* }*/
public void modifier_utilis(utilisateur user, int id_utilis)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\bdd.mdf;Integrated Security=True");
String query = "update Utilisateurs set Nom=@nom,Prenom=@prenom,Pseudo=@pseudo,Mpasse=@motdepasse WHERE Id_utilisateur=@id";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.Parameters.AddWithValue("@id", id_utilis.ToString());
cmd.Parameters.AddWithValue("@nom", user.getnom());
cmd.Parameters.AddWithValue("@prenom", user.getprenom());
cmd.Parameters.AddWithValue("@pseudo", user.getpseudo());
cmd.Parameters.AddWithValue("@motdepasse", user.getmotdepasse());
cmd.ExecuteNonQuery();
con.Close();
}
public User_Affichage(utilisateur use)
{
this.user = use;
InitializeComponent();
Nom2.Text = user.getnom();
Prenom2.Text = user.getprenom();
Pseudo2.Text = user.getpseudo();
motpass = user.getmotdepasse();
Enrigstrer.Visibility = Visibility.Collapsed;
Annuler.Visibility = Visibility.Collapsed;
Nouveau_mot_de_passe.Visibility = System.Windows.Visibility.Collapsed;
Ancien_mot_de_passe.Visibility = System.Windows.Visibility.Collapsed;
Password.Visibility = System.Windows.Visibility.Collapsed;
Password2.Visibility = System.Windows.Visibility.Collapsed;
}
