public void FlightBooking_FindByFlightAndDate()
        {
            FlightBookingRepository repository = new FlightBookingRepository(dbConnectionString);

            var result = repository.Find(1, DateTime.Parse("2018-8-8"));

            Assert.IsNotNull(result);
            Assert.IsTrue(result.FlightBookingId > 0);
        }
        public void FlightBooking_FindByDate()
        {
            FlightBookingRepository repository = new FlightBookingRepository(dbConnectionString);

            var result = repository.Find(DateTime.Parse("2018-8-8"), DateTime.Parse("2018-8-12"));

            Assert.IsNotNull(result);
            Assert.IsTrue(result.ToList().Count > 0);
        }
        public FlightsController(IConfiguration configuration)
        {
            _configuration = configuration;
            conString      = configuration.GetSection("ConnectionString").Value;

            flightRepository        = new FlightRepository(conString);
            passengerRepository     = new PassengerRepository(conString);
            flightBookingRepository = new FlightBookingRepository(conString);
            bookingRepository       = new BookingRepository(conString);
        }
        public void FlightBooking_Update_PassengerCount()
        {
            FlightBookingRepository repository = new FlightBookingRepository(dbConnectionString);

            FlightBooking flightBooking = new FlightBooking
            {
                FlightId       = 1,
                TravelDate     = DateTime.Parse("2018-8-8"),
                PassengerCount = 2
            };
            var result = repository.Update(flightBooking);

            Assert.AreEqual(1, result);
        }
        public void FlightBooking_AddNew()
        {
            FlightBookingRepository repository = new FlightBookingRepository(dbConnectionString);

            var rndDays = new Random().Next(1, 30);

            FlightBooking flightBooking = new FlightBooking
            {
                TravelDate     = DateTime.Now.Date.AddDays(rndDays),
                FlightId       = 8,
                PassengerCount = 2
            };

            var result = repository.Add(flightBooking);

            Assert.AreEqual(1, result);
        }