public ActionResult GetSurveyResponse(int surveyResponseID)
{
SurveyRepo repo = new SurveyRepo();
ClientSurveyVM vm = repo.GetSurveyResponse(surveyResponseID);
vm.Questions = vm.QuestionString.Split('?').Where(s => !string.IsNullOrEmpty(s)).ToList();
vm.Responses = vm.ResponseString.Split('~').ToList();
return(PartialView(vm));
}
public ClientSurveyVM GetSurveyResponse(int surveyResponseId)
{
SuperEarthComEntities1 ctx = new SuperEarthComEntities1();
ClientSurveyVM vm = (from c in ctx.Clients
join sr in ctx.SurveyResponses
on c.ID equals sr.ClientID
join s in ctx.Surveys
on sr.SurveyID equals s.ID
where sr.ID == surveyResponseId
select new ClientSurveyVM
{
ClientID = c.ID,
SurveyID = s.ID,
SurveyResponseID = sr.SurveyID,
FirstName = c.FirstName,
MiddleName = c.MiddleName,
LastName = c.LastName,
CreateDate = sr.CreateDate,
QuestionString = s.Questions,
ResponseString = sr.Responses
}).SingleOrDefault();
return(vm);
}
