create proc OnlineBookingChargesGenerate2
(
	@BookingOrderID int
)
as
begin

set nocount on

declare @UnitID int			-- Unit for booking order
declare @LineItemNum tinyint		-- This is our line item number, which is incremented for each charge inserted into OnlineBookingOrderCharges
declare @BeginningStay datetime		-- Beginning day of reservation
declare @EndingStay datetime		-- Ending day of reservation
declare @BookingOrderChargeID int	-- ID of inserted charge, comes from OnlineBookingOrderChargeInsert return value

-- Check for valid Booking Order
if not exists(select BookingOrderID from OnlineBookingOrders where BookingOrderID = @BookingOrderID)
	return -1

-- Check to make sure Booking Order's charges have not already been generated (modifications to order may not be done through this procedure)
if exists(select BookingOrderID from OnlineBookingOrderCharges where BookingOrderID = @BookingOrderID)
	return -1

-- Assign local variables
select
	@BeginningStay = BeginningStay,
	@EndingStay = EndingStay,
	@UnitID = UnitID
	from OnlineBookingOrders
	where BookingOrderID = @BookingOrderID

-- Calculate rent charges from reservation

declare @CurrentDate datetime
declare @Quantity tinyint
declare @UnitPrice money
declare @Amount money
set @Quantity = 1
set @CurrentDate = @BeginningStay
set @LineItemNum = 1
while @CurrentDate <= @EndingStay
begin	
	if exists(select * from RatesCustom where UnitID = @UnitID and CustomDate = @CurrentDate)
	begin
		-- insert line-item charge
		insert into OnlineBookingOrderCharges
		(
			BookingOrderID,
			ChargeName,
			ChargeType,
			ChargeStatus,
			UnitPrice,
			Quantity,
			TotalAmount,
			LineItemNum
		)
		select 
			@BookingOrderID,
			'Reservation ' + datename(m, @CurrentDate) + ' ' + datename(d, @CurrentDate) + 
			case 
				when datename(d, @CurrentDate) IN ('1', '21', '31') then 'st'
				when datename(d, @CurrentDate) IN ('2', '22') then 'nd'
				when datename(d, @CurrentDate) IN ('3', '23') then 'rd'
				ELSE 'th'
			end,
			'N',
			'A',
			Amount,
			@Quantity,
			Amount * @Quantity,
			@LineItemNum
		from RatesCustom		
		where UnitID = @UnitID and CustomDate = @CurrentDate
	
		-- increment line-item #
		set @LineItemNum = @LineItemNum + 1
		
		-- increment current date
		set @CurrentDate = DateAdd(d, 1, @CurrentDate)
	end
	else
	begin
		-- find our prices from Rates table
		select @Amount = 
			case datename(weekday, @CurrentDate)
				when 'Monday' then DefaultMondayAmount
				when 'Tuesday' then DefaultTuesdayAmount
				when 'Wednesday' then DefaultWednesdayAmount
				when 'Thursday' then DefaultThursdayAmount
				when 'Friday' then DefaultFridayAmount
				when 'Saturday' then DefaultSaturdayAmount
				when 'Sunday' then DefaultSundayAmount
			end
		from Rates
		where UnitID = @UnitID
		print cast(@Amount as varchar(100))
	
		-- insert line-item charge
		insert into OnlineBookingOrderCharges
		(
			BookingOrderID,
			ChargeName,
			ChargeType,
			ChargeStatus,
			UnitPrice,
			Quantity,
			TotalAmount,
			LineItemNum
		)
		select 
			@BookingOrderID,
			'Reservation ' + datename(m, @CurrentDate) + ' ' + datename(d, @CurrentDate) + 
			case 
				when datename(d, @CurrentDate) IN ('1', '21', '31') then 'st'
				when datename(d, @CurrentDate) IN ('2', '22') then 'nd'
				when datename(d, @CurrentDate) IN ('3', '23') then 'rd'
				ELSE 'th'
			end,
			'N',
			'A',
			@Amount,
			@Quantity,
			@Amount * @Quantity,
			@LineItemNum
	
		-- increment line-item #
		set @LineItemNum = @LineItemNum + 1

		-- increment current date
		set @CurrentDate = DateAdd(d, 1, @CurrentDate)

	end
end


end