Creating reports and dashboards | Stimulsoft community forum

Code: Select all

 
           var stiSqlConnectionDatabase = (StiSqlDatabase)stiReport.Dictionary.Databases["Connection"];

            stiSqlConnectionDatabase.ConnectionString = _theService.GetConnectionString(userDetails);
            stiSqlConnectionDatabase.Connected += (_, _) =>
            {
                try
                {
                    var sqlConnection = (SqlConnection)stiReport.DataStore[0].Data;
                    sqlConnection.Open();

                    using var sqlCommand = sqlConnection.CreateCommand();
                    sqlCommand.CommandText = $"SET ROWCOUNT {_configurationService.GetOptions<StimulsoftOptions>(userDetails).SqlRowCount};";
                    sqlCommand.ExecuteNonQuery();
                }
                catch (Exception)
                {
                    // Ignore
                }
            };

Code: Select all

       @Html.Raw(
            Html.StiNetCoreDesigner(
                new StiNetCoreDesignerOptions
                {
                    Actions =
                    {
                        DesignerEvent = "DesignerEvent",
                        GetReport = "GetReport",
                        PreviewReport = "PreviewReport",
                        SaveReport = "SaveReport"
                    },
                    Behavior =
                    {
                        ShowSaveDialog = false
                    },
                    Dictionary =
                    {
                        ShowDictionaryContextMenuProperties = false,
                        PermissionDataConnections = StiDesignerPermissions.View
                    },
                    FileMenu =
                    {
                        ShowClose = false,
                        ShowNew = false,
                        ShowOpen = false,
                        ShowSaveAs = false
                    },
                    Localization = (string)ViewData["Localization"],
                    Server =
                    {
                        RequestTimeout = HtmlHelper.GetStimulsoftOptions().RequestTimeoutInSeconds // Default value is 30
                    }
                }))

Code: Select all

public class StimulsoftFixMiddleware
{
    private readonly RequestDelegate _next;

    public StimulsoftFixMiddleware(RequestDelegate next)
    {
        _next = next;
    }

    public async Task Invoke(HttpContext context)
    {
        if (context.Request.Path.StartsWithSegments("/reportsdesigner"))
        {
            var originalStream = context.Response.Body;

            try
            {
                using (var memoryStream = new MemoryStream())
                {
                    context.Response.Body = memoryStream;
                    await _next(context);

                    memoryStream.Position = 0;
                    await memoryStream.CopyToAsync(originalStream);
                }
            }
            finally
            {
                context.Response.Body = originalStream;
            }

            return;
        }

        await _next(context);
    }
}

public static class StimulsoftFixMiddlewareExtensions
{
    public static IApplicationBuilder UseStimulsoftFix(this IApplicationBuilder builder)
    {
        return builder.UseMiddleware<StimulsoftFixMiddleware>();
    }
}

Code: Select all

        public IActionResult DesignerEvent()
        {
            var profile = GetUserProfile();

            var stiReport = StiNetCoreDesigner.GetReportObject(this);

            _reportsV2Service.ManageSqlConnection(stiReport, profile);

            return StiNetCoreDesigner.DesignerEventResult(this, stiReport);
        }

        public IActionResult GetReport(Guid id)
        {
            var profile = GetUserProfile();

            var report = _reportsV2Service.RetrieveDetails(id, profile);

            var stiReport = new StiReport();
            stiReport.LoadFromString(report.FileContent);

            _reportsV2Service.ManageSqlConnection(stiReport, profile);

            ClearConnectionString(stiReport);

            return StiNetCoreDesigner.GetReportResult(this, stiReport);
        }

        public IActionResult PreviewReport()
        {
            var profile = GetUserProfile();

            var stiReport = StiNetCoreDesigner.GetReportObject(this);

            _reportsV2Service.ManageSqlConnection(stiReport, profile);

            return StiNetCoreDesigner.PreviewReportResult(this, stiReport);
        }

        private static void ClearConnectionString(StiReport stiReport)
        {
            if (stiReport.Dictionary.Databases["Connection"] is not StiSqlDatabase defaultDatabaseConnection)
            {
                throw new InvalidCastException($"Couldn't convert database object to {nameof(StiSqlDatabase)}");
            }

            defaultDatabaseConnection.ConnectionString = "";
        }

Code: Select all

       …
        public void ManageSqlConnection(StiReport stiReport, UserProfile userProfile)
        {
            if (stiReport == null || stiReport.Dictionary.Databases.Count == 0)
            {
                return;
            }

            var stiSqlConnectionDatabase = (StiSqlDatabase)stiReport.Dictionary.Databases["Connection"];

            stiSqlConnectionDatabase.ConnectionString = GetConnectionString(userProfile);
            stiSqlConnectionDatabase.Connected += (_, _) =>
            {
                try
                {
                    var sqlConnection = (SqlConnection)stiReport.DataStore[0].Data;
                    sqlConnection.Open();

                    using var sqlCommand = sqlConnection.CreateCommand();
                    sqlCommand.CommandText = $"SET ROWCOUNT {_configService.GetOptions<StimulsoftOptions>(userProfile).SqlRowCount};"; // Default is 5000
                    sqlCommand.ExecuteNonQuery();
                }
                catch (Exception)
                {
                }
            };
        }
        …