public static DemandeReservationBO SelectById(Int32 pDemandeReservationId)
        {
            DemandeReservationBO demandeReservation = null;

            try {
                using (var demandeReservationDal = new DemandeReservationDAL(Util.GetConnection())) {
                    var lstDemandeReservation = demandeReservationDal.DemandeReservationDAL_SelectById(pDemandeReservationId).ToList();
                    if (lstDemandeReservation.Count == 1){
                        demandeReservation = lstDemandeReservation[0];
                        demandeReservation.RefLivre = RefLivreBL.SelectById(demandeReservation.RefLivreId);
                        demandeReservation.Personne = PersonneBL.SelectById(demandeReservation.ClientId);
                    }
                }
            } catch (Exception ex) {
                throw;
            }

            return demandeReservation;
        }
        public static DemandeReservationBO SelectById(int pDemandeReservationId, EmpruntBO emprunt)
        {
            DemandeReservationBO demandeReservation = null;

            try {
                using (var demandeReservationDal = new DemandeReservationDAL(Util.GetConnection())) {
                    var lstDemandeReservation = demandeReservationDal.DemandeReservationDAL_SelectById(pDemandeReservationId).ToList();
                    if (lstDemandeReservation.Count == 1){
                        demandeReservation = lstDemandeReservation[0];
                        demandeReservation.RefLivre = emprunt.Livre.RefLivre;
                        demandeReservation.Personne = emprunt.Personne;
                    }
                }
            } catch (Exception ex) {
                throw;
            }

            return demandeReservation;
        }