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