// Edit \\ public void EditQuestion(ThemeListQuestionsVM ViewModel) { using (var db = new QuestionnaireDbContext()) { Theme TempTheme = db.ThemesDb.Where(x => x.ThemeID == ViewModel.Theme.ThemeID).Include(y => y.Questions).FirstOrDefault(); TempTheme.Questions = db.QuestionsDb.Where(x => ViewModel.CheckedQuestionIDs.Contains(x.QuestionID)).Include(y => y.Answers).ToList(); db.Entry(TempTheme).State = EntityState.Modified; db.SaveChanges(); } }
// Edit \\ public void EditQuestionnaire(QuestionnaireThemesVM ViewModel) { using (var db = new QuestionnaireDbContext()) { Questionnaire_ TempQuestionnaire = db.QuestionnairesDb.Where(x => x.QuestionnaireID == ViewModel.Questionnaire.QuestionnaireID).Include(y => y.Themes.Select(z => z.Questions.Select(za => za.Answers))).FirstOrDefault(); TempQuestionnaire.Themes = db.ThemesDb.Where(x => ViewModel.CheckedThemeIDs.Contains(x.ThemeID)).Include(y => y.Questions.Select(z => z.Answers)).ToList(); db.Entry(TempQuestionnaire).State = EntityState.Modified; db.SaveChanges(); } }
// Edit \\ public void EditQuestion(Question question, List <string> lista, string CorrectAnswerPoss) { using (var db = new QuestionnaireDbContext()) { Question TempQuestion = db.QuestionsDb.Where(x => x.QuestionID == question.QuestionID).Include(y => y.Answers).FirstOrDefault(); for (int i = 0; i < TempQuestion.Answers.Count; i++) { TempQuestion.Answers.ElementAt(i).IsCorrect = false; TempQuestion.Answers.ElementAt(i).AnswerValue = lista[i]; if (CorrectAnswerPoss == i.ToString()) { TempQuestion.Answers.ElementAt(i).IsCorrect = true; } } // Debug.WriteLine("AnswerCount:" + TempQuestion.Answers.Count); db.Entry(TempQuestion).State = EntityState.Modified; db.SaveChanges(); } }