javafun’s gists

javafun / DependencyResolverInitialization.cs

Created July 26, 2019 11:56 — forked from joseftw/DependencyResolverInitialization.cs

Support for "injecting" AllowedTypes in EPiServer when ContentTypes doesn't know about each other. Raw

	using System.Web.Mvc;
	using EPiServer.DataAbstraction.RuntimeModel;
	using EPiServer.Framework;
	using EPiServer.Framework.Initialization;
	using EPiServer.ServiceLocation;
	using ModularAllowedTypes.Business.Rendering;
	using EPiServer.Web.Mvc;
	using EPiServer.Web.Mvc.Html;
	using StructureMap;

javafun / FindExtensions.cs

Created June 23, 2019 23:30 — forked from jstemerdink/FindExtensions.cs

	namespace EPiServer.SocialAlloy.Web.Business.FindHelpers
	{
	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Linq.Expressions;
	using System.Reflection;

	using EPiServer.Core;
	using EPiServer.Find;

javafun / FindExceptionInterceptor.cs

Created June 23, 2019 23:28 — forked from jstemerdink/FindExceptionInterceptor.cs

	public class FindExceptionInterceptor : IInterceptor
	{
	public void Intercept(IInvocation invocation)
	{
	try
	{
	invocation.Proceed();
	}
	catch (ClientException)
	{

javafun / ImportScheduledJob.cs

Created June 23, 2019 23:27 — forked from jstemerdink/ImportScheduledJob.cs

	using System.Collections.Generic;
	using System.Linq;

	using EPiServer.Commerce.Catalog.ContentTypes;
	using EPiServer.Core;
	using EPiServer.Find;
	using EPiServer.Find.Cms;
	using EPiServer.PlugIn;
	using EPiServer.Scheduler;
	using EPiServer.ServiceLocation;

javafun / UmbracoMembershipAPI snippets.cs

Created June 16, 2019 06:29

A bunch of Umbraco Membership API snippets

	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Web.Security.
	using Umbraco.Core.Services;
	using Umbraco.Web.Models;
	using Umbraco.Web.PublishedCache;

	/*
	*

javafun / rebuild_index.sql

Created June 6, 2019 23:36 — forked from kshimi/rebuild_index.sql

SQLServer rebuild index

	DECLARE @SchemaName sysname, @TableName sysname, @IndexName sysname
	DECLARE @basesql nvarchar(max), @sql nvarchar(max)

	SET @basesql = 'ALTER INDEX @1 On @2 REBUILD WITH ( FILLFACTOR = 50 ) '

	DECLARE IXC CURSOR FOR
	SELECT
	OBJECT_SCHEMA_NAME(i.object_id) As SchemaName
	, OBJECT_NAME(i.object_id) AS TableName
	, i.name AS IndexName

javafun / rebuildIndexes.sql

Created June 6, 2019 23:36 — forked from richardbasile/rebuildIndexes.sql

SQL Server - Rebuild Indexes

	BEGIN
	set quoted_identifier on

	DECLARE @db varchar(max) = 'MyDB'
	DECLARE @today VARCHAR(9) = datename(w,sysdatetime())

	DECLARE @tableName varchar(max)
	DECLARE @indexName varchar(max)
	DECLARE @sql Nvarchar(max)

javafun / power-query-pagination.m

Created April 4, 2019 04:40 — forked from MarkTiedemann/power-query-pagination.m

Power Query Pagination Example

	let
	BaseUrl = "https://fake-odata-api.com/v1/Entities?",
	Token = "F4K3-T0K3N-D0NT-U5E-L0L",
	EntitiesPerPage = 1000,

	GetJson = (Url) =>
	let Options = [Headers=[ #"Authorization" = "Bearer " & Token ]],
	RawData = Web.Contents(Url, Options),
	Json = Json.Document(RawData)
	in Json,

javafun / AsyncHelper.cs

Created April 1, 2019 04:38 — forked from ChrisMcKee/AsyncHelper.cs

AsyncHelpers to simplify calling of Async/Task methods from synchronous context.

	namespace My.Common
	{
	using System;
	using System.Collections.Generic;
	using System.Threading;
	using System.Threading.Tasks;

	public static class AsyncHelpers
	{
	/// <summary>

javafun / DeleteAllVersions.sql

Created January 5, 2019 12:21 — forked from Hendy/DeleteAllVersions.sql

Umbraco - delete version history for all content

	-- Create a temporary table for all documents which are published and not in the recycle bin
	CREATE TABLE #Nodes (id int)
	-- Delete all rows if the table exists before
	TRUNCATE TABLE #Nodes

	-- Insert all nodeIds from all documents which are published and not in the recycle bin
	INSERT INTO #Nodes
	SELECT N.id
	FROM umbracoNode N
	INNER JOIN cmsDocument D ON N.ID = D.NodeId

Vincent javafun