public QuestionJeu(string question, ReponseJeu[] reponses, int order)
{
this.id = -1;
this.question = question;
this.reponses = reponses;
this.order = order;
}
public Message Exec(Message msg)
{
List<QuestionJeu> questionsJeu = new List<QuestionJeu>();
msg.Data[0] = Mpg_Questions_Jeu.Rq_GetAllQuestions();
Message reponse = CAD.GetInstance().Execute_StockedProcedure(msg);
System.Data.DataSet results = (System.Data.DataSet)reponse.Data[0];
msg.Data[0] = Mpg_Reponses_Jeu.Rq_GetAllReponses();
Message reponseRep = CAD.GetInstance().Execute_StockedProcedure(msg);
System.Data.DataSet resultsRep = (System.Data.DataSet)reponseRep.Data[0];
foreach (System.Data.DataRow row in results.Tables[0].Rows)
{
List<ReponseJeu> reponsesQuestion = new List<ReponseJeu>();
int id = Convert.ToInt32(row[Mpg_Questions_Jeu.CH_ID].ToString());
string intitule= row[Mpg_Questions_Jeu.CH_INTITULE].ToString();
int ordre = Convert.ToInt32(row[Mpg_Questions_Jeu.CH_ORDRE].ToString());
foreach (System.Data.DataRow rowRep in resultsRep.Tables[0].Rows)
{
int idRep = Convert.ToInt32(rowRep[Mpg_Reponses_Jeu.CH_ID].ToString());
int idQues = Convert.ToInt32(rowRep[Mpg_Reponses_Jeu.CH_ID_QUESTION].ToString());
string intituleRep = rowRep[Mpg_Reponses_Jeu.CH_INTITULE].ToString();
int points = Convert.ToInt32(rowRep[Mpg_Reponses_Jeu.CH_POINTS].ToString());
bool isCorrect = bool.Parse(rowRep[Mpg_Reponses_Jeu.CH_ISCORRECT].ToString());
ReponseJeu reponseQues = new ReponseJeu(idRep, idQues, intituleRep, points, isCorrect);
if(reponseQues.ID_Question == id)
reponsesQuestion.Add(reponseQues);
}
questionsJeu.Add(new QuestionJeu(id, intitule, reponsesQuestion.Cast<ReponseJeu>().ToArray(),ordre));
}
msg.Data[0] = questionsJeu.Cast<QuestionJeu>().ToArray();
DebugPrintQuestions((QuestionJeu[])msg.Data[0]);
return msg;
}
private void NewButton_Click(object sender, RoutedEventArgs e)
{
switch (this.type)
{
case CT_Get_Questionnaire.QuestionnaireType.Jeu:
int id = this.questionsJeu[this.questionsJeu.Length - 1].ID;
ReponseJeu[] reps = new ReponseJeu[4];
QuestionJeu questionJ = (new QuestionJeu(id,this.QuestionIntituleLabel.Text, reps, this.questionsJeu.Length+1));
Message msgJ = new Message();
msgJ.Data[0] = CT_Get_Questionnaire.QuestionnaireType.Jeu;
msgJ.Data[1] = questionJ;
new CT_Add_Question().Exec(msgJ);
break;
case CT_Get_Questionnaire.QuestionnaireType.Orientation:
QuestionOrientation questionO = ((QuestionOrientation)this.QuestionListBox.SelectedItem);
questionO.QuestionText = this.QuestionIntituleLabel.Text;
Message msgO = new Message();
msgO.Data[0] = CT_Get_Questionnaire.QuestionnaireType.Orientation;
msgO.Data[1] = questionO;
new CT_Del_Question().Exec(msgO);
break;
}
}
