Exemple #1
0
        public async Task <IActionResult> UpdateDish(UpdateDishDTO dish)
        {
            //TODO: Complete this route, and ensure the proper data is being returned.
            var updated = await _dish.UpdateDish(dish);

            // This should be correct but it needs testing.
            if (updated)
            {
                return(Ok());
            }

            return(BadRequest());
        }
        /// <summary>
        /// Updates a Dish and its recipes in the database.
        /// </summary>
        /// <param name="dish">Requires a complete DishDTO including all of its recipes.</param>
        /// <returns>True: if successful</returns>
        public async Task <bool> UpdateDish(UpdateDishDTO dish)
        {
            // TODO: Complete this method and write a (few?) test(s) to confirm its functionality.
            // Completing this method may require usage of other services
            // A few things to remember with the update:
            // 1. When updating the dish, the recipe could change.
            // 2. A recipe consists of ingredients, which could also change

            // Get the dish
            // Update the items in the DB with the new DTO
            // Update the dish with the new recipes
            // Update the new recipes with new ingredients
            // If successful return true
            // If unsuccessful return false

            // Get the Dish from the database
            var dishFromDB = await _context.Dishes.Where(x => x.Name == dish.Name).FirstOrDefaultAsync();

            if (dishFromDB == null)
            {
                return(false);
            }

            // Update its basic information
            dishFromDB.Name     = dish.Name;
            dishFromDB.DishType = dish.Type;

            // Update the database
            _context.Entry(dishFromDB).State = EntityState.Modified;

            // Find all join entities between this dish and recipes
            var deleteTheseRecipes = await _context.DishRecipes.Where(x => x.DishId == dishFromDB.Id).ToListAsync();

            foreach (var recipe in deleteTheseRecipes)
            {
                // Delete those references
                _context.Entry(recipe).State = EntityState.Deleted;
            }

            foreach (var recipe in dish.Recipes)
            {
                // Build a new DishRecpie join entity
                var newRecpieJoin = new DishRecipe
                {
                    DishId   = dish.Id,
                    RecipeId = recipe.Id
                };

                // Add that entity to the database
                _context.Entry(newRecpieJoin).State = EntityState.Added;

                // Find all join entities between this Recipe and its ingredients
                var deleteTheseIngredientsFromTheRecipe = await _context.RecipeIngredients.Where(x => x.RecipeId == recipe.Id).ToListAsync();

                foreach (var ingredient in deleteTheseIngredientsFromTheRecipe)
                {
                    // Delete those references
                    _context.Entry(ingredient).State = EntityState.Deleted;
                }

                foreach (var ingredient in recipe.Ingredients)
                {
                    // Build a new RecipeIngredient join entity
                    var newIngredientJoin = new RecipeIngredients
                    {
                        RecipeId     = recipe.Id,
                        IngredientId = ingredient.Id
                    };

                    // Add that entity into the database
                    _context.Entry(newIngredientJoin).State = EntityState.Added;
                }
            }

            // Save All the Changes
            await _context.SaveChangesAsync();

            return(true);
        }