public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Bio,Vegetarisch,Vegan,Glutenfrei")] Zutaten zutaten) { if (id != zutaten.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(zutaten); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ZutatenExists(zutaten.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(zutaten)); }
// GET: Zutaten public ActionResult Index() { List <Zutaten> ZutatenListe = new List <Zutaten>(); Zutaten Zutaten = new Zutaten(); ZutatenListe = Zutaten.GetAll(); //ViewBag.Message = ; return(View(ZutatenListe)); }
public async Task <IActionResult> Create([Bind("Id,Name,Bio,Vegetarisch,Vegan,Glutenfrei")] Zutaten zutaten) { if (ModelState.IsValid) { _context.Add(zutaten); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(zutaten)); }
// GET: Zutaten public ActionResult Index() { string constr = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString; Zutaten zutaten = new Zutaten() { list = new List <Zutat>() }; using (MySqlConnection con = new MySqlConnection(constr)) { try { con.Open(); string query = "SELECT * FROM Zutaten ORDER BY Bio DESC, Name ASC"; using (MySqlCommand cmd = new MySqlCommand(query, con)) { using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { zutaten.list.Add(new Zutat() { ID = Convert.ToInt32(reader["ID"]), Name = reader["Name"].ToString(), Bio = Convert.ToBoolean(reader["Bio"]), Vegetarisch = Convert.ToBoolean(reader["Vegetarisch"]), Vegan = Convert.ToBoolean(reader["Vegan"]), Glutenfrei = Convert.ToBoolean(reader["Glutenfrei"]) }); } } } con.Close(); } catch (Exception e) { con.Close(); ModelState.AddModelError("Error", e.Message); return(View(zutaten)); } } return(View(zutaten)); }