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