using System;
using System.Collections.Generic;
using System.Windows.Forms;
using System.Linq;
using System.Diagnostics;
using System.IO;
using System.Drawing;
using System.Data;

namespace Schedario
{
    static class Program
    {
        /// <summary>
        /// Punto di ingresso principale dell'applicazione.
        /// </summary>
        /// 

        public static MyMainMdiForm Global_MyMainMdiForm;

        [STAThread]
        static void Main(string[] args)
        {
            //Impedisco che l'applicazione si apra due volte
            var Process = from p in System.Diagnostics.Process.GetProcesses()
                          where p.ProcessName.StartsWith("Schedario") // Nome della mia App
                          select p;
            

            if (!(Process.Count() > 1))
            {
                //Accendo il server Mysql se spento
                OpenMysql();

                Application.EnableVisualStyles();
                Application.SetCompatibleTextRenderingDefault(false);
                Global_MyMainMdiForm = new MyMainMdiForm();
                Application.Run(Global_MyMainMdiForm);


            }
            else if (Process.Count() > 1)
            {
                MessageBox.Show("SCHEDARIO IN ESECUZIONE!","Info",MessageBoxButtons.OK,MessageBoxIcon.Information);
            }
        }

        static void OpenMysql()
        {
            //Apro la connessione al database MYSQL
            System.Diagnostics.Process[] myProcesses;
            myProcesses = System.Diagnostics.Process.GetProcessesByName("mysqld");

            string pathApp = Application.StartupPath.ToString();
            string pathMYSQL = pathApp + "\\mysql\\bin\\mysqld.exe";

            if (myProcesses.Count() == 0)
            {
               
                Process myProcess = new Process();
                myProcess.StartInfo.FileName = pathMYSQL;
                myProcess.StartInfo.CreateNoWindow = true;
                myProcess.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
                myProcess.Start();
            }

        }
    }
}