public void AverageforCategoryTestYearIncams()
{
var jsonArray = TestsHelper.GetJonsArrayFromFile("TransactionsArray.json");
List <AccountMovement> accountMovements = ModelConverter.GetAccountMovmentsFromJarray(jsonArray);
accountMovements.Count.Should().Be(122);
jsonArray = TestsHelper.GetJonsArrayFromFile("CategoriesArray.json");
List <SubCategory> categorisModel = ModelConverter.GetCategoriesFromJarray(jsonArray);
categorisModel.Count.Should().Be(105);
var modementsViewModels = ModelConverter.CreateMovementsViewModels(accountMovements, categorisModel, "Felles");
modementsViewModels[0].Category.Should().BeEquivalentTo("Altibox");
string category = "Mat";
int? year = null;
int? month = null;
bool justExtrations = false;
var average = ModelOperation.AverageforCategory(modementsViewModels, category, 2017, month, justExtrations);
average.Should().Be(117.5);
}
public void GetAccountMovmentsFromSubCategoriesFile()
{
var jsonArray = TestsHelper.GetJonsArrayFromFile("CategoriesArray.json");
List <SubCategory> categorisModel = ModelConverter.GetCategoriesFromJarray(jsonArray);
categorisModel.Count.Should().Be(105);
}
public void GetAccountMovmentsFromTransactionJarray()
{
var jsonArray = TestsHelper.GetJonsArrayFromFile("TransactionsArray.json");
List <AccountMovement> accountMovements = ModelConverter.GetAccountMovmentsFromJarray(jsonArray);
accountMovements.Count.Should().Be(122);
}
public void AddSubcategoriesToMovementTest()
{
var jsonArray = TestsHelper.GetJonsArrayFromFile("CategoriesArray.json");
List <SubCategory> categorisModel = ModelConverter.GetCategoriesFromJarray(jsonArray);
categorisModel.Count.Should().Be(105);
var noko = categorisModel.Where(c => (c.Category == "Mat" || c.Category == "Familly"));
var subcategory = ModelConverter.AddSubcategoriesToMovement(noko);
subcategory.SupPorject.Should().BeEquivalentTo("Mismatch");
}
public void AddValuesToMovementsViewModelTests()
{
var jsonArray = TestsHelper.GetJonsArrayFromFile("TransactionsArray.json");
List <AccountMovement> accountMovements = ModelConverter.GetAccountMovmentsFromJarray(jsonArray);
accountMovements.Count.Should().Be(122);
MovementsViewModel movementViewModel = new MovementsViewModel();
ModelConverter.AddValuesToMovementsViewModel(accountMovements[0], ref movementViewModel);
movementViewModel.Amount.Should().Be(35);
}
public void GetPropertyValueTest()
{
var jsonArray = TestsHelper.GetJonsArrayFromFile("TransactionsArray.json");
List <AccountMovement> accountMovements = ModelConverter.GetAccountMovmentsFromJarray(jsonArray);
accountMovements.Count.Should().Be(122);
var movement = accountMovements[0];
var propertyValue = ModelConverter.GetPropertyValue(movement, "Amount");
propertyValue.Should().BeEquivalentTo(35);
}
public void GetAccountMovmentsFromSubCategoriesFile1()
{
var jsonArray = TestsHelper.GetJonsArrayFromFile("TransactionsArray.json");
List <AccountMovement> accountMovements = ModelConverter.GetAccountMovmentsFromJarray(jsonArray);
accountMovements.Count.Should().Be(122);
jsonArray = TestsHelper.GetJonsArrayFromFile("CategoriesArray.json");
List <SubCategory> categorisModel = ModelConverter.GetCategoriesFromJarray(jsonArray);
categorisModel.Count.Should().Be(105);
var modementsViewModels = ModelConverter.CreateMovementsViewModels(accountMovements, categorisModel, "Felles");
modementsViewModels[0].Category.Should().BeEquivalentTo("Altibox");
}
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 AverageforCategoryTestMonth()
{
var jsonArray = TestsHelper.GetJonsArrayFromFile("TransactionsArray.json");
List <AccountMovement> accountMovements = ModelConverter.GetAccountMovmentsFromJarray(jsonArray);
accountMovements.Count.Should().Be(122);
jsonArray = TestsHelper.GetJonsArrayFromFile("CategoriesArray.json");
List <SubCategory> categorisModel = ModelConverter.GetCategoriesFromJarray(jsonArray);
categorisModel.Count.Should().Be(105);
var modementsViewModels = ModelConverter.CreateMovementsViewModels(accountMovements, categorisModel, "Felles");
modementsViewModels[0].Category.Should().BeEquivalentTo("Altibox");
var average = ModelOperation.AverageforCategory(modementsViewModels, "Mat", null, 6, true);
average.Should().Be(117.5);
}
public static List <SubCategory> GetSubCategories()
{
var jsonArray = TestsHelper.GetJonsArrayFromFile("CategoriesArray.json");
return(ModelConverter.GetCategoriesFromJarray(jsonArray));
}
public static List <AccountMovement> GetAccountMovements()
{
var jsonArray = TestsHelper.GetJonsArrayFromFile("TransactionsArray.json");
return(ModelConverter.GetAccountMovmentsFromJarray(jsonArray));
}
public void GetJonsArrayFromSubCategoriesFile()
{
var jsonArray = TestsHelper.GetJonsArrayFromFile("CategoriesArray.json");
jsonArray.Count.Should().Be(105);
}
public void GetJonsArrayFromTransactionFile()
{
var jsonArray = TestsHelper.GetJonsArrayFromFile("TransactionsArray.json");
jsonArray.Count.Should().Be(122);
}
