public C_t_medecins Lire_ID(int IDMed)
{
CreerCommande("Selectionnert_medecins_ID");
Commande.Parameters.AddWithValue("@IDMed", IDMed);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
C_t_medecins res = new C_t_medecins();
while (dr.Read())
{
res.IDMed = int.Parse(dr["IDMed"].ToString());
res.NomMed = dr["NomMed"].ToString();
res.PrenomMed = dr["PrenomMed"].ToString();
res.GSMMed = int.Parse(dr["GSMMed"].ToString());
res.IDSpe = int.Parse(dr["IDSpe"].ToString());
}
dr.Close();
Commande.Connection.Close();
return(res);
}
public List <C_t_medecins> Lire(string Index)
{
CreerCommande("Selectionnert_medecins");
Commande.Parameters.AddWithValue("@Index", Index);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
List <C_t_medecins> res = new List <C_t_medecins>();
while (dr.Read())
{
C_t_medecins tmp = new C_t_medecins();
tmp.IDMed = int.Parse(dr["IDMed"].ToString());
tmp.NomMed = dr["NomMed"].ToString();
tmp.PrenomMed = dr["PrenomMed"].ToString();
tmp.GSMMed = int.Parse(dr["GSMMed"].ToString());
tmp.IDSpe = int.Parse(dr["IDSpe"].ToString());
res.Add(tmp);
}
dr.Close();
Commande.Connection.Close();
return(res);
}
