private void BTN_GetOverview(object sender, RoutedEventArgs e)
{
_DBConnection.GetMonthOverview(Convert.ToInt32(TXT_Overview_Month.Text), Convert.ToInt32(TXT_Overview_Year.Text));
MonthBills.Clear();
foreach (DBConnection.Bill bill in _DBConnection.MonthBills)
{
MonthBills.Add(bill);
}
RefreshBillListItems();
CalculateReviews();
}
private void RefreshBillListItems()
{
switch (_SortOptions.GetLastOption())
{
case "Id":
if (_SortOptions.GetDescending())
{
_DBConnection.Bills = Bills.OrderByDescending(x => x.Id).ToList <DBConnection.Bill>();
}
else
{
_DBConnection.Bills = Bills.OrderBy(x => x.Id).ToList <DBConnection.Bill>();
}
break;
case "Category":
if (_SortOptions.GetDescending())
{
_DBConnection.Bills = Bills.OrderByDescending(x => x.Category).ToList <DBConnection.Bill>();
}
else
{
_DBConnection.Bills = Bills.OrderBy(x => x.Category).ToList <DBConnection.Bill>();
}
break;
case "DueDate":
if (_SortOptions.GetDescending())
{
_DBConnection.Bills = Bills.OrderByDescending(x => x.DueDate).ToList <DBConnection.Bill>();
}
else
{
_DBConnection.Bills = Bills.OrderBy(x => x.DueDate).ToList <DBConnection.Bill>();
}
break;
case "ForMonth":
if (_SortOptions.GetDescending())
{
_DBConnection.Bills = Bills.OrderByDescending(x => x.ForMonth).ToList <DBConnection.Bill>();
}
else
{
_DBConnection.Bills = Bills.OrderBy(x => x.ForMonth).ToList <DBConnection.Bill>();
}
break;
case "Amount":
if (_SortOptions.GetDescending())
{
_DBConnection.Bills = Bills.OrderByDescending(x => x.Amount).ToList <DBConnection.Bill>();
}
else
{
_DBConnection.Bills = Bills.OrderBy(x => x.Amount).ToList <DBConnection.Bill>();
}
break;
case "Paid":
if (_SortOptions.GetDescending())
{
_DBConnection.Bills = Bills.OrderByDescending(x => x.Paid).ToList <DBConnection.Bill>();
}
else
{
_DBConnection.Bills = Bills.OrderBy(x => x.Paid).ToList <DBConnection.Bill>();
}
break;
}
_DBConnection.ReOrderMonthBills();
Bills.Clear();
MonthBills.Clear();
foreach (DBConnection.Bill bill in _DBConnection.Bills)
{
Bills.Add(bill);
}
foreach (DBConnection.Bill bill in _DBConnection.MonthBills)
{
MonthBills.Add(bill);
}
}