ycaroafonso

{
  "version": "1.0",
  "defaultProvider": "cdnjs",
  "libraries": [
    {
      "library": "bootstrap@5.3.2",
      "destination": "wwwroot/lib/bootstrap/"
    },
    {
      "library": "fullcalendar@6.1.10",

ycaroafonso

# 20220915 Ycaro Afonso

$dirPackages = Join-Path -Path (Get-Location) -ChildPath 'packages'
[String[]]$dirXml = @()

foreach ($arqSln in (Get-ChildItem -Path .\* -Include *.sln)){
    $sln = Get-Content $arqSln
    [String[]]$dirXml += [regex]::matches($sln, '"([^"]*).csproj"').value.replace('"','')
}

ycaroafonso

jQuery(document).ready(function () {
    jQuery(".mascaracpf").mask("999.999.999-99");
    jQuery(".mascaracnpj").mask("99.999.999/9999-99");
    jQuery('.mascaratelefonefixo').mask("(99) 9999-9999");
    jQuery(".mascaracep").mask("99.999-999");
    jQuery(".mascaradecimalavulso").maskMoney({
        allowNegative: true, thousands: "", decimal: ",", affixesStay: false, allowZero: true
    });

ycaroafonso

// A regex abaixo contém possibilidades de idiomas abreviados com exceção do "pt-br"
$regex = "^(af|ar|az|bg|bn|bs|ca|cs|cy|da|de-ch|de|el|en-au|en-ca|en-gb|en|eo|es|et|eu|fa|fi|fo|fr-ca|fr|gl|gu|he|hi|hr|hu|id|is|it|ja|ka|km|ko|ku|lt|lv|mk|mn|ms|nb|nl|no|oc|pl|pt|ro|ru|si|sk|sl|sq|sr-latn|sr|sv|th|tr|tt|ug|uk|vi|zh-cn|zh).js$"
Get-ChildItem -Filter '*.js' -Recurse | Where-Object { $_.Name -match $regex } | Remove-Item

ycaroafonso

Imports System.Data
Imports System.Data.SqlClient

Partial Class _Default
    Inherits System.Web.UI.Page

    ''' 

    ''' Armazena as ID's em uma viewstate
    ''' 

ycaroafonso

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

ycaroafonso

-- Por Ycaro Afonso
-- 2016-03-05
-- Entity Framework mapping generator for MySQL
DROP TABLE IF EXISTS gis.fw_vw_framework_column;
DROP TABLE IF EXISTS gis.fw_vw_framework_constraint;
DROP TABLE IF EXISTS gis.fw_vw_framework_custom_constraint_item_unico; 
DROP TABLE IF EXISTS gis.fw_vw_framework_mapeamento_entity_model_builder;
DROP TABLE IF EXISTS gis.fw_vw_framework_mapeamento_entity_propriedades;
DROP TABLE IF EXISTS gis.fw_vw_framework_mapeamento_entity_propriedades_com_filhos;
DROP TABLE IF EXISTS gis.fw_vw_framework_table;

ycaroafonso

DECLARE @NomeProcedure VARCHAR(200)= 'Nome da Tabela',
    @NomeSchema VARCHAR(200)= 'dbo'

DECLARE @SqlProcedure VARCHAR(MAX)= '',
    @Sql VARCHAR(MAX)= ''
SELECT  @SqlProcedure += ', ' + PARAMETER_NAME + ' = ' + CASE DATA_TYPE
                                                           WHEN 'datetime'
                                                           THEN '''' + CONVERT(VARCHAR(10), GETDATE(), 120) + ''''
                                                           WHEN 'int' THEN '0'
                                                           ELSE 'NULL'

ycaroafonso

DECLARE @Tabela VARCHAR(200) = 'Nome da Tabela',
    @TABLE_SCHEMA VARCHAR(200)= 'dbo'
-- Por Ycaro Afonso 2015-06-07
/*
DROP TABLE #VW_FRAMEWORK_COLUMN
DROP TABLE #VW_FRAMEWORK_TABLE
DROP TABLE #VW_FRAMEWORK_CUSTOM_CONSTRAINT_ITEM_UNICO
DROP TABLE #VW_FRAMEWORK_CONSTRAINT
DROP TABLE #VW_FRAMEWORK_MAPEAMENTO_ENTITY_PROPRIEDADES
DROP TABLE #VW_FRAMEWORK_MAPEAMENTO_ENTITY_PROPRIEDADES_COM_FILHOS

ycaroafonso

ALTER FUNCTION dbo.Convert_DDMMYY_To_DateTime (@DiaMesAno INT)
RETURNS DATETIME
AS
BEGIN
-- Ycaro Afonso (2015-04-19)
	DECLARE @Data VARCHAR(20) = STUFF(STUFF(@DiaMesAno, 3, 0, '/'), 6, 0, '/')
	
	RETURN CONVERT(DATETIME, @Data, 3)
END
GO