Social_GetNotificationCounts

gistfile1.cs

using System;
using System.Linq;
using System.Collections.Generic;
using Fishidy.Domain.SqlServerStructures.Models.Persistence;
using Fishidy.Domain.SqlServerStructures.Models.Processing;

namespace Fishidy.Domain.SqlServerStructures.StoredProcedures
{
    public class Social_GetNotificationCounts
    {
        public static List<Social_GetNotificationCountsResult> Execute(Guid? sourceNodeID)
        {
            var results = new List<Social_GetNotificationCountsResult>();
            var notifications = FishidySqlMongo<NotificationTable>.AsQueryable.Where(n => n.TargetNodeID == sourceNodeID).ToList();

            notifications
                .GroupBy(n => n.RelationshipType, n => 1)
                .ToList()
                .ForEach(n => results.Add(new Social_GetNotificationCountsResult
                                          {
                                              RelationshipType = n.Key,
                                              count = n.Sum()
                                          }));

            return results;
        }  
    }
}