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