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);
        }