public ActionResult AddProductToOrder(int? orderId, int? productId)
{
// find op order en product
var orderItem = db.OrderDetails.SingleOrDefault(o => o.OrderId == orderId && o.ProductId == productId);
Product prod = db.Products.Find(productId);
// nieuwe quotation detail
if (orderItem == null)
{
orderItem = new OrderDetail
{
ProductId = (int)productId,
OrderId = (int)orderId,
Quantity = 1,
Auvibel = prod.Auvibel,
Bebat = prod.Bebat,
CategoryId = prod.CategoryId,
Brand = prod.Brand,
Description = prod.Description,
PriceExVAT = prod.PriceExVAT,
ProductCode = prod.ProductCode,
ProductName = prod.ProductName,
Recupel = prod.Recupel,
Reprobel = prod.Reprobel,
VATPercId = prod.VATPercId,
};
orderItem.VAT = db.VATs.Find(orderItem.VATPercId);
db.OrderDetails.Add(orderItem);
}
else
{
orderItem.Quantity++;
}
orderItem.TotalExVat = (orderItem.PriceExVAT + orderItem.Auvibel + orderItem.Bebat + orderItem.Recupel + orderItem.Reprobel) * orderItem.Quantity;
//Berekent totaal per lijn van producten inc BTW
orderItem.TotalIncVat = orderItem.TotalExVat * (1 + (orderItem.VAT.VATValue / 100));
CalculateTotalPriceinc(orderId);
db.SaveChanges();
return RedirectToAction("AddProducts", new { id = orderId });
}
public ActionResult CreateOrder(int? Id)
{
Order order = new Order();
Quotation quot = new Quotation();
quot = db.Quotations.Find(Id);
order.Annotation = quot.Annotation + " - Order van Offerte " + quot.QuotationNumber;
order.Box = quot.Box;
order.CellPhone = quot.CellPhone;
order.CustomerId = quot.CustomerId;
order.Date = quot.Date;
order.Email = quot.Email;
order.FirstName = quot.FirstName;
order.LastName = quot.LastName;
order.PostalCodeNumber = quot.PostalCodeNumber;
order.StreetName = quot.StreetName;
order.StreetNumber = quot.StreetNumber;
order.TotalPrice = quot.TotalPrice;
order.Town = quot.Town;
order.Active = true;
quot.Active = false;
db.Orders.Add(order);
db.SaveChanges();
order.customerDeliveryAddress = quot.customerDeliveryAddress;
//find highest order number
int maxOrderNumber = 1;
order.OrderNumber = maxOrderNumber;
var listOrders = db.Orders.ToList();
if (listOrders.Count > 1)
{
maxOrderNumber = listOrders.Max(o => o.OrderNumber);
order.OrderNumber = maxOrderNumber + 1;
}
foreach (var item in quot.QuotationDetail)
{
var od = new OrderDetail();
od.OrderId = order.OrderId;
od.Quantity = item.Quantity;
od.PriceExVAT = item.PriceExVAT;
od.TotalExVat = item.TotalExVat;
od.TotalIncVat = item.TotalIncVat;
od.Auvibel = item.Auvibel;
od.Bebat = item.Bebat;
od.Brand = item.Brand;
od.CategoryId = item.CategoryId;
od.Description = item.Description;
od.ProductCode = item.ProductCode;
od.ProductName = item.ProductName;
od.Recupel = item.Recupel;
od.Reprobel = item.Reprobel;
od.VATPercId = item.VATPercId;
od.ProductId = item.ProductId;
od.VAT = item.VAT;
db.OrderDetails.Add(od);
}
db.SaveChanges();
return RedirectToAction("Index", "Orders");
}