private void vendorDetailsToolStripMenuItem_Click(object sender, EventArgs e) { Vendor v = new Vendor(); v.Show(); }
private void button1_Click(object sender, EventArgs e) { Vendor v = new Vendor(); v.Show(); }
private void btnSave_Click(object sender, EventArgs e) { if (txtName.Text == "" || txtAddress.Text == "" || txtCity.Text == "" || txtState.Text == "") { MessageBox.Show("Fill All the Required Fields", "", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { if (mtbMobile.Text != "" || mtbContact.Text != "") { if (mtbMobile.Text.Length < 10 && mtbContact.Text.Length < 10) { MessageBox.Show("Incorrect No.", "", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { string valid; Regex strregex = new Regex("([0-9a-zA-Z]([-.\\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\\w]*[0-9a-zA-Z]\\.)+[a-zA-Z]{2,9})"); valid = txtEmail.Text; if (strregex.IsMatch(valid)) { con.Open(); cmd = new SqlCommand("Insert into Vendor(VendorName,Address,City,State,ContactNo,MobileNo,EmailID) values(@b,@c,@d,@e,@f,@g,@h)", con); cmd.Parameters.AddWithValue("@b", txtName.Text); cmd.Parameters.AddWithValue("@c", txtAddress.Text); cmd.Parameters.AddWithValue("@d", txtCity.Text); cmd.Parameters.AddWithValue("@e", txtState.Text); cmd.Parameters.AddWithValue("@f", mtbContact.Text); cmd.Parameters.AddWithValue("@g", mtbMobile.Text); cmd.Parameters.AddWithValue("@h", txtEmail.Text); try { r = cmd.ExecuteNonQuery(); cmd = new SqlCommand("Select VendorID from Vendor", con); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { res = dr[0].ToString(); } } MessageBox.Show("Vendor Unique Number"+":"+""+""+res, "Succesfully Added", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception exc) { MessageBox.Show(exc.ToString()); } finally { txtAddress.Text = ""; txtCity.Text = ""; txtEmail.Text = ""; txtName.Text = ""; txtState.Text = ""; mtbMobile.Text = ""; mtbContact.Text = ""; con.Close(); } } else if (!strregex.IsMatch(valid)) { MessageBox.Show("Incorrect Email", "", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } Vendor v = new Vendor(); v.Show(); } } }