//using Hydro.CommonBase.Properties;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SQLite;
using System.IO;

namespace Hydro.CommonBase
{
    public class Db1
    {
        static string path=null;
        static Stack<string> stack = new Stack<string>();
        static Db1()
        {
            
        }
        public static void Init(string path0=null)
        {
            path = path0;
            if (path == null)
                path = AppDomain.CurrentDomain.BaseDirectory + "config.wdb";

            //检查数据库是否存在，不在则新建
            //if (!File.Exists(path))
            //    File.WriteAllBytes(path, Resources.Db);

            //初始化数据库连接串
            Connection = new SQLiteConnection($"Data Source={path};Pooling=true;FailIfMissing=false");
            Connection.Open();
        }
       
        public static  IDbConnection Connection;
        public static void Save()
        {
            if (!Directory.Exists("backup"))
            {
                Directory.CreateDirectory("backup");
            }

            string backupPath = $"backup/{Path.GetFileName(path)}.{DateTime.Now:yyyy-MM-dd_HH-mm-ss}.bak";
            FileCopy.Copy(path, backupPath);
            stack.Push(backupPath);
        }

        public static void Undo()
        {
            if (CanUndo())
            {
                Save();
                string lastBackupPath = stack.Pop();
                FileCopy.Copy(lastBackupPath, path, true);
            }
        }

        public static void Redo()
        {
            if (CanRedo())
            {
                Save();
                string nextBackupPath = stack.Pop();
                FileCopy.Copy(nextBackupPath, path, true);
            }
        }

        public static bool CanUndo()
        {
            return stack.Count > 0;
        }

        public static bool CanRedo()
        {
            return stack.Count > 1;
        }

        public static void ClearBackup()
        {
            if (Directory.Exists("backup"))
            {
                Directory.Delete("backup", true);
            }

            stack.Clear();
        }
    }



    public class Db
    {
        public static Db Instance;
        public string GetPath()
        {  return path;  }
        string path = null;
        Stack<string> stack = new Stack<string>();
        public Db()
        {

        }
        public void Init(string path0 = null)
        {
            path = path0;
            if (path == null)
                path = AppDomain.CurrentDomain.BaseDirectory + "config.wdb";
            if (GlobalPath.Path==null )
            {
                FileInfo fileInfo = new FileInfo(path);
                GlobalPath.Path = fileInfo.DirectoryName;
                
            }
            
            
            //检查数据库是否存在，不在则新建
            //if (!File.Exists(path))
            //    File.WriteAllBytes(path, Resources.Db);

            // 移除只读属性
            FileAttributes attributes = File.GetAttributes(path);
            attributes &= ~FileAttributes.ReadOnly;
            File.SetAttributes(path, attributes);

            //初始化数据库连接串
            Connection = new SQLiteConnection($"Data Source={path};Pooling=true;FailIfMissing=false");
            Connection.Open();
        }
        public static void CreateNewConfig(string path0)
        {


            //File.WriteAllBytes(path0, Resources.Db);

        }
        public void Close()
        {
            if (Connection!=null)
                this.Connection.Close();
        }
        public  IDbConnection Connection;
        public  void Save()
        {
            if (!Directory.Exists("backup"))
            {
                Directory.CreateDirectory("backup");
            }

            string backupPath = $"backup/{Path.GetFileName(path)}.{DateTime.Now:yyyy-MM-dd_HH-mm-ss}.bak";
            FileCopy.Copy(path, backupPath);
            stack.Push(backupPath);
        }

        public  void Undo()
        {
            if (CanUndo())
            {
                Save();
                string lastBackupPath = stack.Pop();
                FileCopy.Copy(lastBackupPath, path, true);
            }
        }

        public  void Redo()
        {
            if (CanRedo())
            {
                Save();
                string nextBackupPath = stack.Pop();
                FileCopy.Copy(nextBackupPath, path, true);
            }
        }

        public  bool CanUndo()
        {
            return stack.Count > 0;
        }

        public  bool CanRedo()
        {
            return stack.Count > 1;
        }

        public  void ClearBackup()
        {
            if (Directory.Exists("backup"))
            {
                Directory.Delete("backup", true);
            }

            stack.Clear();
        }
    }
}