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); }