| java.lang.Object
 projectmanagement.business.timewage.WorkSheetManagerImpl
| WorkSheetManagerImpl | | public class WorkSheetManagerImpl implements WorkSheetManager(Code) | | Used to find the instance of WorkSheet.
author:
Sasa Bojanic
version:
1.0 |
| Method Summary | |
| public WorkSheet | findWorkSheetByID(String id)
The findWorkSheetByID method performs a database query to
return a WorkSheet object
representing the row in the worksheet table
that matches the object id.
id, the object id of the worksheet table.the worksheet. | | public WorkSheet[] | getAllWorkSheets()
The getAllWorkSheets method performs a database query to
return all WorkSheet objects representing the
row in the WorkSheets table. | | public WorkSheet[] | getAllWorkSheetsForEmployee(Employee employee)
The getAllWorkSheetsForEmployee method performs a database query to
return all WorkSheet objects representing the
row in the WorkSheets table that belongs to the
given employee. | | public WorkSheet[] | getAllWorkSheetsForEmployeeProjectPair(String employeeID, String projectID)
The getAllWorkSheetsForEmployeeProjectPair method performs
a database query to return a WorkSheet objects
representing the row in the worksheet table
that matches the employee given by employeeID and project
given by projectID.
employeeID, the object id of Employee for which we need worksheets. | | public WorkSheet[] | getAllWorkSheetsForEmployeeProjectPair(Employee employee, Project project)
The getAllWorkSheetsForEmployeeProjectPair method performs
a database query to return a WorkSheet objects
representing the row in the worksheet table
that matches the employee and project.
Parameters:
employee - employee for which we need worksheets.
Parameters:
project - project for which we need worksheets.array of worksheets. | | public WorkSheet[] | getAllWorkSheetsForEmployeeProjectPairFromDate1ToDate2(String employeeID, String projectID, java.sql.Date date1, java.sql.Date date2)
The getAllWorkSheetsForEmployeeProjectPair method performs
a database query to return a WorkSheet objects
representing the row in the worksheet table
that matches the employee given by employeeID, project given
by projectID and between date1 and date2 (including date1).
employeeID, the object id of Employee for which we need worksheets. | | public WorkSheet[] | getAllWorkSheetsForEmployeeProjectPairFromDate1ToDate2(Employee employee, Project project, java.sql.Date date1, java.sql.Date date2)
The getAllWorkSheetsForEmployeeProjectPair method performs
a database query to return a WorkSheet objects
representing the row in the worksheet table
that matches the employee, project and between date1 and date2
(including date1).
Parameters:
employee - Employee for which we need worksheets.
Parameters:
project - Project for which we need worksheets.
Parameters:
date1 - begining date (including date1)
Parameters:
date2 - ending datearray of worksheets. | | public WorkSheet[] | getAllWorksheetsForEmployeeArrayAndProjectArrayBetweenDates(java.util.ArrayList employeeIDs, java.util.ArrayList projectIDs, java.sql.Date date1, java.sql.Date date2)
The getAllWorkSheetsForEmployeeProjectPair method performs
a database query to return a WorkSheet objects
representing the row in the worksheet table
that matches the employee, project and between date1 and date2
(including date1).
Parameters:
employeeIDs - java.util.ArrayList for which we need worksheets.
Parameters:
projectIDs - java.util.ArrayList for which we need worksheets.
Parameters:
date1 - begining date (including date1)
Parameters:
date2 - ending datearray of worksheets. | | public WorkSheet | getWorkSheet()
|
| findWorkSheetByID | | public WorkSheet findWorkSheetByID(String id) throws ProjectManagementBusinessException(Code) | | The findWorkSheetByID method performs a database query to
return a WorkSheet object
representing the row in the worksheet table
that matches the object id.
id, the object id of the worksheet table.the worksheet. null if there isn't a worksheet associatedthe id
exception:
ProjectManagementBusinessException - if there is a problem retrieving worksheet information. |
| getAllWorkSheetsForEmployee | | public WorkSheet[] getAllWorkSheetsForEmployee(Employee employee) throws ProjectManagementBusinessException(Code) | | The getAllWorkSheetsForEmployee method performs a database query to
return all WorkSheet objects representing the
row in the WorkSheets table that belongs to the
given employee.
Parameters:
employee - the employee all the worksheets for given employee
exception:
ProjectManagementBusinessException - if there is a problem retrieving worksheet information. |
| getAllWorkSheetsForEmployeeProjectPair | | public WorkSheet[] getAllWorkSheetsForEmployeeProjectPair(String employeeID, String projectID) throws ProjectManagementBusinessException(Code) | | The getAllWorkSheetsForEmployeeProjectPair method performs
a database query to return a WorkSheet objects
representing the row in the worksheet table
that matches the employee given by employeeID and project
given by projectID.
employeeID, the object id of Employee for which we need worksheets. projectID, the object id of Project for which we need worksheets.array of worksheets. null if there isn't a worksheet associatedthe employeeID and projectID
exception:
ProjectManagementBusinessException - if there is a problem retrieving worksheet information. |
| getAllWorkSheetsForEmployeeProjectPair | | public WorkSheet[] getAllWorkSheetsForEmployeeProjectPair(Employee employee, Project project) throws ProjectManagementBusinessException(Code) | | The getAllWorkSheetsForEmployeeProjectPair method performs
a database query to return a WorkSheet objects
representing the row in the worksheet table
that matches the employee and project.
Parameters:
employee - employee for which we need worksheets.
Parameters:
project - project for which we need worksheets.array of worksheets. null if there isn't a worksheet associatedthe employee and project
exception:
ProjectManagementBusinessException - if there is a problem retrieving worksheet information. |
| getAllWorkSheetsForEmployeeProjectPairFromDate1ToDate2 | | public WorkSheet[] getAllWorkSheetsForEmployeeProjectPairFromDate1ToDate2(String employeeID, String projectID, java.sql.Date date1, java.sql.Date date2) throws ProjectManagementBusinessException(Code) | | The getAllWorkSheetsForEmployeeProjectPair method performs
a database query to return a WorkSheet objects
representing the row in the worksheet table
that matches the employee given by employeeID, project given
by projectID and between date1 and date2 (including date1).
employeeID, the object id of Employee for which we need worksheets. projectID, the object id of Project for which we need worksheets.
Parameters:
date1 - begining date (including date1)
Parameters:
date2 - ending datearray of worksheets. null if there isn't a worksheet associatedthe employeeID, projectID and between date1 and date2
exception:
ProjectManagementBusinessException - if there is a problem retrieving worksheet information. |
| getAllWorkSheetsForEmployeeProjectPairFromDate1ToDate2 | | public WorkSheet[] getAllWorkSheetsForEmployeeProjectPairFromDate1ToDate2(Employee employee, Project project, java.sql.Date date1, java.sql.Date date2) throws ProjectManagementBusinessException(Code) | | The getAllWorkSheetsForEmployeeProjectPair method performs
a database query to return a WorkSheet objects
representing the row in the worksheet table
that matches the employee, project and between date1 and date2
(including date1).
Parameters:
employee - Employee for which we need worksheets.
Parameters:
project - Project for which we need worksheets.
Parameters:
date1 - begining date (including date1)
Parameters:
date2 - ending datearray of worksheets. null if there isn't a worksheet associatedthe employeeID, projectID and between date1 and date2
exception:
ProjectManagementBusinessException - if there is a problem retrieving worksheet information. |
| getAllWorksheetsForEmployeeArrayAndProjectArrayBetweenDates | | public WorkSheet[] getAllWorksheetsForEmployeeArrayAndProjectArrayBetweenDates(java.util.ArrayList employeeIDs, java.util.ArrayList projectIDs, java.sql.Date date1, java.sql.Date date2) throws ProjectManagementBusinessException(Code) | | The getAllWorkSheetsForEmployeeProjectPair method performs
a database query to return a WorkSheet objects
representing the row in the worksheet table
that matches the employee, project and between date1 and date2
(including date1).
Parameters:
employeeIDs - java.util.ArrayList for which we need worksheets.
Parameters:
projectIDs - java.util.ArrayList for which we need worksheets.
Parameters:
date1 - begining date (including date1)
Parameters:
date2 - ending datearray of worksheets. null if there isn't a worksheet associatedthe employeeIDs, projectIDs and between date1 and date2
exception:
ProjectManagementBusinessException - if there is a problem retrieving worksheet information. |
|
|