private void Form1_KeyDown(object sender, KeyEventArgs e) { //add orders if (e.KeyData == Keys.F1) { bool error = true; bool error1 = true; bool error2 = true; string id = combosupid.Text; string pcode = txtprodid.Text; string qty = txtqty.Text; //Start TXTCustid Constraints foreach (char c in id) { if (!Char.IsNumber(c)) { error = false; break; } } if (error == false) { MessageBox.Show("The Supplier ID you entered does not exist in the RECORD", "Error"); return; } ///end of txtCUSTID Constraints /// ///Start of txtprodcode Constraints foreach (char c in pcode) { if (!Char.IsNumber(c)) { error1 = false; break; } } if (error1 == false) { MessageBox.Show("The Product Code you entered does not exist in the RECORD", "Error"); return; } ///end of txtprodcode Constraints /// ///Start of txtquantity Constraints foreach (char c in qty) { if (!Char.IsNumber(c)) { error2 = false; break; } } if (error2 == false) { MessageBox.Show("Invalid Input Please Checked Quantity Field for INCORRECT input", "Error"); return; } ///end of txtquantity Constraints if (combosupid.Text == "" || txtprodid.Text == "" || txtqty.Text == "" || txtTotal.Text == "") { MessageBox.Show("All fields cannot be empty", "Error"); return; } try { conn.dbcon(); SqlCommand cm = new SqlCommand("INSERT INTO Orders (Order_Date, Supplier_ID) " + "Values ('" + txtordersdate.Text + "', '" + combosupid.Text + "' )"); cm.Connection = Connectionclass.con; cm.ExecuteNonQuery(); cmd = new SqlCommand("INSERT INTO OrderDetails (Product_ID, Cost, Quantity) " + "Values ('" + txtprodid.Text + "', '" + txtcost.Text + "' , '" + txtqty.Text + "')"); cmd.Connection = Connectionclass.con; cmd.ExecuteNonQuery(); MessageBox.Show("Saved Successfully", "Saving"); ///clear txtqty.Clear(); txtprodid.SelectedIndex = -1; combosupid.SelectedIndex = -1; txtsupname.Clear(); txtprodname.Clear(); txtunitmeas.Clear(); txtcost.Clear(); txtTotal.Text = "0.00"; } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error"); } finally { conn.Closecon(); } } if (e.KeyData == Keys.Escape) { this.Hide(); Orders display = new Orders(); display.ShowDialog(); } }