public ActionResult _Question(int Id)
{
ManageCertificateViewModel VM = new ManageCertificateViewModel();
using (ApplicationDbContext data = new ApplicationDbContext())
{
VM.Questions = data.Questions.Where(x => x.SectionId == Id).ToList();
wid.SectioId = Id;
VM.wizardIds = wid;
int CertId = data.Sections.FirstOrDefault(f => f.Id == Id).Module.Assessment.CertificationId;
data.Modules.Include("Sections.Questions").Where(w => w.Assessment.CertificationId == CertId).ToList().ForEach(f =>
{
List <Question> questions = new List <Question>();
f.Sections.ToList().ForEach(ff =>
{
questions.AddRange(ff.Questions);
});
if (questions.Count() > 0)
{
TestAndQuestion TQ = new TestAndQuestion()
{
Test = f, Questions = questions
};
VM.TestAndQuestions.Add(TQ);
}
});
}
return(PartialView(VM));
}
public ActionResult _Certificate()
{
ManageCertificateViewModel VM = new ManageCertificateViewModel();
using (ApplicationDbContext data = new ApplicationDbContext())
{
VM.Certificates = data.Certifications.ToList();
VM.wizardIds = wid;
}
return(PartialView(VM));
}
public ActionResult LoadQuestionBySections(int Id)
{
ManageCertificateViewModel VM = new ManageCertificateViewModel();
using (ApplicationDbContext data = new ApplicationDbContext())
{
VM.Questions = data.Questions.Where(X => X.SectionId == Id).ToList();
wid.SectioId = Id;
VM.wizardIds = wid;
}
return(null);
}
public ActionResult _Section(int Id)
{
ManageCertificateViewModel VM = new ManageCertificateViewModel();
using (ApplicationDbContext data = new ApplicationDbContext())
{
VM.Sections = data.Sections.Where(X => X.ModuleId == Id).ToList();
wid.ModuleId = Id;
VM.wizardIds = wid;
}
return(PartialView(VM));
}
public ActionResult LoadAnswersByQuestion(int Id)
{
ManageCertificateViewModel VM = new ManageCertificateViewModel();
using (ApplicationDbContext data = new ApplicationDbContext())
{
VM.Answers = data.Answers.Where(X => X.QuestionId == Id).ToList();
wid.AnswerId = Id;
VM.wizardIds = wid;
}
return(null);
}
public ActionResult LoadModulesByAssessment(int Id)
{
ManageCertificateViewModel VM = new ManageCertificateViewModel();
using (ApplicationDbContext data = new ApplicationDbContext())
{
VM.Modules = data.Modules.Where(X => X.AssessmentId == Id).ToList();
wid.AssessmentId = Id;
VM.wizardIds = wid;
}
return(null);
}
public ActionResult LoadAssessmentByCertification(int Id)
{
ManageCertificateViewModel VM = new ManageCertificateViewModel();
using (ApplicationDbContext data = new ApplicationDbContext())
{
VM.Assessments = data.Assessments.Where(X => X.CertificationId == Id).ToList();
}
wid.CertificationId = Id;
VM.wizardIds = wid;
return(null);
}
public ActionResult _Answer(int Id)
{
ManageCertificateViewModel VM = new ManageCertificateViewModel();
using (ApplicationDbContext data = new ApplicationDbContext())
{
int TestId = data.Questions.FirstOrDefault(f => f.Id == Id).Section.Module.Id;
VM.Answers = data.Answers.Where(x => x.QuestionId == Id).ToList();
wid.QuestionId = Id;
VM.wizardIds = wid;
VM.AllQuestions = data.Questions.Include("Answers").Where(w => w.Section.Module.Id == TestId).ToList();
}
return(PartialView(VM));
}
public ActionResult _Assessment(int Id)
{
ManageCertificateViewModel VM = new ManageCertificateViewModel();
using (ApplicationDbContext data = new ApplicationDbContext())
{
VM.Assessments = data.Assessments.Where(X => X.CertificationId == Id).ToList();
VM.Material = data.Material.Where(w => w.CertificationId == Id && w.Active == true).ToList();
wid.CertificationId = Id;
VM.wizardIds = wid;
}
return(PartialView(VM));
}
// GET: ManageCertifications
public ActionResult ManageCertifications()
{
ManageCertificateViewModel VM = new ManageCertificateViewModel();
using (ApplicationDbContext data = new ApplicationDbContext())
{
VM.Certificates = data.Certifications.ToList();
VM.Assessments = data.Assessments.ToList();
VM.Modules = data.Modules.ToList();
VM.Sections = data.Sections.ToList();
VM.Questions = data.Questions.ToList();
VM.Answers = data.Answers.ToList();
VM.wizardIds = wid;
}
return(View(VM));
}
public ActionResult DeleteAnswer(int Id)
{
ManageCertificateViewModel VM = new ManageCertificateViewModel();
using (ApplicationDbContext data = new ApplicationDbContext())
{
var results = data.Answers.FirstOrDefault(X => X.id == Id);
if (results != null)
{
data.Answers.Remove(results);
data.SaveChanges();
}
VM.Answers = data.Answers.ToList();
VM.wizardIds = wid;
}
return(PartialView("_Answer", VM));
}
