# Class WorkflowScheme

OptimaJet.Workflow.PostgreSQL.WorkflowScheme

Namespace: [OptimaJet.Workflow.PostgreSQL](https://api.workflowengine.io/postgresql/OptimaJet.Workflow.PostgreSQL/)

```csharp
public class WorkflowScheme : DbObject<SchemeEntity>
```

## Type Hierarchy

-   [DbObject<SchemeEntity>](https://api.workflowengine.io/postgresql/OptimaJet.Workflow.PostgreSQL/DbObject-TEntity/)
    -   WorkflowScheme Current type

## Constructors

`public WorkflowScheme(string schemaName, int commandTimeout)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `schemaName` | `String` |  |
| `commandTimeout` | `Int32` |  |

## Methods

`public Task<SchemeEntity> SelectByCodeAsync(NpgsqlConnection connection, string code, string tenantId)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `NpgsqlConnection` |  |
| `code` | `String` |  |
| `tenantId` | `String` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<SchemeEntity>` |  |

`public Task<SchemeEntity> SelectByCodeExactAsync(NpgsqlConnection connection, string code, string tenantId)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `NpgsqlConnection` |  |
| `code` | `String` |  |
| `tenantId` | `String` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<SchemeEntity>` |  |

`public override Task<int> UpsertAsync(NpgsqlConnection connection, SchemeEntity entity, NpgsqlTransaction transaction = null)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `NpgsqlConnection` |  |
| `entity` | `SchemeEntity` |  |
| `transaction` | `NpgsqlTransaction` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` |  |

`public Task<SchemeEntity[]> SelectAllWorkflowSchemesWithPagingAsync(NpgsqlConnection connection, List<(string parameterName, SortDirection sortDirection)> orderParameters, Paging paging)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `NpgsqlConnection` |  |
| `orderParameters` | `List<String, SortDirection>` |  |
| `paging` | `Paging` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<SchemeEntity[]>` |  |

`public Task<List<string>> GetInlinedSchemeCodesAsync(NpgsqlConnection connection, string tenantId = null)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `NpgsqlConnection` |  |
| `tenantId` | `String` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<String>` |  |

`public Task<List<string>> GetRelatedSchemeCodesAsync(NpgsqlConnection connection, string schemeCode, string tenantId = null)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `NpgsqlConnection` |  |
| `schemeCode` | `String` |  |
| `tenantId` | `String` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<String>` |  |

`public Task<List<string>> GetSchemeCodesByTagsAsync(NpgsqlConnection connection, string tenantId, IEnumerable<string> tags)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `NpgsqlConnection` |  |
| `tenantId` | `String` |  |
| `tags` | `IEnumerable<String>` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<String>` |  |

`public Task AddSchemeTagsAsync(NpgsqlConnection connection, string schemeCode, string tenantId, IEnumerable<string> tags, IWorkflowBuilder builder)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `NpgsqlConnection` |  |
| `schemeCode` | `String` |  |
| `tenantId` | `String` |  |
| `tags` | `IEnumerable<String>` |  |
| `builder` | `IWorkflowBuilder` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task` |  |

`public Task RemoveSchemeTagsAsync(NpgsqlConnection connection, string schemeCode, string tenantId, IEnumerable<string> tags, IWorkflowBuilder builder)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `NpgsqlConnection` |  |
| `schemeCode` | `String` |  |
| `tenantId` | `String` |  |
| `tags` | `IEnumerable<String>` |  |
| `builder` | `IWorkflowBuilder` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task` |  |

`public Task SetSchemeTagsAsync(NpgsqlConnection connection, string schemeCode, string tenantId, IEnumerable<string> tags, IWorkflowBuilder builder)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `NpgsqlConnection` |  |
| `schemeCode` | `String` |  |
| `tenantId` | `String` |  |
| `tags` | `IEnumerable<String>` |  |
| `builder` | `IWorkflowBuilder` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task` |  |

[Previous WorkflowProcessTransitionHistory](https://api.workflowengine.io/postgresql/OptimaJet.Workflow.PostgreSQL/WorkflowProcessTransitionHistory/) [Next Migration10Initial](https://api.workflowengine.io/postgresql/OptimaJet.Workflow.PostgreSQL.Migrations/Migration10Initial/)