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++;
}
}
}
}
}