public C_t_chambres Lire_ID(int IDCha) { CreerCommande("Selectionnert_chambres_ID"); Commande.Parameters.AddWithValue("@IDCha", IDCha); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); C_t_chambres res = new C_t_chambres(); while (dr.Read()) { res.IDCha = int.Parse(dr["IDCha"].ToString()); res.NomCha = int.Parse(dr["NomCha"].ToString()); res.QuantiteLits = int.Parse(dr["QuantiteLits"].ToString()); res.TypeCha = dr["TypeCha"].ToString(); res.EtageCha = int.Parse(dr["EtageCha"].ToString()); res.ServiceCha = dr["ServiceCha"].ToString(); } dr.Close(); Commande.Connection.Close(); return(res); }
public List <C_t_chambres> Lire(string Index) { CreerCommande("Selectionnert_chambres"); Commande.Parameters.AddWithValue("@Index", Index); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); List <C_t_chambres> res = new List <C_t_chambres>(); while (dr.Read()) { C_t_chambres tmp = new C_t_chambres(); tmp.IDCha = int.Parse(dr["IDCha"].ToString()); tmp.NomCha = int.Parse(dr["NomCha"].ToString()); tmp.QuantiteLits = int.Parse(dr["QuantiteLits"].ToString()); tmp.TypeCha = dr["TypeCha"].ToString(); tmp.EtageCha = int.Parse(dr["EtageCha"].ToString()); tmp.ServiceCha = dr["ServiceCha"].ToString(); res.Add(tmp); } dr.Close(); Commande.Connection.Close(); return(res); }