public async Task <ActionResult> UpdateOrder(PurchaseOrderViewModel order)
{
var updateOrder = await db.PurchaseOrders.FindAsync(order.ID);
if (updateOrder == null)
{
return(HttpNotFound());
}
var Products = await db.PurchaseOrderProducts.Where(p => p.PurchaseOrderId == order.ID).ToListAsync();
db.PurchaseOrderProducts.RemoveRange(Products);
foreach (var p in order.Products)
{
PurchaseOrderProduct orderProduct = new PurchaseOrderProduct
{
PurchaseOrderId = int.Parse(order.ID.ToString()),
ProductId = p.ProductId,
Qty = p.Qty
};
db.PurchaseOrderProducts.Add(orderProduct);
await db.SaveChangesAsync();
}
return(Json(new { updateOrder.PurchaseOrderId, updateOrder.Date }));
}
public async Task <ActionResult> SaveOrder(PurchaseOrderViewModel order)
{
var newOrder = new PurchaseOrder
{
VendorID = order.VendorId,
Status = "Pending",
Date = DateTime.Now
};
db.PurchaseOrders.Add(newOrder);
await db.SaveChangesAsync();
foreach (var p in order.Products)
{
PurchaseOrderProduct orderProduct = new PurchaseOrderProduct
{
PurchaseOrderId = newOrder.PurchaseOrderId,
ProductId = p.ProductId,
Qty = p.Qty
};
db.PurchaseOrderProducts.Add(orderProduct);
await db.SaveChangesAsync();
}
return(Json(new { Id = newOrder.PurchaseOrderId, Date = newOrder.Date }));
}