private void PrintClosedTrialBalance(ReportViewer rptViewer)
{
String lsDealerNum = comboBoxDealer.Text.TrimEnd().TrimStart() + "%", lsState;
lsState = (comboBoxState.SelectedValue != null) ? comboBoxState.SelectedValue.ToString().TrimStart().TrimEnd() + "%" : "%";
IACDataSetTableAdapters.CUSTOMERTableAdapter CUSTOMERTableAdapter = new IACDataSetTableAdapters.CUSTOMERTableAdapter();
IACDataSetTableAdapters.DEALERTableAdapter DEALERTableAdapter = new IACDataSetTableAdapters.DEALERTableAdapter();
IACDataSetTableAdapters.WS_DEALER_TRIAL_BALANCETableAdapter WS_DEALER_TRIAL_BALANCETableAdapter = new IACDataSetTableAdapters.WS_DEALER_TRIAL_BALANCETableAdapter();
IACDataSetTableAdapters.MastHistTotalsTableAdapter MastHistTotalsTableAdapter = new IACDataSetTableAdapters.MastHistTotalsTableAdapter();
// Moses Newman 05/3/2014 Get rid of SQL Pass Through!
CUSTOMERTableAdapter.FillByStateDealer(iACDataSet.CUSTOMER, lsState, lsDealerNum);
DEALERTableAdapter.FillByCustomerStateDealer(iACDataSet.DEALER, lsState, lsDealerNum);
WS_DEALER_TRIAL_BALANCETableAdapter.FillByStateDealer(iACDataSet.WS_DEALER_TRIAL_BALANCE, lsState, lsDealerNum);
MastHistTotalsTableAdapter.Fill(iACDataSet.MastHistTotals, "C");
ClosedLoanTrialBalance myReportObject = new ClosedLoanTrialBalance();
myReportObject.SetDataSource(iACDataSet);
myReportObject.SetParameterValue("gsUserID", Program.gsUserID);
myReportObject.SetParameterValue("gsUserName", Program.gsUserName);
rptViewer.crystalReportViewer.ReportSource = myReportObject;
rptViewer.crystalReportViewer.Refresh();
rptViewer.Show();
}
private void buttonExcel_Click(object sender, EventArgs e)
{
SQLBackupandRestore SQLBR = new SQLBackupandRestore();
TrialBalancePretty TBP = new TrialBalancePretty();
String lsDealerNum = comboBoxDealer.Text.TrimEnd().TrimStart() + "%", lsState;
lsState = (comboBoxState.SelectedValue != null) ? comboBoxState.SelectedValue.ToString().TrimStart().TrimEnd() + "%" : "%";
IACDataSetTableAdapters.CUSTOMERTableAdapter CUSTOMERTableAdapter = new IACDataSetTableAdapters.CUSTOMERTableAdapter();
IACDataSetTableAdapters.ClosedDealerSummaryTableAdapter ClosedDealerSummaryTableAdapter = new IACDataSetTableAdapters.ClosedDealerSummaryTableAdapter();
IACDataSetTableAdapters.WS_DEALER_TRIAL_BALANCETableAdapter WS_DEALER_TRIAL_BALANCETableAdapter = new IACDataSetTableAdapters.WS_DEALER_TRIAL_BALANCETableAdapter();
// Moses Newman 05/3/2014 Get rid of SQL Pass Through!
CUSTOMERTableAdapter.FillByStateDealer(iACDataSet.CUSTOMER, lsState, lsDealerNum);
ClosedDealerSummaryTableAdapter.Fill(iACDataSet.ClosedDealerSummary, DateTime.Now.Month, DateTime.Now.Year);
WS_DEALER_TRIAL_BALANCETableAdapter.FillByStateDealer(iACDataSet.WS_DEALER_TRIAL_BALANCE, lsState, lsDealerNum);
Int32 elapsed = 0;
if (SQLBR.RunJob("TrialBalance", "Export Trial Balance To EXCEL", false))
{
TBP.IACType = "C";
TBP.CustDealerCount = iACDataSet.CUSTOMER.Rows.Count;
TBP.DealerCount = iACDataSet.WS_DEALER_TRIAL_BALANCE.Rows.Count;
TBP.DealerSummaryCount = iACDataSet.ClosedDealerSummary.Rows.Count;
TBP.FullSourcePath = @"\\Dc-iac\public\AccStuff\mfdata\comp1000\ClosedTrialBalance.xlsx";
Thread.Sleep(5000);
var fi1 = new FileInfo(TBP.FullSourcePath);
while (TBP.IsFileLocked(fi1) && elapsed < 500000)
{
Thread.Sleep(1000);
elapsed += 1000;
}
TBP.TBPRetty();
}
}
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();
}
