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

​

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

var exampleClasses = JsonConvert.DeserializeObject<List<ExampleClass>>(inputJSON);

//New list of orgs with calendar/fiscal years

var orgCalendarYearsList = new List<exampleYears>();

​

//Calculate calendar years

foreach(var exampleClass in exampleClasses)

{

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

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

var sampleYears = new exampleYears()

{

orgId = exampleClass.orgId,

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

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

};

​

orgCalendarYearsList.Add(sampleYears);

}

​

var outputJSON = JsonConvert.SerializeObject(orgCalendarYearsList);

Console.WriteLine(outputJSON);

}

}

​

// Additional classes can go here

public class ExampleClass

{

public int orgId {get;set;}

public string sampleString {get;set;}

public DateTime startDate {get;set;}

public DateTime endDate {get;set;}

public int fiscalYearEnd {get;set;}

}

​

public class exampleYears

{

public int orgId {get;set;}

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

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

}

​