private void buttonUpdate_Click(object sender, EventArgs e)
{
if (condition())
{
TypeClub letype = new TypeClub();
letype.setLibelle(comboBox1.Text);
Clubs club = new Clubs();
club.setId(Int32.Parse(textID.Text));
club.setLienSite(textLienSite.Text);
club.setNom(textNom.Text);
club.setMail(textEmail.Text);
club.setType(letype);
club.setAdresse(textAdresse.Text);
club.setCPT(Int32.Parse(textCPT.Text));
club.setVille(textVille.Text);
club.setTel(Int32.Parse(textTel.Text));
ModeleBDD bd = new ModeleBDD();
bd.UPDATEClub(club);
labelInfo.Text = club.getNom() + " a été modifié ";
dataGridView1.ClearSelection();
FillDataGridView();
}
else
{
MessageBox.Show("Veuillez remplir tout les champs");
}
}
//Statistique Cotisation
public string AVGCotisation(Clubs leClub)
{
string moyenne = "";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT AVG(adherents.Cotisation) as Moyenne FROM adherents INNER JOIN clubs ON adherents.id_clubs = clubs.id WHERE clubs.Nom =@Nom";
command.Parameters.AddWithValue("@Nom", leClub.getNom());
using (MySqlDataReader dataReader = command.ExecuteReader())
{
Clubs LeClub = new Clubs();
while (dataReader.Read())
{
LeClub.setCPT((int)dataReader["Moyenne"]);
}
}
connection.Close();
moyenne = leClub.getCPT().ToString();
return(moyenne);
}
}
private void buttonInsert_Click(object sender, EventArgs e)
{
if (condition())
{
TypeClub letype = new TypeClub();
letype.setLibelle(comboBox1.Text);
Clubs club = new Clubs();
club.setLienSite(textLienSite.Text);
club.setNom(textNom.Text);
club.setMail(textEmail.Text);
club.setType(letype);
club.setAdresse(textAdresse.Text);
club.setCPT(Int32.Parse(textCPT.Text));
club.setVille(textVille.Text);
club.setTel(Int32.Parse(textTel.Text));
try
{
ModeleBDD bd = new ModeleBDD();
bd.setClub(club);
textNom.Text = "";
textLienSite.Text = "";
comboBox1.Text = "";
textEmail.Text = "";
textAdresse.Text = "";
textCPT.Text = "";
textVille.Text = "";
textTel.Text = "";
labelInfo.Text = club.getNom() + " a été ajouter avec succès ";
dataGridView1.ClearSelection();
FillDataGridView();
}catch (Exception e1)
{
MessageBox.Show("Message d'erreur : " + e1.Message + " \nType de l'exception " + e1.GetType() + " \nPile d'appel" + e1.StackTrace);
}
}
else
{
MessageBox.Show("Veuillez remplir tout les champs");
}
}
/// <summary>
/// methode setClub ajouter un club dans la base dedonnées
/// </summary>
/// <param name="leClub">est un abjet de la classe Clubs</param>
public void setClub(Clubs leClub)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO clubs(Nom, LienSite, Adresse, Ville, CodePostal, Telephone, Email, id_type) VALUES (@Nom, @LienSite, @Adresse, @Ville, @CodePostal, @Telephone, @Email, (SELECT id FROM Type WHERE Libelle = @Type))";
command.Parameters.AddWithValue("@Nom", leClub.getNom());
command.Parameters.AddWithValue("@LienSite", leClub.getLienSite());
command.Parameters.AddWithValue("@Adresse", leClub.getAdresse());
command.Parameters.AddWithValue("@Ville", leClub.getVille());
command.Parameters.AddWithValue("@CodePostal", leClub.getCPT());
command.Parameters.AddWithValue("@Telephone", leClub.getTel());
command.Parameters.AddWithValue("@Email", leClub.getEMail());
command.Parameters.AddWithValue("@Type", leClub.getType().getLibelle());
command.ExecuteNonQuery();
connection.Close();
}
}
/// <summary>
/// La méthode modifie un club en fonction de l'objet Clubs en parametre.
/// </summary>
/// <param name="Clubs">Leclub a modifié </param>
/// <returns>un club</returns>
public void UPDATEClub(Clubs leClub)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "UPDATE clubs SET Nom=@Nom, LienSite=@LienSite, Adresse=@Adresse, Ville=@Ville, CodePostal=@CodePostal, Telephone=@Telephone, Email=@Email, id_type= ( SELECT id FROM type WHERE Libelle=@Type ) WHERE id=@id";
command.Parameters.AddWithValue("@Id", leClub.getId());
command.Parameters.AddWithValue("@Nom", leClub.getNom());
command.Parameters.AddWithValue("@LienSite", leClub.getLienSite());
command.Parameters.AddWithValue("@Adresse", leClub.getAdresse());
command.Parameters.AddWithValue("@Ville", leClub.getVille());
command.Parameters.AddWithValue("@CodePostal", leClub.getCPT());
command.Parameters.AddWithValue("@Telephone", leClub.getTel());
command.Parameters.AddWithValue("@Email", leClub.getEMail());
command.Parameters.AddWithValue("@Type", leClub.getType().getLibelle());
command.ExecuteNonQuery();
connection.Close();
}
}