예제 #1
0
        protected override async Task OnGetInternalAsync(SqlConnection connection)
        {
            MyActivitySubscriptions = await new MyHandOffActivities()
            {
                OrgId = OrgId, UserId = UserId
            }.ExecuteAsync(connection);
            MyHandOffItems = await new OpenWorkItems(QueryTraces)
            {
                OrgId = OrgId, InMyActivities = true, ActivityUserId = UserId, IsPaused = true, AppId = CurrentOrgUser.CurrentAppId
            }.ExecuteAsync(connection);

            var itemIds     = MyHandOffItems.Select(wi => wi.Id).ToArray();
            var labelsInUse = await new LabelsInUse()
            {
                WorkItemIds = itemIds, OrgId = OrgId
            }.ExecuteAsync(connection);

            HandOffLabels = labelsInUse.ToLookup(row => row.WorkItemId);

            var comments = await new Comments()
            {
                OrgId = OrgId, ObjectIds = itemIds, ObjectType = ObjectType.WorkItem
            }.ExecuteAsync(connection);

            HandOffComments = comments.ToLookup(row => row.ObjectId);
        }
예제 #2
0
        protected override async Task OnGetInternalAsync(SqlConnection connection)
        {
            UnestimatedItemCount = WorkItems.Where(wi => wi.EstimateHours == 0).Count();

            MyActivitySubscriptions = await new MyHandOffActivities()
            {
                OrgId = OrgId, UserId = UserId
            }.ExecuteAsync(connection);
            MyHandOffItems = await new OpenWorkItems(QueryTraces)
            {
                OrgId = OrgId, InMyActivities = true, ActivityUserId = UserId, IsPaused = true, AppId = CurrentOrgUser.CurrentAppId
            }.ExecuteAsync(connection);

            var itemIds     = MyHandOffItems.Select(wi => wi.Id).ToArray();
            var labelsInUse = await new LabelsInUse()
            {
                WorkItemIds = itemIds, OrgId = OrgId
            }.ExecuteAsync(connection);

            HandOffLabels = labelsInUse.ToLookup(row => row.WorkItemId);

            var comments = await new Comments()
            {
                OrgId = OrgId, ObjectIds = itemIds, ObjectType = ObjectType.WorkItem
            }.ExecuteAsync(connection);

            HandOffComments = comments.ToLookup(row => row.ObjectId);

            MySchedule = await new MyWorkSchedule()
            {
                OrgId = OrgId, UserId = UserId
            }.ExecuteAsync(connection);
            HiddenMilestones = await new HiddenMilestones()
            {
                OrgId = OrgId, UserId = UserId
            }.ExecuteAsync(connection);

            var pinnedItemQry = new OpenWorkItems()
            {
                OrgId = OrgId, MyPinnedItems = true, MyUserId = UserId
            };

            if (Options[Option.MyItemsFilterCurrentApp]?.BoolValue ?? true)
            {
                pinnedItemQry.AppId = CurrentOrgUser.EffectiveAppId;
            }
            UserIdFieldOption.Criteria.Invoke(pinnedItemQry, UserId);
            PinnedItems = await pinnedItemQry.ExecuteAsync(connection);

            var pinnedItemIds = PinnedItems.Select(wi => wi.Id).ToArray();
            var pinnedLabels  = await new LabelsInUse()
            {
                WorkItemIds = pinnedItemIds, OrgId = OrgId
            }.ExecuteAsync(connection);

            PinnedItemLabels = pinnedLabels.ToLookup(row => row.WorkItemId);

            var pinnedComments = await new Comments()
            {
                OrgId = OrgId, ObjectIds = pinnedItemIds, ObjectType = ObjectType.WorkItem
            }.ExecuteAsync(connection);

            PinnedComments = pinnedComments.ToLookup(row => row.ObjectId);
        }