public void MonthlyFinanceReport()
{
try
{
//Call common function for login
var IsLogin = ObjCommonFunctions.CheckLogin();
if (IsLogin != null)
{
Assert.AreEqual("Index", IsLogin.RouteValues["Action"]);
Console.WriteLine("LoginController - Index With Parameters \n The assert value of Action : " + IsLogin.RouteValues["Action"]);
ReportController objReportController = new ReportController();
ReportModel objReportModel = new ReportModel();
BudgetDHTMLXGridDataModel objBudgetDHTMLXGridDataModel = new BudgetDHTMLXGridDataModel();
BudgetDHTMLXGridModel objBudgetDHTMLXGridModel = new BudgetDHTMLXGridModel();
ObjPlanCommonFunctions.SetSessionData();
DataTable dt = ObjCommonFunctions.GetExcelData("GamePlanExcelConn", "[MonthlyFinance$]").Tables[0];
var result = objReportController.GetReportBudgetData(currentYear, "months", "Plan", "") as PartialViewResult;
string MainTotalAllocated = result.ViewBag.MainTotalAllocated.ToString();
string MainTotalActual = result.ViewBag.MainTotalActual.ToString();
BudgetMonth PercAllocated = result.ViewBag.PercAllocated;
objBudgetDHTMLXGridModel = (BudgetDHTMLXGridModel)result.Model;
List <Budgetdataobj> PlanData = objBudgetDHTMLXGridModel.Grid.rows[1].data;
List <string> subHeader = objBudgetDHTMLXGridModel.AttachHeader;
string mainHeaderString = objBudgetDHTMLXGridModel.SetHeader;
string[] mainHeader = mainHeaderString.Split(',').ToArray();
VerifyHeaderValue(dt, MainTotalAllocated, MainTotalActual);
VerifyMonthlyData(dt, PlanData, mainHeader, subHeader, PercAllocated);
if (objBudgetDHTMLXGridModel.Grid.rows[1].rows != null && objBudgetDHTMLXGridModel.Grid.rows[1].rows.Count > 0)
{
var Campaign = objBudgetDHTMLXGridModel.Grid.rows[1].rows[0];
List <Budgetdataobj> CampaignData = Campaign.data;
VerifyMonthlyData(dt, CampaignData, mainHeader, subHeader);
if (Campaign.rows != null && Campaign.rows.Count > 0)
{
var program = Campaign.rows[0];
List <Budgetdataobj> programData = program.data;
VerifyMonthlyData(dt, programData, mainHeader, subHeader);
if (program.rows != null && program.rows.Count > 0)
{
var tactic = program.rows[0];
List <Budgetdataobj> tacticData = tactic.data;
VerifyMonthlyData(dt, tacticData, mainHeader, subHeader);
if (tactic.rows != null && tactic.rows.Count > 0)
{
var lineItem = tactic.rows[0];
List <Budgetdataobj> lineItemData = lineItem.data;
VerifyMonthlyData(dt, lineItemData, mainHeader, subHeader);
}
}
}
}
}
}
catch (Exception e)
{
throw e;
}
}
public void MonthlyRevenueReport()
{
try
{
//Call common function for login
var IsLogin = ObjCommonFunctions.CheckLogin();
if (IsLogin != null)
{
Assert.AreEqual("Index", IsLogin.RouteValues["Action"]);
Console.WriteLine("LoginController - Index With Parameters \n The assert value of Action : " + IsLogin.RouteValues["Action"]);
SetValuesForReport(currentyear, "Monthly");
DataTable dt = ObjCommonFunctions.GetExcelData("GamePlanExcelConn", "[Actual Data$]").Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
VerifyReport_Actual(dt, ActualList);
VerifyReport_ActualCost(dt, ActualCostList);
VerifyReport_Goal(GoalList);
VerifyReport_ProjectedRevenue(ProjectedList, GoalList, ActualList);
VerifyReport_Performance(ActualList, PerformanceList);
VerifyReport_ROI(ActualList, ActualCostList, ROIList);
VerifyReport_TotalRevenue(ActualList, TotalRevenueList);
VerifyHeaderValue(objProjected_Goal, ActualList, GoalList, ProjectedList);
VerifyCardSectionValue(objCardSection, ActualCostList);
VerifyMonthlyGraphValue(objlineChartData, dt, ProjectedList);
}
}
}
catch (Exception e)
{
throw e;
}
}
public async Task INQSummaryReport()
{
try
{
//Call common function for login
var IsLogin = ObjCommonFunctions.CheckLogin();
if (IsLogin != null)
{
Assert.AreEqual("Index", IsLogin.RouteValues["Action"]);
Console.WriteLine("LoginController - Index With Parameters \n The assert value of Action : " + IsLogin.RouteValues["Action"]);
ObjPlanCommonFunctions.SetSessionData();
SetValuesForReport(currentYear, "Monthly", "ProjectedStageValue");
decimal sumOfActual = 0; decimal sumOfProjected = 0;
Sessions.PlanExchangeRate = 1.0;
var result = await objReportController.GetOverviewData(currentYear, "Quarterly") as PartialViewResult;
objReportOverviewModel = new ReportOverviewModel();
objReportOverviewModel = (ReportOverviewModel)result.Model;
if (objReportOverviewModel != null)
{
objProjected_Goal = new Projected_Goal();
objProjected_Goal = objReportOverviewModel.conversionOverviewModel.Projected_LineChartList[0].projected_goal;
#region Actual Projected
foreach (double actual in ActualList)
{
sumOfActual = sumOfActual + Convert.ToDecimal(actual);
}
foreach (double projected in ProjectedList)
{
sumOfProjected = sumOfProjected + Convert.ToDecimal(projected);
}
INQTotalProjected = sumOfActual + sumOfProjected;
Assert.AreEqual(Math.Round(Convert.ToDecimal(objProjected_Goal.Actual_Projected), 2), Math.Round(INQTotalProjected, 2));
Console.WriteLine("ReportController -> GetOverviewData \n Report - Waterfall Summary Report \n The assert value of projected INQ in volume section " + objProjected_Goal.Actual_Projected + ".");
#endregion
#region Actual Goal
DataTable dtModel = ObjCommonFunctions.GetExcelData("GamePlanExcelConn", "[Model$]").Tables[0];
DataRow drModel = dtModel.Rows[0];
INQGoal = Convert.ToDecimal(drModel["TACTIC_PROJECTED_STAGE"].ToString());
Assert.AreEqual(Math.Round(Convert.ToDecimal(objProjected_Goal.Goal), 2), Math.Round(INQGoal, 2));
Console.WriteLine("ReportController -> GetOverviewData \n Report - Waterfall Summary Report \n The assert value of projected INQ goal in volume section " + objProjected_Goal.Goal + ".");
#endregion
#region Actual Percentage
INQPercentage = ((INQTotalProjected - INQGoal) / INQGoal) * 100;
Assert.AreEqual(Math.Round(Convert.ToDecimal(objProjected_Goal.Percentage), 2), Math.Round(INQPercentage, 2));
Console.WriteLine("ReportController -> GetOverviewData \n Report - Waterfall Summary Report \n The assert value of projected INQ percentage in volume section " + objProjected_Goal.Percentage + ".");
#endregion
}
}
}
catch (Exception e)
{
throw e;
}
}
