/* 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; }
private void Annuler_Click(object sender, RoutedEventArgs e) { methodes m = new methodes(); SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\bdd.mdf;Integrated Security=True"); con.Open(); SqlCommand cmd = new SqlCommand("Select * From Utilisateurs Where Id_utilisateur ='" + user.getid_utilis() + "'", con); SqlDataReader myReader = cmd.ExecuteReader(); if (myReader.Read()) { user.setnom(myReader["Nom"].ToString()); user.setprenom(myReader["Prenom"].ToString()); user.setpseudo(myReader["Pseudo"].ToString()); user.setmotdepasse(myReader["Mpasse"].ToString()); } con.Close(); Nom2.Text = user.getnom(); Prenom2.Text = user.getprenom(); Pseudo2.Text = user.getpseudo(); }