private void BindDetails(string bind) { int Count = 0; try { if (bind == "All") { customerCashSavingsList = customerCashSavingsBo.GetCustomerCashSavings(portfolioId, mypager.CurrentPage, hdnSort.Value, out Count); lblTotalRows.Text = hdnRecordCount.Value = Count.ToString(); if (Count > 0) { DivPager.Style.Add("display", "visible"); } if (customerCashSavingsList != null) { DivPager.Visible = true; lblMsg.Visible = false; DataTable dtCustomerCashSavings = new DataTable(); dtCustomerCashSavings.Columns.Add("CashSavingsPortfolioId"); //dtCustomerCashSavings.Columns.Add("Name"); dtCustomerCashSavings.Columns.Add("Instrument Category"); dtCustomerCashSavings.Columns.Add("AccountWithBank"); //dtCustomerCashSavings.Columns.Add("Debt Issuer"); dtCustomerCashSavings.Columns.Add("Deposit Amount"); dtCustomerCashSavings.Columns.Add("InterestAmount"); //dtCustomerCashSavings.Columns.Add("Deposit Date"); //dtCustomerCashSavings.Columns.Add("Interest Basis"); //dtCustomerCashSavings.Columns.Add("Interest Rate"); //dtCustomerCashSavings.Columns.Add("Current Value"); //dtCustomerCashSavings.Columns.Add("Remarks"); DataRow drCustomerCashSavings; for (int i = 0; i < customerCashSavingsList.Count; i++) { drCustomerCashSavings = dtCustomerCashSavings.NewRow(); customerCashSavingsVo = new CashAndSavingsVo(); accVo = new CustomerAccountsVo(); customerCashSavingsVo = customerCashSavingsList[i]; drCustomerCashSavings[0] = customerCashSavingsVo.CashSavingsPortfolioId.ToString().Trim(); //drCustomerCashSavings[1] = customerCashSavingsVo.Name.ToString().Trim(); drCustomerCashSavings[1] = customerCashSavingsVo.AssetInstrumentCategoryName.ToString().Trim(); accVo = customerAccountBo.GetCashAndSavingsAccount(Convert.ToInt32(customerCashSavingsVo.AccountId)); drCustomerCashSavings[2] = accVo.BankName.ToString(); if (customerCashSavingsVo.DepositAmount != 0) { drCustomerCashSavings[3] = String.Format("{0:n2}", decimal.Parse(customerCashSavingsVo.DepositAmount.ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); } else { drCustomerCashSavings[3] = 0; } if (customerCashSavingsVo.InterestAmntPaidOut != null) { drCustomerCashSavings[4] = String.Format("{0:n2}", decimal.Parse(customerCashSavingsVo.InterestAmntPaidOut.ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); } dtCustomerCashSavings.Rows.Add(drCustomerCashSavings); } gvCustomerCashSavings.DataSource = dtCustomerCashSavings; gvCustomerCashSavings.DataBind(); gvCustomerCashSavings.Visible = true; } else { gvCustomerCashSavings.DataSource = null; gvCustomerCashSavings.DataBind(); gvCustomerCashSavings.Visible = false; DivPager.Visible = false; lblMsg.Visible = true; } } this.GetPageCount(); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "PortfolioCashSavingsView.ascx:BindDetails()"); object[] objects = new object[5]; objects[0] = customerVo; objects[1] = bind; objects[2] = customerCashSavingsVo; objects[3] = customerCashSavingsList; objects[4] = Count; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }