public static List<Reservation> GetReservationByDurationAndUser(DateTime pBeginTime, DateTime pEndTime, string pUserFrom)
{
List<Reservation> reservationList = new List<Reservation>();
DataContextDataContext dc = new DataContextDataContext();
ISingleResult<select_reservation_by_duration_and_userResult> rs = dc.select_reservation_by_duration_and_user((DateTime?)pBeginTime, (DateTime?)pEndTime, pUserFrom);
foreach (select_reservation_by_duration_and_userResult r in rs)
{
List<DishQuota> dishQuotaList = new List<DishQuota>();
ISingleResult<get_dishquota_by_reservationResult> rs2 = dc.get_dishquota_by_reservation(r.id);
foreach (get_dishquota_by_reservationResult r2 in rs2)
{
double price = 0;
ISingleResult<get_dish_by_nameResult> rs3 = dc.get_dish_by_name(r2.dish_name);
foreach (get_dish_by_nameResult r3 in rs3)
{
price = (double)r3.price;
}
DishQuota tDishQuota = new DishQuota(r2.id, r2.dish_name, price, (int)r2.quato, r2.note);
dishQuotaList.Add(tDishQuota);
}
Reservation reservation = new Reservation(
r.id,
r.user_from,
r.customer_name,
r.phone,
(DateTime)r.arrive_time,
r.table_name,
(int)r.seat,
(ReservationType)r.type,
(ReservationState)r.state,
dishQuotaList);
reservationList.Add(reservation);
}
return reservationList;
}