public async Task <User> InsertAsync(User user)
{
_logger.LogDebug($"User {_authenticatedService.GetUserKey()} is starting {nameof(UserService)}.{nameof(InsertAsync)}");
user.Created = DateTime.Now;
user.CreatedBy = _authenticatedService.GetUserName();
_validationService.Validate(_userValidator.Validate(user), new List <(bool, string, object, string)>
{
(await _userRepository.ExistsByEmailAsync(user.Email), "Email", user.Email, $"Email {user.Email} already in use")
});
public async Task <int> InsertAsync(User user)
{
_logger.LogDebug($"User {_authenticatedService.GetUserKey()} is inserting a new User - {user}");
var parameters = new DynamicParameters();
parameters.Add("name", user.Name, direction: ParameterDirection.Input);
parameters.Add("email", user.Email, direction: ParameterDirection.Input);
parameters.Add("password", user.Password, direction: ParameterDirection.Input);
parameters.Add("active", user.Active, direction: ParameterDirection.Input);
parameters.Add("confirmed", user.Confirmed, direction: ParameterDirection.Input);
parameters.Add("created", user.Created, direction: ParameterDirection.Input);
parameters.Add("createdby", user.CreatedBy, direction: ParameterDirection.Input);
parameters.Add("updated", user.Updated, direction: ParameterDirection.Input);
parameters.Add("updatedby", user.UpdatedBy, direction: ParameterDirection.Input);
var id = await _sqlService.ExecuteScalarAsync <int>(UserQuery.INSERT, CommandType.Text, parameters);
_logger.LogDebug($"User {id} inserted");
return(id);
}