public ReponseOrientation(int id_question, string reponseText, Metier metier)
{
this.id = -1;
this.id_question = id_question;
this.reponseText = reponseText;
this.metier = metier;
}
public ReponseOrientation(SerializationInfo info, StreamingContext ctxt)
{
this.id = (int)info.GetValue("id", typeof(int));
this.id_question = (int)info.GetValue("id_question", typeof(int));
this.reponseText = (string)info.GetValue("reponseText", typeof(string));
this.metier = (Metier)info.GetValue("metier", typeof(Metier));
}
public Message Exec(Message msg)
{
List<QuestionOrientation> questionsOrientation = new List<QuestionOrientation>();
msg.Data[0] = Mpg_Questions_Orientation.Rq_GetAllQuestions();
Message reponse = CAD.GetInstance().Execute_StockedProcedure(msg);
System.Data.DataSet results = (System.Data.DataSet)reponse.Data[0];
msg.Data[0] = Mpg_Reponses_Orientation.Rq_GetAllReponses();
Message reponseRep = CAD.GetInstance().Execute_StockedProcedure(msg);
System.Data.DataSet resultsRep = (System.Data.DataSet)reponseRep.Data[0];
msg.Data[0] = Mpg_Metiers.Rq_GetAllMetiers();
Message reponseMetier = CAD.GetInstance().Execute_StockedProcedure(msg);
System.Data.DataSet resultsMetier = (System.Data.DataSet)reponseRep.Data[0];
foreach (System.Data.DataRow row in results.Tables[0].Rows)
{
List<ReponseOrientation> reponsesQuestion = new List<ReponseOrientation>();
int id = Convert.ToInt32(row[Mpg_Questions_Orientation.CH_ID].ToString());
string intitule = row[Mpg_Questions_Orientation.CH_INTITULE].ToString();
int ordre = Convert.ToInt32(row[Mpg_Questions_Orientation.CH_ORDRE].ToString());
foreach (System.Data.DataRow rowRep in resultsRep.Tables[0].Rows)
{
Metier metier = new Metier("Aucun metier","Aucune description");
int idRep = Convert.ToInt32(rowRep[Mpg_Reponses_Orientation.CH_ID].ToString());
int idQues = Convert.ToInt32(rowRep[Mpg_Reponses_Orientation.CH_ID_QUESTION].ToString());
string intituleRep = rowRep[Mpg_Reponses_Orientation.CH_INTITULE].ToString();
int idMetier = Convert.ToInt32(rowRep[Mpg_Reponses_Orientation.CH_ID_METIER].ToString());
foreach (System.Data.DataRow rowMet in resultsMetier.Tables[0].Rows)
{
int idMet = Convert.ToInt32(rowMet[Mpg_Metiers.CH_ID].ToString());
string intituleMet = rowMet[Mpg_Metiers.CH_INTITULE].ToString();
string descMet = rowMet[Mpg_Metiers.CH_DESCRIPTION].ToString();
if (idMet == idMetier)
metier = new Metier(idMet, intituleMet, descMet);
}
ReponseOrientation reponseQues = new ReponseOrientation(idRep, idQues, intituleRep, metier);
if (reponseQues.ID_Question == id)
reponsesQuestion.Add(reponseQues);
}
questionsOrientation.Add(new QuestionOrientation(id, intitule, reponsesQuestion.Cast<ReponseOrientation>().ToArray(), ordre));
}
msg.Data[0] = questionsOrientation.Cast<QuestionOrientation>().ToArray();
return msg;
}
private void DoCorrection()
{
Metier[] metiers = new Metier[this.reponses.Length];
for(int i = 0; i<this.reponses.Length; i++)
{
ReponseOrientation rep = this.reponses[i];
metiers[i] = rep.Metier;
Projet_Client.Composant_de_communication.MessageManager.Debug(rep.ReponseText + " --> " + rep.Metier.Intitule);
}
List<Metier> metierList = metiers.Cast<Metier>().ToList<Metier>();
var groupsWithCounts = from s in metierList
group s by s into g
select new
{
Item = g.Key,
Count = g.Count()
};
var groupsSorted = groupsWithCounts.OrderByDescending(g => g.Count);
string mostFrequest = groupsSorted.First().Item.Intitule;
MessageBox.Show("Resultat: " + mostFrequest);
this.Close();
}
private void SaveButton_Click(object sender, RoutedEventArgs e)
{
switch (this.type)
{
case CT_Get_Questionnaire.QuestionnaireType.Jeu:
QuestionJeu questionJ = ((QuestionJeu)this.QuestionListBox.SelectedItem);
questionJ.QuestionText = this.QuestionIntituleLabel.Text;
for(int i = 0; i < questionJ.Reponses.Length; i++)
{
bool correct = (this.ReponseIsCorrectChkBox[i].IsChecked.HasValue) ? this.ReponseIsCorrectChkBox[i].IsChecked.Value : false;
questionJ.Reponses[i] = new ReponseJeu(
questionJ.Reponses[i].ID,
questionJ.ID,
this.ReponsesTxtBox[i].Text,
Convert.ToInt32(this.ReponsesPointsTxtBox[i].Text),
correct);
}
Message msgJ = new Message();
msgJ.Data[0] = CT_Get_Questionnaire.QuestionnaireType.Jeu;
msgJ.Data[1] = questionJ;
new CT_Upd_Question().Exec(msgJ);
break;
case CT_Get_Questionnaire.QuestionnaireType.Orientation:
QuestionOrientation questionO = ((QuestionOrientation)this.QuestionListBox.SelectedItem);
questionO.QuestionText = this.QuestionIntituleLabel.Text;
for (int i = 0; i < questionO.Reponses.Length; i++)
{
Metier m = new Metier("Aucun Metier", "Aucune descrition");
foreach(Metier metier in this.RecupListMetierOfQuestionOrientation(questionO))
{
if(metier.Intitule == this.ReponseMMetierComboBox[i].Text)
m = metier;
}
questionO.Reponses[i] = new ReponseOrientation(
questionO.Reponses[i].ID,
questionO.ID,
this.ReponsesTxtBox[i].Text,
m);
}
Message msgO = new Message();
msgO.Data[0] = CT_Get_Questionnaire.QuestionnaireType.Orientation;
msgO.Data[1] = questionO;
new CT_Upd_Question().Exec(msgO);
break;
}
this.refreshQuestionList();
}