private void PrintFinanceReport(ReportViewer rptViewer)
{
IACDataSet ReportData = new IACDataSet();
IACDataSetTableAdapters.OPNCUSTTableAdapter OPNCUSTTableAdapter = new IACDataSetTableAdapters.OPNCUSTTableAdapter();
IACDataSetTableAdapters.OPNDEALRTableAdapter OPNDEALRTableAdapter = new IACDataSetTableAdapters.OPNDEALRTableAdapter();
IACDataSetTableAdapters.StatementCustomerHeaderTableAdapter StatementCustomerHeaderTableAdapter = new IACDataSetTableAdapters.StatementCustomerHeaderTableAdapter();
IACDataSetTableAdapters.StatementDealerSummaryTableAdapter StatementDealerSummaryTableAdapter = new IACDataSetTableAdapters.StatementDealerSummaryTableAdapter();
OPNCUSTTableAdapter.CustomizeFill("SELECT * FROM OPNCUST WHERE CUSTOMER_ACT_STAT <> \'I\' AND CUSTOMER_DAY_DUE = " + ((DateTime)StatementDatenullableDateTimePicker.Value).Day.ToString().TrimStart().TrimEnd() + " ORDER BY CUSTOMER_DEALER,CUSTOMER_NO");
OPNCUSTTableAdapter.CustomFillBy(ReportData.OPNCUST);
StatementCustomerHeaderTableAdapter.FillByDueDate(ReportData.StatementCustomerHeader, ((DateTime)StatementDatenullableDateTimePicker.Value).Date, false, false);
StatementDealerSummaryTableAdapter.FillByDueDate(ReportData.StatementDealerSummary, ((DateTime)StatementDatenullableDateTimePicker.Value).Date);
if (ReportData.StatementCustomerHeader.Rows.Count == 0 || ReportData.OPNCUST.Rows.Count == 0)
{
MessageBox.Show("*** Sorry there are no statements for the DUE DATE you entered!!! ***");
}
else
{
OPNDEALRTableAdapter.CustomizeFill("SELECT * FROM OPNDEALR");
OPNDEALRTableAdapter.CustomFillBy(ReportData.OPNDEALR);
FinanceReport myReportObject = new FinanceReport();
myReportObject.SetDataSource(ReportData);
myReportObject.SetParameterValue("gsUserID", Program.gsUserID);
myReportObject.SetParameterValue("gsUserName", Program.gsUserName);
myReportObject.SetParameterValue("gsFormTitle", "Open Customer Finance Charge Report");
rptViewer.crystalReportViewer.ReportSource = myReportObject;
rptViewer.crystalReportViewer.Refresh();
rptViewer.Show();
}
}
private void PrintDealerSummary(ReportViewer rptViewer)
{
DateTime ldRunDate;
String lsRunDate = "";
IACDataSet ReportData = new IACDataSet();
IACDataSetTableAdapters.ClosedDealerSummaryTableAdapter ClosedDealerSummaryTableAdapter = new IACDataSetTableAdapters.ClosedDealerSummaryTableAdapter();
lsRunDate = comboBoxRunMonth.SelectedValue.ToString() + "/31/" + textBoxRunYear.Text;
DateTime.TryParse(lsRunDate, out ldRunDate);
if (ldRunDate == DateTime.MinValue)
{
lsRunDate = comboBoxRunMonth.SelectedValue.ToString() + "/30/" + textBoxRunYear.Text;
DateTime.TryParse(lsRunDate, out ldRunDate);
if (ldRunDate == DateTime.MinValue)
{
lsRunDate = comboBoxRunMonth.SelectedValue.ToString() + "/28/" + textBoxRunYear.Text;
DateTime.TryParse(lsRunDate, out ldRunDate);
if (ldRunDate == DateTime.MinValue)
{
lsRunDate = comboBoxRunMonth.SelectedValue.ToString() + "/27/" + textBoxRunYear.Text; // Must be a leap year with February run date
DateTime.TryParse(lsRunDate, out ldRunDate);
}
}
}
ClosedDealerSummaryTableAdapter.Fill(ReportData.ClosedDealerSummary, ldRunDate.Month, ldRunDate.Year);
if (ReportData.ClosedDealerSummary.Rows.Count == 0)
{
MessageBox.Show("*** Sorry there are no DEALHIST records for the RUN MONTH AND YEAR you entered!!! ***");
}
else
{
ClosedDealerSummary myReportObject = new ClosedDealerSummary();
myReportObject.SetDataSource(ReportData);
myReportObject.SetParameterValue("gdCutOffDate", ldRunDate);
myReportObject.SetParameterValue("gsUserID", Program.gsUserID);
myReportObject.SetParameterValue("gsUserName", Program.gsUserName);
rptViewer.crystalReportViewer.ReportSource = myReportObject;
rptViewer.crystalReportViewer.Refresh();
rptViewer.Show();
}
}
private void buttonPrint_Click(object sender, EventArgs e)
{
//String deletePath = "";
//SQLBackupandRestore SQLBR = new SQLBackupandRestore();
Hide();
MDIIAC2013 MDImain = (MDIIAC2013)MdiParent;
MDImain.CreateFormInstance("ReportViewer", false);
ReportViewer rptViewer = (ReportViewer)MDImain.ActiveMdiChild;
IACDataSet ReportDataSet = new IACDataSet();
IACDataSetTableAdapters.ClosedCustomerShortBalanceTableAdapter ClosedCustomerShortBalanceTableAdapter = new IACDataSetTableAdapters.ClosedCustomerShortBalanceTableAdapter();
ClosedCustomerShortBalanceTableAdapter.Fill(ReportDataSet.ClosedCustomerShortBalance);
if (ReportDataSet.ClosedCustomerShortBalance.Rows.Count == 0)
{
MessageBox.Show("*** Sorry there are no Customers with Short Balances! ***");
}
else
{
/*
* deletePath = ReportDataSet.DataPath.Rows[0].Field<String>("Path").TrimEnd();
*
* deletePath += @"EXCLDATA\CustomerRepoExtract.xls";
*
* if(System.IO.File.Exists(deletePath))
* System.IO.File.Delete(deletePath);*/
ShortBalanceReport myReportObject = new ShortBalanceReport();
myReportObject.SetDataSource(ReportDataSet);
myReportObject.SetParameterValue("gsUserID", Program.gsUserID);
myReportObject.SetParameterValue("gsUserName", Program.gsUserName);
rptViewer.crystalReportViewer.ReportSource = myReportObject;
rptViewer.crystalReportViewer.Refresh();
rptViewer.Show();
//SQLBR.CustomerRepoExtractJob();
}
//SQLBR.Dispose();
//SQLBR = null;
Close();
}
private void buttonTransfer_Click(object sender, EventArgs e)
{
IACDataSetTableAdapters.IVRPAYTableAdapter IVRPAYTableAdapter = new IACDataSetTableAdapters.IVRPAYTableAdapter();
IACDataSet AUTOBANK = new IACDataSet();
ReadPCPAYFILE(AUTOBANK);
IVRPAYTableAdapter.Fill(AUTOBANK.IVRPAY);
String lsUNCROOT = Program.GsDataPath, lsOldFile, lsNewFile;
lsOldFile = lsUNCROOT + @"IVRPAY\IVRpmt.csv";
lsNewFile = lsUNCROOT + @"IVRPAY\IVRpmt" + DateTime.Now.Date.Year.ToString() + DateTime.Now.Date.Month.ToString().PadLeft(2, '0') + DateTime.Now.Date.Day.ToString().PadLeft(2, '0') + @".csv";
if (AUTOBANK.IVRPAY.Rows.Count != 0)
{
RenameFile(lsOldFile, lsNewFile);
MessageBox.Show("*** Import of " + AUTOBANK.IVRPAY.Rows.Count.ToString().Trim() + " IVR RECORDS complete. ***", "IVR Payments Import");
}
else
{
MessageBox.Show("*** NO IVR RECORDS FOUND! ***", "IVR Payments Import");
}
IVRPAYTableAdapter.Dispose();
AUTOBANK.Dispose();
}
private void PrintDelinquencyReport()
{
DateTime ldCurrDate = ((DateTime)(nullableDateTimePickerDueDate.Value)).Date;
IACDataSet DelinquencyData = new IACDataSet();
IACDataSetTableAdapters.ClosedDealerAgedSummarySelectTableAdapter ClosedDealerAgedSummarySelectTableAdapter = new IACDataSetTableAdapters.ClosedDealerAgedSummarySelectTableAdapter();
IACDataSetTableAdapters.ClosedDealerAgedSummarySelectCOLTableAdapter ClosedDealerAgedSummarySelectCOLTableAdapter = new IACDataSetTableAdapters.ClosedDealerAgedSummarySelectCOLTableAdapter();
IACDataSetTableAdapters.CUSTOMERTableAdapter CUSTOMERTableAdapter = new IACDataSetTableAdapters.CUSTOMERTableAdapter();
IACDataSetTableAdapters.DEALERTableAdapter DEALERTableAdapter = new IACDataSetTableAdapters.DEALERTableAdapter();
Int32 lnAgedTest = comboBoxAgedPeriod.SelectedIndex + 1;
// Moses Newman 11/20/2018 add sort order.
String lsSortType = null;
if (comboBoxSortType.SelectedIndex == 1)
{
lsSortType = "D";
}
MDIIAC2013 MDImain = (MDIIAC2013)MdiParent;
switch (lnAgedTest)
{
case 1:
case 2:
case 3:
case 4:
case 5:
case 6:
if (!checkBoxCollections.Checked)
{
CUSTOMERTableAdapter.FillByDelinquencies(DelinquencyData.CUSTOMER, lnAgedTest, ldCurrDate, lsSortType);
// Moses Newman 11/19/2013 Moses Newman added ldCurrDate as new parameter to DealerFillByDelinQuencies Query
DEALERTableAdapter.FillByDelinquencies(DelinquencyData.DEALER, lnAgedTest, ldCurrDate);
if (DelinquencyData.CUSTOMER.Rows.Count != 0 && DelinquencyData.DEALER.Rows.Count != 0)
{
Hide();
MDImain.CreateFormInstance("ReportViewer", false);
ReportViewer rptViewer = (ReportViewer)MDImain.ActiveMdiChild;
ClosedCustomerDelinquency myReportObject = new ClosedCustomerDelinquency();
myReportObject.SetDataSource(DelinquencyData);
myReportObject.SetParameterValue("gsUserID", Program.gsUserID);
myReportObject.SetParameterValue("gsUserName", Program.gsUserName);
myReportObject.SetParameterValue("gnAgedMonths", comboBoxAgedPeriod.SelectedIndex + 1);
myReportObject.SetParameterValue("gdCurrentDate", ldCurrDate);
rptViewer.crystalReportViewer.ReportSource = myReportObject;
rptViewer.crystalReportViewer.Refresh();
rptViewer.Show();
}
}
else
{
CUSTOMERTableAdapter.FillByDelinquenciesCOL(DelinquencyData.CUSTOMER, lnAgedTest, ldCurrDate, lsSortType);
// Moses Newman 11/19/2013 Moses Newman added ldCurrDate as new parameter to DealerFillByDelinQuencies Query
DEALERTableAdapter.FillByDelinquenciesCOL(DelinquencyData.DEALER, lnAgedTest, ldCurrDate);
if (DelinquencyData.CUSTOMER.Rows.Count != 0 && DelinquencyData.DEALER.Rows.Count != 0)
{
Hide();
MDImain.CreateFormInstance("ReportViewer", false);
ReportViewer rptViewer = (ReportViewer)MDImain.ActiveMdiChild;
ClosedCustomerDelinquencyCOL myReportObject = new ClosedCustomerDelinquencyCOL();
myReportObject.SetDataSource(DelinquencyData);
myReportObject.SetParameterValue("gsUserID", Program.gsUserID);
myReportObject.SetParameterValue("gsUserName", Program.gsUserName);
myReportObject.SetParameterValue("gnAgedMonths", comboBoxAgedPeriod.SelectedIndex + 1);
myReportObject.SetParameterValue("gdCurrentDate", ldCurrDate);
rptViewer.crystalReportViewer.ReportSource = myReportObject;
rptViewer.crystalReportViewer.Refresh();
rptViewer.Show();
}
}
break;
case 7:
if (!checkBoxCollections.Checked)
{
ClosedDealerAgedSummarySelectTableAdapter.SetCommandTimeout(360);
ClosedDealerAgedSummarySelectTableAdapter.Fill(DelinquencyData.ClosedDealerAgedSummarySelect, ldCurrDate);
if (DelinquencyData.ClosedDealerAgedSummarySelect.Rows.Count != 0)
{
Hide();
MDImain.CreateFormInstance("ReportViewer", false);
ReportViewer rptViewer = (ReportViewer)MDImain.ActiveMdiChild;
ClosedCustomerDelinquencySummary myReportObject = new ClosedCustomerDelinquencySummary();
myReportObject.SetDataSource(DelinquencyData);
myReportObject.SetParameterValue("gsUserID", Program.gsUserID);
myReportObject.SetParameterValue("gsUserName", Program.gsUserName);
myReportObject.SetParameterValue("gnAgedMonths", comboBoxAgedPeriod.SelectedIndex + 1);
myReportObject.SetParameterValue("gdCurrentDate", ldCurrDate);
rptViewer.crystalReportViewer.ReportSource = myReportObject;
rptViewer.crystalReportViewer.Refresh();
rptViewer.Show();
}
}
else // Moses Newman 02/24/2015 Add Collections version of Delinquency Summary Report
{
ClosedDealerAgedSummarySelectTableAdapter.SetCommandTimeout(360);
ClosedDealerAgedSummarySelectTableAdapter.Fill(DelinquencyData.ClosedDealerAgedSummarySelect, ldCurrDate);
ClosedDealerAgedSummarySelectCOLTableAdapter.Fill(DelinquencyData.ClosedDealerAgedSummarySelectCOL, ldCurrDate);
if (DelinquencyData.ClosedDealerAgedSummarySelect.Rows.Count != 0)
{
Hide();
MDImain.CreateFormInstance("ReportViewer", false);
ReportViewer rptViewer = (ReportViewer)MDImain.ActiveMdiChild;
ClosedCustomerDelinquencySummaryCOL myReportObject = new ClosedCustomerDelinquencySummaryCOL();
myReportObject.SetDataSource(DelinquencyData);
myReportObject.SetParameterValue("gsUserID", Program.gsUserID);
myReportObject.SetParameterValue("gsUserName", Program.gsUserName);
myReportObject.SetParameterValue("gnAgedMonths", comboBoxAgedPeriod.SelectedIndex + 1);
myReportObject.SetParameterValue("gdCurrentDate", ldCurrDate);
rptViewer.crystalReportViewer.ReportSource = myReportObject;
rptViewer.crystalReportViewer.Refresh();
rptViewer.Show();
}
}
break;
case 8:
/*
* IACDataSetTableAdapters.RepoCodesTableAdapter RepoCodesTableAdapter = new IACDataSetTableAdapters.RepoCodesTableAdapter();
* IACDataSetTableAdapters.VEHICLETableAdapter VEHICLETableAdapter = new IACDataSetTableAdapters.VEHICLETableAdapter();
* CUSTOMERTableAdapter.FillByDelinquenciesCOL(DelinquencyData.CUSTOMER, 9, ldCurrDate);
* // Moses Newman 11/19/2013 Moses Newman added ldCurrDate as new parameter to DealerFillByDelinQuencies Query
* DEALERTableAdapter.FillByDelinquenciesCOL(DelinquencyData.DEALER, 9, ldCurrDate);
* RepoCodesTableAdapter.Fill(DelinquencyData.RepoCodes);
* VEHICLETableAdapter.FillByRepo(DelinquencyData.VEHICLE);
* if (DelinquencyData.CUSTOMER.Rows.Count != 0 && DelinquencyData.DEALER.Rows.Count != 0)
* {
* Hide();
* MDImain.CreateFormInstance("ReportViewer", false);
* ReportViewer rptViewer = (ReportViewer)MDImain.ActiveMdiChild;
*
* ClosedCustomerDelinquencyRepoReport myReportObject = new ClosedCustomerDelinquencyRepoReport();
* myReportObject.SetDataSource(DelinquencyData);
* myReportObject.SetParameterValue("gsUserID", Program.gsUserID);
* myReportObject.SetParameterValue("gsUserName", Program.gsUserName);
* myReportObject.SetParameterValue("gnAgedMonths", 8);
* myReportObject.SetParameterValue("gdCurrentDate", ldCurrDate);
* rptViewer.crystalReportViewer.ReportSource = myReportObject;
* rptViewer.crystalReportViewer.Refresh();
* rptViewer.Show();
* }
* VEHICLETableAdapter.Dispose();
* RepoCodesTableAdapter.Dispose();*/
break;
}
DelinquencyData.Clear();
DelinquencyData.Dispose();
CUSTOMERTableAdapter.Dispose();
DEALERTableAdapter.Dispose();
ClosedDealerAgedSummarySelectTableAdapter.Dispose();
ClosedDealerAgedSummarySelectCOLTableAdapter.Dispose();
}
private void ReadPCPAYFILE(IACDataSet PCPAY)
{
PaymentDataSet IVR = new PaymentDataSet();
SQLBackupandRestore SQLBR = new SQLBackupandRestore();
IACDataSetTableAdapters.IVRPAYTableAdapter IVRPAYTableAdapter = new IACDataSetTableAdapters.IVRPAYTableAdapter();
IACDataSetTableAdapters.PAYMENTTableAdapter PAYMENTTableAdapter = new IACDataSetTableAdapters.PAYMENTTableAdapter();
PaymentDataSetTableAdapters.IVRRejectsTableAdapter IVRRejectsTableAdapter = new PaymentDataSetTableAdapters.IVRRejectsTableAdapter();
if (SQLBR.RunJob("IVRIMPORT", "Import from IVR", false))
{
Thread.Sleep(5000);
try
{
IVRPAYTableAdapter.Fill(PCPAY.IVRPAY);
}
catch
{
IVRPAYTableAdapter.Fill(PCPAY.IVRPAY);
}
}
// Moses Newman 09/25/2018 Create Rejects Report if any customers are Inactive.
if (PCPAY.IVRPAY.Rows.Count != 0)
{
IVRRejectsTableAdapter.Create();
IVRRejectsTableAdapter.FillByAll(IVR.IVRRejects);
if (IVR.IVRRejects.Rows.Count > 0)
{
MDIIAC2013 MDImain = (MDIIAC2013)MdiParent;
Hide();
MDImain.CreateFormInstance("ReportViewer", false);
ReportViewer rptViewer = (ReportViewer)MDImain.ActiveMdiChild;
IVRRejects myReportObject = new IVRRejects();
myReportObject.SetDataSource(IVR);
myReportObject.SetParameterValue("gsUserID", Program.gsUserID);
myReportObject.SetParameterValue("gsUserName", Program.gsUserName);
myReportObject.SetParameterValue("gsTitle", "IVR PAYMENT REJECTS REPORT");
rptViewer.crystalReportViewer.ReportSource = myReportObject;
rptViewer.crystalReportViewer.Refresh();
rptViewer.Show();
}
}
if (SQLBR.RunJob("IVRToPayment", "Move IVR to PAYMENT", false))
{
Thread.Sleep(5000);
try
{
PAYMENTTableAdapter.FillByAll(PCPAY.PAYMENT);
}
catch
{
PAYMENTTableAdapter.FillByAll(PCPAY.PAYMENT);
}
}
PCPAY.IVRPAY.Clear();
IVRPAYTableAdapter.Dispose();
PAYMENTTableAdapter.Dispose();
PCPAY.Dispose();
}
