/// <summary>
/// readType retourne la liste des types de clubs
/// </summary>
/// <returns></returns>
public List <TypeClub> ReadType()
{
List <TypeClub> liste = new List <TypeClub>();
TypeClub type;
using ( connexion )
{
connexion.Open();
string requete = "SELECT * FROM type_club";
MySqlCommand cmd = new MySqlCommand(requete, connexion);
using (MySqlDataReader datareader = cmd.ExecuteReader())
{
while (datareader.Read())
{
type = new TypeClub(
(string)datareader["libelle"]);
type.id = (int)datareader["id_type_club"];
liste.Add(type);
}
}
}
return(liste);
}
/// <summary>
/// La méthode ReadClub retourne une liste de tout les clubs dans la table.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <Club> ReadClub()
{
List <Club> liste = new List <Club>();
TypeClub type;
Club clubs;
using ( connexion )
{
connexion.Open();
string requete = "SELECT * FROM club join type_club on club.id_type_club = type_club.id_type_club ";
MySqlCommand cmd = new MySqlCommand(requete, connexion);
using (MySqlDataReader datareader = cmd.ExecuteReader())
{
while (datareader.Read())
{
clubs = new Club(
(string)datareader["Titre_club"], (string)datareader["url_club"],
(string)datareader["Ville_club"], (string)datareader["telephone_club"], (string)datareader["Code_Postal_club"],
(string)datareader["mail_club"], (int)datareader["id_type_club"], (string)datareader["Adresse_club"]);
type = new TypeClub(
(string)datareader["libelle"]);
type.id = (int)datareader["id_type_club"];
clubs.id = (int)datareader["id_club"];
clubs.Type = type;
liste.Add(clubs);
}
}
}
return(liste);
}