@Override
public iTask[] getTasksByUser(UserInfo ui) throws RemoteException, nqException {
PreparedStatement stat;
try {
stat =
this.con.prepareStatement(
"SELECT `idTask`, `idProject`, `idUserCreatedBy`, `idUserAssignedTo`, `idParentTask`, `TaskStatus`, `Title`,"
+ " `Description`, `Priority`, `CreationDate`, `DeadlineDate`, `MaxHours`, `isSubTask`, `Rating` "
+ "FROM Tasks WHERE isSubTask = 0 AND idUserAssignedTo = ?");
stat.setInt(1, ui.getID());
return TaskManager.getTasks(stat, this.con);
} catch (SQLException ex) {
throw new nqException(nqExceptionType.ServerError, "Server error : ".concat(ex.getMessage()));
}
}
