@Override
public boolean delete(int id) {
try {
Connection connection = PoolConnection.getConnection();
try {
connection.setAutoCommit(false);
chtdao.deleteByCategoryId(connection, id);
udao.deleteByCatID(connection, id);
chpdao.deleteByCategoryId(connection, id);
cdao.delete(connection, id);
connection.commit();
} catch (SQLTransactionException e) {
connection.rollback();
return false;
} finally {
if (connection != null) {
connection.setAutoCommit(true);
connection.close();
}
}
} catch (SQLException e) {
e.printStackTrace();
}
return true;
}
@Override
public boolean update(int id, Category category) {
try {
Connection connection = PoolConnection.getConnection();
try {
connection.setAutoCommit(false);
// assertTransaction(cdao.update(connection, id, category));
// assertTransaction(chtdao.deleteByCategoryId(connection, id));
// for (Task task : category.getTasks()) {
// assertTransaction(chtdao.insert(connection, id, task.getId()));
// }
cdao.update(connection, id, category);
chtdao.deleteByCategoryId(connection, id);
for (Task task : category.getTasks()) {
chtdao.insert(connection, id, task.getId());
}
connection.commit();
} catch (SQLTransactionException e) {
connection.rollback();
return false;
} finally {
if (connection != null) {
connection.setAutoCommit(true);
connection.close();
}
}
} catch (SQLException e) {
e.printStackTrace();
}
return true;
}
public List<Category> getByPostId(int postId) {
try (Connection connection = PoolConnection.getConnection()) {
return cdao.getByPostId(connection, postId);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
public int getCountAllWithSearch(String categoryToSearch) {
try (Connection connection = PoolConnection.getConnection()) {
return cdao.getCountWithSearch(connection, categoryToSearch);
} catch (SQLException e) {
e.printStackTrace();
}
return 0;
}
public int getCountAll() {
try (Connection connection = PoolConnection.getConnection()) {
return cdao.getCount(connection);
} catch (SQLException e) {
e.printStackTrace();
}
return 0;
}
public List<Category> getAllWithSearchLimited(String nameToSearch, int start, int ammount) {
try (Connection connection = PoolConnection.getConnection()) {
return cdao.getAllWithSearchLimited(connection, nameToSearch, start, ammount);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
@Override
public Category getById(int id) {
try (Connection connection = PoolConnection.getConnection()) {
return cdao.getById(connection, id);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
@Override
public List<Category> getAll() {
try (Connection connection = PoolConnection.getConnection()) {
return cdao.getAll(connection);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}