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); }