private List <ApprovalsData> GetApprovalsDataList(string groupName) { ApprovalsDataList = new List <ApprovalsData>(); var spannerQuery = _flightSpannersData.GetSpannersByGroupName(groupName); //Approval approval; AircraftType aircraftType; ApprovalDetail approvalDetail; foreach (var spanner in spannerQuery) { var approvalsDataQuery = _flightSpannersData.GetApprovalBySpannerCode(spanner.SpannerCode); foreach (var approval in approvalsDataQuery) { aircraftType = _flightSpannersData.GetAircraftTypeByAircraftTypeId(approval.AircraftTypeId); approvalDetail = _flightSpannersData.GetApprovalDetailByApprovalDetailId(approval.ApprovalDetailId); ApprovalsDataList.Add(new ApprovalsData { ApprovalId = approval.ApprovalId, SpannerCode = spanner.SpannerCode, SpannerName = spanner.SpannerFName + " " + spanner.SpannerM1Name, SpannerLicenseNo = spanner.SpannerLicenseNo, AircraftModel = aircraftType.AircraftModel, EngineModel = aircraftType.EngineModel, ApprovalRating = approvalDetail.ApprovalRating, ApprovalCategory = approvalDetail.ApprovalCategory }); } } return(ApprovalsDataList); }