private List <DaysOfInActive> GetInActivePeriodList(string groupName)
        {
            InActivePeriodList = new List <DaysOfInActive>();
            var     inActiveDaysQuery = _flightSpannersData.GetInActivePeriodByGroupName(groupName);
            Spanner spanner;

            foreach (var inActiveDays in inActiveDaysQuery)
            {
                spanner = _flightSpannersData.GetSpannerByCode(inActiveDays.SpannerCode);

                InActivePeriodList.Add(new DaysOfInActive {
                    SpannerCode      = inActiveDays.SpannerCode,
                    SpannerName      = spanner.SpannerFName + " " + spanner.SpannerM1Name,
                    InActivePeriodId = inActiveDays.InActivePeriodId,
                    InActiveFromDate = inActiveDays.InActiveFromDate,
                    InActiveToDate   = inActiveDays.InActiveToDate
                });
            }
            return(InActivePeriodList);
        }