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 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();
}
}
