private void CalculateNumberOfItems(DateTime date) { using (FreeMarketEntities db = new FreeMarketEntities()) { NumberOrdersSingleItem = 0; NumberOrdersTwoToFive = 0; NumberOrdersGreaterFive = 0; List <GetNumberOfItemsStatistic_Result> result = db.GetNumberOfItemsStatistic().ToList(); foreach (GetNumberOfItemsStatistic_Result res in result) { if (res.OrderDatePlaced.HasValue && res.OrderDatePlaced.Value.Year == date.Year && res.OrderDatePlaced.Value.Month == date.Month) { if (res.SumItems == 1) { NumberOrdersSingleItem++; } else if (res.SumItems > 1 && res.SumItems <= 5) { NumberOrdersTwoToFive++; } else { NumberOrdersGreaterFive++; } } } } }