public List <C_T_Membre> Lire(string Index)
{
CreerCommande("SelectionnerT_Membre");
Commande.Parameters.AddWithValue("@Index", Index);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
List <C_T_Membre> res = new List <C_T_Membre>();
while (dr.Read())
{
C_T_Membre tmp = new C_T_Membre();
tmp.Id_Membre = int.Parse(dr["Id_Membre"].ToString());
tmp.M_Nom = dr["M_Nom"].ToString();
tmp.M_Prenom = dr["M_Prenom"].ToString();
tmp.M_Age = int.Parse(dr["M_Age"].ToString());
tmp.M_Sexe = dr["M_Sexe"].ToString();
tmp.M_Statut = dr["M_Statut"].ToString();
tmp.M_Section = dr["M_Section"].ToString();
tmp.M_Cotisation = dr["M_Cotisation"].ToString();
tmp.M_Mail = dr["M_Mail"].ToString();
res.Add(tmp);
}
dr.Close();
Commande.Connection.Close();
return(res);
}
public C_T_Membre Lire_ID(int Id_Membre)
{
CreerCommande("SelectionnerT_Membre_ID");
Commande.Parameters.AddWithValue("@Id_Membre", Id_Membre);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
C_T_Membre res = new C_T_Membre();
while (dr.Read())
{
res.Id_Membre = int.Parse(dr["Id_Membre"].ToString());
res.M_Nom = dr["M_Nom"].ToString();
res.M_Prenom = dr["M_Prenom"].ToString();
res.M_Age = int.Parse(dr["M_Age"].ToString());
res.M_Sexe = dr["M_Sexe"].ToString();
res.M_Statut = dr["M_Statut"].ToString();
res.M_Section = dr["M_Section"].ToString();
res.M_Cotisation = dr["M_Cotisation"].ToString();
res.M_Mail = dr["M_Mail"].ToString();
}
dr.Close();
Commande.Connection.Close();
return(res);
}
