public List <club> ReadClub()
{
List <club> liste = new List <club>();
club club;
type_club typec;
using (connection)
{
connection.Open();
string requete = "SELECT `id_club`,`Titre_club`,`url_club`,`Adresse_club`,`Code_Postal_club`,`Ville_club`,`mail_club`,`telephone_club`,libelle,type_club.id_type_club from club inner join type_club on club.id_type_club=type_club.id_type_club order by `id_club`";
MySqlCommand cmd = new MySqlCommand(requete, connection);
using (MySqlDataReader datareader = cmd.ExecuteReader())
{
while (datareader.Read())
{
typec = new type_club(Convert.ToInt32(datareader["id_type_club"]), (string)datareader["libelle"]);
club = new club((string)datareader["Titre_club"], (string)datareader["url_club"], (string)datareader["Adresse_club"], (string)datareader["Code_Postal_club"], (string)datareader["Ville_club"], (string)datareader["mail_club"], Convert.ToInt32(datareader["telephone_club"]), typec);
club.id_club = Convert.ToInt32(datareader["id_club"]);
//typec.libelle = (string)datareader["libelle"];
//club.type.id_type = (int)datareader["id_type_club"];
liste.Add(club);
}
}
}
return(liste);
}
public List <club> ReadClub()
{
List <club> liste = new List <club>();
club club;
type_club typec;
using (connection) {
connection.Open();
string requete = "SELECT `C_id`,`C_nom`,`C_url`,`C_adresse`,`C_codepostal`,`C_ville`,`C_email`,`C_tel`,'T_libelle',type_club.T_id FROM club INNER JOIN type_club ON club.C_fk_type = type_club.T_id ORDER BY `C_id`";
MySqlCommand cmd = new MySqlCommand(requete, connection);
using (MySqlDataReader datareader = cmd.ExecuteReader()) {
while (datareader.Read())
{
typec = new type_club(Convert.ToInt32(datareader["T_id"]), (string)datareader["T_libelle"]);
club = new club((string)datareader["C_nom"], (string)datareader["C_url"], (string)datareader["C_adresse"], (string)datareader["C_codepostal"], (string)datareader["C_ville"], (string)datareader["C_email"], Convert.ToInt32(datareader["C_tel"]), typec);
//Convert.ToInt32
club.id_club = Convert.ToInt32(datareader["C_id"]);
//typec.libelle = (string)datareader["libelle"];
//club.type.id_type = (int)datareader["id_type_club"];
liste.Add(club);
}
}
}
return(liste);
}
/// <summary>
/// Cette fonction permet de récuperer une liste d'évenement dans la BDD en l'associant à des instances de la classe : evenement
/// </summary>
/// <returns>Liste d'événements</returns>
public List <evenement> ReadEvent()
{
List <evenement> Liste = new List <evenement>();
club club;
type_club typec;
evenement evenement;
using (connection)
{
connection.Open();
string requete = "SELECT * from evenement join club on evenement.id_club=club.id_club join type_club on club.id_type_club=type_club.id_type_club";
MySqlCommand cmd = new MySqlCommand(requete, connection);
using (MySqlDataReader datareader = cmd.ExecuteReader())
{
while (datareader.Read())
{
typec = new type_club(Convert.ToInt32(datareader["id_type_club"]), (string)datareader["libelle"]);
club = new club((string)datareader["Titre_club"], (string)datareader["url_club"], (string)datareader["Adresse_club"], (string)datareader["Code_Postal_club"], (string)datareader["Ville_club"], (string)datareader["mail_club"], Convert.ToInt32(datareader["telephone_club"]), typec);
club.id_club = Convert.ToInt32(datareader["id_club"]);
evenement = new evenement((string)datareader["Titre_evenement"], (DateTime)datareader["debut_evenement"], (DateTime)datareader["fin_evenement"], club);
evenement.id_evenement = Convert.ToInt32(datareader["id_evenement"]);
Liste.Add(evenement);
}
}
}
return(Liste);
}
/// <summary>
/// Cette fonction permet de récuperer une liste d'évenement dans la BDD en l'associant à des instances de la classe : evenement
/// </summary>
/// <returns>Liste d'événements</returns>
public List <evenement> ReadEvent()
{
List <evenement> Liste = new List <evenement>();
club club;
type_club typec;
evenement evenement;
using (connection) {
connection.Open();
string requete = "SELECT * FROM evenement JOIN club ON evenement.E_fk_club = club.C_id JOIN type_club ON club.C_fk_type = type_club.T_id";
MySqlCommand cmd = new MySqlCommand(requete, connection);
using (MySqlDataReader datareader = cmd.ExecuteReader()) {
while (datareader.Read())
{
typec = new type_club(Convert.ToInt32(datareader["T_id"]), (string)datareader["T_libelle"]);
club = new club((string)datareader["C_id"], (string)datareader["C_url"], (string)datareader["C_adresse"], (string)datareader["C_codepostal"], (string)datareader["C_ville"], (string)datareader["C_email"], Convert.ToInt32(datareader["C_tel"]), typec);
club.id_club = Convert.ToInt32(datareader["C_id"]);
evenement = new evenement((string)datareader["E_nom"], (DateTime)datareader["E_datedeb"], (DateTime)datareader["E_datefin"], club);
evenement.id_evenement = Convert.ToInt32(datareader["E_id"]);
Liste.Add(evenement);
}
}
}
return(Liste);
}
public void testtype_club()
{
type_club tc = new type_club(18, "foot");
Assert.Equal(18, tc.id_type);
Assert.Equal("foot", tc.libelle);
}
public void testclub()
{
type_club tc = new type_club(20, "tennis");
club club = new club("un club", "une url", "une adresse", "un CP", "une ville", "un mail", 012345679, tc);
club cluba = club;
Assert.Equal("tennis", club.type.libelle);
Assert.Equal(club, cluba);
Assert.Equal("un club", cluba.Titre_club);
}
public void testnbradh()
{
type_club tc = new type_club(20, "tennis");
club club = new club("un club", "une url", "une adresse", "un CP", "une ville", "un mail", 012345679, tc);
adherent adhtest = new adherent("Bertrand", "jean", "92130", "6 squares louis blé", "Issy-les-mx");
adherent adhtest1 = new adherent("Bertrand", "Paul", "92130", "6 squares louis blé", "Issy-les-mx");
adherent adhtest2 = new adherent("Bertrand", "Romain", "92130", "6 squares louis blé", "Issy-les-mx");
adhtest2.Id = 28;
adherent adhtest3 = new adherent("Bertrand", "Romain", "92130", "6 squares louis blé", "Issy-les-mx");
adhtest3.Id = 28;
club.AjouterClubAdh(adhtest);
club.AjouterClubAdh(adhtest3);
club.AjouterClubAdh(adhtest2);
Assert.Equal(2, club.adherents.Count);
}
public List <adherent> Readadherent()
{
List <adherent> liste = new List <adherent>();
adherent adhérents;
club club;
type_club type;
using (connection)
{
connection.Open();
string requete = "select * from adherent left join club on adherent.id_club=club.id_club left join type_club on club.id_type_club = type_club.id_type_club order by adherent.id_adherent";
MySqlCommand cmd = new MySqlCommand(requete, connection);
using (MySqlDataReader datareader = cmd.ExecuteReader())
{
while (datareader.Read())
{
adhérents = new adherent((string)datareader["Nom_adherent"], (string)datareader["Prenom_adherent"], (string)datareader["Code_Postal_adherent"], (string)datareader["Adresse_adherent"], (string)datareader["Ville_adherent"]);
adhérents.DateNaissance = (DateTime)datareader["Date_naissance_adherent"];
adhérents.Id = (int)datareader["id_adherent"];
if (datareader["id_club"] != System.DBNull.Value && datareader["numero_licence"] != System.DBNull.Value)
{
type = new type_club(Convert.ToInt32(datareader["id_type_club"]), (string)datareader["libelle"]);
club = new club((string)datareader["Titre_club"], (string)datareader["url_club"], (string)datareader["Adresse_club"], (string)datareader["Code_Postal_club"], (string)datareader["Ville_club"], (string)datareader["mail_club"], Convert.ToInt32(datareader["telephone_club"]), type);
adhérents.numero_licence = Convert.ToInt32(datareader["numero_licence"]);
adhérents.Cotisation = Convert.ToInt32(datareader["cotisation_adherent"]);
adhérents.club = club;
}
liste.Add(adhérents);
}
}
}
return(liste);
}
public List <type_club> Liste_Type()
{
List <type_club> Laliste = new List <type_club>();
type_club type;
using (connection) {
connection.Open();
string requete = "SELECT * FROM type_club";
MySqlCommand cmd = new MySqlCommand(requete, connection);
using (MySqlDataReader datareader = cmd.ExecuteReader()) {
while (datareader.Read())
{
type = new type_club(Convert.ToInt32(datareader["T_id"]), (string)datareader["T_libelle"]);
Laliste.Add(type);
}
}
}
return(Laliste);
}
public type_club RecupType(string lib)
{
type_club typeclu;
List <type_club> Liste = new List <type_club>();
using (connection) {
connection.Open();
string requete = "SELECT * FROM type_club WHERE T_libelle=@libelle";
MySqlCommand cmd = new MySqlCommand(requete, connection);
cmd.Parameters.AddWithValue("@libelle", lib);
using (MySqlDataReader datareader = cmd.ExecuteReader()) {
while (datareader.Read())
{
typeclu = new type_club(Convert.ToInt32(datareader["T_id"]), (string)datareader["T_libelle"]);
Liste.Add(typeclu);
}
}
}
return(Liste[0]);
}
public List <adherent> Readadherent()
{
List <adherent> liste = new List <adherent>();
adherent adhérents;
club club;
type_club type;
//connexion_BDD connect = new connexion_BDD();
//connection = getConnection();
using (connection) {
connection.Open();
string requete = "SELECT * FROM adherent LEFT JOIN club ON adherent.A_fk_club = club.C_id LEFT JOIN type_club ON club.C_fk_type = type_club.T_id ORDER BY adherent.A_id";
MySqlCommand cmd = new MySqlCommand(requete, connection);
using (MySqlDataReader datareader = cmd.ExecuteReader()) {
while (datareader.Read())
{
adhérents = new adherent((string)datareader["A_nom"], (string)datareader["A_prenom"], (string)datareader["A_cp"], (string)datareader["A_adresse"], (string)datareader["A_ville"]);
adhérents.DateNaissance = (DateTime)datareader["A_datenaiss"];
adhérents.Id = (int)datareader["A_id"];
if (datareader["A_fk_club"] != System.DBNull.Value && datareader["A_licence"] != System.DBNull.Value)
{
type = new type_club(Convert.ToInt32(datareader["T_id"]), (string)datareader["T_libelle"]);
club = new club((string)datareader["C_nom"], (string)datareader["C_url"], (string)datareader["C_adresse"], (string)datareader["C_codepostal"], (string)datareader["C_ville"], (string)datareader["C_email"], Convert.ToInt32(datareader["C_tel"]), type);
adhérents.numero_licence = Convert.ToInt32(datareader["A_licence"]);
adhérents.Cotisation = Convert.ToInt32(datareader["A_cotisation"]);
adhérents.club = club;
}
liste.Add(adhérents);
}
}
}
return(liste);
}
