Flattening and Grouping Disclosures with Linq | C# Online Compiler

Flattening and Grouping Disclosures with Linq by Anonymous

using System;
using System.Collections.Generic;
using System.Linq;

public class DigDisclosuresData
{
	public DigDisclosures data { get; set; }
}
public class DigDisclosures
{
	public List<Disclosures> disclosures { get; set; }
}
public class Disclosures
{
	public List<GroupedDisclosures> slides { get; set; }
}
public class GroupedDisclosures
{
	public string slideId { get; set; }
	public List<Disclosure> disclosures { get; set; }
}
public class Disclosure
{
	public string language { get; set; }
	public string groupName { get; set; }
}
					
public class Program
{
	public static void Main()
	{
		// Load disclosures object with mock data
		var disclosures = MockData();
		
		var disclosureLanguagesBySlideID = disclosures.data.disclosures
			.SelectMany(disclosure => disclosure.slides)				// flattened list of all slides for all disclosures
			.SelectMany(slide => slide.disclosures, 					// flattened list of all disclosures for all slides within disclosures object
				(slide, slideDisclosure) => new 						// take the parent slide and the child disclosure
					{ slide.slideId, slideDisclosure.groupName, slideDisclosure.language } 		// pair an object with parent slide ID to child disclosure language
			);
		
		var groupedDisclosuresBySiteId = disclosures.data.disclosures
			.SelectMany(disclosure => disclosure.slides)
			.SelectMany(slide => slide.disclosures, (slide, slideDisclosure) => new 						
				{
					slide.slideId,
					slideDisclosure.groupName,
					slideDisclosure.language
				})
			.GroupBy(disclosure => disclosure.groupName)
			.ToDictionary(
				groupedDisclosures => groupedDisclosures.First().slideId,
				groupedDisclosures => groupedDisclosures.Select(gd => gd.language)
			);
		
		disclosureLanguagesBySlideID
			.ToList()
			.ForEach(d => Console.WriteLine(d));
		
		groupedDisclosuresBySiteId
			.ToList()
			.ForEach(kvp => {
				Console.WriteLine(String.Format("[{0}]: ", kvp.Key));
				kvp.Value
					.ToList()
					.ForEach(disclosure => Console.WriteLine(disclosure));
			});
	}
	
	
	public static Dictionary<string, List<Disclosure>> _SlideDisclosures { get; set; }
	public static Dictionary<string, List<Disclosure>> SlideDisclosures
        {
            get
            {
                if (_SlideDisclosures == null)
                {
                    _SlideDisclosures = new Dictionary<string, List<Disclosure>>();
                    
                    disclosures.disclosures.ForEach(disclosure =>
                    {
                        disclosure.slides.ForEach(slide =>
                        {
                            if (!_SlideDisclosures.ContainsKey(slide.slideId))
                            {
                                /*
                                    disclosures for each slide are grouped by the groupName.
                                    The properties of the first disclosure are used white the text of preceeding objects are appended to the first.
                                    If individual parts of a group disclosure need to be bolded/prominant this can be managed here (possibly by adding <strong>)
                                    or some alteration to the function for rendering slide disclosures.
                                */
                                List<Disclosure> groupedDisclosures = slide.disclosures.GroupBy(u => u.groupName)
                                    .Select(grp => grp.ToList().Aggregate((Disclosure)null, (acc, cur) =>
                                        {
                                            if (acc == null)
                                            {
                                                return cur ?? new Disclosure();
                                            }
                                            else
                                            {
                                                acc.language = acc.language + " " + cur.language;
                                            }
                                            return acc;
                                        }, disc => disc))
                                    .ToList();
                                    
                                _SlideDisclosures.Add(slide.slideId, groupedDisclosures ?? new List<Disclosure>());
                            }
                        });
                    });
                }
                return _SlideDisclosures;
            }
        }
	
	public static DigDisclosuresData MockData()
	{
		return new DigDisclosuresData()
		{
			data = new DigDisclosures()
			{
				disclosures = new List<Disclosures>
				{
					new Disclosures()
					{
						slides = new List<GroupedDisclosures>
						{
							new GroupedDisclosures()
							{
								slideId = "Slide 1",
								disclosures = new List<Disclosure>
								{
									new Disclosure()
									{
										language = "I'm the first disclosure",
										groupName = "Group A"
									},
									new Disclosure()
									{
										language = "I'm the second disclosure",
										groupName = "Group A"
									},
									new Disclosure()
									{
										language = "I'm the third disclosure",
										groupName = "Group B"
									}
								}
							},
							new GroupedDisclosures()
							{
								slideId = "Slide 2",
								disclosures = new List<Disclosure>
								{
									new Disclosure()
									{
										language = "I'm the fourth disclosure",
										groupName = "Group B"
									},
									new Disclosure()
									{
										language = "I'm the fifth disclosure",
										groupName = "Group C"
									},
									new Disclosure()
									{
										language = "I'm the sixth disclosure",
										groupName = "Group C"
									}
								}
							}
						}
					}
				}	
			}
		};
	}
}

​x
 
using System;
using System.Collections.Generic;
using System.Linq;
​
public class DigDisclosuresData
{
    public DigDisclosures data { get; set; }
}
public class DigDisclosures
{
    public List<Disclosures> disclosures { get; set; }
}
public class Disclosures
{
    public List<GroupedDisclosures> slides { get; set; }
}
public class GroupedDisclosures
{
    public string slideId { get; set; }
    public List<Disclosure> disclosures { get; set; }
}
public class Disclosure
{
    public string language { get; set; }
    public string groupName { get; set; }
}
                    
public class Program
{
    public static void Main()
    {
        // Load disclosures object with mock data
        var disclosures = MockData();
        
        var disclosureLanguagesBySlideID = disclosures.data.disclosures
            .SelectMany(disclosure => disclosure.slides)                // flattened list of all slides for all disclosures
            .SelectMany(slide => slide.disclosures,                     // flattened list of all disclosures for all slides within disclosures object
                (slide, slideDisclosure) => new                         // take the parent slide and the child disclosure
                    { slide.slideId, slideDisclosure.groupName, slideDisclosure.language }      // pair an object with parent slide ID to child disclosure language
            );
        
        var groupedDisclosuresBySiteId = disclosures.data.disclosures
            .SelectMany(disclosure => disclosure.slides)
            .SelectMany(slide => slide.disclosures, (slide, slideDisclosure) => new                         
                {
                    slide.slideId,
                    slideDisclosure.groupName,
                    slideDisclosure.language
                })
            .GroupBy(disclosure => disclosure.groupName)
            .ToDictionary(
                groupedDisclosures => groupedDisclosures.First().slideId,
                groupedDisclosures => groupedDisclosures.Select(gd => gd.language)
            );
        
        disclosureLanguagesBySlideID
            .ToList()
            .ForEach(d => Console.WriteLine(d));
        
        groupedDisclosuresBySiteId
            .ToList()
            .ForEach(kvp => {
                Console.WriteLine(String.Format("[{0}]: ", kvp.Key));
                kvp.Value
                    .ToList()
                    .ForEach(disclosure => Console.WriteLine(disclosure));
            });
    }
    
    
    public static Dictionary<string, List<Disclosure>> _SlideDisclosures { get; set; }
    public static Dictionary<string, List<Disclosure>> SlideDisclosures
        {
            get
            {
                if (_SlideDisclosures == null)
                {
                    _SlideDisclosures = new Dictionary<string, List<Disclosure>>();
                    
                    disclosures.disclosures.ForEach(disclosure =>
                    {
                        disclosure.slides.ForEach(slide =>
                        {
                            if (!_SlideDisclosures.ContainsKey(slide.slideId))
                            {
                                /*
                                    disclosures for each slide are grouped by the groupName.
                                    The properties of the first disclosure are used white the text of preceeding objects are appended to the first.
                                    If individual parts of a group disclosure need to be bolded/prominant this can be managed here (possibly by adding <strong>)
                                    or some alteration to the function for rendering slide disclosures.
                                */
                                List<Disclosure> groupedDisclosures = slide.disclosures.GroupBy(u => u.groupName)
                                    .Select(grp => grp.ToList().Aggregate((Disclosure)null, (acc, cur) =>
                                        {
                                            if (acc == null)
                                            {
                                                return cur ?? new Disclosure();
                                            }
                                            else
                                            {
                                                acc.language = acc.language + " " + cur.language;
                                            }
                                            return acc;
                                        }, disc => disc))
                                    .ToList();
                                    
                                _SlideDisclosures.Add(slide.slideId, groupedDisclosures ?? new List<Disclosure>());
                            }
                        });
                    });
                }
                return _SlideDisclosures;
            }
        }
    
    public static DigDisclosuresData MockData()
    {
        return new DigDisclosuresData()
        {
            data = new DigDisclosures()
            {
                disclosures = new List<Disclosures>
                {
                    new Disclosures()
                    {
                        slides = new List<GroupedDisclosures>
                        {
                            new GroupedDisclosures()
                            {
                                slideId = "Slide 1",
                                disclosures = new List<Disclosure>
                                {
                                    new Disclosure()
                                    {
                                        language = "I'm the first disclosure",
                                        groupName = "Group A"
                                    },
                                    new Disclosure()
                                    {
                                        language = "I'm the second disclosure",
                                        groupName = "Group A"
                                    },
                                    new Disclosure()
                                    {
                                        language = "I'm the third disclosure",
                                        groupName = "Group B"
                                    }
                                }
                            },
                            new GroupedDisclosures()
                            {
                                slideId = "Slide 2",
                                disclosures = new List<Disclosure>
                                {
                                    new Disclosure()
                                    {
                                        language = "I'm the fourth disclosure",
                                        groupName = "Group B"
                                    },
                                    new Disclosure()
                                    {
                                        language = "I'm the fifth disclosure",
                                        groupName = "Group C"
                                    },
                                    new Disclosure()
                                    {
                                        language = "I'm the sixth disclosure",
                                        groupName = "Group C"
                                    }
                                }
                            }
                        }
                    }
                }   
            }
        };
    }
}

Cached Result
Last Run:	4:31:57 pm
Compile:	0.097s
Execute:	0.014s
Memory:	0b
CPU:	0.016s

View IL Code