示例#1
0
        public int Insert(string email, string recipeName, PreparedRecipe preparedRecipe)
        {
            if (this.cookbookDbContext.preparedRecipes.Any(pr => pr.Cook.Email == email && pr.Recipe.Name == recipeName && pr.Alias == preparedRecipe.Alias && !pr.Complete))
            {
                throw new RecordAlreadyExistException("Record alread exist.");
            }

            DAL.Cook cook = this.cookbookDbContext.cooks.FirstOrDefault(c => c.Email == email);

            DAL.Recipe recipe = this.cookbookDbContext.recipes.FirstOrDefault(r => r.Name == recipeName);

            if (cook is null || recipe is null)
            {
                throw new RecordNotFoundException("Record not found.");
            }

            DAL.PreparedRecipe newPreparedRecipe = new DAL.PreparedRecipe
            {
                Alias        = preparedRecipe.Alias,
                CookId       = cook.CookId,
                RecipeId     = recipe.RecipeId,
                Complete     = false,
                PreparedWhen = DateTime.Now,
            };

            this.cookbookDbContext.preparedRecipes.Add(newPreparedRecipe);
            this.cookbookDbContext.SaveChanges();

            return(newPreparedRecipe.PreparedRecipeId);
        }
示例#2
0
        public Cook GetByCookId(int id)
        {
            DAL.Cook cook = this.cookbookDbContext.cooks
                            .Include(c => c.Recipes)
                            .FirstOrDefault(c => c.CookId == id);
            if (cook is null)
            {
                throw new RecordNotFoundException($"No record found.");
            }

            List <Recipe> recipes = null;

            if (cook.Recipes.Any())
            {
                recipes = new List <Recipe>();
                foreach (var recipe in cook.Recipes)
                {
                    var ingredients = this.cookbookDbContext.recipeIngredients.Where(ri => ri.RecipeId == recipe.RecipeId)
                                      .Select(ri => new Ingredient
                    {
                        IngredientId = ri.IngredientId,
                        Name         = ri.Ingredient.Name
                    });

                    var preparedRecipes = this.cookbookDbContext.preparedRecipes.Where(pr => pr.RecipeId == recipe.RecipeId)
                                          .Select(pr => new PreparedRecipe
                    {
                        Alias            = string.IsNullOrEmpty(pr.Alias) ? "Empty Recipe Alias" : pr.Alias,
                        Complete         = pr.Complete,
                        PreparedWhen     = pr.PreparedWhen.ToString("MMMM dd, yyyy hh:mm tt"),
                        PreparedRecipeId = pr.PreparedRecipeId
                    });

                    recipes.Add(new Recipe
                    {
                        RecipeId        = recipe.RecipeId,
                        Name            = recipe.Name,
                        Description     = recipe.Description,
                        Ingredients     = ingredients.ToList(),
                        PreparedRecipes = preparedRecipes.ToList()
                    });
                }
            }

            return(new Cook
            {
                CookId = cook.CookId,
                Email = cook.Email,
                FirstName = cook.FirstName,
                LastName = cook.LastName,
                Recipes = recipes
            });
        }
示例#3
0
        public int Insert(Cook cook)
        {
            if (this.cookbookDbContext.cooks.Any(c => c.Email == cook.Email))
            {
                throw new RecordAlreadyExistException("Record already exist.");
            }

            DAL.Cook newCook = new DAL.Cook
            {
                Email     = cook.Email,
                FirstName = cook.FirstName,
                LastName  = cook.LastName,
            };

            this.cookbookDbContext.cooks.Add(newCook);

            return(newCook.CookId);
        }
        public int Insert(string email, Recipe recipe)
        {
            if (this.cookbookDbContext.recipes.Any(r => r.Name == recipe.Name && r.Cook.Email == email))
            {
                throw new RecordAlreadyExistException($"Record already exists.");
            }

            DAL.Cook cook = this.cookbookDbContext.cooks.FirstOrDefault(c => c.Email == email);
            if (cook is null)
            {
                throw new RecordNotFoundException("Record not found.");
            }

            DAL.Recipe newRecipe = new DAL.Recipe
            {
                Name        = recipe.Name,
                Description = recipe.Description,
                CookId      = cook.CookId
            };

            this.cookbookDbContext.recipes.Add(newRecipe);

            return(newRecipe.RecipeId);
        }