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"); } }
//les sont modifié //adherent /// <summary> /// Methode qui selection tous adhernts sur la base de données /// </summary> /// <returns>Return un Listes des adherents</returns> public List <Adherents> getAdherents() { List <Adherents> lesAdherents = new List <Adherents>(); using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.Open(); string query = "SELECT a.id AS IdAdherent, a.Licence, a.Sexe, a.Nom, a.Prenom, a.Naissance, a.Adresse, a.CodePostal, a.Ville, a.Cotisation, c.id AS IdClub, c.Nom AS NomClub FROM adherents AS a INNER JOIN clubs AS c ON a.id_clubs=c.id"; //Crée Commande MySqlCommand command = new MySqlCommand(query, connection); //On crée un datareader et on execute la commande using (MySqlDataReader dataReader = command.ExecuteReader()) { //On li la base de données et on ajoute dans la liste les ahderents de la base de données while (dataReader.Read()) { Clubs club = new Clubs(); club.setId((int)dataReader["IdClub"]); club.setNom((string)dataReader["NomClub"]); Adherents lAdherent = new Adherents(); lAdherent.setId((int)dataReader["IdAdherent"]); lAdherent.setClub(club); lAdherent.setLicence((string)dataReader["Licence"]); lAdherent.setSexe((string)dataReader["Sexe"]); lAdherent.setNom((string)dataReader["Nom"]); lAdherent.setPrenom((string)dataReader["Prenom"]); lAdherent.setNaissance((DateTime)dataReader["Naissance"]); lAdherent.setAdresse((string)dataReader["Adresse"]); lAdherent.setCPT((int)dataReader["CodePostal"]); lAdherent.setVille((string)dataReader["Ville"]); lAdherent.setCotisation((int)dataReader["Cotisation"]); lesAdherents.Add(lAdherent); } //string MySQLFormatDate = dateValue.ToString("yyyy-MM-dd HH:mm:ss") } connection.Close(); return(lesAdherents); } }
/* /// <summary> * /// La méthode Read retourne un Adherent en fonction de l'id en parametre. * /// </summary> * /// <param name="id">id de l'adherent selectionnedans la dataGridView</param> * /// <returns>un adhrent</returns> * public Adherents Read(int id) * { * Adherents lAdherent = null; * * using (MySqlConnection connection = new MySqlConnection(connectionString)) * { * connection.Open(); * string query = "SELECT * FROM adherents where id=@id"; * * //Create Command * MySqlCommand cmd = new MySqlCommand(query, connection); * * cmd.Parameters.AddWithValue("@id", id); * * //Create a data reader and Execute the command * using (MySqlDataReader dataReader = cmd.ExecuteReader()) * { * //Read the data and store them in the list * while (dataReader.Read()) * { * lAdherent = new Adherents(); * lAdherent.setId((int)dataReader["id"]); * lAdherent.setLicence((string)dataReader["Licence"]); * lAdherent.setNom((string)dataReader["Nom"]); * lAdherent.setPrenom((string)dataReader["Prenom"]); * lAdherent.setNaissance((string)dataReader["Naissance"]); * lAdherent.setAdresse((string)dataReader["Adresse"]); * lAdherent.setCPT((int)dataReader["CodePoastal"]); * lAdherent.setVille((string)dataReader["Ville"]); * lAdherent.setCotisation(dataReader["Cotisation"] != DBNull.Value ? (int)dataReader["Cotisation"] : 0); * } * } * } * * return lAdherent; * } */ //methode evenement /// <summary> /// Methode qui selection tous Evenements sur la base de données /// </summary> /// <returns>Return un Listes des evenements</returns> public List <Evenements> getEvent() { List <Evenements> Events = new List <Evenements>(); using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.Open(); string query = "SELECT e.id AS IdEven, e.Titre, e.LienSite, e.Adresse, e.Ville, e.CodePostal, e.Moment, e.Type, e.id_clubs, c.id AS IdClub, c.Nom From evenements AS e INNER JOIN Clubs AS c ON e.id_clubs = c.id ORDER BY e.id "; //Crée Commande MySqlCommand command = new MySqlCommand(query, connection); //On crée un datareader et on execute la commande using (MySqlDataReader dataReader = command.ExecuteReader()) { //On li la base de données et on ajiute dans la liste les ahderents de la base de données while (dataReader.Read()) { Clubs LeClub = new Clubs(); LeClub.setId((int)dataReader["IdClub"]); LeClub.setNom((string)dataReader["Nom"]); Evenements Event = new Evenements(); Event.setId((int)dataReader["IdEven"]); Event.setLienSite((string)dataReader["LienSite"]); Event.setType((string)dataReader["Type"]); Event.setTitre((string)dataReader["Titre"]); Event.setClub(LeClub); Event.setMoment((DateTime)dataReader["Moment"]); Event.setAdresse((string)dataReader["Adresse"]); Event.setCPT((int)dataReader["CodePostal"]); Event.setVille((string)dataReader["Ville"]); Events.Add(Event); } } connection.Close(); return(Events); } }
//La methode est modifié //club /// <summary> /// Methode qui selection tous clubs sur la base de données /// </summary> /// <returns>Return un Listes des clubs</returns> public List <Clubs> getClubs() { List <Clubs> lesClubs = new List <Clubs>(); using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.Open(); string query = "SELECT c.id AS IdClub, c.Nom, c.LienSIte, c.Adresse, c.Ville, c.CodePostal, c.Telephone, c.Email, c.id_type, t.id AS IdType, t.Libelle From clubs AS c INNER JOIN type AS t ON c.id_type = t.id"; //Crée Commande MySqlCommand command = new MySqlCommand(query, connection); //On crée un datareader et on execute la commande using (MySqlDataReader dataReader = command.ExecuteReader()) { //On li la base de données et on ajiute dans la liste les ahderents de la base de données while (dataReader.Read()) { TypeClub Type = new TypeClub(); Type.setId((int)dataReader["IdType"]); Type.setLibelle((string)dataReader["Libelle"]); Clubs lClub = new Clubs(); lClub.setId((int)dataReader["IdClub"]); lClub.setLienSite((string)dataReader["LienSite"]); lClub.setMail((string)dataReader["Email"]); lClub.setNom((string)dataReader["Nom"]); lClub.setType(Type); lClub.setTel((int)dataReader["Telephone"]); lClub.setAdresse((string)dataReader["Adresse"]); lClub.setCPT((int)dataReader["CodePostal"]); lClub.setVille((string)dataReader["Ville"]); lesClubs.Add(lClub); } } connection.Close(); return(lesClubs); } }