protected void btnAddIngredient_Click(object sender, EventArgs e) { Int32 RecipeID; try { if (!String.IsNullOrEmpty(Request.QueryString["recipe_id"])) { //get the recipe id RecipeID = Convert.ToInt32(Request.QueryString["recipe_id"]); } else { //connect using (DefaultConnectionEF conn = new DefaultConnectionEF()) { //instantiate a new recipe object in memory Recipe r = new Recipe(); //fill the properties of our object from the form inputs r.recipe_name = txtRecipeName.Text; r.directions = txtRecipeDirections.Text; //add the new object and save changes conn.Recipes.Add(r); conn.SaveChanges(); //get recipe info var Recipe = (from rec in conn.Recipes where rec.recipe_name == r.recipe_name && rec.directions == r.directions select new { rec.recipe_id}).FirstOrDefault(); RecipeID = Recipe.recipe_id; } } Response.Redirect("~/Admin/ingredient.aspx?recipe_id=" + RecipeID); } catch (Exception ex) { lblError.Text = ex.Message; } }
protected void btnSave_Click(object sender, EventArgs e) { using (DefaultConnectionEF conn = new DefaultConnectionEF()) { //instantiate a new student object in memory Ingredient i = new Ingredient(); Measurement m = new Measurement(); Int32 RecipeID = Convert.ToInt32(Request.QueryString["recipe_id"]); //decide if updating or adding, then save if (!String.IsNullOrEmpty(Request.QueryString["ingredient_id"])) { Int32 IngredientID = Convert.ToInt32(Request.QueryString["ingredient_id"]); i = (from ing in conn.Ingredients join mes in conn.Measurements on ing.ingredient_id equals mes.ingredient_id where ing.ingredient_id == IngredientID select ing).FirstOrDefault(); //fill the properties of our object from the form inputs i.Measurements.FirstOrDefault().measurement = txtMeasurement.Text; i.Measurements.FirstOrDefault().unit = ddlUnit.SelectedValue; } i.ingredient_name = txtIngredientName.Text; if (String.IsNullOrEmpty(Request.QueryString["ingredient_id"])) { m.measurement = txtMeasurement.Text; m.unit = ddlUnit.SelectedValue; m.ingredient_id = i.ingredient_id; m.recipe_id = RecipeID; conn.Ingredients.Add(i); conn.Measurements.Add(m); } conn.SaveChanges(); //redirect to updated departments page Response.Redirect("~/Admin/recipe.aspx?recipe_id=" + RecipeID); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (String.IsNullOrEmpty(Request.QueryString["recipe_id"])) { lblIngredientMessage.Text = "At Least One Ingredent Must be Added"; lblIngredientMessage.Visible = true; } else { using (DefaultConnectionEF conn = new DefaultConnectionEF()) { Recipe r = new Recipe(); Int32 RecipeID = Convert.ToInt32(Request.QueryString["recipe_id"]); r = (from rec in conn.Recipes where rec.recipe_id == RecipeID select rec).FirstOrDefault(); //fill the properties of our object from the form inputs r.recipe_name = txtRecipeName.Text; r.directions = txtRecipeDirections.Text; conn.SaveChanges(); lblIngredientMessage.Visible = false; Response.Redirect("/Admin/recipes.aspx"); } } } catch (Exception exception) { lblError.Text = exception.Message; } }
protected void grdIngredients_RowDeleting(object sender, GridViewDeleteEventArgs e) { //get the selected ingredient id Int32 IngredientID = Convert.ToInt32(grdIngredients.DataKeys[e.RowIndex].Values["ingredient_id"]); //get the recipe id Int32 RecipeID = Convert.ToInt32(Request.QueryString["recipe_id"]); try { using (DefaultConnectionEF conn = new DefaultConnectionEF()) { Measurement objM = (from mes in conn.Measurements where mes.recipe_id == RecipeID && mes.ingredient_id == IngredientID select mes).FirstOrDefault(); conn.Measurements.Remove(objM); conn.SaveChanges(); GetRecipe(); } } catch (Exception exc) { Response.Redirect("~/error.aspx"); } }
protected void grdRecipes_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { //connect using (DefaultConnectionEF conn = new DefaultConnectionEF()) { //get the selected recipe_id Int32 Recipe_id = Convert.ToInt32(grdRecipes.DataKeys[e.RowIndex].Values["recipe_id"]); var recipe = (from r in conn.Recipes where r.recipe_id == Recipe_id select r).FirstOrDefault(); var measure = (from mes in conn.Measurements where mes.recipe_id == Recipe_id select mes); //delete conn.Measurements.RemoveRange(measure); conn.Recipes.Remove(recipe); conn.SaveChanges(); //update the grid GetRecipes(); } } catch (Exception ex) { Response.Redirect("~/error.aspx"); } }