Muhammad Umair Irshad umair-me

## mock.cs
Mock<IConfiguration> configuration = new Mock<IConfiguration>();
configuration.Setup(c => c.GetSection(It.IsAny<String>())).Returns(new Mock<IConfigurationSection>().Object);

## gist:fceeaa222558547c2bff9b587d31d46a
cd path/to/project-b
git remote add project-a path/to/project-a
git fetch project-a
git merge --allow-unrelated-histories project-a/master # or whichever branch you want to merge
git remote remove project-a

## HostedService.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading;
using System.Threading.Tasks;
using Microsoft.Extensions.Hosting;

namespace WebApplication24
{
    public abstract class HostedService : IHostedService

## delete _old_records.sql
--This assumes 24 hours to the minute:
DELETE
    MyTableWhere
WHERE
    MyColumn < DATEADD(day, -1, GETDATE())


--This assumes yesterday midnight:
DELETE

## drop_all.sql
/* Drop all non-system stored procs */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])

WHILE @name is not null
BEGIN
    SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'
    EXEC (@SQL)

## ngrok.cmd
ngrok http -host-header=localhost 5000

## enum_as_string.cs
[Column(TypeName = "nvarchar(24)")]
public SomeEnum Name { get; set; }

## current_domain_url.cs
String strPathAndQuery = HttpContext.Current.Request.Url.PathAndQuery;
String strUrl = HttpContext.Current.Request.Url.AbsoluteUri.Replace(strPathAndQuery, "/");

// OR

Request.Url.GetLeftPart(UriPartial.Authority)
// https://stackoverflow.com/a/10337955/1158845

// OR


## context.cs
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    foreach (var relationship in modelBuilder.Model.GetEntityTypes().SelectMany(e => e.GetForeignKeys()))
        relationship.DeleteBehavior = DeleteBehavior.Restrict;
}

## javascript_app.js
// More details: https://addyosmani.com/resources/essentialjsdesignpatterns/book/#revealingmodulepatternjavascript
// https://stackoverflow.com/a/7513721
var JsApp = (function() {

    function callback() {
        alert("done");
    };

    return {
        callbackAlert: callback
	Mock<IConfiguration> configuration = new Mock<IConfiguration>();
	configuration.Setup(c => c.GetSection(It.IsAny<String>())).Returns(new Mock<IConfigurationSection>().Object);
	cd path/to/project-b
	git remote add project-a path/to/project-a
	git fetch project-a
	git merge --allow-unrelated-histories project-a/master # or whichever branch you want to merge
	git remote remove project-a
	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Threading;
	using System.Threading.Tasks;
	using Microsoft.Extensions.Hosting;

	namespace WebApplication24
	{
	public abstract class HostedService : IHostedService
	/* Drop all non-system stored procs */
	DECLARE @name VARCHAR(128)
	DECLARE @SQL VARCHAR(254)

	SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])

	WHILE @name is not null
	BEGIN
	SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'
	EXEC (@SQL)
	[Column(TypeName = "nvarchar(24)")]
	public SomeEnum Name { get; set; }
	String strPathAndQuery = HttpContext.Current.Request.Url.PathAndQuery;
	String strUrl = HttpContext.Current.Request.Url.AbsoluteUri.Replace(strPathAndQuery, "/");

	// OR

	Request.Url.GetLeftPart(UriPartial.Authority)
	// https://stackoverflow.com/a/10337955/1158845

	// OR
	// More details: https://addyosmani.com/resources/essentialjsdesignpatterns/book/#revealingmodulepatternjavascript
	// https://stackoverflow.com/a/7513721
	var JsApp = (function() {

	function callback() {
	alert("done");
	};

	return {
	callbackAlert: callback