public BO.ChartDataBO GetBrokerageChartData(int clientID) { BO.ChartDataBO _chartData = null; try { DatabaseAccess.OpenConnection(); using (DataSet _ds = DatabaseAccess.ExecuteProcedure("P_Sale_BrokerageChartData", new List <DAL.DatabaseParameter>() { new DAL.DatabaseParameter("@ClientID", DAL.ParameterDirection.In, DAL.DataType.Int, clientID) })) { if (_ds != null && _ds.Tables.Count > 0 && _ds.Tables[0].Rows.Count > 0) { _chartData = new BO.ChartDataBO(); var _selfSeries = new BO.ChartSeriesBO() { Name = "Brokerage (Self)", Data = new List <object>() }; var _otherSeries = new BO.ChartSeriesBO() { Name = "Brokerage (Others)", Data = new List <object>() }; foreach (DataRow _dr in _ds.Tables[0].Rows) { _chartData.Categories.Add(Convert.ToString(_dr["Category"])); _selfSeries.Data.Add(_dr["BrokerageSelf"]); _otherSeries.Data.Add(_dr["BrokerageOthers"]); } _chartData.Series.Add(_selfSeries); _chartData.Series.Add(_otherSeries); } } } catch { throw; } finally { DatabaseAccess.CloseConnection(); } return(_chartData); }
public BO.ChartDataBO GetBrokerageBistributionChartData(int clientID) { BO.ChartDataBO _chartData = null; try { DatabaseAccess.OpenConnection(); using (DataSet _ds = DatabaseAccess.ExecuteProcedure("P_Sale_BrokDistributionChartData", new List <DAL.DatabaseParameter>() { new DAL.DatabaseParameter("@ClientID", DAL.ParameterDirection.In, DAL.DataType.Int, clientID) })) { if (_ds != null && _ds.Tables.Count > 0 && _ds.Tables[0].Rows.Count > 0) { _chartData = new BO.ChartDataBO(); var _series = new BO.ChartSeriesBO() { Name = "Brokerage", Data = new List <object>() }; foreach (DataRow _dr in _ds.Tables[0].Rows) { _series.Data.Add(new { Name = Convert.ToString(_dr["BrokerName"]), Y = _dr["BrokerageAmt"] }); } _chartData.Series.Add(_series); } } } catch { throw; } finally { DatabaseAccess.CloseConnection(); } return(_chartData); }
public BO.ChartDataBO GetLoanChartData(int clientID) { BO.ChartDataBO _chartData = null; try { DatabaseAccess.OpenConnection(); using (DataSet _ds = DatabaseAccess.ExecuteProcedure("P_Loan_ChartData", new List <DAL.DatabaseParameter>() { new DAL.DatabaseParameter("@ClientID", DAL.ParameterDirection.In, DAL.DataType.Int, clientID) })) { if (_ds != null && _ds.Tables.Count > 0 && _ds.Tables[0].Rows.Count > 0) { _chartData = new BO.ChartDataBO(); DataTable _data = _ds.Tables[0]; var _paSerise = new BO.ChartSeriesBO() { Name = "Total Principal Amount", Data = new List <object>() }; var _pPaidSerise = new BO.ChartSeriesBO() { Name = "Total Principal Paid", Data = new List <object>(), Stack = "Paid" }; var _iPaidSerise = new BO.ChartSeriesBO() { Name = "Total Interest Paid", Data = new List <object>(), Stack = "Paid" }; foreach (DataRow _dr in _data.Rows) { _chartData.Categories.Add(Convert.ToString(_dr["Borrower"])); _paSerise.Data.Add(_dr["TotalPrincipalAmount"]); _pPaidSerise.Data.Add(_dr["TotalPrincipalPaid"]); _iPaidSerise.Data.Add(_dr["TotalInterestPaid"]); } _chartData.Series.Add(_paSerise); _chartData.Series.Add(_iPaidSerise); _chartData.Series.Add(_pPaidSerise); } } } catch { throw; } finally { DatabaseAccess.CloseConnection(); } return(_chartData); }
public BO.ChartDataBO GetLoanInerestPaidChartData(int clientID) { BO.ChartDataBO _chartData = null; try { DatabaseAccess.OpenConnection(); using (DataSet _ds = DatabaseAccess.ExecuteProcedure("P_Loan_InerestPaidChartData", new List <DAL.DatabaseParameter>() { new DAL.DatabaseParameter("@ClientID", DAL.ParameterDirection.In, DAL.DataType.Int, clientID) })) { if (_ds != null && _ds.Tables.Count > 0 && _ds.Tables[0].Rows.Count > 0) { _chartData = new BO.ChartDataBO(); DataTable _data = _ds.Tables[0]; DataTable _categoriesDT = _ds.Tables[0].DefaultView.ToTable(true, "PayMonth"); foreach (DataRow _dr in _categoriesDT.Rows) { _chartData.Categories.Add(Convert.ToString(_dr["PayMonth"])); } foreach (DataRow _dr in _ds.Tables[0].DefaultView.ToTable(true, "Borrower").Rows) { string _borrower = _dr["Borrower"].ToString(); var _series = new BO.ChartSeriesBO() { Name = _borrower, Data = new List <object>() }; foreach (DataRow _drCat in _categoriesDT.Rows) { string _payMonth = Convert.ToString(_drCat["PayMonth"]); DataRow[] _borPayDR = _data.Select(string.Format("PayMonth='{0}' And Borrower='{1}'", _payMonth, _borrower)); if (_borPayDR.Length > 0) { _series.Data.Add(_borPayDR[0]["TotalPayAmount"]); } else { _series.Data.Add(null); } } _chartData.Series.Add(_series); } } } } catch { throw; } finally { DatabaseAccess.CloseConnection(); } return(_chartData); }