1)BookingCalendarlist. with these fields; ID, StartDate, EndDate
2)Network. With this field; ID
3)BookingCalendarNetwork. With these fields; ID, BookingCalendarID & NetworkID.
So a booking calendar can have multiple networks and a network can be associated with multiple booking calendars.
Now when creating a new booking calendar, i want to check for any conflict, the conflict can happen,
1) if a network inside the booking calendar is already been used as per the BookingCalendar StartDate and EndDate.
So, when creating or editing a booking calendar, i did this to get all the BookingCalendar/s which are already busy during the current booking calendar + get the networks for the current booking calendar (the items selected inside the Networks combbox inside the Booking Calendar form) that is been created/edited:-
//check for booking calendar conflicts
//get the selected networks inside the Network combobox inside the Booking Calendar form
but not sure how i can complete the business logic for checking the conflict in the booking calendars' networks in a delegable way?