private void WebSiteUrltextBox_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { CustomerCodetextBox.Focus(); e.Handled = true; } }
public void Reset1() { SupplierTypecomboBox.SelectedIndex = -1; SupplierNametextBox.Clear(); PhonetextBox.Clear(); FaxtextBox.Clear(); EmailAddresstextBox.Clear(); WebSiteUrltextBox.Clear(); CustomerCodetextBox.Clear(); ResetCorporateAddress(); }
private bool ValidateSupplier() { List <Supplier> suppliers = new List <Supplier>(); con = new SqlConnection(cs.DBConn); con.Open(); string ct3 = "SELECT SupplierName, Phone, Fax, Email, WebSiteUrl, Code FROM Supplier where Supplier.SupplierName='" + SupplierNametextBox.Text + "'"; cmd = new SqlCommand(ct3, con); rdr = cmd.ExecuteReader(); while (rdr.Read()) { if (rdr.HasRows) { Supplier x = new Supplier(); x.Name = rdr.GetString(0); if (!DBNull.Value.Equals(rdr["Phone"])) { x.Phone = rdr.GetString(1); } else { x.Phone = null; } if (!DBNull.Value.Equals(rdr["Fax"])) { x.Fax = rdr.GetString(2); } else { x.Fax = null; } if (!DBNull.Value.Equals(rdr["Email"])) { x.Email = rdr.GetString(3); } else { x.Email = null; } if (!DBNull.Value.Equals(rdr["WebSiteUrl"])) { x.WebSiteUrl = rdr.GetString(4); } else { x.WebSiteUrl = null; } if (!DBNull.Value.Equals(rdr["Code"])) { x.Code = rdr.GetString(5); } else { x.Code = null; } suppliers.Add(x); } } foreach (Supplier p in suppliers) { if (p.Name == SupplierNametextBox.Text && p.Phone == PhonetextBox.Text) { MessageBox.Show(@"This Person Exists,Please Input another one" + "\n" + @"Or Use another Phone", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); SupplierNametextBox.Clear(); PhonetextBox.Clear(); //WebServiceUrltextBox.Clear(); //EmailAddresstextBox.Clear(); //VendorNametextBox.Focus(); con.Close(); return(true); } if (p.Name == SupplierNametextBox.Text && p.Fax == FaxtextBox.Text) { MessageBox.Show(@"This Person Exists,Please Input another one" + "\n" + @"Or Use another Fax", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); SupplierNametextBox.Clear(); FaxtextBox.Clear(); //WebServiceUrltextBox.Clear(); //EmailAddresstextBox.Clear(); //VendorNametextBox.Focus(); con.Close(); return(true); } if (p.Name == SupplierNametextBox.Text && p.Email == EmailAddresstextBox.Text) { MessageBox.Show(@"This Person Exists,Please Input another one" + "\n" + @"Or Use another Email", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); SupplierNametextBox.Clear(); //PhonetextBox.Clear(); //WebServiceUrltextBox.Clear(); EmailAddresstextBox.Clear(); con.Close(); return(true); } if (p.Name == SupplierNametextBox.Text && p.WebSiteUrl == WebSiteUrltextBox.Text) { MessageBox.Show( @"This Person Exists,Please Input another one" + "\n" + @"Or Use another Web Service URL", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); SupplierNametextBox.Clear(); //PhonetextBox.Clear(); WebSiteUrltextBox.Clear(); //EmailAddresstextBox.Clear(); con.Close(); return(true); } if (p.Name == SupplierNametextBox.Text && p.Code == CustomerCodetextBox.Text) { MessageBox.Show( @"This Person Exists,Please Input another one" + "\n" + @"Or Use another Customer Code", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); SupplierNametextBox.Clear(); //PhonetextBox.Clear(); CustomerCodetextBox.Clear(); //EmailAddresstextBox.Clear(); con.Close(); return(true); } } return(false); }