public async Task <JsonResult> getSurvey(int eventId, string apiKey)
{
if (_context.Users.FirstOrDefault(n => n.apiKey == apiKey) == null)
{
var obj = "Вы не авторизовались";
return(new JsonResult(new { error = obj }));
}
else
{
EventDB eventDb = new EventDB();
List <int> idOfQuestions = eventDb.GetIdOfQuestions(_context, eventId);
List <Surveys> sv = new List <Surveys>();
foreach (var id in idOfQuestions)
{
Question question = _context.Questions.FirstOrDefault(n => n.QuestionId == id);
int countOfRespondents = eventDb.GetCountOfRespondents(_context, id);
string type = eventDb.GetTypeOfQuestion(_context, id);
Surveys survey = new Surveys();
survey.countOfRespondents = countOfRespondents;
// survey.type = type;
// necessaryInfo.Add(question.Questions, survey);
// Excel.Application ex = new Excel.Application();
// ex.Visible = true;//отобразить excel
// ex.SheetsInNewWorkbook = 1;//количество листов в рабочей книге
/*Excel.Workbook workbook = ex.Workbooks.Add(Type.Missing);//добавляем рабочую книгу
* ex.DisplayAlerts = false;
* Excel.Worksheet sheet = (Excel.Worksheet)ex.Worksheets.get_Item(1);//получаем первый лист документа
* sheet.Name = "Результаты опроса " + question.Questions;
* string directory = @"C:\Users\Елизавета\source\repos\Evect\Evect\bin\ExcelFilesresults" + "2" + ".xls";
* ex.Application.ActiveWorkbook.SaveAs(directory, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange,
* Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
* survey.excelDirectory = directory;
* necessaryInfo.Add(question.Questions, survey);
*
*/
}
var obj = new { sv };
return(new JsonResult(obj));
}
///+сделать с возврат экселевских файлов
}