public WorkflowProcessTimer()
{
DbTableName = TableName;
DbColumns.AddRange(new[] {
new ColumnInfo()
{
Name = "Id", IsKey = true, Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo()
{
Name = "ProcessId", Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo()
{
Name = "Name"
},
new ColumnInfo()
{
Name = "NextExecutionDateTime", Type = SqlDbType.DateTime
},
new ColumnInfo()
{
Name = "Ignore", Type = SqlDbType.Bit
},
});
}
public WorkflowProcessInstance()
{
DbTableName = "WorkflowProcessInstance";
DbColumns.AddRange(new[]
{
new ColumnInfo()
{
Name = "Id", IsKey = true, Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo()
{
Name = "ActivityName"
},
new ColumnInfo()
{
Name = "IsDeterminingParametersChanged", Type = SqlDbType.Bit
},
new ColumnInfo()
{
Name = "PreviousActivity"
},
new ColumnInfo()
{
Name = "PreviousActivityForDirect"
},
new ColumnInfo()
{
Name = "PreviousActivityForReverse"
},
new ColumnInfo()
{
Name = "PreviousState"
},
new ColumnInfo()
{
Name = "PreviousStateForDirect"
},
new ColumnInfo()
{
Name = "PreviousStateForReverse"
},
new ColumnInfo()
{
Name = "SchemeId", Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo()
{
Name = "StateName"
},
new ColumnInfo()
{
Name = "ParentProcessId", Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo()
{
Name = "RootProcessId", Type = SqlDbType.UniqueIdentifier
},
});
}
/// <summary>
/// Tries the add column async.
/// </summary>
/// <param name="dbColumns">The db columns.</param>
/// <param name="columnName">The column name.</param>
/// <param name="typeCode">The type code.</param>
/// <param name="isNotNull">If true, is not null.</param>
/// <param name="length">The length.</param>
/// <param name="databaseName">The database name.</param>
/// <returns>A Task.</returns>
public static async Task <int> TryAddColumnAsync <T>(this DbColumns dbColumns, string columnName, TypeCode typeCode, bool isNotNull, int length = 0, string databaseName = "")
{
var exist = await dbColumns.IsExistColumnAsync <T>(columnName);
if (!exist)
{
return(await dbColumns.AddColumnsAsync <T>(columnName, typeCode, isNotNull, length, databaseName));
}
return(-1);
}
/// <summary>
/// Tries the rename column name async.
/// </summary>
/// <param name="dbColumns">The db columns.</param>
/// <param name="tableName">The table name.</param>
/// <param name="oldColumnName">The old column name.</param>
/// <param name="newColumnName">The new column name.</param>
/// <param name="typeCode">The type code.</param>
/// <param name="isNotNull">If true, is not null.</param>
/// <param name="length">The length.</param>
/// <param name="databaseName">The database name.</param>
/// <returns>A Task.</returns>
public static async Task <int> TryRenameColumnNameAsync(this DbColumns dbColumns, string tableName, string oldColumnName, string newColumnName, TypeCode typeCode, bool isNotNull, int length = 0, string databaseName = "")
{
var exist = await dbColumns.IsExistColumnAsync(tableName, oldColumnName);
if (!exist)
{
return(await dbColumns.RenameColumnAsync(tableName, oldColumnName, newColumnName, typeCode, isNotNull, length, databaseName));
}
return(-1);
}
public WorkflowProcessTransitionHistory()
{
DbTableName = TableName;
DbColumns.AddRange(new[] {
new ColumnInfo()
{
Name = "Id", IsKey = true, Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo()
{
Name = "ActorIdentityId"
},
new ColumnInfo()
{
Name = "ExecutorIdentityId"
},
new ColumnInfo()
{
Name = "FromActivityName"
},
new ColumnInfo()
{
Name = "FromStateName"
},
new ColumnInfo()
{
Name = "IsFinalised", Type = SqlDbType.Bit
},
new ColumnInfo()
{
Name = "ProcessId", Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo()
{
Name = "ToActivityName"
},
new ColumnInfo()
{
Name = "ToStateName"
},
new ColumnInfo()
{
Name = "TransitionClassifier"
},
new ColumnInfo()
{
Name = "TransitionTime", Type = SqlDbType.DateTime
},
new ColumnInfo()
{
Name = "TriggerName"
}
});
}
public WorkflowScheme()
{
DbColumns.AddRange(new[]
{
new ColumnInfo {
Name = "Code", IsKey = true
},
new ColumnInfo {
Name = "Scheme", Size = -1
}
});
}
static WorkflowProcessInstanceStatus()
{
DbColumns.AddRange(new[]
{
new ColumnInfo {
Name = "Id", IsKey = true, Type = typeof(Guid)
},
new ColumnInfo {
Name = "Status", Type = typeof(byte)
}
});
}
/// <summary>
/// Represents a column in the select statement.
/// </summary>
/// <param name="arg">Is a mapped column.</param>
public Column(DbColumns arg)
: base(arg)
{
if (arg != null)
{
Build = arg.Build;
}
else
{
CheckNull(Arg(() => arg, arg));
}
SetArgType(arg);
}
public WorkflowProcessInstanceStatus()
{
DbColumns.AddRange(new[]
{
new ColumnInfo {
Name = "Id", IsKey = true, Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo {
Name = "Lock", Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo {
Name = "Status", Type = SqlDbType.TinyInt
}
});
}
public WorkflowProcessScheme()
{
DbTableName = TableName;
DbColumns.AddRange(new[] {
new ColumnInfo()
{
Name = "Id", IsKey = true, Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo()
{
Name = "DefiningParameters"
},
new ColumnInfo()
{
Name = "DefiningParametersHash"
},
new ColumnInfo()
{
Name = "IsObsolete", Type = SqlDbType.Bit
},
new ColumnInfo()
{
Name = "SchemeCode"
},
new ColumnInfo()
{
Name = "Scheme", Type = SqlDbType.NVarChar, Size = -1
},
new ColumnInfo()
{
Name = "RootSchemeId", Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo()
{
Name = "RootSchemeCode"
},
new ColumnInfo()
{
Name = "AllowedActivities"
},
new ColumnInfo()
{
Name = "StartingTransition"
}
});
}
static WorkflowProcessInstance()
{
DbColumns.AddRange(new[]
{
new ColumnInfo {
Name = "Id", IsKey = true, Type = typeof(Guid)
},
new ColumnInfo {
Name = "ActivityName"
},
new ColumnInfo {
Name = "IsDeterminingParametersChanged", Type = typeof(bool)
},
new ColumnInfo {
Name = "PreviousActivity"
},
new ColumnInfo {
Name = "PreviousActivityForDirect"
},
new ColumnInfo {
Name = "PreviousActivityForReverse"
},
new ColumnInfo {
Name = "PreviousState"
},
new ColumnInfo {
Name = "PreviousStateForDirect"
},
new ColumnInfo {
Name = "PreviousStateForReverse"
},
new ColumnInfo {
Name = "SchemeId", Type = typeof(Guid)
},
new ColumnInfo {
Name = "StateName"
},
new ColumnInfo {
Name = "ParentProcessId", Type = typeof(Guid)
},
new ColumnInfo {
Name = "RootProcessId", Type = typeof(Guid)
}
});
}
public WorkflowProcessInstancePersistence()
{
DbColumns.AddRange(new[]
{
new ColumnInfo {
Name = "Id", IsKey = true, Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo {
Name = "ProcessId", Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo {
Name = "ParameterName"
},
new ColumnInfo {
Name = "Value", Type = SqlDbType.NVarChar, Size = -1
}
});
}
public WorkflowGlobalParameter()
{
DbColumns.AddRange(new[]
{
new ColumnInfo {
Name = "Id", IsKey = true, Type = SqlDbType.UniqueIdentifier
},
new ColumnInfo {
Name = "Type"
},
new ColumnInfo {
Name = "Name"
},
new ColumnInfo {
Name = "Value"
}
});
}
static WorkflowGlobalParameter()
{
DbColumns.AddRange(new[]
{
new ColumnInfo {
Name = "Id", IsKey = true, Type = typeof(Guid)
},
new ColumnInfo {
Name = "Type"
},
new ColumnInfo {
Name = "Name"
},
new ColumnInfo {
Name = "Value"
}
});
}
public WorkflowScheme()
{
DbColumns.AddRange(new[]
{
new ColumnInfo {
Name = "Code", IsKey = true
},
new ColumnInfo {
Name = "Scheme", Size = -1
},
new ColumnInfo {
Name = nameof(CanBeInlined), Type = SqlDbType.Bit
},
new ColumnInfo {
Name = nameof(InlinedSchemes)
}
});
}
static WorkflowProcessTransitionHistory()
{
DbColumns.AddRange(new[]
{
new ColumnInfo {
Name = "Id", IsKey = true, Type = typeof(Guid)
},
new ColumnInfo {
Name = "ActorIdentityId"
},
new ColumnInfo {
Name = "ExecutorIdentityId"
},
new ColumnInfo {
Name = "FromActivityName"
},
new ColumnInfo {
Name = "FromStateName"
},
new ColumnInfo {
Name = "IsFinalised", Type = typeof(bool)
},
new ColumnInfo {
Name = "ProcessId", Type = typeof(Guid)
},
new ColumnInfo {
Name = "ToActivityName"
},
new ColumnInfo {
Name = "ToStateName"
},
new ColumnInfo {
Name = "TransitionClassifier"
},
new ColumnInfo {
Name = "TransitionTime", Type = typeof(DateTime)
},
new ColumnInfo {
Name = "TriggerName"
}
});
}
static WorkflowProcessTimer()
{
DbColumns.AddRange(new[]
{
new ColumnInfo {
Name = "Id", IsKey = true, Type = typeof(Guid)
},
new ColumnInfo {
Name = "ProcessId", Type = typeof(Guid)
},
new ColumnInfo {
Name = "Name"
},
new ColumnInfo {
Name = "NextExecutionDateTime", Type = typeof(DateTime)
},
new ColumnInfo {
Name = "Ignore", Type = typeof(bool)
}
});
}
static WorkflowProcessScheme()
{
DbColumns.AddRange(new[]
{
new ColumnInfo {
Name = "Id", IsKey = true, Type = typeof(Guid)
},
new ColumnInfo {
Name = "DefiningParameters"
},
new ColumnInfo {
Name = "DefiningParametersHash"
},
new ColumnInfo {
Name = "IsObsolete", Type = typeof(bool)
},
new ColumnInfo {
Name = "SchemeCode"
},
new ColumnInfo {
Name = "Scheme"
},
new ColumnInfo {
Name = "RootSchemeId"
},
new ColumnInfo {
Name = "RootSchemeCode"
},
new ColumnInfo {
Name = "AllowedActivities"
},
new ColumnInfo {
Name = "StartingTransition"
}
});
}
public string GetColumnNameFor(string name)
{
return(DbColumns.FirstOrDefault(x => x.Value == name).Key);
}
