//-----------------------------------

        public List<Cliente> BuscarClienteD(String apellido, String nombre, String mail, Decimal documento)
        {
            var query = String.Format(@"Select * FROM LA_REVANCHA.CLIENTE WHERE 1 = 1 ");

            if (apellido != "")
            {
                query = query + "AND CLI_APELLIDO = '" + apellido + "' ";
            }
            if (nombre != "")
            {
                query = query + "AND CLI_NOMBRE = '" + nombre + "' ";
            }
            if (documento != 0)
            {
                query = query + "AND CLI_NUMERO_IDENTIFICACION = " + documento;
            }
            if (mail != "")
            {
                query = query + "AND CLI_MAIL = '" + mail + "' ";
            }

            DataRowCollection dataRow = SQLUtils.EjecutarConsultaSimple(query, "LA_REVANCHA.CLIENTE");

                var clientes = dataRow.ToList<Cliente>(this.DataRowToCliente);
                return clientes;
            
        }

        public static DataTable GetAllPERIODOXSETORNOME(
          ConnectionInfo pInfo, Decimal pSET_ID
      )
        {
            string lQuery = "";
            DataTable lTable = new DataTable();

            // lQuery = PERIODOXSETORQD.qPERIODOXSETORList;
            //            lQuery += @" WHERE PERQ_STATUS='A'
            //                         AND S.SET_ID = P.SET_ID
            //                         AND S.SET_STATUS='A'
            //                         AND P.PERQ_DIAINICIO <= SYSDATE
            //                         AND P.PERQ_DATAFIM >= SYSDATE
            //                         AND S.SET_ID = " + pSET_ID;

            lQuery += @"  SELECT S.*,P.*
                          from PERIODOXSETOR P , SETOR S WHERE PERQ_STATUS='A'
                          AND S.SET_ID = P.SET_ID
                          AND S.SET_STATUS='A'
                          AND S.SET_ID = " + pSET_ID;

            SelectCommand lSelect = new SelectCommand(lQuery);
            lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));

            return lTable;
        }

        public void ActualizarEscoit(Decimal cod_estadia, Decimal cod_consumible, Decimal cod_item)
        {
            var query = String.Format(@"UPDATE LA_REVANCHA.ESTADIA_CONSUMIBLE_ITEM SET ESCOIT_COD_ITEM = '{0}' WHERE ESCOIT_COD_ESTADIA = '{1}' AND ESCOIT_COD_CONSUMIBLE = '{2}'",
                cod_item, cod_estadia, cod_consumible);

            SQLUtils.EjecutarConsultaConEfectoDeLado(query);
        }

        public void BajarCliente(Decimal codigo, int habilitado)
        {
            var query = String.Format(@"UPDATE NINIRODIE.USUARIO SET USU_HABILITADO = " +
                "'{0}' WHERE USU_CODIGO = '{1}'", habilitado, codigo);

            SQLUtils.EjecutarConsultaConEfectoDeLado(query);
        }

 public AccountDTO(Int32 accountID, Decimal balance, CurrencyType currency, Int32 client_ClientID)
 {
     this.AccountID = accountID;
     this.Balance = balance;
     this.Currency = currency;
     this.Client_ClientID = client_ClientID;
 }

        public static List<Decimal> GetIncrements(Decimal lowerBound, Decimal upperBound)
        {
            if (lowerBound >= upperBound)
            {
                return null;
            }
            Decimal range = upperBound - lowerBound;

            int magnitude = (int)Math.Floor(Math.Log10((double)range));
            if (range < 1)
            {
                magnitude++;
            }
            Decimal step = (Decimal)Math.Pow(10, magnitude) / 10;

            Decimal value = (step * (Decimal)Math.Floor((double)(lowerBound / step)));
            if (value < lowerBound)
            {
                value += step;
            }
            List<Decimal> returnList = new List<Decimal>();
            while (value < upperBound + step)
            {
                returnList.Add((Decimal)Math.Round((double)value, 2));
                value += step;
            }
            return returnList;
        }

        public void SaveToDecimalTestCase1()
        {
            var expected = new Decimal( RandomValueEx.GetRandomInt32() );
            var actual = "InvalidValue".SaveToDecimal( expected );

            Assert.AreEqual( expected, actual );
        }

 public virtual void AddItem(string IDOP, Decimal Cantidad)
 {
     ItemGuiaRemision Item = new ItemGuiaRemision();
     Item.IDOrdenProduccion = IDOP;
     Item.Cantidad = Cantidad;
     Items.Add(Item);
 }

 public void SetMPG(Decimal urban, Decimal combined, Decimal extraUrban)
 {
     if (!(urban < combined && combined < extraUrban))
     {
         throw new Exception("Invalid MPG values detected, maybe you have a Volkswagen");
     }
 }

 public Tweet GetTweet(Decimal id)
 {
     Tweet tweet = (from t in _entity.Tweets
                    where t.ID == id
                    select t).FirstOrDefault();
     return tweet;
 }

 private void edtRaiDecimal_ValueChanged(object sender, EventArgs e)
 {
     if (!mChanging)
     {
         Area = edtRaiDecimal.Value * SquareKilometerToRai;
     }
 }

 public WalkingData(Decimal probability, int steps, int x, int y)
 {
     this.Probability = probability;
     this.Steps = steps;
     this.X = x;
     this.Y = y;
 }

        public DataTable ObtenerInformacionParaSemaforoPrincipal(Decimal ID_EMPRESA)
        {
            Conexion conexion = new Conexion(Empresa);
            DataSet _dataSet = new DataSet();
            DataView _dataView = new DataView();
            DataTable _dataTable = new DataTable();
            String sql = null;
            Boolean ejecutar = true;

            sql = "usp_nom_empleados_obtenerSemaforoPrincipalGestionHumana ";

            sql += ID_EMPRESA.ToString();

            if (ejecutar)
            {
                try
                {
                    _dataSet = conexion.ExecuteReader(sql);
                    _dataView = _dataSet.Tables[0].DefaultView;
                    _dataTable = _dataView.Table;
                }
                catch (Exception e)
                {
                    MensajeError = e.Message;
                }
                finally
                {
                    conexion.Desconectar();
                }
            }
            return _dataTable;
        }

        public static string FormatSeconds(long seconds)
        {
            Decimal time = new Decimal(seconds);

            string suffix;
            if (time > OneDay)
            {
                time /= OneDay;
                suffix = " days";
            }
            else if (time > OneHour)
            {
                time /= OneHour;
                suffix = " hours";
            }
            else if (time > OneMinute)
            {
                time /= OneMinute;
                suffix = " minutes";
            }
            else
            {
                suffix = " seconds";
            }

            return String.Format("{0}{1}", Math.Round(time), suffix);
        }

        private List<ChangeClass> makeChange(Decimal change,List<CurrencyClass> currencyList)
        {
            List<ChangeClass> results = new List<ChangeClass>();

            foreach (CurrencyClass currency in currencyList)
            {
                //since the list is sorted, we can just start at the top and work down

                int units = 0;
                if (currency.Value > change)
                {
                    continue; //nothing to do for this amount
                }
                else
                {
                    //do the math as integers to capture the whole numbers
                    int changeInt = Convert.ToInt32(Decimal.Round(change*100));
                    int valueInt = Convert.ToInt32(Decimal.Round(currency.Value*100));
                    units = changeInt / valueInt;
                    results.Add(new ChangeClass(units,currency));
                    change = change - units * currency.Value;
                }
            }

            return results;
        }

 private SqlDecimal(bool isNull)
 {
     _value = Decimal.Zero;
     _isNull = isNull;
     _precision = 38;
     _scale = 0;
 }

 public static double KmPerDegreeAtLatitude(Decimal latitude)
 {
     double cos = Math.Cos(Convert.ToDouble(latitude) * Math.PI / 180.0);
     //double kmPerDegree = RadiusAtLatitude(latitude) * Math.PI / 180;
     double retVal = KmPerDegree * cos;
     return retVal;
 }

        public void SaveToDecimalTestCase3()
        {
            var expected = new Decimal( RandomValueEx.GetRandomInt32() );
            var actual = "InvalidValue".SaveToDecimal( NumberStyles.Any, CultureInfo.InvariantCulture, expected );

            Assert.AreEqual( expected, actual );
        }

 /// <summary>Initializes a new instance of the <see cref="SalesOrderHeader"/> class.</summary>
 public SalesOrderHeader() : base()
 {
     _salesOrderId = default(System.Int32);
     _salesOrderNumber = default(System.String);
     _totalDue = default(System.Decimal);
     OnCreated();
 }

        /// <summary>
        /// Request a direct payment session
        /// </summary>
        /// <param name="credentials">PagSeguro credentials</param>
        /// <returns><c cref="T:Uol.PagSeguro.CancelRequestResponse">Result</c></returns>
        public static Installments GetInstallments(Credentials credentials, Decimal amount, String cardBrand)
        {
            PagSeguroTrace.Info(String.Format(CultureInfo.InvariantCulture, "InstallmentService.GetInstallments() - begin"));
            try
            {
                using (HttpWebResponse response = HttpURLConnectionUtil.GetHttpGetConnection(
                    BuildInstallmentURL(credentials, amount, cardBrand)))
                {
                    using (XmlReader reader = XmlReader.Create(response.GetResponseStream()))
                    {

                        Installments result = new Installments();
                        InstallmentsSerializer.Read(reader, result);
                        PagSeguroTrace.Info(String.Format(CultureInfo.InvariantCulture, "InstallmentService.Register({0}) - end", result.ToString()));
                        return result;
                    }
                }
            }
            catch (ArgumentException exception)
            {
                PagSeguroServiceException pse = new PagSeguroServiceException(exception.Message);
                PagSeguroTrace.Error(String.Format(CultureInfo.InvariantCulture, "InstallmentService.Register() - error {0}", exception.Message));
                throw pse;
            }
            catch (WebException exception)
            {
                PagSeguroServiceException pse = HttpURLConnectionUtil.CreatePagSeguroServiceException((HttpWebResponse)exception.Response);
                PagSeguroTrace.Error(String.Format(CultureInfo.InvariantCulture, "InstallmentService.Register() - error {0}", pse));
                throw pse;
            }
        }