public Question GetQuestionById(int id)
{
using (var db = new QuizModel())
{
//This will hand back the question and the collection of answers; load them pls.
var question = db.Questions.Find(id);
db.Entry(question).Collection(q => q.Answers).Load();
return(question);
}
}
public List <Question> GetQuestions()
{
using (var db = new QuizModel())
{
var questions = from q in db.Questions
orderby q.QuestionId descending
select q;
return(questions.ToList());
}
}
public QuestionViewModel GetQuestion()
{
using (var db = new QuizModel())
{
var qList = db.Questions
.Include(j => j.Answers)
.ToList();
return(new QuestionViewModel(qList[_randy.Next(0, qList.Count)]));
}
}
public void UpdateQuestion(Question updateQuestion)
{
using (var db = new QuizModel())
{
//attach question object to the object in the db.
db.Questions.Attach(updateQuestion);
var entry = db.Entry(updateQuestion);
//the Modified indicates and update
entry.State = System.Data.Entity.EntityState.Modified;
foreach (var answer in updateQuestion.Answers)
{
var answerEntry = db.Entry(answer);
answerEntry.State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
}
}