public static List <ReponseSondage> RecupereListeDereponses(int id) { using (SqlConnection connection = new SqlConnection(cheminBase)) { connection.Open(); SqlCommand ListeReponses = new SqlCommand("SELECT* FROM Reponse WHERE FKIDSondage=@ID", connection); ListeReponses.Parameters.AddWithValue("@ID", id); SqlDataReader datareaderListe = ListeReponses.ExecuteReader(); datareaderListe.Read(); List <ReponseSondage> ListeReponse = new List <ReponseSondage>(); do { int idReponse = datareaderListe.GetInt32(0); string Reponse = datareaderListe.GetString(2); int NombreDeVote = datareaderListe.GetInt32(3); ReponseSondage reponseSondage = new ReponseSondage(idReponse, Reponse, NombreDeVote); ListeReponse.Add(reponseSondage); }while (datareaderListe.Read()); connection.Close(); ListeReponses.Parameters.Clear(); return(ListeReponse); } }
public static List <ReponseSondage> GetlisteDeReponses(List <string> ListeNonTriee) { List <ReponseSondage> ListeTriee = new List <ReponseSondage>(); foreach (string RepValue in ListeNonTriee) { if (RepValue != "") { ReponseSondage reponse = new ReponseSondage(RepValue); ListeTriee.Add(reponse); } } return(ListeTriee); }