private void TextBoxCutomerNo_Validated(object sender, EventArgs e)
{
if (TextBoxCutomerNo.Text.ToString().Trim().Length < 6 && TextBoxCutomerNo.Text.ToString().Trim().Length > 0)
{
TextBoxCutomerNo.Text = TextBoxCutomerNo.Text.Trim().PadLeft(6, '0');
}
lsCustomerNo = TextBoxCutomerNo.Text.ToString().Trim();
if (lsCustomerNo == "") // Moses Newman 03/02/2012 previously only returned if in Add Mode!!!
{
return;
}
CUSTOMERTableAdapter.Fill(gsData.CUSTOMER, lsCustomerNo);
if (gsData.CUSTOMER.Rows.Count > 0)
{
TextBoxFirstName.Text = gsData.CUSTOMER.Rows[0].Field <String>("CUSTOMER_FIRST_NAME");
TextBoxFirstName.Refresh();
TextBoxLastName.Text = gsData.CUSTOMER.Rows[0].Field <String>("CUSTOMER_LAST_NAME");
TextBoxLastName.Refresh();
textBoxSSNLast4.Text = gsData.CUSTOMER.Rows[0].Field <String>("CUSTOMER_SS_3");
textBoxSSNLast4.Refresh();
comboBoxSide.Text = "CLOSED";
comboBoxSide.Refresh();
nullableDateTimePickerArchivedDate.Value = DateTime.Now;
nullableDateTimePickerArchivedDate.Refresh();
textBoxDealerNo.Text = gsData.CUSTOMER.Rows[0].Field <String>("CUSTOMER_DEALER");
textBoxDealerNo.Refresh();
DEALERTableAdapter.Fill(gsData.DEALER, gsData.CUSTOMER.Rows[0].Field <String>("CUSTOMER_DEALER"));
if (gsData.DEALER.Rows.Count > 0)
{
textBoxDealerName.Text = gsData.DEALER.Rows[0].Field <String>("DEALER_NAME");
textBoxDealerName.Refresh();
}
IsFound = true;
}
else
{
OPNCUSTTableAdapter.Fill(gsData.OPNCUST, lsCustomerNo);
if (gsData.OPNCUST.Rows.Count > 0)
{
TextBoxFirstName.Text = gsData.OPNCUST.Rows[0].Field <String>("CUSTOMER_FIRST_NAME");
TextBoxFirstName.Refresh();
TextBoxLastName.Text = gsData.OPNCUST.Rows[0].Field <String>("CUSTOMER_LAST_NAME");
TextBoxLastName.Refresh();
textBoxSSNLast4.Text = gsData.OPNCUST.Rows[0].Field <String>("CUSTOMER_SS_3");
textBoxSSNLast4.Refresh();
comboBoxSide.Text = "OPEN";
comboBoxSide.Refresh();
nullableDateTimePickerArchivedDate.Value = DateTime.Now;
nullableDateTimePickerArchivedDate.Refresh();
textBoxDealerNo.Text = gsData.OPNCUST.Rows[0].Field <String>("CUSTOMER_DEALER");
textBoxDealerNo.Refresh();
OPNDEALRTableAdapter.Fill(gsData.OPNDEALR, gsData.OPNCUST.Rows[0].Field <String>("CUSTOMER_DEALER"));
if (gsData.OPNDEALR.Rows.Count > 0)
{
textBoxDealerName.Text = gsData.OPNDEALR.Rows[0].Field <String>("OPNDEALR_NAME");
textBoxDealerName.Refresh();
}
IsFound = true;
}
}
}
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);
}