public void UpdateQuestionAnswersDal(int QuestionID, int testId, int answerId, int userId, bool isReviewQuestion)
{
using (QuizEntities context = new QuizEntities())
{
TestQuestionsAnswer _testQuestionsAnswer = context.TestQuestionsAnswers.FirstOrDefault(r => r.QuestionID == QuestionID);
_testQuestionsAnswer.AnswerId = answerId;
_testQuestionsAnswer.UserID = userId;
_testQuestionsAnswer.IsReviewQuestion = isReviewQuestion;
context.SaveChanges();
}
}
public void AddQuestionsAnswersDal(int QuestionID, int testId, int answerId, int userId, bool isReviewQuestion)
{
using (QuizEntities context = new QuizEntities())
{
TestQuestionsAnswer _testQuestionsAnswer = new TestQuestionsAnswer()
{
QuestionID = QuestionID,
TestId = testId,
AnswerId = answerId,
UserID = userId,
IsReviewQuestion = isReviewQuestion
};
context.TestQuestionsAnswers.Add(_testQuestionsAnswer);
context.SaveChanges();
}
}
/// <summary>
/// Adds questions with answers given by the user.
/// </summary>
/// <param name="QuestionID"> Given QuestionID</param>
/// <param name="testId"> Given TestID </param>
/// <param name="answersId"> Given AnswerID </param>
public void AddQuestionsAnswersDal(int QuestionID, int testId, List <int> answersId, int userId, bool isReviewQuestion)
{
using (QuizEntities context = new QuizEntities())
{
TestQuestionsAnswer _testQuestionsAnswer = new TestQuestionsAnswer()
{
QuestionID = QuestionID,
TestId = testId,
UserID = userId,
IsReviewQuestion = isReviewQuestion
};
foreach (var answerId in answersId)
{
_testQuestionsAnswer.AnswerId = answerId;
context.TestQuestionsAnswers.Add(_testQuestionsAnswer);
context.SaveChanges();
}
}
}
