Как обработать исключение Duplicate entry(MySql)

        public static long AddNewDocument(int typeId, string name, string description, string fileName)
        {
            try
            {
                MySqlConnection con = new MySqlConnection(connStr);
                con.Open();
                string sql = @"INSERT INTO document (type_id, name, description, filename) 
                        VALUES (" + typeId + ", '" + name + "', '" + description + "', '" + fileName + "');";
                MySqlCommand command = new MySqlCommand(sql, con);
                command.ExecuteNonQuery();
                con.Close();
                return command.LastInsertedId;
            }
            catch (InvalidCastException e)
            {
                MessageBox.Show(e.Message);
                return -1;
            }
        }

catch (Exception ex)
{
    Console.WriteLine("Commit Exception Type: {0}", ex.GetType());
    Console.WriteLine("  Message: {0}", ex.Message);
 
    // Attempt to roll back the transaction.
    try
    {
        transaction.Rollback();
    }
    catch (Exception ex2)
    {
        // This catch block will handle any errors that may have occurred
        // on the server that would cause the rollback to fail, such as
        // a closed connection.
        Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
        Console.WriteLine("  Message: {0}", ex2.Message);
    }
}

static public void AddContainer(int elementId, int count, int cellId, long operationId, string description)
{
    MySqlConnection con = new MySqlConnection(connStr);
    con.Open();
    MySqlTransaction transaction = con.BeginTransaction(IsolationLevel.ReadCommitted);
    MySqlCommand command1 = new MySqlCommand();
    MySqlCommand command2 = new MySqlCommand();
    try
    {
        string sql = "SELECT name+1 FROM container WHERE name = (SELECT max(name) FROM container);";
        command1 = new MySqlCommand(sql, con, transaction);
        string name = command1.ExecuteScalar().ToString();
        string sql1 = "INSERT INTO container (name, element_id, count, cell_id, operation_id, description) VALUES (" + name + ", " + elementId + ", " + count + ", " + cellId + ", '"+ operationId + "', '" + description + "');";
        command2 = new MySqlCommand(sql1, con, transaction);
        command2.ExecuteNonQuery();
        transaction.Commit();
    }
    catch (MySqlException mysqlEx)
    {
        try
        {
            transaction.Rollback();
        }
        catch (MySqlException mysqlEx2)
        {
            throw new ApplicationException(mysqlEx2.Message);
        }
        throw new ApplicationException(mysqlEx.Message);
    }
    catch (Exception e)
    {
        try
        {
            transaction.Rollback();
        }
        catch (MySqlException e2)
        {
            throw new ApplicationException(e2.Message);
        }
        throw new ApplicationException(e.Message);
    }
    finally
    {
        con.Close();
        command1.Dispose();
        command2.Dispose();
        transaction.Dispose();
        con.Dispose();
    }
}

        static public void AddContainer(int elementId, int count, int cellId, long operationId, string description)
        {
           var options = new TransactionOptions
           {
               IsolationLevel = IsolationLevel.ReadCommitted
           };
 
            using var scope = new TransactionScope(TransactionScopeOption.Required, options, TransactionScopeAsyncFlowOption.Enabled);
            using var con = new MySqlConnection(connStr);
            con.Open();
 
            var sql = "SELECT name+1 FROM container WHERE name = (SELECT max(name) FROM container);";
            var command1 = new MySqlCommand(sql, con, transaction);
            var name = command1.ExecuteScalar().ToString();
 
            var sql1 = "INSERT INTO container (name, element_id, count, cell_id, operation_id, description) VALUES (" + name + ", " + elementId + ", " + count + ", " + cellId + ", '"+ operationId + "', '" + description + "');";
 
            var command2 = new MySqlCommand(sql1, con, transaction);
            command2.ExecuteNonQuery();
 
            scope.Complete();
        }

static public void AddContainer(int elementId, int count, int cellId, long operationId, string description)
{
    MySqlConnection con = new MySqlConnection(connStr);
    con.Open();
    MySqlTransaction transaction = con.BeginTransaction(IsolationLevel.ReadCommitted);
    try
    {
        string name;
        using (MySqlCommand command1 = new MySqlCommand("SELECT name+1 FROM container WHERE name = (SELECT max(name) FROM container);", con, transaction))
        {
            name = command1.ExecuteScalar().ToString();
        }
        using (MySqlCommand command2 = new MySqlCommand("INSERT INTO container (name, element_id, count, cell_id, operation_id, description) VALUES (" + name + ", " + elementId + ", " + count + ", " + cellId + ", '" + operationId + "', '" + description + "');", con, transaction))
        {
            command2.ExecuteNonQuery();
        }
        transaction.Commit();
    }
    catch (Exception e)
    {
        try
        {
            transaction.Rollback();
        }
        catch (Exception e2)
        {
            throw new ApplicationException(e2.Message);
        }
        throw new ApplicationException(e.Message);
    }
    finally
    {
        con.Close();
        transaction.Dispose();
        con.Dispose();
    }
}

catch (SqlException sqlEx)
{
    throw new ApplicationException(string.Format("T-SQL #{0} - {1}", sqlEx.Number, sqlEx.Message));
}
catch (Exception ex)
{
    throw new ApplicationException(ex.Message);
}