ScheduleView To show Hotel Room Bookings

4 posts, 0 answers
  1. Louis
    Louis avatar
    13 posts
    Member since:
    Aug 2011

    Posted 29 Aug 2011 Link to this post


    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
                    return roomType;
                    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







  2. palak
    palak avatar
    102 posts
    Member since:
    May 2011

    Posted 31 Aug 2011 Link to this post

    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.


  3. Konstantina
    Konstantina avatar
    2332 posts

    Posted 01 Sep 2011 Link to this post


    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.

    the Telerik team

    Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's DevProConnections Awards. We are competing in mind-blowing 20 categories and every vote counts! VOTE for Telerik NOW >>

  4. palak
    palak avatar
    102 posts
    Member since:
    May 2011

    Posted 03 Sep 2011 Link to this post

    Hi Konstantina ,

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


Back to Top