public C_PhotoEvenement Lire_ID(int ID)
{
CreerCommande("SelectionnerPhotoEvenement_ID");
Commande.Parameters.AddWithValue("@ID", ID);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
C_PhotoEvenement res = new C_PhotoEvenement();
while (dr.Read())
{
res.ID = int.Parse(dr["ID"].ToString());
res.IDevenement = int.Parse(dr["IDevenement"].ToString());
res.Photo = dr["Photo"].ToString();
res.EstPicto = bool.Parse(dr["EstPicto"].ToString());
}
dr.Close();
Commande.Connection.Close();
return(res);
}
public List <C_PhotoEvenement> LirePhotosEvenement(int ID)
{
CreerCommande("SelectionnerPhotosEvenement");
Commande.Parameters.AddWithValue("@ID", ID);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
List <C_PhotoEvenement> res = new List <C_PhotoEvenement>();
while (dr.Read())
{
C_PhotoEvenement tmp = new C_PhotoEvenement();
tmp.ID = int.Parse(dr["ID"].ToString());
tmp.IDevenement = int.Parse(dr["ID"].ToString());
tmp.Photo = dr["Photo"].ToString();
tmp.EstPicto = bool.Parse(dr["EstPicto"].ToString());
res.Add(tmp);
}
dr.Close();
Commande.Connection.Close();
return(res);
}
