public FoodsItemsExtraVM ViewModel(int id, bool descending, SortFoodItemExtra sortOrder) { var foodItemExtra = NHibernateHelperCore.GetEntities <FoodItemExtra>(a => a.FoodCategory.Id == id); var foodItemExtraVM = foodItemExtra.Select(a => new FoodItemExtraVM() { Id = a.Id, Name = a.Name, Price = a.Price, FoodCategoryId = id }).ToList(); foodItemExtraVM = sortOrder switch { SortFoodItemExtra.Name when !descending => foodItemExtraVM.OrderBy(s => s.Name).ToList(), SortFoodItemExtra.Name when descending => foodItemExtraVM.OrderByDescending(s => s.Name).ToList(), SortFoodItemExtra.Price when !descending => foodItemExtraVM.OrderBy(s => s.Price).ToList(), SortFoodItemExtra.Price when descending => foodItemExtraVM.OrderByDescending(s => s.Price).ToList(), _ => foodItemExtraVM.OrderByDescending(s => s.Name).ToList(), }; var foodsItemsExtraVm = new FoodsItemsExtraVM() { FoodsItemsExtra = foodItemExtraVM, FoodCategoryId = id, Descending = descending, Sort = sortOrder, Admin = User.IsInRole(NHibernateHelperCore.RoleAdmin) }; return(foodsItemsExtraVm); }
public ActionResult CreateOrUpdateFoodItemToExtra(int id) { var foodItemToExtra = NHibernateHelperCore.GetSingleOrDefault <FoodItemToExtra>(a => a.Id == id); var foodItems = NHibernateHelperCore.GetEntities <FoodItem>() .Select(a => new SelectListItem() { Value = a.Id.ToString(), Text = a.Name }).ToList(); var foodItemExtras = NHibernateHelperCore.GetEntities <FoodItemExtra>() .Select(a => new SelectListItem() { Value = a.Id.ToString(), Text = a.Name }).ToList(); var foodItemToExtraVM = new CreateOrUpdateFoodItemToExtraVM() { Id = foodItemToExtra?.Id, FoodItemId = foodItemToExtra?.FoodItem.Id, FoodItemExtraId = foodItemToExtra?.FoodItemExtra.Id, FoodItems = foodItems, FoodItemExtras = foodItemExtras }; return(View(foodItemToExtraVM)); }
public ActionResult Index() { var foodItemToExtra = NHibernateHelperCore.GetEntities <FoodItemToExtra>(); var foodItemToExtraVM = foodItemToExtra.Select(a => new FoodItemToExtraVM() { Id = a.Id }).ToList(); return(View(foodItemToExtraVM)); }
public IActionResult SearchAllEntities(string txt) { var foodItem = NHibernateHelperCore.GetEntities <FoodItem>(); var foodItemExtra = NHibernateHelperCore.GetEntities <FoodItemExtra>(); AllItemsVM allItems; if (!string.IsNullOrWhiteSpace(txt)) { txt = txt.ToLower(); allItems = new AllItemsVM() { FoodsItems = foodItem.Where(compare => compare.Name.ToLower() .Contains(txt)) .Select(a => new FoodItemVM() { Name = a.Name, Price = a.Price, Id = a.Id }).ToList(), FoodsItemsExtraVM = foodItemExtra.Where(compare => compare.Name.ToLower() .Contains(txt)) .Select(a => new FoodItemExtraVM() { Name = a.Name, Price = a.Price, Id = a.Id }).ToList() }; } else { allItems = new AllItemsVM() { FoodsItems = foodItem.Select(a => new FoodItemVM() { Name = a.Name, Price = a.Price, Id = a.Id }).ToList(), FoodsItemsExtraVM = foodItemExtra.Select(a => new FoodItemExtraVM() { Name = a.Name, Price = a.Price, Id = a.Id }).ToList() }; } return(Json(allItems)); }
private FoodsCategoriesVM ViewModel(string txt, bool descending, SortFoodCategory sortOrder) { var foodCategory = NHibernateHelperCore.GetEntities <FoodCategory>(); var foodCategoryVM = new List <FoodCategoryVM>(); if (!string.IsNullOrWhiteSpace(txt)) { txt = txt.ToLower(); foodCategoryVM = foodCategory.Where(compare => compare.Name.ToLower().Contains(txt)) .Select(a => new FoodCategoryVM() { Name = a.Name, Id = a.Id }).ToList(); } else { foodCategoryVM = foodCategory.Select(a => new FoodCategoryVM() { Name = a.Name, Id = a.Id }).ToList(); } foodCategoryVM = sortOrder switch { SortFoodCategory.Name when !descending => foodCategoryVM.OrderBy(s => s.Name).ToList(), SortFoodCategory.Name when descending => foodCategoryVM.OrderByDescending(s => s.Name).ToList(), _ => foodCategoryVM.OrderByDescending(s => s.Name).ToList(), }; var foodsCategoriesVM = new FoodsCategoriesVM() { FoodsCategories = foodCategoryVM, Descending = descending, Sort = sortOrder, Admin = User.IsInRole(NHibernateHelperCore.RoleAdmin) }; return(foodsCategoriesVM); }
public IActionResult DeleteFoodCategory(int id) { var delFoodCategory = NHibernateHelperCore.GetSingleOrDefault <FoodCategory>(a => a.Id == id); var foodItem = NHibernateHelperCore.GetEntities <FoodItem>(a => a.FoodCategory.Id == id); var foodItemExtra = NHibernateHelperCore.GetEntities <FoodItemExtra>(a => a.FoodCategory.Id == id); if (foodItem.Count != 0 && foodItemExtra.Count != 0) { foreach (var delFoodItem in foodItem) { NHibernateHelperCore.DeleteEntities <FoodItem>(delFoodItem); } foreach (var delFoodItemExtra in foodItemExtra) { NHibernateHelperCore.DeleteEntities <FoodItemExtra>(delFoodItemExtra); } } NHibernateHelperCore.DeleteEntities <FoodCategory>(delFoodCategory); return(RedirectToAction("Index", "Home")); }