private void LoadAllLists() {
            ResultSet tasksOnAssetListResultSet = null;   
            Statement statement;
            try {
            statement = connection.createStatement();
       
            tasksOnAssetListResultSet = statement.executeQuery("SELECT * FROM Task WHERE projectID = " + projectID + ";");  
                        
                  
            randSQL.loadAllUsers();
            SetOfUsers allusers = randSQL.getAllUsers();

            while (tasksOnAssetListResultSet.next()){
               int taskID;
               int projectID;                        
               User responsibleUser = null ;
               int taskPriority;
               String status;
               String taskName;
               String taskType;

                taskID = tasksOnAssetListResultSet.getInt("taskID");
                projectID = tasksOnAssetListResultSet.getInt("projectID");
                int userResponsible = tasksOnAssetListResultSet.getInt("responsiblePerson");

               for(int i=0; i<allusers.size();i++)
               {                                
                   int userID = allusers.get(i).getUserID();
                   if(userResponsible == userID)
                   {
                       responsibleUser = allusers.get(i);
                       break;
                   }     
                }

                 taskPriority = tasksOnAssetListResultSet.getInt("taskPriority");
                 status = tasksOnAssetListResultSet.getString("status");
                 taskName = tasksOnAssetListResultSet.getString("taskName");
                 taskType = tasksOnAssetListResultSet.getString("type");

                 Task newTask = new Task(taskID, responsibleUser,taskName, taskPriority , status,projectID, null, taskType);

                 if (responsibleUser == null )
                 {
                     //add to waiting
                     waitingTasks.add(newTask);
                 }
                 else if (newTask.getStatus().equals("Not Started") && newTask.getResponsiblePerson() != null)
                 {
                     //Allocated
                     allocatedTasks.add(newTask);
                 }
                 else if (newTask.getStatus().equals("In Progress"))
                 {
                     //add to inprogress
                     tasksInProgress.add(newTask);
                 }
                 else if (newTask.getStatus().equals("Completed"))
                 {
                     //add to completed
                     completedTasks.add(newTask);
                 }                             
                  allocatedTaskList.setListData(allocatedTasks);; 
                  completedTaskList.setListData(completedTasks);;
                  tIPList.setListData(tasksInProgress);;
                  waitTaskList.setListData(waitingTasks);;
                  OverviewTaskCellRenderer renderer = new OverviewTaskCellRenderer();  //custom cell renderer to display property rather than useless object.toString()
                  allocatedTaskList.setCellRenderer(renderer);
                  completedTaskList.setCellRenderer(renderer);
                  tIPList.setCellRenderer(renderer);
                  waitTaskList.setCellRenderer(renderer);     
            }
            } catch (SQLException ex) {
Logger.getLogger(ManagerUI.class.getName()).log(Level.SEVERE, null, ex);
        }    
    }