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 void BindProductAmc() { PriceBo priceBo = new PriceBo(); DataTable dtGetMutualFundList = new DataTable(); dtGetMutualFundList = priceBo.GetMutualFundList(); BindMutualFundDropDowns(ddlIssuer, dtGetMutualFundList); BindMutualFundDropDowns(ddlRequestAmc, dtGetMutualFundList); }
public void BindMutualFundDropDowns() { PriceBo priceBo = new PriceBo(); DataTable dtGetMutualFundList = new DataTable(); dtGetMutualFundList = priceBo.GetMutualFundList(); ddlIssuer.DataSource = dtGetMutualFundList; ddlIssuer.DataTextField = dtGetMutualFundList.Columns["PA_AMCName"].ToString(); ddlIssuer.DataValueField = dtGetMutualFundList.Columns["PA_AMCCode"].ToString(); ddlIssuer.DataBind(); ddlIssuer.Items.Insert(0, new ListItem("All", "0")); }
public ArrayList GetAMCList() { ArrayList list = new ArrayList(); CommonLookupBo commonLookupBo = new CommonLookupBo(); PriceBo priceBo = new PriceBo(); DataTable dtGetAMCList = new DataTable(); dtGetAMCList = commonLookupBo.GetProdAmc(); foreach (DataRow dr in dtGetAMCList.Rows) { list.Add(new System.Web.UI.WebControls.ListItem( dr["PA_AMCName"].ToString(), dr["PA_AMCCode"].ToString() )); } return(list); }
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 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")); }
protected void OnClick_Submit(object sender, EventArgs e) { PriceBo PriceObj = new PriceBo(); DataSet ds; lblIllegal.Visible = false; //hdnSchemeSearch.Value = null; //hdnCompanySearch.Value = null; if (ddlAssetGroup.SelectedValue == "0") { lblIllegal.Visible = true; lblIllegal.Text = "Select Asset"; } else if (rbtnCurrent.Checked) { if (ddlAssetGroup.SelectedValue == Contants.Source.Equity.ToString()) { string Search = hdnCompanySearch.Value; hdnEquityCount.Value = PriceObj.GetEquityCountSnapshot("C", Search, mypager.CurrentPage).ToString(); lblTotalRows.Text = hdnEquityCount.Value; GetPageCount_Equity(); ds = PriceObj.GetEquitySnapshot("D", Search, mypager.CurrentPage); gvEquityRecord.DataSource = ds; gvEquityRecord.DataBind(); DivEquity.Style.Add("display", "visible"); DivPager.Style.Add("display", "visible"); DivMF.Style.Add("display", "none"); Search = null; hdnCompanySearch.Value = null; } else { string Search = hdnSchemeSearch.Value; hdnMFCount.Value = PriceObj.GetAMFICountSnapshot("C", Search, mypager.CurrentPage).ToString(); lblMFTotalRows.Text = hdnMFCount.Value; GetPageCount_MF(); ds = PriceObj.GetAMFISnapshot("D", Search, mypager.CurrentPage); gvMFRecord.DataSource = ds.Tables[0];; gvMFRecord.DataBind(); DivMF.Style.Add("display", "visible"); DivEquity.Style.Add("display", "none"); DivPager.Style.Add("display", "visible"); Search = null; hdnSchemeSearch.Value = null; } } else if (rbtnHistorical.Checked) { DateTime StartDate = DateTime.Parse(txtFromDate.Text.ToString()); DateTime EndDate = DateTime.Parse(txtToDate.Text.ToString()); hdnFromDate.Value = StartDate.ToString(); hdnToDate.Value = EndDate.ToString(); if (ddlAssetGroup.SelectedValue == Contants.Source.Equity.ToString()) { string Search = hdnCompanySearch.Value; //Search = null; hdnEquityCount.Value = PriceObj.GetEquityCount("C", StartDate, EndDate, Search, mypager.CurrentPage).ToString(); lblTotalRows.Text = hdnEquityCount.Value; GetPageCount_Equity(); ds = PriceObj.GetEquityRecord("D", StartDate, EndDate, Search, mypager.CurrentPage); gvEquityRecord.DataSource = ds; gvEquityRecord.DataBind(); DivEquity.Style.Add("display", "visible"); DivMF.Style.Add("display", "none"); DivPager.Style.Add("display", "visible"); //hdnCompanySearch.Value = null; } else if (ddlAssetGroup.SelectedValue == Contants.Source.MF.ToString()) { string Search = hdnSchemeSearch.Value; hdnMFCount.Value = PriceObj.GetAMFICount("C", StartDate, EndDate, Search, mypager.CurrentPage).ToString(); lblMFTotalRows.Text = hdnMFCount.Value; ds = PriceObj.GetAMFIRecord("D", StartDate, EndDate, Search, mypager.CurrentPage); gvMFRecord.DataSource = ds.Tables[0]; gvMFRecord.DataBind(); GetPageCount_MF(); DivPager.Style.Add("display", "visible"); DivMF.Style.Add("display", "visible"); DivEquity.Style.Add("display", "none"); //Search = null; //hdnSchemeSearch.Value = null; } } }