private void SetStructureDetails() { DataSet dsStructDet; try { dsStructDet = commisionReceivableBo.GetStructureDetails(advisorVo.advisorId, int.Parse(hdnStructId.Value)); foreach (DataRow row in dsStructDet.Tables[0].Rows) { hdnProductId.Value = row["PAG_AssetGroupCode"].ToString(); hdnStructValidFrom.Value = row["ACSM_ValidityStartDate"].ToString(); hdnStructValidTill.Value = row["ACSM_ValidityEndDate"].ToString(); hdnIssuerId.Value = row["PA_AMCCode"].ToString(); hdnCategoryId.Value = row["PAIC_AssetInstrumentCategoryCode"].ToString(); lbtStructureName.Text = row["ACSM_CommissionStructureName"].ToString(); lbtStructureName.ToolTip = row["ACSM_CommissionStructureName"].ToString(); txtProductName.Text = row["PAG_AssetGroupName"].ToString(); txtProductName.ToolTip = row["PAG_AssetGroupName"].ToString(); txtCategory.Text = row["PAIC_AssetInstrumentCategoryName"].ToString(); txtCategory.ToolTip = row["PAIC_AssetInstrumentCategoryName"].ToString(); txtIssuerName.Text = row["PA_AMCName"].ToString(); txtIssuerName.ToolTip = row["PA_AMCName"].ToString(); txtValidFrom.Text = DateTime.Parse(hdnStructValidFrom.Value).ToShortDateString(); txtValidTo.Text = DateTime.Parse(hdnStructValidTill.Value).ToShortDateString(); } //Getting the list of subcategories dsStructDet = commisionReceivableBo.GetSubcategories(advisorVo.advisorId, int.Parse(hdnStructId.Value)); DataTable dtSubcats = dsStructDet.Tables[0]; foreach (DataRow row in dtSubcats.Rows) { if (row["PAISC_AssetInstrumentSubCategoryName"].ToString().Trim() == "") { continue; } rlbAssetSubCategory.Items.Add(new RadListBoxItem(row["PAISC_AssetInstrumentSubCategoryName"].ToString().Trim(), row["PAISC_AssetInstrumentSubCategoryCode"].ToString().Trim())); } hdnSubcategoryIds.Value = convertSubcatListToCSV(rlbAssetSubCategory.Items.ToList()); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CommissionStructureToSchemeMapping.ascx.cs:SetStructureDetails()"); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }