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