public C_t_patients Lire_ID(int IDPat)
{
CreerCommande("Selectionnert_patients_ID");
Commande.Parameters.AddWithValue("@IDPat", IDPat);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
C_t_patients res = new C_t_patients();
while (dr.Read())
{
res.IDPat = int.Parse(dr["IDPat"].ToString());
res.NomPat = dr["NomPat"].ToString();
res.PrenomPat = dr["PrenomPat"].ToString();
res.AdressePat = dr["AdressePat"].ToString();
res.GSMPat = int.Parse(dr["GSMPat"].ToString());
}
dr.Close();
Commande.Connection.Close();
return(res);
}
public List <C_t_patients> Lire(string Index)
{
CreerCommande("Selectionnert_patients");
Commande.Parameters.AddWithValue("@Index", Index);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
List <C_t_patients> res = new List <C_t_patients>();
while (dr.Read())
{
C_t_patients tmp = new C_t_patients();
tmp.IDPat = int.Parse(dr["IDPat"].ToString());
tmp.NomPat = dr["NomPat"].ToString();
tmp.PrenomPat = dr["PrenomPat"].ToString();
tmp.AdressePat = dr["AdressePat"].ToString();
tmp.GSMPat = int.Parse(dr["GSMPat"].ToString());
res.Add(tmp);
}
dr.Close();
Commande.Connection.Close();
return(res);
}
