示例#1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="members"></param>
        /// <param name="leaderboardType"></param>
        /// <param name="take"></param>
        /// <returns></returns>
        public static IEnumerable <PartyHost> GetTopPartyHosts(this MembershipHelper members, LeaderboardType leaderboardType, int take)
        {
            List <PartyHost> partyHosts = new List <PartyHost>();

            PartyHost partyHost = null;

            DatabaseContext databaseContext = ApplicationContext.Current.DatabaseContext;

            switch (leaderboardType)
            {
            case LeaderboardType.MostGuests:

                foreach (dynamic mostGuest in databaseContext.Database.Fetch <dynamic>(@"
                                                                                            SELECT      TOP " + take + @"  
                                                                                                        PartyGuid,
                                                                                                        COUNT(MemberId) AS Partiers
                                                                                            FROM        wonderlandMemberParty
                                                                                            GROUP BY    PartyGuid
                                                                                            ORDER BY    Partiers DESC
                                                                                        "))
                {
                    partyHost = members.GetPartyHost((Guid)mostGuest.PartyGuid);

                    if (partyHost != null)
                    {
                        partyHost.TotalGuests = mostGuest.Partiers;
                        partyHosts.Add(partyHost);
                    }
                    else
                    {
                        LogHelper.Error(typeof(MembershipHelperExtensions), "GetTopPartyHosts", new Exception("Host with party guid: " + ((Guid)mostGuest.PartyGuid).ToString() + " not found in Examine"));
                    }
                }

                break;

            case LeaderboardType.TopFundraisers:

                foreach (dynamic topFundraiser in databaseContext.Database.Fetch <dynamic>(@"
                                                                                                SELECT      TOP " + take + @"
                                                                                                            PartyGuid,
                                                                                                            SUM(Amount) AS Amount
                                                                                                FROM        wonderlandDonation
                                                                                                WHERE       Success = 1
                                                                                                GROUP BY    PartyGuid
                                                                                                ORDER BY    Amount DESC
                                                                                            "))
                {
                    partyHost = members.GetPartyHost((Guid)topFundraiser.PartyGuid);

                    if (partyHost != null)
                    {
                        partyHost.AmountRaised = topFundraiser.Amount;
                        partyHosts.Add(partyHost);
                    }
                    else
                    {
                        LogHelper.Error(typeof(MembershipHelperExtensions), "GetTopPartyHosts", new Exception("Host with party guid: " + ((Guid)topFundraiser.PartyGuid).ToString() + " not found in Examine"));
                    }
                }

                break;
            }

            return(partyHosts);
        }