コード例 #1
0
 public ActionResult ShowCategoryItems(int id)
 {
     using (FoodOrderEntities db = new FoodOrderEntities())
     {
         CatItemViewModel viewModel = new CatItemViewModel();
         var itemData = db.FoodItems.Where(x => x.catId == id &&
                                           x.isEnabled == true &&
                                           x.isDeleted == false &&
                                           x.quantity != "0").ToList();
         var catData = db.Categories.Where(x => x.catId == id).ToList();
         viewModel.category = catData;
         viewModel.foodItem = itemData;
         return(View(viewModel));
     }
 }
コード例 #2
0
        CatItemViewModel GetAllCatItems()
        {
            using (FoodOrderEntities db = new FoodOrderEntities())
            {
                var catData  = db.Categories.ToList();
                var itemData = db.FoodItems.Where(x => x.isDeleted == false).ToList();

                var viewModel = new CatItemViewModel()
                {
                    category = catData,
                    foodItem = itemData
                };
                return(viewModel);
            }
        }