public void UpdateAllUsersRating(IDbConnection connection) { var users = _gameUserService.GetGameUserList(connection, false); foreach (var user in users) { user.PvpPoint = Rand.Next(0, 10000); _gameUserService.AddOrUpdate(connection, user); } }
public void CreateAllianceRating(IDbConnection connection) { var aliances = _allianceService.GetAllAlliances(connection, true); var users = _gameUserService.GetGameUserList(connection, true); foreach (var aliance in aliances) { var aUsers = _allianceService.GetAllianceUsers(connection, aliance.Id); var userIds = aUsers.DistinctBy(i => i.UserId).Select(i => i.UserId); aliance.PvpRating = users.Where(i => userIds.Contains(i.Id)).Sum(i => i.PvpPoint); _allianceService.AddOrUpdate(connection, aliance); } }