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