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