protected void ddlSchmMapSubCat_SelectedIndexChanged(Object sender, EventArgs e)
        {
            MappingBo obj             = new MappingBo();
            DataSet   ds              = new DataSet();
            string    subcategory     = ddlSchmMapSubCat.SelectedValue;
            string    instrumentgroup = ddlSchmMapInstCat.SelectedValue;

            if (!String.IsNullOrEmpty(Request.QueryString["AssetGroup"].ToString()) && Request.QueryString["AssetGroup"].Equals("MF"))
            {
                ds = obj.GetAssetInstrumentSubSubCategory("MF", instrumentgroup, subcategory);
                ddlSubSubCat.DataSource     = ds.Tables[0];;
                ddlSubSubCat.DataTextField  = ds.Tables[0].Columns["PAISSC_AssetInstrumentSubSubCategoryName"].ToString();
                ddlSubSubCat.DataValueField = ds.Tables[0].Columns["PAISSC_AssetInstrumentSubSubCategoryCode"].ToString();
                ddlSubSubCat.DataBind();
            }
        }
        protected void LoadData(string AssetGroup)
        {
            int       WERPCODE;
            MappingVo objVo = new MappingVo();
            MappingBo objBo = new MappingBo();
            DataSet   ds    = new DataSet();

            if (!String.IsNullOrEmpty(Request.QueryString["WERPCODE"]) & AssetGroup.Equals("Equity"))
            {
                WERPCODE                      = Convert.ToInt32(Request.QueryString["WERPCODE"]);
                objVo                         = objBo.GetProductEquityScripDetails(WERPCODE);
                lblWERPCODE.Text              = WERPCODE.ToString();
                txtScripName.Text             = objVo.ScripName;
                txtTicker.Text                = objVo.Ticker;
                txtIncdate.Text               = objVo.IncorporationDate.ToString();
                txtPublishDate.Text           = objVo.PublishDate.ToString();
                txtMarketLot.Text             = objVo.MarketLot.ToString();
                txtFaceValue.Text             = objVo.FaceValue.ToString();
                txtBookClouser.Text           = objVo.BookClosure.ToString();
                ddlInstCategory.SelectedValue = objVo.InstrumentCategory;
                txtBSE.Text                   = objVo.BSE;
                txtNSE.Text                   = objVo.NSE;
                txtCERC.Text                  = objVo.CERC;
                //  ddlSector.SelectedValue = objVo.Sector.ToString();
                // ddlMarketCap.SelectedValue = objVo.MarketCap.ToString();

                ds = objBo.GetAssetInstrumentSubCategory("DE", objVo.InstrumentCategory);
                ddlSubCategory.DataSource     = ds.Tables[0];
                ddlSubCategory.DataTextField  = ds.Tables[0].Columns["PAISC_AssetInstrumentSubCategoryName"].ToString();
                ddlSubCategory.DataValueField = ds.Tables[0].Columns["PAISC_AssetInstrumentSubCategoryCode"].ToString();
                ddlSubCategory.DataBind();
                ddlSubCategory.SelectedValue = objVo.SubCategory;
            }

            else if (!String.IsNullOrEmpty(Request.QueryString["WERPCODE"]) & AssetGroup.Equals("MF"))
            {
                WERPCODE = Convert.ToInt32(Request.QueryString["WERPCODE"]);
                objVo    = objBo.GetProductAMCSchemePlanDetails(WERPCODE);
                lblSchMapWerpCode.Text          = WERPCODE.ToString();
                txtSchmPlnName.Text             = objVo.SchemePlanName;
                ddlSchmMapInstCat.SelectedValue = objVo.MFInstrumentCategory;

                //  ddlSchmMapSector.SelectedValue = objVo.MFSector.ToString();
                txtAMFI.Text  = objVo.AMFI;
                txtCAMS.Text  = objVo.CAMS;
                txtKarvy.Text = objVo.Karvy;

                ds = objBo.GetAssetInstrumentSubCategory(AssetGroup, objVo.MFInstrumentCategory);
                ddlSchmMapSubCat.DataSource     = ds.Tables[0];
                ddlSchmMapSubCat.DataTextField  = ds.Tables[0].Columns["PAISC_AssetInstrumentSubCategoryName"].ToString();
                ddlSchmMapSubCat.DataValueField = ds.Tables[0].Columns["PAISC_AssetInstrumentSubCategoryCode"].ToString();
                ddlSchmMapSubCat.DataBind();
                ddlSchmMapSubCat.SelectedValue = objVo.MFSubCategory;
                ds.Clear();

                ds = objBo.GetAssetInstrumentSubSubCategory(AssetGroup, objVo.MFInstrumentCategory, objVo.MFSubCategory);
                ddlSubSubCat.DataSource     = ds.Tables[0];
                ddlSubSubCat.DataTextField  = ds.Tables[0].Columns["PAISSC_AssetInstrumentSubSubCategoryName"].ToString();
                ddlSubSubCat.DataValueField = ds.Tables[0].Columns["PAISSC_AssetInstrumentSubSubCategoryCode"].ToString();
                ddlSubSubCat.DataBind();
                ddlSubSubCat.SelectedValue = objVo.MFSubSubCategory;
            }
        }