private void ComputeAdd_Click(object sender, EventArgs e) { this.Hide(); addporder disply = new addporder(); disply.ShowDialog(); /*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.Text = ""; * txtprodid.SelectedIndex = -1; * combosupid.SelectedIndex = -1; * txtsupname.Clear(); * txtprodname.Clear(); * txtunitmeas.Clear(); * txtTotal.Text = "0.00"; * * } * catch (Exception ex) * { * MessageBox.Show(ex.ToString(), "Error"); * } * finally * { * conn.Closecon(); * txtcost.Clear(); * } * //refresh * * try * { * * conn.dbcon(); * cmd = new SqlCommand("Select * from OrderDetails"); * cmd.Connection = Connectionclass.con; * sda = new SqlDataAdapter(cmd); * cmb = new SqlCommandBuilder(sda); * ds = new DataSet(); * sda.Fill(ds, "OrderDt"); * dt = ds.Tables["OrderDt"]; * data.DataSource = ds.Tables["OrderDt"]; * data.ReadOnly = false; * data.SelectionMode = DataGridViewSelectionMode.FullRowSelect; * txtTotal.ReadOnly = true; * txtordersdate.ReadOnly = true; * * } * 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) { this.Hide(); addporder disply = new addporder(); disply.ShowDialog(); /* 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.Text = ""; * txtprodid.SelectedIndex = -1; * combosupid.SelectedIndex = -1; * txtsupname.Clear(); * txtprodname.Clear(); * txtunitmeas.Clear(); * txtTotal.Text = "0.00"; * * ///refresh * cmd = new SqlCommand("Select * from OrderDetails"); * cmd.Connection = Connectionclass.con; * sda = new SqlDataAdapter(cmd); * cmb = new SqlCommandBuilder(sda); * ds = new DataSet(); * sda.Fill(ds, "OrderDt"); * dt = ds.Tables["OrderDt"]; * * data.DataSource = ds.Tables["OrderDt"]; * data.ReadOnly = false; * data.SelectionMode = DataGridViewSelectionMode.FullRowSelect; * txtTotal.ReadOnly = true; * txtordersdate.ReadOnly = true; * * * } * catch (Exception ex) * { * MessageBox.Show(ex.ToString(), "Error"); * } * finally * { * conn.Closecon(); * txtcost.Clear(); * }*/ } ///update if (e.KeyData == Keys.Enter || e.KeyData == Keys.F2) { ////UPDATE 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 (txtprodid.Text == "" || txtqty.Text == "" || txtTotal.Text == "") { MessageBox.Show("No such Record To Update", "Error"); return; } try { conn.dbcon(); cmb = new SqlCommandBuilder(sda); sda.Update(ds, "OrderDt"); cmd = new SqlCommand("Update OrderDetails set Product_ID = '" + txtprodid.Text + "' , Cost = '" + txtcost.Text + "', Quantity = '" + txtqty.Text + "' where Order_No = '" + txtorderno.Text + "'"); cmd.Connection = Connectionclass.con; cmd.ExecuteNonQuery(); cmd = new SqlCommand("Update Orders set Supplier_ID = '" + combosupid.Text + "' where Order_No = '" + txtorderno.Text + "'"); cmd.Connection = Connectionclass.con; cmd.ExecuteNonQuery(); MessageBox.Show("Successfully Updated", "Update"); ///clear combosupid.SelectedIndex = -1; txtprodid.SelectedIndex = -1; txtprodname.Clear(); txtsupname.Clear(); txtunitmeas.Clear(); txtcost.Clear(); txtqty.Clear(); txtTotal.Text = "0.00"; combosupid.Enabled = false; txtprodid.Enabled = false; txtqty.ReadOnly = true; //refresh cmd = new SqlCommand("select OD.Order_No, O.Supplier_ID, OD.Product_ID, OD.Cost, OD.Quantity from Orders O inner join OrderDetails OD on O.Order_No = OD.Order_No order by OD.Order_No DESC"); cmd.Connection = Connectionclass.con; sda = new SqlDataAdapter(cmd); cmb = new SqlCommandBuilder(sda); ds = new DataSet(); sda.Fill(ds, "OrderDt"); dt = ds.Tables["OrderDt"]; data.DataSource = ds.Tables["OrderDt"]; data.ReadOnly = false; data.SelectionMode = DataGridViewSelectionMode.FullRowSelect; txtTotal.ReadOnly = true; txtordersdate.ReadOnly = true; ComputeAdd.Enabled = true; } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error"); } finally { conn.Closecon(); } } //back if (e.KeyData == Keys.Escape) { this.Hide(); Main display = new Main(); display.ShowDialog(); this.Close(); } //add product or items if (e.KeyData == Keys.F3) { this.Hide(); Item display = new Item(); display.ShowDialog(); } }