public ActionResult DeleteConfirmed(int id)
{
Theme theme = db.ThemesDb.Find(id);
db.ThemesDb.Remove(theme);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// Add | Save | Create \\
public void CreateQuestion(Question question)
{
using (var db = new QuestionnaireDbContext())
{
db.QuestionsDb.Add(question);
db.SaveChanges();
}
}
public ActionResult DeleteConfirmed(int id)
{
Questionnaire_ questionnaire_ = db.QuestionnairesDb.Find(id);
db.QuestionnairesDb.Remove(questionnaire_);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// 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();
}
}
//// 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();
}
}
// Delete \\
public void DeleteQuestion(int Id)
{
using (var db = new QuestionnaireDbContext())
{
Question question = db.QuestionsDb.Find(Id);
db.QuestionsDb.Remove(question);
db.SaveChanges();
}
}
// 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();
}
}
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();
}
}