public static List<DemandeReservationBO> SelectByEmpruntId(int pEmpruntId, PersonneBO pPersonne, LivreBO pLivre)
        {
            List<DemandeReservationBO> lstDemandeReservation;

            try {
                using (var demandeReservationDal = new DemandeReservationDAL(Util.GetConnection())) {
                    lstDemandeReservation = demandeReservationDal.DemandeReservationDAL_SelectByEmpruntId(pEmpruntId).ToList();
                    foreach (var demandeReservationBo in lstDemandeReservation){
                        demandeReservationBo.RefLivre = pLivre.RefLivre;
                        demandeReservationBo.Personne = pPersonne;
                    }
                }
            } catch (Exception ex) {
                throw;
            }

            return lstDemandeReservation;
        }
        internal static List<DemandeReservationBO> SelectByEmpruntId(Int32 pEmpruntId)
        {
            List<DemandeReservationBO> lstDemandeReservation;

            try {
                using (var demandeReservationDal = new DemandeReservationDAL(Util.GetConnection())) {
                    lstDemandeReservation = demandeReservationDal.DemandeReservationDAL_SelectByEmpruntId(pEmpruntId).ToList();
                    foreach (var demandeReservationBo in lstDemandeReservation){
                        demandeReservationBo.RefLivre = RefLivreBL.SelectById(demandeReservationBo.RefLivreId);
                        demandeReservationBo.Personne = PersonneBL.SelectById(demandeReservationBo.ClientId);
                    }
                }
            } catch (Exception ex) {
                throw;
            }

            return lstDemandeReservation;
        }