public List <Hotel> RetrieveAllByUser(string user) { try { HotelMapper hotelMapper = new HotelMapper(); var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( hotelMapper.GetRetriveAllByIdStatement(user) ); if (lstResult.Count <= 0) { return(default(List <Hotel>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Hotel>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }