/// <summary>
/// Get League Scoring Breakdown by season week id
/// </summary>
/// <param name="seasonWeekId">The season week id representing the season week.</param>
public IEnumerable<OwnerPoints> GetLeaguePoints(int seasonWeekId)
{
List<OwnerPoints> ownerPoints = new List<OwnerPoints>();
foreach (var owner in context.Owners)
{
OwnerPoints ownerPoint = new OwnerPoints { OwnerId = owner.OwnerId, OwnerName = owner.OwnerName, TeamName = owner.TeamName, UniqueId = owner.UniqueId, SeasonWeekId = seasonWeekId, TotalPoints = 0 };
ownerPoints.Add(ownerPoint);
}
var query = NPGGFFLApi.queries.LeaguePointsQuery;
query = query.Replace("{{:PlayerPointsQuery}}", NPGGFFLApi.queries.PlayerPointsQuery);
query = query.Replace("{{:GameFilter}}", string.Empty);
query = query.Replace("{{:PlayerFilter}}", string.Empty);
query = query.Replace("{{:OwnerFilter}}", string.Empty);
query = query.Replace("{{:SeasonWeekFilter}}", string.Format("and pp.SeasonWeekId = {0}", seasonWeekId));
var leaguePointsThisWeek = context.ExecuteQuery<OwnerPoints>(query);
foreach (var pptw in leaguePointsThisWeek)
{
var ownerPointExists = ownerPoints.Where(op => op.OwnerId == pptw.OwnerId).FirstOrDefault();
if (ownerPointExists != null)
{
ownerPointExists.TotalPoints = Math.Round(pptw.TotalPoints, 2);
}
}
return ownerPoints.OrderByDescending(op => op.TotalPoints).ThenBy(op => op.OwnerName);
}
public OwnerPoints GetLeaguePoints(string uniqueId, int seasonWeekId)
{
List<OwnerPoints> ownerPoints = new List<OwnerPoints>();
var owner = context.Owners.Where(o => o.UniqueId == uniqueId).First();
OwnerPoints ownerPoint = new OwnerPoints { OwnerId = owner.OwnerId, OwnerName = owner.OwnerName, TeamName = owner.TeamName, UniqueId = owner.UniqueId, SeasonWeekId = seasonWeekId, TotalPoints = 0 };
var query = NPGGFFLApi.queries.LeaguePointsQuery;
query = query.Replace("{{:PlayerPointsQuery}}", NPGGFFLApi.queries.PlayerPointsQuery);
query = query.Replace("{{:GameFilter}}", string.Empty);
query = query.Replace("{{:PlayerFilter}}", string.Empty);
query = query.Replace("{{:OwnerFilter}}", string.Format("and o.OwnerId = {0}", owner.OwnerId));
query = query.Replace("{{:SeasonWeekFilter}}", string.Format("and pp.SeasonWeekId = {0}", seasonWeekId));
var ownerPointsForWeek = context.ExecuteQuery<OwnerPoints>(query).FirstOrDefault();
if (ownerPointsForWeek != null)
{
ownerPoint.TotalPoints = Math.Round(ownerPointsForWeek.TotalPoints, 2);
}
return ownerPoint;
}