コード例 #1
0
 public int CreateVenviciTransaction(IDbConnection db, VenviciTransaction venTrans)
 {
     string sql = @"INSERT INTO venvici_transaction(
                     transaction_id, customer_username, gtoken_deduct_amount, 
                 commission_credit_amount, pushbv_amount, gtoken_add_amount, remark)
                 VALUES (@transaction_id, @customer_username, @gtoken_deduct_amount, 
                 @commission_credit_amount, @pushbv_amount,@gtoken_add_amount, @remark)
                 RETURNING id;";
     return db.Query<int>(sql, venTrans).FirstOrDefault();
 }
コード例 #2
0
ファイル: VenviciAPI.cs プロジェクト: vietplayfuri/Asp_Master
 public int recordTransaction(string username, string gtoken_transaction_id, string remark, decimal gtokenAmount = 0, decimal commissionCredit = 0, decimal pushBv = 0, decimal gtoken_add_amount = 0)
 {
     var venviciTrans = new VenviciTransaction()
     {
         transaction_id = gtoken_transaction_id,
         customer_username = username,
         gtoken_deduct_amount = gtokenAmount,
         commission_credit_amount = commissionCredit,
         pushbv_amount = pushBv,
         gtoken_add_amount = gtoken_add_amount,
         remark = remark
     };
     var repo = Repo.Instance;
     using (var db = repo.OpenConnectionFromPool())
     {
         return repo.CreateVenviciTransaction(db, venviciTrans);
     }
 }