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