/// <summary>
/// Submits the user's answers
/// </summary>
/// <param name="userID">The ID of the user</param>
/// <param name="testID">The ID of the test</param>
/// <param name="answers">The list of answers that belongs to the user</param>
public static async Task SubmitUsersAnswersAsync(int userID, int testID, List <int> answers)
{
using (MultipleChoiceEntities multipleChoiceEntities = new MultipleChoiceEntities())
{
// Fetch the questions for the test
List <Question> questions = await multipleChoiceEntities.Questions
.Where(x => x.Test_ID == testID)
.ToListAsync();
// Submit the test to the DB
for (int i = 0; i < answers.Count; i++)
{
multipleChoiceEntities.Answers.Add(new Answer()
{
Question_ID = questions[i].Question_ID,
User_ID = userID,
User_Answer = answers[i]
});
}
await multipleChoiceEntities.SaveChangesAsync();
// Submit mark
multipleChoiceEntities.Marks.Add(new Mark()
{
User_ID = userID,
Test_ID = testID,
User_Mark = GetMark(userID, testID)
});
await multipleChoiceEntities.SaveChangesAsync();
}
}
/// <summary>
/// Sets the user type eg. Student or Lecture
/// </summary>
/// <param name="ID">The ID of the user</param>
/// <param name="value">The value to assign to the type</param>
public static void SetType(int ID, string value)
{
using (MultipleChoiceEntities multipleChoiceEntities = new MultipleChoiceEntities())
{
multipleChoiceEntities.Users.FirstOrDefault(x => x.User_ID == ID)
.Type = value;
multipleChoiceEntities.SaveChangesAsync();
}
}
