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