public IHttpActionResult Putingredients(string id, ingredients ingredients) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != ingredients.nom) { return(BadRequest()); } db.Entry(ingredients).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ingredientsExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult Postingredients(ingredients ingredients) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.ingredients.Add(ingredients); try { db.SaveChanges(); } catch (DbUpdateException) { if (ingredientsExists(ingredients.nom)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = ingredients.nom }, ingredients)); }
// GET api/<controller> public List <ingredients> Get() { ingredients ingredients = new ingredients(); List <ingredients> ingList = ingredients.Read(); return(ingList); }
private void addIngrBtn_Click(object sender, RoutedEventArgs e) { ingredients newItem = new ingredients() { name = IngrNameTextBox.Text }; _db.ingredients.Add(newItem); _db.SaveChanges(); this.Hide(); }
public IHttpActionResult Deleteingredients(string id) { ingredients ingredients = db.ingredients.Find(id); if (ingredients == null) { return(NotFound()); } db.ingredients.Remove(ingredients); db.SaveChanges(); return(Ok(ingredients)); }
//-------------------------------------------------------------------- // Build the Insert command String //-------------------------------------------------------------------- private String BuildInsertCommand(ingredients ingredients) { String command; StringBuilder sb = new StringBuilder(); // use a string builder to create the dynamic string sb.AppendFormat("Values('{0}', '{1}','{2}')", ingredients.Name, ingredients.Image, ingredients.Calories); String prefix = "INSERT INTO ingredients_G_2021 " + "( [name], [image],[calories]) "; command = prefix + sb.ToString(); return(command); }
public IHttpActionResult Getingredients(string id) { ingredients ingredients = db.ingredients.Find(id); ingredientViewModel ivm = new ingredientViewModel(); if (ingredients == null) { return(NotFound()); } else { ivm.nom = ingredients.nom; ivm.calories = ingredients.calories; ivm.label = ingredients.label; return(Ok(ivm)); } }
private void AddStorageItemBtn_Click(object sender, RoutedEventArgs e) { ingredients newItem = new ingredients() { name = StorageItemNameTextBox.Text }; _db.ingredients.Add(newItem); _db.SaveChanges(); storage_ingredient newItem2 = new storage_ingredient() { count = 0, ingredient_id = (from m in _db.ingredients select m.id).ToList().Last(), unit_of_measurement_id = unit_id }; _db.storage_ingredient.Add(newItem2); _db.SaveChanges(); this.Hide(); }
public List <ingredients> ReadIng() { SqlConnection con = null; List <ingredients> INGList = new List <ingredients>(); try { con = connect("DBConnectionString"); // create a connection to the database using the connection String defined in the web config file String selectSTR = "SELECT * FROM ingredients_G_2021"; SqlCommand cmd = new SqlCommand(selectSTR, con); // get a reader SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); // CommandBehavior.CloseConnection: the connection will be closed after reading has reached the end while (dr.Read()) { // Read till the end of the data into a row ingredients b = new ingredients(); b.Id = Convert.ToInt32(dr["id"]); b.Name = (string)dr["name"]; b.Image = (string)dr["image"]; b.Calories = Convert.ToDouble(dr["calories"]); INGList.Add(b); } return(INGList); } catch (Exception ex) { // write to log throw (ex); } finally { if (con != null) { con.Close(); } } }
//-------------------------------------------------------------------------------------------------- // This method inserts a student to the student table //-------------------------------------------------------------------------------------------------- public int Insert(ingredients ingredients) { SqlConnection con; SqlCommand cmd; try { con = connect("DBConnectionString"); // create the connection } catch (Exception ex) { // write to log throw (ex); } String cStr = BuildInsertCommand(ingredients); // helper method to build the insert string cmd = CreateCommand(cStr, con); // create the command try { int numEffected = cmd.ExecuteNonQuery(); // execute the command return(numEffected); } catch (Exception ex) { // write to log throw (ex); } finally { if (con != null) { // close the db connection con.Close(); } } }
// POST api/<controller> public void Post([FromBody] ingredients ing) { ing.Insert(); }