public ActionResult Overzicht(OrderViewModel ovm)
{
Klant klant = db.Klanten.Add(ovm.Klant);
db.SaveChanges();
Order order = new Order();
order.Klant = klant;
order.OrderRegels = new List <OrderRegel>();
db.Orders.Add(order);
db.SaveChanges();
foreach (var kvp in (Dictionary <int, int>)Session["Cart"])
{
Product product = db.Producten.Find(kvp.Key);
int amount = kvp.Value;
OrderRegel orderRegel = new OrderRegel();
orderRegel.Order = order;
orderRegel.Product = product;
orderRegel.Aantal = amount;
order.OrderRegels.Add(orderRegel);
}
db.SaveChanges();
return(RedirectToAction("Success"));
}
public List <OrderViewModel> GetProductenPerOrder(int oid)
{
List <OrderViewModel> orders = new List <OrderViewModel>();
try
{
conn.Open();
string select = @"select * from tbl_orderregel orr join tbl_product p on orr.product_id = p.product_id join tbl_order o on orr.order_id = o.order_id where o.order_id = @id";
MySqlCommand cmd = new MySqlCommand(select, conn);
MySqlParameter idParam = new MySqlParameter("@id", MySqlDbType.Int32);
idParam.Value = oid;
cmd.Parameters.Add(idParam);
MySqlDataReader datareader = cmd.ExecuteReader();
while (datareader.Read())
{
Product productnaam = new Product();
int id = datareader.GetInt16("order_id");
double totaal = datareader.GetDouble("totaal");
int gebruiker = datareader.GetInt16("gebruiker_id");
Order order = new Order {
ID = id, Totaal = totaal, StrStatus = "..", aantalProducten = 0, Gebruiker = gebruiker
};
int productID = datareader.GetInt16("Product_ID");
int aantal = datareader.GetInt16("Aantal");
double subtotaal = datareader.GetDouble("Subtotaal");
productnaam = productdbcontroller.GetProduct(productID);
OrderRegel orderregel = new OrderRegel {
ProductID = productID, OrderID = oid, ProductNaam = productnaam.Naam, Aantal = aantal, Subtotaal = subtotaal
};
OrderViewModel orderview = new OrderViewModel {
Order = order, Orderregel = orderregel
};
orders.Add(orderview);
}
return(orders);
}
catch (Exception e)
{
return(null);
}
finally
{
conn.Close();
}
}
public IActionResult AddProduct(int aantal, int productId)
{
int orderId = GetSessionOrderId();
Order order = orderContainer.GetByID(orderId);
Product product = productContainer.GetByID(productId);
OrderRegel orderRegel = new OrderRegel(aantal, product);
order.EditOrderRegel(orderRegel);
ProductViewModel productView = ProductMapper.ProductViewModel(product);
return(RedirectToAction("Product", "Products", productView));
}
public List <OrderRegel> GetAllOrderRegels(int oid)
{
List <OrderRegel> orderregellist = new List <OrderRegel>();
try
{
conn.Open();
string select = @"SELECT * FROM tbl_orderregel WHERE Order_ID='" + oid + "'";
MySqlCommand cmd = new MySqlCommand(select, conn);
MySqlDataReader datareader = cmd.ExecuteReader();
while (datareader.Read())
{
Product productnaam = new Product();
int productID = datareader.GetInt16("Product_ID");
int aantal = datareader.GetInt16("Aantal");
double totaal = datareader.GetDouble("Subtotaal");
productnaam = productdbcontroller.GetProduct(productID);
OrderRegel orderregel = new OrderRegel {
ProductID = productID, OrderID = oid, ProductNaam = productnaam.Naam, Aantal = aantal, Subtotaal = totaal
};
orderregellist.Add(orderregel);
}
return(orderregellist);
}
catch (Exception e)
{
Console.WriteLine("ProductDBController GetAllProducten() " + e);
return(null);
}
finally
{
conn.Close();
}
}
