How do I get a procedure return to see if it has any affected row?

My question is whether you had any affected strings in executing this procedure and store the result in a variable of type int .

If it is = 0 , stop the process.

If it is > 0 , proceed with the process.

I have the following codes:

Controller:

   public void InserirSaldoBonusExtrato(PCINET.pciPedidos.PedidoVenda pedido)
        {
            try
            {
                Extrato extrato = new Extrato(config);
                extrato.Cliente = pedido.PedCliente;
                extrato.Valor = pedido.PedValor;
                extrato.Ciclo = pedido.PedCiclo;
                extrato.TpOperCodigo = 9;
                extrato.TpOperNome = "Pgtopedido";
                extrato.Descricao = "Pagamento do pedido " + pedido.PedNumero + " com bônus";
                extrato.Indicante = 0;
                extrato.Pendente = "N";
                extrato.InserirSaldoBonusExtrato();
            }
            catch (Exception ex)
            {

                throw ex;
            }
        }

Model:

 public void InserirSaldoBonusExtrato()
    {
        try
        {
            new ExtratoDB(config).InserirSaldoBonus(this);
        }
        catch (Exception ex)
        {

            throw ex;
        }
    }

Dapper (date):

   public void InserirSaldoBonus(Extrato extrato)
    {

        try
        {
            var db = new Data<Extrato>(config);
            string query = @"sp_InsereSaldoBonusExtrato @Cliente, @Valor, @Ciclo, @TpOperCodigo, @TpOperNome, @Descricao, @Indicante, @Pendente";
            db.Executar(query, extrato);

        }
        catch (Exception ex)
        {

            throw ex;
        }
    }