public List <Request> RetrieveIdByHotel(Request request) { try { var rqMapper = new RequestMapper(); var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( rqMapper.GetRetriveAllByIdStatement(request) ); if (lstResult.Count <= 0) { return(default(List <Request>)); } var obj = EntityObjectMapper.BuildObjects(lstResult); return(obj.Cast <Request>().ToList()); } catch (Exception e) { ManageException(e); } return(null); }