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);
}
//Initialize SpannersDataDetailViewModel Properties
public void SetApprovalsDataDetailViewModelProperties(int approvalId)
{
var currentGroup = _httpContext.HttpContext.User.FindFirst(ClaimTypes.GroupSid).Value;
Approval approval = _flightSpannersData.GetApprovalByApprovalId(approvalId);
Spanner spanner = _flightSpannersData.GetSpannerByCode(approval.SpannerCode);
AircraftType aircraftType = _flightSpannersData.GetAircraftTypeByAircraftTypeId(approval.AircraftTypeId);;
ApprovalDetail approvalDetail = _flightSpannersData.GetApprovalDetailByApprovalDetailId(approval.ApprovalDetailId);
GroupName = currentGroup;
ApprovalId = approvalId;
SpannerCode = approval.SpannerCode;
SpannerLicenseNo = spanner.SpannerLicenseNo;
SpannerName = spanner.SpannerFName + " " + spanner.SpannerM1Name;
AircraftTypeId = aircraftType.AircraftTypeId;
AircraftModel = aircraftType.AircraftModel;
EngineModel = aircraftType.EngineModel;
AircraftTypeConstant = aircraftType.AircraftTypeConstant;
ApprovalDetailId = approvalDetail.ApprovalDetailId;
ApprovalRating = approvalDetail.ApprovalRating;
ApprovalCategory = approvalDetail.ApprovalCategory;
ApprovalConstant = approvalDetail.ApprovalConstant;
}
//Initialize FlightRecordViewModel Properties
public void SetFlightRecordDetailViewModelProperties(int flightRecordId)
{
//if (!flightRecordId.HasValue)
//return;
var currentGroup = _httpContext.HttpContext.User.FindFirst(ClaimTypes.GroupSid).Value;
FlightRecord flightRecord;
FlightData flightData;
AircraftType aircraftType;
Approval approval;
ApprovalDetail approvalDetail;
Spanner spanner;
flightRecord = _flightSpannersData.GetFlightRecordByFlightRecordId(flightRecordId);
flightData = _flightSpannersData.GetFlightDataByFlightDataId(flightRecord.FlightDataId);
aircraftType = _flightSpannersData.GetAircraftTypeByAircraftTypeId(flightRecord.AircraftTypeId);
if (flightRecord.ApprovalId.HasValue)
{
approval = _flightSpannersData.GetApprovalByApprovalId(flightRecord.ApprovalId);
approvalDetail = _flightSpannersData.GetApprovalDetailByApprovalDetailId(approval.ApprovalDetailId);
spanner = _flightSpannersData.GetSpannerByCode(approval.SpannerCode);
SpannerCode = spanner.SpannerCode;
SpannerName = spanner.SpannerFName + " " + spanner.SpannerM1Name;
ApprovalRating = approvalDetail.ApprovalRating;
ApprovalCategory = approvalDetail.ApprovalCategory;
ApprovalDetailSummary = SpannerName + " ," + SpannerCode + " ," + ApprovalRating + " ," + ApprovalCategory;
ApprovalConstant = approvalDetail.ApprovalConstant;
}
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;
FlightInfo = AirportOrigin + "/" + AirportDestination + " ," + DefaultSectorTime + "hrs" + " ," + FlightBonusCard + "Bonus";
AircraftModel = aircraftType.AircraftModel;
EngineModel = aircraftType.EngineModel;
AircraftTypeSummary = AircraftModel + " ," + EngineModel;
AircraftTypeConstant = aircraftType.AircraftTypeConstant;
GroupName = currentGroup;
FlightCompanyName = flightRecord.FlightCompanyName;
OriginTypeName = flightRecord.OriginTypeName;
EligibilityTypeName = flightRecord.EligibilityTypeName;
DestinationTypeName = flightRecord.DestinationTypeName;
}
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);
}