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