/** 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);
    }
  }