public void UpdateClassesTableValues() { var streamFile = TestsHelper.GetAssemblyFile("Budget Cashflow.xlsx"); using (var cashflowExcelPkg = new ExcelPackage(streamFile)) { IEnumerable <string> categoryList = TestsHelper.GetCategoryList(); var expensesWSheet = cashflowExcelPkg.Workbook.Worksheets["Expenses details"]; var yearBudgetTable = expensesWSheet.Tables["Year_budget"]; var yearExpensesTable = expensesWSheet.Tables["Table_2018"]; var monthWSheet = cashflowExcelPkg.Workbook.Worksheets["Monthly summary"]; var tblOperatingExpenses7Table = monthWSheet.Tables["tblOperatingExpenses7"]; Dictionary <string, string> monthBudgetCategoriesAddress = null; Dictionary <string, string> monthExpensesCategoriesAddress = null; // get address to Month budget table var categoriesWithoutIncome = Helpers.DeleteItemsfromIenumeration(categoryList, new List <string>() { "Åse", "Matias" }); monthBudgetCategoriesAddress = ExcelServices.GetColumnsNameAdress(categoriesWithoutIncome, yearBudgetTable); monthExpensesCategoriesAddress = ExcelServices.GetColumnsNameAdress(categoriesWithoutIncome, yearExpensesTable); ExcelServices.UpdateClassesTableValues(monthBudgetCategoriesAddress, monthExpensesCategoriesAddress, tblOperatingExpenses7Table); var saveExcel = TestsHelper.SaveExcrlPackage(cashflowExcelPkg, "UpdateClassesTableValues-Test"); saveExcel.Should().BeTrue(); } }
public void CreateExcelMonthSummaryTableFromMovementsViewModelIncomeTest() { IEnumerable <string> categoryList = TestsHelper.GetCategoryList(); var movementsViewModels = TestsHelper.GetMovementsViewModels(); using (var stream = new MemoryStream()) using (var package = new ExcelPackage(stream)) { package.Workbook.Worksheets.Add("Sheet1"); var categoriesAverageWSheet = package.Workbook.Worksheets["Sheet1"]; var excelTable = ExcelServices.CreateCategoriesMonthsAveragetest(categoriesAverageWSheet, 13, movementsViewModels, categoryList, 2019, false); var table = package.Workbook.Worksheets.FirstOrDefault().Tables.FirstOrDefault(); var start = table.Address.Start.Address; var end = table.Address.End.Address; var noko = table.WorkSheet.Cells["B6"].Value = ""; //now test that it generated properly, such as: //var sheeDefault = package.Workbook.Worksheets.FirstOrDefault(); //if (sheeDefault != null) sheeDefault.Cells["D57"].Value.Should().Be(-55); var saveExcel = TestsHelper.SaveExcrlPackage(package, "Incomes-test"); saveExcel.Should().BeTrue(); } }
public void UpdateTableValuesActualTest() { Dictionary <string, string> CategoriesAddress = null; var streamFile = TestsHelper.GetAssemblyFile("Budget Cashflow.xlsx"); using (var cashflowExcelPkg = new ExcelPackage(streamFile)) { IEnumerable <string> categoryList = TestsHelper.GetCategoryList(); var categoryListWithTotals = Helpers.AddItemsToIenumeration(categoryList, new List <string>() { "Sub Total", "Total" }); var ExpensesWSheet = cashflowExcelPkg.Workbook.Worksheets["Expenses details"]; var yearBudgetTable = ExpensesWSheet.Tables["Table_2018"]; if (yearBudgetTable != null) { CategoriesAddress = ExcelHelpers.GetNamesAdress(categoryListWithTotals, yearBudgetTable); } var yearWSheet = cashflowExcelPkg.Workbook.Worksheets["Year summary"]; var excelTable = yearWSheet.Tables["tblOperatingExpenses"]; string keyCellValue = null; if (CategoriesAddress != null) { if (CategoriesAddress.TryGetValue("Total", out keyCellValue)) { ExcelServices.UpdateTableValues(excelTable, "ACTUAL", keyCellValue); } } var saveExcel = TestsHelper.SaveExcrlPackage(cashflowExcelPkg, "Update-Test2"); saveExcel.Should().BeTrue(); } }
public void CreateExcelTableFromMovementsViewModelTest() { var jsonArray = TestsHelper.GetJonsArrayFromFile("TransactionsArray.json"); List <AccountMovement> movementsModels = ModelConverter.GetAccountMovmentsFromJarray(jsonArray); movementsModels.Count.Should().Be(122); jsonArray = TestsHelper.GetJonsArrayFromFile("CategoriesArray.json"); List <SubCategory> categorisModel = ModelConverter.GetCategoriesFromJarray(jsonArray); categorisModel.Count.Should().Be(105); IEnumerable <string> categoryList = categorisModel.Select(cat => cat.Category).Distinct(); var movementsViewModels = ModelConverter.CreateMovementsViewModels(movementsModels, categorisModel, "Felles"); movementsViewModels[0].Category.Should().BeEquivalentTo("Altibox"); ExcelWorksheet wsSheet; IEnumerable <string> categories; ExcelPackage excelPackage = new ExcelPackage(); using (var stream = new MemoryStream()) using (var package = new ExcelPackage(stream)) { package.Workbook.Worksheets.Add("Sheet1"); wsSheet = package.Workbook.Worksheets["Sheet1"]; ExcelServices.CreateExcelTableFromMovementsViewModel(movementsViewModels, wsSheet, "Transactions"); //now test that it generated properly, such as: var sheeDefault = package.Workbook.Worksheets.FirstOrDefault(); if (sheeDefault != null) { sheeDefault.Cells["D57"].Value.Should().Be(-55); } var saveExcel = TestsHelper.SaveExcrlPackage(package, "test-Temp"); saveExcel.Should().BeTrue(); } }
public void CreateAverageForYearMonthDayTest() { IEnumerable <string> categoryList = TestsHelper.GetCategoryList(); var movementsViewModels = TestsHelper.GetMovementsViewModels(); using (var stream = new MemoryStream()) using (var package = new ExcelPackage(stream)) { package.Workbook.Worksheets.Add("Sheet1"); var categoriesAverageWSheet = package.Workbook.Worksheets["Sheet1"]; ExcelServices.CreateAverageForYearMonthDay(movementsViewModels, categoriesAverageWSheet, categoryList, 0, 0, true); //now test that it generated properly, such as: //var sheeDefault = package.Workbook.Worksheets.FirstOrDefault(); //if (sheeDefault != null) sheeDefault.Cells["D57"].Value.Should().Be(-55); var saveExcel = TestsHelper.SaveExcrlPackage(package, "CreateAverageForYearMonthDay-test"); saveExcel.Should().BeTrue(); } }