void create_transaction(int OrderId, CoachOrder order, MySqlConnection connection) { using (var cmd = connection.CreateCommand()) { decimal final_price = PriceCalculator.CalculateCutFromTotalPriceWithFee(PriceCalculator.PayType.PayPal, order.mc_gross); cmd.CommandText = "INSERT INTO esc_Transactions (Amount, Status, Date, ReceiverId, senderId, OrderId) VALUES (@amount, @status, @date, @boosterid, @buyerid, @order_id)"; cmd.Parameters.AddWithValue("@amount", final_price); cmd.Parameters.AddWithValue("@status", payment_status.Pending.ToString()); cmd.Parameters.AddWithValue("@date", DateTime.UtcNow); cmd.Parameters.AddWithValue("@boosterid", order.receiver_id); cmd.Parameters.AddWithValue("@buyerid", order.payer_account_id); cmd.Parameters.AddWithValue("@order_id", OrderId); cmd.ExecuteNonQuery(); } }