private void SetInitialRowForESICGrid()
        {
            DataTable table = new DataTable();
            DataRow   dr    = null;

            table.Columns.Add("COMP_CODE", typeof(string));
            table.Columns.Add("TRAN_TYPE", typeof(string));
            table.Columns.Add("TRAN_NO", typeof(string));
            table.Columns.Add("FRDT", typeof(string));
            table.Columns.Add("TODT", typeof(string));
            table.Columns.Add("WRK_HOURS", typeof(string));
            table.Columns.Add("CAL_HOURS", typeof(string));
            table.Columns.Add("CAL_RATE1", typeof(string));
            table.Columns.Add("CAL_RATE2", typeof(string));


            dr = table.NewRow();
            dr["COMP_CODE"] = string.Empty;
            dr["TRAN_TYPE"] = string.Empty;
            dr["TRAN_NO"]   = string.Empty;
            dr["FRDT"]      = string.Empty;
            dr["TODT"]      = string.Empty;
            dr["WRK_HOURS"] = string.Empty;
            dr["CAL_HOURS"] = string.Empty;
            dr["CAL_RATE1"] = string.Empty;
            dr["CAL_RATE2"] = string.Empty;


            table.Rows.Add(dr);

            ViewState["ESICCalculateTable"] = table;

            GvESICCalculateMaster.DataSource = table;
            GvESICCalculateMaster.DataBind();
        }
        public void FillGENEARL_MASTERGrid(string CompCode)
        {
            DataTable Dt = new DataTable();

            Dt = GENERAL_MASLogicLayer.GetAllGENERAL_MASDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString()));



            DataView DvP = new DataView(Dt);

            DvP.RowFilter = "TRAN_TYPE='P'";

            DataView DvE = new DataView(Dt);

            DvE.RowFilter = "TRAN_TYPE='E'";

            DataView DvO = new DataView(Dt);

            DvO.RowFilter = "TRAN_TYPE='O'";

            DataView DvA = new DataView(Dt);

            DvA.RowFilter = "TRAN_TYPE='A'";


            GvPFCalculateMaster.DataSource = DvP.ToTable();
            GvPFCalculateMaster.DataBind();

            GvESICCalculateMaster.DataSource = DvE.ToTable();
            GvESICCalculateMaster.DataBind();

            GvOTCalculateMaster.DataSource = DvO.ToTable();
            GvOTCalculateMaster.DataBind();

            GvAllowanceClaculateMaster.DataSource = DvA.ToTable();
            GvAllowanceClaculateMaster.DataBind();

            //DtSearch = Dv.ToTable();
        }