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