public IActionResult UseQuery()
{
var queryList = new QueryViewModel();
queryList.AddQuery("select top 100 * from Person where IsMale = 0", "Female Person", TableStyles.Medium2);
queryList.AddQuery("select * from Country", "Country", TableStyles.Medium20);
queryList.AddQuery("select * from Car", "Car", TableStyles.Dark2);
queryList.AddQuery("select top 100 * from Person where IsMale = 1", "Male Person", TableStyles.Dark10);
// To use this method you need to configure the Dapper
// See DataLayerConfiguration section
var file = _excelMaker.ExcelMakeByQuery(queryList.GetList());
if (file == null)
{
return(Json("Excel could not be made"));
}
return(File(file, _excelMaker.ContentType(), "MyFile.xlsx"));
}
