public static Boolean Get(Category cat)
{
var db = new BudgetEntities();
var query = from category in db.Categories
where category.Guid == cat.Guid
select category;
return (query.Count() > 0);
}
public static IEnumerable<Transaction> GetTransactions(Category selectedCategory = null, int year = default(int))
{
var db = new BudgetEntities();
var query = from transaction in db.Transactions
select transaction;
// if a year is specified just get transactions for that year
if (year != default(int))
query = query.Where(p => p.Date.Year == year);
// if a category is specified, only get transactions for that category
if (selectedCategory != null)
query = query.Where(p => p.TransactionCategories.Any(q => q.Category == selectedCategory.Guid));
// order by
query = query.OrderBy(p => p.Date).ThenBy(q => q.Payee1.Name);
return query;
}
public TransactionLogWindow(Category cat)
: this()
{
_selectedCategory = cat;
}