public List <SpecialEvent> SpecialEvent_List()
{
//interfacing with our Context class which is inherites DBContext which ties into entity framework
using (eResturantContext context = new eResturantContext())
{
return(context.SpecialEvents.ToList());
}
}
public List <MenuCategoryFoodItems> MenuCategoryFoodItems_Get()
{
using (var context = new eResturantContext())
{
var results = from food in context.Items
orderby food.MenuCategory.Description
select new MenuCategoryFoodItems
{
MenuCategoryDescription = food.MenuCategory.Description
, ItemID = food.ItemID
, FoodDescription = food.Description
, CurrentPrice = food.CurrentPrice
, TimesServed = food.BillItems.Count()
};
return(results.ToList());
}
}
public List <MenuCategoryFoodItemsDTO> MenuCategoryFoodItemsDTO_Get()
{
using (var context = new eResturantContext())
{
var results = from food in context.Items
group food by new { food.MenuCategory.Description } into tempdataset
select new MenuCategoryFoodItemsDTO
{
MenuCategoryDescription = tempdataset.Key.Description
,
FoodItems = (from a in tempdataset
select new FoodItemCounts
{
ItemID = a.ItemID
, FoodDescription = a.Description
, CurrentPrice = a.CurrentPrice
, TimesServed = a.BillItems.Count()
}
).ToList()
};
return(results.ToList());
}
}
