/** Populates a DTO with data from a ResultSet */
  protected void populateDto(Projects dto, ResultSet rs) throws SQLException {
    dto.setIdprojects(rs.getInt(COLUMN_IDPROJECTS));
    dto.setName(rs.getString(COLUMN_NAME));
    dto.setDescription(rs.getString(COLUMN_DESCRIPTION));
    dto.setStartDate(rs.getDate(COLUMN_START_DATE));
    dto.setEndDate(rs.getDate(COLUMN_END_DATE));
    dto.setStatus(rs.getInt(COLUMN_STATUS));
    if (rs.wasNull()) {
      dto.setStatusNull(true);
    }

    dto.setType(rs.getInt(COLUMN_TYPE));
    if (rs.wasNull()) {
      dto.setTypeNull(true);
    }

    dto.setCompanyId(rs.getInt(COLUMN_COMPANY_ID));
    if (rs.wasNull()) {
      dto.setCompanyIdNull(true);
    }

    dto.setBranchId(rs.getInt(COLUMN_BRANCH_ID));
    if (rs.wasNull()) {
      dto.setBranchIdNull(true);
    }
  }
  /** Inserts a new row in the projects table. */
  public ProjectsPk insert(Projects dto) throws ProjectsDaoException {
    long t1 = System.currentTimeMillis();
    // declare variables
    final boolean isConnSupplied = (userConn != null);
    Connection conn = null;
    PreparedStatement stmt = null;
    ResultSet rs = null;

    try {
      // get the user-specified connection or get a connection from the ResourceManager
      conn = isConnSupplied ? userConn : ResourceManager.getConnection();

      stmt = conn.prepareStatement(SQL_INSERT, Statement.RETURN_GENERATED_KEYS);
      int index = 1;
      stmt.setInt(index++, dto.getIdprojects());
      stmt.setString(index++, dto.getName());
      stmt.setString(index++, dto.getDescription());
      stmt.setDate(
          index++,
          dto.getStartDate() == null ? null : new java.sql.Date(dto.getStartDate().getTime()));
      stmt.setDate(
          index++, dto.getEndDate() == null ? null : new java.sql.Date(dto.getEndDate().getTime()));
      if (dto.isStatusNull()) {
        stmt.setNull(index++, java.sql.Types.INTEGER);
      } else {
        stmt.setInt(index++, dto.getStatus());
      }

      if (dto.isTypeNull()) {
        stmt.setNull(index++, java.sql.Types.INTEGER);
      } else {
        stmt.setInt(index++, dto.getType());
      }

      if (dto.isCompanyIdNull()) {
        stmt.setNull(index++, java.sql.Types.INTEGER);
      } else {
        stmt.setInt(index++, dto.getCompanyId());
      }

      if (dto.isBranchIdNull()) {
        stmt.setNull(index++, java.sql.Types.INTEGER);
      } else {
        stmt.setInt(index++, dto.getBranchId());
      }

      System.out.println("Executing " + SQL_INSERT + " with DTO: " + dto);
      int rows = stmt.executeUpdate();
      long t2 = System.currentTimeMillis();
      System.out.println(rows + " rows affected (" + (t2 - t1) + " ms)");

      // retrieve values from auto-increment columns
      rs = stmt.getGeneratedKeys();
      if (rs != null && rs.next()) {
        dto.setIdprojects(rs.getInt(1));
      }

      reset(dto);
      return dto.createPk();
    } catch (Exception _e) {
      _e.printStackTrace();
      throw new ProjectsDaoException("Exception: " + _e.getMessage(), _e);
    } finally {
      ResourceManager.close(stmt);
      if (!isConnSupplied) {
        ResourceManager.close(conn);
      }
    }
  }
  /** Updates a single row in the projects table. */
  public void update(ProjectsPk pk, Projects dto) throws ProjectsDaoException {
    long t1 = System.currentTimeMillis();
    // declare variables
    final boolean isConnSupplied = (userConn != null);
    Connection conn = null;
    PreparedStatement stmt = null;

    try {
      // get the user-specified connection or get a connection from the ResourceManager
      conn = isConnSupplied ? userConn : ResourceManager.getConnection();

      System.out.println("Executing " + SQL_UPDATE + " with DTO: " + dto);
      stmt = conn.prepareStatement(SQL_UPDATE);
      int index = 1;
      stmt.setInt(index++, dto.getIdprojects());
      stmt.setString(index++, dto.getName());
      stmt.setString(index++, dto.getDescription());
      stmt.setDate(
          index++,
          dto.getStartDate() == null ? null : new java.sql.Date(dto.getStartDate().getTime()));
      stmt.setDate(
          index++, dto.getEndDate() == null ? null : new java.sql.Date(dto.getEndDate().getTime()));
      if (dto.isStatusNull()) {
        stmt.setNull(index++, java.sql.Types.INTEGER);
      } else {
        stmt.setInt(index++, dto.getStatus());
      }

      if (dto.isTypeNull()) {
        stmt.setNull(index++, java.sql.Types.INTEGER);
      } else {
        stmt.setInt(index++, dto.getType());
      }

      if (dto.isCompanyIdNull()) {
        stmt.setNull(index++, java.sql.Types.INTEGER);
      } else {
        stmt.setInt(index++, dto.getCompanyId());
      }

      if (dto.isBranchIdNull()) {
        stmt.setNull(index++, java.sql.Types.INTEGER);
      } else {
        stmt.setInt(index++, dto.getBranchId());
      }

      stmt.setInt(10, pk.getIdprojects());
      int rows = stmt.executeUpdate();
      reset(dto);
      long t2 = System.currentTimeMillis();
      System.out.println(rows + " rows affected (" + (t2 - t1) + " ms)");
    } catch (Exception _e) {
      _e.printStackTrace();
      throw new ProjectsDaoException("Exception: " + _e.getMessage(), _e);
    } finally {
      ResourceManager.close(stmt);
      if (!isConnSupplied) {
        ResourceManager.close(conn);
      }
    }
  }