public void VerifyQuarterlyPercentageWithAttribute(decimal percentage, BudgetMonth budgetquarter, string quarter)
{
decimal data = 0;
switch (quarter)
{
case "Q1":
data = Convert.ToDecimal(budgetquarter.BudgetY1);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + quarter + " is " + data.ToString() + ".");
break;
case "Q2":
data = Convert.ToDecimal(budgetquarter.BudgetY4);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + quarter + " is " + data.ToString() + ".");
break;
case "Q3":
data = Convert.ToDecimal(budgetquarter.BudgetY7);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + quarter + " is " + data.ToString() + ".");
break;
case "Q4":
data = Convert.ToDecimal(budgetquarter.BudgetY10);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + quarter + " is " + data.ToString() + ".");
break;
}
}
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 BudgetMonthTest()
{
var assembly = typeof(MainBudget).GetTypeInfo().Assembly;
var names = assembly.GetManifestResourceNames();
var stream = assembly.GetManifestResourceStream("HomeBudgeStandard.template.json");
var jsonString = "";
using (var reader = new StreamReader(stream))
{
jsonString = reader.ReadToEnd();
}
var budgetDescription = JsonConvert.DeserializeObject <BudgetDescription>(jsonString);
var monthData = BudgetMonth.Create(budgetDescription.Categories, DateTime.Now);
using (var file = File.Create("monthTest.bin"))
{
Serializer.Serialize(file, monthData);
}
using (var file = File.OpenRead("monthTest.bin"))
{
var deserializedMonth = Serializer.Deserialize <BudgetMonth>(file);
Assert.AreEqual(monthData.GetTotalExpenseReal(), deserializedMonth.GetTotalExpenseReal());
}
}
void CreateMonthLists()
{
TableRow Row = new TableRow();
MonthLists = new ListControl[12];
int CurMonth = DateTime.Now.Month;
for (int i = 0; i < 12; i++)
{
TableCell Cell = new TableCell();
BudgetMonth BMonth = new BudgetMonth(DateTime.Now.AddMonths(i));
Cell.Controls.Add(MonthLists[i] = CreateListControl(BMonth));
Row.Cells.Add(Cell);
//MonthLists[i].AddItem(BMonth.GetName(), ItemColor.Info);
}
DataTable.Rows.Add(Row);
}
public void VerifyMonthlyData(DataTable dt, List <Budgetdataobj> data, string[] mainHeader, List <string> subHeader, BudgetMonth PercAllocated = null)
{
DataRow dr = dt.NewRow();
if (data.Count > 0 && data != null)
{
switch (data[0].value)
{
case "Plan":
dr = dt.Rows[0];
break;
case "Campaign":
dr = dt.Rows[1];
break;
case "Program":
dr = dt.Rows[2];
break;
case "Tactic":
dr = dt.Rows[3];
break;
case "LineItem":
dr = dt.Rows[4];
break;
}
string mHeader = "";
int j = 0;
for (int i = 1; i <= data.Count() - 1; i++)
{
string htmlString = data[i].value;
string budgetValue = GetBudgetData(htmlString);
if (dr != null)
{
if (i == 1)
{
Assert.AreEqual(dr[i - 1].ToString().Trim(), budgetValue.Trim());
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of " + mainHeader[i - 1] + " is " + dr[i - 1].ToString() + ".");
}
else
{
if (budgetValue.Contains("---"))
{
budgetValue = "0";
}
if (i <= 40)
{
if (!mainHeader[i].Contains('#'))
{
mHeader = mainHeader[i];
}
}
Assert.AreEqual(Math.Round(Convert.ToDecimal(dr[i - 1].ToString()), 2), Math.Round(Convert.ToDecimal(budgetValue), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of " + subHeader[i] + " of " + dr[0].ToString() + " in " + mHeader + " is " + budgetValue + ".");
if (PercAllocated != null && subHeader[i].ToLower() == "budget")
{
decimal percentage = 0;
if (Math.Round(Convert.ToDecimal(dr[i - 1].ToString())) == 0)
{
percentage = 101;
}
else
{
percentage = (Convert.ToDecimal(dr[i - 3].ToString()) / Convert.ToDecimal(dr[i - 1].ToString())) * 100;
}
VerifyMonthlyPercentage(percentage, PercAllocated, mHeader);
}
}
}
}
}
}
public void VerifyMonthlyPercentage(decimal percentage, BudgetMonth budgetMonth, string month)
{
decimal data = 0;
switch (month)
{
case "JAN":
data = Convert.ToDecimal(budgetMonth.BudgetY1);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + month + " is " + data.ToString() + ".");
break;
case "FEB":
data = Convert.ToDecimal(budgetMonth.BudgetY2);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + month + " is " + data.ToString() + ".");
break;
case "MAR":
data = Convert.ToDecimal(budgetMonth.BudgetY3);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + month + " is " + data.ToString() + ".");
break;
case "APR":
data = Convert.ToDecimal(budgetMonth.BudgetY4);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + month + " is " + data.ToString() + ".");
break;
case "MAY":
data = Convert.ToDecimal(budgetMonth.BudgetY5);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + month + " is " + data.ToString() + ".");
break;
case "JUN":
data = Convert.ToDecimal(budgetMonth.BudgetY6);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + month + " is " + data.ToString() + ".");
break;
case "JUL":
data = Convert.ToDecimal(budgetMonth.BudgetY7);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + month + " is " + data.ToString() + ".");
break;
case "AUG":
data = Convert.ToDecimal(budgetMonth.BudgetY8);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + month + " is " + data.ToString() + ".");
break;
case "SEP":
data = Convert.ToDecimal(budgetMonth.BudgetY9);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + month + " is " + data.ToString() + ".");
break;
case "OCT":
data = Convert.ToDecimal(budgetMonth.BudgetY10);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + month + " is " + data.ToString() + ".");
break;
case "NOV":
data = Convert.ToDecimal(budgetMonth.BudgetY11);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + month + " is " + data.ToString() + ".");
break;
case "DEC":
data = Convert.ToDecimal(budgetMonth.BudgetY12);
Assert.AreEqual(Math.Round(Convert.ToDecimal(percentage), 2), Math.Round(Convert.ToDecimal(data), 2));
Console.WriteLine("ReportController - GetReportBudgetData \n Report - Finance Report \n The assert value of percetage in " + month + " is " + data.ToString() + ".");
break;
}
}
