예제 #1
0
파일: BookingDao.cs 프로젝트: ognjenm/egle
        /// <summary>
        /// Get booking ids for a check in date and channel booking scenario
        /// </summary>
        /// <param name="checkInDate">Check in date</param>
        /// <param name="channelBookingScenario">Channel booking scenario</param>
        /// <returns>
        /// The list of bookings with Id populated only 
        /// </returns>
        public List<int> GetBookingIdsByCheckInDateAndChannelScenario(DateTime checkInDate, BookingScenarioTypeEnum channelBookingScenario)
        {
            const string SQL_QUERY = @"SELECT B.Id
                                       FROM Booking.Booking B
                                       INNER JOIN Booking.Orders O ON O.Id = B.OrderId
                                       INNER JOIN Distribution.Channel C ON C.Id = O.ChannelId
                                       INNER JOIN Distribution.ChannelBookingScenario CBS ON CBS.ChannelId = C.Id
                                       WHERE DATEADD(dd, 0, DATEDIFF(dd, 0, B.CheckinDatetime)) = @CheckinDate AND CBS.BookingScenarioCode = @BookingScenarioCode";

            var parameters = new List<SqlParameter>
            {
                DbHelper.CreateParameter(BookingMapper.Parameters.CheckinDate, checkInDate),
                DbHelper.CreateParameter(BookingMapper.Parameters.BookingScenarioCode, channelBookingScenario.GetCode())
            };

            return DbHelper.CreateValueList<int>(SQL_QUERY, BookingMapper.Parameters.Id.ToString(), parameters: parameters);
        }
예제 #2
0
            public void GetAgentPaymentAmountReturnsCorrectAmountsForScenariosGiven(BookingScenarioTypeEnum scenarioType, decimal totalBookingValue, decimal distributorPercentage, decimal expectedPercent)
            {
                // Arrange
                // done through test cases

                // Act
                SettlementManager settlementManager = new SettlementManager();

                decimal result = settlementManager.GetAgentPaymentAmount(scenarioType, totalBookingValue,
                                                                         distributorPercentage);

                // Assert
                Assert.AreEqual(expectedPercent, result, string.Format("percentage did not match test case. scenario:{0}, ttv:{1}, percentage:{2}, expected:{3}", scenarioType.GetCode(), totalBookingValue, distributorPercentage, expectedPercent));
            }