public static List<EventAssignment> getAllAssignments(){
        try{
            Connection con = DB.getConnection();
            PreparedStatement ps = con.prepareStatement(GETALLASSIGN);
            ResultSet res = ps.executeQuery();
            List<EventAssignment> results = new ArrayList<EventAssignment>();
            while(res.next()){
                EventAssignment assign = extractAssignment(res);
                results.add(assign);
            }
            return results;
        }catch(Exception e){}
        return null;
    }