I would like something simliar to the following but using my own desktop application design.
There would need to be a login in and user account where certain fields will be only updated by Admin (read only) However, email and preferences plus contact details will be the self service.
Admin will need to build the booking sheets with basic options - Start & end time plus slot intervals, when the day\course is open and closed for booking, how many times a user can book on a day (in a week) etc. There would need to be an option to mask out slots and also reserve slots. Each booking day \ course will need a CSV download option.
Database for members - memberID as a key field, email etc. User profile, admin notes, Balance
DOB, Locker, Filler 1 -10 for other options - Captain, Team Players, Group links 1 - 3 category
Database for category - member ID, category, start date , previous category
Database to pricing - Cat ID, Price table for each day for each category, each course, special pricing
Database for Groups Group ID Group description, members
Booking table - date time course, time, b9 time, p1 p2 p3 p4 (mem Id1-4) (Cat 1-4) event ID, bookingstatusSlot, timestamp, BookingstatusCheckin
Fire off email reminders plus bookings add, modify, delete - to admin if user profile \account data changed.
Drag and drop players - use of look up based on memid or typing name
Members to only manage their own record - members can add others to booking from drop down
I would prefer VB.net application - I think JQuery may help - SQL DB
I have had a booking application for over 20 years in commercial businesses - I would say the introduction of the now cloud booking sites have actually copied my features. They still don't offer all my features hence I am enhancing\migrating my desktop app to the cloud.
Lets talk about the phases and the costs - we can keep the scope very simple to start with to interface with my existing local application using a hybrid process.