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