コード例 #1
0
  public void populateBillCategoryValues() {
    try {

      Connection con = Main.dbConnection;
      if (!con.isValid(0)) {
        con = Main.reconnect();
      }
      billCategoryValues = FXCollections.observableArrayList();
      PreparedStatement stmt =
          con.prepareStatement(
              "select distinct bill_category from point_name order by bill_category");
      ResultSet rs = stmt.executeQuery();
      while (rs.next()) {
        if (billCategoryValues != null && !billCategoryValues.contains(rs.getString(1)))
          billCategoryValues.add(rs.getString(1).toLowerCase());
      }
      billCategoryTF.setItems(billCategoryValues);
      new AutoCompleteComboBoxListener<>(billCategoryTF);
    } catch (SQLException e) {

      Main._logger.debug("Error :", e);
      e.printStackTrace();
    } catch (Exception e) {

      Main._logger.debug("Error :", e);
      e.printStackTrace();
    }
  }
コード例 #2
0
  private boolean productExistsInCategory(String name, String category) {
    try {

      Connection con = Main.dbConnection;
      if (!con.isValid(0)) {
        con = Main.reconnect();
      }
      String query =
          "select count(*) from products where lower(name)=? and lower(bill_category)=? and product_id<>?";
      PreparedStatement stmt = con.prepareStatement(query);
      stmt.setString(1, name.toLowerCase());
      stmt.setString(2, category.toLowerCase());
      stmt.setLong(3, productRow.getProductId());
      ResultSet rs = stmt.executeQuery();
      if (rs.next()) {
        if (rs.getInt(1) > 0) return true;
      }
    } catch (SQLException e) {

      Main._logger.debug("Error :", e);
      e.printStackTrace();
    } catch (Exception e) {

      Main._logger.debug("Error :", e);
      e.printStackTrace();
    }
    return false;
  }
コード例 #3
0
  public void populateProdTypeValues() {
    try {

      Connection con = Main.dbConnection;
      if (!con.isValid(0)) {
        con = Main.reconnect();
      }
      productTypeValues.clear();
      PreparedStatement stmt =
          con.prepareStatement(
              "select value, code, seq, lov_lookup_id from lov_lookup where code='PRODUCT_TYPE' order by seq");
      ResultSet rs = stmt.executeQuery();
      while (rs.next()) {
        productTypeValues.add(rs.getString(1));
      }
      typeTF.getItems().addAll(productTypeValues);
    } catch (SQLException e) {

      Main._logger.debug("Error :", e);
      e.printStackTrace();
    } catch (Exception e) {

      Main._logger.debug("Error :", e);
      e.printStackTrace();
    }
  }
コード例 #4
0
  @FXML
  void updateAdminDetails(ActionEvent event) {
    try {
      TextField mobileNum = new TextField();
      TextField agencyName = new TextField();
      TextField addr = new TextField();

      Connection con = Main.dbConnection;
      if (!con.isValid(0)) {
        con = Main.reconnect();
      }
      String query =
          "select company_name,company_mobile,company_addr from admin_login where username ='******' ";
      PreparedStatement stmt = con.prepareStatement(query);
      //			stmt.setString(1, HawkerLoginController.loggedInHawker.getPointName());
      ResultSet rs = stmt.executeQuery();
      if (rs.next()) {
        agencyName.setText(rs.getString(1));
        mobileNum.setText(rs.getString(2));
        addr.setText(rs.getString(3));
      }
      rs.close();
      stmt.close();

      Dialog<ButtonType> deleteWarning = new Dialog<ButtonType>();
      deleteWarning.setTitle("Update Admin Details");
      deleteWarning.setHeaderText("Update admin details below.");
      ButtonType saveButtonType = new ButtonType("Save", ButtonData.OK_DONE);
      deleteWarning.getDialogPane().getButtonTypes().addAll(saveButtonType, ButtonType.CANCEL);

      GridPane grid = new GridPane();
      grid.setHgap(10);
      grid.setVgap(10);
      grid.setPadding(new Insets(20, 150, 10, 10));

      grid.add(new Label("Agency Name"), 0, 0);
      grid.add(new Label("Mobile"), 0, 1);
      grid.add(new Label("Address"), 0, 2);
      grid.add(agencyName, 1, 1);
      grid.add(mobileNum, 1, 0);
      grid.add(addr, 1, 2);
      deleteWarning.getDialogPane().setContent(grid);
      Optional<ButtonType> result = deleteWarning.showAndWait();
      if (result.isPresent() && result.get() == saveButtonType) {
        PreparedStatement updateStmt =
            con.prepareStatement(
                "update admin_login set company_name=?, company_mobile=?, company_addr=?");
        updateStmt.setString(1, agencyName.getText());
        updateStmt.setString(2, mobileNum.getText());
        updateStmt.setString(3, addr.getText());
        updateStmt.executeUpdate();
      }
    } catch (SQLException e) {

      Main._logger.debug("Error :", e);
      e.printStackTrace();
    } catch (Exception e) {

      Main._logger.debug("Error :", e);
      e.printStackTrace();
    }
  }
コード例 #5
0
  @FXML
  private void changePasswordClicked(ActionEvent evt) {
    TextInputDialog changePwdDialog = new TextInputDialog();
    changePwdDialog.setTitle("Change password");
    changePwdDialog.setHeaderText(
        "Please enter the new password. \nPassword must be atleast 5 characters long.");
    // changePwdDialog.getDialogPane().getButtonTypes().addAll(ButtonType.OK,
    // ButtonType.CANCEL);
    final Button btOk = (Button) changePwdDialog.getDialogPane().lookupButton(ButtonType.OK);
    btOk.addEventFilter(
        ActionEvent.ACTION,
        event -> {
          if (changePwdDialog.getEditor().getText().isEmpty()
              || changePwdDialog.getEditor().getText().length() < 5) {
            Notifications.create()
                .title("Empty password")
                .text(
                    "Password cannot be left empty and must be more than 5 characters. Try again.")
                .hideAfter(Duration.seconds(5))
                .showError();
            event.consume();
          }
        });
    Optional<String> result = changePwdDialog.showAndWait();
    if (result.isPresent()) {
      try {

        Connection con = Main.dbConnection;
        if (!con.isValid(0)) {
          con = Main.reconnect();
        }
        String deleteString = "update admin_login set password =? where username='******'";
        PreparedStatement deleteStmt = con.prepareStatement(deleteString);
        deleteStmt.setString(1, changePwdDialog.getEditor().getText());

        deleteStmt.executeUpdate();
        con.commit();

        Notifications.create()
            .title("Password updated")
            .text("Password was successfully updated. Please login again!")
            .hideAfter(Duration.seconds(5))
            .showInformation();
        logoutClicked(new ActionEvent());
      } catch (SQLException e) {

        Main._logger.debug("Error :", e);
        e.printStackTrace();
        Notifications.create()
            .hideAfter(Duration.seconds(5))
            .title("Delete failed")
            .text("Delete request of hawker bill has failed")
            .showError();
      } catch (IOException e) {

        Main._logger.debug("Error :", e);
        e.printStackTrace();
      } catch (Exception e) {

        Main._logger.debug("Error :", e);
        e.printStackTrace();
      }
    }
  }