Skip to content

Instantly share code, notes, and snippets.

View shammelburg's full-sized avatar

Sander Hammelburg shammelburg

33 followers · 4 following
View GitHub Profile
@shammelburg
shammelburg / Dockerfile
Created May 12, 2021 09:58
.devcontainer angular configuration
# See here for image contents: https://github.com/microsoft/vscode-dev-containers/tree/v0.177.0/containers/javascript-node/.devcontainer/base.Dockerfile
# [Choice] Node.js version: 16, 14, 12
ARG VARIANT="16-buster"
FROM mcr.microsoft.com/vscode/devcontainers/javascript-node:0-${VARIANT}
# [Optional] Uncomment this section to install additional OS packages.
# RUN apt-get update && export DEBIAN_FRONTEND=noninteractive \
# && apt-get -y install --no-install-recommends <your-package-list-here>
@shammelburg
shammelburg / test.html
Created December 28, 2024 18:22
Hello World Html
<html>
<head>
<style>
h1 {
font-family: Calibri;
}
</style>
</head>
<body>
<h1>Hello World!</h1>
@shammelburg
shammelburg / test.md
Created December 28, 2024 18:21
Hello World Markdown

Hello World

This is content converted from Markdown!

Here's a JSON sample:

{
  "foo": "bar"
}
@shammelburg
shammelburg / angular-url-rewrite.txt
Last active April 2, 2024 10:14
Angular URL Rewrite for web.config
<system.webServer>
<rewrite>
<rules>
<rule name="AngularJS Routes" stopProcessing="true">
<match url=".*" />
<conditions logicalGrouping="MatchAll">
<add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
<add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" />
<add input="{REQUEST_URI}" pattern="^/(api)" negate="true" />
</conditions>
@shammelburg
shammelburg / zip-files-using-ionic
Created November 26, 2015 21:42
Ionic Zip
using Ionic.Zip;
[HttpPost]
public void ZipFiles(FormCollection collection)
{
using (ZipFile zip = new ZipFile())
{
zip.AlternateEncodingUsage = ZipOption.AsNecessary;
var file_collection = _repository.GetListOfFiles();
@shammelburg
shammelburg / udt.cs
Last active April 5, 2022 18:05
Passing UDT into SP using EF Core
//https://forums.asp.net/t/2071573.aspx?Call+SQL+Server+Function+with+UDT+as+input+parameter
public async Task<int> MainCategorySort(int BrandId, IEnumerable<MainCategoryViewModel> vm, string ModifiedBy)
{
var udt = new DataTable();
udt.Columns.Add("MainCategoryId", typeof(int));
udt.Columns.Add("CMSOrder", typeof(int));
foreach(var item in vm)
@shammelburg
shammelburg / app.component.html
Last active January 28, 2022 18:58
Pagination Component with Angular
<div class="card">
<div class="card-body">
<app-pagination #pagination [collectionSize]="tableContent.length" [pageSize]="10" [firstLastButtons]="true" [maxSize]="2">
</app-pagination>
<table class="table table-sm">
<tbody>
<tr
*ngFor="let t of tableContent | slice : (pagination.currentPage - 1) * pagination.pageSize : pagination.currentPage * pagination.pageSize">
<td>{{ t.name }}</td>
@shammelburg
shammelburg / auth-middleware.js
Last active December 8, 2021 17:13
express-graphql-api
const jwt = require('jsonwebtoken');
const authMiddleware = (req, res, next) => {
const authHeader = req.get('Authorization')
if (!authHeader) {
req.error = "No authentication header found."
req.isAuth = false
return next()
}
@shammelburg
shammelburg / index.js
Last active March 17, 2021 14:53
SendGrid Inbound Parse with Express
const express = require('express')
const multer = require('multer')
const app = express()
const upload = multer()
app.post('/api/parse', upload.any(), async (req, res) => {
const body = req.body
@shammelburg
shammelburg / truncate-all.sql
Created November 9, 2020 09:05
Truncate all tables in Azure SQL Database
DECLARE @SQL varchar(max)
SET @SQL = (SELECT ' TRUNCATE TABLE [' + TABLE_SCHEMA +'].['+ TABLE_NAME + '];'
FROM INFORMATION_SCHEMA.TABLES
ORDER BY TABLE_SCHEMA DESC
FOR XML PATH(''))
-- Print Statement
-- SELECT @SQL