using CSFrameworkV5.Core.Common;
using Microsoft.Win32;
///*************************************************************************/
///*
///* 文件名    ：SqlConfigWriter.cs                                
///* 程序说明  : SQL连接配置存储策略
///* 原创作者  ：孙中吕 
///* 
///* Copyright 2006-2017 C/S框架网 www.csframework.com
///*
///**************************************************************************/
using System;

namespace CSFrameworkV5.Core
{
    /// <summary>
    /// 从INI文件读取SQL连接配置
    /// </summary>
    public class IniFileWriter : IWriteSQLConfigValue
    {
        private string _iniFile;

        /// <summary>
        /// 构造器
        /// </summary>
        /// <param name="iniFile">INI文件</param>
        public IniFileWriter(string iniFile)
        {
            _iniFile = iniFile;
            if (!System.IO.File.Exists(iniFile)) Write();
            Read();
        }

        public string DatabaseType { get; set; }

        public string ConnectionString { get; set; }

        public string ServerName { get; set; }

        public int Port { get; set; }

        public string DatabaseName { get; set; }

        public string UserName { get; set; }

        public string Password { get; set; }

        /// <summary>
        /// 读取配置
        /// </summary>
        public void Read()
        {
            var cfg = new IniFile(_iniFile);
            ConnectionString = KeyProvider.Default.Decrypt(
                cfg.IniReadValue("Connection Settings", "SystemConnection",
                    ""));
            DatabaseType =
                cfg.IniReadValue("Connection Settings", "DatabaseType");
            ServerName = cfg.IniReadValue("Connection Settings", "ServerName");
            Port = ConvertEx.ToInt(cfg.IniReadValue("Connection Settings",
                "Port"));
            DatabaseName =
                cfg.IniReadValue("Connection Settings", "DatabaseName");
            UserName = cfg.IniReadValue("Connection Settings", "UserName");
            Password = KeyProvider.Default.Decrypt(
                cfg.IniReadValue("Connection Settings", "Password", ""));
        }

        /// <summary>
        /// 将配置写入INI文件
        /// </summary>
        public void Write()
        {
            var cfg = new IniFile(_iniFile);
            if (cfg != null)
            {
                cfg.IniWriteValue("Connection Settings", "SystemConnection",
                    KeyProvider.Default.Encrypt(ConnectionString));
                cfg.IniWriteValue("Connection Settings", "DatabaseType",
                    DatabaseType.ToStringEx());
                cfg.IniWriteValue("Connection Settings", "ServerName",
                    ServerName.ToStringEx());
                cfg.IniWriteValue("Connection Settings", "Port",
                    Port.ToStringEx());
                cfg.IniWriteValue("Connection Settings", "DatabaseName",
                    DatabaseName.ToStringEx());
                cfg.IniWriteValue("Connection Settings", "UserName",
                    UserName.ToStringEx());
                cfg.IniWriteValue("Connection Settings", "Password",
                    KeyProvider.Default.Encrypt(Password));
            }
        }

        /// <summary>
        /// 加载连接配置
        /// </summary>
        /// <param name="ConfigFile">配置文件</param>
        public static IWriteSQLConfigValue LoadConfiguration(string ConfigFile)
        {
            if (System.IO.File.Exists(ConfigFile))
            {
                IWriteSQLConfigValue cfg = new IniFileWriter(ConfigFile);
                return cfg;
            }
            else
            {
                throw new Exception(
                    "Program cann't run without a SQL configuration.You should config the SQL connection by running CSFramework.Tools.SqlConnector.exe!");
            }
        }
    }

    /// <summary>
    /// 从系统注册表读取SQL连接配置
    /// </summary>
    public class RegisterWriter : IWriteSQLConfigValue
    {
        private string _keyPath;

        /// <summary>
        /// 构造器
        /// </summary>
        /// <param name="keyPath">注册表位置</param>
        public RegisterWriter(string keyPath)
        {
            _keyPath = keyPath;
            Read();
        }

        public string ServerName { get; set; }

        public string DatabaseName { get; set; }

        public int Port { get; set; }

        public string UserName { get; set; }

        public string Password { get; set; }

        public string DatabaseType { get; set; }

        public string ConnectionString { get; set; }

        /// <summary>
        /// 读取配置
        /// </summary>
        public void Read()
        {
            var key = Registry.LocalMachine.CreateSubKey(_keyPath);

            if (key != null)
            {
                ConnectionString = KeyProvider.Default.Decrypt(
                    ConvertEx.ToString(key.GetValue("ConnectionString", "")));
                DatabaseType =
                    ConvertEx.ToString(key.GetValue("DatabaseType", ""));
                ServerName = ConvertEx.ToString(key.GetValue("ServerName", ""));
                Port = ConvertEx.ToInt(key.GetValue("Port", ""));
                DatabaseName =
                    ConvertEx.ToString(key.GetValue("DatabaseName", ""));
                UserName = ConvertEx.ToString(key.GetValue("UserName", ""));
                Password =
                    KeyProvider.Default.Decrypt(
                        ConvertEx.ToString(key.GetValue("Password", "")));
                key.Close();
            }
        }

        /// <summary>
        /// 写入配置
        /// </summary>
        public void Write()
        {
            var key = Registry.LocalMachine.CreateSubKey(_keyPath);
            if (key != null)
            {
                key.SetValue("ConnectionString",
                    KeyProvider.Default.Encrypt(ConnectionString));
                key.SetValue("DatabaseType", DatabaseType);
                key.SetValue("ServerName", ServerName);
                key.SetValue("Port", Port);
                key.SetValue("DatabaseName", DatabaseName);
                key.SetValue("UserName", UserName);
                key.SetValue("Password", KeyProvider.Default.Encrypt(Password));
                key.Close();
            }
        }
    }

    /// <summary>
    /// 从web.config文件读取SQL连接配置
    /// </summary>
    public class WebConfigCfg : IWriteSQLConfigValue
    {
        public WebConfigCfg(string databaseType, string connectionString)
        {
            ConnectionString = connectionString;
            DatabaseType = databaseType;
        }

        public void Write()
        {
            //
        }

        public void Read()
        {
            //
        }

        public string ServerName { get; set; }

        public string DatabaseName { get; set; }

        public int Port { get; set; }

        public string UserName { get; set; }

        public string Password { get; set; }

        public string DatabaseType { get; set; }

        public string ConnectionString { get; set; }
    }
}