public CommissionHotel getCommission(int hotel) { try { var mapperComissionHotel = new CommissionHotelObjectMapper(); var lstResult = SqlDao.GetInstance() .ExecuteQueryProcedure( hotelMapper.GetCommissionStatement(hotel) ); if (lstResult.Count <= 0) { return(null); } var obj = mapperComissionHotel.BuildObjects(lstResult); return(obj.Cast <CommissionHotel>().ToList().FirstOrDefault()); } catch (Exception e) { ManageException(e); } return(null); }