public async Task <List <InvType> > GetSelectableItems() { IQueryable <IGrouping <InvType, Transaction> > groups = _eveProfiteerRepository.MyTransactions().GroupBy(t => t.InvType); return(await groups.AsNoTracking() .Select(g => g.Key) .OrderBy(t => t.TypeName) .ToListAsync()); }
public Task <List <Transaction> > GetTransactions(DateTime start, DateTime end) { return(_eveProfiteerRepository.MyTransactions().Include("InvType").Where(t => t.TransactionDate >= start.Date && t.TransactionDate <= end.Date).ToListAsync()); }