How to check your EPF balance in 6 easy steps

Step 1

Employees need to login the member portal by visiting the EPFO website (https://unifiedportal-mem.epfindia.gov.in/memberinterface/). You need to enter your 12 digit Activated UAN number and the password to view your account details. If you have not activated your UAN, you can do it by clicking on the tab below. Once you have entered the right credentials, it takes four days to activate your UAN.

Step 2 
Once you have entered into the portal, you can find all kind of online services that are available on the EPFO website. From there you can track your queries related to claim status, transferring request, which is required in case your current employer has created another UAN number to track your PF account.

Step 3
You can see various tabs present on the dark green ribbon above. Clicking on the ‘view’ tab will take you to visit your profile, service history, UAN card and your passbook address. This passbook address is a separate website link where you can view your PF account.

Step 4

To view your PF passbook, you need to visit http://www.epfindia.gov.in website. This is a different website where you can view various other details related to EPFO. You need to go to the ‘our service’ tab and under our service tab, you need to click on the ‘for employees’ link. To view the EPF contributions done by your employer every month you need to then click on the ‘member passbook’ link.

Step 5
Once you click on the member passbook link, you will be sent to a different tab, where you need to again enter your activated UAN and same EPFO passwords which you used for the EPFO member login portal.

Step 6

Once you have entered your credentials, you can visit your EPF passbook and view your PF contribution made by the company.

The government has come up with various other benefits where they are giving special benefits to employees who had to leave their current job due to some physical incapacitation. If you want visit the office, you may even locate the nearest EPFO office through this EPFO website, you can also view the eligibility for making online claims and obtain lots more service facilities through this online portal.

One should also know that the accumulated amount is payable on retirement, resignation or death. You can also make partial withdrawals for financing life insurance policies, acquiring a house, wedding of self or dependents, child’s education planning or any treatment of illness etc.

Search text in stored procedure in SQL Server

SELECT *   FROM   sys.procedures WHERE  Object_definition(object_id) LIKE '%keyword%'

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