Form1.cs

using System;
using System.Drawing;
using System.Globalization;
using System.IO;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;
using Microsoft.Data.Sqlite;

namespace pomidor
{
    public partial class Form1 : Form
    {
        readonly System.Windows.Forms.Timer timerx = new System.Windows.Forms.Timer();
        int year = DateTimeOffset.Now.Year;
        long startTime = 0;
        long stopTime = 0;
        long pauseMoment = 0;
        long focus_time = 25;
        long break_time = 5;
        long long_break_time = 15;
        int long_break_n = 4;
        string f1_sound = "";
        string f2_sound = "";
        string b_sound = "";
        string lb_sound = "";
        string pl_folder = "playlist";
        bool ofs_timer = true;
        bool lb_logic = false;
        bool pl_status = false;
        bool pl_repeat = true;
        bool pl_break = true;
        bool pl_paused = false;
        private bool _timer_work = false;
        private bool _timer_pause = false;
        private short _timer_type = 0;
        readonly WMPLib.WindowsMediaPlayer wplayer = new WMPLib.WindowsMediaPlayer();
        readonly WMPLib.WindowsMediaPlayer pl_main = new WMPLib.WindowsMediaPlayer();
        public Form1()
        {
            InitializeComponent();
            SetDoubleBuffered(tableLayoutPanel1);
            SetDoubleBuffered(tabPage1);
            SetDoubleBuffered(tabPage2);
            SetDoubleBuffered(panel1);
            SetDoubleBuffered(panel3);
            SetDoubleBuffered(groupBox2);
            SetDoubleBuffered(groupBox3);
            SetDoubleBuffered(groupBox4);
            timerx.Interval = 1000;

            tableLayoutPanel1.SuspendLayout();
            for (int i = 0; i < 53; i++)
            {
                for (int j = 0; j < 7; j++)
                {
                    PictureBox pB = new PictureBox
                    {
                        Size = MaximumSize,
                        Dock = DockStyle.Fill,
                        SizeMode = PictureBoxSizeMode.StretchImage
                    };
                    pB.BackColor = System.Drawing.Color.Transparent;
                    pB.Paint += pictureBox1_Paint_1;
                    pB.Margin = new Padding(0);
                    tableLayoutPanel1.Controls.Add(pB, i, j);
                }
            }
            tableLayoutPanel1.ResumeLayout();


            this.ShowInTaskbar = false;
            this.WindowState = FormWindowState.Minimized;
            this.Visible = false;


            this.notifyIcon1.ContextMenuStrip = new System.Windows.Forms.ContextMenuStrip();
            this.notifyIcon1.ContextMenuStrip.Items.Add("Приостановить таймер", null, this.PauseClick);
            this.notifyIcon1.ContextMenuStrip.Items.Add("Остановить таймер", null, this.StopClick);
            this.notifyIcon1.ContextMenuStrip.Items.Add("Перезапустить...", null);
            this.notifyIcon1.ContextMenuStrip.Items.Add("Запустить фокусировку", null, this.StartFocus);
            this.notifyIcon1.ContextMenuStrip.Items.Add("Запустить перерыв", null, this.StartBreak);
            this.notifyIcon1.ContextMenuStrip.Items.Add("Запустить длинный перерыв", null, this.StartLongBreak);
            this.notifyIcon1.ContextMenuStrip.Items.Add("Настройки", null, this.OpenSettings);
            this.notifyIcon1.ContextMenuStrip.Items.Add("Импорт данных", null, this.ImportDataBase);
            this.notifyIcon1.ContextMenuStrip.Items.Add("Выйти", null, this.ExitApp);
            (this.notifyIcon1.ContextMenuStrip.Items[2] as ToolStripMenuItem).DropDownItems.Add("Запустить фокусировку", null, this.StartFocus);
            (this.notifyIcon1.ContextMenuStrip.Items[2] as ToolStripMenuItem).DropDownItems.Add("Запустить перерыв", null, this.StartBreak);
            (this.notifyIcon1.ContextMenuStrip.Items[2] as ToolStripMenuItem).DropDownItems.Add("Запустить длинный перерыв", null, this.StartLongBreak);

            DirectoryInfo di = new DirectoryInfo("playlist\\");
            di.Create();
            di = new DirectoryInfo("sounds\\");
            di.Create();
            var f = Directory.GetFiles("sounds\\", "*.mp3");
            foreach (string f2 in f)
            {
                var temp = f2.Split('\\')[1].Split('.')[0];
                this.comboBox1.Items.Add(temp);
                this.comboBox2.Items.Add(temp);
                this.comboBox3.Items.Add(temp);
                this.comboBox4.Items.Add(temp);
            }





            TimersHide();


            if (!System.IO.File.Exists("userdata.db"))
            {
                using (var connection = new SqliteConnection("Data Source=userdata.db;Mode=ReadWriteCreate"))
                {
                    connection.Open();
                    SqliteCommand command = new SqliteCommand
                    {
                        Connection = connection
                    };
                    var SQL = "CREATE TABLE \"timers\" (\"date\"  INTEGER NOT NULL,\"type\"  INTEGER NOT NULL,\"id\"    INTEGER NOT NULL UNIQUE,\"length\"    INTEGER NOT NULL,\"start\" INTEGER NOT NULL,\"end\"   INTEGER NOT NULL,PRIMARY KEY(\"id\" AUTOINCREMENT))";
                    command.CommandText = SQL;
                    _ = command.ExecuteNonQuery();
                    SQL = "CREATE TABLE \"user_pref\" (" +
                        "\"id\"    INTEGER NOT NULL," +
                        "\"focus_time\"    INTEGER NOT NULL DEFAULT 25," +
                        "\"break_time\"    INTEGER NOT NULL DEFAULT 5," +
                        "\"lbreak_time\"   INTEGER NOT NULL DEFAULT 15," +
                        "\"before_lbreak\" INTEGER NOT NULL DEFAULT 4," +
                        "\"f1_sound\"  TEXT DEFAULT \'нет\'," +
                        "\"f2_sound\"  TEXT DEFAULT \'нет\'," +
                        "\"b_sound\"   TEXT DEFAULT \'нет\'," +
                        "\"lb_sound\"  TEXT DEFAULT \'нет\', " +
                        "\"nort_timer\"  INTEGER DEFAULT 1, " +
                        "\"nort_lb_logic\"  INTEGER DEFAULT 0," +
                        "\"pl_status\"  INTEGER DEFAULT 0," +
                        "\"pl_repeat\"  INTEGER DEFAULT 1," +
                        "\"pl_break\"  INTEGER DEFAULT 1," +
                        "\"pl_folder\"  TEXT DEFAULT 'playlist'" +
                        ")";
                    command.CommandText = SQL;
                    _ = command.ExecuteNonQuery();
                    SQL = "INSERT INTO user_pref(id) VALUES(0)";
                    command.CommandText = SQL;
                    _ = command.ExecuteNonQuery();
                    connection.Close();
                }
            }
            fixDataBase();
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;
                command.CommandText = "SELECT * FROM user_pref";
                using (SqliteDataReader reader = command.ExecuteReader())
                {
                    if (reader.HasRows) // если есть данные
                    {
                        while (reader.Read())
                        {
                            object id = reader[0];
                            focus_time = (long)reader.GetValue(1);
                            break_time = (long)reader.GetValue(2);
                            long_break_time = (long)reader.GetValue(3);
                            long_break_n = Convert.ToInt32(reader.GetValue(4));
                            f1_sound = Convert.ToString(reader.GetValue(5));
                            f2_sound = Convert.ToString(reader.GetValue(6));
                            b_sound = Convert.ToString(reader.GetValue(7));
                            lb_sound = Convert.ToString(reader.GetValue(8));
                            ofs_timer = Convert.ToBoolean(reader.GetValue(9));
                            lb_logic = Convert.ToBoolean(reader.GetValue(10));
                            pl_status = Convert.ToBoolean(reader.GetValue(11));
                            pl_repeat = Convert.ToBoolean(reader.GetValue(12));
                            pl_break = Convert.ToBoolean(reader.GetValue(13));
                            pl_folder = Convert.ToString(reader.GetValue(14));

                            if (pl_status && this.notifyIcon1.ContextMenuStrip.Items[this.notifyIcon1.ContextMenuStrip.Items.Count - 2].Text != "Следующий трек")
                            {
                                this.notifyIcon1.ContextMenuStrip.Items.Insert(this.notifyIcon1.ContextMenuStrip.Items.Count - 1, new ToolStripMenuItem("Приостановить плеер", null, pl_pause));
                                this.notifyIcon1.ContextMenuStrip.Items.Insert(this.notifyIcon1.ContextMenuStrip.Items.Count - 1, new ToolStripMenuItem("Следующий трек", null, pl_nextTrack));
                            }
                        }
                    }
                }
                connection.Close();
            }
            if (!System.IO.Directory.Exists(pl_folder))
            {
                MessageBox.Show("Указанная папка не существует, установлена папка по умолчанию - playlist.");
                using (var connection = new SqliteConnection("Data Source=userdata.db"))
                {
                    connection.Open();
                    SqliteCommand command = new SqliteCommand();
                    command.Connection = connection;

                    pl_folder = "playlist";
                    command.CommandText = "UPDATE user_pref SET pl_folder = \"playlist\" WHERE id=0";
                    command.ExecuteNonQuery();
                    connection.Close();


                }
            }
            pl_main.currentPlaylist = pl_main.newPlaylist("main", "");
            var rng = new Random();
            f = Directory.GetFiles(pl_folder + "\\", "*.mp3").OrderBy(x => rng.Next()).ToArray();

            foreach (string f1 in f)
            {
                pl_main.currentPlaylist.appendItem(pl_main.newMedia(f1));
            }
            pl_main.settings.setMode("shuffle", true);
            pl_main.settings.setMode("loop", pl_repeat);
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand
                {
                    Connection = connection
                };
                int temp_year = 0;
                command = new SqliteCommand("SELECT COUNT(*) FROM timers WHERE type = 1", connection);
                int current_n = 0;
                current_n = Convert.ToInt32(command.ExecuteScalar());
                if (current_n != 0)
                {
                    command.CommandText = "SELECT * FROM timers ORDER BY date LIMIT 1";
                    using (SqliteDataReader reader = command.ExecuteReader())
                    {

                        if (reader.HasRows) // если есть данные
                        {
                            while (reader.Read())
                            {
                                temp_year = DateTimeOffset.FromUnixTimeSeconds(Convert.ToInt32(reader.GetValue(0))).Year;
                            }
                        }
                    }
                    while (temp_year < Convert.ToInt32(DateTimeOffset.Now.Year))
                    {
                        _ = comboBox6.Items.Add(temp_year);
                        temp_year++;
                    }
                }
                connection.Close();
            }
            _ = comboBox6.Items.Add(DateTimeOffset.Now.Year);
            comboBox6.SelectedItem = DateTimeOffset.Now.Year;

        }

        private void fixDataBase()
        {
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand
                {
                    Connection = connection
                };
                #region --# nort_timer #--
                command = new SqliteCommand(" ALTER TABLE user_pref ADD nort_timer INTEGER NOT NULL DEFAULT 1", connection);
                try
                {
                    command.ExecuteNonQuery();
                }
                catch
                {

                }
                #endregion
                #region --# nort_lb_logic #--
                command = new SqliteCommand(" ALTER TABLE user_pref ADD nort_lb_logic INTEGER NOT NULL DEFAULT 0", connection); // 0 - обработка по кукумберам, 1 - обработка по перерывам
                try
                {
                    command.ExecuteNonQuery();
                }
                catch
                {

                }
                #endregion
                #region --# pl_status #--
                command = new SqliteCommand(" ALTER TABLE user_pref ADD pl_status INTEGER NOT NULL DEFAULT 0", connection);
                try
                {
                    command.ExecuteNonQuery();
                }
                catch
                {

                }
                #endregion
                #region --# pl_repeat #--
                command = new SqliteCommand(" ALTER TABLE user_pref ADD pl_repeat INTEGER NOT NULL DEFAULT 1", connection);
                try
                {
                    command.ExecuteNonQuery();
                }
                catch
                {

                }
                #endregion
                #region --# pl_break #--
                command = new SqliteCommand(" ALTER TABLE user_pref ADD pl_break INTEGER NOT NULL DEFAULT 1", connection);
                try
                {
                    command.ExecuteNonQuery();
                }
                catch
                {

                }
                #endregion
                #region --# pl_folder #--
                command = new SqliteCommand(" ALTER TABLE user_pref ADD pl_folder TEXT NOT NULL DEFAULT \"playlist\"", connection);
                try
                {
                    command.ExecuteNonQuery();
                }
                catch
                {

                }
                #endregion
                connection.Close();
            }
        }

        private void ImportDataBase(object sender, EventArgs e)
        {
            OpenFileDialog theDialog = new OpenFileDialog();
            theDialog.Title = "Выберите SQLite базу данных";
            theDialog.Filter = "SQLite format|*.db";
            theDialog.InitialDirectory = @"C:\";
            if (theDialog.ShowDialog() == DialogResult.OK)
            {
                using (var connection = new SqliteConnection("Data Source=userdata.db"))
                {
                    string SQL = "ATTACH '" + theDialog.FileName + "' AS TOMERGE";
                    SqliteCommand cmd = new SqliteCommand(SQL);
                    cmd.Connection = connection;
                    connection.Open();
                    int retval = 0;
                    try
                    {
                        retval = cmd.ExecuteNonQuery();
                    }
                    catch (Exception Er)
                    {
                        MessageBox.Show("An error occurred, your import was not completed.\n" + Er.Message);
                    }
                    finally
                    {
                        cmd.Dispose();
                    }

                    SQL = "INSERT INTO timers(date,type,length,start,end) SELECT date,type,length,start,end FROM TOMERGE.timers";
                    cmd = new SqliteCommand(SQL);
                    cmd.Connection = connection;
                    retval = 0;
                    try
                    {
                        retval = cmd.ExecuteNonQuery();
                    }
                    catch (Exception Er)
                    {
                        MessageBox.Show("An error occurred, your import was not completed.\n" + Er.Message);
                    }
                    finally
                    {
                        cmd.Dispose();

                    }
                    SQL = "DETACH TOMERGE";
                    cmd.Connection = connection;
                    connection.Open();
                    retval = 0;
                    try
                    {
                        retval = cmd.ExecuteNonQuery();
                    }
                    catch (Exception Er)
                    {
                        MessageBox.Show("An error occurred, your import was not completed.\n" + Er.Message);
                    }
                    finally
                    {
                        cmd.Dispose();
                        connection.Close();
                    }
                }
                comboBox6.Items.Clear();
                using (var connection = new SqliteConnection("Data Source=userdata.db"))
                {
                    connection.Open();
                    SqliteCommand command = new SqliteCommand
                    {
                        Connection = connection
                    };
                    int temp_year = 0;
                    command = new SqliteCommand("SELECT COUNT(*) FROM timers WHERE type = 1", connection);
                    int current_n = 0;
                    current_n = Convert.ToInt32(command.ExecuteScalar());
                    if (current_n != 0)
                    {
                        command.CommandText = "SELECT * FROM timers ORDER BY date LIMIT 1";
                        using (SqliteDataReader reader = command.ExecuteReader())
                        {

                            if (reader.HasRows) // если есть данные
                            {
                                while (reader.Read())
                                {
                                    temp_year = DateTimeOffset.FromUnixTimeSeconds(Convert.ToInt32(reader.GetValue(0))).Year;
                                }
                            }
                        }
                        while (temp_year < Convert.ToInt32(DateTimeOffset.Now.Year))
                        {
                            _ = comboBox6.Items.Add(temp_year);
                            temp_year++;
                        }
                    }
                    connection.Close();
                }
                _ = comboBox6.Items.Add(DateTimeOffset.Now.Year);
                comboBox6.SelectedItem = DateTimeOffset.Now.Year;
            }
        }

        private void ExitApp(object sender, EventArgs e)
        {
            base.Close();
        }

        private void OpenSettings(object sender, EventArgs e)
        {
            tabControl1.SelectedIndex = 0;
            string[] installs;
            if (!lb_logic)
            {
                installs = new string[] { "никогда",
"через каждый кукумбер",
"через каждый 2-ой кукумбер",
"через каждый 3-ий кукумбер",
"через каждый 4-ый кукумбер",
"через каждый 5-ый кукумбер",
"через каждый 6-ой кукумбер",
"через каждый 7-ой кукумбер",
"через каждый 8-ой кукумбер",
"через каждый 9-ый кукумбер",
"через каждый 10-ый кукумбер"};
            }
            else
            {
                installs = new string[] { "никогда",
"каждый перерыв",
"каждый 2-ой перерыв",
"каждый 3-ий перерыв",
"каждый 4-ый перерыв",
"каждый 5-ый перерыв",
"каждый 6-ой перерыв",
"каждый 7-ой перерыв",
"каждый 8-ой перерыв",
"каждый 9-ый перерыв",
"каждый 10-ый перерыв"};
            }
            comboBox5.Items.Clear();
            comboBox5.Items.AddRange(installs);
            if (long_break_n < 0)
            {
                this.comboBox5.SelectedIndex = 0;
            }
            else
            {
                this.comboBox5.SelectedIndex = long_break_n;
            }
            this.comboBox1.SelectedItem = f1_sound;
            this.comboBox2.SelectedItem = f2_sound;
            this.comboBox3.SelectedItem = b_sound;
            this.comboBox4.SelectedItem = lb_sound;
            this.textBox1.Text = Convert.ToString(focus_time);
            this.textBox2.Text = Convert.ToString(break_time);
            this.textBox3.Text = Convert.ToString(long_break_time);
            this.groupBox2.Visible = true;
            this.groupBox3.Visible = true;
            this.groupBox4.Visible = true;
            this.offsetTimer.Checked = ofs_timer;
            this.lbLogic.Checked = lb_logic;
            this.playerEnabled.Checked = pl_status;
            this.repeatPlaylist.Checked = pl_repeat;
            this.playlistFolder.Text = pl_folder;
            this.pauseMusicBreak.Checked = pl_break;
            this.button3.BackColor = System.Drawing.Color.SeaGreen;
            this.button4.BackColor = System.Drawing.Color.MediumSeaGreen;
            this.Focus();
            this.Visible = true;
            this.WindowState = FormWindowState.Normal;

        }

        private void TimersHide()
        {
            this.notifyIcon1.ContextMenuStrip.Items[0].Visible = false;
            this.notifyIcon1.ContextMenuStrip.Items[1].Visible = false;
            this.notifyIcon1.ContextMenuStrip.Items[2].Visible = false;
            this.notifyIcon1.ContextMenuStrip.Items[3].Visible = true;
            this.notifyIcon1.ContextMenuStrip.Items[4].Visible = true;
            this.notifyIcon1.ContextMenuStrip.Items[5].Visible = true;
        }

        private void TimersShow()
        {
            this.notifyIcon1.ContextMenuStrip.Items[0].Visible = true;
            this.notifyIcon1.ContextMenuStrip.Items[1].Visible = true;
            this.notifyIcon1.ContextMenuStrip.Items[2].Visible = true;
            this.notifyIcon1.ContextMenuStrip.Items[3].Visible = false;
            this.notifyIcon1.ContextMenuStrip.Items[4].Visible = false;
            this.notifyIcon1.ContextMenuStrip.Items[5].Visible = false;
        }
        public void StartLongBreak(object sender, EventArgs e)
        {
            startTime = DateTimeOffset.Now.ToUnixTimeSeconds();
            stopTime = DateTimeOffset.Now.AddMinutes(long_break_time).ToUnixTimeSeconds();
            timerx.Enabled = true;
            _timer_work = true;
            _timer_type = 3;
            timerx.Tick += new EventHandler(Timer_Tick);
            TimersShow();
            this.notifyIcon1.ContextMenuStrip.Items[0].Text = "Приостановить таймер";
            if (System.IO.File.Exists("images/delay.ico"))
            {
                this.notifyIcon1.Icon = new Icon("images/delay.ico");
            }
            else
            {
                this.notifyIcon1.Icon = pomidor.Properties.Resources.delay;
            }
            if (pl_status && !pl_paused && pl_break)
            {
                pl_main.controls.pause();
            }
        }

        public void StartBreak(object sender, EventArgs e)
        {
            startTime = DateTimeOffset.Now.ToUnixTimeSeconds();
            stopTime = DateTimeOffset.Now.AddMinutes(break_time).ToUnixTimeSeconds();
            timerx.Enabled = true;
            _timer_work = true;
            _timer_type = 2;
            timerx.Tick += new EventHandler(Timer_Tick);
            TimersShow();
            this.notifyIcon1.ContextMenuStrip.Items[0].Text = "Приостановить таймер";
            if (System.IO.File.Exists("images/delay.ico"))
            {
                this.notifyIcon1.Icon = new Icon("images/delay.ico");
            }
            else
            {
                this.notifyIcon1.Icon = pomidor.Properties.Resources.delay;
            }
            if (pl_status && !pl_paused && pl_break)
            {
                pl_main.controls.pause();
            }
        }

        public void StartFocus(object sender, EventArgs e)
        {
            startTime = DateTimeOffset.Now.ToUnixTimeSeconds();
            stopTime = DateTimeOffset.Now.AddMinutes(focus_time).ToUnixTimeSeconds();
            timerx.Enabled = true;
            _timer_work = true;
            _timer_type = 1;
            timerx.Tick += new EventHandler(Timer_Tick);
            TimersShow();
            this.notifyIcon1.ContextMenuStrip.Items[0].Text = "Приостановить таймер";
            if (System.IO.File.Exists("images/focus.ico"))
            {
                this.notifyIcon1.Icon = new Icon("images/focus.ico");
            }
            else
            {
                this.notifyIcon1.Icon = pomidor.Properties.Resources.focus;
            }
            if (f1_sound != "нет")
            {
                wplayer.URL = "sounds/" + f1_sound + ".mp3";
                wplayer.controls.play();
            }
            if (pl_status && !pl_paused)
            {
                pl_main.controls.play();
            }
        }

        public void PauseClick(object sender, EventArgs e)
        {
            if (!_timer_pause)
            {
                pauseMoment = DateTimeOffset.Now.ToUnixTimeSeconds();
                timerx.Stop();
                _timer_pause = true;
                this.notifyIcon1.ContextMenuStrip.Items[0].Text = "Возобновить таймер";
                var date = DateTimeOffset.FromUnixTimeSeconds(stopTime - DateTimeOffset.Now.ToUnixTimeSeconds());
                switch (_timer_type)
                {
                    case 1:
                        notifyIcon1.Text = "Режим: Фокусировка";
                        break;
                    case 2:
                        notifyIcon1.Text = "Режим: Короткий перерыв";
                        break;
                    case 3:
                        notifyIcon1.Text = "Режим: Длинный перерыв";
                        break;
                }
                if (_timer_pause)
                {
                    notifyIcon1.Text += "\nСтатус: Пауза";
                }
                else
                {
                    notifyIcon1.Text += "\nСтатус: Активен";
                }
                notifyIcon1.Text += "\nОсталось: " + date.ToString("HH:mm:ss");
                if (System.IO.File.Exists("images/pause.ico"))
                {
                    this.notifyIcon1.Icon = new Icon("images/pause.ico");
                }
                else
                {
                    this.notifyIcon1.Icon = pomidor.Properties.Resources.pause;
                }
                if (pl_status && !pl_paused && pl_break)
                {
                    pl_main.controls.pause();
                }
            }
            else
            {
                stopTime += (DateTimeOffset.Now.ToUnixTimeSeconds() - pauseMoment);
                timerx.Start();
                timerx.Enabled = true;
                _timer_pause = false;
                this.notifyIcon1.ContextMenuStrip.Items[0].Text = "Приостановить таймер";
                switch (_timer_type)
                {
                    case 1:
                        if (System.IO.File.Exists("images/focus.ico"))
                        {
                            this.notifyIcon1.Icon = new Icon("images/focus.ico");
                        }
                        else
                        {
                            this.notifyIcon1.Icon = pomidor.Properties.Resources.focus;
                        }
                        if (pl_status && !pl_paused)
                        {
                            pl_main.controls.play();
                        }
                        break;
                    case 2:
                        if (System.IO.File.Exists("images/delay.ico"))
                        {
                            this.notifyIcon1.Icon = new Icon("images/delay.ico");
                        }
                        else
                        {
                            this.notifyIcon1.Icon = pomidor.Properties.Resources.delay;
                        }
                        break;
                    case 3:
                        if (System.IO.File.Exists("images/delay.ico"))
                        {
                            this.notifyIcon1.Icon = new Icon("images/delay.ico");
                        }
                        else
                        {
                            this.notifyIcon1.Icon = pomidor.Properties.Resources.delay;
                        }
                        break;
                }

            }
        }
        public void StopClick(object sender, EventArgs e)
        {
            if (_timer_work)
            {
                startTime = -1;
                stopTime = -1;
                timerx.Enabled = false;
                _timer_work = false;
                _timer_pause = false;
                TimersHide();
                this.notifyIcon1.ContextMenuStrip.Items[0].Text = "Приостановить таймер";
                notifyIcon1.Text = "Нет активных таймеров.";
                if (System.IO.File.Exists("images/none.ico"))
                {
                    this.notifyIcon1.Icon = new Icon("images/none.ico");
                }
                else
                {
                    this.notifyIcon1.Icon = pomidor.Properties.Resources.none;
                }
                if (pl_status && !pl_paused)
                {
                    pl_main.controls.pause();
                }
            }


        }

        private void NotifyIcon1_MClick(object sender, MouseEventArgs e)
        {
            if (e.Button == MouseButtons.Left)
            {
                if (_timer_work)
                {
                    PauseClick(sender, e);
                }
                else
                {
                    startTime = DateTimeOffset.Now.ToUnixTimeSeconds();
                    switch (_timer_type)
                    {
                        default:
                            stopTime = DateTimeOffset.Now.AddMinutes(focus_time).ToUnixTimeSeconds();
                            _timer_type = 1;
                            if (System.IO.File.Exists("images/focus.ico"))
                            {
                                this.notifyIcon1.Icon = new Icon("images/focus.ico");
                            }
                            else
                            {
                                this.notifyIcon1.Icon = pomidor.Properties.Resources.focus;
                            }
                            if (pl_status && !pl_paused)
                            {
                                pl_main.controls.play();
                            }
                            break;
                        case 2:
                            stopTime = DateTimeOffset.Now.AddMinutes(break_time).ToUnixTimeSeconds();
                            if (System.IO.File.Exists("images/delay.ico"))
                            {
                                this.notifyIcon1.Icon = new Icon("images/delay.ico");
                            }
                            else
                            {
                                this.notifyIcon1.Icon = pomidor.Properties.Resources.delay;
                            }
                            if (pl_status && !pl_paused && pl_break)
                            {
                                pl_main.controls.pause();
                            }
                            break;
                        case 3:
                            stopTime = DateTimeOffset.Now.AddMinutes(long_break_time).ToUnixTimeSeconds();
                            if (System.IO.File.Exists("images/delay.ico"))
                            {
                                this.notifyIcon1.Icon = new Icon("images/delay.ico");
                            }
                            else
                            {
                                this.notifyIcon1.Icon = pomidor.Properties.Resources.delay;
                            }
                            if (pl_status && !pl_paused && pl_break)
                            {
                                pl_main.controls.pause();
                            }
                            break;
                    }
                    timerx.Enabled = true;
                    _timer_work = true;
                    timerx.Tick += new EventHandler(Timer_Tick);
                    TimersShow();
                    this.notifyIcon1.ContextMenuStrip.Items[0].Text = "Приостановить таймер";
                    notifyIcon1.Text = "Нет активных таймеров.";
                }
            }
        }

        private void Timer_Tick(object sender, EventArgs e)
        {
            if (stopTime - DateTimeOffset.Now.ToUnixTimeSeconds() <= 0 && _timer_work)
            {
                _timer_work = false;
                timerx.Enabled = false;
                _timer_pause = false;
                timerx.Stop();
                timerx.Tick -= Timer_Tick;
                TimersHide();
                this.notifyIcon1.ContextMenuStrip.Items[0].Text = "Приостановить таймер";
                notifyIcon1.Text = "Нет активных таймеров.";
                if (System.IO.File.Exists("images/none.ico"))
                {
                    this.notifyIcon1.Icon = new Icon("images/none.ico");
                }
                else
                {
                    this.notifyIcon1.Icon = pomidor.Properties.Resources.none;
                }

                switch (_timer_type)
                {
                    case 1:
                        using (var connection = new SqliteConnection("Data Source=userdata.db"))
                        {
                            connection.Open();
                            SqliteCommand command = new SqliteCommand("INSERT INTO timers(`date`, `start`, `end`, `length`,`type`) VALUES(" + Convert.ToString(DateTimeOffset.Now.ToUnixTimeSeconds()) + "," + Convert.ToString(startTime) + "," + Convert.ToString(stopTime) + "," + Convert.ToString(stopTime - startTime) + "," + Convert.ToString(_timer_type) + ")", connection);
                            command.ExecuteNonQuery();
                            command = new SqliteCommand("SELECT COUNT(*) FROM timers WHERE (date-(date%86400))/86400 = " + Convert.ToString(DateTimeOffset.Now.ToUnixTimeSeconds() / 86400) + " AND type = 2", connection);
                            int current_n = 0;
                            int current_lb = 0;
                            int current_t = 0;
                            current_n = Convert.ToInt32(command.ExecuteScalar());
                            command = new SqliteCommand("SELECT COUNT(*) FROM timers WHERE (date-(date%86400))/86400 = " + Convert.ToString(DateTimeOffset.Now.ToUnixTimeSeconds() / 86400) + " AND type = 3", connection);

                            current_lb = Convert.ToInt32(command.ExecuteScalar());
                            command = new SqliteCommand("SELECT COUNT(*) FROM timers WHERE (date-(date%86400))/86400 = " + Convert.ToString(DateTimeOffset.Now.ToUnixTimeSeconds() / 86400) + " AND type = 1", connection);
                            current_t = Convert.ToInt32(command.ExecuteScalar());
                            if (f2_sound != "нет")
                            {
                                wplayer.URL = "sounds/" + f2_sound + ".mp3";
                                wplayer.controls.play();
                            }
                            if ((current_t % long_break_n == 0 && !lb_logic) || ((current_n + current_lb) % long_break_n == long_break_n - 1 && lb_logic))
                            {
                                _timer_type = 3;
                                Nortification("", 3);

                            }
                            else
                            {
                                _timer_type = 2;
                                Nortification("", 2);
                            }
                            StopClick(sender, e);
                            connection.Close();

                        }
                        break;
                    default:
                        using (var connection = new SqliteConnection("Data Source=userdata.db"))
                        {
                            connection.Open();
                            SqliteCommand command = new SqliteCommand("INSERT INTO timers(`date`, `start`, `end`, `length`,`type`) VALUES(" + Convert.ToString(DateTimeOffset.Now.ToUnixTimeSeconds()) + "," + Convert.ToString(startTime) + "," + Convert.ToString(stopTime) + "," + Convert.ToString(stopTime - startTime) + "," + Convert.ToString(_timer_type) + ")", connection);
                            command.ExecuteNonQuery();
                            connection.Close();
                        }
                        if (_timer_type == 2)
                        {
                            if (b_sound != "нет")
                            {
                                wplayer.URL = "sounds/" + b_sound + ".mp3";
                                wplayer.controls.play();

                            }
                        }
                        else if (_timer_type == 3)
                        {
                            if (lb_sound != "нет")
                            {
                                wplayer.URL = "sounds/" + lb_sound + ".mp3";
                                wplayer.controls.play();

                            }
                        }
                        _timer_type = 1;

                        if (f1_sound != "нет")
                        {
                            wplayer.URL = "sounds/" + f1_sound + ".mp3";
                            wplayer.controls.play();

                        }
                        Nortification("", 1);
                        StopClick(sender, e);
                        break;
                }
                Task.Run(Calc_heatmap);
            }
            else if (_timer_work)
            {
                var date = DateTimeOffset.FromUnixTimeSeconds(stopTime - DateTimeOffset.Now.ToUnixTimeSeconds());
                switch (_timer_type)
                {
                    case 1:
                        notifyIcon1.Text = "Режим: Фокусировка";
                        break;
                    case 2:
                        notifyIcon1.Text = "Режим: Короткий перерыв";
                        break;
                    case 3:
                        notifyIcon1.Text = "Режим: Длинный перерыв";
                        break;
                }
                if (_timer_pause)
                {
                    notifyIcon1.Text += "\nСтатус: Пауза";
                }
                else
                {
                    notifyIcon1.Text += "\nСтатус: Активен";
                }
                notifyIcon1.Text += "\nОсталось: " + date.ToString("HH:mm:ss");
            }
        }

        public void Nortification(string msg, int type)
        {
            Form_Nortification frm = new Form_Nortification(this);
            frm.showAlert(msg, type, long_break_n);
        }

        private void comboBox5_SelectedIndexChanged(object sender, EventArgs e)
        {
            int selectedState = comboBox5.SelectedIndex;
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET before_lbreak = ";
                if (selectedState == 0)
                {
                    selectedState = -1;
                }
                command.CommandText += Convert.ToString(selectedState) + " WHERE id=0";
                command.ExecuteNonQuery();
                long_break_n = selectedState;

                connection.Close();


            }
        }

        private void TextBox1_TextChanged(object sender, EventArgs e)
        {
            string txt = this.textBox1.Text;
            if (txt == "")
            {
                txt = "1";
                this.textBox1.Text = txt;
            }
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET focus_time = ";
                command.CommandText += txt + " WHERE id=0";
                command.ExecuteNonQuery();
                focus_time = Convert.ToInt64(txt);

                connection.Close();


            }
        }

        private void textBox2_TextChanged(object sender, EventArgs e)
        {
            string txt = this.textBox2.Text;
            if (txt == "")
            {
                txt = "1";
                this.textBox2.Text = txt;
            }
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET break_time = ";
                command.CommandText += txt + " WHERE id=0";
                command.ExecuteNonQuery();
                break_time = Convert.ToInt64(txt);

                connection.Close();


            }
        }

        private void textBox3_TextChanged(object sender, EventArgs e)
        {
            string txt = this.textBox3.Text;
            if (txt == "")
            {
                txt = "1";
                this.textBox3.Text = txt;
            }
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET lbreak_time = ";
                command.CommandText += txt + " WHERE id=0";
                command.ExecuteNonQuery();
                long_break_time = Convert.ToInt64(txt);

                connection.Close();


            }
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            string txt = this.comboBox1.SelectedItem.ToString();
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET f1_sound = '";
                command.CommandText += txt + "' WHERE id=0";
                command.ExecuteNonQuery();
                f1_sound = txt;

                connection.Close();


            }
        }

        private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {
            string txt = this.comboBox2.SelectedItem.ToString();
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET f2_sound = '";
                command.CommandText += txt + "' WHERE id=0";
                command.ExecuteNonQuery();
                f2_sound = txt;

                connection.Close();


            }
        }

        private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
        {
            string txt = this.comboBox3.SelectedItem.ToString();
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET b_sound = '";
                command.CommandText += txt + "' WHERE id=0";
                command.ExecuteNonQuery();
                b_sound = txt;

                connection.Close();


            }
        }

        private void comboBox4_SelectedIndexChanged(object sender, EventArgs e)
        {
            string txt = this.comboBox4.SelectedItem.ToString();
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET lb_sound = '";
                command.CommandText += txt + "' WHERE id=0";
                command.ExecuteNonQuery();
                lb_sound = txt;

                connection.Close();


            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.WindowState = FormWindowState.Minimized;
            this.Visible = false;
        }

        private void panel1_MouseDown(object sender, MouseEventArgs e)
        {
            panel1.Capture = false;
            Message m = Message.Create(Handle, 0xa1, new IntPtr(2), IntPtr.Zero);
            WndProc(ref m);
        }

        private void button4_MouseClick(object sender, MouseEventArgs e)
        {
            if (tabControl1.SelectedIndex == 0)
            {
                Task.Run(Calc_heatmap);
            }
            tabControl1.SelectTab(1);
            this.button4.BackColor = System.Drawing.Color.SeaGreen;
            this.button3.BackColor = System.Drawing.Color.MediumSeaGreen;
        }

        private void Calc_heatmap()
        {
            Task.Run(ghostRecalculate);
            int[] weeks = new int[53];
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command, command1;
                command = new SqliteCommand("SELECT COUNT(*) FROM timers WHERE strftime('%Y', datetime(date, 'unixepoch')) = \"" + Convert.ToString(year) + "\" AND type = 1", connection);
                int current_n = 0;
                current_n = Convert.ToInt32(command.ExecuteScalar());
                command = new SqliteCommand("SELECT * FROM timers WHERE strftime('%Y', datetime(date, 'unixepoch')) = \"" + Convert.ToString(year) + "\" AND type = 1", connection);
                int[] days = new int[366];
                bool visokos = true;
                int skip_days = (new DateTime(year, 1, 1).DayOfWeek == 0) ? 6 : (int)new DateTime(year, 1, 1).DayOfWeek - 1;
                using (SqliteDataReader reader = command.ExecuteReader())
                {
                    if (reader.HasRows) // если есть данные
                    {
                        while (reader.Read())
                        {
                            var result = reader.GetValue(0);
                            Console.WriteLine(result);
                            Console.WriteLine(DateTimeOffset.FromUnixTimeSeconds(Convert.ToInt64(result)).ToLocalTime().ToUnixTimeSeconds());
                            Console.WriteLine(DateTimeOffset.FromUnixTimeSeconds(Convert.ToInt64(result)).ToLocalTime().ToString());
                            Console.WriteLine("====");
                            int date = DateTimeOffset.FromUnixTimeSeconds(Convert.ToInt64(result)).ToLocalTime().DayOfYear;
                            days[date - 1]++;
                        }
                    }
                }
                int maxValue = days.Max();
                int current_day = 0;
                int current_week = 0;
                tableLayoutPanel1.SuspendLayout();
                foreach (Control cell in tableLayoutPanel1.Controls)
                {
                    cell.BackColor = SystemColors.Control;
                }
                tableLayoutPanel1.ResumeLayout();
                tableLayoutPanel1.SuspendLayout();
                foreach (Control cell in tableLayoutPanel1.Controls)
                {
                    if (skip_days > 0)
                    {
                        cell.BackColor = SystemColors.Control;
                        skip_days--;
                        continue;
                    }
                    try {
                    if (days[current_day] == 0)
                    {
                        cell.BackColor = System.Drawing.Color.White;
                    }
                    else
                    {
                        int percent = GetPercent(maxValue, days[current_day]);
                        if (percent <= 25)
                        {
                            cell.BackColor = System.Drawing.ColorTranslator.FromHtml("#c6e48b");
                        }
                        else if (percent <= 50 && percent > 25)
                        {
                            cell.BackColor = System.Drawing.ColorTranslator.FromHtml("#7bc96f");
                        }
                        else if (percent <= 75 && percent > 50)
                        {
                            cell.BackColor = System.Drawing.ColorTranslator.FromHtml("#239a3b");
                        }
                        else if (percent > 75)
                        {
                            cell.BackColor = System.Drawing.ColorTranslator.FromHtml("#196127");
                        }

                    }
                
                cell.Name = days[current_day].ToString() + "n" + current_day.ToString() + "n" + cell.Location.X.ToString() + "n" + cell.Location.Y.ToString();
                    cell.MouseEnter += tt_Enter;
                    weeks[current_week] += days[current_day];
                    current_day++;
                    if (current_day % 7 == 0)
                    {
                        current_week++;
                        weeks[current_week] = 0;
                    }
                    if ((visokos && current_day >= 365) || (!visokos && current_day >= 366))
                    {
                        cell.BackColor = SystemColors.Control;
                    }

                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }
                }

                this.chart1.SuspendLayout();
                this.chart1.BeginInvoke((MethodInvoker)(() =>
                {
                    this.chart1.Series[0].Points.Clear();
                    int j = 0;
                    foreach (int i in weeks)
                    {
                        var point = this.chart1.Series[0].Points.AddXY(j, i);
                        this.chart1.Series[0].Points[point].ToolTip = "#SERIESNAME : X=#VALX, Y=#VALY";
                        j++;
                    }
                }));
                this.chart1.ResumeLayout();

                tableLayoutPanel1.ResumeLayout();


                connection.Close();
            }

        }
        private void tt_Leave(object sender, EventArgs e)
        {
            panel3.Visible = false;
        }

        public static Int32 GetPercent(Int32 b, Int32 a)
        {
            if (b == 0) return 0;

            return (Int32)(a / (b / 100M));
        }
        private void tt_Enter(object sender, EventArgs e)
        {
            this.SuspendLayout();
            tableLayoutPanel1.SuspendLayout();
            var pB = (PictureBox)sender;
            var args = pB.Name.Split('n');
            var temp_text = args[0];
            var offset = 0;
            if (int.Parse(args[2]) + tableLayoutPanel1.Location.X + panel3.Width - this.Width > 16)
            {
                offset = int.Parse(args[2]) + tableLayoutPanel1.Location.X + panel3.Width - this.Width + 16;
            }

            panel3.Location = new System.Drawing.Point(int.Parse(args[2]) + tableLayoutPanel1.Location.X - offset, tableLayoutPanel1.Location.Y + int.Parse(args[3]) - panel3.Height - 11);
            if (args[0][args[0].Length - 1] == '1')
            {
                if (args[0].Length == 1)
                {
                    temp_text += " кукумбер, ";
                }
                else if (args[0][args[0].Length - 2] != '1')
                {
                    temp_text += " кукумбер, ";
                }
                else
                {
                    temp_text += " кукумберов, ";
                }
            }
            else if (args[0][args[0].Length - 1] == '2')
            {
                if (args[0].Length == 1)
                {
                    temp_text += " кукумбера, ";
                }
                else if (args[0][args[0].Length - 2] != '1')
                {
                    temp_text += " кукумбера, ";
                }
                else
                {
                    temp_text += " кукумберов, ";
                }
            }
            else if (args[0][args[0].Length - 1] == '3')
            {
                if (args[0].Length == 1)
                {
                    temp_text += " кукумбера, ";
                }
                else if (args[0][args[0].Length - 2] != '1')
                {
                    temp_text += " кукумбера, ";
                }
                else
                {
                    temp_text += " кукумберов, ";
                }
            }
            else if (args[0][args[0].Length - 1] == '4')
            {
                if (args[0].Length == 1)
                {
                    temp_text += " кукумбера, ";
                }
                else if (args[0][args[0].Length - 2] != '1')
                {
                    temp_text += " кукумбера, ";
                }
                else
                {
                    temp_text += " кукумберов, ";
                }
            }
            else
            {
                temp_text += " кукумберов, ";
            }
            var culture = CultureInfo.CreateSpecificCulture("ru-RU");
            DateTime date = new DateTime(year, 1, 1).AddDays(Convert.ToInt32(args[1]));
            temp_text += date.ToString("dddd, d MMMM", culture);
            label13.Text = temp_text;
            panel3.Visible = true;
            tableLayoutPanel1.ResumeLayout();
            this.ResumeLayout();
        }

        private void comboBox6_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                if (year != int.Parse(comboBox6.SelectedItem.ToString()))
                {
                    year = int.Parse(comboBox6.SelectedItem.ToString());
                    Task.Run(Calc_heatmap);
                }
            }
            catch (Exception)
            {
            }
        }
        private void pictureBox1_Paint_1(object sender, PaintEventArgs e)
        {
            var pB = (PictureBox)sender;
            ControlPaint.DrawBorder(e.Graphics, pB.ClientRectangle, SystemColors.ControlDark, ButtonBorderStyle.Solid);
        }
        #region .. Double Buffered function ..
        public static void SetDoubleBuffered(System.Windows.Forms.Control c)
        {
            if (System.Windows.Forms.SystemInformation.TerminalServerSession)
                return;
            System.Reflection.PropertyInfo aProp = typeof(System.Windows.Forms.Control).GetProperty("DoubleBuffered",
            System.Reflection.BindingFlags.NonPublic |
            System.Reflection.BindingFlags.Instance);
            aProp.SetValue(c, true, null);
        }

        #endregion


        #region .. code for Flucuring ..

        protected override CreateParams CreateParams
        {
            get
            {
                CreateParams cp = base.CreateParams;
                cp.ExStyle |= 0x02000000;
                return cp;
            }
        }

        #endregion

        private void p3_Mhover(object sender, EventArgs e)
        {
            panel3.Visible = false;
        }

        private void offsetTimer_CheckedChanged(object sender, EventArgs e)
        {
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET nort_timer = ";
                command.CommandText += Convert.ToInt32(offsetTimer.Checked) + " WHERE id=0";
                command.ExecuteNonQuery();
                ofs_timer = offsetTimer.Checked;

                connection.Close();


            }
        }

        private void lbLogic_CheckedChanged(object sender, EventArgs e)
        {
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET nort_lb_logic = ";
                command.CommandText += Convert.ToInt32(lbLogic.Checked) + " WHERE id=0";
                command.ExecuteNonQuery();
                lb_logic = lbLogic.Checked;

                connection.Close();


            }
            OpenSettings(sender, e);
        }

        private void playerEnabled_CheckedChanged(object sender, EventArgs e)
        {
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET pl_status = ";
                command.CommandText += Convert.ToInt32(playerEnabled.Checked) + " WHERE id=0";
                command.ExecuteNonQuery();
                if (!System.IO.Directory.Exists(pl_folder))
                {
                    MessageBox.Show("Указанная папка не существует, установлена папка по умолчанию - playlist.");
                    pl_folder = "playlist";
                    command.CommandText = "UPDATE user_pref SET pl_folder = \"playlist\" WHERE id=0";
                    command.ExecuteNonQuery();
                }
                pl_status = playerEnabled.Checked;

                connection.Close();



            }
            playerSettingsGroup.Enabled = pl_status;
            if (playerEnabled.Checked)
            {
                pl_main.controls.next();
                if (this.notifyIcon1.ContextMenuStrip.Items[this.notifyIcon1.ContextMenuStrip.Items.Count - 2].Text != "Следующий трек")
                {

                    this.notifyIcon1.ContextMenuStrip.Items.Insert(this.notifyIcon1.ContextMenuStrip.Items.Count - 1, new ToolStripMenuItem("Приостановить плеер", null, pl_pause));
                    this.notifyIcon1.ContextMenuStrip.Items.Insert(this.notifyIcon1.ContextMenuStrip.Items.Count - 1, new ToolStripMenuItem("Следующий трек", null, pl_nextTrack));
                }
            }
            else
            {
                pl_main.controls.previous();
                this.notifyIcon1.ContextMenuStrip.Items.Remove(this.notifyIcon1.ContextMenuStrip.Items[this.notifyIcon1.ContextMenuStrip.Items.Count - 1]);
                this.notifyIcon1.ContextMenuStrip.Items.Remove(this.notifyIcon1.ContextMenuStrip.Items[this.notifyIcon1.ContextMenuStrip.Items.Count - 1]);
            }
        }

        private void pl_pause(object sender, EventArgs e)
        {
            pl_paused = true;
            pl_main.controls.pause();
            this.notifyIcon1.ContextMenuStrip.Items[this.notifyIcon1.ContextMenuStrip.Items.Count - 3].Text = "Возобновить плеер";
            this.notifyIcon1.ContextMenuStrip.Items[this.notifyIcon1.ContextMenuStrip.Items.Count - 3].Click -= pl_pause;
            this.notifyIcon1.ContextMenuStrip.Items[this.notifyIcon1.ContextMenuStrip.Items.Count - 3].Click += pl_unpause;

        }

        private void pl_unpause(object sender, EventArgs e)
        {
            pl_paused = false;
            pl_main.controls.play();
            this.notifyIcon1.ContextMenuStrip.Items[this.notifyIcon1.ContextMenuStrip.Items.Count - 3].Text = "Приостановить плеер";
            this.notifyIcon1.ContextMenuStrip.Items[this.notifyIcon1.ContextMenuStrip.Items.Count - 3].Click -= pl_unpause;
            this.notifyIcon1.ContextMenuStrip.Items[this.notifyIcon1.ContextMenuStrip.Items.Count - 3].Click += pl_pause;
        }

        private void pl_nextTrack(object sender, EventArgs e)
        {
            pl_main.controls.next();
        }

        private void repeatPlaylist_CheckedChanged(object sender, EventArgs e)
        {
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET pl_repeat = ";
                command.CommandText += Convert.ToInt32(repeatPlaylist.Checked) + " WHERE id=0";
                command.ExecuteNonQuery();
                pl_repeat = repeatPlaylist.Checked;
                pl_main.settings.setMode("loop", pl_repeat);
                connection.Close();


            }
        }

        private void pauseMusicBreak_CheckedChanged(object sender, EventArgs e)
        {
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET pl_break = ";
                command.CommandText += Convert.ToInt32(pauseMusicBreak.Checked) + " WHERE id=0";
                command.ExecuteNonQuery();
                pl_break = pauseMusicBreak.Checked;

                connection.Close();


            }
        }
        public void pl_sc()
        {
            pl_main.controls.pause();
        }

        private void playlistFolder_TextChanged(object sender, EventArgs e)
        {
            string txt = this.textBox1.Text;
            if (txt == "")
            {
                txt = "playlist";
                this.playlistFolder.Text = txt;
            }
            using (var connection = new SqliteConnection("Data Source=userdata.db"))
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;

                command.CommandText = "UPDATE user_pref SET pl_folder = ";
                command.CommandText += txt + " WHERE id=0";
                command.ExecuteNonQuery();
                pl_folder = txt;

                connection.Close();


            }
        }

        private void ghostRecalculate()
        {
            if (dateGhost.Value == DateTime.ParseExact("01.01.1753", "dd.MM.yyyy", CultureInfo.InvariantCulture))
            {
                dateGhost.BeginInvoke((MethodInvoker)(() =>
                dateGhost.Value = DateTime.Today.AddDays(-1)
                ));
            }
            previousGhost.BeginInvoke((MethodInvoker)(() =>
                previousGhost.Text = "0"
                ));
            currentGhost.BeginInvoke((MethodInvoker)(() =>
                currentGhost.Text = "0"
                ));
            dateGhost.BeginInvoke((MethodInvoker)(() =>
            {
                DateTimeOffset currentTime = DateTimeOffset.Now.Date;
                DateTimeOffset currentDTime = DateTimeOffset.Now;
                int remainingHours = currentDTime.Hour;
                int remainingMinutes = currentDTime.Minute;
                int remainingSeconds = currentDTime.Second;
                string format = "dd.MM.yyyy";
                DateTimeOffset parsedDate = new DateTimeOffset(dateGhost.Value);
                Console.WriteLine(parsedDate.ToUnixTimeSeconds());
                DateTimeOffset updatedDate = parsedDate.AddHours(remainingHours).AddSeconds(remainingSeconds).AddMinutes(remainingMinutes);
                Console.WriteLine(updatedDate.ToUnixTimeSeconds());
                string queryString = "SELECT COUNT(*) FROM timers WHERE type = \"1\" AND date BETWEEN @StartDate AND @EndDate" ;


                try
                {
                    using (var connection = new SqliteConnection("Data Source=userdata.db;Mode=ReadWriteCreate"))
                    {
                        connection.Open();
                        SqliteCommand command = new SqliteCommand(queryString, connection);
                        command.Parameters.AddWithValue("@StartDate", parsedDate.ToUnixTimeSeconds());
                        command.Parameters.AddWithValue("@EndDate", updatedDate.ToUnixTimeSeconds());
                        int count = Convert.ToInt32(command.ExecuteScalar());
                        previousGhost.BeginInvoke((MethodInvoker)(() =>
                        previousGhost.Text = Convert.ToString(count)
                        ));
                        connection.Close();
                    }
                    using (var connection = new SqliteConnection("Data Source=userdata.db;Mode=ReadWriteCreate"))
                    {
                        connection.Open();
                        SqliteCommand command = new SqliteCommand(queryString, connection);
                        command.Parameters.AddWithValue("@StartDate", currentTime.ToUnixTimeSeconds());
                        command.Parameters.AddWithValue("@EndDate", currentDTime.ToUnixTimeSeconds());
                        int count = Convert.ToInt32(command.ExecuteScalar());
                        currentGhost.BeginInvoke((MethodInvoker)(() =>
                        currentGhost.Text = Convert.ToString(count)
                        ));
                        connection.Close();
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine($"Ошибка при выполнении запроса: {ex.Message}");
                }
            }));
        }

        private void dateGhost_ValueChanged(object sender, EventArgs e)
        {
            Task.Run(ghostRecalculate);
        }
    }
}