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