This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Use MyDb | |
GO | |
DROP TABLE IF EXISTS Tb_Funcionario | |
CREATE TABLE Tb_Funcionario | |
( | |
Id INT NOT NULL, | |
Nome VARCHAR(200), | |
DataNascimento DATE, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
IF OBJECT_ID('tempdb..#Tb_Pessoa') IS NOT NULL | |
DROP TABLE #Tb_Pessoa | |
CREATE TABLE #Tb_Pessoa | |
( | |
Id INT, | |
Nome VARCHAR(100), | |
Estado VARCHAR(100) | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
IF OBJECT_ID('tempdb..#Personagens') IS NOT NULL DROP TABLE #Personagens | |
GO | |
CREATE TABLE #Personagens( | |
Id INT IDENTITY, | |
Nome VARCHAR(100), | |
Funcao VARCHAR(100) | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<style type="text/css"> | |
table, th, td { | |
border: 1px solid ; | |
width: 30% | |
} | |
</style> | |
<table id='table1'> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Ideias - Ajax | |
- Upload/Download de arquivos 1 ou N com barra de progresso. | |
- POST, GET, PUT, DELETE, PATCH - Enviar token, enviar cookie, autenticação, etc. | |
- Submit Form (FormData) | |
- jQuery [Uso do jQuery no Ajax / Ajax.Setup] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<div class="input-group date"> | |
<input type="text" asp-for="DataPlanejada" class="form-control datepicker-button autocomplete="off"> | |
<div class="input-group-append"> | |
<label class="input-group-text" asp-for="DataPlanejada"><i class="fa fa-calendar"></i></label> | |
</div> | |
</div> | |
$('.datepkr_ano, .input-group.ano datepkr_ano').datepicker({ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
static string Between(this string source, string left, string right) | |
{ | |
return Regex.Match( | |
source, | |
string.Format("{0}(.*){1}", left, right)) | |
.Groups[1].Value; | |
} | |
private static List<string> ExtractFromString(string source, string start, string end) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using FileHelpers; | |
using System; | |
using System.Collections.Generic; | |
using System.IO; | |
//Nuget: Install-Package FileHelpers | |
namespace Bingo | |
{ | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
USE myTestDB | |
GO | |
/****** Object: Table [HangFire].[AggregatedCounter] Script Date: 13/11/2020 14:16:04 ******/ | |
SET ANSI_NULLS ON | |
GO | |
SET QUOTED_IDENTIFIER ON | |
GO | |
CREATE TABLE [HangFire].[AggregatedCounter]( | |
[Key] [nvarchar](100) NOT NULL, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//https://stackoverflow.com/questions/8952003/how-does-hashset-compare-elements-for-equality | |
namespace HashSet | |
{ | |
public class Employe | |
{ | |
public Employe() { | |
} | |
public string Name { get; set; } |
NewerOlder