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