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