Skip to content

Instantly share code, notes, and snippets.

View pedroinfo's full-sized avatar

Pedro Xavier pedroinfo

  • São Paulo - BR - Solar System | Milky Way
View GitHub Profile
@pedroinfo
pedroinfo / table.html
Created January 28, 2022 16:17
html table to JS array
<style type="text/css">
table, th, td {
border: 1px solid ;
width: 30%
}
</style>
<table id='table1'>
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]
<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({
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)
using FileHelpers;
using System;
using System.Collections.Generic;
using System.IO;
//Nuget: Install-Package FileHelpers
namespace Bingo
{
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,
//https://stackoverflow.com/questions/8952003/how-does-hashset-compare-elements-for-equality
namespace HashSet
{
public class Employe
{
public Employe() {
}
public string Name { get; set; }
@pedroinfo
pedroinfo / XmlFilter.sql
Created June 26, 2020 02:27
Example Xml List + Where
IF Object_id('produto_xml_exemplo') IS NOT NULL
DROP TABLE produto_xml_exemplo
CREATE TABLE produto_xml_exemplo
(
produtoid INT PRIMARY KEY IDENTITY(1, 1),
nome VARCHAR(100) NOT NULL,
descricao VARCHAR(100) NOT NULL,
quantidade INT NOT NULL,
@pedroinfo
pedroinfo / CursorWithTempTable.sql
Created June 26, 2020 01:58
Cursor + Temp Table - SQL Server
IF Object_id('produto_cursor_exemplo') IS NOT NULL
DROP TABLE produto_cursor_exemplo
CREATE TABLE produto_cursor_exemplo
(
produtoid INT PRIMARY KEY IDENTITY(1, 1),
nome VARCHAR(100) NOT NULL,
descricao VARCHAR(100) NOT NULL,
quantidade INT NOT NULL,
@pedroinfo
pedroinfo / Default.aspx
Created September 6, 2019 02:30
Upload Files ASP.NET WebForms + Ajax
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="FileUploadWebForms.Default" %>
<!DOCTYPE html>
<html>
<head runat="server">
<title></title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
</head>
<body>