public int Insert(InviteRecord record)
{
var sql = "INSERT INTO InviteRecords (AccountId, InviterCode, Type, InviterAccountId, Timestamp, SN) VALUES (@AccountId, @InviterCode, @Type, @InviterAccountId, @Timestamp, @SN);SELECT SCOPE_IDENTITY()";
using (var con = ReadConnection())
{
return(con.ExecuteScalar <int>(sql, record));
}
}
/// <summary>
/// 修改邀请码
/// </summary>
/// <param name="merchantId"></param>
/// <param name="email"></param>
/// <returns></returns>
public void UpdateInviterCode(Guid merchantId, string inviterCode)
{
UserAccountDAC uaDac = new UserAccountDAC();
if (!string.IsNullOrEmpty(inviterCode) && !uaDac.ExistInviterCode(inviterCode))
{
throw new CommonException(ReasonCode.FiiiPosReasonCode.INVITERCODE_NOT_EXISTS, "邀请码不存在");
}
var user = uaDac.GetUserAccountByInviteCode(inviterCode);
InviteRecordDAC irDac = new InviteRecordDAC();
InviteRecord model = new InviteRecord();
model.AccountId = merchantId;
model.InviterCode = inviterCode;
model.Type = InviteType.Fiiipos;
model.Timestamp = DateTime.UtcNow;
model.InviterAccountId = user.Id;
irDac.Insert(model);;
}
public void DistributeRewards(FiiiPayRewardMessage message, int fiiicoinId)
{
MerchantAccountDAC maDAC = new MerchantAccountDAC();
var merchant = maDAC.GetByUsername(message.Account);
if (merchant == null)
{
throw new CommonException(10000, $"无效的商家名:{message.Account}");
}
InviteRecord invitor = GetInvitor(merchant.Id);
if (invitor == null)
{
throw new CommonException(10000, "没有邀请人");
}
var invitedList = new InviteRecordDAC().GetFiiiPosRecordsByInvitorId(invitor.InviterAccountId, InviteType.Fiiipos);
var rewardRate = GetRewardPercentage(invitedList == null ? 0 : invitedList.Count);
if (rewardRate == 0)
{
throw new CommonException(10000, "没有达到奖励条件");
}
decimal t = (decimal)Math.Pow(10, -8);
long nTotalReward = (long)Math.Floor(message.Reward * rewardRate);
if (nTotalReward == 0)
{
throw new CommonException(10000, "奖励金额为0");
}
decimal rewardAmount = nTotalReward * t;
DateTime dtNow = DateTime.UtcNow;
if (message.CurrentDate > 0)
{
dtNow = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddMilliseconds(message.CurrentDate);
}
var distributeRecord = new RewardDistributeRecords
{
UserAccountId = invitor.InviterAccountId,
MerchantAccountId = merchant.Id,
SN = message.SN,
OriginalReward = message.Reward,
Percentage = rewardRate,
ActualReward = rewardAmount,
Timestamp = dtNow
};
long profitId;
decimal oldBalance = 0;
var invitorWallet = uwDAC.GetByAccountId(invitor.InviterAccountId, fiiicoinId);
using (var scope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 0, 1, 30)))
{
if (invitorWallet == null)
{
invitorWallet = CreateWallet(invitor.InviterAccountId, fiiicoinId, rewardAmount);
}
else
{
oldBalance = invitorWallet.Balance;
uwDAC.Increase(invitorWallet.Id, rewardAmount);
}
var profitDetail = new ProfitDetail
{
InvitationId = invitor.Id,
CryptoAmount = rewardAmount,
AccountId = invitor.InviterAccountId,
Status = InviteStatusType.IssuedActive,
Type = ProfitType.InvitePiiiPos,
OrderNo = CreateOrderno(),
Timestamp = dtNow,
CryptoId = invitorWallet.CryptoId,
CryptoCode = "FIII"
};
profitId = pfDAC.Insert(profitDetail);
uwsDAC.Insert(new UserWalletStatement
{
WalletId = invitorWallet.Id,
Action = UserWalletStatementAction.Reward,
Amount = rewardAmount,
Balance = oldBalance + rewardAmount,
FrozenAmount = 0,
FrozenBalance = invitorWallet.FrozenBalance,
Timestamp = dtNow
});
transDAC.Insert(new UserTransaction
{
AccountId = invitor.InviterAccountId,
Amount = rewardAmount,
CryptoCode = "FIII",
CryptoId = fiiicoinId,
DetailId = profitId.ToString(),
Id = Guid.NewGuid(),
MerchantName = string.Empty,
OrderNo = profitDetail.OrderNo,
Status = 2,
Timestamp = dtNow,
Type = UserTransactionType.Profit
});
distributeRecord.ProfitId = profitId;
rdrDAC.Insert(distributeRecord);
scope.Complete();
}
if (profitId > 0)
{
try
{
MessagePushService.PubUserInviteSuccessed(profitId, 0);
}
catch (Exception ex)
{
throw new CommonException(10000, ex.Message);
}
}
}
public async Task <bool> FiiipayMerchantCreateAsync(UserAccount account, FiiiPayMerchantInfoCreateIM model)
{
var uaDAC = new UserAccountDAC();
if (account.L1VerifyStatus != VerifyStatus.Certified)
{
throw new CommonException(ReasonCode.NOT_VERIFY_LV1, Resources.EMNeedLV1Verfied);
}
var inviteAccount = uaDAC.GetByInvitationCode(model.InviteCode);
bool needInviteRecord = true;
if (!string.IsNullOrEmpty(model.InviteCode))
{
if (inviteAccount == null)
{
throw new CommonException(ReasonCode.INVITORCODE_NOT_EXISTS, MessageResources.InvalidInvitation);
}
if (inviteAccount.InvitationCode == account.InvitationCode)
{
throw new CommonException(ReasonCode.INVALID_INVITECODE, MessageResources.InviteCodeCanotInputSelf);
}
var existInviteRecord = await new InviteRecordDAC().GetDetailByAccountIdAsync(account.Id, InviteType.FiiipayMerchant);
if (existInviteRecord != null)
{
needInviteRecord = false;
}
}
else
{
needInviteRecord = false;
}
var merchantCountry = new CountryDAC().GetById(model.CountryId);
if (merchantCountry == null)
{
throw new CommonException(ReasonCode.RECORD_NOT_EXIST, MessageResources.InvalidParameters);
}
if (!merchantCountry.IsSupportStore)
{
throw new CommonException(ReasonCode.RECORD_NOT_EXIST, MessageResources.InvalidParameters);
}
Regions stateRegion;
Regions cityRegion;
if (model.StateId.HasValue)
{
stateRegion = await new RegionDAC().GetByIdAsync(model.StateId.Value);
if (stateRegion == null)
{
throw new CommonException(ReasonCode.RECORD_NOT_EXIST, MessageResources.InvalidParameters);
}
if (stateRegion.CountryId != model.CountryId)
{
throw new CommonException(ReasonCode.RECORD_NOT_EXIST, MessageResources.InvalidParameters);
}
if (model.CityId.HasValue)
{
cityRegion = await new RegionDAC().GetByIdAsync(model.CityId.Value);
if (cityRegion == null)
{
throw new CommonException(ReasonCode.RECORD_NOT_EXIST, MessageResources.InvalidParameters);
}
if (cityRegion.CountryId != model.CountryId || cityRegion.ParentId != stateRegion.Id)
{
throw new CommonException(ReasonCode.RECORD_NOT_EXIST, MessageResources.InvalidParameters);
}
}
}
#region entities
Guid merchantInfoId = Guid.NewGuid();
DateTime dtNow = DateTime.UtcNow;
MerchantInformation merchantInfo = new MerchantInformation
{
Id = merchantInfoId,
CreateTime = dtNow,
FromType = InputFromType.UserInput,
MerchantName = model.MerchantName,
WeekTxt = model.WeekTxt,
Tags = model.TagList == null ? "" : string.Join(",", model.TagList),
Introduce = model.Introduce,
CountryId = merchantCountry.Id,
StateId = model.StateId,
CityId = model.CityId,
PhoneCode = account.PhoneCode,
Address = model.Address,
Lng = model.Lng,
Lat = model.Lat,
Status = Status.Stop,
VerifyStatus = VerifyStatus.UnderApproval,
MerchantAccountId = account.Id,
Phone = model.Phone,
IsPublic = Status.Stop,
FileId = model.StorefrontImg[0],
ThumbnailId = model.StorefrontImg[1],
AccountType = AccountType.User,
Markup = 0,
FeeRate = 0,
IsAllowExpense = false,
Week = Week.Monday,
ApplicantName = model.ApplicantName,
UseFiiiDeduct = model.UseFiiiDeduction
};
InviteRecord inviteRecord = new InviteRecord
{
AccountId = account.Id,
InviterCode = model.InviteCode,
Type = InviteType.FiiipayMerchant,
InviterAccountId = inviteAccount?.Id ?? Guid.Empty,
Timestamp = dtNow
};
FiiipayMerchantVerifyRecord record = new FiiipayMerchantVerifyRecord
{
CreateTime = dtNow,
MerchantInfoId = merchantInfoId,
BusinessLicenseImage = model.BusinessLicenseImage,
LicenseNo = model.LicenseNo,
VerifyStatus = VerifyStatus.UnderApproval
};
List <MerchantCategory> categorys = model.MerchantCategorys.Select(t => new MerchantCategory
{
MerchantInformationId = merchantInfoId,
Category = t
}).ToList();
List <MerchantOwnersFigure> figuresList = new List <MerchantOwnersFigure>();
if (model.FigureImgList != null)
{
for (int i = 0; i < model.FigureImgList.Length; i++)
{
figuresList.Add(new MerchantOwnersFigure
{
MerchantInformationId = merchantInfoId,
FileId = model.FigureImgList[i][0],
Sort = i,
ThumbnailId = model.FigureImgList[i][1]
});
}
}
var coinList = await new CryptocurrencyDAC().GetAllAsync();
List <MerchantSupportCrypto> supportCryptoList = model.SupportCoins.Select(t =>
{
var c = coinList.Find(m => m.Id == t);
if (c != null)
{
return(new MerchantSupportCrypto
{
MerchantInfoId = merchantInfoId,
CryptoId = t,
CryptoCode = c.Code
});
}
return(null);
}).Where(x => x != null).ToList();
#endregion
var mInfoDAC = new MerchantInformationDAC();
var fmVerfiyRecordDAC = new FiiipayMerchantVerifyRecordDAC();
var mCategoryDAC = new MerchantCategoryDAC();
var mFigureDAC = new MerchantOwnersFigureDAC();
var mSupportCryptoDAC = new MerchantSupportCryptoDAC();
var inviteDAC = new InviteRecordDAC();
using (var scope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 0, 1, 30)))
{
mInfoDAC.Insert(merchantInfo);
fmVerfiyRecordDAC.Insert(record);
if (needInviteRecord)
{
inviteDAC.Insert(inviteRecord);
}
if (categorys != null && categorys.Count > 0)
{
foreach (var item in categorys)
{
mCategoryDAC.Insert(item);
}
}
if (figuresList != null && figuresList.Count > 0)
{
foreach (var item in figuresList)
{
mFigureDAC.Insert(item);
}
}
if (supportCryptoList != null && supportCryptoList.Count > 0)
{
foreach (var item in supportCryptoList)
{
mSupportCryptoDAC.Insert(item);
}
}
scope.Complete();
}
return(true);
}
public void DistributeRewards(FiiiPayRewardMessage message, DateTime dt)
{
if (fiiicoinId == 0)
{
var fiiicoin = new CryptocurrencyDAC().GetByCode("FIII");
fiiicoinId = fiiicoin.Id;
}
MerchantAccountDAC maDAC = new MerchantAccountDAC();
var merchant = maDAC.GetByUsername(message.Account);
if (merchant == null)
{
throw new CommonException(10000, $"无效的商家名:{message.Account}");
}
InviteRecord invitor = GetInvitor(merchant.Id);
if (invitor == null)
{
throw new CommonException(10000, "没有邀请人");
}
var invitedList = new InviteRecordDAC().GetFiiiPosRecordsByInvitorId(invitor.InviterAccountId, InviteType.Fiiipos);
var rewardRate = GetRewardPercentage(invitedList == null ? 0 : invitedList.Count);
if (rewardRate == 0)
{
throw new CommonException(10000, "没有达到奖励条件");
}
decimal t = (decimal)Math.Pow(10, -8);
long nTotalReward = (long)Math.Floor(message.ActualReward * rewardRate);
if (nTotalReward == 0)
{
throw new CommonException(10000, "奖励金额为0");
}
decimal rewardAmount = nTotalReward * t;
var distributeRecord = new RewardDistributeRecords
{
UserAccountId = invitor.InviterAccountId,
MerchantAccountId = merchant.Id,
SN = message.SN,
OriginalReward = message.ActualReward,
Percentage = rewardRate,
ActualReward = rewardAmount,
Timestamp = dt
};
long profitId = 0;
decimal oldBalance = 0;
var invitorWallet = uwDAC.GetByAccountId(invitor.InviterAccountId, fiiicoinId);
using (var scope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 0, 1, 30)))
{
if (invitorWallet == null)
{
invitorWallet = CreateWallet(invitor.InviterAccountId, fiiicoinId, rewardAmount);
}
else
{
oldBalance = invitorWallet.Balance;
uwDAC.Increase(invitorWallet.Id, rewardAmount);
}
profitId = pfDAC.Insert(new ProfitDetail()
{
InvitationId = invitor.Id,
CryptoAmount = rewardAmount,
AccountId = invitor.InviterAccountId,
Status = InviteStatusType.IssuedActive,
Type = ProfitType.InvitePiiiPos,
OrderNo = CreateOrderno(),
Timestamp = dt,
CryptoId = invitorWallet.CryptoId
});
uwsDAC.Insert(new UserWalletStatement
{
WalletId = invitorWallet.Id,
Action = UserWalletStatementAction.Reward,
Amount = rewardAmount,
Balance = oldBalance + rewardAmount,
FrozenAmount = 0,
FrozenBalance = invitorWallet.FrozenBalance,
Timestamp = dt,
Remark = "System"
});
distributeRecord.ProfitId = profitId;
rdrDAC.Insert(distributeRecord);
new TempDataDAC().MessageComplated(message.Id);
scope.Complete();
}
}
