public async Task <int> UpdateUserInformation(User entity) { var sql = "UPDATE users SET name = @Name, surname = @Surname,position_id= @PositionId, role_id = @RoleId WHERE user_id = @UserId"; var result = await _mySqlRepository.ExecuteAsync(sql, entity); return(result); }
public async Task <int> UpdateClientInformation(Client entity) { var sql = "UPDATE clients SET client_name = @ClientName, client_middleName = @ClientMiddleName, client_surname = @ClientSurname,client_address = @ClientAddress, client_phoneNumber = @ClientPhoneNumber WHERE client_id= @ClientId"; var result = await _mySqlRepository.ExecuteAsync(sql, entity); return(result); }