public void LoadAdvisorFolioGrid(int CurrentPage) { List <CustomerAccountsVo> customerMFAccountsList = new List <CustomerAccountsVo>(); Dictionary <string, string> genDictAMC = new Dictionary <string, string>(); try { advisorVo = (AdvisorVo)Session["advisorVo"]; string path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString()); int count; customerMFAccountsList = customerAccountBo.GetAdviserMFAccountList(advisorVo.advisorId, mypager.CurrentPage, hdnSort.Value, out count, hdnNameFilter.Value, hdnAMCFilter.Value, out genDictAMC); if (count > 0) { lblTotalRows.Text = hdnRecordCount.Value = count.ToString(); tblPager.Visible = true; } if (customerMFAccountsList != null) { lblMsg.Visible = false; DataTable dtCustomerMFAccounts = new DataTable(); //dtProperty.Columns.Add("SI.No"); dtCustomerMFAccounts.Columns.Add("MFAccountId"); dtCustomerMFAccounts.Columns.Add("CustomerId"); dtCustomerMFAccounts.Columns.Add("PortfolioId"); dtCustomerMFAccounts.Columns.Add("Customer Name"); dtCustomerMFAccounts.Columns.Add("AMC Name"); dtCustomerMFAccounts.Columns.Add("Folio Number"); DataRow drCustomerMFAccounts; for (int i = 0; i < customerMFAccountsList.Count; i++) { drCustomerMFAccounts = dtCustomerMFAccounts.NewRow(); customerMFAccountsVo = new CustomerAccountsVo(); customerMFAccountsVo = customerMFAccountsList[i]; //drProperty[0] = (i + 1).ToString(); drCustomerMFAccounts[0] = customerMFAccountsVo.AccountId.ToString(); drCustomerMFAccounts[1] = customerMFAccountsVo.CustomerId.ToString(); drCustomerMFAccounts[2] = customerMFAccountsVo.PortfolioId.ToString(); drCustomerMFAccounts[3] = customerMFAccountsVo.CustomerName.ToString(); drCustomerMFAccounts[4] = customerMFAccountsVo.AMCName.ToString(); drCustomerMFAccounts[5] = customerMFAccountsVo.AccountNum.ToString(); dtCustomerMFAccounts.Rows.Add(drCustomerMFAccounts); } gvrMFAccounts.DataSource = dtCustomerMFAccounts; gvrMFAccounts.DataBind(); if (genDictAMC.Count > 0) { DropDownList ddlAMC = GetAMCDDL(); if (ddlAMC != null) { ddlAMC.DataSource = genDictAMC; ddlAMC.DataTextField = "Key"; ddlAMC.DataValueField = "Value"; ddlAMC.DataBind(); ddlAMC.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select AMC", "Select AMC")); } if (hdnAMCFilter.Value != "") { ddlAMC.SelectedValue = hdnAMCFilter.Value.ToString(); } } TextBox txtName = GetCustNameTextBox(); if (txtName != null) { if (hdnNameFilter.Value != "") { txtName.Text = hdnNameFilter.Value.ToString(); } } this.GetPageCount(); } else { lblMsg.Visible = true; gvrMFAccounts.DataSource = null; gvrMFAccounts.DataBind(); } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "AdvisorCustomerAccounts.ascx:LoadAdvisorFolioGrid()"); object[] objects = new object[1]; objects[0] = customerMFAccountsVo; objects[1] = customerMFAccountsList; FunctionInfo = exBase.AddObject(FunctionInfo, null);/*, objects*/ exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }