private void button_Click(object sender, RoutedEventArgs e) { int iid = 0; if ((String.IsNullOrEmpty(name.Text)) || (String.IsNullOrEmpty(address.Text)) || (String.IsNullOrEmpty(mobile.Text)) || (String.IsNullOrEmpty(email.Text))) { MessageBox.Show("Some Fields have been left blank"); } else if ((mobile.Text).ToString().Length != 10) { MessageBox.Show("Mobile Number invalid.It must be of 10 digits"); } else { String ll = ""; if (!String.IsNullOrEmpty(landline.Text)) { ll = landline.Text; } OracleCommand cmdc = new OracleCommand("select * from supplier order by supplier_id", con); OracleDataReader odr = cmdc.ExecuteReader(); while (odr.Read()) { iid = Int32.Parse((odr["supplier_id"].ToString())); } iid = iid + 1; OracleCommand cmd1 = new OracleCommand("insert into supplier values(" + iid.ToString() + ",'" + name.Text + "','" + address.Text + "'," + mobile.Text + "," + ll + ",'" + email.Text + "')", con); OracleDataReader odr2 = cmd1.ExecuteReader(); MessageBox.Show("Supplier Added Succesfully"); SupTable a = new SupTable(); a.Show(); this.Hide(); } }
private void button3_Click(object sender, RoutedEventArgs e) { SupTable et = new SupTable(); et.Show(); this.Hide(); }