protected void Requisition_Count()
    {
        BLL_Infra_VesselLib       objVsl         = new BLL_Infra_VesselLib();
        BLL_PURC_Purchase         objTechService = new BLL_PURC_Purchase();
        BLL_Infra_UserCredentials objUserFlt     = new BLL_Infra_UserCredentials();
        DataTable dtEmptyTable = new DataTable();

        DataTable FleetDT = objVsl.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
        DataTable DeptDt  = objTechService.GetDeptType();

        dtEmptyTable.Columns.Add("Message");
        DataRow drEmpty = dtEmptyTable.NewRow();

        drEmpty[0] = "No record found !";
        dtEmptyTable.Rows.Add(drEmpty);

        DataTable dtUserFleet = objUserFlt.Get_Fleet_By_UserID(Convert.ToInt32(Session["USERID"].ToString()));

        if (dtUserFleet.Rows.Count > 0)
        {
            Table tbl_Reqsn_Count = new Table();
            tbl_Reqsn_Count.CssClass    = "tbl-css-dash";
            tbl_Reqsn_Count.CellPadding = 0;
            tbl_Reqsn_Count.CellSpacing = 1;


            foreach (DataRow drflt in FleetDT.Rows)
            {
                // get the fleets based on vessels assigned to loged in user
                DataRow[] drUserFleet = dtUserFleet.Select("fleetcode='" + drflt["code"].ToString() + "'");
                if (drUserFleet.Length > 0)
                {
                    TableRow  tr_Reqsn_Count_HD_Fleet    = new TableRow();
                    TableCell cl_Reqsn_Count_HD_Fleet    = new TableCell();
                    TableRow  tr_Reqsn_Count_HD_FormType = new TableRow();
                    Label     lblHD          = new Label();
                    TableRow  tr_Reqsn_Count = new TableRow();
                    tr_Reqsn_Count.CssClass          = "td-css-dash";
                    cl_Reqsn_Count_HD_Fleet.CssClass = "cell-HD-css";

                    lblHD.Text = drflt["Name"].ToString();

                    cl_Reqsn_Count_HD_Fleet.Controls.Add(lblHD);
                    tr_Reqsn_Count_HD_Fleet.Controls.Add(cl_Reqsn_Count_HD_Fleet);
                    tbl_Reqsn_Count.Controls.Add(tr_Reqsn_Count_HD_Fleet);


                    foreach (DataRow drDep in DeptDt.Rows)
                    {
                        if (drDep["Short_Code"].ToString() != "ALL")
                        {
                            DataTable dtReqsnCount = BLL_Infra_DashBoard.Get_Rreqsn_Count(drDep["Short_Code"].ToString(), UDFLib.ConvertToInteger(drflt["code"].ToString()), Session["USERID"].ToString()).Tables[0];

                            TableCell cl_Reqsn_Count             = new TableCell();
                            TableCell cl_Reqsn_Count_HD_FormType = new TableCell();
                            cl_Reqsn_Count_HD_FormType.Text     = drDep["Description"].ToString();
                            cl_Reqsn_Count.CssClass             = "td-css-dash";
                            cl_Reqsn_Count_HD_FormType.CssClass = "cell-HD-css";

                            GridView gvReqsnCount = new GridView();
                            gvReqsnCount.ID = "gvReqsnCount" + drflt["code"].ToString() + drDep["Short_Code"].ToString();
                            if (dtReqsnCount.Rows.Count > 0)
                            {
                                gvReqsnCount.DataSource = dtReqsnCount;
                            }
                            else
                            {
                                gvReqsnCount.DataSource = dtEmptyTable;
                            }
                            gvReqsnCount.DataBind();

                            gvReqsnCount.EmptyDataText                = "No record found !";
                            gvReqsnCount.AutoGenerateColumns          = true;
                            gvReqsnCount.RowStyle.CssClass            = "RowStyle-css-dash";
                            gvReqsnCount.AlternatingRowStyle.CssClass = "AlternatingRowStyle-css-dash";
                            gvReqsnCount.HeaderStyle.CssClass         = "HeaderStyle-css-dash";

                            tr_Reqsn_Count_HD_FormType.Controls.Add(cl_Reqsn_Count_HD_FormType);
                            cl_Reqsn_Count.Controls.Add(gvReqsnCount);
                            tr_Reqsn_Count.Controls.Add(cl_Reqsn_Count);
                        }
                    }
                    tbl_Reqsn_Count.Controls.Add(tr_Reqsn_Count_HD_FormType);
                    tbl_Reqsn_Count.Controls.Add(tr_Reqsn_Count);
                }
            }

            phReqsnCount.Controls.Add(tbl_Reqsn_Count);
        }
    }