public static void InsertMysqlSubMechanismType()
        {
            ConectarTedef();
            string          query         = "select * from ts_submecanismopago where flag = '0' order by codigosubmecanismopago";
            OleDbCommand    commandselect = new OleDbCommand(query, Conex);
            OleDbDataReader reader        = commandselect.ExecuteReader();

            ConnectionMySQL.Connect();
            while (reader.Read())
            {
                ConnectionMySQL.InsertSubMechanismType(reader.GetString(0), reader.GetString(1), reader.GetString(2));
                UpdateAfterInsert("ts_submecanismopago", "codigosubmecanismopago", 1, reader);
            }
            ConnectionMySQL.Disconnect();
            FinalMessage();
        }