public PagedQueryResultModel ProcessSqlScript([FromBody] SavedScriptProcessModel script)
{
if (!User.IsInRole("Administrator"))
{
script.ConnectionStringName = User.Claims.FirstOrDefault(x => x.Type == "Entity").Value.Substring(0, 3);
}
return(dataManager.ProcessSavedSqlScript(script));
}
public async Task Export([FromBody] SavedScriptProcessModel model)
{
if (!User.IsInRole("Administrator"))
{
model.ConnectionStringName = User.Claims.FirstOrDefault(x => x.Type == "Entity").Value.Substring(0, 3);
}
var data = dataManager.ProcessSavedSqlScript(model, true);
var bytesInStream = await ConvertResultToByteArray(data);
if (bytesInStream.Length > 0)
{
HttpContext.Response.ContentType = "application/force-download";
var name = $"attachment; filename=Data-{DateTime.UtcNow:s}.csv";
HttpContext.Response.Headers.Add("content-disposition", name);
await HttpContext.Response.Body.WriteAsync(bytesInStream, 0, bytesInStream.Length);
}
}
