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