Exemplo n.º 1
0
 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);
     }
 }
Exemplo n.º 2
0
        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());
            }
        }
Exemplo n.º 3
0
        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)]));
            }
        }
Exemplo n.º 4
0
        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();
            }
        }