public CClubs Lire_ID(int clubId)
{
CreerCommande("SelectionnerClubs_ID");
Commande.Parameters.AddWithValue("@ClubId", clubId);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
CClubs res = new CClubs();
while (dr.Read())
{
res.ClubId = clubId;
res.Indice = dr["Indice"].ToString();
res.Nom = dr["Nom"].ToString();
res.NomCourt = dr["NomCourt"].ToString();
res.Adresse = dr["Adresse"].ToString();
}
dr.Close();
Commande.Connection.Close();
return(res);
}
public List <CClubs> Lire(string index)
{
CreerCommande("SelectionnerClubs");
Commande.Parameters.AddWithValue("@Index", index);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
List <CClubs> res = new List <CClubs>();
while (dr.Read())
{
CClubs tmp = new CClubs
{
ClubId = int.Parse(dr["ClubId"].ToString()),
Indice = dr["Indice"].ToString(),
Nom = dr["Nom"].ToString(),
NomCourt = dr["NomCourt"].ToString(),
Adresse = dr["Adresse"].ToString()
};
res.Add(tmp);
}
dr.Close();
Commande.Connection.Close();
return(res);
}
public WClubs(Iclubs InterfazClubs)
{
objClubs = new CClubs();
Manager = new ManagerBD();
ViewClubs = InterfazClubs;
}
