コード例 #1
0
        public void LoadCategory(string productType)
        {
            try
            {
                DataSet ds = assetBo.GetAssetInstrumentCategory(productType); //Change to the respective GroupCode
                ddlInstrumentCategory.DataSource     = ds.Tables[0];
                ddlInstrumentCategory.DataTextField  = "PAIC_AssetInstrumentCategoryName";
                ddlInstrumentCategory.DataValueField = "PAIC_AssetInstrumentCategoryCode";
                ddlInstrumentCategory.DataBind();
                ddlInstrumentCategory.Items.Insert(0, new ListItem("Select", "Select"));
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }

            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "CustomerAccountAdd.ascx:LoadCategory()");
                object[] objects = new object[1];
                objects[0]   = group;
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
        }
コード例 #2
0
        private void BindAssetGroupDropDown()
        {
            try
            {
                DataSet ds = assetBo.GetAssetInstrumentCategory("GI");
                ddlAssetCategory.DataSource     = ds;
                ddlAssetCategory.DataValueField = ds.Tables[0].Columns["PAIC_AssetInstrumentCategoryCode"].ToString();
                ddlAssetCategory.DataTextField  = ds.Tables[0].Columns["PAIC_AssetInstrumentCategoryName"].ToString();
                ddlAssetCategory.DataBind();
                ddlAssetCategory.SelectedValue = "GIRI";
                //ddlAssetCategory.Items.Insert(0, new ListItem("Select Asset Category", "Select Asset Category"));
                BindAssetSubGroupDropDown();
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();

                FunctionInfo.Add("Method", "PortfolioGeneralInsuranceAccountAdd.ascx:BindAssetGroupDropDown()");

                object[] objects = new object[4];

                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
        }
コード例 #3
0
 private void LoadAssetCategories()
 {
     dsAssetCategories          = assetBo.GetAssetInstrumentCategory("GD"); //Change to the respective GroupCode
     ddlCategory.DataSource     = dsAssetCategories.Tables[0];
     ddlCategory.DataTextField  = "PAIC_AssetInstrumentCategoryName".ToString().Trim();
     ddlCategory.DataValueField = "PAIC_AssetInstrumentCategoryCode".ToString().Trim();
     ddlCategory.DataBind();
     ddlCategory.Items.Insert(0, new ListItem("Select a Category", "Select a Category"));
 }
コード例 #4
0
        public void LoadCategory(string category)
        {
            DataSet ds = assetBo.GetAssetInstrumentCategory(category);

            ddlCategory.DataSource     = ds.Tables[0];
            ddlCategory.DataTextField  = ds.Tables[0].Columns["PAIC_AssetInstrumentCategoryName"].ToString();
            ddlCategory.DataValueField = ds.Tables[0].Columns["PAIC_AssetInstrumentCategoryCode"].ToString();
            ddlCategory.DataBind();
        }
コード例 #5
0
        private void BindDropDowns(PropertyVo propertyVo, CustomerAccountsVo customerAccountsVo, string path)
        {
            try
            {
                userVo                        = (UserVo)Session["userVo"];
                customerVo                    = (CustomerVo)Session["CustomerVo"];
                dtMeasureCode                 = XMLBo.GetMeasureCode(path, AssetGroupCode);
                ddlMeasureCode.DataSource     = dtMeasureCode;
                ddlMeasureCode.DataTextField  = "Measure";
                ddlMeasureCode.DataValueField = "MeasureCode";
                ddlMeasureCode.DataBind();
                ddlMeasureCode.Items.Insert(0, new ListItem("Select a Measure Code", "Select a Measure Code"));

                // Bind the Instrument Category for an Asset
                dsInstrumentCategory            = assetBo.GetAssetInstrumentCategory(AssetGroupCode);
                ddlInstrumentCat.DataSource     = dsInstrumentCategory.Tables[0];
                ddlInstrumentCat.DataTextField  = "PAIC_AssetInstrumentCategoryName";
                ddlInstrumentCat.DataValueField = "PAIC_AssetInstrumentCategoryCode";
                ddlInstrumentCat.DataBind();
                ddlInstrumentCat.Items.Insert(0, new ListItem("Select an Instrument Category", "Select an Instrument Category"));

                ddlInstrumentSubCat.Items.Clear();


                // Bind State Drop Downs
                dtStates                = XMLBo.GetStates(path);
                ddlState.DataSource     = dtStates;
                ddlState.DataTextField  = "StateName";
                ddlState.DataValueField = "StateCode";
                ddlState.DataBind();
                ddlState.Items.Insert(0, new ListItem("Select a State", "Select a State"));
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "PortfolioPropertyEntry.ascx:BindDropDowns()");
                object[] objects = new object[5];
                objects[0]   = userVo;
                objects[1]   = propertyVo;
                objects[2]   = customerAccountsVo;
                objects[3]   = path;
                objects[4]   = customerVo;
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
        }
コード例 #6
0
        public void LoadCategory()
        {
            dsAssetCategories          = assetBo.GetAssetInstrumentCategory("CL"); //Change to the respective GroupCode
            ddlCategory.DataSource     = dsAssetCategories.Tables[0];
            ddlCategory.DataTextField  = "PAIC_AssetInstrumentCategoryName";
            ddlCategory.DataValueField = "PAIC_AssetInstrumentCategoryCode";
            ddlCategory.DataBind();
            ddlCategory.Items.Insert(0, new ListItem("Select a Category", "Select a Category"));

            if (command == "EditCol" || command == "ViewCol")
            {
            }
        }
コード例 #7
0
 public void LoadCategory(string productType)
 {
     try
     {
         DataSet ds = assetBo.GetAssetInstrumentCategory(productType);
         ddlCategory.DataSource     = ds.Tables[0];
         ddlCategory.DataTextField  = "PAIC_AssetInstrumentCategoryName";
         ddlCategory.DataValueField = "PAIC_AssetInstrumentCategoryCode";
         ddlCategory.DataBind();
         ddlCategory.Items.Insert(0, new ListItem("Select", "0"));
     }
     catch (BaseApplicationException Ex)
     {
         throw Ex;
     }
 }
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                SessionBo.CheckSession();
                this.Page.Culture = "en-GB";
                userVo            = (UserVo)Session["userVo"];
                customerVo        = (CustomerVo)Session["CustomerVo"];

                if (!IsPostBack)
                {
                    portfolioId = int.Parse(Session[SessionContents.PortfolioId].ToString());
                    BindPortfolioDropDown();
                    trSubCategory.Visible      = false;
                    dsAssetCategories          = assetBo.GetAssetInstrumentCategory("PI"); //Change to the respective GroupCode
                    ddlCategory.DataSource     = dsAssetCategories.Tables[0];
                    ddlCategory.DataTextField  = "PAIC_AssetInstrumentCategoryName";
                    ddlCategory.DataValueField = "PAIC_AssetInstrumentCategoryCode";
                    ddlCategory.DataBind();
                    ddlCategory.Items.Insert(0, new ListItem("Select a Category", "Select a Category"));

                    personalVo = (PersonalVo)Session["personalVo"];

                    if (Request.QueryString["action"] != null)
                    {
                        Manage = Request.QueryString["action"].ToString();
                    }

                    if (personalVo != null)
                    {
                        if (Manage == "edit")
                        {
                            SetControls("edit", personalVo);
                        }
                        else if (Manage == "view")
                        {
                            SetControls("view", personalVo);
                        }
                    }
                    else
                    {
                        SetControls("entry", personalVo);
                    }
                }
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "PortfolioPersonalEntry.ascx:Page_Load()");
                object[] objects = new object[4];
                objects[0]   = customerVo;
                objects[1]   = portfolioId;
                objects[2]   = userVo;
                objects[3]   = personalVo;
                FunctionInfo = exBase.AddObject(FunctionInfo, null);/*, objects*/
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
        }
        protected void gvGovtSaving_ItemDataBound(object sender, GridItemEventArgs e)
        {
            int    AccountId;
            string strModeOfHoldingCode;
            string strDebtIssuerCode;
            string strInterestBasisCode;
            string strCompoundInterestFrequencyCode;
            string strAssetInstrumentCategoryCode;
            string strInterestPayableFrequencyCode;

            if ((e.Item is GridEditFormItem) && e.Item.IsInEditMode)
            {
                GridEditFormItem   editedItem       = (GridEditFormItem)e.Item;
                HtmlGenericControl divAccout        = (HtmlGenericControl)editedItem.FindControl("divAccout");
                HtmlGenericControl divGovtSavings   = (HtmlGenericControl)editedItem.FindControl("divGovtSavings");
                ImageButton        btnImgGovtSaving = (ImageButton)editedItem.FindControl("btnImgGovtSaving");
                ImageButton        btnImgAddAccount = (ImageButton)editedItem.FindControl("btnImgAddAccount");

                if (e.Item.RowIndex == -1)
                {
                    if (hdnCondition.Value != "1")
                    {
                        divGovtSavings.Visible = false;
                    }
                }
                else
                {
                    divAccout.Visible = false;
                }
            }
            if (e.Item is GridEditFormInsertItem && e.Item.OwnerTableView.IsItemInserted)
            {
                GridEditFormInsertItem item = (GridEditFormInsertItem)e.Item;
                GridEditFormItem       gefi = (GridEditFormItem)e.Item;

                DropDownList ddlModeOfHolding = (DropDownList)gefi.FindControl("ddlModeOfHolding");
                dtModeOfHolding                 = XMLBo.GetModeOfHolding(path);
                ddlModeOfHolding.DataSource     = dtModeOfHolding;
                ddlModeOfHolding.DataTextField  = "ModeOfHolding";
                ddlModeOfHolding.DataValueField = "ModeOfHoldingCode";
                ddlModeOfHolding.DataBind();
                ddlModeOfHolding.Items.Insert(0, new ListItem("Select", "Select"));

                DropDownList ddlCategory = (DropDownList)gefi.FindControl("ddlCategory");
                group = "GS";
                DataSet ds = assetBo.GetAssetInstrumentCategory(group);
                ddlCategory.DataSource     = ds.Tables[0];
                ddlCategory.DataTextField  = "PAIC_AssetInstrumentCategoryName";
                ddlCategory.DataValueField = "PAIC_AssetInstrumentCategoryCode";
                ddlCategory.DataBind();
                ddlCategory.Items.Insert(0, new ListItem("Select", "Select"));

                DropDownList ddlgovtModeofHoldings = (DropDownList)gefi.FindControl("ddlgovtModeofHoldings");
                ddlgovtModeofHoldings.DataSource     = dtModeOfHolding;
                ddlgovtModeofHoldings.DataTextField  = "ModeOfHolding";
                ddlgovtModeofHoldings.DataValueField = "ModeOfHoldingCode";
                ddlgovtModeofHoldings.DataBind();
                ddlgovtModeofHoldings.Items.Insert(0, new ListItem("Select a Mode of Holding", "0"));

                DropDownList ddlDebtIssuerCode = (DropDownList)gefi.FindControl("ddlDebtIssuerCode");
                DataTable    dtDebtIssuerCode  = XMLBo.GetDebtIssuer(path);
                ddlDebtIssuerCode.DataSource     = dtDebtIssuerCode;
                ddlDebtIssuerCode.DataTextField  = dtDebtIssuerCode.Columns["DebtIssuerName"].ToString();
                ddlDebtIssuerCode.DataValueField = dtDebtIssuerCode.Columns["DebtIssuerCode"].ToString();
                ddlDebtIssuerCode.DataBind();
                ddlDebtIssuerCode.Items.Insert(0, new ListItem("Select an Asset Issuer", "0"));


                DropDownList ddlInterestBasis = (DropDownList)gefi.FindControl("ddlInterestBasis");
                DataTable    dtInterestBasis  = XMLBo.GetInterestBasis(path);
                ddlInterestBasis.DataSource     = dtInterestBasis;
                ddlInterestBasis.DataTextField  = dtInterestBasis.Columns["InterestBasisType"].ToString();
                ddlInterestBasis.DataValueField = dtInterestBasis.Columns["InterestBasisCode"].ToString();
                ddlInterestBasis.DataBind();
                ddlInterestBasis.Items.Insert(0, new ListItem("Select an Interest Basis", "0"));
                ddlInterestBasis.SelectedIndex = 0;

                DropDownList ddlSimpleInterestFC = (DropDownList)gefi.FindControl("ddlSimpleInterestFC");
                DataTable    dtSimpleInterestFC  = XMLBo.GetFrequency(path);
                ddlSimpleInterestFC.DataSource     = dtSimpleInterestFC;
                ddlSimpleInterestFC.DataTextField  = dtSimpleInterestFC.Columns["Frequency"].ToString();
                ddlSimpleInterestFC.DataValueField = dtSimpleInterestFC.Columns["FrequencyCode"].ToString();
                ddlSimpleInterestFC.DataBind();
                ddlSimpleInterestFC.Items.Insert(0, new ListItem("Select a Frequency", "NA"));

                DropDownList ddlCompoundInterestFC = (DropDownList)gefi.FindControl("ddlCompoundInterestFC");
                DataTable    dtCompoundInterestFC  = XMLBo.GetFrequency(path);
                ddlCompoundInterestFC.DataSource     = dtCompoundInterestFC;
                ddlCompoundInterestFC.DataTextField  = dtCompoundInterestFC.Columns["Frequency"].ToString();
                ddlCompoundInterestFC.DataValueField = dtCompoundInterestFC.Columns["FrequencyCode"].ToString();
                ddlCompoundInterestFC.DataBind();
                ddlCompoundInterestFC.Items.Insert(0, new ListItem("Select a Frequency", "0"));

                RadGrid gvNominees = (RadGrid)gefi.FindControl("gvNominees");

                #region loadnominnes

                DataTable dtCustomerAssociates   = new DataTable();
                DataTable dtNewCustomerAssociate = new DataTable();
                DataRow   drCustomerAssociates;


                dsCustomerAssociates = customerAccountBo.GetCustomerAssociatedRel(customerVo.CustomerId);
                dtCustomerAssociates = dsCustomerAssociates.Tables[0];

                dtNewCustomerAssociate.Columns.Add("MemberCustomerId");
                dtNewCustomerAssociate.Columns.Add("AssociationId");
                dtNewCustomerAssociate.Columns.Add("Name");
                dtNewCustomerAssociate.Columns.Add("Relationship");

                foreach (DataRow dr in dtCustomerAssociates.Rows)
                {
                    drCustomerAssociates    = dtNewCustomerAssociate.NewRow();
                    drCustomerAssociates[0] = dr["C_AssociateCustomerId"].ToString();
                    drCustomerAssociates[1] = dr["CA_AssociationId"].ToString();
                    drCustomerAssociates[2] = dr["C_FirstName"].ToString() + " " + dr["C_LastName"].ToString();
                    drCustomerAssociates[3] = dr["XR_Relationship"].ToString();
                    dtNewCustomerAssociate.Rows.Add(drCustomerAssociates);
                }

                if (dtNewCustomerAssociate.Rows.Count > 0)
                {
                    gvNominees.DataSource = dtNewCustomerAssociate;
                    gvNominees.DataBind();
                    gvNominees.Visible = true;
                }
                else
                {
                }

                #endregion
            }
            if (e.Item is GridDataItem)
            {
                GridDataItem dataItem = e.Item as GridDataItem;
            }
            string strRelationshipCode = string.Empty;
            if (e.Item is GridEditFormItem && e.Item.IsInEditMode && e.Item.ItemIndex != -1)
            {
                GridEditFormItem gefi       = (GridEditFormItem)e.Item;
                RadGrid          gvNominees = (RadGrid)gefi.FindControl("gvNominees");

                GovtSavingNPId                   = int.Parse(gvGovtSaving.MasterTableView.DataKeyValues[e.Item.ItemIndex]["CGSNP_GovtSavingNPId"].ToString());
                AccountId                        = int.Parse(gvGovtSaving.MasterTableView.DataKeyValues[e.Item.ItemIndex]["CGSA_AccountId"].ToString());
                strModeOfHoldingCode             = gvGovtSaving.MasterTableView.DataKeyValues[e.Item.ItemIndex]["XMOH_ModeOfHoldingCode"].ToString();
                strDebtIssuerCode                = gvGovtSaving.MasterTableView.DataKeyValues[e.Item.ItemIndex]["XDI_DebtIssuerCode"].ToString();
                strInterestBasisCode             = gvGovtSaving.MasterTableView.DataKeyValues[e.Item.ItemIndex]["XIB_InterestBasisCode"].ToString();
                strCompoundInterestFrequencyCode = gvGovtSaving.MasterTableView.DataKeyValues[e.Item.ItemIndex]["XF_CompoundInterestFrequencyCode"].ToString();
                strAssetInstrumentCategoryCode   = gvGovtSaving.MasterTableView.DataKeyValues[e.Item.ItemIndex]["PAIC_AssetInstrumentCategoryCode"].ToString();
                strInterestPayableFrequencyCode  = gvGovtSaving.MasterTableView.DataKeyValues[e.Item.ItemIndex]["XF_InterestPayableFrequencyCode"].ToString();

                DropDownList ddlModeOfHolding = (DropDownList)gefi.FindControl("ddlModeOfHolding");
                dtModeOfHolding                 = XMLBo.GetModeOfHolding(path);
                ddlModeOfHolding.DataSource     = dtModeOfHolding;
                ddlModeOfHolding.DataTextField  = "ModeOfHolding";
                ddlModeOfHolding.DataValueField = "ModeOfHoldingCode";
                ddlModeOfHolding.DataBind();
                ddlModeOfHolding.SelectedValue = strModeOfHoldingCode;

                DropDownList ddlCategory = (DropDownList)gefi.FindControl("ddlCategory");
                group = "GS";
                DataSet ds = assetBo.GetAssetInstrumentCategory(group);
                ddlCategory.DataSource     = ds.Tables[0];
                ddlCategory.DataTextField  = "PAIC_AssetInstrumentCategoryName";
                ddlCategory.DataValueField = "PAIC_AssetInstrumentCategoryCode";
                ddlCategory.DataBind();
                ddlCategory.SelectedValue = strAssetInstrumentCategoryCode;


                DropDownList ddlgovtModeofHoldings = (DropDownList)gefi.FindControl("ddlgovtModeofHoldings");
                ddlgovtModeofHoldings.DataSource     = dtModeOfHolding;
                ddlgovtModeofHoldings.DataTextField  = "ModeOfHolding";
                ddlgovtModeofHoldings.DataValueField = "ModeOfHoldingCode";
                ddlgovtModeofHoldings.DataBind();
                ddlgovtModeofHoldings.SelectedValue = strModeOfHoldingCode;

                DropDownList ddlDebtIssuerCode = (DropDownList)gefi.FindControl("ddlDebtIssuerCode");
                DataTable    dtDebtIssuerCode  = XMLBo.GetDebtIssuer(path);
                ddlDebtIssuerCode.DataSource     = dtDebtIssuerCode;
                ddlDebtIssuerCode.DataTextField  = dtDebtIssuerCode.Columns["DebtIssuerName"].ToString();
                ddlDebtIssuerCode.DataValueField = dtDebtIssuerCode.Columns["DebtIssuerCode"].ToString();
                ddlDebtIssuerCode.DataBind();
                ddlDebtIssuerCode.SelectedValue = strDebtIssuerCode;


                DropDownList ddlInterestBasis = (DropDownList)gefi.FindControl("ddlInterestBasis");
                DataTable    dtInterestBasis  = XMLBo.GetInterestBasis(path);
                ddlInterestBasis.DataSource     = dtInterestBasis;
                ddlInterestBasis.DataTextField  = dtInterestBasis.Columns["InterestBasisType"].ToString();
                ddlInterestBasis.DataValueField = dtInterestBasis.Columns["InterestBasisCode"].ToString();
                ddlInterestBasis.DataBind();
                ddlInterestBasis.SelectedValue = strInterestBasisCode;

                DropDownList ddlSimpleInterestFC = (DropDownList)gefi.FindControl("ddlSimpleInterestFC");
                DataTable    dtSimpleInterestFC  = XMLBo.GetFrequency(path);
                ddlSimpleInterestFC.DataSource     = dtSimpleInterestFC;
                ddlSimpleInterestFC.DataTextField  = dtSimpleInterestFC.Columns["Frequency"].ToString();
                ddlSimpleInterestFC.DataValueField = dtSimpleInterestFC.Columns["FrequencyCode"].ToString();
                ddlSimpleInterestFC.DataBind();
                ddlSimpleInterestFC.SelectedValue = strInterestPayableFrequencyCode;

                DropDownList ddlCompoundInterestFC = (DropDownList)gefi.FindControl("ddlCompoundInterestFC");
                DataTable    dtCompoundInterestFC  = XMLBo.GetFrequency(path);
                ddlCompoundInterestFC.DataSource     = dtCompoundInterestFC;
                ddlCompoundInterestFC.DataTextField  = dtCompoundInterestFC.Columns["Frequency"].ToString();
                ddlCompoundInterestFC.DataValueField = dtCompoundInterestFC.Columns["FrequencyCode"].ToString();
                ddlCompoundInterestFC.DataBind();
                ddlCompoundInterestFC.SelectedValue = strCompoundInterestFrequencyCode;


                #region loadnominnes

                DataTable dtCustomerAssociates   = new DataTable();
                DataTable dtNewCustomerAssociate = new DataTable();
                DataRow   drCustomerAssociates;


                dsCustomerAssociates = customerAccountBo.GetCustomerAssociatedRel(customerVo.CustomerId);
                dtCustomerAssociates = dsCustomerAssociates.Tables[0];

                dtNewCustomerAssociate.Columns.Add("MemberCustomerId");
                dtNewCustomerAssociate.Columns.Add("AssociationId");
                dtNewCustomerAssociate.Columns.Add("Name");
                dtNewCustomerAssociate.Columns.Add("Relationship");

                foreach (DataRow dr in dtCustomerAssociates.Rows)
                {
                    drCustomerAssociates    = dtNewCustomerAssociate.NewRow();
                    drCustomerAssociates[0] = dr["C_AssociateCustomerId"].ToString();
                    drCustomerAssociates[1] = dr["CA_AssociationId"].ToString();
                    drCustomerAssociates[2] = dr["C_FirstName"].ToString() + " " + dr["C_LastName"].ToString();
                    drCustomerAssociates[3] = dr["XR_Relationship"].ToString();
                    dtNewCustomerAssociate.Rows.Add(drCustomerAssociates);
                }

                if (dtNewCustomerAssociate.Rows.Count > 0)
                {
                    gvNominees.DataSource = dtNewCustomerAssociate;
                    gvNominees.DataBind();
                    gvNominees.Visible = true;
                }
                else
                {
                }

                #endregion
            }
        }
        private void BindDropDownLists()
        {
            AssetBo   assetBo              = new AssetBo();
            DataTable dtInterestBasis      = new DataTable();
            DataSet   dsInstrumentCategory = new DataSet();
            DataTable dtDebtIssuer         = new DataTable();
            DataTable dtFrequency          = new DataTable();
            string    xmlLookUpPath        = "";

            try
            {
                xmlLookUpPath = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());

                // Bind the drop down with values from the XML
                dtInterestBasis                 = assetBo.GetInterestBasis(xmlLookUpPath);
                ddlInterestBasis.DataSource     = dtInterestBasis;
                ddlInterestBasis.DataTextField  = "WIB_InterestBasis";
                ddlInterestBasis.DataValueField = "WIB_InterestBasisCode";
                ddlInterestBasis.DataBind();
                ddlInterestBasis.Items.Insert(0, "Select an Interest Basis");

                dsInstrumentCategory      = assetBo.GetAssetInstrumentCategory(assetGroupCode);
                ddlAssetIC.DataSource     = dsInstrumentCategory.Tables[0];
                ddlAssetIC.DataTextField  = "PAIC_AssetInstrumentCategoryName";
                ddlAssetIC.DataValueField = "PAIC_AssetInstrumentCategoryCode";
                ddlAssetIC.DataBind();
                ddlAssetIC.Items.Insert(0, "Select an Asset Instrument Category");

                dtDebtIssuer                 = assetBo.GetDebtIssuerCode(xmlLookUpPath);
                ddlDebtIssuer.DataSource     = dtDebtIssuer;
                ddlDebtIssuer.DataTextField  = "WDI_DebtIssuerName";
                ddlDebtIssuer.DataValueField = "WDI_DebtIssuerCode";
                ddlDebtIssuer.DataBind();
                ddlDebtIssuer.Items.Insert(0, "Select a Debt Issuer");

                dtFrequency = assetBo.GetFrequencyCode(xmlLookUpPath);

                ddlCIFrequency.DataSource     = dtFrequency;
                ddlCIFrequency.DataTextField  = "WF_Frequency";
                ddlCIFrequency.DataValueField = "WF_FrequencyCode";
                ddlCIFrequency.DataBind();
                ddlCIFrequency.Items.Insert(0, "Select a Compounding Frequency");

                ddlIPFrequency.DataSource     = dtFrequency;
                ddlIPFrequency.DataTextField  = "WF_Frequency";
                ddlIPFrequency.DataValueField = "WF_FrequencyCode";
                ddlIPFrequency.DataBind();
                ddlIPFrequency.Items.Insert(0, "Select an Interest Payout Frequency");
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "PortfolioCashSavingsEdit.ascx.cs:BindDropDownLists()");
                object[] objects = new object[2];
                objects[0]   = xmlLookUpPath;
                objects[1]   = assetGroupCode;
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
        }