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";
}
}