using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace csvTojSon
{
    public partial class frmMain : Form
    {
        protected char DefaultSeparatorChar = ';';
        protected Types.GeocoderLocation location = new Types.GeocoderLocation();

        public frmMain()
        {
            InitializeComponent();
        }

        private void frmMain_Load(object sender, EventArgs e)
        {
            System.Collections.Specialized.NameValueCollection nvc = System.Configuration.ConfigurationManager.AppSettings;
            cfgSettings.apiKeyBingMaps = (nvc.AllKeys.Contains("apiKeyBingMaps") ? nvc["apiKeyBingMaps"] : string.Empty);
            cfgSettings.bingMapsApiUrl = (nvc.AllKeys.Contains("bingMapsApiUrl") ? nvc["bingMapsApiUrl"] : string.Empty);
            cfgSettings.fileScarti = (nvc.AllKeys.Contains("fileScarti") ? nvc["fileScarti"] : string.Empty);
            cfgSettings.xmlNameSpace = (nvc.AllKeys.Contains("xmlNameSpace") ? nvc["xmlNameSpace"] : string.Empty);
        }

        private void btnSource_Click(object sender, EventArgs e)
        {
            OpenFileDialog dlg = new OpenFileDialog()
            {
                InitialDirectory = System.IO.Directory.GetCurrentDirectory(),
                Title = "File da leggere",
                DefaultExt = "csv",
                Filter = "Files csv (*.csv)|*.csv|Tutti i file (*.*)|*.*",
                FileName = txtSourceFile.Text,
                RestoreDirectory = true
            };
            if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                txtSourceFile.Text = dlg.FileName;
            }
        }

        private void btnDestination_Click(object sender, EventArgs e)
        {
            SaveFileDialog dlg = new SaveFileDialog()
            {
                InitialDirectory = System.IO.Directory.GetCurrentDirectory(),
                Title = "File da produrre",
                DefaultExt = "json",
                Filter = "Files jSon (*.jSon)|*.jSon|Tutti i file (*.*)|*.*",
                FileName = txtDestionationFile.Text,
                RestoreDirectory = true
            };
            if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                txtDestionationFile.Text = dlg.FileName;
            }
        }

        private void btnOk_Click(object sender, EventArgs e)
        {
            if (txtSourceFile.Text.Trim().Length == 0)
            {
                MessageBox.Show("Specificare il percorso del file da leggere.", "Attenzione!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            if (txtDestionationFile.Text.Trim().Length == 0)
            {
                MessageBox.Show("Specificare il percorso del file da produrre.", "Attenzione!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            // Attesa
            Cursor.Current = Cursors.WaitCursor;

            try
            {
                string[] lines = System.IO.File.ReadAllLines(txtSourceFile.Text);

                int rigaInizio = 0;

                DataTable dt = new DataTable("Mizar");

                System.Type CSVType = typeof(Types.CSV.Record);
                System.Reflection.FieldInfo[] CSVFieldInfos = CSVType.GetFields();

                if (chkFirstRowCol.Checked)
                {
                    string[] columns = lines[rigaInizio].Split(new char[] { DefaultSeparatorChar }, StringSplitOptions.RemoveEmptyEntries);
                    foreach (string column in columns)
                    {
                        DataColumn dc = new DataColumn(column.Trim()) { AllowDBNull = false, DataType = typeof(string), DefaultValue = string.Empty };
                        dt.Columns.Add(dc);
                    }
                    rigaInizio++;
                }

                if (dt.Columns.Count == 0)
                {
                    foreach (System.Reflection.FieldInfo info in CSVFieldInfos)
                    {
                        DataColumn dc = new DataColumn(info.Name.Trim()) { AllowDBNull = false, DataType = info.FieldType, DefaultValue = string.Empty };
                        dt.Columns.Add(dc);
                    }
                }

                for (int i = rigaInizio; i <= lines.Length - 1; i++)
                {
                    string[] fields = lines[i].ToUTF8().Split(new char[] { DefaultSeparatorChar }, StringSplitOptions.RemoveEmptyEntries);
                    DataRow dr = dt.NewRow();
                    dr.ItemArray = fields;
                    dt.Rows.Add(dr);
                }

                Types.CSV commaFile = new Types.CSV();
                commaFile.root = new Types.CSV.Root();
                commaFile.root.results = new Types.CSV.Record[dt.Rows.Count];

                System.Collections.Specialized.NameValueCollection nvc = System.Configuration.ConfigurationManager.AppSettings;
                cfgSettings.fileScarti = (nvc.AllKeys.Contains("fileScarti") ? nvc["fileScarti"] : string.Empty);

                string fileOk = System.IO.Path.Combine(System.IO.Path.GetDirectoryName(txtDestionationFile.Text), System.IO.Path.GetFileNameWithoutExtension(txtDestionationFile.Text) + ".txt");

                int righeOK = 0, righeKO = 0;

                for (int riga = 0; riga <= dt.Rows.Count - 1; riga++)
                {
                    DataRow dr = dt.Rows[riga];
                    commaFile.root.results[riga] = new Types.CSV.Record();
                    commaFile.root.results[riga].cod_cap = dr["cod_cap"].ToString().Trim();
                    commaFile.root.results[riga].cod_provincia = dr["cod_provincia"].ToString().Trim();
                    commaFile.root.results[riga].codice_sede = dr["codice_sede"].ToString().Trim();
                    commaFile.root.results[riga].den_indirizzo = dr["den_indirizzo"].ToString().Trim();
                    commaFile.root.results[riga].den_istituzione = dr["den_istituzione"].ToString().Trim();
                    commaFile.root.results[riga].den_localita = dr["den_localita"].ToString().Trim();
                    commaFile.root.results[riga].den_ragione_sociale = dr["den_ragione_sociale"].ToString().Trim();

                    //Normalizzazione
                    commaFile.root.results[riga].cod_cap = (commaFile.root.results[riga].cod_cap != "NULL" ? commaFile.root.results[riga].cod_cap.PadLeft(5, '0') : "");
                    commaFile.root.results[riga].den_indirizzo = commaFile.root.results[riga].den_indirizzo.Replace("SNC", "");

                    //Composizione richiesta
                    // Via G. Mechelli, Lariano, 00040 RM
                    string query = commaFile.root.results[riga].den_indirizzo + ", " + commaFile.root.results[riga].den_localita + ", " + (string.IsNullOrEmpty(commaFile.root.results[riga].cod_cap) ? "" : commaFile.root.results[riga].cod_cap) + " " + commaFile.root.results[riga].cod_provincia;

                    location = Types.RecuperaCoordinate(query);
                    if (location != null)
                    {
                        commaFile.root.results[riga].latitudine = location.Latitude;
                        commaFile.root.results[riga].longitudine = location.Longitude;
                        righeOK++;
                        System.IO.File.AppendAllText(fileOk, "Coordinate trovate (" + righeOK + " su " + (riga + 1) + ") per " + query + " -> lat. " + location.Latitude.ToString("#0.0000000") + ", long. " + location.Longitude.ToString("#0.0000000") + "\r\n");
                    }
                    else
                    {
                        righeKO++;
                        string msg = "Coordinate non trovate (" + righeKO + " su " + (riga + 1) + ") per " + query + "\r\n";
                        if (cfgSettings.fileScarti.Trim() != "")
                        {
                            System.IO.File.AppendAllText(cfgSettings.fileScarti, msg);
                        }
                        else
                        {
                            Console.WriteLine(msg);
                        }
                    }
                    if (riga % 5 == 0)
                    {
                        System.Threading.Thread.Sleep(1000);
                    }
                }

                // Normale
                Cursor.Current = Cursors.Default;

                string jSonData = commaFile.root.ToJSON<Types.CSV.Root>();

                System.IO.File.WriteAllText(txtDestionationFile.Text, jSonData);

                MessageBox.Show("Salvataggio file di destinazione completata correttamente.", "csvTojSon", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Errore!", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
    }
}