public void GetRestaurantStatistic()
{
log.InfoFormat("[GetRestaurantStatistic].");
var queryCollection = Query.NE("IsDeleted", true);
using (Restaurants restaurantsDb = new Restaurants())
{
MongoEntityRepositoryBase<RestaurantBasicData> basicData =
new MongoEntityRepositoryBase<RestaurantBasicData>(restaurantsDb.DB);
var queryNotNullCuisines = Query.Or(
Query.NE("Cuisine", BsonValue.Create(BsonNull.Value)),
Query.NE("Cuisines", BsonValue.Create(BsonNull.Value))
);
int notNullCuisine = basicData.FindAs(queryNotNullCuisines).Count();
var queryNotNullCuisineWithMenu = Query.And(
queryNotNullCuisines,
Query.Exists("Menu.MenuParts,1")
);
int notNullCuisineWithMenuCount = basicData.FindAs(queryNotNullCuisineWithMenu).Count();
var queryNotNullCuisineWithNullMenu = Query.And(
queryNotNullCuisines,
Query.Size("Menu.MenuParts", 0)
);
int notNullCuisineWithNullMenuCount = basicData.FindAs(queryNotNullCuisineWithNullMenu).Count();
log.DebugFormat("[GetRestaurantStatistic] notNullCuisine={0}, notNullCuisineWithMenuCount={1}, notNullCuisineWithNullMenuCount={2}.", notNullCuisine, notNullCuisineWithMenuCount, notNullCuisineWithNullMenuCount);
}
}