public C_Evenement Lire_ID(int ID)
{
CreerCommande("SelectionnerEvenement_ID");
Commande.Parameters.AddWithValue("@ID", ID);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
C_Evenement res = new C_Evenement();
while (dr.Read())
{
res.ID = int.Parse(dr["ID"].ToString());
res.DateDebut = DateTime.Parse(dr["DateDebut"].ToString());
res.DateFin = DateTime.Parse(dr["DateFin"].ToString());
res.Description = dr["Description"].ToString();
res.TypeEvenement = int.Parse(dr["TypeEvenement"].ToString());
res.IDtitre = int.Parse(dr["IDtitre"].ToString());
res.IDlieu = int.Parse(dr["IDlieu"].ToString());
}
dr.Close();
Commande.Connection.Close();
return(res);
}
public List <C_Evenement> Lire(string Index)
{
CreerCommande("SelectionnerEvenement");
Commande.Parameters.AddWithValue("@Index", Index);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
List <C_Evenement> res = new List <C_Evenement>();
while (dr.Read())
{
C_Evenement tmp = new C_Evenement();
tmp.ID = int.Parse(dr["ID"].ToString());
tmp.DateDebut = DateTime.Parse(dr["DateDebut"].ToString());
tmp.DateFin = DateTime.Parse(dr["DateFin"].ToString());
tmp.Description = dr["Description"].ToString();
tmp.TypeEvenement = int.Parse(dr["TypeEvenement"].ToString());
tmp.IDtitre = int.Parse(dr["IDtitre"].ToString());
tmp.IDlieu = int.Parse(dr["IDlieu"].ToString());
res.Add(tmp);
}
dr.Close();
Commande.Connection.Close();
return(res);
}
