pedroinfo

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/11.9.0/styles/default.min.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/11.9.0/highlight.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/11.9.0/languages/vbscript.min.js"></script>
<script>hljs.highlightAll();</script>



<pre><code class="language-vbscript">
Sub HelloWorld()
    MsgBox "Hello from VBA!"

pedroinfo

<configuration>
  <system.web>
    <authorization>
      <allow users="*" />
    </authorization>
  </system.web>
  <system.webServer>
    <security>
      <authentication>
        <anonymousAuthentication enabled="true" />

pedroinfo

static string ExtrairValorEntreParenteses(string input)
    {
        var match = Regex.Match(input, @"\(([^)]*)\)");
        return match.Success ? match.Groups[1].Value : null;
    }

pedroinfo

Sub EnviarComCertificadoCliente()

    Dim http As Object
    Dim url As String
    Dim certSubject As String
    Dim json As String

    url = "https://sua-api.com/endpoint"
    certSubject = "CN=Nome do seu certificado"

pedroinfo

using Microsoft.AspNetCore.Authentication.Certificate;
using Microsoft.AspNetCore.Server.Kestrel.Https;
using System.Security.Claims;

var builder = WebApplication.CreateBuilder(args);

// Autenticação por certificado digital
builder.Services.AddAuthentication(CertificateAuthenticationDefaults.AuthenticationScheme)
    .AddCertificate(options =>
    {

pedroinfo

// -----------------------------
// TokenInfo.cs
// -----------------------------
public class TokenInfo
{
    public string Token { get; init; }
    public string Username { get; init; }
    public string IpAddress { get; init; }
    public DateTime Expiration { get; init; }
}

pedroinfo

using System;
using System.Diagnostics;
using System.Runtime.InteropServices;
using System.Threading;

public static class WindowHelper
{
    [DllImport("user32.dll")]
    private static extern bool SetForegroundWindow(IntPtr hWnd);

pedroinfo

SELECT 
    mr.contrato,
    mr.dt_inicio_vigencia_contrato AS dt_inicio_mf_receita,
    mr.vl_receita_total AS receita_mf_receita,
    mr.competencia AS competencia_mf_receita,
    mr2.dt_inicio_vigencia_contrato AS dt_inicio_mf_receita_202501,
    mr2.vl_receita_total AS receita_mf_receita_202501,
    mr2.competencia AS competencia_mf_receita_202501,
    CASE 
        WHEN mr.vl_receita_total = mr2.vl_receita_total THEN 'Iguais'

pedroinfo

public class ConfigReader
{
    private readonly string _configFilePath;

    // Constructor that initializes the config file path
    public ConfigReader(string configFilePath = "appsettings.json")
    {
        _configFilePath = configFilePath;
    }

pedroinfo

using System;
using System.IO;
using Newtonsoft.Json.Linq;

/// <summary>
/// Provides methods to retrieve connection strings and app settings from the appsettings.json file.
/// </summary>
public static class AppSettings
{
    private static readonly Lazy<JObject> _config = new Lazy<JObject>(LoadAppSettings);