When building a method that returns IEnumerable, you can use the yield keyword to return results one at a time, rather than returning a full […]
Queue and Stack in javascript
Using basic array functions, you can treat an array as a queue (first in first out) or a stack (last in first out): To act […]
Handlebars in NodeJS
“use strict”; (function() { const handlebars = require(“handlebars”); const source = “{{ “{{” }}title}}\n” + “Hello {{ “{{” }}person.name}}, I see that you are {{ […]
AJAX in Angular
Regular GET/POST $http({ method: “POST”, url: “someUrl”, headers: { “Content-Type”: “application/json; charset=utf-8” }, data: JSON.stringify({ name: “John Doe” })}).then(function(response) { console.log(“Successful response: ” + response);}, […]
Add timestamp to photo using ImageMagick
rem dptnt.com/2009/04/how-to-add-date-time-stamp-to-jpeg-photos-using-free-software/ @ECHO OFFSETLOCALFOR /R %%G IN (*.jpg) DO CALL :process “%%G”GOTO :end :process SET _inname=%1 identify -format %%w %_inname% >dttmpfile set /p width=<dttmpfile Set […]
View Job History in SQL Server
create procedure util.ViewJobHistory( @ExecutionDate date = null ,@JobName sysname = null)asbegin declare @executionDateInt int; set @executionDateInt = year(@ExecutionDate) * 10000 + month(@ExecutionDate) * 100 + […]
Type-safe JSON result in ASP.NET MVC
public abstract class BaseController : Controller { protected internal JsonResult<T> Json<T>(T data) { return Json(data, null /* contentType */, null /* contentEncoding */, JsonRequestBehavior.DenyGet); } […]
SQL Server Flatten and Unflatten
Assuming you have a table type named SingleColumnText which contains (obviously) a single column of text, named [TextValue]: create function util.Flatten( @input util.SingleColumnText readonly ,@delimiter […]
Shrink image with ImageMagick
@ECHO OFFSETLOCALFOR /R %%G IN (*.jpg) DO CALL :process “%%G”GOTO :end :process SET _inname=%1 SET _outname=%_inname:~0,-5%_1024.jpg” identify -format %%w %_inname% >width.txt identify -format %%h %_inname% […]
Replace alert with SweetAlert
SweetAlert is a nice simple solution for displaying alert messages. Here’s the basic way to replace the built-in alert, so you don’t have to use […]