Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

com.silverpeas.projectManager.model
Class ProjectManagerDAO

java.lang.Object
  extended by com.silverpeas.projectManager.model.ProjectManagerDAO

public class ProjectManagerDAO
extends Object

Author:
neysseri

Constructor Summary
ProjectManagerDAO()
           
 
Method Summary
static void actionEstDecomposee(Connection con, int id, int estDecomposee)
           
static int addResource(Connection con, TaskResourceDetail resource)
           
static int addTask(Connection con, TaskDetail task)
           
static Date dbDate2Date(String dbDate, String fieldName)
           
static void deleteAllResources(Connection con, int taskId, String instanceId)
           
static List<TaskDetail> getAllTasks(Connection con, String instanceId, Filtre filtre)
           
static TaskDetail getMostDistantTask(Connection con, String instanceId, int taskId)
           
static List<TaskDetail> getNextTasks(Connection con, int taskId)
           
static int getOccupationByUser(Connection con, String userId, Date dateDeb, Date dateFin)
           
static int getOccupationByUser(Connection con, String userId, Date dateDeb, Date dateFin, int excludedTaskId)
           
static List<TaskResourceDetail> getResources(Connection con, int taskId, String instanceId)
           
static TaskDetail getTask(Connection con, int id)
           
static TaskDetail getTask(Connection con, String id)
           
static List<TaskDetail> getTasks(Connection con, int actionId, Filtre filtre, String instanceId)
           
static List<TaskDetail> getTasksByMotherId(Connection con, String instanceId, int motherId, Filtre filtre)
           
static List<TaskDetail> getTasksByMotherIdAndPreviousId(Connection con, String instanceId, int motherId, int previousId)
           
static List<TaskDetail> getTasksNotCancelledByMotherId(Connection con, String instanceId, int motherId, Filtre filtre)
           
static List<TaskDetail> getTree(Connection con, int actionId)
           
static void removeTask(Connection con, int id)
           
static void updateTask(Connection con, TaskDetail task)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

ProjectManagerDAO

public ProjectManagerDAO()
Method Detail

addTask

public static int addTask(Connection con,
                          TaskDetail task)
                   throws SQLException,
                          com.stratelia.webactiv.util.exception.UtilException
Throws:
SQLException
com.stratelia.webactiv.util.exception.UtilException

addResource

public static int addResource(Connection con,
                              TaskResourceDetail resource)
                       throws SQLException,
                              com.stratelia.webactiv.util.exception.UtilException
Throws:
SQLException
com.stratelia.webactiv.util.exception.UtilException

updateTask

public static void updateTask(Connection con,
                              TaskDetail task)
                       throws SQLException,
                              com.stratelia.webactiv.util.exception.UtilException
Throws:
SQLException
com.stratelia.webactiv.util.exception.UtilException

deleteAllResources

public static void deleteAllResources(Connection con,
                                      int taskId,
                                      String instanceId)
                               throws SQLException
Throws:
SQLException

actionEstDecomposee

public static void actionEstDecomposee(Connection con,
                                       int id,
                                       int estDecomposee)
                                throws SQLException
Throws:
SQLException

removeTask

public static void removeTask(Connection con,
                              int id)
                       throws SQLException
Throws:
SQLException

getTask

public static TaskDetail getTask(Connection con,
                                 String id)
                          throws SQLException
Throws:
SQLException

getTask

public static TaskDetail getTask(Connection con,
                                 int id)
                          throws SQLException
Throws:
SQLException

getResources

public static List<TaskResourceDetail> getResources(Connection con,
                                                    int taskId,
                                                    String instanceId)
                                             throws SQLException
Throws:
SQLException

getAllTasks

public static List<TaskDetail> getAllTasks(Connection con,
                                           String instanceId,
                                           Filtre filtre)
                                    throws SQLException
Throws:
SQLException

getTasks

public static List<TaskDetail> getTasks(Connection con,
                                        int actionId,
                                        Filtre filtre,
                                        String instanceId)
                                 throws SQLException
Throws:
SQLException

getNextTasks

public static List<TaskDetail> getNextTasks(Connection con,
                                            int taskId)
                                     throws SQLException
Throws:
SQLException

getMostDistantTask

public static TaskDetail getMostDistantTask(Connection con,
                                            String instanceId,
                                            int taskId)
                                     throws SQLException
Throws:
SQLException

getTree

public static List<TaskDetail> getTree(Connection con,
                                       int actionId)
                                throws SQLException
Parameters:
con - a Connection to database
actionId - the root of the tree
Returns:
the tree - a List of TaskDetail
Throws:
SQLException

getTasksByMotherId

public static List<TaskDetail> getTasksByMotherId(Connection con,
                                                  String instanceId,
                                                  int motherId,
                                                  Filtre filtre)
                                           throws SQLException
Throws:
SQLException

getTasksNotCancelledByMotherId

public static List<TaskDetail> getTasksNotCancelledByMotherId(Connection con,
                                                              String instanceId,
                                                              int motherId,
                                                              Filtre filtre)
                                                       throws SQLException
Throws:
SQLException

getTasksByMotherIdAndPreviousId

public static List<TaskDetail> getTasksByMotherIdAndPreviousId(Connection con,
                                                               String instanceId,
                                                               int motherId,
                                                               int previousId)
                                                        throws SQLException
Throws:
SQLException

getOccupationByUser

public static int getOccupationByUser(Connection con,
                                      String userId,
                                      Date dateDeb,
                                      Date dateFin)
                               throws SQLException
Throws:
SQLException

getOccupationByUser

public static int getOccupationByUser(Connection con,
                                      String userId,
                                      Date dateDeb,
                                      Date dateFin,
                                      int excludedTaskId)
                               throws SQLException
Throws:
SQLException

dbDate2Date

public static Date dbDate2Date(String dbDate,
                               String fieldName)
                        throws SQLException
Throws:
SQLException
Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD
Copyright © 2016 Silverpeas. All Rights Reserved.