Hotel Room Booking with Room Status - Update (ASP.NET, C#, VB, SQL Server)

The Hotel Room Booking tutorial was updated.

New features:

• SQL Server database (2008+)
• CSS Styling (Scheduler White theme)
• Room Status (Dirty/Cleanup/Ready)
• Payment Status
• Includes DayPilot Pro for ASP.NET WebForms 7.5 SP1 Trial.

Feature summary:

• Reservation Status (New/Confirmed/Arrived/Checked Out)
• Reservation Change Rules
• User Notifications
• Room Filtering (by Size)
• Modal Dialog for Reservation Editing
• Includes C# and VB.NET source code (downloadable Visual Studio solution).
• Supports .NET Framework 4.0 or higher.
• Supports Visual Studio 2010 or higher.

Download

You can download the sample project with C# and VB source code.

Online Demo

Test the tutorial project in an online demo.

Example: Room Status

The Scheduler control displays three columns (Room, Size, Status):

<DayPilot:DayPilotScheduler 
  ID="DayPilotScheduler1" 
  runat="server" 
  ...
  >
  <HeaderColumns>
      <DayPilot:RowHeaderColumn Title="Room" Width="80" />
      <DayPilot:RowHeaderColumn Title="Size" Width="80" />
      <DayPilot:RowHeaderColumn Title="Status" Width="80" />
  </HeaderColumns>
</DayPilot:DayPilotScheduler>

The status is set using BeforeResHeaderRender event handler and custom CSS classes:

C#

protected void DayPilotScheduler1_BeforeResHeaderRender(object sender, BeforeResHeaderRenderEventArgs e)
{
  string status = (string)e.DataItem["RoomStatus"];
  switch (status)
  {
      case "Dirty":
          e.CssClass = "status_dirty";
          break;
      case "Cleanup":
          e.CssClass = "status_cleanup";
          break;
  }
}

VB

Protected Sub DayPilotScheduler1_BeforeResHeaderRender(ByVal sender As Object, ByVal e As BeforeResHeaderRenderEventArgs)
  Dim status As String = CStr(e.DataItem("RoomStatus"))
  Select Case status
    Case "Dirty"
      e.CssClass = "status_dirty"
    Case "Cleanup"
      e.CssClass = "status_cleanup"
  End Select
End Sub