public static object MostPopularFilm(CouchDatabase <Ticket> database)
{
var thirdQuery = database
.AsQueryable().Take(dataCount)
.GroupBy(x => x.FilmShow.Film.FilmId)
.Select(x => new
{
x.FirstOrDefault().FilmShow.Film,
Number = x.Count()
})
.OrderByDescending(x => x.Number)
.ToList();
return(thirdQuery);
}
public static object PersonMostCinemas(CouchDatabase <Ticket> database)
{
var secondQuery = database
.AsQueryable().Take(dataCount)
.GroupBy(x => x.Person.PersonId)
.Select(x => new
{
x.FirstOrDefault().Person,
Number = x.Count()
})
.OrderByDescending(x => x.Number)
.ToList();
return(secondQuery);
}
public static object MostProfitableCinema(CouchDatabase <Ticket> database)
{
var firstQuery = database
.AsQueryable().Take(dataCount)
.GroupBy(x => x.FilmShow.Cinema.CinemaId)
.Select(x => new
{
Id = x.FirstOrDefault().FilmShow.Cinema.CinemaId,
Price = x.Sum(c => c.TicketPrice)
})
.OrderByDescending(x => x.Price)
.ToList();
return(firstQuery);
}
public void Max()
{
using (var httpTest = new HttpTest())
{
httpTest.RespondWithJson(_response);
var result = _rebels.AsQueryable().Max(r => r.Age);
Assert.Equal(_mainRebel.Age, result);
}
}
public void All()
{
using (var httpTest = new HttpTest())
{
httpTest.RespondWithJson(_response);
var result = _rebels.AsQueryable().All(r => r.Name == _mainRebel.Name);
Assert.True(result);
}
}
