= Use-case 0008 - Book Photographer =

'''Initiating actor:''' Bride / Groom (Wedding owner)

'''Other actors:''' Wedding Organizer (Assistant)

== Description ==
The user reserves a photographer for the wedding day. The booking is recorded with date, time range, status and links the photographer to a wedding.

== Scenario ==
1. The user opens the "Photographers" section.
2. The system lists photographers.

{{{
SET search_path TO project;

SELECT photographer_id, name, email, phone_number, price_per_hour
FROM photographer
ORDER BY name;
}}}

3. The user selects a photographer and clicks "Book".
4. The system displays a booking form.
5. The user submits booking.
6. The system saves the booking in the database.

{{{
SET search_path TO project;

INSERT INTO photographer_booking("date", start_time, end_time, status, photographer_id, wedding_id)
VALUES (:date, :start_time, :end_time, :status, :photographer_id, :wedding_id)
RETURNING booking_id;
}}}

7. The system confirms booking and displays booking details.