Distinct List Function Using SQL

Distinct List Function Using SQL 



CREATE FUNCTION dbo.DistinctList
(
@List VARCHAR(MAX),
@Delim CHAR
)
RETURNS
VARCHAR(MAX)
AS
BEGIN
DECLARE @ParsedList TABLE
(
Item VARCHAR(MAX)
)
DECLARE @list1 VARCHAR(MAX), @Pos INT, @rList VARCHAR(MAX)
SET @list = LTRIM(RTRIM(@list)) + @Delim
SET @pos = CHARINDEX(@delim, @list, 1)
WHILE @pos > 0
BEGIN
SET @list1 = LTRIM(RTRIM(LEFT(@list, @pos - 1)))
IF @list1 <> ''
INSERT INTO @ParsedList VALUES (CAST(@list1 AS VARCHAR(MAX)))
SET @list = SUBSTRING(@list, @pos+1, LEN(@list))
SET @pos = CHARINDEX(@delim, @list, 1)
END
SELECT @rlist = COALESCE(@rlist+',','') + item
FROM (SELECT DISTINCT Item FROM @ParsedList) t
RETURN @rlist
END

GO

Input : SELECT dbo.DistinctList('ashish,ashish,manish',',')

output: ashish,manish

Website Performance with ASP.NET - Use Cache Headers (HttpModule CacheHeader define)

Setting Header Programatically

You can also set the cache headers programmatically. This can be useful for generated content and allows more fine granular and flexible control of the cache headers. The example below allows clients as well as proxies to cache all responses for one hour. You can of course use different settings depending on any parameter/content/config value etc.

using System;
using System.Web;
using System.Web.UI;
using System.Web.Configuration;
using System.Text;
using System.Security.Cryptography;
using System.IO;
public class PreInitModule : IHttpModule
{
public void Init(HttpApplication context)
    {
     
        context.PreRequestHandlerExecute += HandlePreRequest;
    }
    private void SetDefaultCacheHeader(object sender, EventArgs eventArgs)
    {
        HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.Public);
        HttpContext.Current.Response.Cache.SetMaxAge(TimeSpan.FromSeconds(3600));
        HttpContext.Current.Response.Cache.SetExpires(DateTime.UtcNow.AddSeconds(3600));
    }
}


Web.config


 <system.web>

  <httpModules>
      <add name="MyPreInitModule" type="PreInitModule" />
   
    </httpModules>
 
  </system.web>

<system.webServer>
<modules runAllManagedModulesForAllRequests="true">
   
      <add name="MyPreInitModule" type="PreInitModule" />
    </modules>
  <staticContent>
      <clientCache cacheControlMode="UseMaxAge" cacheControlMaxAge="7.00:00:00" />
      <mimeMap fileExtension=".otf" mimeType="application/x-font-opentype" />
      <mimeMap fileExtension=".woff" mimeType="application/font-woff" />
      <mimeMap fileExtension=".woff2" mimeType="application/font-woff2" />
     
    </staticContent>
    <caching enabled="true" enableKernelCache="true">
      <profiles>

        <add extension=".png" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" />
        <add extension=".jpg" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" />
        <add extension=".jpeg" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" />
        <add extension=".gif" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" />
        <add extension=".css" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" />
        <add extension=".js" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" />
        <add extension=".pdf" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" />
        <add extension=".ico" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" />
        <add extension=".woff2" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" />
        <add extension=".eot" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" />
        <add extension=".ttf" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" />
      </profiles>
    </caching>
  </system.webServer>

asp.net MVC HttpModule example

1)  First Create SessionManger class
using System.Web;
using System.Collections.Generic;
namespace ManageSession
{
    public class SessionManger
    {
       

        public static int AdminID
        {
            get
            {
             
                    return (int)System.Web.HttpContext.Current.Session["AdminID"];
             
            }
            set { System.Web.HttpContext.Current.Session["AdminID"] = value; }
        }
        public static int UserType
        {
            get
            {

                return (int)System.Web.HttpContext.Current.Session["UserType"];

            }
            set { System.Web.HttpContext.Current.Session["UserType"] = value; }
        }
        public static int CompanyID
        {
            get
            {

                return (int)System.Web.HttpContext.Current.Session["CompanyID"];

            }
            set { System.Web.HttpContext.Current.Session["CompanyID"] = value; }
        }
        public static string UserTheme
        {
            get
            {

                return (string)System.Web.HttpContext.Current.Session["UserTheme"];

            }
            set { System.Web.HttpContext.Current.Session["UserTheme"] = value; }
        }
        public static int BranchID
        {
            get
            {

                return (int)System.Web.HttpContext.Current.Session["BranchID"];

            }
            set { System.Web.HttpContext.Current.Session["BranchID"] = value; }
        }
    }
}

2) PreInitModule class 

using System;

using System.Web;

using System.Web.UI;

using System.Web.Configuration;

using System.Text;

using System.Security.Cryptography;

using System.IO;

/// <summary>

/// Ashish Srivastava

/// 21 Sep 2017

/// 

/// </summary>

public class PreInitModule : IHttpModule

{

    #region IHttpModule Members

    public void Dispose()

    {

        //throw new NotImplementedException();

    }

    public void Init(HttpApplication context)

    {

        context.PreRequestHandlerExecute += HandlePreRequest;

    }

    void HandlePreRequest(object sender, EventArgs e)

    {

        var page = HttpContext.Current.CurrentHandler as System.Web.Mvc.MvcHandler;

        if (page != null)

        {

            //page.PreInit += delegate

            //{

                if (HttpContext.Current.Request.Path.ToLower().Contains("/admin/"))

                {

                if (HttpContext.Current.Session["AdminID"] != null)

                {

                    if (HttpContext.Current.Session["CompanyID"] != null)

                    {

                        if (HttpContext.Current.Session["BranchID"] != null) return;

                        var loginPageBranch = WebConfigurationManager.AppSettings["LoginPagePath"] ?? "~/Admin/Branch";

                        if (HttpContext.Current.Request.Path.Contains(loginPageBranch.Substring(loginPageBranch.LastIndexOf("/") + 1)) == false

                              && HttpContext.Current.Request.Path.Contains("Branch") == false

                              && HttpContext.Current.Request.Path.Contains("BillingCompanyReport.aspx") == false

                            && HttpContext.Current.Request.Path.Contains("UserCompanyMapping.aspx") == false

                            && HttpContext.Current.Request.Path.Contains("AddCompany.aspx") == false

                            && HttpContext.Current.Request.Path.Contains("AddBranch.aspx") == false

                            && HttpContext.Current.Request.Path.Contains("InvoceHeadSettings.aspx") == false

                       //&& HttpContext.Current.Request.Path.Contains("ForgetPassword.aspx") == false

                       )

                        {

                            HttpContext.Current.Response.Redirect(loginPageBranch, true);

                        }

                        else

                        {

                            return;

                        }

                    }

                    var loginPageCompany = WebConfigurationManager.AppSettings["LoginPagePath"] ?? "~/Admin/Company";

                    if (HttpContext.Current.Request.Path.Contains(loginPageCompany.Substring(loginPageCompany.LastIndexOf("/") + 1)) == false

                        && HttpContext.Current.Request.Path.Contains("Company") == false

                        && HttpContext.Current.Request.Path.Contains("AddCompany.aspx") == false

                        && HttpContext.Current.Request.Path.Contains("BillingCompanyReport.aspx") == false

                        && HttpContext.Current.Request.Path.Contains("UserCompanyMapping.aspx") == false

                        && HttpContext.Current.Request.Path.Contains("AddCompany.aspx") == false

                        && HttpContext.Current.Request.Path.Contains("AddBranch.aspx") == false

                        && HttpContext.Current.Request.Path.Contains("InvoceHeadSettings.aspx") == false

                   )

                    {

                        HttpContext.Current.Response.Redirect(loginPageCompany, true);

                    }

                    else

                    {

                        return;

                    }

                }

                var loginPage = WebConfigurationManager.AppSettings["LoginPagePath"] ?? "~/Login?Session=Expire";

                if (HttpContext.Current.Request.Path.Contains(loginPage.Substring(loginPage.LastIndexOf("/") + 1)) == false)

                {

                    HttpContext.Current.Response.Redirect(loginPage, true);

                }

                else

                {

                }

            }                

        }

    }

    #endregion     

}

3) Web.config

  <system.web>

<httpModules>

      <add name="MyPreInitModule" type="PreInitModule" />

    </httpModules>

  </system.web>

 <system.webServer>

  <modules>

      <add name="MyPreInitModule" type="PreInitModule" />

    </modules>

</system.webServer>

Convert JSON String to DataTable in ASP.Net

1. using System;
2. using System.Collections.Generic;
3. using System.Data;
4. using System.Text.RegularExpressions;
5. 
   
6. public class ConvertJsonStringToDataTable
7. {
8.    public DataTable JsonStringToDataTable(string jsonString)
9.    {
10.       DataTable dt = new DataTable();
11.       string[] jsonStringArray = Regex.Split(jsonString.Replace("[", "").Replace("]",""), "},{");
12.       List<string> ColumnsName = new List<string>();
13.       foreach (string jSA in jsonStringArray)
14.       {
15.          string[] jsonStringData = Regex.Split(jSA.Replace("{", "").Replace("}", ""),",");
16.          foreach (string ColumnsNameData in jsonStringData)
17.          {
18.             try
19.             {
20.                int idx = ColumnsNameData.IndexOf(":");
21.                string ColumnsNameString = ColumnsNameData.Substring(0, idx - 1).Replace("\"", "");
22.                if (!ColumnsName.Contains(ColumnsNameString))
23.                {
24.                   ColumnsName.Add(ColumnsNameString);
25.                }
26.             }
27.             catch (Exception ex)
28.             {
29.                throw new Exception(string.Format("Error Parsing Column Name : {0}", ColumnsNameData));
30.             }
31.          }
32.          break;
33.       }
34.       foreach (string AddColumnName in ColumnsName)
35.       {
36.          dt.Columns.Add(AddColumnName);
37.       }
38.       foreach (string jSA in jsonStringArray)
39.       {
40.          string[] RowData = Regex.Split(jSA.Replace("{", "").Replace("}", ""), ",");
41.          DataRow nr = dt.NewRow();
42.          foreach (string rowData in RowData)
43.          {
44.             try
45.             {
46.                int idx = rowData.IndexOf(":");
47.                string RowColumns = rowData.Substring(0, idx - 1).Replace("\"", "");
48.                string RowDataString = rowData.Substring(idx + 1).Replace("\"", "");
49.                nr[RowColumns] = RowDataString;
50.             }
51.             catch (Exception ex)
52.             {
53.                continue;
54.             }
55.          }
56.          dt.Rows.Add(nr);
57.       }
58.       return dt;
59.    }
60. }