javafun

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

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

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

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

How to check if product expired?

var publishedStateAssessor = ServiceLocator.Current.GetInstance<IPublishedStateAssessor>();
var isPublished = publishedStateAssessor.IsPublished(entryContent, PublishedStateCondition.None);

javafun

  <system.codedom>
    <compilers>
      <compiler language="c#;cs;csharp" extension=".cshtml" compilerOptions="/nowarn:1702" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" warningLevel="4">
        <providerOption name="CompilerVersion" value="v4.0" />
        <providerOption name="WarnAsError" value="false" />
      </compiler>      
    </compilers>
  </system.codedom>

javafun

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

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

	public static class AsyncHelpers
	{
		/// <summary>

javafun

-- 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

javafun

[ImplementPropertyType("slider")]
public IEnumerable<HomeSlider> Slider
{
    get
    {
        var archetypeModel = this.GetPropertyValue<ArchetypeModel>("slider");
        return archetypeModel.Select(x =>
            {
                return new HomeSlider()
                {