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()); } }