public void AddQuestionToCourse(QuestionDto question, CourseDto course)
{
_dbConnection.Execute(
"INSERT INTO Questions(Id, CourseId, Text, Difficulty, WrongAnswer1, WrongAnswer2, WrongAnswer3, RightAnswer) VALUES(@id, @courseId, @text, @difficulty, @wrongAnswer1, @wrongAnswer2, @wrongAnswer3, @rightAnswer)",
new { id = question.Id, courseId = course.Id, text = question.Text, difficulty = question.Difficulty, wrongAnswer1 = question.WrongAnswer1, wrongAnswer2 = question.WrongAnswer2, wrongAnswer3 = question.WrongAnswer3, rightAnswer = question.RightAnswer });
}
public QuestionDto GetRandomQuestionByCourse(CourseDto course, int difficulty)
{
return(_dbConnection.Query <QuestionDto>(
"SELECT Id, Text, Difficulty, WrongAnswer1, WrongAnswer2, WrongAnswer3, RightAnswer FROM Questions WHERE CourseId = @id AND Difficulty = @diff ORDER BY RANDOM() LIMIT 1",
new { id = course.Id, diff = difficulty }).First());
}
public void AddCourse(CourseDto course)
{
_dbConnection.Execute("INSERT INTO Courses (Id, Name) Values (@id, @name)", new { id = course.Id, name = course.Name });
}
public List <QuestionDto> GetAllQuestionsByCourse(CourseDto course)
{
return(_dbConnection.Query <QuestionDto>("SELECT Id, Text, Difficulty, WrongAnswer1, WrongAnswer2, WrongAnswer3, RightAnswer FROM Questions WHERE CourseId = @id", new { id = course.Id }).ToList());
}
