public static ReservationBO SelectById(Int32 pId) { ReservationBO result; try { using (var reservationDal = new ReservationDAL(Util.GetConnection())) { result = (ReservationBO)reservationDal.ReservationDAL_SelectById(pId); } } catch (Exception Ex) { throw; } return result; }
public static List<ReservationBO> SelectEnCoursValidByInfo(String pInfo) { List<ReservationBO> result; try { using (var reservationDal = new ReservationDAL(Util.GetConnection())) { result = reservationDal.ReservationDAL_SelectEnCoursValidByInfo(pInfo).ToList(); foreach (var reservationBo in result){ reservationBo.Emprunt = EmpruntBL.SelectById(reservationBo.EmpruntId); reservationBo.DemandeReservation = DemandeReservationBL.SelectById(reservationBo.DemandeReservationId); } } } catch (Exception Ex) { throw; } return result; }
public static ReservationBO SelectEnCoursValidByReservationId(Int32 pDemandeReservationId) { ReservationBO result = null; try { using (var reservationDal = new ReservationDAL(Util.GetConnection())) { var lstResult = reservationDal.ReservationDAL_SelectEnCoursValidByReservationId(pDemandeReservationId).ToList(); if (lstResult.Count() == 1){ result = lstResult[0]; result.Emprunt = EmpruntBL.SelectById(result.EmpruntId); result.DemandeReservation = DemandeReservationBL.SelectById(result.DemandeReservationId); } } } catch (Exception Ex) { throw; } return result; }
public static List<ReservationBO> SelectAll() { List<ReservationBO> lstResult; try { using (var reservationDal = new ReservationDAL(Util.GetConnection())) { lstResult = reservationDal.ReservationDAL_SelectAll().ToList(); foreach (var reservationBo in lstResult){ reservationBo.Emprunt = EmpruntBL.SelectById(reservationBo.EmpruntId); reservationBo.DemandeReservation = DemandeReservationBL.SelectById(reservationBo.DemandeReservationId, reservationBo.Emprunt); } } } catch (Exception Ex) { throw; } return lstResult; }