private List <DaysOfInActive> GetInActivePeriodListBySpannerCode(string spannerCode)
        {
            InActivePeriodList = new List <DaysOfInActive>();
            var     inActiveDaysQuery = _flightSpannersData.GetInActivePeriodBySpannerCode(spannerCode);
            Spanner spanner           = _flightSpannersData.GetSpannerByCode(spannerCode);

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