Exemple #1
0
        public IReadOnlyList <DBClubInfoDto> GetClubs()
        {
            var value = _cache.Get <IReadOnlyList <DBClubInfoDto> >(ResourceCacheType.Clubs);

            if (value == null)
            {
                Logger.Information("Caching: Clubs");
                Logger.Information("Caching...");
                using (var db = GameDatabase.Open())
                {
                    var clubs       = DbUtil.Find <ClubDto>(db).ToList();
                    var clubPlayers = DbUtil.Find <ClubPlayerDto>(db).ToList();

                    var dbClubInfoList = new List <DBClubInfoDto>();
                    foreach (var clubDto in clubs)
                    {
                        var clubInfo = new DBClubInfoDto {
                            ClubDto = clubDto
                        };
                        var dbPlayerInfoList = new List <ClubPlayerInfo>();
                        foreach (var playerInfoDto in clubPlayers.Where(p => p.ClubId == clubDto.Id))
                        {
                            using (var dbC = AuthDatabase.Open())
                            {
                                var account = DbUtil.Find <AccountDto>(dbC, statement => statement
                                                                       .Where($"{nameof(AccountDto.Id):C} = @{nameof(playerInfoDto.PlayerId)}")
                                                                       .WithParameters(new { playerInfoDto.PlayerId }))
                                              .FirstOrDefault();

                                dbPlayerInfoList.Add(new ClubPlayerInfo
                                {
                                    AccountId = (ulong)playerInfoDto.PlayerId,
                                    State     = (ClubState)playerInfoDto.State,
                                    Rank      = (ClubRank)playerInfoDto.Rank,
                                    Account   = account
                                });
                            }
                        }

                        clubInfo.PlayerDto = dbPlayerInfoList.ToArray();
                        dbClubInfoList.Add(clubInfo);
                    }

                    value = dbClubInfoList.ToArray();
                }

                _cache.Set(ResourceCacheType.Clubs, value);
            }

            return(value);
        }
        public IReadOnlyList <DBClubInfoDto> GetClubs()
        {
            var value = _cache.Get <IReadOnlyList <DBClubInfoDto> >(ResourceCacheType.Clubs);

            if (value == null)
            {
                Logger.Information("Caching...");
                using (var db = GameDatabase.Open())
                {
                    var Clubs       = db.Find <ClubDto>().ToList();
                    var ClubPlayers = db.Find <ClubPlayerDto>().ToList();

                    var DBClubInfoList = new List <DBClubInfoDto>();
                    foreach (var clubDto in Clubs)
                    {
                        var ClubInfo = new DBClubInfoDto();
                        ClubInfo.ClubDto = clubDto;

                        var DBPlayerInfoList = new List <ClubPlayerInfo>();
                        foreach (var playerInfoDto in ClubPlayers.Where(p => p.ClubId == clubDto.Id))
                        {
                            AccountDto account;
                            using (var dbC = AuthDatabase.Open())
                            {
                                account = (dbC.Find <AccountDto>(statement => statement
                                                                 .Where($"{nameof(AccountDto.Id):C} = @{nameof(playerInfoDto.PlayerId)}")
                                                                 .WithParameters(new { playerInfoDto.PlayerId })))
                                          .FirstOrDefault();

                                DBPlayerInfoList.Add(new ClubPlayerInfo()
                                {
                                    AccountId = (ulong)playerInfoDto.PlayerId,
                                    State     = (ClubState)playerInfoDto.State,
                                    IsMod     = playerInfoDto.IsMod,
                                    account   = account,
                                });
                            }
                        }
                        ClubInfo.PlayerDto = DBPlayerInfoList.ToArray();
                        DBClubInfoList.Add(ClubInfo);
                    }
                    value = DBClubInfoList.ToArray();
                }

                _cache.Set(ResourceCacheType.Clubs, value);
            }
            return(value);
        }