Esempio n. 1
0
 internal PollsQueryBuilder(Group group, User accessingUser, Guid[] groupsToQuery, PollsApi.PollsListOptions options)
 {
     query = options;
     _group = group;
     _accessingUser = accessingUser;
     _groupsToQuery = groupsToQuery;
     _parameters = new List<SqlParameter>();
 }
Esempio n. 2
0
 internal PollsQueryBuilder(Group group, User accessingUser, Guid[] groupsToQuery, PollsApi.PollsListOptions options)
 {
     query          = options;
     _group         = group;
     _accessingUser = accessingUser;
     _groupsToQuery = groupsToQuery;
     _parameters    = new List <SqlParameter>();
 }
 private static string PollsCacheKey(Guid applicationId, PollsApi.PollsListOptions options)
 {
     return(string.Concat("Polling_PK_Polls:"
                          , TEApi.Users.AccessingUser.Id.Value
                          , ":", applicationId
                          , ":", options.IsEnabled
                          , ":", options.IsSuspectedAbusive
                          , ":", options.AuthorUserId
                          , ":", options.PageIndex
                          , ":", options.PageSize
                          , ":", options.SortBy
                          , ":", options.SortOrder));
 }
        internal static PagedList <Poll> ListPolls(int groupId, PollsApi.PollsListOptions options)
        {
            var group = TEApi.Groups.Get(new GroupsGetOptions()
            {
                Id = groupId
            });

            if (group == null)
            {
                return(new PagedList <Poll>());
            }

            Guid[] filterGroupIds = null;
            if (options.IncludeSubGroups == true)
            {
                var groupsToQuery = TEApi.Groups.List(new GroupsListOptions()
                {
                    IncludeAllSubGroups = true, ParentGroupId = groupId, PageSize = 9999
                });
                groupsToQuery.Add(group);

                IEnumerable <Guid> ids;
                ids = from g1 in groupsToQuery
                      select g1.ApplicationId;

                filterGroupIds = ids.ToArray();

                if (filterGroupIds.Length == 0)
                {
                    return(new PagedList <Poll>());
                }
            }

            //PagedList<Poll> polls = (PagedList<Poll>)CacheService.Get(PollsCacheKey(group.ApplicationId, options), CacheScope.Context | CacheScope.Process);
            //if (polls == null)
            //{
            var polls = PollingDataService.ListPolls(group, TEApi.Users.AccessingUser, filterGroupIds, options);

            //CacheService.Put(PollsCacheKey(group.ApplicationId, options), polls, CacheScope.Context | CacheScope.Process, new string[] { PollTag(group.ApplicationId) });
            //}

            return(polls);
        }
Esempio n. 5
0
        public static PagedList<Poll> List(int groupId, PollsListOptions options)
        {
            if (options == null)
                options = new PollsListOptions();

            if (options.PageSize > 100)
                options.PageSize = 100;
            else if (options.PageSize < 1)
                options.PageSize = 1;

            if (options.PageIndex < 0)
                options.PageIndex = 0;

            try
            {
                if (string.Equals(options.SortBy, "TopPollsScore", StringComparison.OrdinalIgnoreCase))
                {
                    var group = TEApi.Groups.Get(new GroupsGetOptions { Id = groupId });
                    if (group == null || group.HasErrors())
                        return new PagedList<Poll>();

                    var scores = TEApi.CalculatedScores.List(Plugins.TopPollsScore.ScoreId, new CalculatedScoreListOptions { ApplicationId = group.ApplicationId, ContentTypeId = ContentTypeId, PageIndex = options.PageIndex, PageSize = options.PageSize, SortOrder = "Descending" });

                    var polls = new List<Poll>();
                    foreach (var score in scores)
                    {
                        if (score.Content != null)
                        {
                            var poll = Get(score.Content.ContentId);
                            if (poll != null)
                                polls.Add(poll);
                        }
                    }

                    return new PagedList<Poll>(polls, scores.PageSize, scores.PageIndex, scores.TotalCount);
                }
                else
                {
                    var polls = InternalApi.PollingService.ListPolls(groupId, options);
                    return new PagedList<Poll>(polls.Select(x => new Poll(x)), polls.PageSize, polls.PageIndex, polls.TotalCount);
                }
            }
            catch (Exception ex)
            {
                return new PagedList<Poll>(new AdditionalInfo(new Error(ex.GetType().FullName, ex.Message)));
            }
        }
Esempio n. 6
0
        internal static PagedList <Poll> ListPolls(Telligent.Evolution.Extensibility.Api.Entities.Version1.Group group, User user, Guid[] filterGroupIds, PollsApi.PollsListOptions options)
        {
            List <Poll> polls = new List <Poll>();

            using (var connection = GetSqlConnection())
            {
                using (var command = CreateSprocCommand("[polling_Polls_List]", connection))
                {
                    PollsQueryBuilder queryBuilder = new PollsQueryBuilder(group, user, filterGroupIds, options);

                    command.Parameters.Add("@sql", SqlDbType.NVarChar, -1).Value     = queryBuilder.BuildQuery();
                    command.Parameters.Add("@TotalRecords", SqlDbType.Int).Direction = ParameterDirection.Output;

                    for (int i = 0; i < queryBuilder.SqlParameters.Length; i++)
                    {
                        command.Parameters.Add(queryBuilder.SqlParameters[i]);
                    }

                    connection.Open();
                    using (var reader = command.ExecuteReader())
                    {
                        Dictionary <Guid, Poll> pollsById = new Dictionary <Guid, Poll>();

                        while (reader.Read())
                        {
                            var poll = PopulatePoll(reader);
                            pollsById[poll.Id] = poll;
                            polls.Add(poll);
                        }

                        reader.NextResult();

                        while (reader.Read())
                        {
                            var  pollAnswer = PopulatePollAnswer(reader);
                            Poll poll;
                            if (pollsById.TryGetValue(pollAnswer.PollId, out poll))
                            {
                                poll.Answers.Add(pollAnswer);
                            }
                        }

                        reader.Close();
                    }
                    connection.Close();

                    return(new PagedList <Poll>(polls, options.PageSize, options.PageIndex, (int)command.Parameters["@TotalRecords"].Value));
                }
            }
        }
        public static PagedList <Poll> List(int groupId, PollsListOptions options)
        {
            if (options == null)
            {
                options = new PollsListOptions();
            }

            if (options.PageSize > 100)
            {
                options.PageSize = 100;
            }
            else if (options.PageSize < 1)
            {
                options.PageSize = 1;
            }

            if (options.PageIndex < 0)
            {
                options.PageIndex = 0;
            }

            try
            {
                if (string.Equals(options.SortBy, "TopPollsScore", StringComparison.OrdinalIgnoreCase))
                {
                    var group = TEApi.Groups.Get(new GroupsGetOptions {
                        Id = groupId
                    });
                    if (group == null || group.HasErrors())
                    {
                        return(new PagedList <Poll>());
                    }

                    var scores = TEApi.CalculatedScores.List(Plugins.TopPollsScore.ScoreId, new CalculatedScoreListOptions {
                        ApplicationId = group.ApplicationId, ContentTypeId = ContentTypeId, PageIndex = options.PageIndex, PageSize = options.PageSize, SortOrder = "Descending"
                    });

                    var polls = new List <Poll>();
                    foreach (var score in scores)
                    {
                        if (score.Content != null)
                        {
                            var poll = Get(score.Content.ContentId);
                            if (poll != null)
                            {
                                polls.Add(poll);
                            }
                        }
                    }

                    return(new PagedList <Poll>(polls, scores.PageSize, scores.PageIndex, scores.TotalCount));
                }
                else
                {
                    var polls = InternalApi.PollingService.ListPolls(groupId, options);
                    return(new PagedList <Poll>(polls.Select(x => new Poll(x)), polls.PageSize, polls.PageIndex, polls.TotalCount));
                }
            }
            catch (Exception ex)
            {
                return(new PagedList <Poll>(new AdditionalInfo(new Error(ex.GetType().FullName, ex.Message))));
            }
        }