// 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;
}
