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