public int CreateTokenTransaction(IDbConnection db, TokenTransaction tokenTran)
{
string sql = @"INSERT INTO token_transaction(
customer_username, partner_identifier, gtoken_transaction_id,
partner_order_id, token_type, transaction_type, amount, description,
ip_address, country_code, created_at, updated_at, tax, service_charge)
VALUES (
@customer_username, @partner_identifier, @gtoken_transaction_id,
@partner_order_id, @token_type, @transaction_type, @amount, @description,
@ip_address, @country_code, @created_at, @updated_at, @tax, @service_charge)
RETURNING id";
return db.Query<int>(sql, tokenTran).FirstOrDefault();
}
public bool deductGToken(string username, TokenTransaction transaction, string campTitle)
{
string remark = string.Format("Deduct GToken for transaction: {0} {1}, originator: {2}", transaction.gtoken_transaction_id, campTitle, transaction.customer_username);
decimal amount = transaction.amount;
var venvici = new VenviciModel()
{
enumAction = VenviciAction.deductGToken,
username = username,
amount = amount,
refNo = transaction.gtoken_transaction_id,
remark = remark
};
var result = SendAPIRequest(venvici);
bool suscess = result.Contains(Helper.GetDescription(VenviciReult.success));
Api.Instance.LogApi("1", "web/deductGToken.jsp", suscess, HttpContext.Current.Request.UserAgent,
"venvici", transaction.customer_username, HttpContext.Current.Request.UserHostAddress, string.Empty,
JsonConvert.SerializeObject(venvici) + " ---- Result: " + result);
if (suscess)
recordTransaction(username, transaction.gtoken_transaction_id, remark, gtokenAmount: amount);
return suscess;
}
public bool UpdateCashBack(string username, TokenTransaction transaction, string campTitle)
{
if (!deductGToken(username, transaction, campTitle))
return false;
return commissionCredit(username, transaction, campTitle);
}
public bool PushBv(string username, TokenTransaction transaction)
{
decimal pushbv = transaction.amount;
var venvici = new VenviciModel()
{
enumAction = VenviciAction.PushBV,
username = username,
bv = pushbv
};
var result = SendAPIRequest(venvici);
bool suscess = result.Contains(Helper.GetDescription(VenviciReult.success));
Api.Instance.LogApi("1", "web/pushBv.jsp", suscess, HttpContext.Current.Request.UserAgent,
"venvici", transaction.customer_username, HttpContext.Current.Request.UserHostAddress, string.Empty, JsonConvert.SerializeObject(venvici) + " ---- Result: " + result);
if (suscess)
{
string remark = string.Format("BV for transaction: {0}, originator: {1}", transaction.gtoken_transaction_id, transaction.customer_username);
recordTransaction(username, transaction.gtoken_transaction_id, remark, pushBv: pushbv);
}
return suscess;
}