public List <C_t_soigner> Lire(string Index)
{
CreerCommande("Selectionnert_soigner");
Commande.Parameters.AddWithValue("@Index", Index);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
List <C_t_soigner> res = new List <C_t_soigner>();
while (dr.Read())
{
C_t_soigner tmp = new C_t_soigner();
tmp.IDSoi = int.Parse(dr["IDSoi"].ToString());
tmp.IDMed = int.Parse(dr["IDMed"].ToString());
tmp.IDPat = int.Parse(dr["IDPat"].ToString());
tmp.DateOperation = DateTime.Parse(dr["DateOperation"].ToString());
tmp.DateAuthorisationSortie = DateTime.Parse(dr["DateAuthorisationSortie"].ToString());
if (dr["PrixOperation"] != DBNull.Value)
{
tmp.PrixOperation = int.Parse(dr["PrixOperation"].ToString());
}
res.Add(tmp);
}
dr.Close();
Commande.Connection.Close();
return(res);
}
public C_t_soigner Lire_ID(int IDSoi)
{
CreerCommande("Selectionnert_soigner_ID");
Commande.Parameters.AddWithValue("@IDSoi", IDSoi);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
C_t_soigner res = new C_t_soigner();
while (dr.Read())
{
res.IDSoi = int.Parse(dr["IDSoi"].ToString());
res.IDMed = int.Parse(dr["IDMed"].ToString());
res.IDPat = int.Parse(dr["IDPat"].ToString());
res.DateOperation = DateTime.Parse(dr["DateOperation"].ToString());
res.DateAuthorisationSortie = DateTime.Parse(dr["DateAuthorisationSortie"].ToString());
if (dr["PrixOperation"] != DBNull.Value)
{
res.PrixOperation = int.Parse(dr["PrixOperation"].ToString());
}
}
dr.Close();
Commande.Connection.Close();
return(res);
}
