private void toolStripButtonSave_Click(object sender, EventArgs e)
{
string lsDealerNo = "";
Validate(); //Validate form so all data sets are updated with field values
DealerbindingSource.EndEdit();
lsDealerNo = DEALERcomboBox.Text.ToString().Trim();
tableAdapConn = new System.Data.SqlClient.SqlConnection();
tableAdapConn.ConnectionString = IAC2018SQL.Properties.Settings.Default.IAC2010SQLConnectionString;
tableAdapConn.Open();
dEALERTableAdapter.Connection = tableAdapConn;
tableAdapTran = dEALERTableAdapter.BeginTransaction();
dEALERTableAdapter.Transaction = tableAdapTran;
try
{
dEALERTableAdapter.Update(iacDataSet.DEALER.Rows[DealerbindingSource.Position]);
tableAdapTran.Commit();
}
catch (System.Data.SqlClient.SqlException ex)
{
tableAdapTran.Rollback();
MessageBox.Show("This is a Microsoft SQL Server database error: " + ex.Message.ToString());
}
catch (System.InvalidOperationException ex)
{
tableAdapTran.Rollback();
MessageBox.Show("Invalid Operation Error: " + ex.Message.ToString());
}
catch (Exception ex)
{
tableAdapTran.Rollback();
MessageBox.Show("General Exception Error: " + ex.Message.ToString());
}
finally
{
dEALERTableAdapter.UnlockRecord(iacDataSet.DEALER.Rows[DealerbindingSource.Position].Field <String>("DEALER_ACC_NO"));
tableAdapConn.Close();
tableAdapConn = null;
tableAdapTran = null;
toolStripButtonSave.Enabled = false;
if (lbAddFlag)
{
lbAddFlag = false;
iacDataSet.DEALER.Clear();
StartUpConfiguration();
}
iacDataSet.AcceptChanges();
Program.gsKey = lsDealerNo;
DEALERcomboBox.Text = lsDealerNo;
if (lbEdit)
{
lbEdit = false;
SetViewMode();
}
}
}
private void setRelatedData()
{
Double lnContOSLoansRatio;
if (lbAddFlag || lbEdit)
{
return;
}
if (DEALERcomboBox.Text.ToString().TrimEnd().Length > 0)
{
iacDataSet.DEALER.Clear();
iacDataSet.DEALHIST.Clear();
dEALERTableAdapter.Fill(iacDataSet.DEALER, DEALERcomboBox.Text.ToString().TrimEnd());
if (iacDataSet.DEALER.Rows.Count > 0)
{
dEALHISTTableAdapter.FillAllByDealerAcc(iacDataSet.DEALHIST, DEALERcomboBox.Text.ToString().TrimEnd());
lnContOSLoansRatio = 0;
if (iacDataSet.DEALER.Rows[0].Field <Nullable <Decimal> >("DEALER_YTD_OLOAN") != null)
{
if (iacDataSet.DEALER.Rows[0].Field <Decimal>("DEALER_YTD_OLOAN") != 0)
{
lnContOSLoansRatio = Convert.ToDouble(iacDataSet.DEALER.Rows[0].Field <Decimal>("DEALER_YTD_CONT") / iacDataSet.DEALER.Rows[0].Field <Decimal>("DEALER_YTD_OLOAN"));
}
}
ResperOSLoanstextBox.Text = (lnContOSLoansRatio != 0) ? lnContOSLoansRatio.ToString("P", new System.Globalization.CultureInfo("en-US")):"";
ResperOSLoanstextBox2.Text = ResperOSLoanstextBox.Text;
dLRLISTBYNUMTableAdapter.Fill(iacDataSet.DLRLISTBYNUM);
dEALERLISTTableAdapter.FillAll(iacDataSet.DEALERLIST);
DEALERcomboBox.Text = (Program.gsKey != null) ? Program.gsKey : "";
//DealerListbindingSource.Position = DealerListbindingSource.Find("DEALER_ACC_NO", (object)DEALERcomboBox.Text);
}
else
{
var ldlgAnswer = MessageBox.Show("Sorry no dealer found that matches your selected dealer number! Would you like to add a new record?", "Add New Prompt", MessageBoxButtons.YesNo);
if (ldlgAnswer == DialogResult.No)
{
DealerNamecomboBox.Text = "";
ActiveControl = DealerNamecomboBox;
DealerNamecomboBox.SelectAll();
}
else
{
lbAddFlag = true;
iacDataSet.DEALER.Clear();
DealerbindingSource.AddNew();
DealerbindingSource.EndEdit();
// Set NULL VALUES to empty string
iacDataSet.DEALER.Rows[DealerbindingSource.Position].SetField <String>("DEALER_ACC_NO", DEALERcomboBox.Text);
iacDataSet.DEALER.Rows[DealerbindingSource.Position].SetField <String>("DEALER_STATUS", "A");
iacDataSet.DEALER.Rows[DealerbindingSource.Position].SetField <DateTime>("DEALER_POST_DATE", DateTime.Now.Date);
iacDataSet.DEALER.Rows[DealerbindingSource.Position].SetField <DateTime>("DealerStartDate", DateTime.Now.Date);
iacDataSet.DEALER.Rows[DealerbindingSource.Position].SetField <String>("CellPhone", "");
iacDataSet.DEALER.Rows[DealerbindingSource.Position].SetField <String>("DEALER_NAME", "");
iacDataSet.DEALER.Rows[DealerbindingSource.Position].SetField <String>("DEALER_ADDR", "");
iacDataSet.DEALER.Rows[DealerbindingSource.Position].SetField <String>("DEALER_HOME_PHONE", "");
iacDataSet.DEALER.Rows[DealerbindingSource.Position].SetField <String>("DEALER_CITY", "");
iacDataSet.DEALER.Rows[DealerbindingSource.Position].SetField <String>("DEALER_ST", "");
iacDataSet.DEALER.Rows[DealerbindingSource.Position].SetField <String>("DEALER_WORK_PHONE", "");
iacDataSet.DEALER.Rows[DealerbindingSource.Position].SetField <String>("DEALER_ZIP", "");
DealerNamecomboBox.Enabled = false;
nullableDateTimePickerDealerStartDate.Enabled = true;
DEALER_STREETTextBox.Enabled = true;
DealerCityTextBox.Enabled = true;
DealerStateTextBox.Enabled = true;
DealerZipTextBox.Enabled = true;
DealerHomePhoneTextBox.Enabled = true;
maskedTextBoxCellPhone.Enabled = true;
DEALERWorkPhoneTextBox.Enabled = true;
textBoxDealerEmail.Enabled = true;
dEALER_NAMETextBox.Enabled = true;
toolStripButtonEdit.Enabled = false;
DEALERcomboBox.Enabled = false;
DealerNamecomboBox.Enabled = false;
ActiveControl = dEALER_NAMETextBox;
dEALER_NAMETextBox.SelectAll();
}
}
}
}
