namespace Napominalka
{
    public partial class Form1 : Form
    {
        private MySqlConnection conn;
        private MySqlCommand cmd;
        private MySqlDataReader myData;
        private MySqlDataReader myD;
        private ContextMenu contextMenu1;
        private MenuItem cmenuExit;
        private MenuItem cmenuAbout;

        private MonthCalendar cl;

        private string login;
        private string pass;
        private string id;
        private string op;
        private NotifyIcon notifyIcon1;

        public Form1()
        {
            InitializeComponent();
            try
            {
                /*Календарь*/
                cl = new MonthCalendar();
                cl.Location = new Point(10, 10);
                /*Меню трея*/
                contextMenu1 = new ContextMenu();
                cmenuExit = new MenuItem();
                cmenuAbout = new MenuItem();

                //About
                cmenuAbout.Index = 0;
                cmenuAbout.Text = "О програмі";
                cmenuAbout.Click += new EventHandler(cmenuAbout_Click);
                //Exit
                cmenuExit.Index = 1;
                cmenuExit.Text = "Вийти";
                cmenuExit.Click += new EventHandler(cmenuExit_Click);
                //Add
                contextMenu1.MenuItems.Add(cmenuAbout);
                contextMenu1.MenuItems.Add(cmenuExit);
                /**/
                FileStream fr = new FileStream("config.dev", FileMode.Open);
                StreamReader sr = new StreamReader(fr, System.Text.Encoding.Unicode);
                login = sr.ReadLine();
                pass = sr.ReadLine();
                sr.Close();
                fr.Close();


                this.Resize += new EventHandler(Form1_Resize);
                this.FormClosed += new FormClosedEventHandler(Form1_FormClosed);
                this.StartPosition = FormStartPosition.CenterScreen;
                this.Icon = new Icon("test.ico");
                this.Controls.Add(cl);


                notifyIcon1 = new NotifyIcon();
                notifyIcon1.Icon = new Icon("test.ico");
                notifyIcon1.Click += new EventHandler(notifyIcon1_Click);
                notifyIcon1.ContextMenu = contextMenu1;
                notifyIcon1.Visible = true;

            }
            catch
            {
                MessageBox.Show("Виникла помилка при зчитуванні даних з файлу");
                this.Close();
            }

        }

        void Form1_FormClosed(object sender, FormClosedEventArgs e)
        {
            conn.Close();
            notifyIcon1.Visible = false;
        }

        void cmenuExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        void cmenuAbout_Click(object sender, EventArgs e)
        {
            MessageBox.Show("Програма для напомінання про визначні дати. Beta-версія");
        }

        void notifyIcon1_Click(object sender, EventArgs e)
        {
            if (FormWindowState.Minimized == WindowState)
            {
                Show();
                WindowState = FormWindowState.Normal;
            }
        }

        void Form1_Resize(object sender, EventArgs e)
        {
            if (FormWindowState.Minimized == WindowState)
            {
                Hide();
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            try
            {
                conn = new MySql.Data.MySqlClient.MySqlConnection();
                cmd = new MySql.Data.MySqlClient.MySqlCommand();
                conn.ConnectionString = "Server='10.0.108.52';Uid='user';Pwd='';Database='db_nap';";
        conn.Open();
                String SQL = "SELECT id, op FROM user WHERE login='" + login + "' AND pass='" + pass + "';";
                cmd.Connection = conn;
                cmd.CommandText = SQL;
                myData = cmd.ExecuteReader();
                if (!myData.HasRows)
                {
                    MessageBox.Show("Виникла помилка при перевірці даних");
                    this.Close();
                }
                myData.Read();
                id = myData[0].ToString();
                op = myData[1].ToString();
                DateTime tmp = new DateTime();
                //conn.Close();
                //conn.Open();
                tmp = DateTime.Now;
                string year = tmp.Year.ToString();
                string month=tmp.Month.ToString();
                switch (month)
                {
                    case "1":
                    case "2":
                    case "3":
                    case "4":
                    case "5":
                    case "6":
                    case "7":
                    case "8":
                    case "9":
                        month = "0" + month;
                        break;

                }
                SQL = "SELECT iduser, date, type, txt FROM tnap WHERE (iduser='0' OR iduser='" + id + "') AND (date LIKE '" + year + "-" + month + "-% %:%:%');";
                MessageBox.Show(SQL);
                //MySql.Data.MySqlClient.MySqlCommand cmds = new MySql.Data.MySqlClient.MySqlCommand();
                //cmd.Connection = conn;
                cmd.CommandText = SQL;
                myData = cmd.ExecuteReader();
                myData.Read();
                string date = myData[1].ToString();
                cl.BoldedDates = new DateTime[] { new DateTime(2011, 8, 24, 0, 0, 0, 0) };
            }
            catch (MySql.Data.MySqlClient.MySqlException ex)
            {
                MessageBox.Show("Виникла помилка при підключенні до бази даних!\n"+ex.Message);

                this.Close();
            }

        }
    }
}