public int CancelBooking(Guid bookingGuid, DateTime cancelledDate)
        {
            string sql = @"dbo.Booking_CancelById @BookingGuid, @CancelledDate";

            return(SqlDataAccess.SaveData(sql, new { BookingGuid = bookingGuid, CancelledDate = cancelledDate }));
        }
        public int CheckOut(Guid bookingGuid, DateTime checkedOutDate)
        {
            string sql = @"dbo.Booking_CheckOutById @BookingGuid, @CheckedOutDate";

            return(SqlDataAccess.SaveData(sql, new { BookingGuid = bookingGuid, CheckedOutDate = checkedOutDate }));
        }
        public int CreateBooking(Guid id, string name, string phone, string email, DateTime checkInDate, DateTime checkOutDate)
        {
            string sql = @"dbo.Booking_Insert @Id, @Name, @Phone, @Email, @CheckInDate, @CheckOutDate";

            return(SqlDataAccess.SaveData(sql, new { Id = id, Name = name, Phone = phone, Email = email, CheckInDate = checkInDate, CheckOutDate = checkOutDate }));
        }