public void add(Recipe recipe, string userName) { List <Recipe> list = new List <Recipe>(); RecipeLists sortedList = new RecipeLists(); // Retrieve all recipes in database if any and add new recipe to list list = retrieveAllRecipes(userName); list.Add(recipe); // Sort all the recipes including newly added recipe in alphabetical order list = sortedList.sortRecipeList(list); // Try to drop the old table and create recipe list database try { dropTable(userName); create(list, userName); var page = HttpContext.Current.CurrentHandler as Page; ScriptManager.RegisterStartupScript(page, page.GetType(), "Scripts", "<script>alert('Recipe Successfully Added to Favorite List!!!');</script>", false); } // Catch sqlite exception to see if database error occurs catch (SqlException e3) { Debug.WriteLine("Unable to add recipe!", e3.ToString()); Debug.Write(e3.StackTrace); } // Catch any other exception for debugging catch (Exception e3) { Debug.WriteLine(e3.ToString()); Debug.Write(e3.StackTrace); } }
protected void Page_Load(object sender, EventArgs e) { string userName = User.Identity.Name; if (userName == "") { userName = "******"; } Session.Add("userName", userName); try { // Preload reg recipe list database to be displayed on grid view RecipeWS.RecipeWebService ws = new RecipeWS.RecipeWebService(); RecipeWS.WSRecipe[] wsList = ws.GetWebServiceRecipes(); int count = wsList.Length; for (int i = 0; i < count; i++) { Recipe recipe = new Recipe(); recipe.RecipeName = wsList[i].RecipeName; recipe.RecipeIngredients = wsList[i].RecipeIngredients; recipe.RecipeInstructions = wsList[i].RecipeInstructions; recipe.RecipeSize = wsList[i].RecipeSize; recipe.RecipeImage = wsList[i].RecipeImage; list.Add(recipe); } } catch { Debug.WriteLine("Unable to load data from Service1Client!"); Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Error! Unable to retrieve recipe list from host!');</script>"); } RecipeMgr recipeMgr = new RecipeMgr(); RecipeLists loadData = new RecipeLists(); // Create the recipe list database with preloaded recipes recipeMgr.storeRecipes(list); // Try to retrieve bool recipeAdded variable if available try { recipeAdded = (bool)(Session["recipeAdded"]); } catch (Exception ex) { Debug.Write(ex.StackTrace); Debug.WriteLine("Form loaded with no recipeAdded variable available."); } // Try to retrieve recipeDeleted bool variable if available try { recipeDeleted = (bool)(Session["recipeDeleted"]); } catch (Exception ex) { Debug.Write(ex.StackTrace); Debug.WriteLine("Form loaded with no recipeDeleted variable available."); } // Display success message if recipe successfully added to list from AddRecipeForm // Change the session bool variables back to false if (recipeAdded) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Success! Recipe Added to List!');</script>"); Session["recipeAdded"] = false; } else if (recipeDeleted) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Recipe successfully deleted from list!');</script>"); Session["recipeDeleted"] = false; } }