private void button4_Click(object sender, EventArgs e) { this.Hide(); Orders display = new Orders(); display.ShowDialog(); }
private void btnback_Click(object sender, EventArgs e) { this.Hide(); Orders display = new Orders(); display.ShowDialog(); this.Close(); }
private void Form1_KeyDown(object sender, KeyEventArgs e) { //back if (e.KeyData == Keys.Escape) { this.Hide(); Orders display = new Orders(); display.ShowDialog(); this.Close(); } ///add product if (e.KeyData == Keys.F1) { bool error1 = true; bool error2 = true; bool error3 = true; bool error4 = true; bool error5 = true; string name = txtprodname.Text; string unit = txtunitmeas.Text; string cost = txtcost.Text; string price = txtitemprice.Text; string discount = txtdis.Text; //Start TXTCustid Constraints foreach (char c in name) { if (Char.IsNumber(c)) { error1 = false; break; } } char ch = ' '; for (int a = 0; a < name.Length; a++) { ch = name[a]; if (ch == ',' || ch == '<' || ch == '.' || ch == '>' || ch == '?' || ch == '/' || ch == ';' || ch == ':' || ch == '"' || ch == '|' || ch == ']' || ch == '}' || ch == '[' || ch == '{' || ch == '+' || ch == '=' || ch == '-' || ch == '_' || ch == ')' || ch == '(' || ch == '*' || ch == '&' || ch == '^' || ch == '%' || ch == '$' || ch == '#' || ch == '@' || ch == '!' || ch == '`' || ch == '~' || ch == '\\' || ch == '\'') { error1 = false; } } if (error1 == false) { MessageBox.Show("1", "Error"); return; } ///end of txtCUSTID Constraints /// ///Start of txtprodcode Constraints foreach (char c in unit) { if (Char.IsNumber(c)) { error2 = false; break; } } for (int a = 0; a < unit.Length; a++) { ch = unit[a]; if (ch == ',' || ch == '<' || ch == '.' || ch == '>' || ch == '?' || ch == '/' || ch == ';' || ch == ':' || ch == '"' || ch == '|' || ch == ']' || ch == '}' || ch == '[' || ch == '{' || ch == '+' || ch == '=' || ch == '-' || ch == '_' || ch == ')' || ch == '(' || ch == '*' || ch == '&' || ch == '^' || ch == '%' || ch == '$' || ch == '#' || ch == '@' || ch == '!' || ch == '`' || ch == '~' || ch == '\\' || ch == '\'') { error2 = false; } } if (error2 == false) { MessageBox.Show("2", "Error"); return; } ///end of txtprodcode Constraints /// ///Start of txtquantity Constraints foreach (char c in cost) { if (!Char.IsNumber(c)) { error3 = false; break; } } if (error3 == false) { MessageBox.Show("3", "Error"); return; } ///end of txtquantity Constraints /// ///Start of txtitemprice Constraints foreach (char c in price) { if (!Char.IsNumber(c)) { error4 = false; break; } } if (error4 == false) { MessageBox.Show("4", "Error"); return; } ///end of txtitemprice Constraints /// ///Start of txtdiscount Constraints foreach (char c in discount) { if (!Char.IsNumber(c)) { error5 = false; break; } } if (error5 == false) { MessageBox.Show("5", "Error"); return; } if (txtprodname.Text == "" || txtunitmeas.Text == "" || txtcost.Text == "" || txtdiscrip.Text == "" || txtitemprice.Text == "") { MessageBox.Show("All fields cannot be empty", "Error"); return; } try { conn.dbcon(); SqlCommand cm = new SqlCommand("INSERT INTO Products (Product_Name,Unit_Measure, Description, Cost, Price, Discount) " + "Values ('" + txtprodname.Text + "','" + txtunitmeas.Text + "','" + txtdiscrip.Text + "','" + txtcost.Text + "','" + txtitemprice.Text + "', '" + txtdis.Text + "' )"); cm.Connection = Connectionclass.con; cm.ExecuteNonQuery(); MessageBox.Show("Saved Successfully", "Saving"); txtprodname.Clear(); txtdiscrip.Clear(); txtunitmeas.Clear(); txtcost.Clear(); txtitemprice.Clear(); txtdis.Clear(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Closecon(); } } }
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(); } }