public MySqlConnection OpenConnection(string connnectionString)
        {
            if (conn == null || conn.State != ConnectionState.Open)
            {
                try
                {
                    conn = new MySqlConnection(connnectionString);
                    if (conn.State != ConnectionState.Open)
                        conn.Open();
                }
                catch (Exception ex)
                {
                    if (conn != null)
                    {
                        conn.Dispose();
                    }
                }
                 logger.LogError("--Debug Connection Issue-- \n" + "Connection state : " + conn.State);
            }
            return conn;
        }

        public int ExecuteCommand(string queryString)
        {
            try
            {
                conn = OpenConnection(connnectionString);
                MySqlCommand cmd = new MySqlCommand(queryString, conn);
                object id = cmd.ExecuteScalar();
                string newProdID = id != null ? id.ToString() : "0";
                conn.Close();
                conn.Dispose();
                return Int32.Parse(newProdID);

            }
            catch (Exception ex)
            {
                logger.LogError("Mysql Error Additional Log Info:" + "\n Query String: " + queryString + "\n Connection state: " + conn.State + " \n Exeception Stacktrace : " + ex.StackTrace + " \n Exeception InnerException : " + ex.InnerException + " \n Exeception Message : " + ex.Message);
                throw ex;
            }
        }