在特定月份的非预订日期预订特定酒店的房间 [英] to book room of particular hotel on non booking dates of particular month

问题描述

我正在做旅游指南项目..我为在线客户提供预订酒店房间的设施..
但我对如何获取不是为特定房间预订的日期感到困惑...
我的酒店表结构是这样的:

i am doing project on tourism guide.. in that i m provide facility of booking hotel room for customer online..
but i m confused to how to get dates which are not book for a particular room...
my hotel table structure is like this :

hotel_mast 
------------------ 
hotel_Code(p.k) 
hotel_name 
hotel_address 
hotel_City 

room_detail 
------------------- 
room_Code 
hotel_Code(f.k) 
room_Type 
room_Rate 
no_of_room 
room_availability 

booking_mast 
------------------- 
book_Code(p.k) 
hotel_Code(f.k) 
room_Code(f.k) 
check_in_date 
check_out_date 
total_Amount 

请..帮助我确定日期..在15天内，我将提交我的项目...因此，请帮助我..
佐治...
请使用c#语言在asp.net中提供答案..

please.. help me to get date.. within 15 days my submission of my project is coming... so please help me..
Sachi ...
plz give ans in asp.net with c# language..

推荐答案

在我看来，这在逻辑上是有缺陷的:在现实世界中，潜在客户和酒店员工都会这样做不需要知道没有预定房间的日期".

他们需要知道的是预订的日期.然后，对于客户或雇员(或两者)，您可以构造一个可视用户界面(DateTimePicker?)，该界面显示所有预订，因此隐式显示所有可用日期.

我想您可能会遇到一种罕见的(?)情况，即有人想要一个特定的房间，并且想知道什么时候有空，但是在那种情况下，您仍然希望有某种时间范围:某种基础像这样的查询:在2011年12月的最后一周，#302房什么时候可用"?

或者，如果没有可视化的用户界面，您希望能够采用客户建议的开始日期和停留时间，并进行查询以返回所有可用客房?

因此，房间可用性"成为针对您数据库的查询，而不是针对房间详细信息"表字段的查询?

祝您功课顺利！

This seems to me logically flawed: in the real world both the potential customer, and the hotel employees do not need to know the "dates which are not booked for a room."

What they do need to know are which dates are booked. Then for either customer or employee (or both) you could construct a visual user interface (DateTimePicker ?) that, since it shows all bookings, implicitly shows all available dates.

I guess you could have the rarer (?) case that someone wanted a specific room, and wanted to know when it was available, but in that case you''d still want to have some kind of time frame: some kind of basis for a query like: ''in the last week of December, 2011, what days is Room #302 available'' ?

Or, if there''s no visual user interface, you want to be able to take a customer''s proposed starting date, and length of stay, and do a query that returns all rooms available ?

So then ''room availability'' becomes a query against your database, not a ''room-detail'' Table field ?

good luck with your homework !

这篇关于在特定月份的非预订日期预订特定酒店的房间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！