edu.jhu.cs.oose.group4.DAO.interfaces

Interface TaskDAO

All Known Implementing Classes:

TaskDAOImpl

public interface TaskDAO

Task DAO interface.

Author:

Group4

Method Summary

Modifier and Type	Method and Description
void	acceptTask(java.sql.Connection connection, int taskId) Change a task from free to unavailable.
void	addTask(java.sql.Connection connection, int id, java.lang.String name, java.lang.String description, java.sql.Timestamp start_time, java.sql.Timestamp end_time, double price, boolean creator_accepted, double location_latitude, double location_longitude) Persists a task into the database given a Task object.
void	cancelTask(java.sql.Connection connection, int taskId) Changes a task from unavailable to free.
void	copyTaskToFinished(java.sql.Connection connection, int taskId) Transfer task from Task table to Finish_Task table.
AbstractTask	getTask(java.sql.Connection connection, int task_id) Returns version of the task currently in database.
java.util.List<AbstractTask>	getTaskList(java.sql.Connection connection)
java.util.List<AbstractTask>	getTaskList(java.sql.Connection connection, int count, int startingIndex, java.util.List<TaskFilter> filters) Returns a list of tasks that user can complete
void	removeTask(java.sql.Connection connection, int task_id) Remove task from database.

Method Detail

addTask

void addTask(java.sql.Connection connection,
             int id,
             java.lang.String name,
             java.lang.String description,
             java.sql.Timestamp start_time,
             java.sql.Timestamp end_time,
             double price,
             boolean creator_accepted,
             double location_latitude,
             double location_longitude)
      throws UserRetrievalException,
             java.sql.SQLException

Persists a task into the database given a Task object. Validates the user based on whether a duplicate task_id already exists

Parameters:

connection - database connection

id - id of the user

name - Name of the user.

description - description of the new task

start_time - start time of the task. Format should be 'MM-DD-YY HH:mm'

end_time - end time of the task. Format should be 'MM-DD-YY HH:mm'

price - compensation amount of the task.

creator_accepted - 1 if creator accepted, 0 if not.

location_latitude - latitude of the task location

location_longitude - longitude of the task location

Throws:

UserRetrievalException - Attempt to add task with no valid user

java.sql.SQLException - for failure of SQL execution

removeTask

void removeTask(java.sql.Connection connection,
                int task_id)
         throws java.sql.SQLException

Remove task from database.

Parameters:

connection - Mysql connection.

task_id - Task to be deleted.

Throws:

java.sql.SQLException - SQL execution.

getTask

AbstractTask getTask(java.sql.Connection connection,
                     int task_id)
              throws TaskRetrievalException,
                     java.sql.SQLException

Returns version of the task currently in database. Returns a user based task ID.

Parameters:

connection - database connection

task_id - task ID assigned to the Task.

Returns:

DefaultServerTask task object given credentials

Throws:

TaskRetrievalException - for failure in retrieving a corresponding task

java.sql.SQLException - for failure in sql execution

getTaskList

java.util.List<AbstractTask> getTaskList(java.sql.Connection connection,
                                         int count,
                                         int startingIndex,
                                         java.util.List<TaskFilter> filters)
                                  throws java.sql.SQLException

Returns a list of tasks that user can complete

Parameters:

connection - Database connection.

count - Number of tasks in the task list.

startingIndex - The beginning index to be viewed.

filters - The list of filters to be applied

Returns:

List of tasks of interest to the user.

Throws:

java.sql.SQLException - For failure in sql execution.

getTaskList

java.util.List<AbstractTask> getTaskList(java.sql.Connection connection)
                                  throws java.sql.SQLException

Parameters:

connection - Database connection.

Returns:

All available tasks in the database.

Throws:

java.sql.SQLException - When connection fails.

acceptTask

void acceptTask(java.sql.Connection connection,
                int taskId)
         throws java.sql.SQLException

Change a task from free to unavailable.

Parameters:

connection - Database connection

taskId - Task to be accepted.

Throws:

java.sql.SQLException - When connection fails.

cancelTask

void cancelTask(java.sql.Connection connection,
                int taskId)
         throws java.sql.SQLException

Changes a task from unavailable to free.

Parameters:

connection - Database connection.

taskId - Task to be freed.

Throws:

java.sql.SQLException - When connection fails.

copyTaskToFinished

void copyTaskToFinished(java.sql.Connection connection,
                        int taskId)
                 throws java.sql.SQLException

Transfer task from Task table to Finish_Task table.

Parameters:

connection - Database connection.

taskId - Task to transferred.

Throws:

java.sql.SQLException - When connection fails.