} // 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)); }