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(); }
//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; } }
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(); } }