public IActionResult Breads(string resId)
{
var foods = _context.Foods.ToList();
var frs = _context.FoodRestaurants.Include(ff => ff.Food).Where(ff => ff.RestaurantId == resId).ToList();
var foodRestaurant = new FoodRestaurant
{
RestaurantId = resId,
FoodRestaurantPrice = 0.0f
};
foodRestaurant.AvailableFoodsCanBeAdded = new List <SelectListItem>();
if (frs.Count != 0)
{
foreach (var eachFrs in frs)
{
var eachFood = foods.SingleOrDefault(ff => ff.FoodId == eachFrs.FoodId);
foods.Remove(eachFood);
}
}
foreach (var eachFood in foods)
{
foodRestaurant.AvailableFoodsCanBeAdded.Add(new SelectListItem
{
Value = eachFood.FoodId.ToString(),
Text = eachFood.FoodName
});
}
ViewBag.FoodsOfTheRestaurant = frs;
ViewBag.restaurantIdViewBag = resId;
return(View(foodRestaurant));
}
public async Task <IActionResult> DeleteBread(FoodRestaurant foodRestaurant)
{
try
{
var deleteAnItemFromRestaurant = await _context.Database
.ExecuteSqlInterpolatedAsync($"EXEC sp__RemoveItemOfTheRestaurant @foodId = {foodRestaurant.FoodId}, @restaurantId = {foodRestaurant.RestaurantId}");
return(RedirectToAction("Breads", "Restaurant", new
{
resId = foodRestaurant.RestaurantId
}));
}
catch (Exception e)
{
throw;
}
}
public async Task <IActionResult> Breads(FoodRestaurant foodRestaurant)
{
foodRestaurant.AddedIn = DateTime.Today;
try
{
var res = await _context.Database.ExecuteSqlInterpolatedAsync(
$"EXEC sp__PushNewItemOfTheRestaurant @foodId={foodRestaurant.FoodId}, @restaurantId={foodRestaurant.RestaurantId}, @added = {foodRestaurant.AddedIn}, @price = {foodRestaurant.FoodRestaurantPrice}");
return(RedirectToAction("Breads", "Restaurant", new
{
resId = foodRestaurant.RestaurantId
}));
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
