public async Task <FileResult> Export()
{
List <string> csvRows = new List <string>();
StringBuilder sb = new StringBuilder();
var user_ = await _userManager.FindByEmailAsync(User.Identity.Name);
//header line
csvRows.Add(PrimeSimulatorDocs.GenerateExportHeader().ToString());
//add data from DB
List <trace> list_travaux = await(from T in _context.trace
where T.email == user_.Email
select T).ToListAsync();
var list_a_exporter = PrimeSimulatorDocs.ToDataTable(list_travaux);
foreach (DataRow objRD in list_a_exporter.Rows)
{
sb = new StringBuilder();
// Records Lines
csvRows.Add(PrimeSimulatorDocs.GenerateExportRecordLine(objRD).ToString());
}
var list_CSV = string.Join("\r\n", csvRows);
return(File(Encoding.GetEncoding("ISO-8859-1").GetBytes(list_CSV.ToString()), "application/csv", $"Travaux.csv"));
}
public async Task <ActionResult> Generate()
{
var d = new PrimeSimulatorDocs(_context);
var fileName = "test";
//add Id variable
var doc = await d.Generate(1);
if (doc != null)
{
Response.ContentType = "application/pdf";
Response.Headers.Add("content-disposition", $"inline;filename={HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8)}.pdf");
Response.Headers.Add("Content-Length", doc.Length.ToString());
Response.Body.WriteAsync(doc, 0, doc.Length);
Response.Body.Flush();
return(new EmptyResult());
}
return(View());
}
