private void sortGridViewMFPortfolio(string sortExpression, string direction) { DataTable dtMFPortfolioTransaction = new DataTable(); dtMFPortfolioTransaction.Columns.Add("Date"); dtMFPortfolioTransaction.Columns.Add("Transaction Type"); dtMFPortfolioTransaction.Columns.Add("Buy/Sell"); dtMFPortfolioTransaction.Columns.Add("Buy Quantity"); dtMFPortfolioTransaction.Columns.Add("Buy Price"); dtMFPortfolioTransaction.Columns.Add("Sell Quantity"); dtMFPortfolioTransaction.Columns.Add("Sell Price"); dtMFPortfolioTransaction.Columns.Add("Cost Of Acquisition"); dtMFPortfolioTransaction.Columns.Add("Realized Sales Value"); dtMFPortfolioTransaction.Columns.Add("Cost Of Sales"); dtMFPortfolioTransaction.Columns.Add("Net Cost"); dtMFPortfolioTransaction.Columns.Add("Net Holdings"); dtMFPortfolioTransaction.Columns.Add("Average Price"); dtMFPortfolioTransaction.Columns.Add("Profit/Loss"); DataRow drMFPortfolioTransaction; for (int i = 0; i < mfPortfolioTransactionVoList.Count; i++) { drMFPortfolioTransaction = dtMFPortfolioTransaction.NewRow(); mfPortfolioTransactionVo = new MFPortfolioTransactionVo(); mfPortfolioTransactionVo = mfPortfolioTransactionVoList[i]; drMFPortfolioTransaction[0] = mfPortfolioTransactionVo.TransactionDate.ToShortDateString(); drMFPortfolioTransaction[1] = mfPortfolioTransactionVo.TransactionType.ToString(); drMFPortfolioTransaction[2] = mfPortfolioTransactionVo.BuySell.ToString(); drMFPortfolioTransaction[3] = mfPortfolioTransactionVo.BuyQuantity.ToString("f4"); drMFPortfolioTransaction[4] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.BuyPrice.ToString("f4"))); drMFPortfolioTransaction[5] = mfPortfolioTransactionVo.SellQuantity.ToString("f4"); drMFPortfolioTransaction[6] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.SellPrice.ToString("f4"))); drMFPortfolioTransaction[7] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.CostOfAcquisition.ToString("f4"))); drMFPortfolioTransaction[8] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.RealizedSalesValue.ToString("f4"))); drMFPortfolioTransaction[9] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.CostOfSales.ToString("f4"))); drMFPortfolioTransaction[10] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.NetCost.ToString("f4"))); drMFPortfolioTransaction[11] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.NetHoldings.ToString("f4"))); drMFPortfolioTransaction[12] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.AveragePrice.ToString("f4"))); drMFPortfolioTransaction[13] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.RealizedProfitLoss.ToString("f4"))); dtMFPortfolioTransaction.Rows.Add(drMFPortfolioTransaction); } DataView dv = new DataView(dtMFPortfolioTransaction); dv.Sort = sortExpression + direction; gvMFPortfolio.DataSource = dv; gvMFPortfolio.DataBind(); gvMFPortfolio.Visible = true; }
public void LoadEquityPortfolioTransactions() { try { if (mfPortfolioTransactionVoList == null) { } else { lblCustomer.Text = customerVo.FirstName.ToString() + " " + customerVo.LastName.ToString(); lblScrip.Text = mfPortfolioVo.SchemePlan.ToString(); lblAccount.Text = mfPortfolioVo.Folio.ToString(); realizedPL = 0; unrealizedPL = 0; totalPL = 0; DataTable dtMFPortfolioTransaction = new DataTable(); dtMFPortfolioTransaction.Columns.Add("Transaction Type"); dtMFPortfolioTransaction.Columns.Add("Buy Date"); dtMFPortfolioTransaction.Columns.Add("Buy Quantity"); dtMFPortfolioTransaction.Columns.Add("Buy Price"); dtMFPortfolioTransaction.Columns.Add("Cost Of Acquisition"); dtMFPortfolioTransaction.Columns.Add("Sell Date"); dtMFPortfolioTransaction.Columns.Add("Sell Quantity"); dtMFPortfolioTransaction.Columns.Add("Sell Price"); dtMFPortfolioTransaction.Columns.Add("Realized Sales Value"); dtMFPortfolioTransaction.Columns.Add("Current NAV"); dtMFPortfolioTransaction.Columns.Add("Current Value"); dtMFPortfolioTransaction.Columns.Add("AgeOfInvestment"); dtMFPortfolioTransaction.Columns.Add("ActualPL"); dtMFPortfolioTransaction.Columns.Add("NotionalPL"); dtMFPortfolioTransaction.Columns.Add("TotalPL"); dtMFPortfolioTransaction.Columns.Add("AbsReturn"); dtMFPortfolioTransaction.Columns.Add("AnnReturn"); dtMFPortfolioTransaction.Columns.Add("STT"); dtMFPortfolioTransaction.Columns.Add("NetSalesProceed"); dtMFPortfolioTransaction.Columns.Add("STCG"); dtMFPortfolioTransaction.Columns.Add("LTCG"); DataRow drMFPortfolioTransaction; for (int i = 0; i < mfPortfolioTransactionVoList.Count; i++) { drMFPortfolioTransaction = dtMFPortfolioTransaction.NewRow(); mfPortfolioTransactionVo = new MFPortfolioTransactionVo(); mfPortfolioTransactionVo = mfPortfolioTransactionVoList[i]; unrealizedPL = unrealizedPL + mfPortfolioTransactionVo.NotionalProfitLoss; realizedPL = realizedPL + mfPortfolioTransactionVo.RealizedProfitLoss; totalPL = totalPL + mfPortfolioTransactionVo.TotalProfitLoss; drMFPortfolioTransaction[0] = mfPortfolioTransactionVo.TransactionType.ToString(); if (mfPortfolioTransactionVo.BuyDate != DateTime.MinValue) { drMFPortfolioTransaction[1] = mfPortfolioTransactionVo.BuyDate.ToShortDateString(); } else { drMFPortfolioTransaction[1] = ""; } drMFPortfolioTransaction[2] = mfPortfolioTransactionVo.BuyQuantity.ToString("f4"); drMFPortfolioTransaction[3] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.BuyPrice.ToString("f4"))); drMFPortfolioTransaction[4] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.CostOfAcquisition.ToString("f4"))); if (mfPortfolioTransactionVo.SellDate != DateTime.MinValue) { drMFPortfolioTransaction[5] = mfPortfolioTransactionVo.SellDate.ToShortDateString(); } else { drMFPortfolioTransaction[5] = "-"; } drMFPortfolioTransaction[6] = mfPortfolioTransactionVo.SellQuantity.ToString("f4"); drMFPortfolioTransaction[7] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.SellPrice.ToString("f4"))); drMFPortfolioTransaction[8] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.RealizedSalesValue.ToString("f4"))); drMFPortfolioTransaction[9] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.CurrentNAV.ToString("f4"))); drMFPortfolioTransaction[10] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.CurrentValue.ToString("f4"))); drMFPortfolioTransaction[11] = String.Format("{0:n0}", decimal.Parse(mfPortfolioTransactionVo.AgeOfInvestment.ToString("f0"))); drMFPortfolioTransaction[12] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.RealizedProfitLoss.ToString("f4"))); drMFPortfolioTransaction[13] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.NotionalProfitLoss.ToString("f4"))); drMFPortfolioTransaction[14] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.TotalProfitLoss.ToString("f4"))); drMFPortfolioTransaction[15] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.AbsoluteReturns.ToString("f4"))); drMFPortfolioTransaction[16] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.AnnualReturns.ToString("f4"))); drMFPortfolioTransaction[17] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.STT.ToString("f4"))); drMFPortfolioTransaction[18] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.NetSalesProceed.ToString("f4"))); drMFPortfolioTransaction[19] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.STCGTax.ToString("f4"))); drMFPortfolioTransaction[20] = String.Format("{0:n4}", decimal.Parse(mfPortfolioTransactionVo.LTCGTax.ToString("f4"))); dtMFPortfolioTransaction.Rows.Add(drMFPortfolioTransaction); } gvMFPortfolio.DataSource = dtMFPortfolioTransaction; gvMFPortfolio.DataBind(); gvMFPortfolio.Visible = true; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "ViewMutualFundPortfolioTransactions.ascx:LoadEquityPortfolioTransactions()"); object[] objects = new object[1]; objects[0] = mfPortfolioTransactionVoList; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }