EmpireReportSenderSettings 1.0.1

Settings for Empire Report Sending

This is a C# library class to store common settings for Empire report projects - database connections, SQL query, recipients, etc.

Expected usage

Create a settings blob as an environment variable

SettingsBlob:

{
  "SqlQuery": "SELECT * FROM ReportData",
  "ReportTemplateFileName": "reports/ReportTemplateFileName.rpt"
}

Consume data

using EmpireReportSenderSettings;

IEmpireReportSenderSettingsBase settings = new EmailReportSettings();
List<MailAddress> recipients = settings.EmailRecipients;
string connectionString = settings.GetConnectionString();

Expected values

The following values are expected in the settings blob.

Report Base Settings

Base class intending to be inherited to various report types based on their presentation.

• SqlQuery: The SQL query to run to get the data for the report
• ReportTemplateFileName: The name of the report template file
• ReportDataFile: The name of the report data file
• DatabaseConnectionString: The connection string to the database
• DatabaseUsername: The username to connect to the database
• DatabasePassword: The password to connect to the database
• LogWebhookUri: The URI to send logs to

Email Report Settings

For reports that are to be sent via email.

• OutputFileName: The name of the output file
• OutputFilePat: The path to the output file
• EmailList: A comma separated list of email addresses to send the report to (e.g. "nb@empireindustries.com,jaris@empireindustries.com" or "nb@empireindustries.com")
• EmailApiKey: The API key for sending emails
• ReportEmailSenderName: The name of the sender of the email
• ReportEmailSenderAddress: The email address of the sender of the email
• ReportEmailSubject: The subject of the email
• ReportEmailPlainTextBody: The plain text body of the email
• ReportEmailHtmlBody: The HTML body of the email