public void UpdateQuestionaire(string qType, string myData, string myDataKey) //single view update
{
Questionaire uQ = JsonConvert.DeserializeObject <Questionaire>(myData);
Questionaire dataKey = JsonConvert.DeserializeObject <Questionaire>(myDataKey);
if (qType == "enumeration")
{
string[] keyID = dataKey.ansKeyID.Split('|');
string[] key = uQ.ansKey.Split('|');
for (short c = 0; c < (key.Length - 1); c++)
{
Main.fileManagement("UPDATE [key]" +
"SET [ans_key] = '" + key[c].Replace("'", "''").Trim() + "'" +
"WHERE [key_id] = " + Convert.ToInt32(keyID[c]));
}
}
else
{
Main.fileManagement("EXEC [uspUpdateQuestionaire] @qID = " + dataKey.qID + ", @cID1 = " + dataKey.cID1 + ", @cID2 = " + dataKey.cID2 + ", @cID3 = " + dataKey.cID3 + ", @cID4 = " + dataKey.cID4 + ", @ansKeyID = " + dataKey.ansKeyID + ", " +
"@qType = '" + qType + "', @question = '" + uQ.question + "', @c1 = '" + uQ.choiceA + "', @c2 = '" + uQ.choiceB + "', @c3 = '" + uQ.choiceC + "', @c4 = '" + uQ.choiceD + "', @ansKey = '" + uQ.ansKey + "'");
}
}
public void addQuestion(string questionaire)
{
Questionaire cq = JsonConvert.DeserializeObject <Questionaire>(questionaire);
if (cq.type == "multiple choice")
{
Main.fileManagement("EXEC [uspCreateQuestion] @examID = " + examID + ", @qType = '" + cq.type + "', @question = '" + cq.question + "', @c1 = '" + cq.choiceA + "', @c2 = '" + cq.choiceB + "', @c3 = '" + cq.choiceC + "', @c4 = '" + cq.choiceD + "', @ansKey = '" + cq.ansKey + "'");
}
else if (cq.type == "true or false")
{
Main.fileManagement("EXEC [uspCreateQuestion] @examID = " + examID + ", @qType = '" + cq.type + "', @question = '" + cq.question + "', @c1 = '" + cq.choiceA + "', @c2 = '" + cq.choiceB + "', @ansKey = '" + cq.ansKey + "'");
}
else if (cq.type == "enumeration")
{
if (examID == 0)
{
examID = Main.dataCounter("SELECT MAX([exam_id]) FROM [exam]");
}
Main.fileManagement("INSERT INTO [exam_question]([question], [exam_id], [type])" +
"VALUES('" + cq.question.Replace("'", "''").Trim() + "', " + examID + ", '" + cq.type + "')");
qID = Main.dataCounter("SELECT MAX([question_id])" +
"FROM [exam_question]" +
"WHERE [exam_id] = " + examID);
string[] ans = cq.ansKey.Split('|');
for (short i = 0; i < (ans.Length - 1); i++)
{
Main.fileManagement("INSERT INTO [key]([ans_key], [question_id])" +
"VALUES('" + ans[i].Replace("'", "''").Trim() + "', " + qID + ")");
}
}
else
{
Main.fileManagement("EXEC [uspCreateQuestion] @examID = " + examID + ", @qType = '" + cq.type + "', @question = '" + cq.question + "', @ansKey = '" + cq.ansKey + "'");
}
}