/// <summary>
/// Maps the alerts.
/// </summary>
/// <param name="dataReader">The data reader.</param>
/// <returns>Alert object.</returns>
private static Alert MapAlert(SqlDataReader dataReader)
{
return new Alert
{
AlertId = dataReader.Int32Field(AlertId).ToString(CultureInfo.CurrentCulture),
AlertType = dataReader.StringField(AlertType),
IsDenyAshore = dataReader.BooleanField(IsDenyAshore),
IsDenyOnboard = dataReader.BooleanField(IsDenyOnboard),
IsOverride = dataReader.BooleanField(IsOverride),
IsSoundEnable = dataReader.BooleanField(IsSoundEnable),
AddedDateTime = dataReader.DateTimeField(AddedDate)
};
}
/// <summary>
/// Maps the guest reservation detail.
/// </summary>
/// <param name="dataReader">The data reader.</param>
/// <returns>Guest collection</returns>
private static async Task<GuestCollection> RetrieveGuestReservationDetail(SqlDataReader dataReader)
{
var guestCollection = new GuestCollection();
if (dataReader != null)
{
while (await dataReader.ReadAsync())
{
var guest = new Guest();
guest.GuestId = dataReader.Int32Field(GuestId).ToString();
guest.CruiseDetail = new GuestCruiseDetail();
guest.CruiseDetail.ReservationId = dataReader.Int32Field(ReservationId).ToString();
guest.CruiseDetail.ReservationNumber = dataReader.StringField(ReservationNumber);
guest.CruiseDetail.IsVip = dataReader.BooleanField(VIPFlag);
guest.CruiseDetail.IsPrimary = dataReader.BooleanField(IsPrimary);
guest.CruiseDetail.Stateroom = dataReader.StringField(Stateroom);
guest.CruiseDetail.EmbarkDate = dataReader.DateTimeField(EmbarkDate);
guest.CruiseDetail.DebarkDate = dataReader.DateTimeField(DebarkDate);
guest.CruiseDetail.ReservationStatusId = dataReader.ByteField(ReservationStatusId).ToString();
guest.CruiseDetail.VoyageId = dataReader.Int32Field(VoyageId).ToString();
var loyaltyLevelTypeId = dataReader.Int32NullableField(LoyaltyLevelTypeId);
guest.CruiseDetail.LoyaltyLevelTypeId = loyaltyLevelTypeId.HasValue ? loyaltyLevelTypeId.Value.ToString() : null;
var beaconId = dataReader.Int32NullableField(BeaconId);
guest.CruiseDetail.BeaconId = beaconId.HasValue ? beaconId.Value.ToString() : null;
////guest.CruiseDetail.HasRecovery = dataReader.BooleanField(HasRecovery);
guest.CruiseDetail.HasTravelWith = dataReader.BooleanField(HasTravelWith);
guest.CruiseDetail.IsFolioAtRisk = dataReader.BooleanField(IsFolioAtRisk);
guest.CruiseDetail.CanDebarkAlone = dataReader.BooleanField(CanDebarkAlone);
guest.CruiseDetail.StateroomOccupancy = dataReader.ByteField(StateroomOccupancy).ToString();
guest.CruiseDetail.DiningDetail = dataReader.StringField(DiningDetail);
guest.CruiseDetail.IsCheckedIn = dataReader.BooleanField(IsCheckedIn);
guest.CruiseDetail.IsConciergeStatus = dataReader.BooleanField(IsConciergeStatus);
guest.CruiseDetail.IsBackToBack = dataReader.BooleanField(IsBackToBack);
var stateroomCategoryTypeId = dataReader.Int16NullableField(StateroomCategoryTypeID);
guest.CruiseDetail.StateroomCategoryTypeId = stateroomCategoryTypeId.HasValue ? stateroomCategoryTypeId.Value.ToString() : null;
guest.CruiseDetail.StateroomCategoryType = dataReader.StringField(Category);
guestCollection.Add(guest);
}
}
return guestCollection;
}
/// <summary>
/// Maps the alerts.
/// </summary>
/// <param name="dataReader">The data reader.</param>
/// <returns>Alert object.</returns>
private static AccessCard MapAccessCard(SqlDataReader dataReader)
{
return new AccessCard
{
AccessCardId = dataReader.Int32Field(AccessCardId).ToString(CultureInfo.CurrentCulture),
AccessCardNumber = dataReader.StringField(AccessCardNumber),
ExpiryDate = dataReader.DateTimeNullableField(ExpiryDate),
AddedDate = dataReader.DateTimeField(AddedDate)
};
}
/// <summary>
/// Maps the voyages.
/// </summary>
/// <param name="dataReader">The data reader.</param>
/// <returns>The Collection of voyages</returns>
private static async Task<ICollection<Voyage>> MapVoyages(SqlDataReader dataReader)
{
var voyages = new Collection<Voyage>();
IDictionary<string, ICollection<Itinerary>> itineraries = new Dictionary<string, ICollection<Itinerary>>();
if (dataReader != null)
{
while (await dataReader.ReadAsync())
{
var voyage = new Voyage
{
VoyageId = dataReader.Int32Field(VoyageId).ToString(),
ShipId = dataReader.ByteField(ShipId).ToString(),
Number = dataReader.StringField(Number),
Name = dataReader.StringField(Name),
EmbarkDate = dataReader.DateTimeField(EmbarkDate),
DebarkDate = dataReader.DateTimeField(DebarkDate),
EmbarkPortId = dataReader.Int32Field(EmbarkPortId).ToString(),
DebarkPortId = dataReader.Int32Field(DebarkPortId).ToString(),
Nights = dataReader.ByteField(Nights),
DestinationId = dataReader.StringField(DestinationName),
IsActive = dataReader.BooleanField(IsActive),
MediaItemAddress = dataReader.StringField(MediaItemAddress)
};
byte[] bytes = await voyage.MediaItemAddress.ImageAddressToByteArray();
voyage.ItineraryGraphImage = bytes.ToBitmapSource();
voyages.Add(voyage);
}
}
return voyages;
}
