Database

<br />
SELECT DISTINCT <br />
Ad.pkAdId, Ad.fileName, Ad.name, Ad.length, Ad.lastUpdated,<br />
MAX(BookingDate.bookingDate) AS MaxDate,<br />
MIN(BookingDate.bookingDate) AS MinDate,<br />
AVG(BookingHour.bookedSlots + BookingHour.bonusSlots) AS AverageSlots<br />
FROM Ad <br />
INNER JOIN Booking ON Ad.pkAdId = Booking.fkAdId <br />
INNER JOIN BookingDate ON Booking.pkBookingId = BookingDate.fkBookingId<br />
INNER JOIN BookingHour ON BookingDate.pkBookingDateId = BookingHour.fkBookingDateId<br />
WHERE (Booking.fkChannelId = @channelId)<br />
GROUP BY Ad.pkAdId, Ad.fileName, Ad.name, Ad.length, Ad.lastUpdated<br />
Having MAX(BookingDate.bookingDate) >= @startDate<br />
AND MIN(BookingDate.bookingDate) <= @endDate)<br />
ORDER BY Ad.fileName<br />

Friend Function DateToDb(ByVal val As Object) As Object
   'Validates a datevalue before saving to db
   If IsDate(val) Then
     Return val
   Else
     Return DBNull.Value
   End If

 End Function

 Friend Function DateFromDb(ByVal val As Object, Optional ByVal DateFormat As String = "MM/dd/yyyy") As Object
   'Validate the date from the database. Return "" if null
   If TypeOf val Is Date Then
     Return Format(val, DateFormat)
   End If
   Return C_ES

 End Function