private void BindEQLedgerMIS(int CustomerId, int TradeAccountId, int BankAccountId)
{
DataSet dsGetEqLedgerMIS;
DataTable dtGetEqLedgerMIS;
dsGetEqLedgerMIS = customerTransactionBo.GetEquityLedgerMIS(CustomerId, TradeAccountId, BankAccountId);
dtGetEqLedgerMIS = dsGetEqLedgerMIS.Tables[0];
DataTable dtEqLedgerMISDetails = new DataTable();
dtEqLedgerMISDetails.Columns.Add("MarginDetails");
dtEqLedgerMISDetails.Columns.Add("Amount");
dtEqLedgerMISDetails.Columns.Add("CurrentValuation");
dtEqLedgerMISDetails.Columns.Add("ProfitLoss");
DataRow drEqLedgerMISDetails;
foreach (DataRow dr in dtGetEqLedgerMIS.Rows)
{
drEqLedgerMISDetails = dtEqLedgerMISDetails.NewRow();
if (dr["TYPE"].ToString() == "A")
{
drEqLedgerMISDetails["MarginDetails"] = "Cheques received (deposit)";
}
else if (dr["TYPE"].ToString() == "B")
{
drEqLedgerMISDetails["MarginDetails"] = "Withdrawl to Date";
}
else if (dr["TYPE"].ToString() == "C")
{
drEqLedgerMISDetails["MarginDetails"] = "Amount Invested";
}
else if (dr["TYPE"].ToString() == "D")
{
drEqLedgerMISDetails["MarginDetails"] = "Balance Margin";
}
if (Math.Round(decimal.Parse(dr["Amount"].ToString()), 0) != 0)
{
drEqLedgerMISDetails["Amount"] = Math.Round(decimal.Parse(dr["Amount"].ToString()), 0);
}
else
{
drEqLedgerMISDetails["Amount"] = "";
}
if (Math.Round(decimal.Parse(dr["CurrentValue"].ToString()), 0) != 0)
{
drEqLedgerMISDetails["CurrentValuation"] = Math.Round(decimal.Parse(dr["CurrentValue"].ToString()), 0);
}
else
{
drEqLedgerMISDetails["CurrentValuation"] = "";
}
if (Math.Round(decimal.Parse(dr["ProfitLoss"].ToString()), 0) != 0)
{
drEqLedgerMISDetails["ProfitLoss"] = Math.Round(decimal.Parse(dr["ProfitLoss"].ToString()), 0);
}
else
{
drEqLedgerMISDetails["ProfitLoss"] = "";
}
dtEqLedgerMISDetails.Rows.Add(drEqLedgerMISDetails);
}
if (dtEqLedgerMISDetails != null)
{
gvEqMIS.Visible = true;
imgbtnEqMIS.Visible = true;
gvEqMIS.DataSource = dtEqLedgerMISDetails;
gvEqMIS.DataBind();
}
else
{
gvEqMIS.Visible = false;
gvEqMIS.DataSource = null;
gvEqMIS.DataBind();
imgbtnEqMIS.Visible = false;
}
if (Cache["gvEqMIS" + userVo.UserId] == null)
{
Cache.Insert("gvEqMIS" + userVo.UserId, dtEqLedgerMISDetails);
}
else
{
Cache.Remove("gvEqMIS" + userVo.UserId);
Cache.Insert("gvEqMIS" + userVo.UserId, dtEqLedgerMISDetails);
}
}