public static void GetMagasinPersonne(Personne pers) { MySqlCommand requete = new MySqlCommand("select m.codemag,m.nom, m.adresse, m.numcompte,m.soldecompte from magasin m," + "personne p where m.codemag=p.codemag and p.matricule=?mat group by m.codemag"); requete.Parameters.AddWithValue("?mat", pers.Matricule); MySqlDataReader reader = requete.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Magasin m = new Magasin((string)reader[0], (string)reader[1], (string)reader[2], Convert.ToInt64(reader[3]), Convert.ToInt64(reader[4])); pers.Mag = m; } reader.Close(); } }
public static List <Personne> GetListePersonnes() { List <Personne> listePersonnes = new List <Personne>(); MySqlCommand com = new MySqlCommand("select * from personne"); com.Connection = connection; MySqlDataReader dr = com.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { Personne p = new Personne(Convert.ToInt16(dr[0]), (string)dr[2], (string)dr[3], (string)dr[4], (string)dr[6]); listePersonnes.Add(p); } } //listePersonnes.Remove(Proxy.PersonneConnecte); dr.Close(); return(listePersonnes); }
public static void SupprimerPersonne(Personne p) { MySqlCommand requete = new MySqlCommand("select * from personne where nom=?nom and prenom=?prenom"); requete.Connection = connection; requete.Parameters.AddWithValue("?nom", p.Nom); requete.Parameters.AddWithValue("?prenom", p.Prenom); MySqlDataReader dr = requete.ExecuteReader(); if (!dr.HasRows) { dr.Close(); throw new UtilisateurExistantException("La personne que vous souhaitez supprimer n'existe pas"); } else { dr.Close(); MySqlCommand req = new MySqlCommand("delete from personne where matricule=?mat"); req.Connection = connection; req.Parameters.AddWithValue("?mat", p.Matricule); req.ExecuteNonQuery(); } }
private void btValider_Click(object sender, EventArgs e) { Personne p = new Personne((Magasin)cbMag.SelectedItem, (string)cbType.SelectedItem, tbNom.Text, tbPrenom.Text, Convert.ToInt32(tbTel.Text), tbLogin.Text, tbMdp.Text); ConnexionDataSource.CreerPersonne(p); }