public ActionResult OpenReport()
{
StiRequestParams requestParams = StiMvcDesigner.GetRequestParams();
System.Web.HttpContext.Current.Session["CurrentStimulsoftFileNameToDesign"] = requestParams.Designer.FileName;
return(StiMvcDesigner.GetReportResult());
}
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 ActionResult ExportReport()
{
StiReport report = StiMvcViewer.GetReportObject();
StiRequestParams parameters = StiMvcViewer.GetRequestParams();
if (parameters.ExportFormat == StiExportFormat.Pdf)
{
// Some actions with report when exporting to PDF
}
return(StiMvcViewer.ExportReportResult(report));
}
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 ActionResult SaveReport()
{
try
{
StiReport report = StiMvcDesigner.GetReportObject();
string fileName = System.Web.HttpContext.Current.Session["CurrentStimulsoftFileNameToDesign"] != null ? System.Web.HttpContext.Current.Session["CurrentStimulsoftFileNameToDesign"].ToString() : null;
if (fileName != null)
{
if (!System.IO.File.Exists(fileName))
{
throw new Exception(string.Format("Unable to save file \"{0}\"! The path to the file is not available. Please use Sava As.", fileName));
}
report.Save(fileName);
}
else
{
StiRequestParams requestParams = StiMvcDesigner.GetRequestParams();
string fileNameFullPath = requestParams.Designer.FileName;
try
{
FileStream f = new FileStream(fileNameFullPath, FileMode.Create, FileAccess.Write);
f.Close();
report.Save(fileNameFullPath);
System.Web.HttpContext.Current.Session["CurrentStimulsoftFileNameToDesign"] = fileNameFullPath;
}
catch
{
throw new Exception(string.Format("Unable to save file \"{0}\"! Please enter a valid file name with FULL path.", fileNameFullPath));
}
}
}
catch (Exception e)
{
System.Web.HttpContext.Current.Session.Remove("CurrentStimulsoftFileNameToDesign");
return(StiMvcDesigner.SaveReportResult(string.Format("An error happened: {0}", e.Message)));
}
return(StiMvcDesigner.SaveReportResult());
}
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));
}
public ActionResult SaveReportAs()
{
string fileNameFullPath = "";
try
{
StiReport report = StiMvcDesigner.GetReportObject();
StiRequestParams requestParams = StiMvcDesigner.GetRequestParams();
fileNameFullPath = requestParams.Designer.FileName;
FileStream f = new FileStream(fileNameFullPath, FileMode.Create, FileAccess.Write);
f.Close();
report.Save(fileNameFullPath);
System.Web.HttpContext.Current.Session["CurrentStimulsoftFileNameToDesign"] = fileNameFullPath;
return(StiMvcDesigner.SaveReportResult(report));
}
catch
{
return(StiMvcDesigner.SaveReportResult(string.Format("Unable to save file \"{0}\"! Please enter a valid file name with FULL path.", fileNameFullPath)));
}
}
public StimulsoftRequestParams(StiRequestParams prms)
{
_prms = prms;
}
