public IActionResult Dashboards()
{
var dashboardFiles = Directory.GetFiles($"{environment.ContentRootPath}\\Dashboards", "*.mrt");
var fileNames = new string[dashboardFiles.Length];
var index = 0;
foreach (var filePath in dashboardFiles)
{
fileNames[index++] = Path.GetFileNameWithoutExtension(filePath);
}
ViewBag.FileNames = fileNames;
var fileName = RouteData.Values["id"].ToString();
var report = StiReport.CreateNewDashboard();
report.Load(StiNetCoreHelper.MapPath(this, $"Dashboards/{fileName}.mrt"));
var dashboard = report.Pages[0] as StiDashboard;
ViewBag.ForeHtmlColor = ColorTranslator.ToHtml(dashboard != null ? StiDashboardStyleHelper.GetForeColor(dashboard) : Color.Black);
ViewBag.BackHtmlColor = ColorTranslator.ToHtml(dashboard != null ? StiDashboardStyleHelper.GetDashboardBackColor(dashboard, true) : Color.White);
ViewBag.BackColor = dashboard != null?StiDashboardStyleHelper.GetDashboardBackColor(dashboard, true) : Color.White;
return(View());
}
public ActionResult GetReport()
{
// Cria o relatório
StiReport report = new StiReport();
// Carrega o arquivo de relatório da pasta Reports do projeto
report.Load(StiNetCoreHelper.MapPath(this, "Reports/relatorio_dados.mrt"));
// Criar DataSet com o mesmo nome usado no editor de relatórios
DataSet dataSet = new DataSet("dataSet");
// Criar DataTable com o mesmo nome usado para o DataSource
// no editor de relatórios
DataTable dataTable = new DataTable("Gastos");
// Instrução sql que retorna os dados
// com formatação para Data e Moeda
string sql = @"select CONVERT(VARCHAR(10),Data,103) as Data
,Area
,FORMAT(VALOR, 'c', 'pt-BR') as Valor
from Gastos";
// Preenchendo o DataTable com os dados
// trazidos do banco de dados Sql Server
dataTable = data.retornaDataTable <SqlConnection>(sql);
// Adicionando o DataTable ao DataSet
dataSet.Tables.Add(dataTable);
// Adicionando o DataSet ao relatório
// Informando nome e alias
report.RegData("dataSet", "dataSet", dataSet);
// retorna o relatório com dados para o Visualizador
return(StiNetCoreViewer.GetReportResult(this, report));
}
public IActionResult GetReport()
{
StiReport report = new StiReport();
report.LoadDocument(StiNetCoreHelper.MapPath(this, "Reports/SimpleList.mdc"));
return StiNetCoreViewer.GetReportResult(this, report);
}
public IActionResult PrintB()
{
StiReport sti = new StiReport();
sti.Load(StiNetCoreHelper.MapPath(this, "wwwroot/Report/address.mrt"));
//var ppp = _context.Factor1
// .Include(f => f.IdfactorstateNavigation)
// .Include(a => a.IdproductaddressNavigation)
// .FirstAsync();
var addres = _context.Productaddresses.ToList();
sti.Dictionary.Variables["variableName"].Value = "Yar";
var report = StiReport.CreateNewReport();
var path = StiNetCoreHelper.MapPath(this, "wwwroot/Report/address.mr");
report.Load(path);
return(StiNetCoreReportResponse.ResponseAsPdf(report));
//sti.RegData("st", addres);
return(StiNetCoreViewer.GetReportResult(this, sti));
}
public IActionResult GetReport(string id)
{
// Create the report object and load data from xml file
var report = new StiReport();
// Load report from MDZ document file
// If not found - load from MRT template
switch (id)
{
// Interactive Reports
case "DrillDownSorting":
// Parameters
case "ParametersDetailedCategories":
case "ParametersDetailedOrders":
case "ParametersHighlightCondition":
case "ParametersSelectingCountry":
case "ParametersInvoice":
// {Today} function is used
case "MultiColumnListContainers":
var data = new DataSet("Demo");
data.ReadXml(StiNetCoreHelper.MapPath(this, "Data/Demo.xml"));
report.Load(StiNetCoreHelper.MapPath(this, "ReportTemplates/" + id + ".mrt"));
report.RegData(data);
break;
default:
report.LoadPackedDocument(StiNetCoreHelper.MapPath(this, "ReportSnapshots/" + id + ".mdz"));
break;
}
return(StiNetCoreViewer.GetReportResult(this, report));
}
public IActionResult GetReport()
{
// Loading the report template
var reportPath = StiNetCoreHelper.MapPath(this, "Reports/TwoSimpleLists.mrt");
var report = new StiReport();
report.Load(reportPath);
// Deleting connections in the report template
report.Dictionary.Databases.Clear();
// Loading data from the XML file
var dataPath = StiNetCoreHelper.MapPath(this, "Reports/Data/Demo.xml");
var data = new DataSet();
data.ReadXml(dataPath);
// Registering data in the report
report.RegData(data);
// Syncing the data structure, if required
//report.Dictionary.Synchronize();
return(StiNetCoreViewer.GetReportResult(this, report));
}
public IActionResult Xml()
{
var path = StiNetCoreHelper.MapPath(this, "Reports/Data/XMLFile.xml");
var xml = System.IO.File.ReadAllText(path);
return(Ok(xml));
}
public IActionResult GetReport(string reportPath, string dataKey = null)
{
if (!string.IsNullOrWhiteSpace(reportPath))
{
EnsureAllowAccess(reportPath);
var report = new StiReport();
string contentRootPath = _hostingEnvironment.ContentRootPath;
Stimulsoft.Base.StiLicense.LoadFromFile(contentRootPath + "/Stimulsoft/license.key");
var fullReportPath = StiNetCoreHelper.MapPath(this, reportPath);
report.Load(fullReportPath);
// report.Dictionary.Variables["OrganizationName"].Value = "AwroNore";
// report.Dictionary.Variables["OrganizationLogo"].Value = $"{Request.Scheme}://{Request.Host}{""}";
if (!string.IsNullOrWhiteSpace(dataKey))
{
var reportDatasource = _context.HttpContext.Session.Get <List <ReportDatasourceModel> >(dataKey);
foreach (var item in reportDatasource)
{
report.RegData(item.Name, item.Name, item.Value);
}
report.Render();
}
return(StiNetCoreViewer.GetReportResult(this, report));
}
else
{
//Raise error path is empty;
return(null);
}
}
public IActionResult ReportDesigner()
{
string Report = "demoreport";
var reportPath = HostEnvironment.WebRootPath + "\\Reports\\" + Report + ".mrt";
StiReport report = new StiReport();
//report.Load(reportPath);
///What is the code for desgining from json her
///The link to json is , considering that the json api is protected
///http://localhost:52507/api/Reports/GetEmployees
report.Load(StiNetCoreHelper.MapPath(this, reportPath));
var jsonString = "{ }"; // Your code to autorization and get JSON string
var dataSet = StiJsonToDataSetConverter.GetDataSet(jsonString);
report.RegData("ConnectionName", dataSet);
report.Dictionary.Synchronize();
return(StiNetCoreDesigner.GetReportResult(this, report));
}
public IActionResult GetReport(int id = 1)
{
// Create the report object
StiReport report = new StiReport();
switch (id)
{
// Dynamic sorting
case 1:
report.Load(StiNetCoreHelper.MapPath(this, "Reports/Sorting.mrt"));
break;
// Drill down
case 2:
report.Load(StiNetCoreHelper.MapPath(this, "Reports/ListOfProducts.mrt"));
break;
// Collapsing
case 3:
report.Load(StiNetCoreHelper.MapPath(this, "Reports/GroupWithCollapsing.mrt"));
break;
// Bookmarks
case 4:
report.Load(StiNetCoreHelper.MapPath(this, "Reports/ParametersSelectingCountry.mrt"));
break;
// Parameters
case 5:
report.Load(StiNetCoreHelper.MapPath(this, "Reports/InteractiveCharts.mrt"));
break;
}
return(StiNetCoreViewer.GetReportResult(this, report));
}
public IActionResult GetReport()
{
var report = new StiReport();
//Load and add font to the resources
var fileContent = System.IO.File.ReadAllBytes(StiNetCoreHelper.MapPath(this, "Fonts/Roboto-Black.ttf"));
var resource = new StiResource("Roboto-Black", "Roboto-Black", false, StiResourceType.FontTtf, fileContent, false);
report.Dictionary.Resources.Add(resource);
//Add resource font to the font collection
StiFontCollection.AddResourceFont(resource.Name, resource.Content, "ttf", resource.Alias);
//Create a text component
var dataText = new StiText();
dataText.ClientRectangle = new RectangleD(1, 1, 3, 2);
dataText.Text = "Sample Text";
dataText.Font = StiFontCollection.CreateFont("Roboto-Black", 12, FontStyle.Regular);
dataText.Border.Side = StiBorderSides.All;
report.Pages[0].Components.Add(dataText);
return(StiNetCoreDesigner.GetReportResult(this, report));
}
public IActionResult GetReport(string id)
{
// Create the report object
StiReport report = new StiReport();
// Load report
switch (id)
{
// Load report snapshot
case "1":
report.LoadDocument(StiNetCoreHelper.MapPath(this, "Reports/SimpleList.mdc"));
break;
// Load report template
case "2":
report.Load(StiNetCoreHelper.MapPath(this, "Reports/TwoSimpleLists.mrt"));
break;
// Load report snapshot
default:
report.LoadDocument(StiNetCoreHelper.MapPath(this, "Reports/SimpleList.mdc"));
break;
}
// Load data from XML file for report template
if (!report.IsDocument)
{
DataSet data = new DataSet("Demo");
data.ReadXml(StiNetCoreHelper.MapPath(this, "Reports/Data/Demo.xml"));
report.RegData(data);
}
return(StiNetCoreViewer.GetReportResult(this, report));
}
public IActionResult GetReport()
{
StiReport report = new StiReport();
report.Load(StiNetCoreHelper.MapPath(this, "reports/13contest.mrt"));
return(StiNetCoreViewer.GetReportResult(this, report));
}
public async Task <IActionResult> GetReport()
{
XDocument doc = XDocument.Load("Reports/ReportV3.mrt");
List <XElement> components = doc.Element("StiSerializer").Elements("Pages").Elements("Page1").Elements("Components")
.ToList();
foreach (XElement elem in components)
{
elem.Element("Text1").Element("Text").Value = "31.12.2020";
elem.Element("Text2").Element("Text").Value = "31.03.2021";
elem.Element("Text3").Element("Text").Value = "01.09.2020*";
elem.Element("Text4").Element("Text").Value = "31.12.2020";
elem.Element("Text5").Element("Text").Value = "31.03.2021**";
elem.Element("Text6").Element("Text").Value = "31.03.2021***";
}
doc.Save("Reports/ReportV3.mrt");
StiReport report = new StiReport();
// Загрузит шаблон отчета из папки.
report.Load(StiNetCoreHelper.MapPath(this, "Reports/ReportV3.mrt"));
// Рендерит отчет.
await report.RenderAsync();
// Экспорт в PDF в указанную папку.
await report.ExportDocumentAsync(StiExportFormat.Pdf, @"C:\StimulsoftReports\ReportResult.pdf");
return(Ok("Save success"));
}
public string ProvisionForDepreciationOfFixedAssets([FromBody] JObject data)
{
string startDate = data.GetValue("startDate").ToString();
DateTime sdate = ChangeDateFormat(startDate);
string endDate = data.GetValue("endDate").ToString();
DateTime edate = ChangeDateFormat(endDate);
string companyBranchCode = data.GetValue("companyBranchCode").ToString();
string databaseID = data.GetValue("databaseID").ToString();
StiReport report = new StiReport();
string AccountID = data.GetValue("AccountID").ToString();
var path = StiNetCoreHelper.MapPath(this, "C:/MohamedFahmy/BinHamranAdminPanelFront/src/reports/ProvisionForDepreciationOfFixedAssets.mrt");
report.Load(path);
report["FromDate"] = startDate;
report["ToDate"] = endDate;
report["@STARTDATE"] = sdate;
report["@ENDDATE"] = edate;
report["@CompanyBranchID"] = companyBranchCode;
report["@ACCOUNTID"] = AccountID;
report["@DatabaseID"] = databaseID;
var dbMS_SQL = (StiSqlDatabase)report.Dictionary.Databases["MS SQL"];
dbMS_SQL.ConnectionString = appSettings.Report_Connection;
report.Render(false);
return(report.SaveDocumentJsonToString());
}
public IActionResult GetReport(string id)
{
var report = StiReport.CreateNewDashboard();
report.Load(StiNetCoreHelper.MapPath(this, $"Dashboards/{id}.mrt"));
return(StiNetCoreViewer.GetReportResult(this, report));
}
public IActionResult GetReport()
{
StiReport report = new StiReport();
report.Load(StiNetCoreHelper.MapPath(this, "Reports/relatorio_teste.mrt"));
return(StiNetCoreDesigner.GetReportResult(this, report));
}
public IActionResult GetReport(string id)
{
var report = new StiReport();
report.Load(StiNetCoreHelper.MapPath(this, $"Dashboards/{id}.mrt"));
return(StiNetCoreDesigner.GetReportResult(this, report));
}
public IActionResult GetReport(string id)
{
var report = StiReport.CreateNewDashboard();
report.Load(StiNetCoreHelper.MapPath(this, "/Dashboards/" + id + ".mrt"));
return(StiNetCoreDesigner.GetReportResult(this, report));
}
public IActionResult GetReport()
{
StiReport report = new StiReport();
report.Load(StiNetCoreHelper.MapPath(this, "Reports/TwoSimpleLists.mrt"));
return(StiNetCoreDesignerFx.GetReportResult(this, report));
}
private StiReport GetDashboard()
{
var reportPath = StiNetCoreHelper.MapPath(this, "Dashboards/DashboardChristmas.mrt");
var report = StiReport.CreateNewDashboard();
report.Load(reportPath);
return(report);
}
private StiReport GetReport()
{
var reportPath = StiNetCoreHelper.MapPath(this, "Reports/TwoSimpleLists.mrt");
var report = new StiReport();
report.Load(reportPath);
return(report);
}
public IActionResult GetReport()
{
StiReport report = new StiReport();
report.Load(StiNetCoreHelper.MapPath(this, "Reports/payments-preset.mrt"));
return(StiNetCoreViewer.GetReportResult(this, report));
}
public IActionResult GetReport()
{
var report = new StiReport();
var path = StiNetCoreHelper.MapPath(this, "Reports/Report.mrt");
report.Load(path);
return(StiNetCoreViewer.GetReportResult(this, report));
}
public IActionResult GetReportIEnumerable()
{
StiReport report = new StiReport();
report.Load(StiNetCoreHelper.MapPath(this, "Reports/BusinessObjects_IEnumerable.mrt"));
report.RegData("EmployeeIEnumerable", CreateBusinessObjectsIEnumerable.GetEmployees());
return(StiNetCoreViewer.GetReportResult(this, report));
}
public IActionResult GetReport()
{
// Create the report object
var report = new StiReport();
report.Load(StiNetCoreHelper.MapPath(this, "Reports/TwoSimpleLists.mrt"));
return(StiNetCoreViewer.GetReportResult(this, report));
}
public IActionResult GetReport(string id = "SimpleList")
{
// Create the report object and load data from xml file
var report = new StiReport();
report.Load(StiNetCoreHelper.MapPath(this, "/Reports/" + id + ".mrt"));
return(StiNetCoreDesigner.GetReportResult(this, report));
}
public IActionResult GetReportITypedList()
{
var report = new StiReport();
report.Load(StiNetCoreHelper.MapPath(this, "Reports/BusinessObjects_ITypedList.mrt"));
report.RegData("EmployeeITypedList", CreateBusinessObjectsITypedList.GetEmployees());
return(StiNetCoreViewer.GetReportResult(this, report));
}
public string getReportForDesigner(string reportName)
{
var path = StiNetCoreHelper.MapPath(this, "/Reports/" + reportName + ".mrt");
StreamReader rd = new StreamReader(path);
string data = rd.ReadToEnd();
rd.Close();
return(data);
}
public IActionResult GetReport()
{
// Loading the report template
var reportPath = StiNetCoreHelper.MapPath(this, "Reports/TwoSimpleLists.mrt");
var report = new StiReport();
report.Load(reportPath);
return(StiNetCoreDesigner.GetReportResult(this, report));
}
