/// <summary>
        /// Maps the guest embark.
        /// </summary>
        /// <param name="guestEmbarkStatsCollection">The guest embark stats collection.</param>
        /// <returns>
        /// return GuestEmbarkStats
        /// </returns>
        public static GuestEmbarkStats MapGuestEmbarkData(IEnumerable<Entities.GuestEmbarkStats> guestEmbarkStatsCollection)
        {
            var guestEmbark = new GuestEmbarkStats();
            if (guestEmbarkStatsCollection != null)
            {
                foreach (var guestEmbarkations in guestEmbarkStatsCollection)
                {
                    guestEmbark.Ashore += guestEmbarkations.Ashore;
                    guestEmbark.CheckedIn += guestEmbarkations.CheckedIn;
                    guestEmbark.DebarkingToday += guestEmbarkations.DebarkingToday;
                    guestEmbark.ExpectedToday += guestEmbarkations.ExpectedToday;
                    guestEmbark.NotCheckedIn += guestEmbarkations.NotCheckedIn;
                    guestEmbark.Onboard += guestEmbarkations.Onboard;
                    guestEmbark.TotalOccupancy += guestEmbarkations.TotalOccupancy;
                }
            }

            return guestEmbark;
        }
        /// <summary>
        /// Function to map GuestEmbarkStats.
        /// </summary>
        /// <param name="dataReader">Instance of SqlDataReader</param>
        /// <returns>Instance of GuestEmbarkStats</returns>
        private static async Task<GuestEmbarkStats> MapGuestEmbarkStatistics(SqlDataReader dataReader)
        {
            var guestEmbarkStats = new GuestEmbarkStats();

            if (dataReader != null)
            {
                while (await dataReader.ReadAsync())
                {
                    guestEmbarkStats = new GuestEmbarkStats
                    {
                        Ashore = dataReader.Int32Field(Ashore),
                        CheckedIn = dataReader.Int32Field(CheckedIn),
                        DebarkingToday = dataReader.Int32Field(DebarkingTodayField),
                        ExpectedToday = dataReader.Int32Field(ExpectedToday),
                        NotCheckedIn = dataReader.Int32Field(NotCheckedIn),
                        Onboard = dataReader.Int32Field(Onboard),
                        TotalOccupancy = dataReader.Int32Field(TotalOccupancy)
                    };
                }
            }

            return guestEmbarkStats;
        }