using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class donnees : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        VoirResultat();
    }

    private void VoirResultat()
    {
        OleDbCommand command;
        OleDbDataReader reader;
        string query = "";
        OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString = ConfigurationManager.ConnectionStrings["SondBD"].ConnectionString;
        try
        {
            conn.Open();

            #region Question 1 (Oui,Non,Je ne sais pas)
            //Question 1 Oui = colonne 0, Non = colonne 1, je ne sais pas = colonne 3 
            query = "SELECT * FROM GetQuestion1Result";
            command = new OleDbCommand(query, conn);
            reader = command.ExecuteReader();
            while (reader.Read())
            {
                Qu1Oui.Text = reader["Oui"].ToString() + "%";
                Qu1Non.Text = reader["Non"].ToString() + "%";
                Qu1JenesaisPas.Text = reader["Pas"].ToString() + "%";
            }
            //Libérer et vider les valeurs
            reader.Close();
            reader.Dispose();
            command.Dispose();
            #endregion

            #region Question 2 (Oui,Non)
            /*Question 2 colonne 0 = Oui, colonne 1 = Non
             * Sur 10 colonnes 
             */
            query = "SELECT * FROM GetQuestion2Result";
            command = new OleDbCommand(query, conn);
            reader = command.ExecuteReader();

            while (reader.Read())
            {
                Qu2QuinOui.Text = reader["QuinVrai"].ToString() + "%";
                Qu2QuinNon.Text = reader["QuinFaux"].ToString() + "%";
                Qu2DonnOui.Text = reader["DonnVrai"].ToString() + "%";
                Qu2DonnNon.Text = reader["DonnFaux"].ToString() + "%";
                Qu2EcritLanauOui.Text = reader["EcritVrai"].ToString() + "%";
                Qu2EcritLanauNon.Text = reader["EcritFaux"].ToString() + "%";
                Qu2PrgCulOui.Text = reader["CultVrai"].ToString() + "%";
                Qu2PrgCulNon.Text = reader["CultFaux"].ToString() + "%";
                Qu2CollectifOui.Text = reader["AVoixVrai"].ToString() + "%";
                Qu2CollectifNon.Text = reader["AVoixFaux"].ToString() + "%";
                Qu2CarOui.Text = reader["CarrVrai"].ToString() + "%";
                Qu2CarNon.Text = reader["CarrFaux"].ToString() + "%";
                Qu2ConOui.Text = reader["ConcourLitVrai"].ToString() + "%";
                Qu2ConNon.Text = reader["ConcourLitFaux"].ToString() + "%";
                Qu2SlamOui.Text = reader["SlamVrai"].ToString() + "%";
                Qu2SlamNon.Text = reader["SlamFaux"].ToString() + "%";
            }
            reader.Close();
            reader.Dispose();
            command.Dispose();
            #endregion

            #region Question 3 1..5
            /*Question 3 1 à 5 où 5 est le plus apprécié
             * (18 * 5) Colonnes
             * P.S: C'est pas pour rien que je fais des régions
             */

            query = "SELECT * FROM GetQuestion3Result";
            command = new OleDbCommand(query, conn);
            reader = command.ExecuteReader();

            while (reader.Read())
            {
                Qu3ActiCon1.Text = reader["ActiCon1"].ToString() + "%";
                Qu3ActiCon2.Text = reader["ActiCon2"].ToString() + "%";
                Qu3ActiCon3.Text = reader["ActiCon3"].ToString() + "%";
                Qu3ActiCon4.Text = reader["ActiCon4"].ToString() + "%";
                Qu3ActiCon5.Text = reader["ActiCon5"].ToString() + "%";

                Qu3ActiRes1.Text = reader["ActiRes1"].ToString() + "%";
                Qu3ActiRes2.Text = reader["ActiRes2"].ToString() + "%";
                Qu3ActiRes3.Text = reader["ActiRes3"].ToString() + "%";
                Qu3ActiRes4.Text = reader["ActiRes4"].ToString() + "%";
                Qu3ActiRes5.Text = reader["ActiRes5"].ToString() + "%";

                Qu3ActiEcrit1.Text = reader["Atelier1"].ToString() + "%";
                Qu3ActiEcrit2.Text = reader["Atelier2"].ToString() + "%";
                Qu3ActiEcrit3.Text = reader["Atelier3"].ToString() + "%";
                Qu3ActiEcrit4.Text = reader["Atelier4"].ToString() + "%";
                Qu3ActiEcrit5.Text = reader["Atelier5"].ToString() + "%";

                Qu3Camp1.Text = reader["Camp1"].ToString() + "%";
                Qu3Camp2.Text = reader["Camp2"].ToString() + "%";
                Qu3Camp3.Text = reader["Camp3"].ToString() + "%";
                Qu3Camp4.Text = reader["Camp4"].ToString() + "%";
                Qu3Camp5.Text = reader["Camp5"].ToString() + "%";

                Qu3Classe1.Text = reader["Classe1"].ToString() + "%";
                Qu3Classe2.Text = reader["Classe2"].ToString() + "%";
                Qu3Classe3.Text = reader["Classe3"].ToString() + "%";
                Qu3Classe4.Text = reader["Classe4"].ToString() + "%";
                Qu3Classe5.Text = reader["Classe5"].ToString() + "%";

                Qu3Concour1.Text = reader["Concours1"].ToString() + "%";
                Qu3Concour2.Text = reader["Concours2"].ToString() + "%";
                Qu3Concour3.Text = reader["Concours3"].ToString() + "%";
                Qu3Concour4.Text = reader["Concours4"].ToString() + "%";
                Qu3Concour5.Text = reader["Concours5"].ToString() + "%";

                Qu3Conf1.Text = reader["Conférence1"].ToString() + "%";
                Qu3Conf2.Text = reader["Conférence2"].ToString() + "%";
                Qu3Conf3.Text = reader["Conférence3"].ToString() + "%";
                Qu3Conf4.Text = reader["Conférence4"].ToString() + "%";
                Qu3Conf5.Text = reader["Conférence5"].ToString() + "%";

                Qu3Expo1.Text = reader["Expo1"].ToString() + "%";
                Qu3Expo2.Text = reader["Expo2"].ToString() + "%";
                Qu3Expo3.Text = reader["Expo3"].ToString() + "%";
                Qu3Expo4.Text = reader["Expo4"].ToString() + "%";
                Qu3Expo5.Text = reader["Expo5"].ToString() + "%";

                Qu3Mento1.Text = reader["Mentorat1"].ToString() + "%";
                Qu3Mento2.Text = reader["Mentorat2"].ToString() + "%";
                Qu3Mento3.Text = reader["Mentorat3"].ToString() + "%";
                Qu3Mento4.Text = reader["Mentorat4"].ToString() + "%";
                Qu3Mento5.Text = reader["Mentorat5"].ToString() + "%";

                Qu3Parcour1.Text = reader["Parcours1"].ToString() + "%";
                Qu3Parcour2.Text = reader["Parcours2"].ToString() + "%";
                Qu3Parcour3.Text = reader["Parcours3"].ToString() + "%";
                Qu3Parcour4.Text = reader["Parcours4"].ToString() + "%";
                Qu3Parcour5.Text = reader["Parcours5"].ToString() + "%";


                Qu3PrixLivre1.Text = reader["PrixLivre1"].ToString() + "%";
                Qu3PrixLivre2.Text = reader["PrixLivre2"].ToString() + "%";
                Qu3PrixLivre3.Text = reader["PrixLivre3"].ToString() + "%";
                Qu3PrixLivre4.Text = reader["PrixLivre4"].ToString() + "%";
                Qu3PrixLivre5.Text = reader["PrixLivre5"].ToString() + "%";

                Qu3Resi1.Text = reader["Residence1"].ToString() + "%";
                Qu3Resi2.Text = reader["Residence2"].ToString() + "%";
                Qu3Resi3.Text = reader["Residence3"].ToString() + "%";
                Qu3Resi4.Text = reader["Residence4"].ToString() + "%";
                Qu3Resi5.Text = reader["Residence5"].ToString() + "%";

                Qu3Salon1.Text = reader["Salon1"].ToString() + "%";
                Qu3Salon2.Text = reader["Salon2"].ToString() + "%";
                Qu3Salon3.Text = reader["Salon3"].ToString() + "%";
                Qu3Salon4.Text = reader["Salon4"].ToString() + "%";
                Qu3Salon5.Text = reader["Salon5"].ToString() + "%";

                //Qu4 car à la base c'était une autre question sur papier

                Qu4GesCarr1.Text = reader["GestionCar1"].ToString() + "%";
                Qu4GesCarr2.Text = reader["GestionCar2"].ToString() + "%";
                Qu4GesCarr3.Text = reader["GestionCar3"].ToString() + "%";
                Qu4GesCarr4.Text = reader["GestionCar4"].ToString() + "%";
                Qu4GesCarr5.Text = reader["GestionCar5"].ToString() + "%";

                Qu4MiseMarche1.Text = reader["MiseEnMarche1"].ToString() + "%";
                Qu4MiseMarche2.Text = reader["MiseEnMarche2"].ToString() + "%";
                Qu4MiseMarche3.Text = reader["MiseEnMarche3"].ToString() + "%";
                Qu4MiseMarche4.Text = reader["MiseEnMarche4"].ToString() + "%";
                Qu4MiseMarche5.Text = reader["MiseEnMarche5"].ToString() + "%";

                Qu4Nouvtec1.Text = reader["NouvTech1"].ToString() + "%";
                Qu4Nouvtec2.Text = reader["NouvTech2"].ToString() + "%";
                Qu4Nouvtec3.Text = reader["NouvTech3"].ToString() + "%";
                Qu4Nouvtec4.Text = reader["NouvTech4"].ToString() + "%";
                Qu4Nouvtec5.Text = reader["NouvTech5"].ToString() + "%";
            }
            reader.Close();
            reader.Dispose();
            command.Dispose();
            #endregion

            #region Question 4 Développement
            query = "SELECT * FROM GetQuestion4Result";
            command = new OleDbCommand(query, conn);
            reader = command.ExecuteReader();
            int i = 0;
            while (reader.Read())
            {
                ++i;
                Qu5.Controls.Add(new LiteralControl("<div class=\"comm\">"));
                Qu5.Controls.Add(new LiteralControl("<p>" + i.ToString() + "- " + reader["Valeur"].ToString() + "</p>"));
                Qu5.Controls.Add(new LiteralControl("</div>"));
            }
            reader.Close();
            reader.Dispose();
            command.Dispose();
            #endregion

            #region Question 5 Developpement
            query = "SELECT * FROM GetQuestion5Result";
            command = new OleDbCommand(query, conn);
            reader = command.ExecuteReader();
            i = 0;
            while (reader.Read())
            {
                ++i;
                Qu6.Controls.Add(new LiteralControl("<div class=\"comm\">"));
                Qu6.Controls.Add(new LiteralControl("<p>" + i.ToString() + "- " + reader["Valeur"].ToString() + "</p>"));
                Qu6.Controls.Add(new LiteralControl("</div>"));
            }
            reader.Close();
            reader.Dispose();
            command.Dispose();
            #endregion

            #region Question 6 Developpement
            query = "SELECT * FROM GetQuestion6Result";
            command = new OleDbCommand(query, conn);
            reader = command.ExecuteReader();
            i = 0;
            while (reader.Read())
            {
                ++i;
                Qu7.Controls.Add(new LiteralControl("<div class=\"comm\">"));
                Qu7.Controls.Add(new LiteralControl("<p>" + i.ToString() + "- " + reader["Valeur"].ToString() + "</p>"));
                Qu7.Controls.Add(new LiteralControl("</div>"));
            }
            reader.Close();
            reader.Dispose();
            command.Dispose();
            #endregion

            #region Question 7 Developpement
            query = "SELECT * FROM GetQuestion7Result";
            command = new OleDbCommand(query, conn);
            reader = command.ExecuteReader();
            i = 0;
            while (reader.Read())
            {
                ++i;
                Qu8.Controls.Add(new LiteralControl("<div class=\"comm\">"));
                Qu8.Controls.Add(new LiteralControl("<p>" + i.ToString() + "- " + reader["Valeur"].ToString() + "</p>"));
                Qu8.Controls.Add(new LiteralControl("</div>"));
            }
            reader.Close();
            reader.Dispose();
            command.Dispose();
            #endregion

            #region Question 8 Developpement
            query = "SELECT * FROM GetQuestion8Result";
            command = new OleDbCommand(query, conn);
            reader = command.ExecuteReader();
            i = 0;
            while (reader.Read())
            {
                ++i;
                Qu9.Controls.Add(new LiteralControl("<div class=\"comm\">"));
                Qu9.Controls.Add(new LiteralControl("<p>" + i.ToString() + "- " + reader["Valeur"].ToString() + "</p>"));
                Qu9.Controls.Add(new LiteralControl("</div>"));
            }
            reader.Close();
            reader.Dispose();
            command.Dispose();
            #endregion

            #region Question 9 Oui Non
            query = "SELECT * FROM GetQuestion9Result";
            command = new OleDbCommand(query, conn);
            reader = command.ExecuteReader();
            while (reader.Read())
            {
                Qu11Oui.Text = reader["Oui"].ToString() + "%";
                Qu11Non.Text = reader["Non"].ToString() + "%";
            }
            reader.Close();
            reader.Dispose();
            command.Dispose();
            #endregion
        }
        finally
        {
            conn.Close();
        }
    }

}