} // IsNormalMode
private static void SendReport(DateTime oDate, ASafeLog oLog)
{
oLog.Debug("Generating reconciliation report...");
var oDB = new SqlConnection();
oLog.Debug("Loading Pacnet report metadata from db...");
var pacnet = new Report(oDB, "RPT_PACNET_RECONCILIATION");
oLog.Debug("Loading Paypoint report metadata from db...");
var paypoint = new Report(oDB, "RPT_PAYPOINT_RECONCILIATION");
var rh = new BaseReportHandler(oDB, oLog);
var sender = new ReportDispatcher(oDB, oLog);
var email = new ReportEmail();
oLog.Debug("Generating Pacnet report...");
email.ReportBody.Append(new H2().Append(new Text(pacnet.GetTitle(oDate))));
email.ReportBody.Append(
rh.TableReport(new ReportQuery(pacnet, oDate, oDate))
);
oLog.Debug("Generating Paypoint report...");
email.ReportBody.Append(new H2().Append(new Text(paypoint.GetTitle(oDate))));
email.ReportBody.Append(
rh.TableReport(new ReportQuery(paypoint, oDate, oDate))
);
var sTo = new StringBuilder();
sTo.Append(pacnet.ToEmail);
if (pacnet.ToEmail != "")
{
sTo.Append(",");
}
sTo.Append(paypoint.ToEmail);
oLog.Debug("Sending report...");
sender.Dispatch(
"Reconciliation " + oDate.ToString("MMMM d yyyy", CultureInfo.InvariantCulture),
oDate,
email.HtmlBody,
null,
sTo.ToString()
);
oLog.Debug("Reconciliation report generation complete.");
} // SendReport
private static void TestLoansIssuedReport(AConnection oDB, ASafeLog log)
{
var brh = new BaseReportHandler(oDB, log);
var rpt = new Report(oDB, Reports.ReportType.RPT_LOANS_GIVEN.ToString());
ATag oTag = brh.BuildLoansIssuedReport(rpt, new DateTime(2013, 7, 1), new DateTime(2013, 7, 15));
}
