public async Task <IEnumerable <MonthModel> > HandleAsync(ListMonthWithOutcome query)
{
using (ReadModelContext db = new ReadModelContext())
{
var entities = await db.Outcomes
.OrderByDescending(o => o.When)
.Select(o => new { Year = o.When.Year, Month = o.When.Month })
.Distinct()
.ToListAsync();
return(entities
.Select(o => new MonthModel(o.Year, o.Month)));
}
}
public async Task <List <MonthModel> > HandleAsync(ListMonthWithOutcome query)
{
using (ReadModelContext db = readModelContextFactory.Create())
{
var entities = await db.Outcomes
.WhereUserKey(query.UserKey)
.Select(o => new { Year = o.When.Year, Month = o.When.Month })
.OrderByDescending(o => o.Year)
.ThenByDescending(o => o.Month)
.Distinct()
.ToListAsync();
return(entities
.Select(o => new MonthModel(o.Year, o.Month))
.ToList());
}
}
