public async Task <List <ResponseCSV> > GetResponseCSVForCurrentSurvey() { var list = new List <ResponseCSV>(); var response = await GetAllResponsesForCurrentSurvey(); if (response != null && response.Any()) { await LoadQuestionsForCurrentSurvey(); foreach (var r in response) { var csv = new ResponseCSV() { DateEntered = r.DateEntered, Id = r.Id, Survey = CurrentSurvey.SurveyTitle, Question = CurrentSurvey.Questions.First(x => x.Id == r.QuestionId).QuestionText, Option = CurrentSurvey.Questions.First(x => x.Id == r.QuestionId).Options.First(x => x.Id == r.OptionId).OptionText, UserName = r.UserName }; list.Add(csv); } } return(list); }
public async Task <List <ResponseCSV> > GetAllCSVResponsesBySurveyId(int surveyId) { var list = new List <ResponseCSV>(); await LoadSurveyById(surveyId); await LoadQuestionsForCurrentSurvey(); var table = AzureClient.GetTable <Responses>(); var responses = await table.Where(x => x.SurveyId == surveyId).ToListAsync(); if (responses != null && responses.Count > 0) { foreach (var r in responses) { var csv = new ResponseCSV() { DateEntered = r.DateEntered, Id = r.Id, Survey = CurrentSurvey.SurveyTitle, Question = CurrentSurvey.Questions.First(x => x.Id == r.QuestionId).QuestionText, Option = CurrentSurvey.Questions.First(x => x.Id == r.QuestionId).Options.First(x => x.Id == r.OptionId).OptionText, UserName = r.UserName }; list.Add(csv); } } return(list); }