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

namespace Sony.Filtr.Bootstrap
{
    public class BootstrapperSettings
    {
        public Dictionary<string, string> GetSettings()
        {
            var dbSettings = GetDatabaseSettings();
            var configOverrides = ConfigurationManager.AppSettings;
            Dictionary<string, string> 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;
        }
    }
}