Esempio n. 1
0
        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();
             * }*/
        }
Esempio n. 2
0
        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();
            }
        }