using GoogleMaps.LocationServices;

using System;

using System.Collections.Generic;

using System.IO;

using System.Linq;

using System.Net;

using System.Text;

using System.Threading.Tasks;

using System.Xml;

using System.Xml.Linq;

​

namespace TestGeolocations

{

    class Program

    {

        static void Main(string[] args)

        {

            // parse address from xml to txt

            XNamespace ns = "urn:schemas-microsoft-com:office:excel";

            var xdoc = XDocument.Load(@"c:\users\gsiradze\documents\visual studio 2013\Projects\TestGeolocations\TestGeolocations\loc.xml");

            IEnumerable<string> ss = xdoc.Descendants(ns + "Crn").Select(x => x.Elements(ns + "Text").Reverse().Skip(1).Take(1).DefaultIfEmpty()).SelectMany(x => x).Select(x => (string)x);

            using (System.IO.StreamWriter file = new System.IO.StreamWriter(@"c:\users\gsiradze\documents\visual studio 2013\Projects\TestGeolocations\TestGeolocations\texts.txt", true))

            {

                foreach (var x in ss)

                {

                    file.WriteLine(x);

                }

            }

​

            //check in google map

            foreach (string line in File.ReadLines(@"C:\Users\gsiradze\documents\visual studio 2013\Projects\TestGeolocations\TestGeolocations\texts.txt"))

            {

                var locationService = new GoogleLocationService();

                var point = locationService.GetLatLongFromAddress(line);

                if (point != null)

                {

                    var latitude = point.Latitude;

                    var longitude = point.Longitude;

                }

                else

                {

                    using (System.IO.StreamWriter file = new System.IO.StreamWriter(@"C:\Users\gsiradze\documents\visual studio 2013\Projects\TestGeolocations\TestGeolocations\wrongAddr.txt", true))

                    {

                        file.WriteLine(line);

                    }

                }

            }

        }

    }

}