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