public IEnumerable <ExpenseListDto> GetAll()
{
return(_db.GetExpenses().Select(x => new ExpenseListDto
{
Id = x.Id, Omschrijving = x.Omschrijving, Bedrag = x.Bedrag, Datum = x.Datum
}));
}
public IEnumerable <ExpenseListDto> GetMany()
{
return(_expenseDatabase.GetExpenses()
.Select(x =>
new ExpenseListDto
{
Id = x.Id,
Description = x.Description,
Date = x.Date,
Value = x.Value
}));
}
public IActionResult Index()
{
var expenses = _expenseDatabase.GetExpenses().Select(x => new ExpenseIndexViewModel
{
Bedrag = x.Bedrag,
Categorie = x.Categorie,
Datum = x.Datum,
Id = x.Id,
Omschrijving = x.Omschrijving
});
return(View(expenses));
}
public IActionResult Index()
{
List <ExpenseListItemViewModel> expenseList = _expenseDatabase.GetExpenses().OrderBy(s => s.Datum).Select(expense => new ExpenseListItemViewModel
{
Id = expense.Id,
Omschrijving = expense.Omschrijving,
Bedrag = expense.Bedrag,
Datum = expense.Datum,
Categorie = expense.Categorie
}).ToList();
return(View(new ExpenseListViewModel
{
List = expenseList,
Years = GetYears(),
Highest = expenseList.Where(s => s.Bedrag == HoogsteBedrag(expenseList)).ToList(),
Lowest = expenseList.Where(s => s.Bedrag == laagsteBedrag(expenseList)).ToList(),
MostExpensiveDays = ExpensesPerDay(expenseList).Where(s => s.Value == ExpensesPerDay(expenseList).OrderBy(s => s.Value).Last().Value).ToDictionary(s => s.Key, s => s.Value),
MostExpensiveCategories = CostsOfCategories(expenseList).Where(s => s.Value == CostsOfCategories(expenseList).OrderBy(s => s.Value).Last().Value).ToDictionary(s => s.Key, s => s.Value),
CheapestCategories = CostsOfCategories(expenseList).Where(s => s.Value == CostsOfCategories(expenseList).OrderBy(s => s.Value).First().Value).ToDictionary(s => s.Key, s => s.Value)
}));
}
public List <ExpensesIndexViewModel> CreateExpensesList()
{
List <Expense> expensesFromDB = _expensesDB.GetExpenses();
List <ExpensesIndexViewModel> expensesInList = new List <ExpensesIndexViewModel>();
if (expensesFromDB.Count != 0)
{
for (int i = 0; i < expensesFromDB.Count; i++)
{
Expense expense = expensesFromDB.ElementAt(i);
ExpensesIndexViewModel expenseModel = new ExpensesIndexViewModel
{
Amount = expense.Amount,
Date = expense.Date,
ID = expense.ID
};
bool Added = false;
if (i != 0)
{
int count = expensesInList.Count;
for (int j = 0; j < count; j++)
{
if ((expenseModel.Date < expensesInList.ElementAt(j).Date) && !Added)
{
expensesInList.Insert(j, expenseModel);
Added = true;
}
else
{
if ((j == (count - 1)) && !Added)
{
expensesInList.Add(expenseModel);
Added = true;
}
}
}
}
else
{
expensesInList.Add(expenseModel);
}
}
}
return(expensesInList);
}
