private void GetRecipes() { COMP229S17S2Entities dbconnection = new COMP229S17S2Entities(); var recipes = (from allRecipes in dbconnection.recipes select allRecipes); RecipesGridView.DataSource = recipes.ToList(); RecipesGridView.DataBind(); }
public int getIngredientIDByName(string Name) { try { COMP229S17S2Entities dbConnection = new COMP229S17S2Entities(); List <int> item = (from x in dbConnection.ingredients where x.Name == Name select x.ID).ToList(); return(item[0]); } catch (Exception e) { return(-1); } }
public string getIngredientByID(int ID) { try { COMP229S17S2Entities dbConnection = new COMP229S17S2Entities(); List <string> item = (from x in dbConnection.ingredients where x.ID == ID select x.Name).ToList(); return(item[0]); } catch (Exception e) { return(""); } }
public int GetRecipeIDByName(string name) { try { COMP229S17S2Entities dbConnection = new COMP229S17S2Entities(); List <int> ID = (from x in dbConnection.recipes where x.Name == name select x.ID).ToList(); return(ID[0]); } catch (Exception e) { return(-1); } }
// write a method that takes an ingredient and returns a collection // of recipes that use that ingredient public List <recipeingredient> getIngredientDetailByRecipeID(int RecipeNumber) { try { COMP229S17S2Entities dbConnection = new COMP229S17S2Entities(); List <recipeingredient> ID = (from x in dbConnection.recipeingredients where x.Recipe == RecipeNumber select x).ToList(); return(ID); } catch (Exception e) { return(new List <recipeingredient>()); } }
public int CheckIngredient(int recipeID, int ingredientID) { try { COMP229S17S2Entities dbConnection = new COMP229S17S2Entities(); List <int> ID = (from x in dbConnection.recipeingredients where x.Ingredient == ingredientID & x.Recipe == recipeID select x.ID).ToList(); return(ID[0]); } catch (Exception e) { return(-1); } }
public string getIngredientByName(string name) { try { COMP229S17S2Entities dbConnection = new COMP229S17S2Entities(); //instead of an sql query we are building a LINQ query List <string> nameOfIngre = (from x in dbConnection.recipes where x.Name == name select x.Name).ToList(); return(nameOfIngre[0]); } catch (Exception e) { return(""); } }
public recipe GetRecipeByRecipeID(int ID) { try { COMP229S17S2Entities dbConnection = new COMP229S17S2Entities(); //instead of an sql query we are building a LINQ query List <recipe> result = (from x in dbConnection.recipes where x.ID == ID select x).ToList(); return(result[0]); } catch (Exception e) { return(new recipe()); } }
public List <recipe> GetRecipeByRecipeName(string name) { try { COMP229S17S2Entities dbConnection = new COMP229S17S2Entities(); //instead of an sql query we are building a LINQ query List <recipe> result = (from x in dbConnection.recipes where x.Name == name select x).ToList(); return(result); } catch (Exception e) { return(new List <recipe>()); } }
public string InsertRecipeIngredient(recipeingredient item) { try { COMP229S17S2Entities dbConnection = new COMP229S17S2Entities(); dbConnection.recipeingredients.Add(item); Console.WriteLine("<p>" + item.ToString() + "</p>"); dbConnection.SaveChanges(); return("Item " + item.Recipe + " was saved."); } catch (Exception ex) { return(ex.ToString()); } }
public string InsertIngredient(ingredient item) { try { //Create database connection COMP229S17S2Entities dbConnection = new COMP229S17S2Entities(); //Add item of ingredients to database dbConnection.ingredients.Add(item); dbConnection.SaveChanges(); return("Item " + item.Name + " was saved"); } catch (Exception e) { return(e.ToString()); } }
public List <int> GetRecipeIDByIngredient(string name) { int ingridientID = GetIngredientIdByName(name); try { COMP229S17S2Entities dbConnection = new COMP229S17S2Entities(); //instead of an sql query we are building a LINQ query List <int> result = (from x in dbConnection.recipeingredients where x.Ingredient == ingridientID select x.Recipe).ToList(); return(result); } catch (Exception e) { return(new List <int>()); } }
protected void btnDelete_Click(object sender, EventArgs e) { if (Request.Cookies["RecipeID"] != null) { int RecipeID = Convert.ToInt32(Server.HtmlEncode(Request.Cookies["RecipeID"].Value)); using (COMP229S17S2Entities dbConnection = new COMP229S17S2Entities()) { /* * recipe deletedRecipe = (from recipeRecords in dbConnection.recipes * where recipeRecords.ID == RecipeID * select recipeRecords).FirstOrDefault(); * * dbConnection.recipes.Remove(deletedRecipe); * dbConnection.SaveChanges(); * Response.Redirect("~/pages/Recipes.aspx"); */ RecipeIngredientModel a = new RecipeIngredientModel(); List <int> b = a.getReInIDbyRecipe(RecipeID); for (int i = 0; i < b.Count; i++) { int c = b[i]; recipeingredient combine = (from mix in dbConnection.recipeingredients where mix.ID == c select mix).FirstOrDefault(); dbConnection.recipeingredients.Remove(combine); dbConnection.SaveChanges(); } recipe deletedRecipe = (from recipeRecords in dbConnection.recipes where recipeRecords.ID == RecipeID select recipeRecords).FirstOrDefault(); dbConnection.recipes.Remove(deletedRecipe); dbConnection.SaveChanges(); Response.Redirect("Recipes.aspx"); } } }
List <recipe> GetRecipesSubmittedBy_Category_Ingredient(string submittedby, string category, string ingredient) { IngredientModel inModel = new IngredientModel(); RecipeIngredientModel reInModel = new RecipeIngredientModel(); RecipeModel reModel = new RecipeModel(); using (COMP229S17S2Entities dbConnection = new COMP229S17S2Entities()) { if (submittedby == "All") { if (category == "All") { if (ingredient == "All") { try { List <recipe> result = (from x in dbConnection.recipes select x).ToList(); return(result); } catch (Exception ex) { return(new List <recipe>()); } } else { try { List <int> RecipeID = reInModel.GetRecipeIDByIngredient(ingredient); List <recipe> result = new List <recipe>(); for (int i = 0; i < RecipeID.Count; i++) { int b = RecipeID[i]; List <recipe> a = (from x in dbConnection.recipes where x.ID == b select x).ToList(); result.Add(a[0]); } return(result); } catch (Exception ex) { return(new List <recipe>()); } } } else { if (ingredient == "All") { try { List <recipe> result = (from x in dbConnection.recipes where x.Category == category select x).ToList(); return(result); } catch (Exception ex) { return(new List <recipe>()); } } else { try { List <int> RecipeID = reInModel.GetRecipeIDByIngredient(ingredient); List <recipe> result = new List <recipe>(); for (int i = 0; i < RecipeID.Count; i++) { int b = RecipeID[i]; List <recipe> a = (from x in dbConnection.recipes where x.ID == b select x).ToList(); foreach (recipe x in a) { if (x.Category == category) { result.Add(a[0]); } } } return(result); } catch (Exception ex) { return(new List <recipe>()); } } } } else { if (category == "All") { if (ingredient == "All") { try { List <recipe> result = (from x in dbConnection.recipes where x.SubmittedBy == submittedby select x).ToList(); return(result); } catch (Exception ex) { return(new List <recipe>()); } } else { try { List <int> RecipeID = reInModel.GetRecipeIDByIngredient(ingredient); List <recipe> result = new List <recipe>(); for (int i = 0; i < RecipeID.Count; i++) { int b = RecipeID[i]; List <recipe> a = (from x in dbConnection.recipes where x.ID == b select x).ToList(); foreach (recipe x in a) { if (x.SubmittedBy == submittedby) { result.Add(a[0]); } } } return(result); } catch (Exception ex) { return(new List <recipe>()); } } } else { if (ingredient == "All") { try { List <recipe> result = (from x in dbConnection.recipes where x.Category == category && x.SubmittedBy == submittedby select x).ToList(); return(result); } catch (Exception ex) { return(new List <recipe>()); } } else { try { List <int> RecipeID = reInModel.GetRecipeIDByIngredient(ingredient); List <recipe> result = new List <recipe>(); for (int i = 0; i < RecipeID.Count; i++) { int b = RecipeID[i]; List <recipe> a = (from x in dbConnection.recipes where x.ID == b select x).ToList(); foreach (recipe x in a) { if (x.SubmittedBy == submittedby && x.Category == category) { result.Add(a[0]); } } } return(result); } catch (Exception ex) { return(new List <recipe>()); } } } } } }
protected void btnSave_Click(object sender, EventArgs e) { int RecipeID = Convert.ToInt32(Server.HtmlEncode(Request.Cookies["RecipeID"].Value)); if (txtCategory.Visible == false) { string query = "UPDATE Recipe SET Name='" + txtName.Text + "',Category='" + DropDownList1.SelectedValue.ToString() + "',Description='" + txtDescription.Text + "',PrepTime=" + Convert.ToInt32(txtTime.Text) + ",Servings = " + Convert.ToInt32(this.txtNumOfServing.Text) + " WHERE ID =" + RecipeID + ";"; using (SqlConnection db = new SqlConnection("Data Source=DESKTOP-FOJ2HKK;Initial Catalog=COMP229S17S2;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework")) { SqlCommand command = new SqlCommand(query, db); db.Open(); SqlDataReader reader = command.ExecuteReader(); } } else { string query = "UPDATE Recipe SET Name='" + txtName.Text + "',Category='" + txtCategory.Text + "',Description='" + txtDescription.Text + "',PrepTime=" + Convert.ToInt32(txtTime.Text) + ",Servings = " + Convert.ToInt32(this.txtNumOfServing.Text) + " WHERE ID =" + RecipeID + ";"; using (SqlConnection db = new SqlConnection("Data Source=DESKTOP-FOJ2HKK;Initial Catalog=COMP229S17S2;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework")) { SqlCommand command = new SqlCommand(query, db); db.Open(); SqlDataReader reader = command.ExecuteReader(); } } using (COMP229S17S2Entities db = new COMP229S17S2Entities()) { List <ListOfIngredients> ingredientList = new List <ListOfIngredients>(); foreach (GridViewRow row in grd.Rows) { TextBox ingNameTB = (TextBox)row.FindControl("txtIngredient"); string ingName = ingNameTB.Text; TextBox unitTB = (TextBox)row.FindControl("txtUnit"); string ingUnit = unitTB.Text; TextBox quantityTB = (TextBox)row.FindControl("txtQuantity"); int ingQuantity = Convert.ToInt32(quantityTB.Text); ingredientList.Add(new ListOfIngredients(ingName, ingQuantity, ingUnit)); } db.SaveChanges(); foreach (ListOfIngredients item in ingredientList) { recipeingredient newRepIng = new recipeingredient(); IngredientModel ingModel = new IngredientModel(); RecipeIngredientModel ReInModel = new RecipeIngredientModel(); RecipeModel recipeModel = new RecipeModel(); ingredient newIngredient = new ingredient(); if (ReInModel.CheckIngredient(RecipeID, ingModel.getIngredientIDByName(item.Name)) < 0) { if (ingModel.getIngredientIDByName(item.Name) < 0) { newIngredient.Name = item.Name; ingModel.InsertIngredient(newIngredient); } newRepIng.Ingredient = ingModel.getIngredientIDByName(item.Name); newRepIng.Recipe = RecipeID; newRepIng.Quantity = item.Quantity; newRepIng.UM = item.Unit; ReInModel.InsertRecipeIngredient(newRepIng); } else { string query1 = "UPDATE recipeingredients SET UM='" + item.Unit + "',Quantity=" + item.Quantity + "WHERE Recipe = " + RecipeID + "AND Ingredient = " + ingModel.getIngredientIDByName(item.Name) + ";"; using (SqlConnection db1 = new SqlConnection("Data Source=DESKTOP-FOJ2HKK;Initial Catalog=COMP229S17S2;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework")) { SqlCommand command = new SqlCommand(query1, db1); db1.Open(); SqlDataReader reader = command.ExecuteReader(); } } } List <recipeingredient> freshest = (from recipeIngItems in db.recipeingredients where recipeIngItems.Recipe == RecipeID select recipeIngItems).ToList(); List <int> recipeIngIdsToDelete = new List <int>(); try { for (int i = 0; i < ingredientList.Count; i++) { freshest[i].Quantity = ingredientList[i].Quantity; freshest[i].UM = ingredientList[i].Unit; if (freshest[i].Quantity == 0) { //recipeIngIdsToDelete.Add(freshest[i].id); db.recipeingredients.Remove(freshest[i]); } } } catch (Exception ed) { } db.SaveChanges(); //Redirect bact to the updated recipes page Response.Redirect("Recipes.aspx"); } Label1.Text = TextBox1.Text; }