public async Task <IActionResult> RemoveProductFromOrder(Orderline3778 orderline)
{
var param1 = new SqlParameter("@PORDERID", orderline.Orderid);
var param2 = new SqlParameter("@PPRODIID", orderline.Productid);
var sql = "EXEC REMOVE_PRODUCT_FROM_ORDER @PORDERID, @PPRODIID";
await _context.Database.ExecuteSqlRawAsync(sql, param1, param2);
return(Ok());
}
public async Task <IActionResult> AddProductToOrder(Orderline3778 orderline)
{
var param1 = new SqlParameter("@PORDERID", orderline.Orderid);
var param2 = new SqlParameter("@PPRODIID", orderline.Productid);
var param3 = new SqlParameter("@PQTY", orderline.Quantity);
var param4 = new SqlParameter("@DISCOUNT", orderline.Discount);
var sql = "EXEC ADD_PRODUCT_TO_ORDER @PORDERID, @PPRODIID, @PQTY, @DISCOUNT";
await _context.Database.ExecuteSqlRawAsync(sql, param1, param2, param3, param4);
return(Ok());
}
