// Get \\ public List <Question> GetQuestions() { using (var db = new QuestionnaireDbContext()) { return(db.QuestionsDb.ToList()); } }
// Add | Save | Create \\ public void CreateQuestion(Question question) { using (var db = new QuestionnaireDbContext()) { db.QuestionsDb.Add(question); db.SaveChanges(); } }
// Get \\ public List <Questionnaire_> GetQuestionnaires() { using (var db = new QuestionnaireDbContext()) { List <Questionnaire_> Questionnaires = db.QuestionnairesDb.Include(x => x.Themes.Select(y => y.Questions.Select(z => z.Answers))).ToList(); return(Questionnaires); } }
// Get \\ public List <Theme> GetThemes() { using (var db = new QuestionnaireDbContext()) { List <Theme> themes = db.ThemesDb.Include(x => x.Questions.Select(y => y.Answers)).ToList(); return(db.ThemesDb.ToList()); } }
public Questionnaire_ GetQuestionnaire(int?Id) { using (var db = new QuestionnaireDbContext()) { Questionnaire_ Questionnairee = db.QuestionnairesDb.Where(x => x.QuestionnaireID == Id).Include(y => y.Themes.Select(z => z.Questions.Select(za => za.Answers))).FirstOrDefault(); return(Questionnairee); } }
// Add | Save | Create \\ public void CreateQuestionnaireVM(QuestionnaireThemesVM ViewModel) { using (var db = new QuestionnaireDbContext()) { ViewModel.Questionnaire.Themes = db.ThemesDb.Where(x => ViewModel.CheckedThemeIDs.Contains(x.ThemeID)).Include(y => y.Questions.Select(z => z.Answers)).ToList(); db.QuestionnairesDb.Add(ViewModel.Questionnaire); db.SaveChanges(); } }
public Question GetQuestion(int?Id) { using (var db = new QuestionnaireDbContext()) { var questions = db.QuestionsDb.Where(x => x.QuestionID == Id).Include(y => y.Answers).ToList(); Debug.WriteLine("AnswerCount:" + questions.FirstOrDefault().Answers.Count); return(questions.FirstOrDefault()); } }
// Delete \\ public void DeleteQuestion(int Id) { using (var db = new QuestionnaireDbContext()) { Question question = db.QuestionsDb.Find(Id); db.QuestionsDb.Remove(question); db.SaveChanges(); } }
//// Add | Save | Create \\ public void CreateTheme(ThemeListQuestionsVM ViewModel) { using (var db = new QuestionnaireDbContext()) { ViewModel.Theme.Questions = db.QuestionsDb.Where(question => ViewModel.CheckedQuestionIDs.Contains(question.QuestionID)).Include(y => y.Answers).ToList(); db.ThemesDb.Add(ViewModel.Theme); db.SaveChanges(); } }
public Theme GetTheme(int?Id) { using (var db = new QuestionnaireDbContext()) { Theme theme = db.ThemesDb.Include(x => x.Questions).Where(x => x.ThemeID == Id).FirstOrDefault(); Debug.WriteLine("AnswerCount:" + theme.Questions.Count); return(theme); } }
public ThemeListQuestionsVM GetThemeVM(int?Id) { using (var db = new QuestionnaireDbContext()) { ThemeListQuestionsVM ViewModel = new ThemeListQuestionsVM(); ViewModel.Theme = db.ThemesDb.Include(x => x.Questions).Where(x => x.ThemeID == Id).FirstOrDefault(); return(ViewModel); } }
public QuestionnaireThemesVM GetQuestionnairesVM() { using (var db = new QuestionnaireDbContext()) { QuestionnaireThemesVM ViewModel = new QuestionnaireThemesVM(); ViewModel.Themes = db.ThemesDb.ToList(); return(ViewModel); } }
public QuestionnaireThemesVM GetQuestionnairesVM(int?id) { using (var db = new QuestionnaireDbContext()) { QuestionnaireThemesVM ViewModel = new QuestionnaireThemesVM(); ViewModel.Themes = db.ThemesDb.ToList(); ViewModel.Questionnaire = db.QuestionnairesDb.Where(x => x.QuestionnaireID == id).Include(y => y.Themes.Select(z => z.Questions.Select(za => za.Answers))).FirstOrDefault(); return(ViewModel); } }
// 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(); } }
public QuestionAnswersVM GetQuestionViewModel(int?Id) { using (var db = new QuestionnaireDbContext()) { QuestionAnswersVM ViewModel = new QuestionAnswersVM(); Question questions = db.QuestionsDb.Where(x => x.QuestionID == Id).Include(y => y.Answers).FirstOrDefault(); ViewModel.Question = questions; Debug.WriteLine("AnswerCount :" + questions.Answers.Count); Debug.WriteLine("AnswerCountViewModel :" + ViewModel.Question.Answers.Count); return(ViewModel); } }
public ThemeListQuestionsVM GetThemesVM() { using (var db = new QuestionnaireDbContext()) { ThemeListQuestionsVM ViewModel = new ThemeListQuestionsVM(); //Get All Questions var questionlist = db.QuestionsDb.Include(y => y.Answers).ToList(); ViewModel.Questions = questionlist; Debug.WriteLine("QuestionCount :" + questionlist.Count); Debug.WriteLine("QuestionCountViewModel :" + ViewModel.Questions.Count); return(ViewModel); } }
// 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(); } }
public void CreateQuestion(QuestionAnswersVM ViewModel) { using (var db = new QuestionnaireDbContext()) { for (int i = 0; i < ViewModel.Answers.Count(); i++) { if (ViewModel.CorrectAnswerID == "{ i = " + i + " }") { db.AnswersDb.Add(new Answer { AnswerValue = ViewModel.Answers[i], IsCorrect = true }); } else { db.AnswersDb.Add(new Answer { AnswerValue = ViewModel.Answers[i], IsCorrect = false }); } } db.QuestionsDb.Add(ViewModel.Question); db.SaveChanges(); } }
public LogQuestionnaireRepository(QuestionnaireDbContext context) { _context = context; }
public FormSettingRepository(QuestionnaireDbContext context) { this.context = context; }
public QuestionnaireRepository(QuestionnaireDbContext context) { this.context = context; }