public DataSet GetComprehensiveNetworthSummary(PortfolioReportVo report, int adviserId) { PortfolioReportsDao portfolioReport = new PortfolioReportsDao(); DataSet dsComprehensiveNetworthSummary = null; try { dsComprehensiveNetworthSummary = portfolioReport.GetComprehensiveNetworthSummary(report, adviserId); } catch (Exception ex) { } return(dsComprehensiveNetworthSummary); }
public DataSet GetCustomerAssetAllocationDetails(PortfolioReportVo report, int adviserId, string reportType) { PortfolioReportsDao portfolioReport = new PortfolioReportsDao(); DataSet dsAssetAllocation = null; try { dsAssetAllocation = portfolioReport.GetCustomerAssetAllocationDetails(report, adviserId, reportType); } catch (Exception ex) { } return(dsAssetAllocation); }
public DataSet GetPortfolioSummary(PortfolioReportVo report, int adviserId) { PortfolioReportsDao portfolioReports = new PortfolioReportsDao(); DataSet dsPortfolio = new DataSet(); DataTable dtAssetPrevious = new DataTable(); DataTable dtAssetCurrent = new DataTable(); DataTable dtAssets = new DataTable(); //DataTable dtLiabilities = new DataTable(); dtAssets.Columns.Add("PortfolioId"); dtAssets.Columns.Add("AssetType"); dtAssets.Columns.Add("PreviousValue", Type.GetType("System.Double")); dtAssets.Columns.Add("CurrentValue", Type.GetType("System.Double")); dtAssets.Columns.Add("CustomerId", Type.GetType("System.Int64")); dtAssets.Columns.Add("CustomerName"); dtAssets.Columns.Add("PortfolioName"); DataSet dsPortfolioSummary = portfolioReports.GetPortfolioSummary(report, adviserId); dtAssetCurrent = dsPortfolioSummary.Tables[0]; dtAssetPrevious = dsPortfolioSummary.Tables[1]; //dtAssetCurrent.Merge(dtAssetPrevious); try { foreach (DataRow drCurrent in dtAssetCurrent.Rows) { foreach (DataRow drPrevious in dtAssetPrevious.Rows) { if (drCurrent["PortfolioId"].ToString() == drPrevious["PortfolioId"].ToString() && drCurrent["AssetType"].ToString() == drPrevious["AssetType"].ToString()) { drCurrent["PreviousValue"] = Convert.ToInt64(drPrevious["PreviousValue"]); break; } } dtAssets.ImportRow(drCurrent); } foreach (DataRow drPrevious in dtAssetPrevious.Rows) { string expression = string.Empty; expression = "PortfolioId = " + drPrevious["PortfolioId"] + " and AssetType = '" + drPrevious["AssetType"] + "'"; if (dtAssets.Select(expression) == null) { dtAssets.ImportRow(drPrevious); break; } } } catch (Exception ex) { throw ex; } dsPortfolio.Tables.Add(dtAssets); dsPortfolioSummary.Tables[2].TableName = "dtLiabilities"; dsPortfolio.Tables.Add(dsPortfolioSummary.Tables[2].Copy()); DataTable dtNetWorth = CalculateCustomersNetWorth(dsPortfolio); //DataTable dtNetWorth = CalculateNetWorth(dsPortfolio); dsPortfolio.Tables.Add(dtNetWorth); return(dsPortfolio); }