private Territories BuscarTerritory(string valor)
        {
            Territories ret = null;

            DataRow[] rows = territories.Select(String.Format("TerritoryID='{0}'", valor));

            if (rows == null)
            {
                rows = territories.Select(String.Format("TerritoryDescription='{0}'", valor));
            }

            if (rows != null)
            {
                DataRow row = rows[0];

                ret = new Territories()
                {
                    TerritoryID          = (string)row["TerritoryID"],
                    TerritoryDescription = (string)row["TerritoryDescription"],
                    RegionID             = (int)row["RegionID"],
                    Region = solRegions.BuscarId((int)row["RegionID"])
                };
            }

            return(ret);
        }
        private Region BuscarRegionID(int region)
        {
            Region ret = solRegions.BuscarId(region);

            return(ret);
        }