private void LoadAllSchemeList(int amcCode) { DataSet dsLoadAllScheme = new DataSet(); DataTable dtLoadAllScheme = new DataTable(); if (ddlIssuer.SelectedIndex != 0) { amcCode = int.Parse(ddlIssuer.SelectedValue.ToString()); categoryCode = ddlCategory.SelectedValue; //dtLoadAllScheme = priceBo.GetAllScehmeList(amcCode); dsLoadAllScheme = priceBo.GetSchemeListCategoryConcatenation(amcCode, categoryCode); dtLoadAllScheme = dsLoadAllScheme.Tables[0]; } if (dtLoadAllScheme.Rows.Count > 0) { ddlScheme.DataSource = dtLoadAllScheme; ddlScheme.DataTextField = dtLoadAllScheme.Columns["PASP_SchemePlanName"].ToString(); ddlScheme.DataValueField = dtLoadAllScheme.Columns["PASP_SchemePlanCode"].ToString(); ddlScheme.DataBind(); ddlScheme.Items.Insert(0, new ListItem("All", "0")); } else { ddlScheme.Items.Clear(); ddlScheme.DataSource = null; ddlScheme.DataBind(); ddlScheme.Items.Insert(0, new ListItem("All", "0")); } }
private void LoadAllSchemeList(int amcCode) { DataSet dsLoadAllScheme = new DataSet(); DataTable dtLoadAllScheme = new DataTable(); if (ddlIssuer.SelectedIndex != 0) { amcCode = int.Parse(ddlIssuer.SelectedValue.ToString()); //dtLoadAllScheme = priceBo.GetAllScehmeList(amcCode); dsLoadAllScheme = priceBo.GetSchemeListCategoryConcatenation(amcCode, categoryCode); dtLoadAllScheme = dsLoadAllScheme.Tables[0]; } }
public void LoadAllSchemeNAV() { PriceBo priceBo = new PriceBo(); DataSet dsLoadAllSchemeNAV; DataTable dtLoadAllSchemeNAV = new DataTable(); int amcCode; string categoryCode; //if (ddlSelectMutualFund.SelectedIndex != 0 && ddlNAVCategory.SelectedIndex == 0) //{ amcCode = int.Parse(ddlSelectMutualFund.SelectedValue.ToString()); categoryCode = ddlNAVCategory.SelectedValue; dsLoadAllSchemeNAV = priceBo.GetSchemeListCategoryConcatenation(amcCode, "ALL"); dtLoadAllSchemeNAV = dsLoadAllSchemeNAV.Tables[0]; // } // if (ddlSelectMutualFund.SelectedIndex != 0 && ddlNAVCategory.SelectedIndex != 0) //{ // amcCode = int.Parse(ddlSelectMutualFund.SelectedValue.ToString()); // categoryCode = ddlNAVCategory.SelectedValue; // //subCategory = ddlNAVSubCategory.SelectedValue; // dsLoadAllSchemeNAV = priceBo.GetSchemeListCategoryConcatenation(amcCode, categoryCode); // dtLoadAllSchemeNAV = dsLoadAllSchemeNAV.Tables[0]; //} if (dtLoadAllSchemeNAV.Rows.Count > 0) { ddlSelectSchemeNAV.DataSource = dtLoadAllSchemeNAV; ddlSelectSchemeNAV.DataTextField = dtLoadAllSchemeNAV.Columns["PASP_SchemePlanName"].ToString(); ddlSelectSchemeNAV.DataValueField = dtLoadAllSchemeNAV.Columns["PASP_SchemePlanCode"].ToString(); ddlSelectSchemeNAV.DataBind(); ddlSelectSchemeNAV.Items.Insert(0, new System.Web.UI.WebControls.ListItem("All Scheme", "0")); } else { ddlSelectSchemeNAV.Items.Clear(); ddlSelectSchemeNAV.DataSource = null; ddlSelectSchemeNAV.DataBind(); ddlSelectSchemeNAV.Items.Insert(0, new System.Web.UI.WebControls.ListItem("All", "0")); } //ddlSelectSchemeNAV.Items.Insert(0, new System.Web.UI.WebControls.ListItem("All", "0")); }