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()); }