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