public void BindRateGrid() { try { DataTable dtEQAccRate = new DataTable(); FolioList = customeraccountBo.GetEquityRates(portfolioId); if (FolioList == null) { lblMessage.Visible = true; gvEQAccRate.DataSource = null; gvEQAccRate.DataBind(); } else { lblMessage.Visible = false; dtEQAccRate.Columns.Add("CebId"); dtEQAccRate.Columns.Add("AccountId"); dtEQAccRate.Columns.Add("Trade No"); dtEQAccRate.Columns.Add("Transaction Mode"); dtEQAccRate.Columns.Add("Transaction Type"); dtEQAccRate.Columns.Add("Rate"); dtEQAccRate.Columns.Add("Sebi Turn Over Fee"); dtEQAccRate.Columns.Add("Transaction Charges"); dtEQAccRate.Columns.Add("Stamp Charges"); dtEQAccRate.Columns.Add("STT"); dtEQAccRate.Columns.Add("Service Tax"); dtEQAccRate.Columns.Add("Start Date"); dtEQAccRate.Columns.Add("End Date"); DataRow drEQAcc; for (int i = 0; i < FolioList.Count; i++) { drEQAcc = dtEQAccRate.NewRow(); FolioVo = new CustomerAccountsVo(); FolioVo = FolioList[i]; drEQAcc["CebId"] = FolioVo.CebId; drEQAcc["AccountId"] = FolioVo.AccountId; drEQAcc["Trade No"] = FolioVo.TradeNum; if (FolioVo.TransactionMode == 1) { drEQAcc["Transaction Mode"] = "Speculative"; } else if (FolioVo.TransactionMode == 0) { drEQAcc["Transaction Mode"] = "Delivery"; } if (FolioVo.Type == "B") { drEQAcc["Transaction Type"] = "Buy"; } else if (FolioVo.Type == "S") { drEQAcc["Transaction Type"] = "Sell"; } drEQAcc["Rate"] = FolioVo.Rate; drEQAcc["Sebi Turn Over Fee"] = FolioVo.SebiTurnOverFee.ToString(); drEQAcc["Transaction Charges"] = FolioVo.TransactionCharges.ToString(); drEQAcc["Stamp Charges"] = FolioVo.StampCharges.ToString(); drEQAcc["STT"] = FolioVo.Stt.ToString(); drEQAcc["Service Tax"] = FolioVo.ServiceTax.ToString(); if (FolioVo.StartDate != DateTime.MinValue) { drEQAcc["Start Date"] = FolioVo.StartDate.ToShortDateString(); } else { drEQAcc["Start Date"] = string.Empty; } if (FolioVo.EndDate != DateTime.MinValue) { drEQAcc["End Date"] = FolioVo.EndDate.ToShortDateString(); } else { drEQAcc["End Date"] = string.Empty; } dtEQAccRate.Rows.Add(drEQAcc); } gvEQAccRate.DataSource = dtEQAccRate; gvEQAccRate.DataBind(); } if (Cache["EQAccountDetails" + portfolioId] == null) { Cache.Insert("EQAccountDetails" + portfolioId, dtEQAccRate); } else { Cache.Remove("EQAccountDetails" + portfolioId); Cache.Insert("EQAccountDetails" + portfolioId, dtEQAccRate); } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerMFFolioView.ascx:BindFolioGridView()"); object[] objects = new object[2]; objects[0] = customerVo; objects[1] = portfolioId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }