public static List <BookingMini> ExtractBookingsPeriodSelected(DateTime FromDate, DateTime ToDate)
{
using (TourplaniSEntities te = new TourplaniSEntities())
{
var bhdList = te.BHDs.Where(bhd => bhd.DATE_ENTERED >= FromDate && bhd.DATE_ENTERED <= ToDate)
.OrderBy(bhd => bhd.DATE_ENTERED)
.ToList();
return(bhdList.Select(bhd => ProjectToBookingMini(bhd)).ToList());
}
}
public static List <BookingMini> ExtractBookingsFutureTravelling()
{
using (TourplaniSEntities te = new TourplaniSEntities())
{
DateTime startTravelDate = DateTime.Today;
IEnumerable <BHD> BkgsSelected = te.BHDs
.Where(b => b.TRAVELDATE >= startTravelDate)
.OrderBy(b => b.DATE_ENTERED);
// projection and then send
return(BkgsSelected.Select(b => ProjectToBookingMini(b)).ToList());
}
}
