Doubts

Posted Date: 05 Sep 2008 Posted By: gopinath Member Level: Bronze Points: 1 Responses: 1

I am Doing the application package for hotel management System. Front End as VB.NET and Back End as SQL Server 2000.

In Room Booking Form, Under this We have booked a room before 2 days and the status is booked and on that particular date the room is booked.
But if we are going to book the same room on yesterday means it have to show me as the room is already booked and make some other rooms. But the message is displayed as present but the correct message is want to display on yesterday is already booked and make some rooms to u.

Please help me for this and how to manipulate it in both front and back end as well as possible.

Responses

Author: Anil Kumar Pandey 05 Sep 2008

Member Level: Diamond

Rating:

Points: 3

hi,

Before allotting the room to the cleint u need to Check the date as well as the status....

so Use Condition..

Until the date of Booking is having the Status=Empty..

Do not allow to book the Room...

Regards
Anil;

Thanks & Regards
Anil Kumar Pandey

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Source code to convert foxpro to MS Access database
	Previous : Grid filtering slow downs the grid loding
	Return to Discussion Forum
	Post New Message
	Category: .NET

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use