コード例 #1
0
        private void mbntGeo_Click(object sender, EventArgs e)
        {
            txtreslt      = "";
            dtCoordinates = new DataTable();
            validar       = new Classes.validacao();
            format        = new Classes.formatResult();
            DataTable dt = new DataTable();

            geocode = new Classes.Geocode();
            dt      = Classes.excel.import(openFileDialog1.FileName);

            if (validar.existColunm(dt, colY) && validar.existColunm(dt, colX))
            {
                //cria as clunas com uma chave estrageira de fk
                dtCoordinates.Columns.AddRange(new DataColumn[13]
                {
                    new DataColumn("Id", typeof(int)),
                    new DataColumn("BAIRRO", typeof(string)),
                    new DataColumn("LOGRADOURO", typeof(string)),
                    new DataColumn("NUM", typeof(string)),
                    new DataColumn("MUNICIPIO", typeof(string)),
                    new DataColumn("COMPLEMENTO", typeof(string)),
                    new DataColumn("CEP", typeof(string)),
                    new DataColumn("UF", typeof(string)),
                    new DataColumn("PAIS", typeof(string)),
                    new DataColumn("Latitude", typeof(string)),
                    new DataColumn("Longitude", typeof(string)),
                    new DataColumn("Fonte", typeof(string)),
                    new DataColumn("Precisao", typeof(string)),
                });

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (dt.Rows[i][colY].ToString() != "" && dt.Rows[i][colX].ToString() != "")
                    {
                        dt.Rows[i][colY] = dt.Rows[i][colY].ToString().Trim(); //remove espaço do valor da coluna Y na posição i
                        dt.Rows[i][colX] = dt.Rows[i][colX].ToString().Trim(); //remove espaço do valor da coluna X na posição i
                        txtreslt         = geocode.geocodeReverso(mcmbFonte.SelectedIndex, dt.Rows[i][colY].ToString(), dt.Rows[i][colX].ToString(), "*****@*****.**");

                        retorno = format.resultJsonReversoGeo(txtreslt, mcmbFonte.SelectedIndex);

                        if (!retorno[0].Contains("Erro") && !retorno[1].Contains("Erro") && retorno[1] != "NULL" && retorno[2] != "NULL" && retorno[3] != "NULL")
                        {
                            dtCoordinates.Rows.Add(i, validar.formatUTF8(retorno[0]), validar.formatUTF8(retorno[1]), validar.formatUTF8(retorno[2]), validar.formatUTF8(retorno[3]), validar.formatUTF8(retorno[4]), validar.formatUTF8(retorno[5]), validar.formatUTF8(retorno[6]), validar.formatUTF8(retorno[7]), validar.formatUTF8(retorno[8]), validar.formatUTF8(retorno[9]), validar.formatUTF8(retorno[10]), validar.formatUTF8(retorno[11]));
                        }
                        else
                        {
                            dtCoordinates.Rows.Add(i, validar.formatUTF8(retorno[0]), validar.formatUTF8(retorno[1]), validar.formatUTF8(retorno[2]), validar.formatUTF8(retorno[3]));
                        }
                    }
                }
            }
        }
コード例 #2
0
        public string[] resultReversoGeo(string txtxml, int fonte, string pk, string fk)
        {
            //fazer try catch instacia essa classe somente dentro da função
            // retorna messagem de erro quando ocorrer o mesmo

            DataSet ds = new DataSet();

            validar = new validacao();
            DataTable dt = new DataTable();

            string[] row = new string[12];

            XmlDocument docxml = new XmlDocument();

            docxml.LoadXml(txtxml);
            ds.ReadXml(new XmlNodeReader(docxml));
            string numero     = string.Empty;
            string logradouro = "NULL";
            string bairro     = "NULL";
            string cidade     = "NULL";
            string estado     = "NULL";
            string pais       = "NULL";
            string cep        = "NULL";
            string lat        = "NULL";
            string lng        = "NULL";
            string precisao   = "NULL";



            switch (fonte)
            {
            case 1:    //GOOGLE


                if (ds.Tables["GeocodeResponse"].Rows[0]["status"].ToString() == "OK")    //verifica se retorno algo
                {
                    try
                    {
                        if (txtxml.Contains("premise"))
                        {
                            if (ds.Tables["GeocodeResponse"].Rows[0]["status"].ToString() == "OK")    //verifica se retorno algo
                            {
                                ds.Tables["address_component"].Rows[0]["long_name"].ToString();
                                ds.Tables["address_component"].Rows[0]["short_name"].ToString();
                                ds.Tables["address_component"].Rows[0]["type"].ToString();
                            }

                            row = new string[] { "Erro(0x00101):", "Erro de requisição", "Messagem original:" + txtxml, "", "", "", "", "", "", "", "", "", "" };
                        }

                        if (txtxml.Contains("(0x00101)"))
                        {
                            row = new string[] { "Erro(0x00101):", "Erro de requisição", "Messagem original:" + txtxml, "", "", "", "", "", "", "", "", "", "" };
                        }
                        else
                        {
                            if ((txtxml.Contains("sublocality_level_1")))
                            {
                                if (txtxml.Contains("street_number"))
                                {
                                    if (ds.Tables["address_component"].Rows[0][1].ToString().Contains("-"))
                                    {
                                        numero = validar.calcMedia(ds.Tables["address_component"].Rows[0]["long_name"].ToString().Split('-')).ToString();
                                    }
                                    else
                                    {
                                        numero = ds.Tables["address_component"].Rows[0]["long_name"].ToString();
                                    }
                                }
                                else
                                {
                                    numero = "NULL";
                                }
                                if (txtxml.Contains("route"))
                                {
                                    logradouro = ds.Tables["address_component"].Rows[1]["long_name"].ToString();
                                }
                                else
                                {
                                    logradouro = "NULL";
                                }
                                if (txtxml.Contains("political"))
                                {
                                    if (txtxml.Contains("sublocality"))
                                    {
                                        if (txtxml.Contains("sublocality_level_1"))
                                        {
                                            bairro = ds.Tables["address_component"].Rows[2]["long_name"].ToString();
                                        }
                                        else
                                        {
                                            bairro = "NULL";
                                        }
                                    }
                                    else
                                    {
                                        bairro = "NULL";
                                    }
                                    if (txtxml.Contains("locality"))
                                    {
                                        cidade = ds.Tables["address_component"].Rows[3]["long_name"].ToString();
                                    }
                                    else
                                    {
                                        cidade = "NULL";
                                    }
                                    if (txtxml.Contains("administrative_area_level_1"))
                                    {
                                        estado = ds.Tables["address_component"].Rows[5]["long_name"].ToString();
                                    }
                                    else
                                    {
                                        estado = "NULL";
                                    }
                                    if (txtxml.Contains("country"))
                                    {
                                        pais = ds.Tables["address_component"].Rows[6]["long_name"].ToString();
                                    }
                                    else
                                    {
                                        pais = "NULL";
                                    }
                                }
                                else
                                {
                                    bairro = "NULL";
                                    cidade = "NULL";
                                    estado = "NULL";
                                    pais   = "NULL";
                                }

                                if (txtxml.Contains("postal_code"))
                                {
                                    cep = ds.Tables["address_component"].Rows[6]["long_name"].ToString();
                                }
                                else
                                {
                                    cep = "NULL";
                                }
                                if (txtxml.Contains("location"))
                                {
                                    lat = ds.Tables["location"].Rows[0]["lat"].ToString();
                                    lng = ds.Tables["location"].Rows[0]["lng"].ToString();
                                }
                                else
                                {
                                    lat = "NULL";
                                    lng = "NULL";
                                }
                                if (txtxml.Contains("location_type"))
                                {
                                    precisao = ds.Tables["geometry"].Rows[0]["location_type"].ToString();
                                }
                                else
                                {
                                    precisao = "NULL";
                                }
                            }
                            else
                            {
                                if (txtxml.Contains("street_number"))
                                {
                                    if (ds.Tables["address_component"].Rows[0][1].ToString().Contains("-"))
                                    {
                                        numero = validar.calcMedia(ds.Tables["address_component"].Rows[0]["long_name"].ToString().Split('-')).ToString();
                                    }
                                    else
                                    {
                                        numero = ds.Tables["address_component"].Rows[0]["long_name"].ToString();
                                    }
                                }
                                else
                                {
                                    numero = "NULL";
                                }
                                if (txtxml.Contains("route"))
                                {
                                    logradouro = ds.Tables["address_component"].Rows[1]["long_name"].ToString();
                                }
                                else
                                {
                                    logradouro = "NULL";
                                }
                                if (txtxml.Contains("political"))
                                {
                                    if (txtxml.Contains("sublocality"))
                                    {
                                        if (txtxml.Contains("sublocality_level_1"))
                                        {
                                            bairro = ds.Tables["address_component"].Rows[7]["long_name"].ToString();
                                        }
                                        else
                                        {
                                            bairro = "NULL";
                                        }
                                    }
                                    else
                                    {
                                        bairro = "NULL";
                                    }
                                    if (txtxml.Contains("locality"))
                                    {
                                        cidade = ds.Tables["address_component"].Rows[3]["long_name"].ToString();
                                    }
                                    else
                                    {
                                        cidade = "NULL";
                                    }
                                    if (txtxml.Contains("administrative_area_level_1"))
                                    {
                                        estado = ds.Tables["address_component"].Rows[4]["long_name"].ToString();
                                    }
                                    else
                                    {
                                        estado = "NULL";
                                    }
                                    if (txtxml.Contains("country"))
                                    {
                                        pais = ds.Tables["address_component"].Rows[5]["long_name"].ToString();
                                    }
                                    else
                                    {
                                        pais = "NULL";
                                    }
                                }
                                else
                                {
                                    bairro = "NULL";
                                    cidade = "NULL";
                                    estado = "NULL";
                                    pais   = "NULL";
                                }

                                if (txtxml.Contains("postal_code"))
                                {
                                    cep = ds.Tables["address_component"].Rows[6]["long_name"].ToString();
                                }
                                else
                                {
                                    cep = "NULL";
                                }
                                if (txtxml.Contains("location"))
                                {
                                    lat = ds.Tables["location"].Rows[0]["lat"].ToString();
                                    lng = ds.Tables["location"].Rows[0]["lng"].ToString();
                                }
                                else
                                {
                                    lat = "NULL";
                                    lng = "NULL";
                                }
                                if (txtxml.Contains("location_type"))
                                {
                                    precisao = ds.Tables["geometry"].Rows[0]["location_type"].ToString();
                                }
                                else
                                {
                                    precisao = "NULL";
                                }
                            }
                        }



                        row = new string[] { bairro, logradouro, numero, cidade, "NULL", cep, estado, pais, lat, lng, "Google", precisao, pk };
                    }
                    catch (Exception e)
                    {
                        string erro = e.Message;
                        row = new string[] { "Erro(0x00103):", "Erro de formatação", "Messagem original:" + erro, "", "", "", "", "", "", "", "", "", "" };
                    }
                }
                else
                {
                    row = new string[] { "Erro(0x00102):", "Não possui resultados", "Messagem original:" + ds.Tables["GeocodeResponse"].Rows[0]["status"].ToString(), "", "", "", "", "", "", "", "", "", "" };
                }


                break;

            case 2:

                if (ds.Tables["reversegeocode"].Rows[0][0].ToString() == "0")
                {
                    for (int j = 0; j < ds.Tables["result"].Rows.Count; j++)
                    {
                        //dsResult.Tables["addressparts"].Rows[0]["house_number"].ToString();//numero
                        //ds.Tables["addressparts"].Rows[0]["road"].ToString();//rua
                        //ds.Tables["addressparts"].Rows[0]["town"].ToString();//cidade
                        //ds.Tables["addressparts"].Rows[0]["county"].ToString();//bairro
                        //ds.Tables["addressparts"].Rows[0]["state"].ToString();//estado
                        //ds.Tables["addressparts"].Rows[0]["country"].ToString();//pais


                        row = new string[] { ds.Tables["addressparts"].Rows[0]["county"].ToString(), ds.Tables["addressparts"].Rows[0]["road"].ToString(), "NULL", ds.Tables["addressparts"].Rows[0]["town"].ToString(), "NULL", "NULL", ds.Tables["addressparts"].Rows[0]["state"].ToString(), ds.Tables["result"].Rows[j][4].ToString(), ds.Tables["result"].Rows[j][5].ToString(), "Nominatim", "", pk };
                    }
                }
                else
                {
                    row = new string[] { "Erro", "Não possui resultados", "", "", "", "", "", "", "", "", "", pk };
                }


                break;

            case 3:

                if (ds.Tables["Response"].Rows[0]["StatusDescription"].ToString() == "OK")
                {
                    if (ds.Tables["Address"].Rows[0]["AddressLine"].ToString().Contains(","))
                    {
                        logradouro = ds.Tables["Address"].Rows[0]["AddressLine"].ToString().Split(',')[0];
                        numero     = ds.Tables["Address"].Rows[0]["AddressLine"].ToString().Split(',')[1].Trim();
                    }
                    else
                    {
                        logradouro = ds.Tables["Address"].Rows[0]["AddressLine"].ToString();
                    }
                    row = new string[] { "NULL", logradouro, numero, ds.Tables["Address"].Rows[0]["Locality"].ToString(), "NULL", ds.Tables["Address"].Rows[0]["PostalCode"].ToString(), ds.Tables["Address"].Rows[0]["AdminDistrict"].ToString(), ds.Tables["Point"].Rows[0]["Latitude"].ToString(), ds.Tables["Point"].Rows[0]["Longitude"].ToString(), "Bing", ds.Tables["GeocodePoint"].Rows[0]["CalculationMethod"].ToString(), pk };
                }
                else
                {
                    row = new string[] { "Erro", "Não possui resultados", "", "", "", "", "", "", "", "", "", pk };
                }


                break;

            default:

                row = new string[] { "Erro", "Não possui resultados", "", "", "", "", "", "", "", "", "", pk };
                break;
            }



            return(row);
        }
コード例 #3
0
        public string [] resultJsonReversoGeo(string txtreturn, int fonte, string pk, string fk)
        {
            string numero      = "NULL";
            string logradouro  = "NULL";
            string bairro      = "NULL";
            string cidade      = "NULL";
            string estado      = "NULL";
            string pais        = "NULL";
            string cep         = "NULL";
            string lat         = "NULL";
            string lng         = "NULL";
            string precisao    = "NULL";
            string complemento = "NULL";

            string[] row = new string[13];
            dynamic  json;
            string   type = "";

            validar = new validacao();

            try
            {
                switch (fonte)
                {
                case 1:    //GOOGLE
                    json = JValue.Parse(txtreturn);
                    if (json.status == "OK")
                    {
                        precisao = json.results[0].geometry.location_type;
                        lat      = json.results[0].geometry.location.lat;
                        lng      = json.results[0].geometry.location.lng;
                        for (int i = 0; i < json.results.Count; i++)
                        {
                            for (int j = 0; j < json.results[i].address_components.Count; j++)
                            {
                                type = json.results[i].address_components[j].types[0];

                                if (type == "premise")
                                {
                                    complemento = json.results[i].address_components[j].long_name;
                                    complemento = "NULL";
                                }
                                else if (type == "street_number")
                                {
                                    numero = json.results[i].address_components[j].long_name;
                                    if (numero.Contains("-"))
                                    {
                                        numero = validar.calcMedia(numero.Split('-')).ToString();
                                    }

                                    numero = validar.removeCaracter(numero);
                                }
                                else if (type == "route")
                                {
                                    logradouro = json.results[i].address_components[j].long_name;
                                }
                                else if (type == "sublocality_level_1")
                                {
                                    bairro = json.results[i].address_components[j].long_name;
                                }
                                else if (type == "locality")
                                {
                                    cidade = json.results[i].address_components[j].long_name;
                                }
                                else if (type == "administrative_area_level_1")
                                {
                                    estado = json.results[i].address_components[j].long_name;
                                }
                                else if (type == "country")
                                {
                                    pais = json.results[i].address_components[j].long_name;
                                }
                                else if (type == "postal_code")
                                {
                                    cep = json.results[i].address_components[j].long_name;
                                }
                            }



                            if (numero != "NULL" && logradouro != "NULL" && bairro != "NULL" && cidade != "NULL" && estado != "NULL" && pais != "NULL" && cep != "NULL")     //se tudo completado break
                            {
                                break;
                            }
                        }

                        row = new string[] { bairro, logradouro, numero, cidade, complemento, cep, estado, pais, lat, lng, "Google", precisao, pk };
                    }
                    else    //fim status
                    {
                        row = new string[] { "Erro(0x00101):", "Erro de requisição", "Messagem original:" + json.status, "", "", "", "", "", "", "", "", "", pk };
                    }


                    break; //fim case 1

                case 2:    //nominatim
                    break;

                case 3:    //bing
                    json = JValue.Parse(txtreturn);
                    //DataSet ds = new DataSet();
                    // XmlDocument docxml = new XmlDocument();
                    // docxml.LoadXml(txtreturn);
                    // ds.ReadXml(new XmlNodeReader(docxml));
                    //if (ds.Tables["Response"].Rows[0]["StatusDescription"].ToString() == "OK")
                    //{
                    //    if (ds.Tables["Address"].Rows[0]["AddressLine"].ToString().Contains(","))
                    //    {
                    //        logradouro = ds.Tables["Address"].Rows[0]["AddressLine"].ToString().Split(',')[0];
                    //        numero = ds.Tables["Address"].Rows[0]["AddressLine"].ToString().Split(',')[1].Trim();
                    //    }
                    //    else
                    //    {
                    //        logradouro = ds.Tables["Address"].Rows[0]["AddressLine"].ToString();
                    //    }
                    //    row = new string[] { "NULL", logradouro, numero, ds.Tables["Address"].Rows[0]["Locality"].ToString(), "NULL", ds.Tables["Address"].Rows[0]["PostalCode"].ToString(), ds.Tables["Address"].Rows[0]["AdminDistrict"].ToString(),"Brasil",ds.Tables["Point"].Rows[0]["Latitude"].ToString(), ds.Tables["Point"].Rows[0]["Longitude"].ToString(), "Bing", ds.Tables["GeocodePoint"].Rows[0]["CalculationMethod"].ToString(), pk };
                    //}
                    //else
                    //{
                    //    row = new string[] { "Erro", "Não possui resultados", "", "", "", "", "", "", "", "", "", pk };
                    //}

                    if (json.statusDescription == "OK")
                    {
                        //precisao = json.results[0].geometry.location_type;
                        //lat = json.results[0].geometry.location.lat;
                        //lng = json.results[0].geometry.location.lng;


                        for (int i = 0; i < json.resourceSets.Count; i++)
                        {
                            for (int j = 0; j < json.resourceSets[i].resources.Count; j++)
                            {
                                dynamic teste1 = json.resourceSets[i].resources[j].o.SelectToken("$.Manufacturers[?(@.Name == 'address')]");
                                dynamic teste2 = json.resourceSets[i].resources.Children()["address"];
                                dynamic teste3 = json.resourceSets[i].resources.SelectToken("address");
                                dynamic teste  = json.resourceSets[i].resources.Contains("address");



                                type = json.resourceSets[i].resources[j].address.addressLine;   //////address line
                                if (type != "null" && type != "NULL" || type != "")
                                {
                                    if (logradouro == "NULL" || numero == "NULL")
                                    {
                                        if (type.Contains(","))
                                        {
                                            logradouro = type.Split(',')[0];
                                            numero     = type.Split(',')[1];
                                        }
                                        else if (type.Contains('-'))
                                        {
                                        }
                                        else
                                        {
                                            logradouro = type;
                                        }
                                    }
                                }
                                //////////////////////////fim addres line

                                estado = json.resourceSets[i].resources[j].address.adminDistrict; //estado

                                pais = json.resourceSets[i].resources[j].address.countryRegion;   //pais

                                cep = json.resourceSets[i].resources[j].address.postalCode;       //cep

                                cidade = json.resourceSets[i].resources[j].address.locality;      //cidade

                                type = json.resourceSets[i].resources[j].geocodePoints[0].type;
                                if (type == "Point")
                                {
                                    lat      = json.resourceSets[i].resources[j].geocodePoints[0].coordinates[0];
                                    lng      = json.resourceSets[i].resources[j].geocodePoints[0].coordinates[1];
                                    precisao = json.resourceSets[i].resources[j].geocodePoints[0].calculationMethod;
                                }
                            }
                            if (numero != "NULL" && logradouro != "NULL" && bairro != "NULL" && cidade != "NULL" && estado != "NULL" && pais != "NULL" && cep != "NULL" && complemento != "NULL")    //se tudo completado break
                            {
                                break;
                            }
                        }


                        row = new string[] { bairro, logradouro, numero, cidade, complemento, cep, estado, pais, lat, lng, "Bing", precisao, pk };
                    }
                    else    //fim status
                    {
                        row = new string[] { "Erro(0x00101):", "Erro de requisição", "Messagem original:" + json.status, "", "", "", "", "", "", "", "", "", pk };
                    }


                    break;

                default:

                    row = new string[] { "Erro", "Fonte não encontrada", "", "", "", "", "", "", "", "", "", pk };
                    break;
                }



                return(row);
            }
            catch (Exception ex)
            {
                string erro = ex.Message;
                return(row = new string[] { "Erro(0x00103):", "Erro de formatação", "Messagem original:" + erro, "", "", "", "", "", "", "", "", "", pk });
            }
        }