private List <Record> GetRecordList(string groupName) { RecordList = new List <Record>(); var flightRecordQuery = _flightSpannersData.GetFlightRecordByGroupName(groupName); Approval approval; FlightData flightData; AircraftType aircraftType; ApprovalDetail approvalDetail; Spanner spanner; bool ApprovalNotNull = false; foreach (var flightRecord in flightRecordQuery) { flightData = _flightSpannersData.GetFlightDataByFlightDataId(flightRecord.FlightDataId); aircraftType = _flightSpannersData.GetAircraftTypeByAircraftTypeId(flightRecord.AircraftTypeId); ApprovalNotNull = flightRecord.ApprovalId.HasValue; if (ApprovalNotNull) { approval = _flightSpannersData.GetApprovalByApprovalId(flightRecord.ApprovalId.Value); approvalDetail = _flightSpannersData.GetApprovalDetailByApprovalDetailId(approval.ApprovalDetailId); spanner = _flightSpannersData.GetSpannerByCode(approval.SpannerCode); RecordList.Add(new Record { RecordId = flightRecord.FlightRecordId, RecordDate = flightRecord.RecordDate, RecordTime = flightRecord.RecordTime, FlightDate = flightRecord.FlightDate, FlightTime = flightRecord.FlightTime, IsRecordSetteled = flightRecord.IsRecordSettled, IsRecordAutoSelected = flightRecord.IsRecordAutoSelected, AirportOrigin = flightData.AirportOrigin, AirportDestination = flightData.AirportDestination, DefaultSectorTime = flightData.DefaultSectorTime, FlightDataConstant = flightData.FlightDataConstant, IsFlightLocal = flightData.IsFlightLocal, IsFlightCargo = flightData.IsFlightCargo, FlightBonusCard = flightData.FlightBonusCard, AircraftModel = aircraftType.AircraftModel, EngineModel = aircraftType.EngineModel, AircraftTypeConstant = aircraftType.AircraftTypeConstant, //SpannerCode = ApprovalNotNull ? spanner.SpannerCode : null, SpannerCode = spanner.SpannerCode, SpannerName = spanner.SpannerFName + " " + spanner.SpannerM1Name, ApprovalRating = approvalDetail.ApprovalRating, ApprovalCategory = approvalDetail.ApprovalCategory, ApprovalConstant = approvalDetail.ApprovalConstant, GroupName = groupName, FlightCompanyName = flightRecord.FlightCompanyName, OriginTypeName = flightRecord.OriginTypeName, EligibilityTypeName = flightRecord.EligibilityTypeName, DestinationTypeName = flightRecord.DestinationTypeName }); } else { RecordList.Add(new Record { RecordId = flightRecord.FlightRecordId, RecordDate = flightRecord.RecordDate, RecordTime = flightRecord.RecordTime, FlightDate = flightRecord.FlightDate, FlightTime = flightRecord.FlightTime, IsRecordSetteled = flightRecord.IsRecordSettled, IsRecordAutoSelected = flightRecord.IsRecordAutoSelected, AirportOrigin = flightData.AirportOrigin, AirportDestination = flightData.AirportDestination, DefaultSectorTime = flightData.DefaultSectorTime, FlightDataConstant = flightData.FlightDataConstant, IsFlightLocal = flightData.IsFlightLocal, IsFlightCargo = flightData.IsFlightCargo, FlightBonusCard = flightData.FlightBonusCard, AircraftModel = aircraftType.AircraftModel, EngineModel = aircraftType.EngineModel, AircraftTypeConstant = aircraftType.AircraftTypeConstant, GroupName = groupName, FlightCompanyName = flightRecord.FlightCompanyName, OriginTypeName = flightRecord.OriginTypeName, EligibilityTypeName = flightRecord.EligibilityTypeName, DestinationTypeName = flightRecord.DestinationTypeName }); } } return(RecordList); }