public async void CanGetNumberOfFlightsPerMonth()
{
// Arrange
var items =
Builder <FlightDc>
.CreateListOfSize(78)
.All()
.With(x => x.Year, 2013)
.TheFirst(1)
.With(x => x.Month, 1)
.TheNext(2)
.With(x => x.Month, 2)
.TheNext(3)
.With(x => x.Month, 3)
.TheNext(4)
.With(x => x.Month, 4)
.TheNext(5)
.With(x => x.Month, 5)
.TheNext(6)
.With(x => x.Month, 6)
.TheNext(7)
.With(x => x.Month, 7)
.TheNext(8)
.With(x => x.Month, 8)
.TheNext(9)
.With(x => x.Month, 9)
.TheNext(10)
.With(x => x.Month, 10)
.TheNext(11)
.With(x => x.Month, 11)
.TheNext(12)
.With(x => x.Month, 12)
.Build();
context.Flights.AddRange(items);
context.SaveChanges();
// Act
var result = await flightsRepository.GetNumberOfFlightsPerMonth();
result.GroupBy(x => x.Month);
//Assert
Assert.Equal(1, result.ElementAt(0).NumberOfFlights);
Assert.Equal(2, result.ElementAt(1).NumberOfFlights);
Assert.Equal(3, result.ElementAt(2).NumberOfFlights);
Assert.Equal(4, result.ElementAt(3).NumberOfFlights);
Assert.Equal(5, result.ElementAt(4).NumberOfFlights);
Assert.Equal(6, result.ElementAt(5).NumberOfFlights);
Assert.Equal(7, result.ElementAt(6).NumberOfFlights);
Assert.Equal(8, result.ElementAt(7).NumberOfFlights);
Assert.Equal(9, result.ElementAt(8).NumberOfFlights);
Assert.Equal(10, result.ElementAt(9).NumberOfFlights);
Assert.Equal(11, result.ElementAt(10).NumberOfFlights);
Assert.Equal(12, result.ElementAt(11).NumberOfFlights);
}
