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