public async Task ExportToExcel(string GridModel, string gridId, int id, string survey)
{
ExcelExport exp = new ExcelExport();
GridProperties obj = (GridProperties)Syncfusion.JavaScript.Utils.DeserializeToModel(typeof(GridProperties), GridModel);
//Clear if there are any filter columns
//syncfusion bug in exporting while in filter mode
obj.FilterSettings.FilteredColumns.Clear();
grid = gridId;
count = 0;
if (gridId == "Surveys")
{
var surveys = await _prepareService.GetSurveys();
var model = QuestionnaireMapper.ToSurveyManageViewModel(surveys);
var dataSource = model.Surveys.ToList();
var currentDate = DateTime.Today.ToShortDateString().Replace("/", "-");
exp.Export(obj, dataSource, LocalizedStrings.GetString("Questionnaire") + " " /*"Questionnaire "*/ + currentDate + ".xlsx", ExcelVersion.Excel2013, false, false, "flat-saffron");
}
if (gridId == "SurveyItems")
{
var surveys = await _prepareService.GetSurveys(id);
var data = surveys.FirstOrDefault();
var model = QuestionnaireMapper.ToSurveyViewModel(data);
var dataSource = model.SurveyItems.ToList();
var currentDate = DateTime.Today.ToShortDateString().Replace("/", "-");
exp.Export(obj, dataSource, LocalizedStrings.GetString("Questionnaire") + " " /*"Questionnaire "*/ + survey + " " + currentDate + ".xlsx", ExcelVersion.Excel2013, false, false, "flat-saffron");
}
}
public async Task <ActionResult> Index(bool partial = false)
{
var surveys = await _prepareService.GetSurveys();
var model = QuestionnaireMapper.ToSurveyManageViewModel(surveys);
if (partial)
{
return(PartialView(model));
}
return(View(model));
}
public async Task <ActionResult> Detail(int id, bool partial = false)
{
var surveys = await _prepareService.GetSurveys(id);
var survey = surveys.FirstOrDefault();
var model = QuestionnaireMapper.ToSurveyViewModel(survey);
if (partial)
{
return(PartialView(model));
}
return(View(model));
}
