public final class AppointmentResourceHome extends Object
Modifier and Type | Method and Description |
---|---|
static void |
delete(int nIdAppointment,
int nIdAppointmentFormResourceType)
Delete an appointment resource
|
static void |
deleteByIdAppointment(int nIdAppointment)
Delete appointment resource associated with a given appointment
|
static void |
deleteByIdAppointmentFormResourceType(int nIdAppointmentFormResourceType)
Delete appointment resource associated with a given appointment form resource type
|
static List<AppointmentResource> |
findByIdAppointment(int nIdAppointment)
Find appointment resource associated with a given appointment
|
static AppointmentResource |
findByPrimaryKey(int nIdAppointment,
int nIdAppointmentFormResourceType)
Find an appointment resource from its primary key
|
static List<Integer> |
findIdAppointmentsByResourceAndDate(String strIdResource,
String strResourceType,
Date dateMin,
Date dateMax)
Get the list of id of appointments a resource is associated to between two given dates
|
static void |
insert(AppointmentResource resource)
Insert a new appointment resource
|
static boolean |
isResourceAvailable(String strIdResource,
String strResourceTypeName,
Timestamp nStartingTime,
Timestamp nEndingTime)
Check if a resource is available for a given period, or if it has already been associated with an appointment
|
static void |
update(AppointmentResource resource)
Update an appointment resource
|
public static void insert(AppointmentResource resource)
resource
- The appointment resource to insertpublic static AppointmentResource findByPrimaryKey(int nIdAppointment, int nIdAppointmentFormResourceType)
nIdAppointment
- The id of the appointmentnIdAppointmentFormResourceType
- the id of the appointment form resource typepublic static List<AppointmentResource> findByIdAppointment(int nIdAppointment)
nIdAppointment
- the id of the appointmentpublic static void update(AppointmentResource resource)
resource
- The appointment resource to updatepublic static void delete(int nIdAppointment, int nIdAppointmentFormResourceType)
nIdAppointment
- The id of the appointment of the appointment resourcenIdAppointmentFormResourceType
- The id of the appointment form resource type of the appointment resourcepublic static void deleteByIdAppointment(int nIdAppointment)
nIdAppointment
- The id of the appointmentpublic static void deleteByIdAppointmentFormResourceType(int nIdAppointmentFormResourceType)
nIdAppointmentFormResourceType
- The id of the appointment form resource typepublic static boolean isResourceAvailable(String strIdResource, String strResourceTypeName, Timestamp nStartingTime, Timestamp nEndingTime)
strIdResource
- The id of the resourcestrResourceTypeName
- The type of the resourcenStartingTime
- The beginning timenEndingTime
- the ending timepublic static List<Integer> findIdAppointmentsByResourceAndDate(String strIdResource, String strResourceType, Date dateMin, Date dateMax)
strIdResource
- The id of the resourcestrResourceType
- The resource typedateMin
- The minimum datedateMax
- the maximum dateCopyright © 2018 City of Paris. All rights reserved.