public async Task <IActionResult> RemoveProductFromOrder(Orderline9802 order)
{
SqlParameter p1 = new SqlParameter("@PORDERID", order.Orderid);
SqlParameter p2 = new SqlParameter("@PPRODIID", order.Productid);
var sql = "EXEC REMOVE_PRODUCT_FROM_ORDER @PORDERID, @PPRODIID";
await _context.Database.ExecuteSqlRawAsync(sql, p1, p2);
return(Ok());
}
public async Task <IActionResult> AddProductToOrder(Orderline9802 order)
{
SqlParameter p1 = new SqlParameter("@PORDERID", order.Orderid);
SqlParameter p2 = new SqlParameter("@PPRODID", order.Productid);
SqlParameter p3 = new SqlParameter("@PQTY", order.Quantity);
SqlParameter p4 = new SqlParameter("@DISCOUNT", order.Discount);
var sql = "EXEC ADD_PRODUCT_TO_ORDER @PORDERID, @PPRODID, @PQTY, @DISCOUNT";
await _context.Database.ExecuteSqlRawAsync(sql, p1, p2, p3, p4);
return(Accepted());
}
