public IReadOnlyCollection <BetViewModel> GetBets(int matchId)
{
using (var context = new SportsContext())
{
var bets = context.Bets.Where(b => b.MatchId == matchId).ToList();
var betIds = bets.Select(b => b.Id).ToList();
var odds = context.Odds.Where(o => betIds.Contains(o.BetId)).ToList();
// todo we may do it in DB, not sure if it will be better
var result = bets
.GroupJoin(odds, b => b.Id, o => o.BetId, (bet, oddsList) =>
new BetViewModel
{
Id = bet.Id,
Name = bet.Name,
Odds = oddsList.Select(o => new OddsViewModel
{
Id = o.Id,
Name = o.Name,
Value = o.Value
})
.ToList()
})
.ToList();
return(result);
}
}
public IReadOnlyCollection <MatchViewModel> GetMatches(int eventId)
{
using (var context = new SportsContext())
{
return(context
.Matches
.Where(s => s.EventId == eventId)
.Select(s => new MatchViewModel
{
Id = s.Id,
Name = s.Name
})
.ToList());
}
}
private async Task AddOrUpdateAsync <T>(IReadOnlyCollection <T> sports)
where T : class
{
if (sports.Count <= 0)
{
return;
}
using (var context = new SportsContext())
{
await context.BulkMergeAsync(sports);
await context.BulkSaveChangesAsync();
}
}
public IReadOnlyCollection <SportViewModel> GetSports()
{
using (var context = new SportsContext())
{
return(context
.Sports
.Include("Events")
.Select(s => new SportViewModel
{
Id = s.Id,
Name = s.Name,
EventsCount = s.Events.Count
})
.ToList());
}
}
public IReadOnlyCollection <EventViewModel> GetEvents(int sportId)
{
using (var context = new SportsContext())
{
return(context
.Events
.Include("Matches")
.Where(s => s.SportId == sportId)
.Select(s => new EventViewModel
{
Id = s.Id,
Name = s.Name,
MatchesCount = s.Matches.Count
})
.ToList());
}
}