// 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 Resultat(Sondage vote, int nbreVoteReponse1, int nbreVoteReponse2, int nbreVoteReponse3, int nbreTotalVotant, int fK_Id_sondage)
{
Vote = vote;
NbreVoteReponse1 = nbreVoteReponse1;
NbreVoteReponse2 = nbreVoteReponse2;
NbreVoteReponse3 = nbreVoteReponse3;
NbreTotalVotant = nbreTotalVotant;
FK_Id_sondage = fK_Id_sondage;
}
// REQUETE SQL POUR SAVOIR L'ETAT DU SONDAGE EN BDD
public static void EtatDuSondageMiseAjour(Sondage sondage)
{
using (SqlConnection connection = new SqlConnection(ConnectString))
{
connection.Open();
SqlCommand command = new SqlCommand("UPDATE Sondage SET ActiveSondage = 1 WHERE ID= @idSond ", connection);
command.Parameters.AddWithValue("@idSond", sondage.ID);
command.ExecuteNonQuery();
}
}
public Resultat(Sondage vote, int nbreVoteReponse1, int nbreVoteReponse2, int nbreVoteReponse3, int nbreTotalVotant, int fK_Id_sondage, int poucentageRep1, int poucentageRep2, int poucentageRep3)
{
Vote = vote;
NbreVoteReponse1 = nbreVoteReponse1;
NbreVoteReponse2 = nbreVoteReponse2;
NbreVoteReponse3 = nbreVoteReponse3;
NbreTotalVotant = nbreTotalVotant;
FK_Id_sondage = fK_Id_sondage;
PoucentageRep1 = poucentageRep1;
PoucentageRep2 = poucentageRep2;
PoucentageRep3 = poucentageRep3;
}
// CREATION D'UN SONDAGE ET INSERTION EN BASE DE DONNEES
public static int CreerNouveauSondage(Sondage nouvoSondage)
{
using (SqlConnection connection = new SqlConnection(ConnectString))
{
connection.Open();
SqlCommand command = new SqlCommand("Insert into Sondage(Questions,Reponse1,Reponse2,Reponse3,Choix,ActiveSondage) OUTPUT Inserted.ID VALUES (@question,@rep1,@rep2,@rep3,@choix,@nonActif)", connection);
command.Parameters.AddWithValue("@question", nouvoSondage.Questions);
command.Parameters.AddWithValue("@rep1", nouvoSondage.Reponse1);
command.Parameters.AddWithValue("@rep2", nouvoSondage.Reponse2);
command.Parameters.AddWithValue("@rep3", nouvoSondage.Reponse3);
command.Parameters.AddWithValue("@choix", nouvoSondage.Choix);
command.Parameters.AddWithValue("@nonActif", nouvoSondage.ActiveSondage);
int idInserer = (int)command.ExecuteScalar();
return(idInserer);
}
}
// PAGE VOTE SELECTION DES ELEMENTS DE MON SONDAGE POUR POUVOIR VOTER Recuperation de l'id du sondage
public static Sondage PageDeVote(int idSondage)
{
using (SqlConnection connection = new SqlConnection(ConnectString))
{
connection.Open();
SqlCommand command = new SqlCommand("Select * FROM Sondage WHERE ID=@idSondage", connection);
command.Parameters.AddWithValue("@idSondage", idSondage);
SqlDataReader dataReader = command.ExecuteReader();
dataReader.Read();
int id = (int)dataReader["ID"];
string question = (string)dataReader["Questions"];
string reponse1 = (string)dataReader["Reponse1"];
string reponse2 = (string)dataReader["Reponse2"];
string reponse3 = (string)dataReader["Reponse3"];
bool choix = (bool)dataReader["Choix"];
bool actifOuPas = (bool)dataReader["ActiveSondage"];
Sondage sondage = new Sondage(id, question, reponse1, reponse2, reponse3, choix, actifOuPas);
return(sondage);
}
}
// REQUETE DESACTIVATION SONDAGE
public static Sondage DesactiverSondage(int idSondage)
{
using (SqlConnection connection = new SqlConnection(ConnectString))
{
connection.Open();
SqlCommand command = new SqlCommand(@"SELECT * FROM Sondage,Resultat WHERE ID = @idSond and FK_Id_sondage = @idSond", connection);
command.Parameters.AddWithValue("@idSond", 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"];
Sondage sondage = new Sondage(idsondage, question, reponse1, reponse2, reponse3, choix, actifOuPas);
return(sondage);
}
}
public creationsondage(Sondage nouvoSondage)
{
NouvoSondage = nouvoSondage;
}
public ResultatVote(Sondage resultatVoteSondage, Resultat resultatVoteResultat)
{
ResultatVoteSondage = resultatVoteSondage;
ResultatVoteResultat = resultatVoteResultat;
}