public static void do_edit(String name, String num, String img_path) {
    try {
      Connection conn = MyConnection1.connect();
      String s0 =
          "update "
              + MyDB.getNames()
              + ".category set cat_name='"
              + name
              + "',img_path='"
              + img_path
              + "' where cat_num='"
              + num
              + "'";
      PreparedStatement stmt = conn.prepareStatement(s0);
      stmt.execute();

      String s1 =
          "update "
              + MyDB.getNames()
              + ".category_type set cat_name='"
              + name
              + "' where cat_num='"
              + num
              + "'";
      PreparedStatement stmt1 = conn.prepareStatement(s1);
      stmt1.execute();
      Prompt.call("Updated Successfully");
      //            JOptionPane.showMessageDialog(null, "Updated Successfully");
    } catch (Exception e) {
      throw new RuntimeException(e);
    } finally {
      MyConnection1.close();
    }
  }
  public static void do_delete_category_type(String num) {
    try {
      Connection conn = MyConnection1.connect();
      String s0 = "delete from " + MyDB.getNames() + ".category_type where type_num='" + num + "'";
      PreparedStatement stmt = conn.prepareStatement(s0);
      stmt.execute();

      String s1 =
          "delete from "
              + MyDB.getNames()
              + ".inventory2_stocks_left where types_num='"
              + num
              + "'";
      PreparedStatement stmt1 = conn.prepareStatement(s1);
      stmt1.execute();

      String s2 = "delete from " + MyDB.getNames() + ".inventory2 where types_num='" + num + "'";
      PreparedStatement stmt2 = conn.prepareStatement(s2);
      stmt2.execute();

      Prompt.call("Updated Successfully");

      //            JOptionPane.showMessageDialog(null, "Updated Successfully");

    } catch (Exception e) {
      throw new RuntimeException(e);
    } finally {
      MyConnection1.close();
    }
  }
  private void pay3(List<to_cust_charges> cus) {

    for (to_cust_charges t : cus) {

      S2_customers.pay3(t.ci_number, t.or);
      data_charges();
    }
    data_charges();
    Prompt.call("PAYED");
  }
Exemplo n.º 4
0
  public static void do_add(String num) {
    if (if_exists(num) == true) {
      Prompt.call("Already Added");
      //            JOptionPane.showMessageDialog(null, "Already Added");
      return;
    }
    try {
      Connection conn = MyConnection.connect();

      String s0 = "insert into " + MyDB.getNames() + ".favorites(prod_code)values(?)";
      PreparedStatement stmt = conn.prepareStatement(s0);

      stmt.setString(1, num);
      stmt.execute();
      Prompt.call("ADDED TO FAVORITES");
      //            JOptionPane.showMessageDialog(null, "ADDED TO FAVORITES");
    } catch (Exception e) {
      throw new RuntimeException(e);
    } finally {
      MyConnection.close();
    }
  }
  private void do_save() {

    String name = tf_prod.getText();
    double qty = S15_update_product.get_qty(n, "");

    if (qty == 0) {
      S15_update_product.update_product(n, name);
      do_ok();

    } else {
      Prompt.call("Cannot Update, Still has available stocks");
      //            JOptionPane.showMessageDialog(null, "Cannot Update, Still has available
      // stocks");
    }
  }
Exemplo n.º 6
0
  public static void do_delete(String num) {
    //        JOptionPane.showMessageDialog(null, "adadad");

    try {
      Connection conn = MyConnection.connect();

      String s0 = "delete from " + MyDB.getNames() + ".favorites where prod_code='" + num + "'";
      PreparedStatement stmt = conn.prepareStatement(s0);

      //            stmt.setString(1, num);
      stmt.execute();

      Prompt.call("DELETED");
      //            JOptionPane.showMessageDialog(null, "DELETED");

    } catch (Exception e) {
      throw new RuntimeException(e);
    } finally {
      MyConnection.close();
    }
  }
Exemplo n.º 7
0
  public static void do_cancel(
      double qty,
      String cashier_id,
      String product_id,
      double new_qty,
      String id,
      double price,
      String name) {

    double qty_left = S4_endorsements.get_left(product_id, cashier_id);

    String date = DateType.datetime.format(new Date());

    try {
      Connection conn = MyConnection.connect();
      if (qty == new_qty) {

        String s0 = "delete from " + MyDB.getNames() + ".sales where id='" + id + "'";
        PreparedStatement stmt = conn.prepareStatement(s0);
        stmt.execute();

        qty_left += new_qty;
        String s1 =
            "update "
                + MyDB.getNames()
                + ".endorsements set qty_left='"
                + qty_left
                + "' where cashier_id='"
                + cashier_id
                + "' and product_id='"
                + product_id
                + "'";
        PreparedStatement stmt2 = conn.prepareStatement(s1);
        stmt2.execute();

        String s2 =
            "insert into "
                + MyDB.getNames()
                + ".cancelled_sales(product_id,product_name,price,qty,date_added)values(?,?,?,?,?)";
        PreparedStatement stmt3 = conn.prepareStatement(s2);
        stmt3.setString(1, product_id);
        stmt3.setString(2, name);
        stmt3.setDouble(3, price);
        stmt3.setDouble(4, new_qty);
        stmt3.setString(5, date);
        stmt3.execute();

      } else {
        double aw = qty - new_qty;
        double commission = 0;
        double rate = S4_endorsements.get_commission_rate(product_id);
        rate = (rate / 100);

        commission = (new_qty * price) * rate;

        String s0 =
            "update "
                + MyDB.getNames()
                + ".sales set qty_sold='"
                + new_qty
                + "',commission='"
                + commission
                + "' where id='"
                + id
                + "'";
        PreparedStatement stmt = conn.prepareStatement(s0);
        stmt.execute();

        qty_left += new_qty;
        String s1 =
            "update "
                + MyDB.getNames()
                + ".endorsements set qty_left='"
                + qty_left
                + "' where cashier_id='"
                + cashier_id
                + "' and product_id='"
                + product_id
                + "'";
        PreparedStatement stmt2 = conn.prepareStatement(s1);
        stmt2.execute();

        String s2 =
            "insert into "
                + MyDB.getNames()
                + ".cancelled_sales(product_id,product_name,price,qty,date_added)values(?,?,?,?,?)";
        PreparedStatement stmt3 = conn.prepareStatement(s2);
        stmt3.setString(1, product_id);
        stmt3.setString(2, name);
        stmt3.setDouble(3, price);
        stmt3.setDouble(4, qty - new_qty);
        stmt3.setString(5, date);
        stmt3.execute();
      }

      Prompt.call("Successfully Updated");
      //            JOptionPane.showMessageDialog(null, "Successfully Updated");
    } catch (Exception e) {
      throw new RuntimeException(e);
    } finally {
      MyConnection.close();
    }
  }