public void UpdateClaimForUserQueryGeneratesCorrectQuery() { var generatedQuery = _queryFactory.GetUpdateQuery <UpdateClaimForUserQuery, DapperIdentityUserClaim <int> >(new DapperIdentityUserClaim <int>()); const string expected = "UPDATE `identity`.`identityuserclaim` SET `ClaimType` = @NewClaimType, `ClaimValue` = @NewClaimValue WHERE `UserId` = @UserId AND `ClaimType` = @ClaimType AND `ClaimValue` = @ClaimValue"; Assert.Equal(expected, generatedQuery); }
public void UpdateClaimForUserQueryGeneratesCorrectQuery() { var generatedQuery = _queryFactory.GetUpdateQuery <UpdateClaimForUserQuery, DapperIdentityUserClaim <int> >(new DapperIdentityUserClaim <int>()); const string expected = "UPDATE [dbo].[IdentityUserClaim] SET [ClaimType] = @NewClaimType, [ClaimValue] = @NewClaimValue WHERE [UserId] = @UserId AND [ClaimType] = @ClaimType AND [ClaimValue] = @ClaimValue"; Assert.Equal(expected, generatedQuery); }
public void UpdateClaimForUserQueryGeneratesCorrectQuery() { var generatedQuery = _queryFactory.GetUpdateQuery <UpdateClaimForUserQuery, DapperIdentityUserClaim <int> >(new DapperIdentityUserClaim <int>()); const string expected = "UPDATE \"dbo\".\"IdentityUserClaim\" SET \"ClaimType\" = @NewClaimType, \"ClaimValue\" = @NewClaimValue WHERE \"UserId\" = @UserId AND \"ClaimType\" = @ClaimType AND \"ClaimValue\" = @ClaimValue"; Assert.Equal(expected, generatedQuery); }
public async Task <bool> UpdateAsync(IdentityUser user, CancellationToken cancellationToken) { try { var updateFunction = new Func <DbConnection, Task <bool> >(async x => { try { var dynamicParameters = new DynamicParameters(user); var query = _queryFactory.GetUpdateQuery <UpdateUserQuery, IdentityUser>(user); var result = await x.ExecuteAsync(query, dynamicParameters, _unitOfWork.Transaction); return(result > 0); } catch (Exception ex) { Logging.LogException(ex); throw; } }); DbConnection conn = null; if (_unitOfWork?.Connection == null) { using (conn = _connectionProvider.Create()) { await conn.OpenAsync(cancellationToken); return(await updateFunction(conn)); } } else { conn = _unitOfWork.CreateOrGetConnection(); return(await updateFunction(conn)); } } catch (Exception ex) { Logging.LogException(ex); throw; } }
public void UpdateRoleQueryGenerateCorrectQuery() { var generatedQuery = _queryFactory.GetUpdateQuery <UpdateRoleQuery, CustomDapperIdentityRole>(new CustomDapperIdentityRole { Id = 1, Name = "Teste", Dummy = "dummy" }); var expected = "UPDATE \"dbo\".\"IdentityRole\" SET \"Dummy\" = @Dummy, \"Name\" = @Name WHERE \"Id\" = @Id"; Assert.Equal(expected, generatedQuery); }
public void UpdateRoleQueryGenerateCorrectQuery() { var generatedQuery = _queryFactory.GetUpdateQuery <UpdateRoleQuery, CustomDapperIdentityRole>(new CustomDapperIdentityRole { Id = 1, Name = "Teste", Dummy = "dummy" }); const string expected = "UPDATE [dbo].[IdentityRole] SET [Dummy] = @Dummy, [Name] = @Name WHERE [Id] = @Id"; Assert.Equal(expected, generatedQuery); }
public void UpdateRoleQueryGenerateCorrectQuery() { var generatedQuery = _queryFactory.GetUpdateQuery <UpdateRoleQuery, CustomDapperIdentityRole>(new CustomDapperIdentityRole { Id = 1, Name = "Teste", Dummy = "dummy" }); const string expected = "UPDATE `identity`.`identityrole` SET `Dummy` = @Dummy, `Name` = @Name WHERE `Id` = @Id"; Assert.Equal(expected, generatedQuery); }
public virtual async Task <T> UpdateAsync(T entity, CancellationToken cancellationToken, bool firstLevelOnly = false) { try { var updateFunction = new Func <DbConnection, Task <T> >(async x => { var dynamicParameters = new DynamicParameters(entity); var query = _queryFactory.GetUpdateQuery <UpdateQuery, T>(entity); var result = await x.ExecuteAsync(query, dynamicParameters, _unitOfWork.Transaction); if (!firstLevelOnly) { await SyncChildArrayUpdates(entity, cancellationToken); await HandleChildObjects(entity, cancellationToken); } return(entity); }); DbConnection conn = null; if (_unitOfWork?.Connection == null) { using (conn = _connectionProvider.Create()) { await conn.OpenAsync(cancellationToken); return(await updateFunction(conn)); } } else { conn = _unitOfWork.CreateOrGetConnection(); return(await updateFunction(conn)); } } catch (Exception ex) { Logging.LogException(ex); throw; } }
public async Task <bool> UpdateFillStatusAsync(int fillId, string userId, bool accepted, CancellationToken cancellationToken) { try { var updateFunction = new Func <DbConnection, Task <bool> >(async x => { var dynamicParameters = new DynamicParameters(); dynamicParameters.Add("Accepted", accepted); dynamicParameters.Add("AcceptedUserId", userId); dynamicParameters.Add("AcceptedOn", DateTime.UtcNow); dynamicParameters.Add("ResourceOrderFillId", fillId); var entity = new ResourceOrderFill(); var query = _queryFactory.GetUpdateQuery <UpdateOrderFillStatusQuery, ResourceOrderFill>(entity); var result = await x.ExecuteAsync(query, dynamicParameters, _unitOfWork.Transaction); return(result > 0); }); DbConnection conn = null; if (_unitOfWork?.Connection == null) { using (conn = _connectionProvider.Create()) { await conn.OpenAsync(cancellationToken); return(await updateFunction(conn)); } } else { conn = _unitOfWork.CreateOrGetConnection(); return(await updateFunction(conn)); } } catch (Exception ex) { Logging.LogException(ex); throw; } }
public async Task <bool> Update(TRole role, CancellationToken cancellationToken) { try { var updateFunction = new Func <DbConnection, Task <bool> >(async x => { var dynamicParameters = new DynamicParameters(role); var query = _queryFactory.GetUpdateQuery <UpdateRoleQuery, TRole>(role); var result = await x.ExecuteAsync(query, dynamicParameters, _unitOfWork.Transaction); return(result > 0); }); DbConnection conn = null; if (_unitOfWork?.Connection == null) { using (conn = _connectionProvider.Create()) { await conn.OpenAsync(cancellationToken); return(await updateFunction(conn)); } } else { conn = _unitOfWork.CreateOrGetConnection(); return(await updateFunction(conn)); } } catch (Exception ex) { _log.LogError(ex, ex.Message); throw; } }