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 PostUpdateAmount(Int32 UpdatePos)
{
Int32 CustomerPos;
BindingSource OPNCUSTBindingSource = new BindingSource();
IACDataSetTableAdapters.OPNCUSTTableAdapter OPNCUSTTableAdapter = new IACDataSetTableAdapters.OPNCUSTTableAdapter();
OPNCUSTTableAdapter.Fill(AddOniacDataSet.OPNCUST, AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <String>("UPDATE_CUSTOMER"));
if (AddOniacDataSet.OPNCUST.Rows.Count == 0)
{
return;
}
else
{
CustomerPos = 0;
}
OPNCUSTBindingSource.DataSource = AddOniacDataSet.OPNCUST;
OPNCUSTBindingSource.Position = CustomerPos;
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Decimal>("CUSTOMER_BALANCE", AddOniacDataSet.OPNCUST.Rows[CustomerPos].Field <Decimal>("CUSTOMER_BALANCE") + AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Decimal>("UPDATE_AMOUNT_RCV"));
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Decimal>("CUSTOMER_UPDATE_AMOUNT", AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Decimal>("UPDATE_AMOUNT_RCV"));
lnBalance += AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Decimal>("UPDATE_AMOUNT_RCV");
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <String>("CUSTOMER_PAY_REM_1", "ADD");
// Moses Newman 01/31/2014 Fix UPDATE_NEW_REG_AMOUNT filed so it is populated with 0 and NOT NULL as default value.
if (AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Nullable <Decimal> >("UPDATE_NEW_REG_AMOUNT") == null)
{
AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].SetField <Decimal>("UPDATE_NEW_REG_AMOUNT", 0);
}
if (AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Decimal>("UPDATE_NEW_REG_AMOUNT") != 0)
{
if (AddOniacDataSet.OPNCUST.Rows[CustomerPos].Field <Decimal>("CUSTOMER_REGULAR_AMOUNT") != AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Decimal>("UPDATE_NEW_REG_AMOUNT"))
{
if (AddOniacDataSet.OPNCUST.Rows[CustomerPos].Field <Decimal>("CUSTOMER_REG_AMOUNT1") == 0)
{
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Decimal>("CUSTOMER_REG_AMOUNT1", AddOniacDataSet.OPNCUST.Rows[CustomerPos].Field <Decimal>("CUSTOMER_REGULAR_AMOUNT"));
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Int32>("CUSTOMER_STAT1", AddOniacDataSet.OPNCUST.Rows[CustomerPos].Field <Int32>("CUSTOMER_STATUS_NO"));
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Int32>("CUSTOMER_STATUS_NO", 0);
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Decimal>("CUSTOMER_REGULAR_AMOUNT", AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Decimal>("UPDATE_NEW_REG_AMOUNT"));
}
else
if (AddOniacDataSet.OPNCUST.Rows[CustomerPos].Field <Decimal>("CUSTOMER_REG_AMOUNT2") == 0)
{
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Decimal>("CUSTOMER_REG_AMOUNT2", AddOniacDataSet.OPNCUST.Rows[CustomerPos].Field <Decimal>("CUSTOMER_REGULAR_AMOUNT"));
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Int32>("CUSTOMER_STAT2", AddOniacDataSet.OPNCUST.Rows[CustomerPos].Field <Int32>("CUSTOMER_STATUS_NO"));
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Int32>("CUSTOMER_STATUS_NO", 0);
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Decimal>("CUSTOMER_REGULAR_AMOUNT", AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Decimal>("UPDATE_NEW_REG_AMOUNT"));
}
else
{
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Decimal>("CUSTOMER_REGULAR_AMOUNT", AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Decimal>("UPDATE_NEW_REG_AMOUNT"));
}
}
}
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Int32>("CUSTOMER_STATE1", AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Int32>("UPDATE_STATE_CODE"));
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Decimal>("CUSTOMER_INTEREST_RATE1", AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Decimal>("UPDATE_INT1"));
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Decimal>("CUSTOMER_INTEREST_RATE2", AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Decimal>("UPDATE_INT2"));
AddOniacDataSet.OPNCUST.Rows[CustomerPos].SetField <Decimal>("CUSTOMER_INTEREST_RATE3", AddOniacDataSet.OPNUPDAT.Rows[UpdatePos].Field <Decimal>("UPDATE_INT3"));
lnMASTER_OS_LOANS += lnBalance;
OPNCUSTBindingSource.EndEdit();
OPNCUSTTableAdapter.Update(AddOniacDataSet.OPNCUST.Rows[CustomerPos]);
AddOniacDataSet.OPNCUST.AcceptChanges();
CustomerHistory(CustomerPos, UpdatePos);
}
