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