/// <summary>
/// Modifie l'évènement
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonUpdate_Click(object sender, EventArgs e)
{
if (condition())
{
if (verifiLicence())
{
Clubs club = new Clubs();
club.setNom(comboBox2.Text);
Adherents adherent = new Adherents();
adherent.setId(Int32.Parse(textID.Text));
adherent.setClub(club);
adherent.setSexe(comboBox1.Text);
adherent.setNom(textNom.Text);
adherent.setPrenom(textPrenom.Text);
adherent.setLicence(textLicence.Text);
adherent.setNaissance(dateTimePicker1.Value);
adherent.setAdresse(textAdresse.Text);
adherent.setCPT(Int32.Parse(textCodePostal.Text));
adherent.setVille(textVille.Text);
adherent.setCotisation(Int32.Parse(textCotisation.Text));
try
{
ModeleBDD bd = new ModeleBDD();
bd.UPDATEAdherent(adherent);
comboBox1.Text = "";
comboBox2.Text = "";
textID.Text = "";
textNom.Text = "";
textPrenom.Text = "";
textLicence.Text = "";
//dateTimePicker1.Value = DateTime.Now;
textAdresse.Text = "";
textCodePostal.Text = "";
textVille.Text = "";
textCotisation.Text = "";
label10.Text = adherent.getNom() + " a été modifié ";
dataGridView1.ClearSelection();
FillDataGridView();
}catch (Exception e2)
{
MessageBox.Show("Message d'erreur : " + e2.Message + " \nType de l'exception " + e2.GetType() + " \nPile d'appel" + e2.StackTrace);
}
}
else
{
MessageBox.Show("La licence doit être unique");
}
}
else
{
MessageBox.Show("Veuillez remplir tout les champs");
}
}
/// <summary>
/// Ajoute un évènements
/// </summary>
/// <param name="sender"></param>
/// <param name="e">l'évènement à ajouter</param>
private void buttonInsertion_Click(object sender, EventArgs e)
{
if (condition())
{
if (verifiLicence())
{
Clubs club = new Clubs();
club.setNom(comboBox2.Text);
Adherents adherent = new Adherents();
adherent.setClub(club);
adherent.setSexe(comboBox1.Text);
adherent.setNom(textNom.Text);
adherent.setPrenom(textPrenom.Text);
adherent.setLicence(textLicence.Text);
adherent.setNaissance(dateTimePicker1.Value);
adherent.setAdresse(textAdresse.Text);
adherent.setCPT(Int32.Parse(textCodePostal.Text));
adherent.setVille(textVille.Text);
adherent.setCotisation(Int32.Parse(textCotisation.Text));
ModeleBDD bd = new ModeleBDD();
bd.setAdherent(adherent);
comboBox1.Text = "";
comboBox2.Text = "";
textNom.Text = "";
textPrenom.Text = "";
textLicence.Text = "";
//dateTimePicker1.Value = DateTime.Now;
textAdresse.Text = "";
textCodePostal.Text = "";
textVille.Text = "";
textCotisation.Text = "";
label10.Text = adherent.getNom() + " a été ajouter avec succès ";
dataGridView1.ClearSelection();
FillDataGridView();
}
else
{
MessageBox.Show("La Licence doit être unique");
}
}
else
{
MessageBox.Show("Veuillez rmplir tout les champs");
}
}
/// <summary>
/// methode setAdherents ajouter un adherents dans un base de donnée
/// </summary>
/// <param name="me">est un objet de la classe Adherents</param>
public void setAdherent(Adherents me)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO adherents(id_clubs, Licence, Sexe, Nom, Prenom, Naissance, Adresse, CodePostal, Ville, Cotisation) VALUES ((SELECT id FROM clubs WHERE Nom = @Club), @Licence, @Sexe, @Nom, @Prenom, @Naissance, @Adresse, @CodePostal, @Ville, @Cotisation)";
command.Parameters.AddWithValue("@Club", me.getClub().getNom());
command.Parameters.AddWithValue("@Licence", me.getLicence());
command.Parameters.AddWithValue("@Sexe", me.getSexe());
command.Parameters.AddWithValue("@Nom", me.getNom());
command.Parameters.AddWithValue("@Prenom", me.getPrenom());
command.Parameters.AddWithValue("@Naissance", me.getNaissance());
command.Parameters.AddWithValue("@Adresse", me.getAdresse());
command.Parameters.AddWithValue("@CodePostal", me.getCPT());
command.Parameters.AddWithValue("@Ville", me.getVille());
command.Parameters.AddWithValue("@Cotisation", me.getCotisation());
command.ExecuteNonQuery();
connection.Close();
}
}
/// <summary>
/// Methode qui permet de modifié un adhérent dans la base de donnée
/// </summary>
/// <param name="lAdherent">lAdherent a modifié</param>
public void UPDATEAdherent(Adherents lAdherent)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "UPDATE adherents SET id_clubs=(SELECT id FROM clubs WHERE Nom=@NomClub), Licence=@Licence, Sexe=@Sexe, Nom=@Nom, Prenom=@Prenom, Naissance=@Naissance, Adresse=@Adresse, CodePostal=@CodePostal, Ville=@Ville, Cotisation=@Cotisation WHERE id=@id";
command.Parameters.AddWithValue("@Id", lAdherent.getId());
command.Parameters.AddWithValue("@NomClub", lAdherent.getClub().getNom());
command.Parameters.AddWithValue("@Licence", lAdherent.getLicence());
command.Parameters.AddWithValue("@Nom", lAdherent.getNom());
command.Parameters.AddWithValue("@Prenom", lAdherent.getPrenom());
command.Parameters.AddWithValue("@Sexe", lAdherent.getSexe());
command.Parameters.AddWithValue("@Naissance", lAdherent.getNaissance());
command.Parameters.AddWithValue("@CodePostal", lAdherent.getCPT());
command.Parameters.AddWithValue("@Adresse", lAdherent.getAdresse());
command.Parameters.AddWithValue("@Ville", lAdherent.getVille());
command.Parameters.AddWithValue("@Cotisation", lAdherent.getCotisation());
command.ExecuteNonQuery();
connection.Close();
}
}
