private void CompanyTypecomboBox_SelectedIndexChanged(object sender, EventArgs e)
{
VendorNametextBox.Focus();
try
{
con = new SqlConnection(cs.DBConn);
con.Open();
cmd = con.CreateCommand();
cmd.CommandText = "SELECT CompanyTypeId from VendorCompanyType WHERE CompanyTypeName= '" + CompanyTypecomboBox.Text + "'";
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
companytypeid = rdr.GetInt32(0);
}
if ((rdr != null))
{
rdr.Close();
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void VendorNametextBox_Leave(object sender, EventArgs e)
{
// int Minlen = 3;
//if (!(VendorNametextBox.Text.Length >= Minlen))
//{
// MessageBox.Show("input atleast 3 Character");
//// VendorNametextBox.Clear();
// VendorNametextBox.Focus();
// }
if (!string.IsNullOrEmpty(VendorNametextBox.Text))
{
string vendorname = VendorNametextBox.Text.Trim();
Regex mRegxExpression;
int Minlen = 3;
mRegxExpression = new Regex(@"^[A-Za-z]+[\s][A-Za-z]+[.][A-Za-z]+$");
if ((!mRegxExpression.IsMatch(vendorname)) && (!(VendorNametextBox.Text.Length >= Minlen)))
{
MessageBox.Show("Please type your valid Vendor Name.", "MojoCRM", MessageBoxButtons.OK, MessageBoxIcon.Error);
VendorNametextBox.Clear();
VendorNametextBox.Focus();
}
}
}
private void CompanyTypecomboBox_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
VendorNametextBox.Focus();
e.Handled = true;
}
}
public void ResetAll()
{
//CompanyTypecomboBox.Items.Clear();
CompanyTypecomboBox.SelectedIndex = -1;
VendorNametextBox.Clear();
PhonetextBox.Clear();
EmailAddresstextBox.Clear();
WebServiceUrltextBox.Clear();
ResetResidentialAddress();
}
private bool ValidateControlls()
{
bool validate = true;
if (string.IsNullOrEmpty(CompanyTypecomboBox.Text))
{
MessageBox.Show(@"Please select Company Type", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
validate = false;
CompanyTypecomboBox.Focus();
}
else if (string.IsNullOrEmpty(VendorNametextBox.Text))
{
MessageBox.Show(@"Please enter Vendor name", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
validate = false;
VendorNametextBox.Focus();
}
else if (string.IsNullOrEmpty(cmbRADivision.Text))
{
MessageBox.Show(@"Please select division", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
validate = false;
cmbRADivision.Focus();
}
else if (string.IsNullOrWhiteSpace(cmbRADistrict.Text))
{
MessageBox.Show(@"Please Select district", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
validate = false;
cmbRADistrict.Focus();
}
else if (string.IsNullOrWhiteSpace(cmbRAThana.Text))
{
MessageBox.Show(@"Please select Thana", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
validate = false;
cmbRAThana.Focus();
}
else if (string.IsNullOrWhiteSpace(cmbRAPost.Text))
{
MessageBox.Show(@"Please Select Post Office", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
validate = false;
cmbRAPost.Focus();
}
else if (ValidateVendor())
{
validate = false;
}
return(validate);
}
private bool ValidateVendor()
{
List <Vendor> vendors = new List <Vendor>();
con = new SqlConnection(cs.DBConn);
con.Open();
string ct3 =
"SELECT V_Name, Phone, Email, WebUrl FROM tblVendor where tblVendor.V_Name='" +
VendorNametextBox.Text + "'";
cmd = new SqlCommand(ct3, con);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
if (rdr.HasRows)
{
Vendor x = new Vendor();
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["Email"]))
{
x.Email = rdr.GetString(2);
}
else
{
x.Email = null;
}
if (!DBNull.Value.Equals(rdr["WebUrl"]))
{
x.Weburl = rdr.GetString(3);
}
else
{
x.Weburl = null;
}
vendors.Add(x);
}
}
foreach (Vendor p in vendors)
{
if (p.Name == VendorNametextBox.Text && p.Phone == PhonetextBox.Text)
{
MessageBox.Show(@"This Person Exists,Please Input another one" + "\n" + @"Or Use another Phone",
"Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
VendorNametextBox.Clear();
PhonetextBox.Clear();
WebServiceUrltextBox.Clear();
EmailAddresstextBox.Clear();
//VendorNametextBox.Focus();
con.Close();
return(true);
}
if (p.Name == VendorNametextBox.Text && p.Email == EmailAddresstextBox.Text)
{
MessageBox.Show(@"This Person Exists,Please Input another one" + "\n" + @"Or Use another Email",
"Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
VendorNametextBox.Clear();
PhonetextBox.Clear();
WebServiceUrltextBox.Clear();
EmailAddresstextBox.Clear();
con.Close();
return(true);
}
if (p.Name == VendorNametextBox.Text && p.Weburl == WebServiceUrltextBox.Text)
{
MessageBox.Show(
@"This Person Exists,Please Input another one" + "\n" + @"Or Use another Web Service URL",
"Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
VendorNametextBox.Clear();
PhonetextBox.Clear();
WebServiceUrltextBox.Clear();
EmailAddresstextBox.Clear();
con.Close();
return(true);
}
}
return(false);
}
