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