public ActionResult NextTest(int programID, RequestContext _requestContext)
{
ModelState.Clear();
using (OQDevSNAPEntities dbContext = new OQDevSNAPEntities())
{
ClientTestDisplay ctd = new ClientTestDisplay();
ctd.Package = GetPackageActivities(programID);
ctd.TestID = GetTestID(ctd);
return(View("~/Views/Test/CompleteTest.cshtml", ctd));
}
}
public ActionResult StartTest(ClientSelectedProgram viewModel)
{
int proID = 0;
using (OQDevSNAPEntities dbContext = new OQDevSNAPEntities())
{
//ClientProgramDisplay cpd = new ClientProgramDisplay();
//cpd.programID = 1;
//cpd.Activities = GetPackageActivities(cpd.programID);
foreach (string selectedProgram in viewModel.SelectedProgram)
{
int.TryParse(selectedProgram, out proID);
}
}
return(NextTest(proID, this.Request != null ? this.Request.RequestContext : _homeContext));
}
public static List <Package> GetPackageActivities(int programID)
{
List <Package> activities = new List <Package>();
try
{
using (OQDevSNAPEntities dbContext = new OQDevSNAPEntities())
{
var dbActivities = dbContext.GroupPrograms.Include("GroupPackageActivities").Where(g => g.ID == programID).ToList();
foreach (GroupPackageActivity gp in dbActivities[0].GroupPackageActivities.OrderBy(g => g.ActivityDisplayOrder))
{
Package p = new Package();
p.PackageName = gp.GroupPackageName.PackageName;
p.ProgramName = gp.GroupProgram.ProgramName;
p.ActivityName = gp.GroupActivityType.ActivityName;
p.ActivityDisplayName = gp.GroupActivityType.ActivityDisplayName;
p.ActivityID = gp.QuestionnaireType;
if (gp.PackageType == 1) // Pre-Testing Package
{
}
else if (gp.PackageType == 2) // Mid-Session
{
}
else if (gp.PackageType == 3) // Post-Testing Package
{
p.Activities = QuestionnaireRepository.GetQuestionnaireQuestions((string)gp.QuestionnaireType, "en-CA");
activities.Add(p);
}
else // Non-Packages
{
}
//activities.Add(p);
}
}
}
catch (Exception e)
{
throw;
}
return(activities);
}
public static List <Question> GetQuestionnaireQuestions(string questionnaireType, string language)
{
List <Question> questions = new List <Question>();
try
{
using (OQDevSNAPEntities dbContext = new OQDevSNAPEntities())
{
var dbQuestions = dbContext.GroupActivityQuestions.Include("GroupActivityOptions").Include("GroupActivityTexts").Where(
q => q.QuestionnaireType == questionnaireType
).OrderBy(q => q.DisplayOrder).ToList();
foreach (GroupActivityQuestion dbQ in dbQuestions)
{
Question q = new Question();
q.QuestionID = dbQ.QuestionID;
q.QuestionType = dbQ.QuestionType;
var qt = dbQ.GroupActivityTexts.FirstOrDefault(t => t.Language == language);
if (qt != null)
{
q.QuestionText = qt.Text;
q.QuestionNumber = qt.QuestionNumber;
}
foreach (GroupActivityOption o in dbQ.GroupActivityOptions.OrderBy(o => o.DisplayOrder))
{
q.Options.Add(new Option {
Value = o.Value, Text = o.Text
});
}
questions.Add(q);
}
}
}
catch (Exception e)
{
throw;
}
return(questions);
}
public static SelectGroupProgramModel GenerateSelectGroupProgramModel(int programID, string programName)
{
SelectGroupProgramModel gp = new SelectGroupProgramModel {
ID = programID, ProgramName = programName
};
using (OQDevSNAPEntities dbContext = new OQDevSNAPEntities())
{
var wasProgram = dbContext.GroupPrograms.FirstOrDefault(p => p.ProgramName == "WAS");
var oedProgram = dbContext.GroupPrograms.FirstOrDefault(p => p.ProgramName == "OED");
var beProgram = dbContext.GroupPrograms.FirstOrDefault(p => p.ProgramName == "BE");
var bldProgram = dbContext.GroupPrograms.FirstOrDefault(p => p.ProgramName == "BLD");
var ynaProgram = dbContext.GroupPrograms.FirstOrDefault(p => p.ProgramName == "YNA");
var tftbProgram = dbContext.GroupPrograms.FirstOrDefault(p => p.ProgramName == "TFTB");
var rcmProgram = dbContext.GroupPrograms.FirstOrDefault(p => p.ProgramName == "RCM");
var rcwProgram = dbContext.GroupPrograms.FirstOrDefault(p => p.ProgramName == "RCW");
var programs = new List <GroupProgram>();
GroupProgram was = new GroupProgram()
{
SelectorID = wasProgram.ID,
ProgramDisplayName = wasProgram.ProgramDisplayName,
ProgramName = wasProgram.ProgramName,
StartDate = wasProgram.StartDate,
EndDate = wasProgram.EndDate,
ProgramLength = wasProgram.ProgramLength,
ProgramID = wasProgram.ProgramID
};
programs.Add(was);
GroupProgram oed = new GroupProgram()
{
SelectorID = oedProgram.ID,
ProgramDisplayName = oedProgram.ProgramDisplayName,
StartDate = oedProgram.StartDate,
EndDate = oedProgram.EndDate,
ProgramLength = oedProgram.ProgramLength,
ProgramID = oedProgram.ProgramID
};
programs.Add(oed);
GroupProgram be = new GroupProgram()
{
SelectorID = beProgram.ID,
ProgramDisplayName = beProgram.ProgramDisplayName,
StartDate = beProgram.StartDate,
EndDate = beProgram.EndDate,
ProgramLength = beProgram.ProgramLength,
ProgramID = beProgram.ProgramID
};
programs.Add(be);
GroupProgram bld = new GroupProgram()
{
SelectorID = bldProgram.ID,
ProgramDisplayName = bldProgram.ProgramDisplayName,
StartDate = bldProgram.StartDate,
EndDate = bldProgram.EndDate,
ProgramLength = bldProgram.ProgramLength,
ProgramID = bldProgram.ProgramID
};
programs.Add(bld);
GroupProgram yna = new GroupProgram()
{
SelectorID = ynaProgram.ID,
ProgramDisplayName = ynaProgram.ProgramDisplayName,
StartDate = ynaProgram.StartDate,
EndDate = ynaProgram.EndDate,
ProgramLength = ynaProgram.ProgramLength,
ProgramID = ynaProgram.ProgramID
};
programs.Add(yna);
GroupProgram tftb = new GroupProgram()
{
SelectorID = tftbProgram.ID,
ProgramDisplayName = tftbProgram.ProgramDisplayName,
StartDate = tftbProgram.StartDate,
EndDate = tftbProgram.EndDate,
ProgramLength = tftbProgram.ProgramLength,
ProgramID = tftbProgram.ProgramID
};
programs.Add(tftb);
GroupProgram rcm = new GroupProgram()
{
SelectorID = rcmProgram.ID,
ProgramDisplayName = rcmProgram.ProgramDisplayName,
StartDate = rcmProgram.StartDate,
EndDate = rcmProgram.EndDate,
ProgramLength = rcmProgram.ProgramLength,
ProgramID = rcmProgram.ProgramID
};
programs.Add(rcm);
GroupProgram rcw = new GroupProgram()
{
SelectorID = rcwProgram.ID,
ProgramDisplayName = rcwProgram.ProgramDisplayName,
StartDate = rcwProgram.StartDate,
EndDate = rcwProgram.EndDate,
ProgramLength = rcwProgram.ProgramLength,
ProgramID = rcwProgram.ProgramID
};
programs.Add(rcw);
gp.Programs = programs;
}
return(gp);
}
public HomeController()
{
_dbContext = new OQDevSNAPEntities();
}
public static SelectActivityTypeModel GenerateSelectTestModel()
{
SelectActivityTypeModel satm = new SelectActivityTypeModel();
using (OQDevSNAPEntities dbContext = new OQDevSNAPEntities())
{
//All activities in all group programs/workshops
var oqTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "OQ");
var uricaTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "URICA-DV");
var pyoqTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PYOQ");
var yoqTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "YOQ");
var gcsTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "GCS");
var icsTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "ICS");
var sdtTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "SDT");
var rseTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "RSE");
var pasTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PAS");
var tscl40Test = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "TSCL-40");
var preRSFVPTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "Pre RS-FVP");
var famIIITest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "FAM-III");
var pasphTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PASPH");
var pasnpTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PASNP");
var npapsTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "NPAPS");
var papsTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PAPS");
var sesTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "SES");
var iseTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "ISE");
var edi3Test = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "EDI-3");
var csq8Test = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "CSQ-8");
var pfRCMTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PF-RCM");
var dairTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "DAI-R");
var cdi2Test = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "CDI-2");
var sipaTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "SIPA");
var psiTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PSI");
var marFeedTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "Marriage Feedback");
var rcFormTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "RC");
var preDemoFVPTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "Pre Demo-FVP");
var pesTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PES");
var seaTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "SEA Exit");
var preWorkDemoTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "Pre Workshop Demo");
var demoOEDTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "Demo-OED");
var pfOEDTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PF-OED");
var demoBEBLDWASTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "Demo-BE/BLD/WAS");
var pfBETest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PF-BE");
var postDemoFVPTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "Post Demo-FVP");
var pfTFTBTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PF-TFTB");
var postRSFVPTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "Post RS-FVP");
var pfYNATest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PF-YNA");
var pfBLDTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PF-BLD");
var pfWASTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PF-WAS");
var pfRCWTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "PF-RCW");
var codExitTest = dbContext.GroupActivityTypes.FirstOrDefault(t => t.ActivityName == "COD Exit");
var activity = new List <GroupActivityType>();
GroupActivityType oq = new GroupActivityType()
{
ActivityTypeID = oqTest.ActivityTypeID,
ActivityDisplayName = oqTest.ActivityDisplayName,
ActivityName = oqTest.ActivityName
};
activity.Add(oq);
GroupActivityType urica = new GroupActivityType()
{
ActivityTypeID = uricaTest.ActivityTypeID,
ActivityDisplayName = uricaTest.ActivityDisplayName,
ActivityName = uricaTest.ActivityName
};
activity.Add(urica);
GroupActivityType pyoq = new GroupActivityType()
{
ActivityTypeID = pyoqTest.ActivityTypeID,
ActivityDisplayName = pyoqTest.ActivityDisplayName,
ActivityName = pyoqTest.ActivityName
};
activity.Add(pyoq);
GroupActivityType yoq = new GroupActivityType()
{
ActivityTypeID = yoqTest.ActivityTypeID,
ActivityDisplayName = yoqTest.ActivityDisplayName,
ActivityName = yoqTest.ActivityName
};
activity.Add(yoq);
GroupActivityType gcs = new GroupActivityType()
{
ActivityTypeID = gcsTest.ActivityTypeID,
ActivityDisplayName = gcsTest.ActivityDisplayName,
ActivityName = gcsTest.ActivityName
};
activity.Add(gcs);
GroupActivityType ics = new GroupActivityType()
{
ActivityTypeID = icsTest.ActivityTypeID,
ActivityDisplayName = icsTest.ActivityDisplayName,
ActivityName = icsTest.ActivityName
};
activity.Add(ics);
GroupActivityType sdt = new GroupActivityType()
{
ActivityTypeID = sdtTest.ActivityTypeID,
ActivityDisplayName = sdtTest.ActivityDisplayName,
ActivityName = sdtTest.ActivityName
};
activity.Add(sdt);
GroupActivityType rse = new GroupActivityType()
{
ActivityTypeID = rseTest.ActivityTypeID,
ActivityDisplayName = rseTest.ActivityDisplayName,
ActivityName = rseTest.ActivityName
};
activity.Add(rse);
GroupActivityType pas = new GroupActivityType()
{
ActivityTypeID = pasTest.ActivityTypeID,
ActivityDisplayName = pasTest.ActivityDisplayName,
ActivityName = pasTest.ActivityName
};
activity.Add(pas);
GroupActivityType tscl40 = new GroupActivityType()
{
ActivityTypeID = tscl40Test.ActivityTypeID,
ActivityDisplayName = tscl40Test.ActivityDisplayName,
ActivityName = tscl40Test.ActivityName
};
activity.Add(tscl40);
GroupActivityType preRSFVP = new GroupActivityType()
{
ActivityTypeID = preRSFVPTest.ActivityTypeID,
ActivityDisplayName = preRSFVPTest.ActivityDisplayName,
ActivityName = preRSFVPTest.ActivityName
};
activity.Add(preRSFVP);
GroupActivityType famIII = new GroupActivityType()
{
ActivityTypeID = famIIITest.ActivityTypeID,
ActivityDisplayName = famIIITest.ActivityDisplayName,
ActivityName = famIIITest.ActivityName
};
activity.Add(famIII);
GroupActivityType pasph = new GroupActivityType()
{
ActivityTypeID = pasphTest.ActivityTypeID,
ActivityDisplayName = pasphTest.ActivityDisplayName,
ActivityName = pasphTest.ActivityName
};
activity.Add(pasph);
satm.Activity = activity;
}
return(satm);
}
