// 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 ActionResult Edit(QuestionnaireThemesVM ViewModel)
{
if (ModelState.IsValid)
{
QuestionnaireServ.EditQuestionnaire(ViewModel);
return(RedirectToAction("Index"));
}
return(View(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 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();
}
}
// GET: Questionnaire/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
QuestionnaireThemesVM ViewModel = QuestionnaireServ.GetQuestionnairesVM(id);
if (ViewModel == null)
{
return(HttpNotFound());
}
return(View(ViewModel));
}
// GET: Questionnaire/Create
public ActionResult Create()
{
QuestionnaireThemesVM ViewModel = QuestionnaireServ.GetQuestionnairesVM();
return(View(ViewModel));
}
