private void BindGridView(int customerId, DateTime from, DateTime to)
{
string type, mode;
RadComboBox radComboBoxTradeDate = new RadComboBox();
DataSet dsExange = new DataSet();;
DataTable dtEquityTransactions = new DataTable();
DataTable dtTradeDate = new DataTable();
Dictionary <string, string> genDictTranType = new Dictionary <string, string>();
Dictionary <string, string> genDictExchange = new Dictionary <string, string>();
Dictionary <string, string> genDictTradeDate = new Dictionary <string, string>();
int Visible = 0;
try
{
if (Request.QueryString["From"] != null && Request.QueryString["To"] != null)
{
equityTransactionList = customerTransactionBo.GetEquityTransactions(customerId, int.Parse(Request.QueryString["PortfolioId"].ToString()), int.Parse(Request.QueryString["ScripCode"].ToString()), from, to, Request.QueryString["Currency"].ToString());
Visible = 1;
}
else
{
equityTransactionList = customerTransactionBo.GetEquityTransactions(customerId, portfolioId, 0, from, to, (ddl_type.SelectedValue));
}
if (equityTransactionList != null)
{
ErrorMessage.Visible = false;
gvEquityTransactions.Visible = true;
dtEquityTransactions.Columns.Add("TransactionId");
dtEquityTransactions.Columns.Add("InvestorName");
dtEquityTransactions.Columns.Add("PanNo");
dtEquityTransactions.Columns.Add("ManagerName");
dtEquityTransactions.Columns.Add("BrokerName");
dtEquityTransactions.Columns.Add("TradeAccountNum");
dtEquityTransactions.Columns.Add("DematAccountNo");
dtEquityTransactions.Columns.Add("SettlementNo");
dtEquityTransactions.Columns.Add("BillNo");
dtEquityTransactions.Columns.Add("Scheme Name");
dtEquityTransactions.Columns.Add("Scripcode");
dtEquityTransactions.Columns.Add("Transaction Type");
dtEquityTransactions.Columns.Add("Transaction Code");
dtEquityTransactions.Columns.Add("Dividend Status");
dtEquityTransactions.Columns.Add("Exchange");
dtEquityTransactions.Columns.Add("TradeDate", typeof(DateTime));
dtEquityTransactions.Columns.Add("Quantity", typeof(double));
dtEquityTransactions.Columns.Add("Rate", typeof(double));
dtEquityTransactions.Columns.Add("FORExRate");
dtEquityTransactions.Columns.Add("FORExDate", typeof(DateTime));
dtEquityTransactions.Columns.Add("Gross Trade Consideration", typeof(double));
dtEquityTransactions.Columns.Add("Brokerage", typeof(double));
dtEquityTransactions.Columns.Add("Net Rate With Brokerage", typeof(double));
dtEquityTransactions.Columns.Add("Net Trade Consideration With Brokerage", typeof(double));
dtEquityTransactions.Columns.Add("SebiTurnOverFee", typeof(double));
dtEquityTransactions.Columns.Add("TransactionCharges", typeof(double));
dtEquityTransactions.Columns.Add("StampCharges", typeof(double));
dtEquityTransactions.Columns.Add("STT", typeof(double));
dtEquityTransactions.Columns.Add("ServiceTax", typeof(double));
dtEquityTransactions.Columns.Add("OtherCharges", typeof(double));
dtEquityTransactions.Columns.Add("Difference In Amount", typeof(double));
dtEquityTransactions.Columns.Add("Net Rate With All Charges", typeof(double));
dtEquityTransactions.Columns.Add("TradeTotal", typeof(double));
dtEquityTransactions.Columns.Add("TransactionStatus");
dtEquityTransactions.Columns.Add("Purpose");
dtEquityTransactions.Columns.Add("Demat Charge", typeof(double));
dtEquityTransactions.Columns.Add("FXCurencyRate");
dtEquityTransactions.Columns.Add("MktClosingForexRate");
dtEquityTransactions.Columns.Add("CET_CreatedOn", typeof(DateTime));
DataRow drEquityTransaction;
DataRow drTradedate;
for (int i = 0; i < equityTransactionList.Count; i++)
{
drEquityTransaction = dtEquityTransactions.NewRow();
drTradedate = dtTradeDate.NewRow();
equityTransactionVo = new EQTransactionVo();
equityTransactionVo = equityTransactionList[i];
drEquityTransaction["TransactionId"] = equityTransactionVo.TransactionId.ToString();
drEquityTransaction["TradeAccountNum"] = equityTransactionVo.TradeAccountNum.ToString();
drEquityTransaction["Scheme Name"] = equityTransactionVo.ScripName.ToString();
if (equityTransactionVo.TradeType.ToString() == "D")
{
mode = "Delivery";
}
else
{
mode = "Speculation";
}
if (equityTransactionVo.TransactionCode == 1 || equityTransactionVo.TransactionCode == 2)
{
drEquityTransaction["Transaction Type"] = equityTransactionVo.TransactionType + "/" + mode;
}
else
{
drEquityTransaction["Transaction Type"] = equityTransactionVo.TransactionType;
}
drEquityTransaction["Transaction Code"] = equityTransactionVo.TransactionCode.ToString();
drEquityTransaction["Exchange"] = equityTransactionVo.Exchange.ToString();
drEquityTransaction["TradeDate"] = DateTime.Parse(equityTransactionVo.TradeDate.ToString());
drEquityTransaction["Rate"] = decimal.Parse(equityTransactionVo.Rate.ToString()).ToString();
drEquityTransaction["Quantity"] = equityTransactionVo.Quantity.ToString("f0");
drEquityTransaction["Brokerage"] = decimal.Parse(equityTransactionVo.Brokerage.ToString());
drEquityTransaction["TradeTotal"] = decimal.Parse(equityTransactionVo.TradeTotal.ToString()).ToString();
drEquityTransaction["TransactionStatus"] = equityTransactionVo.TransactionStatus.ToString();
drEquityTransaction["ManagerName"] = equityTransactionVo.ManagerName.ToString();
drEquityTransaction["BrokerName"] = equityTransactionVo.BrokerName.ToString();
drEquityTransaction["DematAccountNo"] = equityTransactionVo.DpclientId.ToString();
drEquityTransaction["Purpose"] = equityTransactionVo.Purpose.ToString();
drEquityTransaction["InvestorName"] = equityTransactionVo.InvestorName.ToString();
drEquityTransaction["PanNo"] = equityTransactionVo.PanNo.ToString();
drEquityTransaction["Scripcode"] = equityTransactionVo.Scripcode.ToString();
drEquityTransaction["SettlementNo"] = equityTransactionVo.SettlementNo.ToString();
drEquityTransaction["BillNo"] = equityTransactionVo.BillNo.ToString();
drEquityTransaction["SebiTurnOverFee"] = equityTransactionVo.SebiTurnOverFee.ToString();
drEquityTransaction["TransactionCharges"] = equityTransactionVo.TransactionCharges.ToString();
drEquityTransaction["StampCharges"] = equityTransactionVo.StampCharges.ToString();
drEquityTransaction["STT"] = equityTransactionVo.STT.ToString();
drEquityTransaction["ServiceTax"] = equityTransactionVo.ServiceTax.ToString();
drEquityTransaction["Difference In Amount"] = equityTransactionVo.DifferenceInBrokerage.ToString();
drEquityTransaction["OtherCharges"] = equityTransactionVo.OtherCharges.ToString();
drEquityTransaction["Gross Trade Consideration"] = equityTransactionVo.GrossConsideration.ToString();
drEquityTransaction["Net Rate With Brokerage"] = equityTransactionVo.RateInclBrokerage.ToString();
drEquityTransaction["Net Trade Consideration With Brokerage"] = equityTransactionVo.TradeTotalIncBrokerage.ToString();
drEquityTransaction["Net Rate With All Charges"] = equityTransactionVo.RateIncBrokerageAllCharges.ToString();
if (equityTransactionVo.DividendRecieved == true)
{
drEquityTransaction["Dividend Status"] = "Received";
}
else if (equityTransactionVo.DividendRecieved == false)
{
drEquityTransaction["Dividend Status"] = "Receivable";
}
drEquityTransaction["Demat Charge"] = equityTransactionVo.DematCharge;
drEquityTransaction["FORExRate"] = equityTransactionVo.ForExRate;
drEquityTransaction["FORExRate"] = equityTransactionVo.ForExRate;
if (equityTransactionVo.ForExRateDate != DateTime.MinValue)
{
drEquityTransaction["FORExDate"] = equityTransactionVo.ForExRateDate;
}
drEquityTransaction["FXCurencyRate"] = equityTransactionVo.FXCurencyRate;
drEquityTransaction["MktClosingForexRate"] = equityTransactionVo.MktClosingForexRate;
drEquityTransaction["CET_CreatedOn"] = DateTime.Parse(equityTransactionVo.CreatedOn.ToString());
dtEquityTransactions.Rows.Add(drEquityTransaction);
}
gvEquityTransactions.DataSource = dtEquityTransactions;
ViewState["asd"] = dtEquityTransactions;
gvEquityTransactions.DataBind();
gvEquityTransactions.Visible = true;
if (Visible == 1)
{
gvEquityTransactions.MasterTableView.GetColumn("action").Visible = false;
}
Panel1.Visible = true;
trSelectAction.Visible = true;
ddlAction.SelectedIndex = 0;
if (!advisorVo.A_IsFamilyOffice)
{
gvEquityTransactions.MasterTableView.GetColumn("ManagerName").Visible = false;
ddlAction.Items[2].Enabled = false;
ddlAction.Items[3].Enabled = false;
ddlAction.Items[4].Enabled = false;
}
if (Cache["EquityTransactionsDetails" + customerPortfolioVo.CustomerId.ToString()] == null)
{
Cache.Insert("EquityTransactionsDetails" + customerPortfolioVo.CustomerId.ToString(), dtEquityTransactions);
}
else
{
Cache.Remove("EquityTransactionsDetails" + customerPortfolioVo.CustomerId.ToString());
Cache.Insert("EquityTransactionsDetails" + customerPortfolioVo.CustomerId.ToString(), dtEquityTransactions);
}
imgBtnExport.Visible = true;
}
else
{
imgBtnExport.Visible = false;
ErrorMessage.Visible = true;
gvEquityTransactions.DataSource = null;
Panel1.Visible = false;
gvEquityTransactions.Visible = false;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "EquityTransactionsView.ascx:BindGridView()");
object[] objects = new object[2];
objects[0] = customerId;
objects[1] = equityTransactionList;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}