コード例 #1
0
        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();
                }
            }
        }
コード例 #2
0
        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();
                    }
                }
            }
        }