public void FilterRouteBycationDate()
{
#region 서울 -> 정읍
if (comboArrival.Text == "서울" && comboDeparture.Text == "정읍")
{
var result = from reservationtime in ReservationDao.GetAllReservationDate()
from route in RouteDao.GetByRouteId()
where reservationtime.RouteId == 1 && route.RouteId == 1 && DateTimePicker.Value.Date == reservationtime.ReservationDate
select new
{
reservationtime.ArrivalTime,
reservationtime.DepartureTime,
reservationtime.ReservationDate,
route.ArrivalLocation,
reservationtime.TravelTime,
reservationtime.RouteId
};
routeBindingSource.DataSource = result;
}
#endregion
#region 대전 -> 부산
if (comboArrival.Text == "대전" && comboDeparture.Text == "부산")
{
var result = from reservationtime in ReservationDao.GetAllReservationDate()
from route in RouteDao.GetByRouteId()
where reservationtime.RouteId == 2 && route.RouteId == 2 && DateTimePicker.Value.Date == reservationtime.ReservationDate
select new
{
reservationtime.ArrivalTime,
reservationtime.DepartureTime,
reservationtime.ReservationDate,
route.ArrivalLocation,
reservationtime.TravelTime,
reservationtime.RouteId
};
routeBindingSource.DataSource = result;
}
#endregion
}