public void Reset1() { SupplierTypecomboBox.SelectedIndex = -1; SupplierNametextBox.Clear(); PhonetextBox.Clear(); FaxtextBox.Clear(); EmailAddresstextBox.Clear(); WebSiteUrltextBox.Clear(); CustomerCodetextBox.Clear(); ResetCorporateAddress(); }
private void SupplierNametextBox_Leave(object sender, EventArgs e) { if (!string.IsNullOrEmpty(SupplierNametextBox.Text)) { string suppliername = SupplierNametextBox.Text.Trim(); Regex mRegxExpression; int Minlen = 3; mRegxExpression = new Regex(@"^[A-Za-z]+[\s][A-Za-z]+[.][A-Za-z]+$"); if ((!mRegxExpression.IsMatch(suppliername)) && (!(SupplierNametextBox.Text.Length >= Minlen))) { MessageBox.Show("Name at least Three letters!", "MojoCRM", MessageBoxButtons.OK, MessageBoxIcon.Error); SupplierNametextBox.Clear(); SupplierNametextBox.Focus(); } } }
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); }
private bool ValidateControlls() { bool validate = true; if (!companyCreated) { MessageBox.Show(@"Company is not created Yet" + "\n" + @"Please Create Company First", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Hand); validate = false; } else if (string.IsNullOrEmpty(SupplierTypecomboBox.Text)) { MessageBox.Show(@"Please select Supplier Type", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); validate = false; SupplierTypecomboBox.Focus(); } else if (string.IsNullOrEmpty(SupplierNametextBox.Text)) { MessageBox.Show(@"Please enter Supplier name", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); validate = false; SupplierNametextBox.Focus(); } if (CountrycomboBox.Text == "Bangladesh") { if (string.IsNullOrEmpty(cDivisionCombo.Text)) { MessageBox.Show(@"Please select division", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); validate = false; cDivisionCombo.Focus(); } else if (string.IsNullOrWhiteSpace(cDistCombo.Text)) { MessageBox.Show(@"Please Select district", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); validate = false; cDistCombo.Focus(); } else if (string.IsNullOrWhiteSpace(cThanaCombo.Text)) { MessageBox.Show(@"Please select Thana", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); validate = false; cThanaCombo.Focus(); } else if (string.IsNullOrWhiteSpace(cPostOfficeCombo.Text)) { MessageBox.Show(@"Please Select Post Office", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); validate = false; cPostOfficeCombo.Focus(); } } else { if (string.IsNullOrWhiteSpace(StreettextBox.Text) && string.IsNullOrWhiteSpace(StatetextBox.Text) && string.IsNullOrWhiteSpace(PostalCodetextBox.Text)) { MessageBox.Show("Please enter Addresses!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); validate = false; StreettextBox.Focus(); } } if (ValidateSupplier()) { validate = false; } return(validate); }