static async Task Main(string[] args)
{
var parameters = ArgumentHelper.Get(args);
var reporthelper = new ReportHelper();
var reports = new [] { "Timesheets Reconciliation" };
foreach (var reportName in reports)
{
var report = await reporthelper.GetReportIdByNameAsync(parameters, reportName);
var data = await reporthelper.ExecuteReportAsync(parameters, report, new[]
{
new ReportFilterModel
{
ParameterName = "ClientId",
Value = parameters.ClientId.ToString(),
StringValue = parameters.ClientId.ToString()
},
new ReportFilterModel
{
ParameterName = "FromDate",
Value = new DateTime(parameters.Year, 01, 01).ToString("yyyy-MM-dd"),
StringValue = new DateTime(parameters.Year, 01, 01).ToString("yyyy-MM-dd")
},
new ReportFilterModel
{
ParameterName = "ToDate",
Value = new DateTime(parameters.Year, 12, 31, 23, 59, 59).ToString("yyyy-MM-dd"),
StringValue = new DateTime(parameters.Year, 12, 31, 23, 59, 59).ToString("yyyy-MM-dd")
}
});
DataExportHelper.ExportToCsv(reportName, data.Data);
}
}
/// <summary>
/// Reload data.
/// </summary>
public override void ReloadData(bool forceLoad)
{
if ((TableInfo == null) || ((GraphImageWidth != 0) && (ComputedWidth == 0)))
{
// Graph width is computed no need to create graph
return;
}
Visible = true;
EnsureChildControls();
LoadTable();
mReportInfo = ReportInfoProvider.GetReportInfo(TableInfo.TableReportID);
if (mReportInfo == null)
{
return;
}
// Check security settings
if (!(CheckReportAccess(mReportInfo) && CheckEmailModeSubscription(mReportInfo, ValidationHelper.GetBoolean(TableInfo.TableSettings["SubscriptionEnabled"], true))))
{
Visible = false;
return;
}
// Prepare query attributes
QueryIsStoredProcedure = TableInfo.TableQueryIsStoredProcedure;
QueryText = TableInfo.TableQuery;
// Init parameters
InitParameters(mReportInfo.ReportParameters);
// Init macro resolver
InitResolver();
mErrorOccurred = false;
DataSet ds = null;
try
{
// Load data
ds = LoadData();
}
catch (Exception ex)
{
// Display error message, if data load fail
lblError.Visible = true;
lblError.Text = "[ReportTable.ascx] Error loading the data: " + ex.Message;
EventLogProvider.LogException("Report table", "E", ex);
mErrorOccurred = true;
}
// If no data load, set empty dataset
if (DataHelper.DataSourceIsEmpty(ds))
{
if (EmailMode && SendOnlyNonEmptyDataSource)
{
Visible = false;
return;
}
string noRecordText = ValidationHelper.GetString(TableInfo.TableSettings["QueryNoRecordText"], String.Empty);
if (!String.IsNullOrEmpty(noRecordText))
{
UIGridViewObject.Visible = false;
lblInfo.Text = ResolveMacros(noRecordText);
lblInfo.Visible = true;
EnableExport = false;
return;
}
if (!EmailMode)
{
Visible = false;
return;
}
}
else
{
UIGridViewObject.Visible = true;
// Resolve macros in column names
int i = 0;
foreach (DataColumn dc in ds.Tables[0].Columns)
{
if (dc.ColumnName == "Column" + (i + 1))
{
dc.ColumnName = ResolveMacros(ds.Tables[0].Rows[0][i].ToString());
}
else
{
dc.ColumnName = ResolveMacros(dc.ColumnName);
}
i++;
}
// Resolve macros in dataset
foreach (DataRow dr in ds.Tables[0].Rows)
{
foreach (DataColumn dc in ds.Tables[0].Columns)
{
if (dc.DataType.FullName.ToLowerCSafe() == "system.string")
{
dr[dc.ColumnName] = ResolveMacros(ValidationHelper.GetString(dr[dc.ColumnName], String.Empty));
}
}
}
if (EmailMode)
{
// For some email formats, export data in csv format
EmailFormatEnum format = EmailHelper.GetEmailFormat(ReportSubscriptionSiteID);
if ((format == EmailFormatEnum.Both) || (format == EmailFormatEnum.PlainText))
{
using (MemoryStream ms = MemoryStream.New())
{
DataExportHelper deh = new DataExportHelper(ds);
byte[] data = deh.ExportToCSV(ds, 0, ms, true);
ReportSubscriptionSender.AddToRequest(mReportInfo.ReportName, "t" + TableInfo.TableName, data);
}
}
// For plain text email show table only as attachment
if (format == EmailFormatEnum.PlainText)
{
menuCont.Visible = false;
ltlEmail.Visible = true;
ltlEmail.Text = String.Format(GetString("reportsubscription.attachment"), TableInfo.TableName);
return;
}
GenerateTableForEmail(ds);
menuCont.Visible = false;
return;
}
}
// Databind to gridview control
UIGridViewObject.DataSource = ds;
EnsurePageIndex();
UIGridViewObject.DataBind();
if ((TableFirstColumnWidth != Unit.Empty) && (UIGridViewObject.Rows.Count > 0))
{
UIGridViewObject.Rows[0].Cells[0].Width = TableFirstColumnWidth;
}
}
/// <summary>
/// Reload data.
/// </summary>
public override void ReloadData(bool forceLoad)
{
if ((TableInfo == null) || ((GraphImageWidth != 0) && (ComputedWidth == 0)))
{
// Graph width is computed no need to create graph
return;
}
Visible = true;
EnsureChildControls();
LoadTable();
mReportInfo = ReportInfoProvider.GetReportInfo(TableInfo.TableReportID);
if (mReportInfo == null)
{
return;
}
// Check security settings
if (!(CheckReportAccess(mReportInfo) && CheckEmailModeSubscription(mReportInfo, ValidationHelper.GetBoolean(TableInfo.TableSettings["SubscriptionEnabled"], true))))
{
Visible = false;
return;
}
// Prepare query attributes
QueryIsStoredProcedure = TableInfo.TableQueryIsStoredProcedure;
QueryText = TableInfo.TableQuery;
// Init parameters
InitParameters(mReportInfo.ReportParameters);
// Init macro resolver
InitResolver();
mErrorOccurred = false;
DataSet ds = null;
// Ensure report item name for caching
if (String.IsNullOrEmpty(ReportItemName))
{
ReportItemName = String.Format("{0};{1}", mReportInfo.ReportName, TableInfo.TableName);
}
try
{
// Load data
ds = LoadData();
}
catch (Exception ex)
{
// Display error message, if data load fail
lblError.Visible = true;
lblError.Text = "Error loading the data: " + ex.Message;
EventLogProvider.LogException("Report table", "E", ex);
mErrorOccurred = true;
}
// If no data load, set empty dataset
if (DataHelper.DataSourceIsEmpty(ds))
{
if (EmailMode && SendOnlyNonEmptyDataSource)
{
Visible = false;
return;
}
string noRecordText = ValidationHelper.GetString(TableInfo.TableSettings["QueryNoRecordText"], String.Empty);
if (!String.IsNullOrEmpty(noRecordText))
{
UIGridViewObject.Visible = false;
lblInfo.Text = ResolveMacros(noRecordText);
lblInfo.Visible = true;
EnableExport = false;
return;
}
if (!EmailMode)
{
Visible = false;
return;
}
}
else
{
UIGridViewObject.Visible = true;
// Resolve macros in column names
int i = 0;
foreach (DataColumn dc in ds.Tables[0].Columns)
{
if (dc.ColumnName == "Column" + (i + 1))
{
dc.ColumnName = ResolveMacros(ds.Tables[0].Rows[0][i].ToString());
}
else
{
dc.ColumnName = ResolveMacros(dc.ColumnName);
}
i++;
}
// Resolve macros in dataset
foreach (DataRow dr in ds.Tables[0].Rows)
{
foreach (DataColumn dc in ds.Tables[0].Columns)
{
if (dc.DataType.FullName.Equals("system.string", StringComparison.CurrentCultureIgnoreCase))
{
dr[dc.ColumnName] = ResolveMacros(ValidationHelper.GetString(dr[dc.ColumnName], String.Empty));
}
}
}
if (EmailMode)
{
// For some email formats, export data in csv format
EmailFormatEnum format = EmailHelper.GetEmailFormat(ReportSubscriptionSiteID);
if ((format == EmailFormatEnum.Both) || (format == EmailFormatEnum.PlainText))
{
using (var ms = new SystemIO.MemoryStream())
{
DataExportHelper deh = new DataExportHelper(ds);
byte[] data = deh.ExportToCSV(ds, 0, ms, true);
ReportSubscriptionSender.AddToRequest(mReportInfo.ReportName, "t" + TableInfo.TableName, data);
}
}
// For plain text email show table only as attachment
if (format == EmailFormatEnum.PlainText)
{
menuCont.Visible = false;
ltlEmail.Visible = true;
ltlEmail.Text = String.Format(GetString("reportsubscription.attachment"), TableInfo.TableName);
return;
}
GenerateTableForEmail(ds);
menuCont.Visible = false;
return;
}
}
// Databind to gridview control
UIGridViewObject.DataSource = ds;
EnsurePageIndex();
UIGridViewObject.DataBind();
if ((TableFirstColumnWidth != Unit.Empty) && (UIGridViewObject.Rows.Count > 0))
{
UIGridViewObject.Rows[0].Cells[0].Width = TableFirstColumnWidth;
}
}
private static async Task <string> GenerateExportFile(DataGridResultViewer resultViewer, IDataExporter dataExporter)
{
var tempFileName = Path.GetTempFileName();
var connectionConfiguration = ConfigurationProvider.GetConnectionConfiguration(ConfigurationProvider.ConnectionStrings[0].Name);
Thread.CurrentThread.CurrentCulture = CultureInfo.DefaultThreadCurrentCulture = CultureInfo.InvariantCulture;
using (var exportContext = await dataExporter.StartExportAsync(ExportOptions.ToFile(tempFileName, resultViewer.Title), DataExportHelper.GetOrderedExportableColumns(resultViewer.ResultGrid), connectionConfiguration.InfrastructureFactory.DataExportConverter, CancellationToken.None))
{
await exportContext.AppendRowsAsync(resultViewer.ResultGrid.Items.Cast <object[]>());
await exportContext.FinalizeAsync();
}
return(tempFileName);
}
/// <summary>
/// Reload data.
/// </summary>
public override void ReloadData(bool forceLoad)
{
if ((GraphImageWidth != 0) && (ComputedWidth == 0))
{
// Graph width is computed no need to create graph
return;
}
Visible = true;
errorOccurred = false;
try
{
ReportTableName = Parameter;
EnsureTableInfo();
EnsureChildControls();
//Test security
if (TableInfo != null)
{
ri = ReportInfoProvider.GetReportInfo(TableInfo.TableReportID);
if (ri != null)
{
if (ri.ReportAccess != ReportAccessEnum.All)
{
if (!CMSContext.CurrentUser.IsAuthenticated())
{
Visible = false;
return;
}
}
EnableSubscription = EnableSubscription && (ValidationHelper.GetBoolean(TableInfo.TableSettings["SubscriptionEnabled"], true) && ri.ReportEnableSubscription);
if (EmailMode && !EnableSubscription)
{
this.Visible = false;
return;
}
//Set default parametrs directly if not set
if (ReportParameters == null)
{
FormInfo fi = new FormInfo(ri.ReportParameters);
// Get datarow with required columns
ReportParameters = fi.GetDataRow(false);
fi.LoadDefaultValues(ReportParameters, true);
}
ApplyTimeParameters();
}
}
// Only use base parameters in case of stored procedure
if (QueryIsStoredProcedure)
{
AllParameters = SpecialFunctions.ConvertDataRowToParams(ReportParameters, null);
}
// Load data
DataSet ds = LoadData();
// If no data load, set empty dataset
if (DataHelper.DataSourceIsEmpty(ds))
{
if (EmailMode && SendOnlyNonEmptyDataSource)
{
Visible = false;
return;
}
string noRecordText = ValidationHelper.GetString(TableInfo.TableSettings["QueryNoRecordText"], String.Empty);
if (noRecordText != String.Empty)
{
GridViewObject.Visible = false;
lblInfo.Text = CMSContext.ResolveMacros(noRecordText);
plcInfo.Visible = true;
EnableExport = false;
return;
}
if (!EmailMode)
{
Visible = false;
}
}
else
{
GridViewObject.Visible = true;
// Resolve macros in column names
int i = 0;
foreach (DataColumn dc in ds.Tables[0].Columns)
{
if (dc.ColumnName == "Column" + ((int)(i + 1)).ToString())
{
dc.ColumnName = ResolveMacros(ds.Tables[0].Rows[0][i].ToString());
}
else
{
dc.ColumnName = ResolveMacros(dc.ColumnName);
}
i++;
}
// Resolve macros in dataset
foreach (DataRow dr in ds.Tables[0].Rows)
{
foreach (DataColumn dc in ds.Tables[0].Columns)
{
if (dc.DataType.FullName.ToLowerCSafe() == "system.string")
{
dr[dc.ColumnName] = ResolveMacros(ValidationHelper.GetString(dr[dc.ColumnName], ""));
}
}
}
if (EmailMode)
{
// For some email formats, export data in csv format
EmailFormatEnum format = EmailHelper.GetEmailFormat(ReportSubscriptionSiteID);
if ((format == EmailFormatEnum.Both) || (format == EmailFormatEnum.PlainText))
{
using (MemoryStream ms = MemoryStream.New())
{
DataExportHelper deh = new DataExportHelper(ds);
byte[] data = deh.ExportToCSV(ds, 0, ms, true);
ReportSubscriptionSender.AddToRequest(ri.ReportName, "t" + TableInfo.TableName, data);
}
}
// For plain text email show table only as attachment
if (format == EmailFormatEnum.PlainText)
{
menuCont.Visible = false;
ltlEmail.Visible = true;
ltlEmail.Text = String.Format(GetString("reportsubscription.attachment"), TableInfo.TableName);
return;
}
GenerateTableForEmail(ds);
menuCont.Visible = false;
return;
}
}
ApplyStyles();
// Databind to gridview control
GridViewObject.DataSource = ds;
EnsurePageIndex();
GridViewObject.DataBind();
if ((TableFirstColumnWidth != Unit.Empty) && (GridViewObject.Rows.Count > 0))
{
GridViewObject.Rows[0].Cells[0].Width = TableFirstColumnWidth;
}
}
catch (Exception ex)
{
// Display error message, if data load fail
lblError.Visible = true;
lblError.Text = "[ReportTable.ascx] Error loading the data: " + ex.Message;
EventLogProvider ev = new EventLogProvider();
ev.LogEvent("Report table", "E", ex);
errorOccurred = true;
}
}
private async Task ExportData(IDataExporter dataExporter, ExportOptions exportOptions)
{
using (var cancellationTokenSource = new CancellationTokenSource())
{
var operationMonitor = new WindowOperationMonitor(cancellationTokenSource)
{
IsIndeterminate = false
};
operationMonitor.Show();
var exception = await App.SafeActionAsync(
async delegate
{
using (var exportContext = await dataExporter.StartExportAsync(exportOptions, DataExportHelper.GetOrderedExportableColumns(ResultGrid), _outputViewer.DocumentPage.InfrastructureFactory.DataExportConverter, cancellationTokenSource.Token))
{
exportContext.SetProgress(_resultRows.Count, operationMonitor);
await exportContext.AppendRowsAsync(_resultRows);
await exportContext.FinalizeAsync();
}
});
operationMonitor.Close();
var isOperationCanceledException = exception is OperationCanceledException;
if (exception != null && !isOperationCanceledException)
{
Messages.ShowError(exception.Message);
}
}
}
/// <summary>
/// Reload data.
/// </summary>
public override void ReloadData(bool forceLoad)
{
if ((GraphImageWidth != 0) && (ComputedWidth == 0))
{
// Graph width is computed no need to create graph
return;
}
Visible = true;
errorOccurred = false;
try
{
ReportTableName = Parameter;
EnsureTableInfo();
EnsureChildControls();
//Test security
if (TableInfo != null)
{
ri = ReportInfoProvider.GetReportInfo(TableInfo.TableReportID);
if (ri != null)
{
if (ri.ReportAccess != ReportAccessEnum.All)
{
if (!CMSContext.CurrentUser.IsAuthenticated())
{
Visible = false;
return;
}
}
EnableSubscription = EnableSubscription && (ValidationHelper.GetBoolean(TableInfo.TableSettings["SubscriptionEnabled"], true) && ri.ReportEnableSubscription);
if (EmailMode && !EnableSubscription)
{
this.Visible = false;
return;
}
//Set default parametrs directly if not set
if (ReportParameters == null)
{
FormInfo fi = new FormInfo(ri.ReportParameters);
// Get datarow with required columns
ReportParameters = fi.GetDataRow(false);
fi.LoadDefaultValues(ReportParameters, true);
}
ApplyTimeParameters();
}
}
// Only use base parameters in case of stored procedure
if (QueryIsStoredProcedure)
{
AllParameters = SpecialFunctions.ConvertDataRowToParams(ReportParameters, null);
}
// Load data
DataSet ds = LoadData();
// If no data load, set empty dataset
if (DataHelper.DataSourceIsEmpty(ds))
{
if (EmailMode && SendOnlyNonEmptyDataSource)
{
Visible = false;
return;
}
string noRecordText = ValidationHelper.GetString(TableInfo.TableSettings["QueryNoRecordText"], String.Empty);
if (noRecordText != String.Empty)
{
GridViewObject.Visible = false;
lblInfo.Text = CMSContext.ResolveMacros(noRecordText);
plcInfo.Visible = true;
EnableExport = false;
return;
}
if (!EmailMode)
{
Visible = false;
}
}
else
{
GridViewObject.Visible = true;
// Resolve macros in column names
int i = 0;
foreach (DataColumn dc in ds.Tables[0].Columns)
{
if (dc.ColumnName == "Column" + ((int)(i + 1)).ToString())
{
dc.ColumnName = ResolveMacros(ds.Tables[0].Rows[0][i].ToString());
}
else
{
dc.ColumnName = ResolveMacros(dc.ColumnName);
}
i++;
}
// Resolve macros in dataset
foreach (DataRow dr in ds.Tables[0].Rows)
{
foreach (DataColumn dc in ds.Tables[0].Columns)
{
if (dc.DataType.FullName.ToLowerCSafe() == "system.string")
{
dr[dc.ColumnName] = ResolveMacros(ValidationHelper.GetString(dr[dc.ColumnName], ""));
}
}
}
if (EmailMode)
{
// For some email formats, export data in csv format
EmailFormatEnum format = EmailHelper.GetEmailFormat(ReportSubscriptionSiteID);
if ((format == EmailFormatEnum.Both) || (format == EmailFormatEnum.PlainText))
{
using (MemoryStream ms = MemoryStream.New())
{
DataExportHelper deh = new DataExportHelper(ds);
byte[] data = deh.ExportToCSV(ds, 0, ms, true);
ReportSubscriptionSender.AddToRequest(ri.ReportName, "t" + TableInfo.TableName, data);
}
}
// For plain text email show table only as attachment
if (format == EmailFormatEnum.PlainText)
{
menuCont.Visible = false;
ltlEmail.Visible = true;
ltlEmail.Text = String.Format(GetString("reportsubscription.attachment"), TableInfo.TableName);
return;
}
GenerateTableForEmail(ds);
menuCont.Visible = false;
return;
}
}
ApplyStyles();
// Databind to gridview control
GridViewObject.DataSource = ds;
EnsurePageIndex();
GridViewObject.DataBind();
if ((TableFirstColumnWidth != Unit.Empty) && (GridViewObject.Rows.Count > 0))
{
GridViewObject.Rows[0].Cells[0].Width = TableFirstColumnWidth;
}
}
catch (Exception ex)
{
// Display error message, if data load fail
lblError.Visible = true;
lblError.Text = "[ReportTable.ascx] Error loading the data: " + ex.Message;
EventLogProvider ev = new EventLogProvider();
ev.LogEvent("Report table", "E", ex);
errorOccurred = true;
}
}
