public OrderProduct AddNewOrderProduct(NewOrderProduct newOrderProduct)
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
var queryString = @"Insert into OrderProduct(ProductId, OrderId, Quantity)
Output inserted.*
Values(@ProductId, @OrderId, @Quantity)";
var product = connection.QueryFirstOrDefault <OrderProduct>(queryString, newOrderProduct);
if (product != null)
{
return(product);
}
}
throw new Exception("Can't add a new order product");
}
public ActionResult AddNewOrderProduct(NewOrderProduct newOrderProduct)
{
var product = _connections.AddNewOrderProduct(newOrderProduct);
return(Accepted(product));
}
