SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[FriendlyURLs](
     [contentID] [int] NOT NULL,
     [url] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

CONSTRAINT [PK_FriendlyURLs] PRIMARY KEY CLUSTERED
(
[contentID] ASC
)
WITH (
    PAD_INDEX = OFF,
    IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AliasURLs](
                [contentID] [int] NOT NULL,
                [url] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[GetContentIDByPrimaryURL]
        @url nvarchar(200)
AS
BEGIN
        SELECT contentID FROM FriendlyURLs WHERE url=@url
END

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[GetPrimaryURLByAlias]
    @aliasURL nvarchar(200)
AS
BEGIN
    SELECT url FROM FriendlyURLs WHERE contentID =
     (SELECT contentID FROM AliasURLs WHERE url = @aliasURL)
END
GO

<%@ Application Language="C#" %>

<script runat="server">

    void Application_BeginRequest(object sender, EventArgs e)
    {

    }

</script>

<%@ Application Language="C#" %>

<script runat="server">

    void Application_BeginRequest(object sender, EventArgs e)
    {
        HttpContext.Current.RewritePath("content.aspx?id=1", false);
    }

</script>

<%@ Application Language="C#" %>

<script runat="server">

    void Application_BeginRequest(object sender, EventArgs e)
    {
        var request = HttpContext.Current.Request.RawUrl.ToString().ToLower();

        // all excluded types should signal an exit from the rewrite pipeline
        if (Business.Rewrite.IsExcludedRequest(request)) return;

        HttpContext.Current.RewritePath("content.aspx?id=1", false);
    }

</script>

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

namespace Business
{
    public static class Rewrite
    {
        /// <summary>
        /// Checks incoming request against a list of excluded types
        /// </summary>
        /// <param name="request">the incoming request</param>
        /// <returns>true if the current request should be excluded</returns>
        public static bool IsExcludedRequest(string request)
        {
            if (request.Contains(".css") ||
                request.Contains(".js") ||
                request.Contains(".png") ||
                request.Contains(".gif") ||
                request.Contains(".bmp") ||
                request.Contains(".jpg") ||
                request.Contains(".jpeg") ||
                request.Contains(".mov") ||
                request.Contains(".ashx") ||
                request.Contains(".asmx"))
            {
                return true;
            }
            return false;
        }
    }
}

<%@ Application Language="C#" %>

<script runat="server">

    void Application_BeginRequest(object sender, EventArgs e)
    {
        var request = HttpContext.Current.Request.RawUrl.ToString().ToLower();
        int? contentID = null;

        // all excluded types should signal an exit from the rewrite pipeline
        if (Business.Rewrite.IsExcludedRequest(request)) return;

        // attempt to pull up a content ID by checking the primary URLs
        contentID = Business.Rewrite.GetIDByPrimaryURL(request);

        if (contentID != null) HttpContext.Current.RewritePath("content.aspx?id=" + contentID, false);
    }

</script>

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

namespace Business
{
    public static class Rewrite
    {
        /// <summary>
        /// Checks incoming request against a list of excluded types
        /// </summary>
        /// <param name="request">the incoming request</param>
        /// <returns>true if the current request should be excluded</returns>
        public static bool IsExcludedRequest(string request)
        {
            if (request.Contains(".css") ||
                request.Contains(".js") ||

request.Contains(".png") ||
                request.Contains(".gif") ||
                request.Contains(".bmp") ||
                request.Contains(".jpg") ||
                request.Contains(".jpeg") ||
                request.Contains(".mov") ||
                request.Contains(".ashx") ||
                request.Contains(".asmx"))
            {
                return true;
            }
            return false;
        }

        /// <summary>
        /// Attempts to pull up a content ID for an incoming friendly URL
        /// </summary>
        /// <param name="request">the incoming request</param>
        /// <returns>a nullable integer for the content ID if available</returns>
        public int? GetIDByPrimaryUrl(string request)
        {
            return Data.Rewrite.GetIDByPrimaryUrl(request);
        }
    }
}

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Data
{
    public static class Rewrite
    {
        /// <summary>
        /// Returns a content ID for a particular request
        /// </summary>
        /// <param name="request">the incoming request</param>
        /// <returns>a nullable content ID for the content if available</returns>
        public static int? GetIDByPrimaryUrl(string request)
        {
            int? contentID = null;

            using (var conn = Factory.GetConnection())

{
                var comm = Factory.GetCommand("GetContentIDByPrimaryURL");
                comm.CommandType = CommandType.StoredProcedure;
                comm.Parameters.AddWithValue("@url", request);

                try
                {
                    conn.Open();
                    var reader = comm.ExecuteReader();
                    if (reader.Read())
                    {
                        contentID = reader.GetInt32(0);
                    }
                    conn.Close();
                }
                finally
                {
                    conn.Close();
                }
            }

            return contentID;
        }
    }
}

<%@ Application Language="C#" %>

<script runat="server">

    void Application_BeginRequest(object sender, EventArgs e)
    {
        var request = HttpContext.Current.Request.RawUrl.ToString().ToLower();
        int? contentID = null;

        // all excluded types should signal an exit from the rewrite pipeline
        if (Business.Rewrite.IsExcludedRequest(request)) return;

        // attempt to pull up a content ID by checking the primary URLs
        contentID = Business.Rewrite.GetIDByPrimaryUrl(request);

        if (contentID != null) HttpContext.Current.RewritePath("/content.aspx?id=" + contentID, false);
    }

</script>

<%@ Application Language="C#" %>

<script runat="server">

    void Application_BeginRequest(object sender, EventArgs e)
    {
        var request = HttpContext.Current.Request.RawUrl.ToString().ToLower();
        int? contentID = null;
        string foundPrimaryViaAlias = String.Empty;

        // all excluded types should signal an exit from the rewrite pipeline
        if (Business.Rewrite.IsExcludedRequest(request)) return;

        // attempt to pull up a primary URL by checking aliases
        foundPrimaryViaAlias = Business.Rewrite.GetPrimaryUrlByAlias(request);

        // if we found a primary, indicating this was an alias, redirect to the primary
        if (!String.IsNullOrEmpty(foundPrimaryViaAlias))
        {
            Response.RedirectPermanent(foundPrimaryViaAlias);
        }

        // attempt to pull up a content ID by checking the primary URLs
        contentID = Business.Rewrite.GetIDByPrimaryUrl(request);

        if (contentID != null) HttpContext.Current.RewritePath("/content.aspx?id=" + contentID, false);
    }

</script>

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

namespace Business
{
    public static class Rewrite
    {
        /// <summary>
        /// Checks incoming request against a list of excluded types
        /// </summary>
        /// <param name="request">the incoming request</param>
        /// <returns>true if the current request should be excluded</returns>
        public static bool IsExcludedRequest(string request)
        {
            if (request.Contains(".css") ||
                request.Contains(".js") ||
                request.Contains(".png") ||
                request.Contains(".gif") ||
                request.Contains(".bmp") ||
                request.Contains(".jpg") ||
                request.Contains(".jpeg") ||
                request.Contains(".mov") ||
                request.Contains(".ashx") ||
                request.Contains(".asmx"))
            {
                return true;
            }
            return false;
        }

        /// <summary>
        /// Attempts to pull up a content ID for an incoming friendly URL
        /// </summary>
        /// <param name="request">the incoming request</param>
        /// <returns>a nullable integer for the content ID if available</returns>
        public static int? GetIDByPrimaryUrl(string request)
        {
            return Data.Rewrite.GetIDByPrimaryUrl(request);
        }

        /// <summary>
        ///  Attempts to pull up a primary URL based on an incoming alias
        /// </summary>
        /// <param name="request">the incoming request</param>

/// <returns>a primary URL string, if available</returns>
        public static string GetPrimaryUrlByAlias(string request)
        {
            return Data.Rewrite.GetPrimaryUrlByAlias(request);
        }
    }
}

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Data
{
    public static class Rewrite
    {
        /// <summary>
        /// Returns a content ID for a particular request
        /// </summary>
        /// <param name="request">the incoming request</param>
        /// <returns>a nullable content ID for the content if available</returns>
        public static int? GetIDByPrimaryUrl(string request)
        {
            int? contentID = null;

            using (var conn = Factory.GetConnection())
            {
                var comm = Factory.GetCommand("GetContentIDByPrimaryURL");
                comm.CommandType = CommandType.StoredProcedure;
                comm.Parameters.AddWithValue("@url", request);

                try
                {
                    conn.Open();
                    var reader = comm.ExecuteReader();
                    if (reader.Read())
                    {
                        contentID = reader.GetInt32(0);
                    }
                    conn.Close();
                }
                finally
                {

conn.Close();
                }
            }

            return contentID;
        }

        /// <summary>
        ///  Attempts to pull up a primary URL based on an incoming alias
        /// </summary>
        /// <param name="request">the incoming request</param>
        /// <returns>a primary URL string, if available</returns>
        public static string GetPrimaryUrlByAlias(string request)
        {
            string primaryURL = String.Empty;

            using (var conn = Factory.GetConnection())
            {
                var comm = Factory.GetCommand("GetPrimaryURLByAlias");
                comm.CommandType = CommandType.StoredProcedure;
                comm.Parameters.AddWithValue("@aliasUrl", request);

                try
                {
                    conn.Open();
                    var reader = comm.ExecuteReader();
                    if (reader.Read())
                    {
                        primaryURL = reader.GetString(0);
                    }
                    conn.Close();
                }
                finally
                {
                    conn.Close();
                }
            }

            return primaryURL;
        }
    }
}