private void AlimenterListeClient() { lstClient = new ObservableCollection <OVClient>(); string loadClient = "SELECT Identifiant, NomEntreprise, NomResponsable, PrenomResponsable, CiviliteResponsable, RueEntreprise, CpEntreprise, VilleEntreprise, MailEntreprise, FaxEntreprise, TelephoneEntreprise FROM client"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = loadClient; MySqlDataAdapter ad = new MySqlDataAdapter(); ad.SelectCommand = cmd; cmd.Connection = connect.con; DataSet ds = new DataSet(); ad.Fill(ds); foreach (DataRowView rowView in ds.Tables[0].DefaultView) { OVClient ovClient = new OVClient(); ovClient.Identifiant = int.Parse(rowView["Identifiant"].ToString()); ovClient.NomEntreprise = rowView["NomEntreprise"].ToString(); ovClient.NomResponsable = rowView["NomResponsable"].ToString(); ovClient.PrenomResponsable = rowView["PrenomResponsable"].ToString(); ovClient.CiviliteResponsable = rowView["CiviliteResponsable"].ToString(); ovClient.RueEntreprise = rowView["RueEntreprise"].ToString(); ovClient.CpEntreprise = int.Parse(rowView["CpEntreprise"].ToString()); ovClient.VilleEntreprise = rowView["VilleEntreprise"].ToString(); ovClient.MailEntreprise = rowView["MailEntreprise"].ToString(); ovClient.FaxEntreprise = rowView["FaxEntreprise"].ToString(); ovClient.TelephoneEntreprise = rowView["TelephoneEntreprise"].ToString(); lstClient.Add(ovClient); } }
private void listBoxClient_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { OVClient ovClient = new OVClient(); ovClient = (OVClient)listBoxClient.SelectedItem; string IDclientChanged = ovClient.Identifiant.ToString(); string connectionString = "SERVER=localhost" + ";" + "DATABASE=megacastingv2" + ";" + "UID=root" + ";" + "PASSWORD="******";"; string Query = @"SELECT * FROM client WHERE Identifiant = '" + IDclientChanged + "';"; MySqlConnection MyConn = new MySqlConnection(connectionString); MySqlCommand MyCommand = new MySqlCommand(Query, MyConn); MySqlDataReader MyReader; MyConn.Open(); MyReader = MyCommand.ExecuteReader(); //Remplir TextBox selon client selectionné tbNomEts.Text = ovClient.NomEntreprise; tbNomResp.Text = ovClient.NomResponsable; tbPrenomResp.Text = ovClient.PrenomResponsable; cbCivResp.Text = ovClient.CiviliteResponsable; tbRueEnt.Text = ovClient.RueEntreprise; tbCpEnt.Text = ovClient.CpEntreprise.ToString(); tbVilleEnt.Text = ovClient.VilleEntreprise; tbMailEnt.Text = ovClient.MailEntreprise; tbTelephoneEnt.Text = ovClient.TelephoneEntreprise; tbFaxEnt.Text = ovClient.FaxEntreprise; } catch (Exception ex) { Console.WriteLine(ex.Message); } }
private void btnDeleteClient_Click(object sender, RoutedEventArgs e) { if (listBoxClient.SelectedItems != null) { OVClient ovClient = new OVClient(); ovClient = (OVClient)listBoxClient.SelectedItem; string IdClientDelete = ovClient.Identifiant.ToString(); string connectionString = "SERVER=localhost" + ";" + "DATABASE=megacastingv2" + ";" + "UID=root" + ";" + "PASSWORD="******";"; string Query = @"DELETE FROM client WHERE Identifiant ='" + IdClientDelete + "';"; MySqlConnection MyConn = new MySqlConnection(connectionString); MySqlCommand MyCommand = new MySqlCommand(Query, MyConn); MySqlDataReader MyReader; MyConn.Open(); MyReader = MyCommand.ExecuteReader(); //Rafraichir listBoxClient ListClients.Remove(ovClient); MessageBox.Show("Client Supprimé !"); } else { MessageBox.Show("Sélectionner un élément"); } }
private void btnUpdateClient_Click(object sender, RoutedEventArgs e) { if (listBoxClient.SelectedItems.Count > 0) { if ((MessageBox.Show("Êtes-vous sûr de vouloir modifier le client?", "Warning ! Modification d'un client", MessageBoxButton.YesNo, MessageBoxImage.Exclamation) == MessageBoxResult.Yes)) { OVClient ovClient = (OVClient)listBoxClient.SelectedItem; string IdClientUpdate = ovClient.Identifiant.ToString(); string NomEts = ovClient.NomEntreprise; string NomResp = ovClient.NomResponsable; string PrenomResp = ovClient.NomResponsable; string CiviliteResp = ovClient.NomResponsable; string RueEts = ovClient.NomResponsable; string CpEts = ovClient.NomResponsable; string VilleEts = ovClient.NomResponsable; string MailEts = ovClient.NomResponsable; string FaxEts = ovClient.NomResponsable; string TelephoneEts = ovClient.NomResponsable; string connectionString = "SERVER=localhost" + ";" + "DATABASE=megacastingv2" + ";" + "UID=root" + ";" + "PASSWORD="******";"; string Query = @"UPDATE client SET NomEntreprise = '" + tbNomEts.Text + "', NomResponsable = '" + tbNomResp.Text + "', PrenomResponsable = '" + tbPrenomResp.Text + "', CiviliteResponsable = '" + cbCivResp.Text + "', RueEntreprise = '" + tbRueEnt.Text + "', CpEntreprise = '" + tbCpEnt.Text + "', VilleEntreprise = '" + tbVilleEnt.Text + "', MailEntreprise = '" + tbMailEnt.Text + "', FaxEntreprise = '" + tbFaxEnt.Text + "', TelephoneEntreprise = '" + tbTelephoneEnt.Text + "' WHERE Identifiant ='" + IdClientUpdate + "';"; MySqlConnection MyConn = new MySqlConnection(connectionString); MySqlCommand MyCommand = new MySqlCommand(Query, MyConn); MySqlDataReader MyReader; MyConn.Open(); MyReader = MyCommand.ExecuteReader(); //Vider donnnées apres insertion tbNomEts.Text = string.Empty; tbNomResp.Text = string.Empty; tbPrenomResp.Text = string.Empty; cbCivResp.Text = string.Empty; tbRueEnt.Text = string.Empty; tbCpEnt.Text = string.Empty; tbVilleEnt.Text = string.Empty; tbMailEnt.Text = string.Empty; tbTelephoneEnt.Text = string.Empty; tbFaxEnt.Text = string.Empty; //Rafraichir listBoxClient } } else { MessageBox.Show("Sélectionner un élément"); } }
//CHAMP ONGLET CLIENT private void btnAddClient_Click(object sender, RoutedEventArgs e) { if ((MessageBox.Show("Êtes-vous sûr de vouloir créer un nouveau client?", "Warning ! Ajout d'un nouveau client", MessageBoxButton.YesNo, MessageBoxImage.Exclamation) == MessageBoxResult.Yes)) { MainWindow dialog = new MainWindow(); try { OVClient ovClient = new OVClient(); ovClient.NomEntreprise = this.tbNomEts.Text; ovClient.NomResponsable = this.tbNomResp.Text; ovClient.PrenomResponsable = this.tbPrenomResp.Text; ovClient.CiviliteResponsable = this.cbCivResp.Text; ovClient.RueEntreprise = this.tbRueEnt.Text; ovClient.CpEntreprise = int.Parse(this.tbCpEnt.Text); ovClient.VilleEntreprise = tbVilleEnt.Text; ovClient.MailEntreprise = this.tbMailEnt.Text; ovClient.FaxEntreprise = this.tbFaxEnt.Text; ovClient.TelephoneEntreprise = this.tbTelephoneEnt.Text; string connectionString = "SERVER=localhost" + ";" + "DATABASE=megacastingv2" + ";" + "UID=root" + ";" + "PASSWORD="******";"; string Query = @"INSERT INTO client (NomEntreprise, NomResponsable, PrenomResponsable, CiviliteResponsable, RueEntreprise, CpEntreprise, VilleEntreprise, MailEntreprise, FaxEntreprise, TelephoneEntreprise) values('" + ovClient.NomEntreprise + "','" + ovClient.NomResponsable + "','" + ovClient.PrenomResponsable + "','" + ovClient.CiviliteResponsable + "','" + ovClient.RueEntreprise + "','" + ovClient.CpEntreprise + "','" + ovClient.VilleEntreprise + "','" + ovClient.MailEntreprise + "','" + ovClient.FaxEntreprise + "','" + ovClient.TelephoneEntreprise + "');"; MySqlConnection MyConn = new MySqlConnection(connectionString); MySqlCommand MyCommand = new MySqlCommand(Query, MyConn); MySqlDataReader MyReader; MyConn.Open(); MyReader = MyCommand.ExecuteReader(); //Vider donnnées apres insertion tbNomEts.Text = string.Empty; tbNomResp.Text = string.Empty; tbPrenomResp.Text = string.Empty; cbCivResp.Text = string.Empty; tbRueEnt.Text = string.Empty; tbCpEnt.Text = string.Empty; tbVilleEnt.Text = string.Empty; tbMailEnt.Text = string.Empty; tbTelephoneEnt.Text = string.Empty; tbFaxEnt.Text = string.Empty; //Rafraichir listBoxClient ListClients.Add(ovClient); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } } }