/// <summary>
        /// Maps the crew embark.
        /// </summary>
        /// <param name="crewEmbarkStatsCollection">The crew embark stats collection.</param>
        /// <returns>return CrewEmbarkStats</returns>
        public static CrewEmbarkStats Map(IEnumerable<Entities.CrewEmbarkStats> crewEmbarkStatsCollection)
        {
            var crewEmbark = new CrewEmbarkStats();
            if (crewEmbarkStatsCollection != null)
            {
                foreach (var crewEmbarkations in crewEmbarkStatsCollection)
                {
                    crewEmbark.Ashore += crewEmbarkations.Ashore;
                    crewEmbark.SignIn += crewEmbarkations.CheckedIn;
                    crewEmbark.DebarkingToday += crewEmbarkations.DebarkingToday;
                    crewEmbark.ExpectedToday += crewEmbarkations.ExpectedToday;
                    crewEmbark.Onboard += crewEmbarkations.Onboard;
                    crewEmbark.TotalOccupancy += crewEmbarkations.TotalOccupancy;
                }
            }

            return crewEmbark;
        }
        /// <summary>
        /// Function to map CrewEmbarkStats.
        /// </summary>
        /// <param name="dataReader">Instance of SqlDataReader</param>
        /// <returns>Instance of CrewEmbarkStats</returns>
        private static async Task<CrewEmbarkStats> MapCrewEmbarkStatistics(SqlDataReader dataReader)
        {
            var crewEmbarkStats = new CrewEmbarkStats();

            if (dataReader != null)
            {
                while (await dataReader.ReadAsync())
                {
                    crewEmbarkStats = new CrewEmbarkStats
                    {
                        Ashore = dataReader.Int32Field(Ashore),
                        SignIn = dataReader.Int32Field(SignIn),
                        DebarkingToday = dataReader.Int32Field(DebarkingTodayField),
                        ExpectedToday = dataReader.Int32Field(ExpectedToday),
                        Onboard = dataReader.Int32Field(Onboard),
                        TotalOccupancy = dataReader.Int32Field(TotalOccupancy)
                    };
                }
            }

            return crewEmbarkStats;
        }