public async Task <IActionResult> GetP206DataByArticle(SExcelHome sExcelHome)
{
_logger.LogInformation(String.Format(@"****** ExcelController GetP206DataByArticle fired!! ******"));
List <SqlParameter> pc = new List <SqlParameter> {
new SqlParameter("@Article", sExcelHome.article)
};
var data = await _context.GetP206DataByArticle
.FromSqlRaw(" EXECUTE dbo.GetP206DataByArticle @Article ", pc.ToArray())
.ToListAsync();
string title = "";
if (data.Count > 0)
{
title = data[0].Title;
}
else
{
return(Ok("0"));
}
byte[] result = _excelService.CommonExportReportWithATitle(data, "TempP206DataByArticle.xlsx", title);
return(File(result, "application/xlsx", "P206DataByArticle.xlsx"));
}