/// <summary> /// Maps the ship time data. /// </summary> /// <param name="dataReader">The data reader.</param> /// <returns>Gets the ship time</returns> internal static async Task<ShipTime> MapShipTimeData(SqlDataReader dataReader) { var shipTime = new ShipTime(); if (dataReader != null) { while (await dataReader.ReadAsync()) { shipTime.ShipId = dataReader.Int16Field(ShipId).ToString(); shipTime.UtcOffset = dataReader.Int16Field(UtcOffset); } } return shipTime; }
/// <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> /// 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 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 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> /// Function to map Brands. /// </summary> /// <param name="dataReader">Instance of SqlDataReader</param> /// <returns>Brand Collection</returns> private static async Task<BrandCollection> MapBrands(SqlDataReader dataReader) { var brandCollection = new BrandCollection(); if (dataReader != null) { while (await dataReader.ReadAsync()) { var brand = new Brand { BrandId = dataReader.Int16Field(BrandId).ToString(), Name = dataReader.StringField(Name), MediaItemAddress = dataReader.StringField(MediaItemAddress) }; byte[] bytes = await brand.MediaItemAddress.ImageAddressToByteArray(); brand.BrandIcon = bytes.ToBitmapSource(); brandCollection.Add(brand); } } return brandCollection; }