List <PendingChange> IPendingChangesService.GetPendingChanges()
{
using (var context = new BluecowEntities())
{
var changes = context.CTApplications_PendingChanges.ToList();
return(Mapper.Map <List <CTApplications_PendingChanges>, List <PendingChange> >(changes));
}
}
PaxPendingChange IPendingChangesService.GetPaxPendingChanges(int paxId)
{
using (var context = new BluecowEntities())
{
var paxChanges = (
from BP in context.CTBookings_Passenger
join PP in context.CTPassengers_Passenger
on BP.PAX_ID equals PP.PAX_ID
where BP.PAX_ID == paxId
select new PaxPendingChange
{
MasterData = new BookingPassenger()
{
PaxId = BP.PAX_ID,
FirstName = BP.FIRST_NAME,
FamilyName = BP.FAMILY_NAME,
MiddleName = BP.MIDDLE_NAME,
DateOfBirth = BP.DOB,
Gender = BP.GENDER,
PassportNationality = BP.PSPT_NATIONALITY,
PassportBirthPlace = BP.PSPT_BIRTH_PLACE,
PassportNumber = BP.PSPT_NO,
PassportIssueDate = BP.PSPT_ISS_DATE,
PassportExpiryDate = BP.PSPT_EXP_DATE
},
StagedData = new ModifiedPassenger()
{
PaxId = BP.PAX_ID,
MiddleName = PP.MIDDLE_NAME,
Gender = PP.GENDER,
PassportNationality = PP.PSPT_NATIONALITY,
PassportBirthPlace = PP.PSPT_BIRTH_PLACE,
PassportNumber = PP.PSPT_NO,
PassportIssueDate = PP.PSPT_ISS_DATE,
PassportExpiryDate = PP.PSPT_EXP_DATE
}
}).FirstOrDefault();
return(paxChanges);
}
}
