//Code Exercise: https://dotnetfiddle.net/loo4FS

​

using System;

using System.Collections.Generic;

using Newtonsoft.Json;

using System.Linq;

public class Program

{

    public static void Main()

    {

​

        // Please email conductiv-eng@outlook.com if you have any questions.

        // When complete, please send your name and the URL of your "Share Link" (.NET Fiddle menu item Share > Share Link) to conductiv-eng@outlook.com. Thank you!

        // Note: usings directives include typical libraries needed (feel free to add more if needed), also NuGet Package Newtonsoft.Json is included

        // Given input json for three organizations

        // Return list of all years in date range:

        // 1) Calendar years

        // 2) Fiscal years

        var inputJSON = @"

        [

            {

                orgId: 1,

                startDate: '2018-1-01T00:00:00',

                endDate: '2020-8-29T00:00:00',

                fiscalYearEnd: 12

            },

            {

                orgId: 2,

                startDate: '2018-1-01T00:00:00',

                endDate: '2020-8-29T00:00:00',

                fiscalYearEnd: 6

            },

            {

                orgId: 3,

                startDate: '2018-9-01T00:00:00',

                endDate: '2020-8-29T00:00:00',

                fiscalYearEnd: 8

            }

        ]";

        //Correct Output

        /*

        [

            {

                "orgId": 1,

                "calendarYears": [2018,2019,2020],

                "fiscalYears": [2018,2019,2020]

            },

            {

                "orgId": 2,

                "calendarYears": [2018,2019,2020],

                "fiscalYears": [2018,2019,2020,2021]

            },

            {

                "orgId": 3,

                "calendarYears": [2018,2019,2020],

                "fiscalYears": [2019,2020]

            }

        ]

        */

​

        //TODO Tasks

        // 1) Create classes to deserialize JSON (use JSON.NET)

        // 2) Perform calculation from start/end dates to get range of calendar and fiscal years

        // 3) Output JSON to match correct output above

        //JSON deserialize

        var orgDatesList = JsonConvert.DeserializeObject<List<OrgDates>>(inputJSON);

        //New list of orgs with calendar/fiscal years

        var orgCalendarYearsList = new List<OrgCalendarYears>();

        //Calculate calendar years

        foreach(var orgDates in orgDatesList)

        {

            // Getting fiscal year for start and end

            var fyStart = (orgDates.startDate.Month > orgDates.fiscalYearEnd ? orgDates.startDate.Year+1:orgDates.startDate.Year);

            var fyEnd = (orgDates.endDate.Month > orgDates.fiscalYearEnd ? orgDates.endDate.Year+1:orgDates.endDate.Year);

            //Adding ranges of years to new object

            var orgCalYears = new OrgCalendarYears()

            {

                orgId = orgDates.orgId,

                calendarYears = Enumerable.Range(orgDates.startDate.Year, (orgDates.endDate.Year+1)-orgDates.startDate.Year).ToList(),

                fiscalYears = Enumerable.Range(fyStart, (fyEnd+1)-fyStart).ToList()

            };

            orgCalendarYearsList.Add(orgCalYears);

        }

        var outputJSON = JsonConvert.SerializeObject(orgCalendarYearsList);

        Console.WriteLine(outputJSON);

    }

}

​

// Additional classes can go here

public class ExampleClass

{

    public int sampleId {get;set;}

    public string sampleString {get;set;}

}

​

public class OrgDates

{

    public int orgId {get;set;}

    public DateTime startDate {get;set;}

    public DateTime endDate {get;set;}

    public int fiscalYearEnd {get;set;}

}

​

public class OrgCalendarYears

{

    public int orgId {get;set;}

    public List<int> calendarYears {get;set;}

    public List<int> fiscalYears {get;set;}

}