public Questionnaire()
{
id = 1;
dsn = "Server=LOUCAZ\\SQLEXPRESS;User Id=user;Password=1234;";
QuestionnairePath = "@C:\\Users\\Loucaz\\source\\repos\\Quiz\\WebApplication3\\jquizzy\\init.js";
QuestionnaireUrl = "@https://localhost:44393/jquizzy/jquizzy.htm";
//dsn = Context.Application["dsn"].ToString();
//ChargeProprietes((DataTable)Context.Application["composants"]);
//Chargement de données
DataOlinwone = new DataServices(dsn);
//Charge le questionnaire
MonQuestionnaire = ChargeData(Requetes.Questionnaire, id);
//Charge les questions
MesQuestions = ChargeData(Requetes.Questions, id);
//Charge les options
MesReponses = ChargeData(Requetes.Options, id);
//Fermer la connexion
DataOlinwone.CloseConnection();
if (CheckChargement)
{
//Traitement des données
IList <Question> json = new List <Question> {
};
foreach (DataRow Item in MesQuestions.Rows)
{
Question result = new Question();
result.question = Item["question_valeur"].ToString();
DataRow[] answers = MesReponses.Select($"option_question=" + Item["question_id"]);
foreach (DataRow answer in answers)
{
result.answers.Add(answer["option_valeur"].ToString());
if ((bool)answer["option_correct"])
{
result.correctAnswer = (int)answer["option_rang"];
}
}
//Structure les questions
json.Add(result);
}
//Structure les conclusions
DataRow MesConclusions = MonQuestionnaire.Rows[0];
Conclusion conclusion = new Conclusion
{
perfect = MesConclusions["questionnaire_conclusion1"].ToString(),
excellent = MesConclusions["questionnaire_conclusion2"].ToString(),
good = MesConclusions["questionnaire_conclusion3"].ToString(),
average = MesConclusions["questionnaire_conclusion4"].ToString(),
bad = MesConclusions["questionnaire_conclusion5"].ToString(),
poor = MesConclusions["questionnaire_conclusion6"].ToString(),
worst = MesConclusions["questionnaire_conclusion7"].ToString()
};
//Génération du fichier
string jsonSerializedObj = "var init = { 'questions':" + JsonConvert.SerializeObject(json) + ",'resultComments' :" + JsonConvert.SerializeObject(conclusion) + "};";
//generation automatiquement le nom
File.WriteAllText(QuestionnairePath, jsonSerializedObj);
}
Text = $"<a href=\"" + QuestionnaireUrl + "\">Quiz</a>";
}
