In case of hotel reservation ststem project, suppose that a hotel XYZ have a room with no. 111.
Also suppose that two castomers want to book that room(111) today.
1st customer wants to book that room for 3 days 29/4/2012,30/4/2012,1/5/2012..
2nd customer wnts to book that room for just one day 26/4/2012......
today is 21/4/2012............How can maintain all taht using c# code.......that means those two customers can book the room because their booking date for room no 111 does not override......but if 2nd customer wants to book the room for 28/4/2012 then i have to show the 2ndcustomer ROOM NO 111 NOT AVAILABLE
please give me some idea how can i maintain all that and database tables reqired for that...