public void LoadEquityPortfolioTransactions()
{
try
{
if (eqPortfolioTransactionVoList == null)
{
}
else
{
lblCustomer.Text = customerVo.FirstName.ToString() + " " + customerVo.LastName.ToString();
lblScrip.Text = eqPortfolioVo.EQCompanyName.ToString();
lblAccount.Text = eqPortfolioVo.AccountId.ToString();
DataTable dtEqPortfolioTransaction = new DataTable();
dtEqPortfolioTransaction.Columns.Add("Date");
dtEqPortfolioTransaction.Columns.Add("Trade Type");
dtEqPortfolioTransaction.Columns.Add("Buy/Sell");
dtEqPortfolioTransaction.Columns.Add("Buy Quantity");
dtEqPortfolioTransaction.Columns.Add("Buy Price");
dtEqPortfolioTransaction.Columns.Add("Sell Quantity");
dtEqPortfolioTransaction.Columns.Add("Sell Price");
dtEqPortfolioTransaction.Columns.Add("Cost Of Acquisition");
dtEqPortfolioTransaction.Columns.Add("Realized Sales Value");
dtEqPortfolioTransaction.Columns.Add("Cost Of Sales");
dtEqPortfolioTransaction.Columns.Add("Net Cost");
dtEqPortfolioTransaction.Columns.Add("Net Holdings");
dtEqPortfolioTransaction.Columns.Add("Average Price");
dtEqPortfolioTransaction.Columns.Add("Profit/Loss");
DataRow drEqPortfolioTransaction;
for (int i = 0; i < eqPortfolioTransactionVoList.Count; i++)
{
drEqPortfolioTransaction = dtEqPortfolioTransaction.NewRow();
eqPortfolioTransactionVo = new EQPortfolioTransactionVo();
eqPortfolioTransactionVo = eqPortfolioTransactionVoList[i];
drEqPortfolioTransaction[0] = eqPortfolioTransactionVo.TradeDate.ToShortDateString();
if (eqPortfolioTransactionVo.TradeType.ToString() == "S")
{
drEqPortfolioTransaction[1] = "Speculative";
}
else
{
drEqPortfolioTransaction[1] = "Delivery";
}
drEqPortfolioTransaction[2] = eqPortfolioTransactionVo.TradeSide.ToString();
drEqPortfolioTransaction[3] = eqPortfolioTransactionVo.BuyQuantity.ToString("f4");
drEqPortfolioTransaction[4] = String.Format("{0:n4}", decimal.Parse(eqPortfolioTransactionVo.BuyPrice.ToString("f4")));
drEqPortfolioTransaction[5] = eqPortfolioTransactionVo.SellQuantity.ToString("f0");
drEqPortfolioTransaction[6] = String.Format("{0:n4}", decimal.Parse(eqPortfolioTransactionVo.SellPrice.ToString("f4")));
drEqPortfolioTransaction[7] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.CostOfAcquisition.ToString("f4")));
drEqPortfolioTransaction[8] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.RealizedSalesValue.ToString("f4")));
drEqPortfolioTransaction[9] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.CostOfSales.ToString("f4")));
drEqPortfolioTransaction[10] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.NetCost.ToString("f4")));
drEqPortfolioTransaction[11] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.NetHoldings.ToString("f4")));
drEqPortfolioTransaction[12] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.AveragePrice.ToString("f4")));
drEqPortfolioTransaction[13] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.RealizedProfitLoss.ToString("f4")));
dtEqPortfolioTransaction.Rows.Add(drEqPortfolioTransaction);
}
gvEquityPortfolio.DataSource = dtEqPortfolioTransaction;
gvEquityPortfolio.DataBind();
gvEquityPortfolio.Visible = true;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewEquityPortfolioTransactions.ascx:LoadEquityPortfolioTransactions()");
object[] objects = new object[3];
objects[0] = eqPortfolioTransactionVoList;
objects[1] = eqPortfolioTransactionVo;
objects[2] = eqPortfolioVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void sortGridViewBranches(string sortExpression, string direction)
{
try
{
eqPortfolioTransactionVoList = (List <EQPortfolioTransactionVo>)Session["EquityPortfolioTransactionList"];
DataTable dtEqPortfolioTransaction = new DataTable();
dtEqPortfolioTransaction.Columns.Add("Date");
dtEqPortfolioTransaction.Columns.Add("Trade Type");
dtEqPortfolioTransaction.Columns.Add("Buy/Sell");
dtEqPortfolioTransaction.Columns.Add("Buy Quantity");
dtEqPortfolioTransaction.Columns.Add("Buy Price");
dtEqPortfolioTransaction.Columns.Add("Sell Quantity");
dtEqPortfolioTransaction.Columns.Add("Sell Price");
dtEqPortfolioTransaction.Columns.Add("Cost Of Acquisition");
dtEqPortfolioTransaction.Columns.Add("Realized Sales Value");
dtEqPortfolioTransaction.Columns.Add("Cost Of Sales");
dtEqPortfolioTransaction.Columns.Add("Net Cost");
dtEqPortfolioTransaction.Columns.Add("Net Holdings");
dtEqPortfolioTransaction.Columns.Add("Average Price");
dtEqPortfolioTransaction.Columns.Add("Profit/Loss");
DataRow drEqPortfolioTransaction;
for (int i = 0; i < eqPortfolioTransactionVoList.Count; i++)
{
drEqPortfolioTransaction = dtEqPortfolioTransaction.NewRow();
eqPortfolioTransactionVo = new EQPortfolioTransactionVo();
eqPortfolioTransactionVo = eqPortfolioTransactionVoList[i];
drEqPortfolioTransaction[0] = eqPortfolioTransactionVo.TradeDate.ToShortDateString();
if (eqPortfolioTransactionVo.TradeType.ToString() == "S")
{
drEqPortfolioTransaction[1] = "Speculative";
}
else
{
drEqPortfolioTransaction[1] = "Delivery";
}
drEqPortfolioTransaction[2] = eqPortfolioTransactionVo.TradeSide.ToString();
drEqPortfolioTransaction[3] = eqPortfolioTransactionVo.BuyQuantity.ToString("f4");
drEqPortfolioTransaction[4] = String.Format("{0:n4}", decimal.Parse(eqPortfolioTransactionVo.BuyPrice.ToString("f4")));
drEqPortfolioTransaction[5] = eqPortfolioTransactionVo.SellQuantity.ToString("f0");
drEqPortfolioTransaction[6] = String.Format("{0:n4}", decimal.Parse(eqPortfolioTransactionVo.SellPrice.ToString("f4")));
drEqPortfolioTransaction[7] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.CostOfAcquisition.ToString("f4")));
drEqPortfolioTransaction[8] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.RealizedSalesValue.ToString("f4")));
drEqPortfolioTransaction[9] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.CostOfSales.ToString("f4")));
drEqPortfolioTransaction[10] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.NetCost.ToString("f4")));
drEqPortfolioTransaction[11] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.NetHoldings.ToString("f4")));
drEqPortfolioTransaction[12] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.AveragePrice.ToString("f4")));
drEqPortfolioTransaction[13] = String.Format("{0:n2}", decimal.Parse(eqPortfolioTransactionVo.RealizedProfitLoss.ToString("f4")));
dtEqPortfolioTransaction.Rows.Add(drEqPortfolioTransaction);
}
DataView dv = new DataView(dtEqPortfolioTransaction);
dv.Sort = sortExpression + direction;
gvEquityPortfolio.DataSource = dv;
gvEquityPortfolio.DataBind();
gvEquityPortfolio.Visible = true;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewEquityPortfolioTransactions.ascx:sortGridViewBranches()");
object[] objects = new object[3];
objects[0] = eqPortfolioTransactionVoList;
objects[1] = eqPortfolioTransactionVo;
objects[2] = eqPortfolioVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
