using Fuel01;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Convert
{
    public static class Program
    {
        private static string Folder { get;  set; } 
        static void Main(string[] args)
        {
            Folder = Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData) + @"\AsoFuel";
            DataSet1.tb_epreuveDataTable tb_epr = new DataSet1.tb_epreuveDataTable();

            tb_epr.Clear();
            tb_epr.ReadXml(Path.Combine(Folder,"epreuve.xml"));
            SaveToJson<DataSet1.tb_epreuveDataTable>(Path.Combine(Folder, "epreuve.json"), tb_epr);

            foreach (var item in tb_epr.Rows) 
            {
                DataSet1.tb_epreuveRow myrow = item as DataSet1.tb_epreuveRow;
                string key_epr = myrow["key_epr"].ToString();
                Console.WriteLine(key_epr);
                DataSet1.tb_stationDataTable tb_sta = new DataSet1.tb_stationDataTable();
                tb_sta.Clear();
                tb_sta.ReadXml(Path.Combine(Folder, key_epr,"station.xml"));
                SaveToJson<DataSet1.tb_stationDataTable>(Path.Combine(Folder, key_epr, "station.json"), tb_sta);

                DataSet1.tb_vehiDataTable tb_vehi = new DataSet1.tb_vehiDataTable();
                tb_vehi.Clear();
                tb_vehi.ReadXml(Path.Combine(Folder, key_epr, "vehicule.xml"));
                SaveToJson<DataSet1.tb_vehiDataTable>(Path.Combine(Folder, key_epr, "vehicule.json"), tb_vehi);

                DataSet1.tb_prestaDataTable tb_presta = new DataSet1.tb_prestaDataTable();
                tb_presta.Clear();
                tb_presta.ReadXml(Path.Combine(Folder, key_epr, "presta_base.xml"));
                SaveToJson<DataSet1.tb_prestaDataTable>(Path.Combine(Folder, key_epr, "presta_base.json"), tb_presta);

                tb_presta.Clear();
                tb_presta.ReadXml(Path.Combine(Folder, key_epr, "presta.xml"));
                SaveToJson<DataSet1.tb_prestaDataTable>(Path.Combine(Folder, key_epr, "presta.json"), tb_presta);

                DataSet1.tb_venteDataTable tb_vente = new DataSet1.tb_venteDataTable();
                tb_vente.Clear();
                tb_vente.ReadXml(Path.Combine(Folder, key_epr, "vente.xml"));
                SaveToJson<DataSet1.tb_venteDataTable>(Path.Combine(Folder, key_epr, "vente.json"), tb_vente);

            }                                                               

        }

        public static bool SaveToJson<T>(string filename, T ds)                                                                                                                                                                                                                                 
        {
            try
            {
                var result = JsonConvert.SerializeObject(ds);
                File.WriteAllText(filename, result);
                return true;
            }
            catch
            {
                return false;
            }
        }
    }
}