public void GetCommand(SqlCommand command, bool inlcudeHiddenFields = true, bool isSchemaOnly = false, bool useUserFilter = true, string sortField = null, string sortDir = null)
{
_report.MigrateToNewReport();
command.CommandType = CommandType.Text;
command.CommandTimeout = SystemSettings.GetReportTimeout();
switch (_report.ReportDefType)
{
case ReportType.Table:
_tabularReportSql.GetTabularSql(command, JsonConvert.DeserializeObject <TabularReport>(_report.ReportDef), inlcudeHiddenFields, isSchemaOnly, _report.ReportID, useUserFilter, sortField, sortDir);
break;
case ReportType.TicketView:
_tabularReportSql.GetTabularSql(command, JsonConvert.DeserializeObject <TabularReport>(_report.ReportDef), inlcudeHiddenFields, isSchemaOnly, _report.ReportID, useUserFilter, sortField, sortDir);
break;
default:
break;
}
Report.AddCommandParametersForExport(command, _report.Collection.LoginUser);
command.CommandText = $" /* ReportID: {_report.ReportID.ToString()} OrganizationID: {_report.OrganizationID.ToString()} */ " + command.CommandText;
}
private void GetCommand(SqlCommand command, bool inlcudeHiddenFields = true, bool isSchemaOnly = false, bool useUserFilter = true, string sortField = null, string sortDir = null)
{
_report.MigrateToNewReport();
_summaryReport = JsonConvert.DeserializeObject <SummaryReport>(_report.ReportDef);
command.CommandType = CommandType.Text;
command.CommandTimeout = SystemSettings.GetReportTimeout();
switch (_report.ReportDefType)
{
case ReportType.Chart:
_summaryReportSql.GetSummarySql(command, _summaryReport, isSchemaOnly, null, false, true);
break;
case ReportType.Summary:
_summaryReportSql.GetSummarySql(command, _summaryReport, isSchemaOnly, _report.ReportID, useUserFilter, false);
break;
default:
break;
}
Report.AddCommandParametersForExport(command, _report.Collection.LoginUser);
command.CommandText = $" /* ReportID: {_report.ReportID.ToString()} OrganizationID: {_report.OrganizationID.ToString()} */ " + command.CommandText;
}