public void CalculateCalendarYearRangeAccountingForExistingYearsWithCeilingOfCurrentYearToUseTest()
        {
            // Test empty list: should return just current year
            var currentYearToUse = DateTime.Today.Year;
            var ceilingYear      = currentYearToUse;

            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), null, null, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear), Is.EquivalentTo(Enumerable.Range(currentYearToUse, 1)));

            // No existing budget records

            // Testing if only have a start year
            // -- Start Year in the past: should go from Start Year to Current Year
            var startYear = currentYearToUse - 2;

            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), startYear, null, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear), Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(startYear, currentYearToUse)));
            // -- Start Year same as current year: should just be Start Year
            startYear = currentYearToUse;
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), startYear, null, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear), Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(startYear, startYear)));
            // -- Start Year in the future: should just be the ceiling year
            startYear = currentYearToUse + 3;
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), startYear, null, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear), Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(ceilingYear, ceilingYear)));

            // Testing if only have a completion year
            var completionYear = currentYearToUse - 2;

            // -- Completion Year in the past or same as current year, should only show Completion Year
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), null, completionYear, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(completionYear, completionYear)));
            completionYear = currentYearToUse;
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), null, completionYear, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(completionYear, completionYear)));
            // -- Completion Year in the future: should be the ceiling year
            completionYear = currentYearToUse + 3;
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), null, completionYear, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(ceilingYear, ceilingYear)));

            // Testing if have both Start Year and Completion Year: should always be Start Year to Completion Year
            // -- Start Year in the past
            startYear = currentYearToUse - 2;
            // -- Completion year in the past
            completionYear = currentYearToUse - 1;
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), startYear, completionYear, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(startYear, completionYear)));
            // -- Completion year same as current year
            completionYear = currentYearToUse;
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), startYear, completionYear, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(startYear, completionYear)));
            // -- Completion year in future, should only go up to the ceiling year
            completionYear = startYear + 5;
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), startYear, completionYear, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(startYear, ceilingYear)));

            // -- Start Year same as current year
            startYear = currentYearToUse;
            // -- Completion year in the past; should throw since that cannot happen!
            completionYear = currentYearToUse - 1;
            Assert.Throws <PreconditionException>(() => NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), startYear, completionYear, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear), "Cannot have a start year > end year!");
            // -- Completion year same as current year
            completionYear = currentYearToUse;
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), startYear, completionYear, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(startYear, completionYear)));
            // -- Completion year in future
            completionYear = startYear + 5;
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), startYear, completionYear, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(startYear, ceilingYear)));

            // -- Start Year in the future
            startYear = currentYearToUse + 2;
            // -- Completion year in the past; should throw since that cannot happen!
            completionYear = currentYearToUse - 1;
            Assert.Throws <PreconditionException>(() => NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), startYear, completionYear, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear), "Cannot have a start year > end year!");
            // -- Completion year same as current year
            completionYear = currentYearToUse;
            Assert.Throws <PreconditionException>(() => NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), startYear, completionYear, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear), "Cannot have a start year > end year!");
            // -- Completion year in future
            completionYear = startYear + 5;
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int>(), startYear, completionYear, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(ceilingYear, ceilingYear)));

            // If we have existing budget records, we need to factor those in
            var yearBeforeCurrentYear = currentYearToUse - 2;
            var yearAfterCurrentYear  = currentYearToUse + 4;

            // no start year and no end year provided
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int> {
                yearBeforeCurrentYear
            }, null, null, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(yearBeforeCurrentYear, currentYearToUse)));
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int> {
                yearBeforeCurrentYear, yearAfterCurrentYear
            }, null, null, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(yearBeforeCurrentYear, yearAfterCurrentYear)));
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int> {
                yearAfterCurrentYear
            }, null, null, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(currentYearToUse, yearAfterCurrentYear)));
            // start year provided
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int> {
                yearBeforeCurrentYear
            }, currentYearToUse, null, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(yearBeforeCurrentYear, currentYearToUse)));
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int> {
                yearBeforeCurrentYear, yearAfterCurrentYear
            }, currentYearToUse, null, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(yearBeforeCurrentYear, yearAfterCurrentYear)));
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int> {
                yearAfterCurrentYear
            }, currentYearToUse, null, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(currentYearToUse, yearAfterCurrentYear)));
            // end year provided
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int> {
                yearBeforeCurrentYear
            }, null, currentYearToUse, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(yearBeforeCurrentYear, currentYearToUse)));
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int> {
                yearBeforeCurrentYear, yearAfterCurrentYear
            }, null, currentYearToUse, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(yearBeforeCurrentYear, yearAfterCurrentYear)));
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int> {
                yearAfterCurrentYear
            }, null, currentYearToUse, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(currentYearToUse, yearAfterCurrentYear)));
            // start year and end year provided
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int> {
                yearBeforeCurrentYear
            }, currentYearToUse - 1, currentYearToUse + 1, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(yearBeforeCurrentYear, ceilingYear)));
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int> {
                yearBeforeCurrentYear, yearAfterCurrentYear
            }, currentYearToUse - 1, currentYearToUse + 1, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(yearBeforeCurrentYear, yearAfterCurrentYear)));
            Assert.That(NeptuneDateUtilities.CalculateCalendarYearRangeAccountingForExistingYears(new List <int> {
                yearAfterCurrentYear
            }, currentYearToUse - 1, currentYearToUse + 1, currentYearToUse, NeptuneDateUtilities.MinimumYear, ceilingYear),
                        Is.EquivalentTo(NeptuneDateUtilities.GetRangeOfYears(currentYearToUse - 1, yearAfterCurrentYear)));
        }