public void LoadInterestBasis(string path)
{
DataTable dt = assetBo.GetInterestBasis(path);
ddlInterestBasis.DataSource = dt;
ddlInterestBasis.DataTextField = dt.Columns["WIB_InterestBasis"].ToString();
ddlInterestBasis.DataValueField = dt.Columns["WIB_InterestBasisCode"].ToString();
ddlInterestBasis.DataBind();
}
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;
}
}