コード例 #1
0
ファイル: RecipesDA.cs プロジェクト: FEDexperts/MyBuyList
        internal void RemoveRecipeFromShoppingList(int userId, int recipeId)
        {
            RecipesInShoppingList recipesInShoppingList = DataContext.RecipesInShoppingLists.SingleOrDefault(p => p.USER_ID == userId && p.RECIPE_ID == recipeId);

            DataContext.RecipesInShoppingLists.DeleteOnSubmit(recipesInShoppingList);
            DataContext.SubmitChanges();
        }
コード例 #2
0
        //private void BindRecipesList()
        //{
        //    IQueryable<RecipesInShoppingList> recipes = BusinessFacade.Instance.GetSelectedRecipes(UserId);
        //    RepeaterRecipes.ItemDataBound += RepeaterRecipes_ItemDataBound;
        //    RepeaterRecipes.DataSource = recipes;
        //    RepeaterRecipes.DataBind();

        //    NumOfSelectedRecipes = recipes.Count();
        //}

        private void RepeaterRecipes_ItemDataBound(object sender, RepeaterItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                RecipesInShoppingList recipe     = (RecipesInShoppingList)e.Item.DataItem;
                HyperLink             recipeName = (HyperLink)e.Item.FindControl("RecipeName");
                recipeName.Text        = recipe.RECIPE_NAME.Substring(0, recipe.RECIPE_NAME.Length <= 40 ? recipe.RECIPE_NAME.Length : 30);
                recipeName.NavigateUrl = string.Format("../RecipeDetails.aspx?RecipeId={0}", recipe.RECIPE_ID);
                recipeName.ToolTip     = recipe.RECIPE_NAME;
            }
        }
コード例 #3
0
ファイル: RecipesDA.cs プロジェクト: FEDexperts/MyBuyList
        internal void AddRecipeToShoppingList(int userId, int recipeId)
        {
            RecipesInShoppingList recipesInShoppingList = DataContext.RecipesInShoppingLists.SingleOrDefault(p => p.USER_ID == userId && p.RECIPE_ID == recipeId);

            if (recipesInShoppingList == null)
            {
                Recipe recipe = DataContext.Recipes.SingleOrDefault(p => p.RecipeId == recipeId);

                recipesInShoppingList = new RecipesInShoppingList()
                {
                    USER_ID   = userId,
                    RECIPE_ID = recipeId,
                    SERVINGS  = recipe.Servings
                };

                DataContext.RecipesInShoppingLists.InsertOnSubmit(recipesInShoppingList);
                DataContext.SubmitChanges();
            }
        }