index.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.Text.RegularExpressions;
using System.Globalization;
using System.Linq;
using Raven.Client.Documents.Indexes;

public class Index_MyIndex : AbstractIndexCreationTask
{
    public override string IndexName => "MyIndex";

    public override IndexDefinition CreateIndexDefinition()
    {
        return new IndexDefinition
        {
            Maps =
            {
            @"map(""WorkPackages"",processWorkBreakdownHours);",
            @"map(""Subs"",processWorkBreakdownHours);",
            @"map(""Majors"",processWorkBreakdownHours);",
            @"map(""Projects"",processWorkBreakdownHours);"
            },
            Reduce = @"groupBy(x => x.Scope).aggregate(g => {
    return {
        Scope: g.key,
        EsimatedHours: g.values.reduce((count, val) => val.EsimatedHours + count, 0),
        CompletedHours: g.values.reduce((amount, val) => val.CompletedHours + amount, 0)
    };
})",
            AdditionalSources = new Dictionary<string, string>
            {
                ["map.js"] = @"function processWorkBreakdownHours(doc) {
    let hours = {
        EsimatedHours: doc.EsimatedHours,
        CompletedHours: doc.CompletedHours
    };
    let results = [Object.assign({
        Scope: id(doc)
    }, hours)];

    let current = doc;
    while (current.Parent) {
        current = load(current.Parent.Id, current.Parent.Type);
        results.push(Object.assign({
            Scope: id(current)
        }, hours));
    }
    return results;
}"
            }
        };
    }
}