示例#1
0
        // RECUPERATION RESULTAT BDD POUR RESULTAT SONDAGE  !!!!!!!

        public static Resultat RecupererResultatEnBdd(int idSondage)
        {
            using (SqlConnection connection = new SqlConnection(ConnectString))
            {
                connection.Open();

                SqlCommand command = new SqlCommand(@"SELECT * FROM Sondage,Resultat WHERE ID = @id and FK_Id_sondage = @id", connection);

                command.Parameters.AddWithValue("@id", idSondage);
                SqlDataReader reader = command.ExecuteReader();

                reader.Read();

                int    idsondage      = (int)reader["ID"];
                string question       = (string)reader["Questions"];
                string reponse1       = (string)reader["Reponse1"];
                string reponse2       = (string)reader["Reponse2"];
                string reponse3       = (string)reader["Reponse3"];
                bool   choix          = (bool)reader["Choix"];
                bool   actifOuPas     = (bool)reader["ActiveSondage"];
                int    nbreRep1       = (int)reader["NbreVoteReponse1"];
                int    nbrevoterep2   = (int)reader["NbreVoteReponse2"];
                int    nbrevoteRep3   = (int)reader["NbreVoteReponse3"];
                int    nombreDeVotant = (int)reader["NbreVotant"];
                int    fk_id_sondage  = (int)reader["FK_Id_sondage"];

                Sondage  sondage  = new Sondage(idsondage, question, reponse1, reponse2, reponse3, choix, actifOuPas);
                Resultat resultat = new Resultat(sondage, nbreRep1, nbrevoterep2, nbrevoteRep3, nombreDeVotant, fk_id_sondage);
                return(resultat);
            }
        }
 public ResultatVote(Sondage resultatVoteSondage, Resultat resultatVoteResultat)
 {
     ResultatVoteSondage  = resultatVoteSondage;
     ResultatVoteResultat = resultatVoteResultat;
 }