public void First()
{
var query = new AccountDeviceGetFirstSchema {
Id = 5
};
var account = _accountDeviceService.FirstAsync(query).GetAwaiter().GetResult();
Assert.IsTrue(query.StatusCode == 200);
Assert.IsTrue(account != null);
}
public async Task <IServiceResult> ExternalSigninAsync(ExternalUserBindingModel externalUser, AccountProfileResult accountProfile)
{
if (accountProfile == null && accountProfile.AccountId.HasValue)
{
return(DataTransferer.DefectiveEntry());
}
if (accountProfile.StatusId != Status.Active)
{
return(DataTransferer.UserIsNotActive());
}
var now = DateTime.UtcNow;
var accountQuery = new AccountGetFirstSchema {
Id = accountProfile.AccountId,
StatusId = Status.Active.ToInt()
};
var account = await FirstAsync(accountQuery);
if (account == null)
{
return(DataTransferer.UserNotFound());
}
// todo: check the account
using (var transaction = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled)) {
try {
var accountDeviceQuery = new AccountDeviceGetFirstSchema {
AccountId = account.Id,
DeviceId = externalUser.DeviceId
};
var accountDevice = await _accountDeviceService.FirstAsync(accountDeviceQuery);
if (accountDevice == null)
{
return(DataTransferer.DeviceIdNotFound());
}
int deviceId;
if (accountDevice != null)
{
deviceId = accountDevice.Id.Value;
// set a new token
await _accountDeviceService.UpdateAsync(new AccountDeviceUpdateSchema {
Id = accountDevice.Id.Value
});
}
else
{
// create new device for account
deviceId = await _accountDeviceService.AddAsync(new AccountDeviceAddSchema {
AccountId = account.Id,
DeviceId = externalUser.DeviceId,
DeviceName = externalUser.DeviceName,
DeviceType = externalUser.DeviceType,
CreatedAt = now,
StatusId = Status.Active.ToInt()
});
}
// clean forgot password tokens
//account.Id.Value, transaction
await _accountProfileService.CleanForgotPasswordTokensAsync(account.Id.Value);
//if(accountProfileCleanTokens.StatusCode != 200) {
// Log.Error($"Can't update 'ForgotPasswordTokens' to NULL for AccountId={account.Id}");
// return DataTransferer.SomethingWentWrong();
//}
// set last signed in at
var accountUpdate = new AccountUpdateSchema {
Id = account.Id.Value,
LastSignedinAt = now
};
await UpdateAsync(accountUpdate);
if (accountUpdate.StatusCode != 200)
{
Log.Error($"Can't update 'LastSignedinAt' after a successfully signing in for AccountId={account.Id}");
}
transaction.Complete();
var token = _jwtHandler.Bearer(new Account(account.Id.Value, deviceId, account.Username, now).ToClaimsIdentity());
return(DataTransferer.Ok(token));
}
catch (Exception ex) {
Log.Error(ex, ex.Source);
return(DataTransferer.InternalServerError(ex));
}
}
}
public async Task <AccountDeviceResult> FirstAsync(AccountDeviceGetFirstSchema accountDevice)
{
var result = await _storedProcedure.QueryFirstAsync <AccountDeviceGetFirstSchema, AccountDeviceResult>(accountDevice);
return(result);
}
public async Task <IServiceResult> SigninAsync(SigninBindingModel signinModel)
{
var now = DateTime.UtcNow;
using (var transaction = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled)) {
try {
var query = new AccountProfileGetFirstSchema {
LinkedId = signinModel.Username
//StatusId = Status.Active
};
if (signinModel.Username.IsPhoneNumber())
{
query.TypeId = AccountProfileType.Phone.ToInt();
}
else if (new EmailAddressAttribute().IsValid(signinModel.Username))
{
query.TypeId = AccountProfileType.Email.ToInt();
}
else
{
return(DataTransferer.InvalidEmailOrCellPhone());
}
var accountProfile = await _accountProfileService.FirstAsync(query).ConfigureAwait(true);
if (accountProfile == null)
{
if (query.TypeId == AccountProfileType.Phone.ToInt())
{
return(DataTransferer.PhoneNotFound());
}
else
{
return(DataTransferer.EmailNotFound());
}
}
var account = await FirstAsync(new AccountGetFirstSchema {
Id = accountProfile.AccountId,
StatusId = Status.Active.ToInt()
}).ConfigureAwait(true);
if (account == null)
{
return(DataTransferer.UserIsNotActive());
}
var deviceId = 0;
// check password
if (_cryptograph.IsEqual(signinModel.Password, account.Password))
{
var accountDeviceQuery = new AccountDeviceGetFirstSchema {
AccountId = account.Id,
DeviceId = signinModel.DeviceId
};
var accountDevice = await _accountDeviceService.FirstAsync(accountDeviceQuery);
// todo: check the accountDevice
if (accountDevice != null)
{
deviceId = accountDevice.Id.Value;
// set new token
await _accountDeviceService.UpdateAsync(new AccountDeviceUpdateSchema {
Id = accountDevice.Id.Value,
});
}
else
{
// create new device for account
deviceId = await _accountDeviceService.AddAsync(new AccountDeviceAddSchema {
AccountId = account.Id,
DeviceId = signinModel.DeviceId,
DeviceName = signinModel.DeviceName,
DeviceType = signinModel.DeviceType,
CreatedAt = now,
StatusId = Status.Active.ToInt()
});
}
}
else
{
return(DataTransferer.WrongPassword());
}
// clean forgot password tokens
await _accountProfileService.CleanForgotPasswordTokensAsync(account.Id.Value);
//if(accountProfilesQuery.StatusCode != 200) {
// Log.Error($"Can't update 'ForgotPasswordTokens' to NULL for AccountId={account.Id}");
// return DataTransferer.SomethingWentWrong();
//}
// set last signed in at
var changedAccount = UpdateAsync(new AccountUpdateSchema {
LastSignedinAt = now
});
transaction.Complete();
var token = _jwtHandler.Bearer(new Account(account.Id.Value, deviceId, signinModel.Username, now).ToClaimsIdentity());
return(DataTransferer.Ok(token));
}
catch (Exception ex) {
Log.Error(ex, ex.Source);
return(DataTransferer.InternalServerError());
}
}
}
