private void FillBookingList()
{
var booking = new Booking(database);
var bookingList = booking.GetBookingList();
var videolist = booking.GetVideo();
var genrelist = booking.GetGenre();
var customerlist = booking.GetCustomer();
var result = from bklist in bookingList
join vdo in videolist
on bklist.VideoId equals vdo.Id
join cust in customerlist
on bklist.CustomerId equals cust.Id
join gnr in genrelist
on vdo.GenreId equals gnr.Id
select new ListViewItem(new VideoBooking()
{
Id= bklist.Id,
CustomerName= cust.Name,
VideoName = vdo.Name,
GenreName = gnr.Name,
RentDate = bklist.RentDate,
ReturnDate = bklist.ReturnDate,
Cost = bklist.Cost
}.ToArray());
lvwBookings.Items.Clear();
lvwBookings.Items.AddRange(result.ToArray());
}