C# date range within date range restricted by threshold x
<p>I've asked a similar question before but this is more in depth given that I figured out could of things since then. So believe me it's not repeated. </p>

<p>My user will use the system to make a reservation of room space and provide a start date and an end date by which his reservation should expire. Now there is a threshold of x number of seats in the room. Many bookings could be placed on the same date range as long as the rooms are available. </p>

<p>What am finding difficulty dealing with is the multiple reservation on the same date, and even worst when it comes to booking a date range within a booked range. That is having a booking from 10oct example until 20, then another booking starting from let's say 11th oct till 30 or 5th nov. how can I keep track of this reservation? It's been killing me for the past few weeks. </p>

<p>I am using SQL database to store reservation form data and c#  language of choice to develop asp application. Thanks in advance for the help. </p>
