private ToplistResult[] GetThisWeeksToplist(string userId)
{
using (var db = new Db.BgDbContext())
{
var weekAgo = DateTime.Now.AddDays(-7);
var top10 = db.Users
.OrderByDescending(u => u.Elo)
.Where(u => u.Id != Guid.Empty && u.Name != "deleted") // filter guest and deleted
.Where(u => u.Players.Any(p => p.Game.Started > weekAgo))
.Take(10)
.Select(user => new
{
id = user.Id,
name = user.Name,
elo = user.Elo,
})
.ToArray();
var results = new ToplistResult[top10.Length];
for (int i = 0; i < top10.Length; i++)
{
results[i] = new ToplistResult
{
place = i + 1,
name = top10[i].name,
elo = top10[i].elo,
you = top10[i].id.ToString() == userId
};
}
return(results);
}
}
public Toplist GetToplist()
{
var userId = GetUserId();
var thisWeek = GetThisWeeksToplist(userId);
using (var db = new Db.BgDbContext())
{
var top10 = db.Users
.OrderByDescending(u => u.Elo)
.Where(u => u.Id != Guid.Empty && u.Name != "deleted") // filter guest and deleted
.Take(10)
.Select(user => new
{
id = user.Id,
name = user.Name,
elo = user.Elo,
})
.ToArray();
var results = new ToplistResult[top10.Length];
for (int i = 0; i < top10.Length; i++)
{
results[i] = new ToplistResult
{
place = i + 1,
name = top10[i].name,
elo = top10[i].elo,
you = top10[i].id.ToString() == userId
};
}
var youEntry = db.Users.Single(u => u.Id.ToString() == userId);
// This has to be the last call, because the connection then will be closed.
var myRank = db.ExcecuteScalar("GetRank", ("Id", userId)); // to prevent reading entire table into this app a stored procedure is called on the server.
var you = new ToplistResult()
{
elo = youEntry.Elo,
name = youEntry.Name,
place = myRank,
you = true
};
var topList = new Toplist {
results = results, you = you, thisWeek = thisWeek
};
return(topList);
}
}