Simple database Migration manager

using System;
using System.IO;
using MySql.Data.MySqlClient;

namespace FtwCore.Database.Migrations
{
    public sealed class MigrationManager
    {
        private string m_szConnectionString;
        private string m_szMigrationsPath;

        public MigrationManager(string host, string user, string pass, string data, int port)
        {
            m_szMigrationsPath = Environment.CurrentDirectory + "\\migrations\\";
            m_szConnectionString = $"Server={host};Port={port};Database={data};Uid={user};Password={pass};charset=utf8;";
        }

        public string LastException
        {
            get; private set;
        }

        public void Migrate()
        {
            if (!Directory.Exists(m_szMigrationsPath))
                Directory.CreateDirectory(m_szMigrationsPath);

            string[] files = Directory.GetFiles(m_szMigrationsPath);
            foreach (var file in files)
            {
                FileInfo info = new FileInfo(file);
                if (info.Extension != ".sql")
                {
                    Console.WriteLine($@"Skip migration file {info.Name} not sql");
                    continue;
                }

                if (Path.GetFileNameWithoutExtension(file).Length < 16)
                {
                    Console.WriteLine($@"Skip migration file {info.Name} name length less than 16");
                    continue;
                }

                string szYear = info.Name.Substring(0, 4);
                string szMonth = info.Name.Substring(4, 2);
                string szDay = info.Name.Substring(6, 2);
                string szHours = info.Name.Substring(8, 2);
                string szMinutes = info.Name.Substring(10, 2);
                string szSeconds = info.Name.Substring(12, 2);

                if (!int.TryParse(szYear, out int year)
                    || !int.TryParse(szMonth, out int month)
                    || !int.TryParse(szDay, out int day)
                    || !int.TryParse(szHours, out int hour)
                    || !int.TryParse(szMinutes, out int minute)
                    || !int.TryParse(szSeconds, out int second)
                    || !DateTime.TryParse($"{year}-{month}-{day} {hour}:{minute}:{second}", out DateTime dtFullTime))
                {
                    Console.WriteLine($@"Skip migration file {info.Name} invalid date stamp yyyyMMddHHmmss");
                    continue;
                }

                string fileName = Path.GetFileName(file);
                if (HasExecuted(fileName))
                {
                    continue;
                }

                if (!Execute(fileName))
                {
                    Console.WriteLine($@"Error on executing migration for file {info.Name}! Error: {LastException}");
                    continue;
                }

                ExecuteInsert($"INSERT INTO `migrations` (`file`, `execute_time`) VALUES ('{fileName}', '{DateTime.Now:yyyy-MM-dd HH:mm:ss}')");
                Console.WriteLine($@"Migration file {info.Name} has been executed");
            }
        }

        public bool Execute(string fileName)
        {
            if (!fileName.ToLower().EndsWith(".sql"))
                fileName += ".sql";

            try
            {
                using (MySqlConnection conn = new MySqlConnection(m_szConnectionString))
                {
                    conn.Open();
                    MySqlScript script = new MySqlScript(conn, File.ReadAllText($"{m_szMigrationsPath}{fileName}"));
                    script.Execute();
                    conn.Close();
                }
                return true;
            }
            catch (MySqlException ex)
            {
                LastException = ex.Message;
                return false;
            }
        }

        public bool HasExecuted(string fileName)
        {
            string query = "SELECT id FROM migrations WHERE `file`=@file LIMIT 1";
            try
            {
                using (MySqlConnection conn = new MySqlConnection(m_szConnectionString))
                {
                    using (MySqlCommand command = new MySqlCommand(query, conn))
                    {
                        conn.Open();
                        command.Prepare();
                        command.Parameters.AddWithValue("@file", fileName);
                        bool result = command.ExecuteReader().HasRows;
                        conn.Close();
                        return result;
                    }
                }
            }
            catch (MySqlException ex)
            {
                LastException = ex.Message;
                return false;
            }
        }

        public int ExecuteInsert(string szQuery)
        {
            try
            {
                int result = -1;
                using (MySqlConnection conn = new MySqlConnection(m_szConnectionString))
                {
                    using (MySqlCommand command = new MySqlCommand(szQuery, conn))
                    {
                        conn.Open();
                        result = command.ExecuteNonQuery();
                        conn.Close();
                    }
                }
                return result;
            }
            catch (MySqlException ex)
            {
                LastException = ex.Message;
                return -1;
            }
        }

        public bool TestConnection()
        {
            try
            {
                using (MySqlConnection conn = new MySqlConnection(m_szConnectionString))
                {
                    conn.Open();
                    conn.Close();
                }
                return true;
            }
            catch (MySqlException ex)
            {
                LastException = ex.Message;
                return false;
            }
        }
    }
}