/// <summary> /// Maps the gangway event status asynchronous. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Gangway Event Status</returns> internal static async Task<string> MapGangwayEventStatusAsync(SqlDataReader dataReader) { var value = default(string); if (dataReader != null && dataReader.HasRows) { await dataReader.ReadAsync(); value = dataReader.StringField(StatusField); } return value; }
/// <summary> /// Maps the configuration data. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>The component setting collection</returns> internal static async Task<ComponentSettingCollection> MapConfigurationData(SqlDataReader dataReader) { var componentSettingCollection = new ComponentSettingCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var ComponentSettings = new ComponentSetting { Id = dataReader.GuidField(Id).ToString(), Name = dataReader.StringField(Name), Value = dataReader.StringField(Value) }; componentSettingCollection.Add(ComponentSettings); } } return componentSettingCollection; }
/// <summary> /// Maps the specified data reader. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Media Item Address</returns> internal static async Task<string> MapMediaItemAddress(SqlDataReader dataReader) { var mediaItemAddress = string.Empty; if (dataReader != null) { while (await dataReader.ReadAsync()) { var mediaItemId = dataReader.Int32Field(MediaItemId).ToString(); var baseAddress = dataReader.StringField(Mediapath); mediaItemAddress = string.Concat(mediaItemId, CommonConstants.Comma, baseAddress); } if (!dataReader.IsClosed) { dataReader.Close(); } } return await Task.FromResult(mediaItemAddress); }
/// <summary> /// Retrieves the guest personal detail. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Guest Collection.</returns> private static async Task<GuestCollection> RetrieveGuestPersonalDetail(SqlDataReader dataReader) { var guestCollection = new GuestCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var guest = new Guest(); guest.GuestId = dataReader.Int32Field(GuestId).ToString(); guest.PersonalDetail = new PersonalDetail(); guest.PersonalDetail.Title = dataReader.StringField(Title); guest.PersonalDetail.FirstName = dataReader.StringField(FirstName); guest.PersonalDetail.MiddleName = dataReader.StringField(MiddleName); guest.PersonalDetail.LastName = dataReader.StringField(LastName); guest.PersonalDetail.Nickname = dataReader.StringField(NickName); guest.PersonalDetail.PreferredName = dataReader.StringField(PreferredName); guest.PersonalDetail.Suffix = dataReader.StringField(Suffix); guest.PersonalDetail.Birthdate = dataReader.DateTimeNullableField(BirthDate); guest.PersonalDetail.BirthCountryId = dataReader.Int32NullableField(BirthCountryId).HasValue ? dataReader.Int32NullableField("BirthCountryID").Value.ToString() : null; guest.PersonalDetail.CitizenshipCountryId = dataReader.Int32NullableField(CitizenshipCountryId).HasValue ? dataReader.Int32NullableField("BirthCountryID").Value.ToString() : null; guest.PersonalDetail.Gender = dataReader.StringField(Gender); guest.PersonalDetail.MaritalStatus = dataReader.StringField(MaritalStatus); guest.PersonalDetail.Occupation = dataReader.StringField(Occupation); guest.PersonalDetail.AnniversaryDate = dataReader.DateTimeNullableField(AnniversaryDate); guest.PersonalDetail.DocumentNumber = dataReader.StringField(DocumentNumber); guest.PersonalDetail.Age = dataReader.Int16Field(Age); guest.PersonalDetail.SourceId = dataReader.StringField(SourceId); guestCollection.Add(guest); } } return guestCollection; }
/// <summary> /// /// </summary> /// <param name="dataReader"></param> /// <returns></returns> public static async Task<Crewmember> MapUserDetails(SqlDataReader dataReader) { var crew = new Crewmember(); if (dataReader != null) { while (await dataReader.ReadAsync()) { crew.CrewmemberId = dataReader.Int32Field(CrewMemberId).ToString(); crew.PersonalDetail = new PersonalDetail(); crew.PersonalDetail.Title = dataReader.StringField(Title); crew.PersonalDetail.FirstName = dataReader.StringField(FirstName); crew.PersonalDetail.MiddleName = dataReader.StringField(MiddleName); crew.PersonalDetail.LastName = dataReader.StringField(LastName); crew.PersonalDetail.Nickname = dataReader.StringField(NickName); crew.PersonalDetail.PreferredName = dataReader.StringField(PreferredName); crew.PersonalDetail.Suffix = dataReader.StringField(Suffix); crew.PersonalDetail.Gender = dataReader.StringField(Gender); crew.PersonalDetail.Age = dataReader.Int32Field(Age); crew.SecurityPhotoAddress = dataReader.StringField(SecurityPhotoAddress); byte[] bytes = await crew.SecurityPhotoAddress.ImageAddressToByteArray(); crew.Photo = bytes.ToBitmapSource(); crew.AssignPhotoByteArray(new Collection<byte>(bytes)); } } return crew; }
/// <summary> /// Maps the loyalty level types. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Loyalty level types</returns> private static async Task<LoyaltyLevelTypeCollection> MapLoyaltyLevelTypes(SqlDataReader dataReader) { var loyaltyLevelTypeCollection = new LoyaltyLevelTypeCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var loyaltyLevelType = new LoyaltyLevelType { LoyaltyLevelTypeId = dataReader.Int32Field(LoyaltyLevelTypeId).ToString(), NoOfCruiseNights = dataReader.Int32Field(NoOfCruiseNights), Name = dataReader.StringField(Name), LogoImageAddress = dataReader.StringField(LogoImageAddress), BrandId = dataReader.Int16Field(BrandId).ToString() }; byte[] bytes = await loyaltyLevelType.LogoImageAddress.ImageAddressToByteArray(); loyaltyLevelType.LoyaltyIcon = bytes.ToBitmapSource(); loyaltyLevelTypeCollection.Add(loyaltyLevelType); } } return loyaltyLevelTypeCollection; }
/// <summary> /// Maps the person message. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>filled person message.</returns> private static PersonMessage MapPersonMessage(SqlDataReader dataReader) { return new PersonMessage { AlertId = dataReader.Int32Field(AlertId).ToString(CultureInfo.CurrentCulture), StatusId = dataReader.ByteField(StatusID).ToString(CultureInfo.CurrentCulture), AddedBy = dataReader.StringField(AddedBy), IsSoundEnable = dataReader.BooleanField(IsSoundEnable), AddedDateTime = dataReader.DateTimeNullableField(AddedDateTime) }; }
/// <summary> /// Maps the ports. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>port collection.</returns> private static async Task<PortCollection> MapPorts(SqlDataReader dataReader) { var portCollection = new PortCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var port = new Port { PortId = dataReader.Int32Field(PortId).ToString(), CountryId = dataReader.Int32Field(CountryId).ToString(), Code = dataReader.StringField(Code), City = dataReader.StringField(City), State = dataReader.StringField(State), StateId = dataReader.Int32NullableField(StateId).ToString(), Description = dataReader.StringField(Description), Name = dataReader.StringField(Name) }; portCollection.Add(port); } } return portCollection; }
/// <summary> /// Maps the visitor personal detail. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Visitor collection</returns> private static async Task<VisitorCollection> RetrieveVisitorPersonalDetail(SqlDataReader dataReader) { var visitors = new VisitorCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var visitor = new Visitor(); visitor.VisitorId = dataReader.Int32Field(VisitorId).ToString(); visitor.PersonalDetail = new PersonalDetail(); visitor.VisitorInfo = new VisitorInfo(); visitor.PersonalDetail.Age = dataReader.Int16NullableField(Age); visitor.PersonalDetail.AnniversaryDate = dataReader.DateTimeNullableField(AnniversaryDate); visitor.PersonalDetail.BirthCountryId = dataReader.Int32NullableField(BirthCountryId).ToString(); visitor.PersonalDetail.Birthdate = dataReader.DateTimeNullableField(BirthDate); visitor.PersonalDetail.CitizenshipCountryId = dataReader.Int32NullableField(CitizenshipCountryId).ToString(); visitor.PersonalDetail.FirstName = dataReader.StringField(FirstName); visitor.PersonalDetail.Gender = dataReader.StringField(Gender); visitor.PersonalDetail.LastName = dataReader.StringField(LastName); visitor.PersonalDetail.MaritalStatus = dataReader.StringField(MaritalStatus); visitor.PersonalDetail.MiddleName = dataReader.StringField(MiddleName); visitor.PersonalDetail.Nickname = dataReader.StringField(NickName); visitor.PersonalDetail.Occupation = dataReader.StringField(Occupation); visitor.PersonalDetail.DocumentNumber = dataReader.StringField(DocumentNumber); visitor.PersonalDetail.Suffix = dataReader.StringField(Suffix); visitor.PersonalDetail.Title = dataReader.StringField(Title); visitor.PersonalDetail.DepartmentName = dataReader.StringField(Department); visitor.PersonalDetail.DepartmentPOC = dataReader.StringField(Contact); visitor.VisitorInfo.CompanyName = dataReader.StringField(Company); visitor.PersonalDetail.DocumentNumber = dataReader.StringField(DocumentNumber); visitor.PersonalDetail.DocumentType = dataReader.StringField(DocumentType); ////visitor.VisitorInfo.ContactNumber = dataReader.StringField(ContactPhoneNumber); visitor.VisitorInfo.CompanyContactNumber = dataReader.StringField(ContactPhoneNumber); visitor.PersonalDetail.DocumentTypeId = dataReader.Int16Field(DocumentTypeId).ToString(); visitors.Add(visitor); } } return visitors; }
/// <summary> /// Maps the crew. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Crew member collection</returns> private static async Task<CrewmemberCollection> MapCrew(SqlDataReader dataReader) { var crewmemberCollection = new CrewmemberCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var crew = new Crewmember(); crew.CrewmemberId = dataReader.Int32Field(CrewMemberId).ToString(); crew.CrewmemberTypeId = dataReader.ByteField(CrewMemberTypeId).ToString(); crew.EmployeeNo = dataReader.StringField(EmployeeNo); var hasAlert = dataReader.BooleanNullableField(HasAlert); var hasMessage = dataReader.BooleanNullableField(HasMessage); crew.HasAlert = hasAlert.HasValue ? hasAlert.Value : false; crew.HasMessage = hasMessage.HasValue ? hasMessage.Value : false; crew.Position = dataReader.StringField(Position); crew.LastDateTime = dataReader.DateTimeNullableField(LastDateTime); crew.LastEvent = dataReader.StringField(LastEvent); crew.SafetyNumber = dataReader.StringField(SafetyNumber); crew.SecurityPhotoAddress = dataReader.StringField(SecurityPhotoAddress); crew.Stateroom = dataReader.StringField(Stateroom); crew.StateroomOccupancy = dataReader.ByteField(StateroomOccupancy).ToString(); crew.Department = dataReader.StringField(Department); crew.PortAssignedDate = dataReader.DateTimeNullableField(PortAssignedDate); byte[] bytes = await crew.SecurityPhotoAddress.ImageAddressToByteArray(); crew.Photo = bytes.ToBitmapSource(); crew.AssignPhotoByteArray(new Collection<byte>(bytes)); crewmemberCollection.Add(crew); } } return crewmemberCollection; }
/// <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; }
/// <summary> /// Maps the gangway locations. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>The collection of gangway location</returns> private static async Task<ICollection<GangwayLocation>> MapGangwayLocations(SqlDataReader dataReader) { var gangwayLocations = new Collection<GangwayLocation>(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var gangwayLocation = new GangwayLocation { LocationId = dataReader.Int32Field(LocationId).ToString(), LocationTypeId = dataReader.ByteField(LocationTypeId).ToString(), Name = dataReader.StringField(Name) }; gangwayLocations.Add(gangwayLocation); } } return gangwayLocations.OrderBy(a => a.Name).ToList(); }
/// <summary> /// Maps the stateroom categories. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>The collection of stateroom category</returns> private static async Task<StateroomCategoryCollection> MapStateroomCategories(SqlDataReader dataReader) { var stateroomCategories = new StateroomCategoryCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var stateroomCategory = new StateroomCategory { StateroomCategoryTypeId = dataReader.Int16Field(StateroomCategoryTypeId).ToString(), StateroomCategoryType = dataReader.StringField(StateroomCategoryType), MediaItemAddress = dataReader.StringField(MediaItemAddress), Category = dataReader.StringField(Category) }; byte[] bytes = await stateroomCategory.MediaItemAddress.ImageAddressToByteArray(); stateroomCategory.StateroomIcon = bytes.ToBitmapSource(); stateroomCategories.Add(stateroomCategory); } } return stateroomCategories; }
/// <summary> /// Maps the ships. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Ship data filled.</returns> private static async Task<Ship> MapShips(SqlDataReader dataReader) { var ship = new Ship(); if (dataReader != null) { ship.BrandId = dataReader.ByteField(BrandId).ToString(); ship.Code = dataReader.StringField(Code); ship.MediaItemAddress = dataReader.StringField(MediaItemAddress); ship.Name = dataReader.StringField(Name); ship.ShipId = dataReader.Int16Field(ShipId).ToString(); byte[] bytes = await ship.MediaItemAddress.ImageAddressToByteArray(); ship.ShipImage = bytes.ToBitmapSource(); } return await Task.FromResult(ship); }
/// <summary> /// Maps the document types. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Document types</returns> private static async Task<DocumentTypeCollection> MapDocumentTypes(SqlDataReader dataReader) { var documentTypeCollection = new DocumentTypeCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var documentType = new DocumentType { DocumentTypeId = dataReader.Int16Field(DocumentTypeId).ToString(), Code = dataReader.StringField(Code), Name = dataReader.StringField(Name), CountryId = dataReader.Int32NullableField(CountryId).HasValue ? dataReader.Int32NullableField(CountryId).Value.ToString() : null }; documentTypeCollection.Add(documentType); } } return documentTypeCollection; }
/// <summary> /// Maps the states. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>State collection.</returns> private static async Task<StateCollection> MapStates(SqlDataReader dataReader) { var stateCollection = new StateCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var state = new State { CountryId = dataReader.Int32Field(CountryId).ToString(), StateId = dataReader.Int32Field(StateId).ToString(), Name = dataReader.StringField(Name) }; stateCollection.Add(state); } } return stateCollection; }
/// <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 history. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>gangway history Object.</returns> private static GangwayHistory MapHistory(SqlDataReader dataReader) { return new GangwayHistory { PersonId = dataReader.StringField(PersonID), PersonTypeId = dataReader.ByteNullableField(PersonTypeID).HasValue ? dataReader.ByteNullableField(PersonTypeID).Value.ToString(CultureInfo.CurrentCulture) : null, FirstName = dataReader.StringField(FirstName), LastName = dataReader.StringField(LastName), GangwayEventTypeId = dataReader.Int16NullableField(EventTypeId).HasValue ? dataReader.Int16NullableField(EventTypeId).Value.ToString(CultureInfo.CurrentCulture) : null, EventDateTime = dataReader.DateTimeNullableField(EventDate), EventDetails = !string.IsNullOrWhiteSpace(dataReader.StringField(EventDetail)) ? dataReader.StringField(EventDetail).DeserializeXml<EventDetail>() : null, GangwayLocation = dataReader.StringField(Location), MachineName = dataReader.StringField(MachineName), PortCode = dataReader.StringField(Port), UserName = dataReader.StringField(AddedBy) }; }
/// <summary> /// Maps the guest personal detail. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Guest Collection.</returns> private static async Task<GuestCollection> MapGuests(SqlDataReader dataReader) { var guestCollection = new GuestCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var guest = new Guest(); guest.GuestId = dataReader.Int32Field(GuestId).ToString(); var hasAlert = dataReader.BooleanNullableField(HasAlert); guest.HasAlert = hasAlert.HasValue ? hasAlert.Value : false; var hasMessage = dataReader.BooleanNullableField(HasMessage); guest.HasMessage = hasMessage.HasValue ? hasMessage.Value : false; guest.LastDateTime = dataReader.DateTimeNullableField(LastDateTime); guest.LastEvent = dataReader.StringField(LastEvent); guest.SecurityPhotoAddress = dataReader.StringField(SecurityPhotoMediaItemAddress); byte[] bytes = await guest.SecurityPhotoAddress.ImageAddressToByteArray(); guest.Photo = bytes.ToBitmapSource(); guest.AssignPhotoByteArray(new Collection<byte>(bytes)); guestCollection.Add(guest); } } return guestCollection; }
/// <summary> /// Maps the person status. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Person Status List.</returns> internal static async Task<List<PersonStatus>> MapPersonStatus(SqlDataReader dataReader) { var personStatusList = new List<PersonStatus>(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var personStatus = new PersonStatus(); personStatus.PersonId = dataReader.Int32Field(PersonId); personStatus.Status = dataReader.StringField(Status); personStatus.StatusChangedDate = dataReader.DateTimeNullableField(StatusChangedDate); personStatusList.Add(personStatus); } if (!dataReader.IsClosed) { dataReader.Close(); } } return personStatusList; }
/// <summary> /// Maps the visitors. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>The visitor collection</returns> private static async Task<VisitorCollection> MapVisitors(SqlDataReader dataReader) { var visitors = new VisitorCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var visitor = new Visitor { HasAlert = dataReader.BooleanNullableField(HasAlert).HasValue ? dataReader.BooleanNullableField(HasAlert).Value : false, HasMessage = dataReader.BooleanNullableField(HasMessage).HasValue ? dataReader.BooleanNullableField(HasMessage).Value : false, LastDateTime = dataReader.DateTimeNullableField(LastDateTime), LastEvent = dataReader.StringField(LastEvent), SecurityPhotoAddress = dataReader.StringField(SecurityPhotoAddress), VisitorId = dataReader.Int32Field(VisitorId).ToString(), VisitorTypeId = dataReader.ByteField(VisitorTypeId).ToString(), VisitorType = dataReader.StringField(VisitorType), VisitPurpose = dataReader.StringField(VisitPurpose) }; byte[] bytes = await visitor.SecurityPhotoAddress.ImageAddressToByteArray(); visitor.Photo = bytes.ToBitmapSource(); visitor.AssignPhotoByteArray(new Collection<byte>(bytes)); visitors.Add(visitor); } } return visitors; }
/// <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 crew personal detail. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>The crew member</returns> private static async Task<CrewmemberCollection> RetrieveCrewmemberPersonalDetail(SqlDataReader dataReader) { var crewmembers = new CrewmemberCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var crewmember = new Crewmember(); crewmember.CrewmemberId = dataReader.Int32Field(CrewMemberId).ToString(); crewmember.PersonalDetail = new PersonalDetail(); crewmember.PersonalDetail.Age = dataReader.Int16NullableField(Age); crewmember.PersonalDetail.AnniversaryDate = dataReader.DateTimeNullableField(AnniversaryDate); crewmember.PersonalDetail.BirthCountryId = dataReader.Int32NullableField(BirthCountryId).ToString(); crewmember.PersonalDetail.Birthdate = dataReader.DateTimeNullableField(BirthDate); crewmember.PersonalDetail.CitizenshipCountryId = dataReader.Int32NullableField(CitizenshipCountryId).ToString(); crewmember.PersonalDetail.FirstName = dataReader.StringField(FirstName); crewmember.PersonalDetail.Gender = dataReader.StringField(Gender); crewmember.PersonalDetail.LastName = dataReader.StringField(LastName); crewmember.PersonalDetail.MaritalStatus = dataReader.StringField(MaritalStatus); crewmember.PersonalDetail.MiddleName = dataReader.StringField(MiddleName); crewmember.PersonalDetail.Nickname = dataReader.StringField(NickName); crewmember.PersonalDetail.Occupation = dataReader.StringField(Occupation); crewmember.PersonalDetail.DocumentNumber = dataReader.StringField(DocumentNumber); crewmember.PersonalDetail.Suffix = dataReader.StringField(Suffix); crewmember.PersonalDetail.Title = dataReader.StringField(Title); crewmember.PersonalDetail.PreferredName = dataReader.StringField(PreferredName); crewmember.BoardingInfo.OnboardDate = dataReader.DateTimeNullableField(OnboardDate); crewmember.BoardingInfo.AshoreDate = dataReader.DateTimeNullableField(AshoreDate); crewmembers.Add(crewmember); } } return crewmembers; }
/// <summary> /// Maps the person types. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Person types.</returns> private static async Task<PersonTypeEntityCollection> MapPersonTypes(SqlDataReader dataReader) { var personTypeEntityCollection = new PersonTypeEntityCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var personTypeEntity = new PersonTypeEntity { PersonTypeId = dataReader.Int32Field(PersonTypeId).ToString(), Name = dataReader.StringField(Name) }; personTypeEntityCollection.Add(personTypeEntity); } } return personTypeEntityCollection; }
/// <summary> /// Maps the event types. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Event type data filled</returns> private static async Task<EventType> MapEventTypes(SqlDataReader dataReader) { var eventType = new EventType(); if (dataReader != null) { eventType.EventTypeId = dataReader.Int16NullableField(EventTypeId).ToString(); eventType.Name = dataReader.StringField(Name); eventType.Description = dataReader.StringField(Description); } return await Task.FromResult(eventType); }
/// <summary> /// Maps the folio. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>returns folio.</returns> private static Folio MapFolio(SqlDataReader dataReader) { return new Folio { FolioNumber = dataReader.StringField(FolioNumber), AccessCardNumber = dataReader.StringField(AccessCardNumber), FolioStatus = dataReader.StringField(FolioStatus), IsGangwayAllowed = dataReader.BooleanField(GangwayAllowedFlag) }; }
/// <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 travel party asynchronous. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns></returns> internal static async Task<string> MapTravelPartyAsync(SqlDataReader dataReader) { StringBuilder reservationNumberTravelWith = new StringBuilder(); if (dataReader != null) { while (await dataReader.ReadAsync()) { reservationNumberTravelWith.Append(dataReader.StringField("TravelWithReservationNumber")).Append(","); }; return reservationNumberTravelWith.ToString().TrimEnd(','); } return string.Empty; }
/// <summary> /// Maps the message. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns> filled Message object</returns> private static Message MapMessage(SqlDataReader dataReader) { return new Message { Description = dataReader.StringField(Description), Subject = dataReader.StringField(Subject), ImageAddress = dataReader.StringField(ImageAddress) }; }
/// <summary> /// Maps the countries. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Country collection</returns> private static async Task<CountryCollection> MapCountries(SqlDataReader dataReader) { var countryCollection = new CountryCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var country = new Country { CountryId = dataReader.Int32Field(CountryId).ToString(), Code = dataReader.StringField(Code), Name = dataReader.StringField(Name), CountryFlagAddress = dataReader.StringField(CountryFlagAddress) }; byte[] bytes = await country.CountryFlagAddress.ImageAddressToByteArray(); country.CountryIcon = bytes.ToBitmapSource(); countryCollection.Add(country); } } return countryCollection; }