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));
}
