emmanueltissera

@functions {
    public static string TrackThisPage()
    {
        if (Request.QueryString["ignoreGTM"] != null && Request.QueryString["ignoreGTM"] == "false")
        {
            return "true";
        }
        else if ((Request.Cookies["ignorePageViews"] != null && Request.Cookies["ignorePageViews"].Value == "true") ||
            (Request.QueryString["ignoreGTM"] != null && Request.QueryString["ignoreGTM"] == "true") ||
            Request.Path.EndsWith("ignore", StringComparison.InvariantCultureIgnoreCase) ||

emmanueltissera

<!-- Google Tag Manager -->
<noscript><iframe src="//www.googletagmanager.com/ns.html?id=GTM-XXXXXX"
height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>
<script>dataLayer = [{'trackThisPage': '@HelperFunctions.TrackThisPage()'}];
(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':
new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=
'//www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);
})(window,document,'script','dataLayer','GTM-XXXXXX');</script>
<!-- End Google Tag Manager -->

emmanueltissera

-- INSTRUCTIONS:
-- 1. Replace custom_database with the actual database name (Use a replace all on custom_database)
-- 2. Change @BackUpFileName to the actual location
-- 3. Change parameters for @DbUser & @LoginPassword

-- ============================
-- Restore [custom_database]
-- ============================
DECLARE @BackUpFileName varchar(100), @DbUser varchar(100), @LoginPassword varchar(100);

emmanueltissera

ALTER PROCEDURE getNodes
  @isActive bit
AS
  BEGIN
    -- Declare a single column table to be used as a single dimension array
    DECLARE @activeNodes TABLE (id int)
    
    -- Only if the following condition is satisfied, 1070 will be added to the pseudo-array
    IF @isActive = 1
      INSERT INTO @activeNodes(id) VALUES (1070)

emmanueltissera

CREATE PROCEDURE getNodes
  @isActive bit
AS
  BEGIN
    -- Declare a single column table to be used as a single dimension array
    DECLARE @activeNodes TABLE (id int)
    
    -- Only if the following condition is satisfied, 1070 will be added to the pseudo-array
    IF @isActive = 1
      INSERT INTO @activeNodes(id) VALUES (1070)

emmanueltissera

<system.webServer>
  <defaultDocument>
    <files>
      <add value="default.aspx" />
    </files>
  </defaultDocument>    
</system.webServer>

emmanueltissera

  <!--Original setting-->
  <section name="handlers" overrideModeDefault="Deny" />
  <section name="modules" allowDefinition="MachineToApplication" overrideModeDefault="Deny" />
  <!--Modified setting-->
  <section name="handlers" overrideModeDefault="Allow" />
  <section name="modules" allowDefinition="MachineToApplication" overrideModeDefault="Allow" />

emmanueltissera

// HelloGist.cs
using System;

public class HelloGist
{
   public static void Main()
   {
      Console.WriteLine("Hello, Gist!");
   }
}