public static void ReadExam(int id)
{
var context = new QuizzingDbContext();
var foundExam = context.Exam.FirstOrDefault(e => e.Id == id);
if (foundExam != null)
{
Console.WriteLine($"Id : {foundExam.Id}");
Console.WriteLine($"Theme : {foundExam.Theme}");
Console.WriteLine($"Description : {foundExam.Description}");
}
}
public static Exam CreateExam(string theme, string description)
{
var context = new QuizzingDbContext();
Exam NewExam = new Exam {
Theme = theme, Description = description
};
context.Exam.Add(NewExam);
context.SaveChanges();
NewExam.Id = context.Exam.FirstOrDefault(e => e.Theme == theme).Id;
return(NewExam);
}
static public aQuestion getQuestion(int id)
{
var context = new QuizzingDbContext();
var tq = context.Question.Where(e => e.Id == id)
.Select(s => new aQuestion
{
Id = s.Id,
eQuestion = s.AQuestion,
}).FirstOrDefault();
tq.eCorrectAnswers = context.CorrectAnswer.Where(c => c.QuestionId == id)
.Include(a => a.Answer)
.Select(b => b.Answer.Answer1).ToList();
tq.eMultyChoices = context.Multiplechoice.Where(c => c.QuestionId == id)
.Include(a => a.Answer)
.Select(b => b.Answer.Answer1).ToList();
return(tq);
}
static public TheQuizzes GetTheQuiz(int id)
{
var context = new QuizzingDbContext();
var tq = context.Exam.Where(e => e.Id == id)
.Select(q => new TheQuizzes
{
Id = q.Id,
Theme = q.Theme,
Description = q.Description
}).FirstOrDefault();
var Q = context.Question.Where(e => e.ExamId == id)
.Select(i => i.Id).ToList();
foreach (var q in Q)
{
tq.theQuestions.Add(getQuestion(q));
}
return(tq);
}
