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