using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using Microsoft.Extensions.Configuration;
using Sony.Filtr.Database;

namespace Sony.Filtr.Bootstrap
{
    public class BootstrapperSettings
    {
        private IConfigurationRoot _config;
        public BootstrapperSettings(IConfigurationRoot config) 
        {
            _config = config;
        }
        public Dictionary<string, string> GetSettings()
        {
            var dbSettings = GetDatabaseSettings();
            var configOverrides = _config.GetSection("appSettings")?.GetChildren()?.ToDictionary(x => x.Key, x => x.Value);
            Dictionary<string, string> joinedSettings = new Dictionary<string, string>();
            if (configOverrides != null)
            {
                joinedSettings = configOverrides.Keys.Cast<string>().ToDictionary(configOverrideKey => configOverrideKey, configOverrideKey => configOverrides[configOverrideKey]);
            }
            
            foreach (var dbSetting in dbSettings)
            {
                if (!joinedSettings.ContainsKey(dbSetting.Key))
                    joinedSettings.Add(dbSetting.Key, dbSetting.Value);
            }

            return joinedSettings;
            
        }

        private Dictionary<string, string> GetDatabaseSettings()
        {
            Dictionary<string, string> settings = new Dictionary<string, string>();
            using (var connection = DatabaseHandler.GetOpenReadOnlyConnection())
            {
                var cmd = connection.CreateCommand();
                cmd.CommandText = "SELECT strKey, strValue FROM tblBootstrap";
                var reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    settings.Add(reader.GetString(0), reader.GetString(1));
                }
            }
            return settings;
        }
    }
}