public void Update(GatewayOrder model)
{
using (var con = WriteConnection())
{
con.Execute("UPDATE GatewayOrders SET Status=@Status WHERE Id=@Id", new { Status = model.Status, Id = model.Id });
}
}
public void Insert(GatewayOrder order)
{
const string sql =
@"INSERT INTO [dbo].[GatewayOrders]([Id],[OrderNo],[TradeNo],[MerchantAccountId],[MerchantName],[UserAccountId],[CryptoId],[CryptoAmount],[ActualCryptoAmount],[ActualFiatAmount],[FiatAmount],[FiatCurrency],[Status],[Timestamp],[Remark],[ExchangeRate],[Markup],[ExpiredTime],[TransactionFee],[PaymentTime])
VALUES (@Id,@OrderNo,@TradeNo,@MerchantAccountId,@MerchantName,@UserAccountId,@CryptoId,@CryptoAmount,@ActualCryptoAmount,@ActualFiatAmount,@FiatAmount,@FiatCurrency,@Status,@Timestamp,@Remark,@ExchangeRate,@Markup,@ExpiredTime,@TransactionFee,@PaymentTime)";
using (var con = WriteConnection())
{
con.Execute(sql, order);
}
}
//private readonly Dictionary<string, int> _notificationErrorCount = new Dictionary<string, int>();
public void Payment(string message)
{
var orderModel = JsonConvert.DeserializeObject <MallPaymentOrder>(message);
var userWalletDac = new UserWalletDAC();
var walletStatementDac = new UserWalletStatementDAC();
var gatewayOrderDac = new GatewayOrderDAC();
var mallDac = new MallPaymentOrderDAC();
var cryptoDac = new CryptocurrencyDAC();
var extsis = gatewayOrderDac.GetByOrderNo(orderModel.OrderId);
if (extsis != null && extsis.Status == GatewayOrderStatus.Completed)
{
_log.Info("Order message " + message + " hased Payment.");
return;
}
var cryptoFiii = cryptoDac.GetByCode("FIII");
var fiiiWallet = userWalletDac.GetByAccountId(orderModel.UserAccountId, cryptoFiii.Id);
if (fiiiWallet.Balance < orderModel.CryptoAmount)
{
_log.ErrorFormat("message {0}, Insufficient balance", message);
}
try
{
var fiiiPrice = GetMarketPrice("USD", "FIII");
var fiiiFiatAmount = Math.Round(orderModel.CryptoAmount * fiiiPrice, 2);
var trdeNo = NumberGenerator.GenerateUnixOrderNo();
var id = Guid.NewGuid();
using (var scope = new TransactionScope())
{
userWalletDac.Decrease(fiiiWallet.Id, orderModel.CryptoAmount);
walletStatementDac.Insert(new UserWalletStatement
{
WalletId = fiiiWallet.Id,
Action = UserWalletStatementAction.Consume,
Amount = -orderModel.CryptoAmount,
Balance = fiiiWallet.Balance - orderModel.CryptoAmount,
FrozenAmount = 0,
FrozenBalance = fiiiWallet.FrozenBalance,
Timestamp = DateTime.UtcNow
});
var gatewayFiiiOrder = new GatewayOrder
{
Id = id,
OrderNo = orderModel.OrderId,
MerchantAccountId = Guid.Empty,
MerchantName = "FiiiShop",
CryptoId = cryptoFiii.Id,
CryptoCode = "FIII",
FiatAmount = fiiiFiatAmount,
FiatCurrency = "USD",
Status = GatewayOrderStatus.Completed,
ExpiredTime = DateTime.UtcNow.AddMinutes(30),
Markup = 0M,
ExchangeRate = fiiiPrice,
PaymentTime = DateTime.UtcNow,
Timestamp = DateTime.UtcNow,
UserAccountId = orderModel.UserAccountId,
ActualCryptoAmount = orderModel.CryptoAmount,
ActualFiatAmount = fiiiFiatAmount,
CryptoAmount = orderModel.CryptoAmount,
TransactionFee = 0,
Remark = null,
TradeNo = trdeNo
};
gatewayOrderDac.Insert(gatewayFiiiOrder);
mallDac.UpdateStatus(orderModel.Id, (byte)OrderStatus.Completed);
mallDac.UpdateTradeNo(orderModel.Id, trdeNo);
scope.Complete();
}
RabbitMQSender.SendMessage("ShopPayment", id);
SendNotificationMessage(TradeType.Payment, orderModel.Id, orderModel.OrderId, trdeNo, "success");
}
catch (Exception exception)
{
//SendNotificationMessage(TradeType.Payment, orderModel.Id, orderModel.OrderId, string.Empty, "error");
_log.Error("Payment error, exception : " + exception.Message);
}
}
public GatewayOrderInfoOM PrePay(string code, UserAccount account)
{
var codeEntity = QRCode.Deserialize(code);
if (codeEntity.SystemPlatform != SystemPlatform.Gateway || codeEntity.QrCodeEnum != QRCodeEnum.GateWayPay)
{
throw new CommonException(ReasonCode.INVALID_QRCODE, MessageResources.InvalidQRCode);
}
var orderDetail = GetGatewayOrderDetail(codeEntity.QRCodeKey);
if (orderDetail == null)
{
throw new CommonException(ReasonCode.INVALID_QRCODE, MessageResources.InvalidQRCode);
}
var cryptoCurrency = new CryptocurrencyDAC().GetByCode(orderDetail.Crypto);
if (cryptoCurrency == null || cryptoCurrency?.Id == null)
{
throw new CommonException(ReasonCode.CRYPTO_NOT_EXISTS, "Error: Invalid Cryptocurrency");
}
var goDAC = new GatewayOrderDAC();
var gatewayOrder = goDAC.GetByTradeNo(orderDetail.Id.ToString());
if (gatewayOrder != null)
{
if (gatewayOrder.Status != GatewayOrderStatus.Pending)
{
throw new CommonException(ReasonCode.ORDER_HAD_COMPLETE, MessageResources.OrderComplated);
}
}
else
{
gatewayOrder = new GatewayOrder()
{
OrderNo = IdentityHelper.OrderNo(),
TradeNo = orderDetail.Id.ToString(),
Id = Guid.NewGuid(),
CryptoId = cryptoCurrency.Id,
MerchantAccountId = orderDetail.MerchantAccountId,
FiatAmount = orderDetail.FiatAmount,
MerchantName = orderDetail.MerchantName,
UserAccountId = account.Id,
CryptoAmount = orderDetail.CryptoAmount,
ActualCryptoAmount = orderDetail.ActualCryptoAmount,
FiatCurrency = orderDetail.FiatCurrency,
Markup = orderDetail.MarkupRate,
ActualFiatAmount = orderDetail.ActualFiatAmount,
Status = GatewayOrderStatus.Pending,
ExchangeRate = orderDetail.ExchangeRate,
ExpiredTime = orderDetail.ExpiredTime,
TransactionFee = orderDetail.TransactionFee,
Timestamp = DateTime.UtcNow,
Remark = orderDetail.Remark
};
goDAC.Insert(gatewayOrder);
}
return(new GatewayOrderInfoOM()
{
Timestamp = DateTime.UtcNow.ToUnixTime().ToString(),
OrderId = gatewayOrder.Id,
MerchantName = gatewayOrder.MerchantName,
CryptoCode = cryptoCurrency.Code,
ActurlCryptoAmount = gatewayOrder.ActualCryptoAmount
});
}
