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);
}
