public ArrayList GetSchemeList() { ArrayList schemelist = new ArrayList(); PriceBo priceBo = new PriceBo(); ProductMFBo productMFBo = new ProductMFBo(); DataTable dtGetSchemeList = new DataTable(); dtGetSchemeList = productMFBo.GetSchemePlanOnline(0); //dtGetASBALocation = customerBo.GetASBABankLocation(prefixText); foreach (DataRow dr in dtGetSchemeList.Rows) { schemelist.Add(new System.Web.UI.WebControls.ListItem( dr["PASP_SchemePlanName"].ToString(), dr["PASP_SchemePlanCode"].ToString() )); } //List<string> names = new List<string>(); //foreach (DataRow dr in dtGetSchemeList.Rows) //{ // string item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(dr["PASP_SchemePlanName"].ToString(), dr["PASP_SchemePlanCode"].ToString()); // names.Add(item);z //} //return names.ToArray(); return(schemelist); }
public string[] GetSchemeName(string prefixText, string contextKey) //int amcCode, string categoryCode, int Sflag, int customerId) { string[] parts = contextKey.Split('/'); int amcCode = Convert.ToInt32(parts[0]); string categoryCode = parts[1]; int Sflag = Convert.ToInt32(parts[2]); int customerId = Convert.ToInt32(parts[3]); //foreach (string part in parts) //{ // Console.WriteLine(part); //} ProductMFBo productMFBo = new ProductMFBo(); DataTable dtSchemePlans; List <string> names = new List <string>(); dtSchemePlans = productMFBo.GetSchemeName(amcCode, categoryCode, Sflag, customerId).Tables[0]; foreach (DataRow dr in dtSchemePlans.Rows) { string item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(dr["PASP_SchemePlanName"].ToString(), dr["PASP_SchemePlanCode"].ToString()); names.Add(item); } return(names.ToArray()); }
private void BindCategory() { DataSet dsProductAssetCategory; ProductMFBo productMFBo = new ProductMFBo(); dsProductAssetCategory = productMFBo.GetProductAssetCategory(); DataTable dtCategory = dsProductAssetCategory.Tables[0]; ddlCategory1.DataSource = dtCategory; ddlCategory1.DataValueField = dtCategory.Columns["PAIC_AssetInstrumentCategoryCode"].ToString(); ddlCategory1.DataTextField = dtCategory.Columns["PAIC_AssetInstrumentCategoryName"].ToString(); ddlCategory1.DataBind(); ddlCategory1.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); ddlCategory2.DataSource = dtCategory; ddlCategory2.DataValueField = dtCategory.Columns["PAIC_AssetInstrumentCategoryCode"].ToString(); ddlCategory2.DataTextField = dtCategory.Columns["PAIC_AssetInstrumentCategoryName"].ToString(); ddlCategory2.DataBind(); ddlCategory2.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); ddlCategory3.DataSource = dtCategory; ddlCategory3.DataValueField = dtCategory.Columns["PAIC_AssetInstrumentCategoryCode"].ToString(); ddlCategory3.DataTextField = dtCategory.Columns["PAIC_AssetInstrumentCategoryName"].ToString(); ddlCategory3.DataBind(); ddlCategory3.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); ddlCategory4.DataSource = dtCategory; ddlCategory4.DataValueField = dtCategory.Columns["PAIC_AssetInstrumentCategoryCode"].ToString(); ddlCategory4.DataTextField = dtCategory.Columns["PAIC_AssetInstrumentCategoryName"].ToString(); ddlCategory4.DataBind(); ddlCategory4.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); }
public string[] GetSchemeList(string prefixText) { ProductMFBo productMFBo = new ProductMFBo(); DataTable dtSchemePlans; List <string> names = new List <string>(); dtSchemePlans = productMFBo.GetSchemePlanPrefix(prefixText); foreach (DataRow dr in dtSchemePlans.Rows) { string item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(dr["PASP_SchemePlanName"].ToString(), dr["PASP_SchemePlanCode"].ToString()); names.Add(item); } return(names.ToArray()); }
public string[] GetSWPSchemeNames(string prefixText, string contextKey) //int amcCode, string categoryCode, int Sflag, int customerId) { ProductMFBo productMFBo = new ProductMFBo(); DataTable dtSchemePlans; List <string> names = new List <string>(); dtSchemePlans = productMFBo.GetSWPSchemeNames(prefixText, int.Parse(contextKey)).Tables[0]; foreach (DataRow dr in dtSchemePlans.Rows) { string item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(dr["PASP_SchemePlanName"].ToString(), dr["PASP_SchemePlanCode"].ToString()); names.Add(item); } return(names.ToArray()); }
public ArrayList GetAMCWiseSchemeList(int AmcCodes) { ArrayList AMCWiseSchemeList = new ArrayList(); PriceBo priceBo = new PriceBo(); ProductMFBo productMFBo = new ProductMFBo(); DataTable dtGetSchemeList = new DataTable(); dtGetSchemeList = productMFBo.GetSchemePlanName(AmcCodes); //dtGetASBALocation = customerBo.GetASBABankLocation(prefixText); foreach (DataRow dr in dtGetSchemeList.Rows) { AMCWiseSchemeList.Add(new System.Web.UI.WebControls.ListItem( dr["PASP_SchemePlanName"].ToString(), dr["PASP_SchemePlanCode"].ToString() )); } return(AMCWiseSchemeList); }
public string[] GetInvestorScheme(string prefixText) { string exchangetype = string.Empty; if (HttpContext.Current.Session["ExchangeMode"] != null) { exchangetype = HttpContext.Current.Session["ExchangeMode"].ToString(); } ProductMFBo productMFBo = new ProductMFBo(); DataTable dtGetSchemeList = new DataTable(); List <string> schemelist = new List <string>(); dtGetSchemeList = productMFBo.GetSchemeGuess(prefixText, exchangetype == "Online" ? 1 : 0); foreach (DataRow dr in dtGetSchemeList.Rows) { string item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(dr["PASP_SchemePlanName"].ToString(), dr["PASP_SchemePlanCode"].ToString()); schemelist.Add(item); } return(schemelist.ToArray()); }
private void BindCategory(DropDownList ddlCategory) { DataSet dsProductAssetCategory; ProductMFBo productMFBo = new ProductMFBo(); dsProductAssetCategory = productMFBo.GetProductAssetCategory(); DataTable dtCategory = dsProductAssetCategory.Tables[0]; ddlCategory.DataSource = dtCategory; ddlCategory.DataValueField = dtCategory.Columns["PAIC_AssetInstrumentCategoryCode"].ToString(); ddlCategory.DataTextField = dtCategory.Columns["PAIC_AssetInstrumentCategoryName"].ToString(); ddlCategory.DataBind(); if (ddlCategory.ID.ToString() == "ddlCategory") { ddlCategory.Items.Insert(0, new System.Web.UI.WebControls.ListItem("All Categories", "0")); } else { ddlCategory.SelectedValue = "MFEQ"; } }