public ListModel <EventLogItem> List([FromBody] ListQueryModel <EventLogListQueryModel> listQuery) { if (listQuery == null) { listQuery = new ListQueryModel <EventLogListQueryModel>(); } if (listQuery.Model == null) { listQuery.Model = new EventLogListQueryModel(); } if (!_sessionContext.HasPermission(Permissions.EventLogFullView)) { listQuery.Model.BranchId = _branchContext.Branch.Id; } if (!_sessionContext.HasPermission(Permissions.EventLogView) && !listQuery.Model.EntityId.HasValue) { throw new PawnshopApplicationException("Ќедостаточно прав дл¤ выполнени¤ данной операции."); } return(new ListModel <EventLogItem> { List = _repository.List(listQuery, listQuery.Model), Count = _repository.Count(listQuery, listQuery.Model) }); }
public string Report([FromBody] ReportQueryModel queryModel) { if (queryModel == null) { throw new ArgumentNullException(nameof(queryModel)); } if (string.IsNullOrWhiteSpace(queryModel.ReportName)) { throw new ArgumentNullException(nameof(queryModel.ReportName)); } var report = new StiReport(); if (queryModel.ReportName == "CashBookReport") { if (!_sessionContext.HasPermission(Permissions.CashBookView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <CashBookQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/CashBookReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.CurrentDate.Date; report["endDate"] = model.CurrentDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["accountId"] = _branchContext.Configuration.CashOrderSettings.CashAccountId; report["chiefAccountantName"] = _branchContext.Configuration.LegalSettings.ChiefAccountantName; report["cashierName"] = _branchContext.Configuration.LegalSettings.CashierName; } else if (queryModel.ReportName == "CashBalanceReport") { if (!_sessionContext.HasPermission(Permissions.CashBalanceView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <CashBalanceQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/CashBalanceReport.mrt")); report["userId"] = _sessionContext.UserId; report["beginDate"] = model.CurrentDate.Date; report["endDate"] = model.CurrentDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["accountId"] = _branchContext.Configuration.CashOrderSettings.CashAccountId; } else if (queryModel.ReportName == "CashReport") { if (!_sessionContext.HasPermission(Permissions.CashReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <CashReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/CashReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = new DateTime(model.Year, model.Month, 1); report["endDate"] = new DateTime(model.Year, model.Month, 1, 23, 59, 59).AddMonths(1).AddDays(-1); report["cashAccountId"] = _branchContext.Configuration.CashOrderSettings.CashAccountId; report["goldAccountId"] = _branchContext.Configuration.CashOrderSettings.GoldCollateralSettings.SellingSettings.CreditId; report["autoAccountId"] = _branchContext.Configuration.CashOrderSettings.CarCollateralSettings.SellingSettings.CreditId; report["goodsAccountId"] = _branchContext.Configuration.CashOrderSettings.GoodCollateralSettings.SellingSettings.CreditId; report["machineryAccountId"] = _branchContext.Configuration.CashOrderSettings.MachineryCollateralSettings.SellingSettings.CreditId; } else if (queryModel.ReportName == "SellingReport") { if (!_sessionContext.HasPermission(Permissions.SellingReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <SellingReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/SellingReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["status"] = model.Status ?? 0; } else if (queryModel.ReportName == "DelayReport") { if (!_sessionContext.HasPermission(Permissions.DelayReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <DelayReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/DelayReport.mrt")); report["beginDelayCount"] = model.BeginDelayCount; report["endDelayCount"] = model.EndDelayCount; report["collateralType"] = model.CollateralType; report["branchId"] = model.BranchId; } else if (queryModel.ReportName == "DailyReport") { if (!_sessionContext.HasPermission(Permissions.DailyReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <DailyReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/DailyReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.CurrentDate.Date; report["endDate"] = model.CurrentDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["accountId"] = _branchContext.Configuration.CashOrderSettings.CashAccountId; } else if (queryModel.ReportName == "ConsolidateReport") { if (!_sessionContext.HasPermission(Permissions.ConsolidateReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <ConsolidateReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/ConsolidateReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["cashAccountId"] = _branchContext.Configuration.CashOrderSettings.CashAccountId; report["goldAccountId"] = _branchContext.Configuration.CashOrderSettings.GoldCollateralSettings.SellingSettings.CreditId ?? 0; report["autoAccountId"] = _branchContext.Configuration.CashOrderSettings.CarCollateralSettings.SellingSettings.CreditId ?? 0; report["goodsAccountId"] = _branchContext.Configuration.CashOrderSettings.GoodCollateralSettings.SellingSettings.CreditId ?? 0; report["machineryAccountId"] = _branchContext.Configuration.CashOrderSettings.MachineryCollateralSettings.SellingSettings.CreditId ?? 0; report["userId"] = _sessionContext.UserId; } else if (queryModel.ReportName == "SfkConsolidateReport") { if (!_sessionContext.HasPermission(Permissions.ConsolidateReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <ConsolidateReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/SfkConsolidateReport.mrt")); report["branchId"] = model.BranchId; if (model.IsPeriod == true) { report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); } else { report["beginDate"] = model.BeginDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); } report["userId"] = _sessionContext.UserId; report["isPeriod"] = model.IsPeriod; } else if (queryModel.ReportName == "DiscountReport") { if (!_sessionContext.HasPermission(Permissions.DiscountReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <DiscountReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/DiscountReport.mrt")); report["branchId"] = model.BranchId; if (model.Month == 0) { report["beginDate"] = new DateTime(model.Year, 1, 1); report["endDate"] = new DateTime(model.Year, 12, 31, 23, 59, 59); } else { report["beginDate"] = new DateTime(model.Year, model.Month, 1); report["endDate"] = new DateTime(model.Year, model.Month, 1, 23, 59, 59).AddMonths(1).AddDays(-1); } } else if (queryModel.ReportName == "AccountCardReport") { if (!_sessionContext.HasPermission(Permissions.AccountCardView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <AccountCardQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/AccountCardReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["accountId"] = model.AccountId; } else if (queryModel.ReportName == "AccountCycleReport") { if (!_sessionContext.HasPermission(Permissions.AccountCycleView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <AccountCycleQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/AccountCycleReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); } else if (queryModel.ReportName == "GoldPriceReport") { if (!_sessionContext.HasPermission(Permissions.GoldPriceView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <GoldPriceQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/GoldPriceReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["queryPrice"] = model.QueryPrice; } else if (queryModel.ReportName == "ExpenseMonthReport") { if (!_sessionContext.HasPermission(Permissions.ExpenseMonthReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <ExpenseMonthReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/ExpenseMonthReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = new DateTime(model.Year, model.Month, 1); report["endDate"] = new DateTime(model.Year, model.Month, 1, 23, 59, 59).AddMonths(1).AddDays(-1); report["userId"] = _sessionContext.UserId; } else if (queryModel.ReportName == "ExpenseYearReport") { if (!_sessionContext.HasPermission(Permissions.ExpenseYearReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <ExpenseYearReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/ExpenseYearReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = new DateTime(model.Year, 1, 1); report["endDate"] = new DateTime(model.Year, 12, 31, 23, 59, 59); report["userId"] = _sessionContext.UserId; } else if (queryModel.ReportName == "OperationalReport") { if (!_sessionContext.HasPermission(Permissions.OperationalReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <OperationalReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/OperationalReport.mrt")); report["beginDate"] = model.BeginDate; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["userId"] = _sessionContext.UserId; report["cashAccountId"] = _branchContext.Configuration.CashOrderSettings.CashAccountId; report["goldAccountId"] = _branchContext.Configuration.CashOrderSettings.GoldCollateralSettings.SellingSettings.CreditId; report["autoAccountId"] = _branchContext.Configuration.CashOrderSettings.CarCollateralSettings.SellingSettings.CreditId; report["goodsAccountId"] = _branchContext.Configuration.CashOrderSettings.GoodCollateralSettings.SellingSettings.CreditId; report["machineryAccountId"] = _branchContext.Configuration.CashOrderSettings.MachineryCollateralSettings.SellingSettings.CreditId; report["sfkTransferAccountId"] = _branchContext.Configuration.CashOrderSettings.CarTransferSettings.SupplyDebtSettings.DebitId; report["sfkBuyoutAccountId"] = _branchContext.Configuration.CashOrderSettings.CarTransferSettings.DebtSettings.CreditId; } else if (queryModel.ReportName == "SplitProfitReport") { if (!_sessionContext.HasPermission(Permissions.SplitProfitReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <SplitProfitReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/SplitProfitReport.mrt")); report["branchId"] = model.BranchId; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["userId"] = _sessionContext.UserId; } else if (queryModel.ReportName == "InsuranceReport") { if (!_sessionContext.HasPermission(Permissions.InsuranceReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <InsuranceReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/InsuranceReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["userId"] = _sessionContext.UserId; report["status"] = model.Status; } else if (queryModel.ReportName == "OrderRegisterReport") { if (!_sessionContext.HasPermission(Permissions.OrderRegisterView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <OrderRegisterQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/OrderRegisterReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["userId"] = _sessionContext.UserId; report["accountType"] = model.AccountType; report["accountId"] = model.AccountId; } else if (queryModel.ReportName == "ProfitReport") { if (!_sessionContext.HasPermission(Permissions.ProfitReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <ProfitReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/ProfitReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["userId"] = _sessionContext.UserId; report["collateralType"] = model.CollateralType; } else if (queryModel.ReportName == "SfkProfitReport") { if (!_sessionContext.HasPermission(Permissions.ProfitReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <ProfitReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/SfkProfitReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["userId"] = _sessionContext.UserId; report["collateralType"] = model.CollateralType; } else if (queryModel.ReportName == "ReconciliationReport") { if (!_sessionContext.HasPermission(Permissions.ReconciliationReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <ReconciliationReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/ReconciliationReport.mrt")); report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); } else if (queryModel.ReportName == "ConsolidateProfitReport") { if (!_sessionContext.HasPermission(Permissions.ProfitReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <ConsolidateProfitReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/ConsolidateProfitReport.mrt")); report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["collateralType"] = model.CollateralType; } else if (queryModel.ReportName == "SfkConsolidateProfitReport") { if (!_sessionContext.HasPermission(Permissions.ProfitReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <ConsolidateProfitReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/SfkConsolidateProfitReport.mrt")); report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["collateralType"] = model.CollateralType; } else if (queryModel.ReportName == "PaymentReport") { if (!_sessionContext.HasPermission(Permissions.PaymentReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <PaymentReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/PaymentReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.CurrentDate.Date; report["endDate"] = model.CurrentDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); } else if (queryModel.ReportName == "IssuanceReport") { if (!_sessionContext.HasPermission(Permissions.IssuanceReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <IssuanceReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/IssuanceReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["userId"] = _sessionContext.UserId; } else if (queryModel.ReportName == "ReinforceAndWithdrawReport") { if (!_sessionContext.HasPermission(Permissions.ReinforceAndWithdrawReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } var model = JsonConvert.DeserializeObject <ReinforceAndWithdrawReportQueryModel>(queryModel.ReportQuery); report.Load(StiNetCoreHelper.MapPath(this, "Reports/ReinforceAndWithdrawReport.mrt")); report["branchId"] = model.BranchId; report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); } else if (queryModel.ReportName == "SfkTransferedReport") { if (!_sessionContext.HasPermission(Permissions.ConsolidateReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } report.Load(StiNetCoreHelper.MapPath(this, "Reports/SfkTransferedReport.mrt")); } else if (queryModel.ReportName == "AccountableReport") { if (!_sessionContext.HasPermission(Permissions.AccountableReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } report.Load(StiNetCoreHelper.MapPath(this, "Reports/AccountableReport.mrt")); var model = JsonConvert.DeserializeObject <AccountableReportQueryModel>(queryModel.ReportQuery); report["accountIds"] = string.Join(",", model.AccountIds); report["branchIds"] = string.Join(",", model.BranchIds); report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["userId"] = _sessionContext.UserId; } else if (queryModel.ReportName == "NotificationReport") { if (!_sessionContext.HasPermission(Permissions.NotificationReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } report.Load(StiNetCoreHelper.MapPath(this, "Reports/NotificationReport.mrt")); var model = JsonConvert.DeserializeObject <NotificationReportQueryModel>(queryModel.ReportQuery); report["branchId"] = model.BranchId; report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.BeginDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); report["userId"] = _sessionContext.UserId; } else if (queryModel.ReportName == "RegionMonitoringReport") { if (!_sessionContext.HasPermission(Permissions.RegionMonitoringReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } report.Load(StiNetCoreHelper.MapPath(this, "Reports/RegionMonitoringReport.mrt")); var model = JsonConvert.DeserializeObject <RegionMonitoringReportQueryModel>(queryModel.ReportQuery); report["branchIds"] = string.Join(",", model.BranchIds); report["beginDate"] = model.BeginDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); } else if (queryModel.ReportName == "StatisticsReport") { if (!_sessionContext.HasPermission(Permissions.StatisticsReportView)) { throw new PawnshopApplicationException("У вас недостаточно прав для просмотра отчета, обратитесь к администратору"); } report.Load(StiNetCoreHelper.MapPath(this, "Reports/StatisticsReport.mrt")); var model = JsonConvert.DeserializeObject <StatisticsReportQueryModel>(queryModel.ReportQuery); report["branchIds"] = string.Join(",", model.BranchIds); report["beginDate"] = model.BeginDate.Date; report["endDate"] = model.EndDate.Date.AddHours(23).AddMinutes(59).AddSeconds(59); } var sqlDatabase = (report.Dictionary.Databases["ReportConnection"] as StiSqlDatabase) ?? ((StiSqlDatabase)report.Dictionary.Databases[0]); sqlDatabase.ConnectionString = _options.DatabaseConnectionString; report.Render(); return(report.SaveDocumentJsonToString()); }