// GET: Salades/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var saladeViewModel = new SaladeViewModel
{
Salade = db.Salades.Include(i => i.Composants).First(i => i.ID == id)
};
if (saladeViewModel == null)
{
return(HttpNotFound());
}
var allComposant = db.Composants.ToList();
saladeViewModel.AllComposant = allComposant.Select(o => new SelectListItem {
Text = o.Nom, Value = o.ID.ToString()
});
Salade salade = db.Salades.Find(id);
if (salade == null)
{
return(HttpNotFound());
}
return(View(saladeViewModel));
}
public ActionResult DeleteConfirmed(int id)
{
Salade salade = db.Salades.Find(id);
db.Salades.Remove(salade);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "ID,Nom,Description")] Salade salade)
{
if (ModelState.IsValid)
{
db.Salades.Add(salade);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(salade));
}
public ActionResult Create([Bind(Include = "ID,Nom,Description,Fabricant_ID")] Salade salade)
{
if (ModelState.IsValid)
{
db.Salades.Add(salade);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Fabricant_ID = new SelectList(db.Fabricants, "ID", "Nom", salade.Fabricant.ID);
return(View(salade));
}
// GET: Salades/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Salade salade = db.Salades.Find(id);
if (salade == null)
{
return(HttpNotFound());
}
return(View(salade));
}
public List <Bestelling> GetBestellingen()
{
List <Bestelling> returnList = new List <Bestelling>();
using (SqlConnection connection = new SqlConnection(conn))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand("SELECT b.BestellingID, k.Adres, k.Naam, b.KlantID FROM Bestellingen b LEFT JOIN Klanten k ON b.KlantID = k.KlantID", connection))
{
cmd.Connection = connection;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (!reader.IsDBNull(2))
{
returnList.Add(new Bestelling()
{
ID = reader.GetInt32(0),
Klant = new Klant(reader.GetString(2), reader.GetString(1), reader.GetInt32(3))
});
}
else
{
returnList.Add(new Bestelling()
{
ID = reader.GetInt32(0)
});
}
}
}
}
}
foreach (Bestelling bestelling in returnList)
{
bestelling.Items = new List <Item>();
List <int> pizzaIDs = new List <int>();
List <int> saladeIDs = new List <int>();
List <int> drankenIDs = new List <int>();
using (SqlConnection connection = new SqlConnection(conn))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand("SELECT PizzaID FROM PizzaItems WHERE BestellingID = @bestellingID", connection))
{
cmd.Connection = connection;
cmd.Parameters.Add("@bestellingID", SqlDbType.Int).Value = bestelling.ID;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
pizzaIDs.Add(reader.GetInt32(0));
}
}
}
using (SqlCommand cmd = new SqlCommand("SELECT SaladeID FROM SaladeItems WHERE BestellingID = @bestellingID", connection))
{
cmd.Connection = connection;
cmd.Parameters.Add("@bestellingID", SqlDbType.Int).Value = bestelling.ID;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
saladeIDs.Add(reader.GetInt32(0));
}
}
}
using (SqlCommand cmd = new SqlCommand("SELECT DrankID FROM DrankItems WHERE BestellingID = @bestellingID", connection))
{
cmd.Connection = connection;
cmd.Parameters.Add("@bestellingID", SqlDbType.Int).Value = bestelling.ID;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
drankenIDs.Add(reader.GetInt32(0));
}
}
}
}
foreach (int id in pizzaIDs)
{
Pizza temp = itemRepo.GetPizzaByID(id);
if (temp != null)
{
bestelling.Items.Add(temp);
}
}
foreach (int id in saladeIDs)
{
Salade temp = itemRepo.GetSaladeByID(id);
if (temp != null)
{
bestelling.Items.Add(temp);
}
}
foreach (int id in drankenIDs)
{
Drank temp = itemRepo.GetDrankByID(id);
if (temp != null)
{
bestelling.Items.Add(temp);
}
}
}
return(returnList);
}
