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