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); }