public IActionResult ExportReportResponse()
{
StiRequestParams requestParams = StiNetCoreViewer.GetRequestParams(this);
// byte[] data = requestParams.Data;
// string fileName = requestParams.Export.FileName;
// StiExportFormat format = requestParams.Export.Format;
// bool openAfterExport = requestParams.Export.OpenAfterExport;
return(StiNetCoreViewer.ExportReportResponseResult(this));
}
public IActionResult Post()
{
var requestParams = StiNetCoreViewer.GetRequestParams(this);
switch (requestParams.Action)
{
case StiAction.GetReport:
return(GetReportResult());
default:
return(StiNetCoreViewer.ProcessRequestResult(this));
}
}
public async Task <IActionResult> Post(EquipmentInspectionDto model)
{
var requestParams = StiNetCoreViewer.GetRequestParams(this);
switch (requestParams.Action)
{
case StiAction.GetReport:
return(await GetReportResult(model));
default:
return(await StiNetCoreViewer.ProcessRequestResultAsync(this));
}
}
public IActionResult GetReportData()
{
StiRequestParams requestParams = StiNetCoreViewer.GetRequestParams(this);
// JSON data
if (requestParams.Connection.Type == StiConnectionType.JSON)
{
return(StiNetCoreViewer.GetReportDataResult(this, _hostEnvironment.WebRootPath + "\\data\\Demo.json"));
}
// XML data
if (requestParams.Connection.Type == StiConnectionType.XML)
{
string pathData = requestParams.Connection.PathData;
string pathSchema = requestParams.Connection.PathSchema;
string data = pathSchema != null
? System.IO.File.ReadAllText(_hostEnvironment.WebRootPath + "\\" + pathSchema)
: System.IO.File.ReadAllText(_hostEnvironment.WebRootPath + "\\" + pathData);
return(StiNetCoreViewer.GetReportDataResult(this, data));
//return StiNetCoreViewer.GetReportDataResult(this, _hostEnvironment.WebRootPath + "\\" + pathData);
}
// SQL data
if (requestParams.Connection.Type == StiConnectionType.MSSQL)
{
string connectionString = requestParams.Connection.ConnectionString;
string queryString = requestParams.Connection.QueryString;
StiDataResult result = new StiDataResult()
{
Columns = new string[2] {
"Column1", "Column2"
},
Types = new string[2] {
"number", "string"
},
Rows = new string[3][] { new string[2] {
"1", "Row1"
}, new string[2] {
"2", "Row2"
}, new string[2] {
"3", "Row3"
} }
};
return(StiNetCoreViewer.GetReportDataResult(this, result));
}
return(StiNetCoreViewer.GetReportDataResult(this));
}
public IActionResult ExportReport()
{
StiReport report = StiNetCoreViewer.GetReportObject(this);
StiRequestParams parameters = StiNetCoreViewer.GetRequestParams(this);
// Some actions with report when exporting
report.ReportName = "MyReportName";
report.ReportAlias = report.ReportName;
if (parameters.ExportFormat == StiExportFormat.Pdf)
{
// Change some export settings when exporting to PDF
StiPdfExportSettings settings = (StiPdfExportSettings)StiNetCoreViewer.GetExportSettings(this);
settings.CreatorString = "My Company";
return(StiNetCoreViewer.ExportReportResult(this, report, settings));
}
return(StiNetCoreViewer.ExportReportResult(this, report));
}
