private void DEALERcomboBox_Validated(object sender, EventArgs e) { if (lbFormClosing || DEALERcomboBox.Text.TrimEnd() == "") { return; } int lnContingentPos = 0, lnSeq = 0; Object loContingentSeq = null; String lsDealerNo = ""; if (DEALERcomboBox.Text.ToString().Trim().Length < 3 && DEALERcomboBox.Text.ToString().Trim().Length > 0) { lbFromDealerNameChange = true; DEALERcomboBox.Text = DEALERcomboBox.Text.PadLeft(3, '0'); } lsDealerNo = DEALERcomboBox.Text; if (!lbEdit) { setRelatedData(); } if (CONTINGiacDataSet.CONTING.Rows.Count != 0) { if (CONTINGbindingSource.Position == -1) { lnContingentPos = CONTINGbindingSource.Find("CONTING_DEALER", lsDealerNo); } else { lnContingentPos = CONTINGbindingSource.Position; } if (lnContingentPos > -1) { if (lbAdd) { return; } else { CONTINGbindingSource.Position = lnContingentPos; } } else { if (!lbAdd) { lsDealerNo = CONTINGiacDataSet.CONTING.Rows[0].Field <String>("CONTINGENT_DEALER"); CONTINGbindingSource.MoveFirst(); } } } else { if (!lbAdd) { return; } } if (CONTINGiacDataSet.DEALER.Rows.Count == 0 && DEALERcomboBox.Text.TrimEnd().Length != 0) { MessageBox.Show("Sorry no dealer found that matches your selected dealer number!"); DEALERcomboBox.Text = ""; DealerNamecomboBox.Text = ""; ActiveControl = DealerNamecomboBox; DealerNamecomboBox.SelectAll(); } else { if (lbEdit) { if (CONTINGiacDataSet.CONTING.Rows.Count == 0) { MessageBox.Show("Sorry no contingent records found that match your selected dealer number!"); ActiveControl = DEALERcomboBox; DEALERcomboBox.Select(); } } if (lbAdd && DEALERcomboBox.Text.ToString().TrimEnd() != "") { CONTINGbindingSource.AddNew(); CONTINGbindingSource.EndEdit(); CONTINGiacDataSet.CONTING.Rows[CONTINGbindingSource.Position].SetField <String>("CONTING_DEALER", DEALERcomboBox.Text.ToString()); CONTINGiacDataSet.CONTING.Rows[CONTINGbindingSource.Position].SetField <DateTime>("CONTING_POST_DATE", DateTime.Now.Date); loContingentSeq = cONTINGTableAdapter.MaxSeqQuery(DEALERcomboBox.Text.ToString(), DateTime.Now.Date); if (loContingentSeq != null) { lnSeq = (int)loContingentSeq + 1; } else { lnSeq = 0; //Closed and Open contingents start with 0 for first sequence number } CONTINGiacDataSet.CONTING.Rows[CONTINGbindingSource.Position].SetField <Int32>("CONTING_ENTRY_SEQ", lnSeq); CONTINGiacDataSet.CONTING.Rows[CONTINGbindingSource.Position].SetField <Char>("CONTING_POST_IND", (Char)(255)); if (CONTINGiacDataSet.CONTING.Rows.Count != 0) { toolStripButtonSave.Enabled = true; } } if (CONTINGiacDataSet.DEALER.Rows.Count > 0 && !lbAdd) { //DealerNamecomboBox.Text = CONTINGiacDataSet.DEALER.Rows[0].Field<String>("DEALER_NAME"); if (lbAdd || lbEdit) { dateTimePickerPostDate.Enabled = true; ActiveControl = dateTimePickerPostDate; dateTimePickerPostDate.Select(); } } } }