public AddTransactionViewModel()
{
db = new AccountHistoryContext();
db.Categories.Load();
db.Accounts.Load();
Accounts = CollectionViewSource.GetDefaultView(db.Accounts.Local);
Categories = CollectionViewSource.GetDefaultView(db.Categories.Local);
Quantity = "1";
}
private void Update()
{
using (var db = new AccountHistoryContext())
{
Balance = db.Accounts.Sum(x => (int?)x.Amount) ?? 0;
MonthlyExpenses = db.Transactions.Where(x => x.Date.Month == DateTime.Now.Month && x.Date.Year == DateTime.Now.Year && x.Type == TransactionType.Expense).Sum(x => (int?)x.Amount) ?? 0;
Accounts = db.Accounts.ToList();
}
}
public PurseViewModel()
{
db = new AccountHistoryContext();
transactions = new List <Transaction>();
TransactionName = string.Empty;
TransactionType = TransactionType.Expense;
TransactionsView = CollectionViewSource.GetDefaultView(transactions);
TransactionsView.Filter = TransactionFilter;
DateRange = TransactionDateRange.Month;
}
public TransactionQueries(AccountHistoryContext context) : base(context)
{
}
public AddCreditTransactionCommandHandler(AccountHistoryContext context,
TransactionQueries transactionQueries)
{
_context = context;
_transactionQueries = transactionQueries;
}
public TransactionsController(AccountHistoryContext context)
{
_context = context;
}
public AccountsController(AccountHistoryContext context)
{
_context = context;
}
protected BaseQuery(AccountHistoryContext context)
{
_context = context;
}
