How to make rooms available?
<p>I am working on a website providing the hotel booking service as well as tourism information. The question is that how to make rooms available after the period of their booking has expired ..... This is actually a website and I'm writing it in ASP.NET and the code behind is C#.NET. The backend used is SQL Server 2005. I just want to ask what could be the possible logic to make the room available after the customer that booked it checked out the hotel. I mean, this room is to be now made available for any other customer. Suppose, I booked room A on 1-1-2013 for three days. During these days, if any other customer wants to book this room, it should be locked and the customer should be prompted to book another room. So, in short, the room should be made available the day the customer checks out and also should be available to another customer.</p>
