public async Task InsertAsync(FiiipayMerchantVerifyRecord record)
{
const string sql = @"INSERT INTO [dbo].[FiiipayMerchantVerifyRecords]([CreateTime],[MerchantInfoId],[LicenseNo],[BusinessLicenseImage],[VerifyStatus],[VerifyTime],[Auditor],[Message])
VALUES (@CreateTime,@MerchantInfoId,@LicenseNo,@BusinessLicenseImage,@VerifyStatus,@VerifyTime,@Auditor,@Message)";
using (var con = await WriteConnectionAsync())
{
await con.ExecuteAsync(sql, record);
}
}
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);
}