public List <Service> RetrieveAllByHotel(int idHotel) { try { ServiceMapper serviceMapper = new ServiceMapper(); var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( serviceMapper.GetRetriveAllByIdStatement(idHotel) ); if (lstResult.Count <= 0) { return(default(List <Service>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Service>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }