public void SetValuesForReport(string Year, string isQuarterly) { objReportController = new ReportController(); objReportModel = new ReportModel(); objReportDataTable = new RevenueDataTable(); subModelList = new RevenueSubDataTableModel(); objRevenueToPlanModel = new RevenueToPlanModel(); objProjected_Goal = new Projected_Goal(); objCardSection = new CardSectionModel(); objlineChartData = new lineChartData(); objCardSectionListModel = new CardSectionListModel(); ObjPlanCommonFunctions.SetSessionData(); var result1 = objReportController.GetRevenueData(Year, isQuarterly) as PartialViewResult; objReportModel = (ReportModel)(result1.ViewData.Model); objRevenueToPlanModel = objReportModel.RevenueToPlanModel; objReportDataTable = objRevenueToPlanModel.RevenueToPlanDataModel; subModelList = objReportDataTable.SubDataModel; objlineChartData = objRevenueToPlanModel.LineChartModel; objProjected_Goal = objReportModel.RevenueHeaderModel; objCardSection = objReportModel.CardSectionModel; objCardSectionListModel = objCardSection.CardSectionListModel[0]; if (isQuarterly == "Monthly") { ActualList = objReportDataTable.ActualList; ProjectedList = objReportDataTable.ProjectedList; GoalList = objReportDataTable.GoalList; PerformanceList = subModelList.PerformanceList; ActualCostList = subModelList.CostList; ROIList = subModelList.ROIList; TotalRevenueList = subModelList.RevenueList; } else { QuaterlyActualList = objReportDataTable.ActualList; QuaterlyProjectedList = objReportDataTable.ProjectedList; QuaterlyGoalList = objReportDataTable.GoalList; QuaterlyPerformanceList = subModelList.PerformanceList; QuaterlyActualCostList = subModelList.CostList; QuaterlyROIList = subModelList.ROIList; QuaterlyTotalRevenueList = subModelList.RevenueList; } }
public void VerifyQuarterlyGraphValue(lineChartData objlineChartData, CardSectionListModel objCardSectionListModel) { if (objlineChartData.categories != null && objlineChartData.categories.Count > 0 && objlineChartData.series != null && objlineChartData.series.Count > 0) { List <string> categories = objlineChartData.categories; series ActualSeries = objlineChartData.series[0]; series GoalSeries = objlineChartData.series[1]; series ProjectedSeries = objlineChartData.series[2]; decimal SumOfActualSeries = 0; decimal SumOfGoalSeries = 0; decimal SumOfProjectedSeries = 0; decimal SumOfActualCostSeries = 0; lineChartData tacticLineChartData = objCardSectionListModel.LineChartData; series tacticRevenueSeries = tacticLineChartData.series[0]; series tacticCostSeries = tacticLineChartData.series[1]; #region Graph for Plan for (int i = 1; i <= ActualSeries.data.Count - 1; i++) { if (QuaterlyTotalRevenueList != null && QuaterlyTotalRevenueList.Count > 0 && QuaterlyProjectedList != null && QuaterlyProjectedList.Count > 0) { SumOfActualSeries = Convert.ToDecimal(QuaterlyTotalRevenueList[i - 1]) + Convert.ToDecimal(QuaterlyProjectedList[i - 1]); Assert.AreEqual(Math.Round(Convert.ToDecimal(ActualSeries.data[i].ToString()), 2), Math.Round(SumOfActualSeries, 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of quarterly actual revenue in graph " + QuarterList[i - 1] + " is " + ActualSeries.data[i].ToString() + "."); } } for (int i = 1; i <= GoalSeries.data.Count - 1; i++) { if (QuaterlyGoalList != null && QuaterlyGoalList.Count > 0) { SumOfGoalSeries = SumOfGoalSeries + Convert.ToDecimal(QuaterlyGoalList[i - 1]); Assert.AreEqual(Math.Round(Convert.ToDecimal(GoalSeries.data[i].ToString()), 2), Math.Round(SumOfGoalSeries, 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of quarterly goal in graph " + QuarterList[i - 1] + " is " + GoalSeries.data[i].ToString() + "."); } } for (int i = 1; i <= ProjectedSeries.data.Count - 1; i++) { decimal projectedSeries = 0; if (QuaterlyProjectedList != null && QuaterlyProjectedList.Count > 0 && QuaterlyProjectedList[i - 1] != 0) { SumOfProjectedSeries = Convert.ToDecimal(QuaterlyTotalRevenueList[i - 1]) + Convert.ToDecimal(QuaterlyProjectedList[i - 1]); } if (ProjectedSeries.data[i].ToString() == "") { projectedSeries = 0; } else { projectedSeries = Convert.ToDecimal(ProjectedSeries.data[i].ToString()); } Assert.AreEqual(Math.Round(Convert.ToDecimal(projectedSeries), 2), Math.Round(SumOfProjectedSeries, 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of quarterly projected revenue in graph " + QuarterList[i - 1] + " is " + ProjectedSeries.data[i].ToString() + "."); } #endregion #region Graph for Tactic for (int i = 0; i <= QuaterlyTotalRevenueList.Count - 1; i++) { if (QuaterlyTotalRevenueList != null && QuaterlyTotalRevenueList.Count > 0) { Assert.AreEqual(Math.Round(Convert.ToDecimal(tacticRevenueSeries.data[i].ToString()), 2), Math.Round(Convert.ToDecimal(QuaterlyTotalRevenueList[i]), 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of quarterly tactic actual revenue in graph " + QuarterList[i] + " is " + tacticRevenueSeries.data[i].ToString() + "."); } } for (int i = 0; i <= QuaterlyActualCostList.Count - 1; i++) { if (QuaterlyActualCostList != null && QuaterlyActualCostList.Count > 0) { SumOfActualCostSeries = SumOfActualCostSeries + Convert.ToDecimal(QuaterlyActualCostList[i]); Assert.AreEqual(Math.Round(Convert.ToDecimal(tacticCostSeries.data[i].ToString()), 2), Math.Round(SumOfActualCostSeries, 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of quarterly tactic actual cost in graph " + QuarterList[i] + " is " + tacticCostSeries.data[i].ToString() + "."); } } #endregion } }