ScheduleView To show Hotel Room Bookings

[Louis]

Hi,

I would like to use the ScheduleView control. To display the Room Bookings for a hotel or resort.I have tried
to view examples, but I cant seem to find anything that pertains to me.

firstly I am using the entity framework to connect to my database, I have the following entities that pertain to my problem.
Booking, Room, Guest
Booking has amongst others the following fields,

• StartDate - Datetime
• EndDate - Datetime
• Guest
• Room
• ID - int

Room has amongst others the following fields

• RoomNumber - string (Eg: W01, K13)
• RoomType - string (Eg: 2 Bedroom 4 Sleeper, 1 Bedroom 2 sleeper)
• ID - int

guest has amongst others the following fields

• Name - string
• Surname - string
• ID - int

For the resources I thought to extend the default Resource class to add a field that I would require basically like this:

 

 

 

public class CustomResource : Resource
    {

        private string roomType;
        public string RoomType
        {
            get
            {
                return roomType;
            }
            set
            {
                if (value != roomType)
                {
                    roomType = value;
                }
            }
        }
}

 

If you are familiar with the ScheduleView example (FirstLook)I would like to group bookings in a similar way
to the way the courts are grouped. But I would like to have multiple tabs accros the top where each tab is a RoomType. otherwise listing 185 rooms below one another might not be very easy to use.

Regarding drag and drop, I would only like to be able to drag a room from its location perhaps to another room of the same type, if there is a opening. In doing that we an affectivly manage the rooms.

All our booking span either a single night or multiple nights.

In the Booking (Appointment) area on the screen, I would like to show the guest name and surname.

I hope I have provided enough information for someone to be able to assist me.

Thank You

Louis Lewis

 

 

 

 

 

 

[palak]

Hi Louis,

As per me, you need to take rooms [RoomNumber - string (Eg: W01, K13)] as another resource(resourcetype) like you took roomtype[2 Bedroom 4 Sleeper, 1 Bedroom 2 sleeper] as resource(resourcetype) if you want to display rooms vertically, and roomtype horizontally(on the top). Then you can use drag and drop your bookings easily. One thing that confused me how could we manage lot of resource items (185 rooms) in schduleview as there is no paging feature for viewdefinitions(day/week/month/timeline). Alternate filtering logic could be used but i would need this feature.

As you are using entity framework, guest name,surname other fields can easily be bounded.

thanks
palak

[Konstantina]

Hi,

For the paging feature - you can refer to this forum post in which is explained how to implement it in Scheduler control. The logic is exactly the same, the only difference is that with ScheduleView the ResourceTypeSource should be cleared and then the new set of resource types added, so that the control can refresh itself.

Hope this information helps.

Greetings,
Konstantina
the Telerik team

[palak]

Hi Konstantina ,

Thanks for pointing me out this link , it would be grt if i can. i'll go through your link.

palak.