public void Create(OrderDetails model, IDbConnection connection, IDbTransaction transaction)
{
connection.Execute("INSERT INTO OrderDetails VALUES (@OrderID, @ProductFormatID, @Quantity, @UnitPrice) ",
new
{
model.OrderID,
model.ProductFormatID,
model.Quantity,
model.UnitPrice
}, transaction);
var request = new ProductFormatRepository();
var product = request.FindById(model.ProductFormatID, connection);
if ((product.StockQuantity - model.Quantity) >= 0)
{
connection.Execute("UPDATE ProductFormat SET StockQuantity = StockQuantity - @Quantity WHERE ProductFormatID = @ProductFormatID ",
new
{
model.Quantity,
model.ProductFormatID
}, transaction);
}
else
{
throw (new Exception("No Quantity"));
}
}
public void Create(OrderDetails model)
{
SqlConnection connection = new SqlConnection(
"data source=.; database=Commerce; integrated security=true");
var sql = "INSERT INTO OrderDetails VALUES (@OrderID, @ProductFormatID, @Quantity, @UnitPrice) ";
var request = new ProductFormatRepository();
var product = request.FindById(model.ProductFormatID);
if ((product.StockQuantity - model.Quantity) >= 0)
{
sql = sql + "UPDATE ProductFormat SET StockQuantity = StockQuantity - @Quantity WHERE ProductFormatID = @ProductFormatID";
SqlCommand command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("@OrderID", model.OrderID);
command.Parameters.AddWithValue("@ProductFormatID", model.ProductFormatID);
command.Parameters.AddWithValue("@Quantity", model.Quantity);
command.Parameters.AddWithValue("@UnitPrice", model.UnitPrice);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
else
{
}
}
public void Create(OrderDetails model) //新增
{
SqlConnection connection = new SqlConnection(
SqlConnectionString.ConnectionString());
var sql = "INSERT INTO OrderDetails VALUES (@OrderID, @ProductFormatID, @Quantity, @UnitPrice) ";
var request = new ProductFormatRepository();
var product = request.FindById(model.ProductFormatID);
sql = sql + "UPDATE ProductFormat SET StockQuantity = StockQuantity - @Quantity WHERE ProductFormatID = @ProductFormatID";
SqlCommand command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("@OrderID", model.OrderID);
command.Parameters.AddWithValue("@ProductFormatID", model.ProductFormatID);
command.Parameters.AddWithValue("@Quantity", model.Quantity);
command.Parameters.AddWithValue("@UnitPrice", model.UnitPrice);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
