public WorkflowController(WorkflowDataContext context, IAuthService authService, WorkflowCache cache, EventBus eventBus)
{
this.context = context;
this.authService = authService;
this.cache = cache;
this.eventBus = eventBus;
}
internal static Process GetProcessFromContext(WorkflowDataContext DataContext)
{
var pi = DataContext.GetProperties()["Process"];
var process = pi.GetValue(DataContext) as Process;
return(process);
}
protected override void Execute(NativeActivityContext context)
{
WorkflowDataContext dataContext = context.DataContext;
PropertyDescriptorCollection propertyDescriptorCollection = dataContext.GetProperties();
string sessionId = string.Empty;
int fileSystemItemId = 0;
foreach (PropertyDescriptor propertyDesc in propertyDescriptorCollection)
{
if (propertyDesc.Name == "ArgSessionId")
{
sessionId = propertyDesc.GetValue(dataContext) as string;
break;
}
}
foreach (PropertyDescriptor propertyDesc in propertyDescriptorCollection)
{
if (propertyDesc.Name == "ArgFileSystemItemId")
{
fileSystemItemId = (int)propertyDesc.GetValue(dataContext);
break;
}
}
if (string.IsNullOrWhiteSpace(sessionId))
{
LogHelper.AddGeneralLog(GeneralLogTypeEnum.ActivityError, $"SessionId is null.");
return;
}
if (fileSystemItemId == 0)
{
LogHelper.AddSessionLog(SessionLogTypeEnum.ActivityError, sessionId, $"FileSystemItemId is null.");
return;
}
FileSystemItemDto fileSystemItem = null;
try
{
using (var sqlDbContext = new SqlDbContext())
{
fileSystemItem = sqlDbContext.FileSystemItems.FirstOrDefault(x => x.Id == fileSystemItemId);
}
}
catch (Exception ex)
{
LogHelper.AddSessionLog(SessionLogTypeEnum.ActivityError, sessionId, $"Exception has been thrown when getting fileSystemItem. FileSystemItemId: {fileSystemItemId}", ex);
return;
}
Result.Set(context, fileSystemItem);
}
public static object GetValueOfWorkflowVariable(WorkflowDataContext dataContext, string valueName)
{
object value = null;
PropertyDescriptorCollection propertyDescriptorCollection = dataContext.GetProperties();
foreach (PropertyDescriptor propertyDesc in propertyDescriptorCollection)
{
if (propertyDesc.Name == valueName)
{
value = propertyDesc.GetValue(dataContext);
break;
}
}
return(value);
}
protected override void Execute(CodeActivityContext context)
{
Logger = (ILogger)context.GetExtension <ILogger>();
KernelService = (IKernelService)context.GetExtension <IKernelService>();
TerminalDataCache = KernelService.TerminalDataCache;
TransactionDataCache = KernelService.TransactionDataCache;
WorkflowDataContext dataContext = context.DataContext;
PropertyDescriptorCollection propertyDescriptorCollection = dataContext.GetProperties();
foreach (PropertyDescriptor propertyDesc in propertyDescriptorCollection)
{
if (propertyDesc.Name == "TerminalConfig")
{
TerminalConfig = propertyDesc.GetValue(dataContext) as TerminalConfig;
}
}
}
public WorkflowTypeController(WorkflowDataContext context)
{
this.context = context;
}
protected override void Track(TrackingRecord trackRecord, TimeSpan timeStamp)
{
try
{
string State = "unknown";
Guid InstanceId = trackRecord.InstanceId;
ActivityStateRecord activityStateRecord = trackRecord as ActivityStateRecord;
ActivityScheduledRecord activityScheduledRecord = trackRecord as ActivityScheduledRecord;
WorkflowInstanceRecord workflowInstanceRecord = trackRecord as WorkflowInstanceRecord;
if (workflowInstanceRecord != null)
{
var Instance = WorkflowInstance.Instances.Where(x => x.InstanceId == InstanceId.ToString()).FirstOrDefault();
if (workflowInstanceRecord.State == WorkflowInstanceStates.Started || workflowInstanceRecord.State == WorkflowInstanceStates.Resumed)
{
lock (timerslock) timers.Add(InstanceId.ToString(), new Dictionary <string, Stopwatch>());
System.Diagnostics.Activity.Current = null;
// Instance.RootActivity = Instance.source.StartActivity(workflowInstanceRecord.State.ToString() + " " + Instance.Workflow.name, ActivityKind.Consumer, Instance.ParentSpanId);
Instance.RootActivity = Instance.source.StartActivity(workflowInstanceRecord.State.ToString() + " " + Instance.Workflow.name, ActivityKind.Consumer);
if (Instance.RootActivity != null)
{
if (!string.IsNullOrEmpty(Instance.ParentSpanId))
{
Instance.RootActivity?.SetParentId(Instance.ParentSpanId);
}
Instance.SpanId = Instance.RootActivity.SpanId.ToHexString();
}
Instance.RootActivity?.SetTag("status.code", 200);
Instance.RootActivity?.SetTag("status.state", workflowInstanceRecord.State.ToString());
Instance.RootActivity?.SetTag("ofid", Config.local.openflow_uniqueid);
try
{
if (global.webSocketClient != null && global.webSocketClient.user != null && !string.IsNullOrEmpty(global.webSocketClient.user.username))
{
Instance.RootActivity?.SetTag("username", global.webSocketClient.user.username);
}
else
{
Instance.RootActivity?.SetTag("username", System.Security.Principal.WindowsIdentity.GetCurrent().Name);
}
}
catch (Exception)
{
}
try
{
if (hostname == null)
{
hostname = System.Net.Dns.GetHostName();
}
Instance.RootActivity?.SetTag("hostname", hostname);
}
catch (Exception)
{
hostname = "";
}
Instance.Activities.Push(Instance.RootActivity);
}
else if (workflowInstanceRecord.State == WorkflowInstanceStates.Aborted || workflowInstanceRecord.State == WorkflowInstanceStates.Canceled ||
workflowInstanceRecord.State == WorkflowInstanceStates.Completed || workflowInstanceRecord.State == WorkflowInstanceStates.Deleted ||
workflowInstanceRecord.State == WorkflowInstanceStates.Suspended || workflowInstanceRecord.State == WorkflowInstanceStates.Terminated ||
workflowInstanceRecord.State == WorkflowInstanceStates.UnhandledException || workflowInstanceRecord.State == WorkflowInstanceStates.UpdateFailed)
{
if (timers.ContainsKey(InstanceId.ToString()))
{
lock (timerslock) timers.Remove(InstanceId.ToString());
}
if (workflowInstanceRecord.State != WorkflowInstanceStates.Completed)
{
Instance.RootActivity?.SetTag("status.state", 500);
}
if (workflowInstanceRecord.State == WorkflowInstanceStates.UnhandledException)
{
Instance.RootActivity?.SetTag("Exception", ((System.Activities.Tracking.WorkflowInstanceUnhandledExceptionRecord)workflowInstanceRecord).UnhandledException);
}
if (workflowInstanceRecord.State == WorkflowInstanceStates.Aborted)
{
Instance.RootActivity?.SetTag("Reason", ((System.Activities.Tracking.WorkflowInstanceAbortedRecord)workflowInstanceRecord).Reason);
}
if (workflowInstanceRecord.State == WorkflowInstanceStates.Suspended)
{
Instance.RootActivity?.SetTag("Reason", ((System.Activities.Tracking.WorkflowInstanceSuspendedRecord)workflowInstanceRecord).Reason);
}
if (workflowInstanceRecord.State == WorkflowInstanceStates.Terminated)
{
Instance.RootActivity?.SetTag("Reason", ((System.Activities.Tracking.WorkflowInstanceTerminatedRecord)workflowInstanceRecord).Reason);
}
Instance.RootActivity?.SetTag("status.state", workflowInstanceRecord.State.ToString());
if (Instance.source != null)
{
while (Instance.Activities.Count > 0)
{
var span = Instance.Activities.Pop();
span?.Dispose();
}
Instance.RootActivity = null;
}
}
else
{
Instance.RootActivity?.AddEvent(new ActivityEvent(workflowInstanceRecord.State.ToString()));
if (Instance.Activities.Count > 0)
{
Instance.Activities.First()?.AddEvent(new ActivityEvent(workflowInstanceRecord.State.ToString()));
}
}
}
//if (activityStateRecord != null || activityScheduledRecord != null)
if (activityStateRecord != null)
{
string ActivityId = null, name = null;
var Instance = WorkflowInstance.Instances.Where(x => x.InstanceId == InstanceId.ToString()).FirstOrDefault();
if (activityStateRecord.Activity != null && !string.IsNullOrEmpty(activityStateRecord.Activity.Id))
{
ActivityId = activityStateRecord.Activity.Id;
}
if (activityStateRecord.Activity != null && !string.IsNullOrEmpty(activityStateRecord.Activity.Name))
{
name = activityStateRecord.Activity.Name;
}
Console.WriteLine(activityStateRecord.State.ToString() + " " + ActivityId + " " + name);
// var sw = new Stopwatch(); sw.Start();
if (timers.ContainsKey(InstanceId.ToString()) && !string.IsNullOrEmpty(ActivityId))
{
var timer = timers[InstanceId.ToString()];
if (activityStateRecord.State == ActivityStates.Executing)
{
if (!timer.ContainsKey(ActivityId))
{
Stopwatch sw = new Stopwatch(); sw.Start();
timer.Add(ActivityId, sw);
var TypeName = activityStateRecord.Activity.TypeName;
var Name = activityStateRecord.Activity.Name;
if (String.IsNullOrEmpty(Name))
{
Name = TypeName;
}
if (TypeName.IndexOf("`") > -1)
{
TypeName = TypeName.Substring(0, TypeName.IndexOf("`"));
}
System.Diagnostics.Activity.Current = Instance.RootActivity;
var span = Instance.source.StartActivity(Name, ActivityKind.Consumer);
span?.AddTag("type", TypeName);
span?.AddTag("ActivityId", ActivityId);
// Console.WriteLine("Push " + Name);
if (Instance.source != null)
{
Instance.Activities.Push(span);
}
// Console.WriteLine("start " + TypeName);
}
else
{
// Console.WriteLine("Skip adding new span and timer for " + ActivityId);
}
}
if (activityStateRecord.State != ActivityStates.Executing)
{
if (timer.ContainsKey(ActivityId))
{
Stopwatch sw = timer[ActivityId];
timer.Remove(ActivityId);
var TypeName = activityStateRecord.Activity.TypeName;
var Name = activityStateRecord.Activity.Name;
if (String.IsNullOrEmpty(Name))
{
Name = TypeName;
}
if (TypeName.IndexOf("`") > -1)
{
TypeName = TypeName.Substring(0, TypeName.IndexOf("`"));
}
try
{
if (Instance.Activities.Count > 0)
{
if (Instance.Activities.First().DisplayName == Name)
{
// Console.WriteLine("Popping " + Name);
var span = Instance.Activities.Pop();
span?.Dispose();
}
else
{
// Console.WriteLine("Skip pop, expected " + Name + " but found " + Instance.Activities.First().DisplayName);
}
}
}
catch (Exception ex)
{
Log.Error(ex.ToString());
}
}
else
{
// Console.WriteLine("Skip removing old span and timer for " + ActivityId);
}
}
}
if (activityStateRecord.Activity != null && !string.IsNullOrEmpty(activityStateRecord.Activity.Name) && Instance != null && Instance.Workflow != null)
{
var TypeName = activityStateRecord.Activity.TypeName;
if (TypeName.IndexOf("`") > -1)
{
TypeName = TypeName.Substring(0, TypeName.IndexOf("`"));
}
//RobotInstance.activity_counter.WithLabels((activityStateRecord.Activity.Name, TypeName, Instance.Workflow.name)).Inc();
}
foreach (var v in activityStateRecord.Variables)
{
if (Instance.Variables.ContainsKey(v.Key))
{
Instance.Variables[v.Key].value = v.Value;
}
else
{
if (v.Value != null)
{
Instance.Variables.Add(v.Key, new WorkflowInstanceValueType(v.Value.GetType(), v.Value));
}
}
//wfi.variables.Add(v.Key, v.Value);
}
// Log.Activity(activityStateRecord.State + " " + activityStateRecord.Activity.Id + " " + activityStateRecord.Activity.Name);
}
if (activityScheduledRecord != null)
{
var Instance = WorkflowInstance.Instances.Where(x => x.InstanceId == InstanceId.ToString()).FirstOrDefault();
if (Instance == null || Instance.wfApp == null)
{
return;
}
var wfApp = Instance.wfApp;
var executor = typeof(System.Activities.Hosting.WorkflowInstance).GetField("executor", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(wfApp);
var scheduler = executor.GetType().GetField("scheduler", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(executor);
string ActivityId = null;
string ChildActivityId = null;
if (activityStateRecord != null)
{
ActivityId = activityStateRecord.Activity.Id;
State = activityStateRecord.State.ToLower();
}
if (activityScheduledRecord != null)
{
State = "Scheduled";
if (activityScheduledRecord.Activity != null)
{
ActivityId = activityScheduledRecord.Activity.Id;
}
if (activityScheduledRecord.Child != null)
{
ChildActivityId = activityScheduledRecord.Child.Id;
}
}
if (activityScheduledRecord.Activity == null && activityScheduledRecord.Child != null)
{
// this will make "1" be handles twice, but "1" is always sendt AFTER being scheduled, but we can catch it here ?
ActivityId = activityScheduledRecord.Child.Id;
ChildActivityId = activityScheduledRecord.Child.Id;
}
if (string.IsNullOrEmpty(ActivityId))
{
return;
}
if (activityScheduledRecord.Child.Id == "1.11")
{
// scheduler.GetType().GetMethod("ClearAllWorkItems", BindingFlags.Public | BindingFlags.Instance).Invoke(scheduler, new object[] { executor });
// scheduler.GetType().GetMethod("ScheduleWork", BindingFlags.NonPublic | BindingFlags.Instance).Invoke(scheduler, new object[] { false });
//var firstWorkItem = scheduler.GetType().GetField("firstWorkItem", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(scheduler);
//firstWorkItem.GetType().GetMethod("Release", BindingFlags.Public | BindingFlags.Instance).Invoke(firstWorkItem, new object[] { executor });
//firstWorkItem.GetType().GetMethod("Dispose", BindingFlags.Public | BindingFlags.Instance).Invoke(firstWorkItem, new object[] { executor });
//scheduler.GetType().GetMethod("NotifyWorkCompletion", BindingFlags.NonPublic | BindingFlags.Instance).Invoke(scheduler, new object[] { });
}
if (activityScheduledRecord.Activity != null)
{
// Log.Activity("Scheduled " + activityScheduledRecord.Activity.Id + " " + activityScheduledRecord.Activity.Name + " -> " + activityScheduledRecord.Child.Id + " " + activityScheduledRecord.Child.Name);
}
else if (activityScheduledRecord.Child != null)
{
// Log.Activity("Scheduled " + activityScheduledRecord.Child.Id + " " + activityScheduledRecord.Child.Name);
}
if (Instance.Variables == null)
{
Instance.Variables = new Dictionary <string, WorkflowInstanceValueType>();
}
if (activityStateRecord != null)
{
foreach (var v in Instance.Variables.ToList())
{
if (!activityStateRecord.Variables.ContainsKey(v.Key))
{
Instance.Variables.Remove(v.Key);
}
}
foreach (var v in activityStateRecord.Variables)
{
if (Instance.Variables.ContainsKey(v.Key))
{
Instance.Variables[v.Key].value = v.Value;
}
}
}
var instanceMapField = executor.GetType().GetField("instanceMap", BindingFlags.NonPublic | BindingFlags.Instance);
// get SerializedProgramMapping to have InstanceMap get filled, needed by SerializedProgramMapping
var SerializedProgramMapping = executor.GetType().GetProperty("SerializedProgramMapping", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(executor);
ActivityInstance activityInstance = executor.GetType().GetField("rootInstance", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(executor) as ActivityInstance;
// Sometimes we can find the ActivityInstance in rootInstance
ActivityInstance result = findActivityInstance(executor, activityInstance, ActivityId);
// But more often, we find it in InstanceMapping
var instanceMap = instanceMapField.GetValue(executor);
if (instanceMap != null && result == null)
{
var _list = SerializedProgramMapping.GetType().GetProperty("InstanceMapping", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(SerializedProgramMapping);
foreach (System.Collections.DictionaryEntry kvp in (System.Collections.IDictionary)_list)
{
var a = kvp.Key as System.Activities.Activity;
if (a == null)
{
continue;
}
if (result == null && a.Id == ActivityId)
{
result = findActivityInstance(kvp.Value, ActivityId);
}
}
}
if (result != null)
{
WorkflowDataContext context = null;
var cs = typeof(WorkflowDataContext).GetConstructors(BindingFlags.NonPublic | BindingFlags.Instance);
ConstructorInfo c = cs.First();
try
{
object o = c.Invoke(new Object[] { executor, result, true });
context = o as WorkflowDataContext;
var vars = context.GetProperties();
foreach (dynamic v in vars)
{
var value = v.GetValue(context);
if (Instance.Variables.ContainsKey(v.DisplayName))
{
Instance.Variables[v.DisplayName] = new WorkflowInstanceValueType(v.PropertyType, value);
}
else
{
Instance.Variables.Add(v.DisplayName, new WorkflowInstanceValueType(v.PropertyType, value));
}
}
}
catch (Exception ex)
{
Log.Debug(ex.Message);
}
}
OnVisualTracking?.Invoke(Instance, ActivityId, ChildActivityId, State);
}
else
{
// Log.Debug(trackRecord.ToString());
}
}
catch (Exception ex)
{
Log.Error(ex.ToString());
}
}
protected override void Execute(CodeActivityContext context)
{
WorkflowDataContext dc = context.DataContext;
//get Excel context
XLExcelContextInfo customContext = Utils.GetXLExcelContextInfo(context);
//retrieve the parameters from the Context
string filePath = customContext.Path;
string sheetName = SheetName.Get(context);
string rowNum = "";
//open file
using (SpreadsheetDocument myDoc = SpreadsheetDocument.Open(filePath, true))
{
WorkbookPart workbookPart = myDoc.WorkbookPart;
//determine ID of the Sheet
string relId = workbookPart.Workbook.Descendants <Sheet>().First(s => sheetName.Equals(s.Name)).Id;
if (String.IsNullOrEmpty(relId))
{
throw new Exception("Could not indentify the Excel Sheet");
}
//open reader for Sheet
WorksheetPart worksheetPart = workbookPart.GetPartById(relId) as WorksheetPart;
OpenXmlReader reader = OpenXmlReader.Create(worksheetPart);
//read the XML objects until we reach the rows
while (reader.Read())
{
//check if current elem is row
if (reader.ElementType == typeof(Row))
{
//loop through row siblings
do
{
if (reader.HasAttributes)
{
//at each step, read the current rowNum
rowNum = reader.Attributes.First(a => a.LocalName == "r").Value;
}
} while (reader.ReadNextSibling());
break;
}
}
}
int result;
//convert the result to Int and pass it as an output argument
if (Int32.TryParse(rowNum, out result))
{
NumberOfRows.Set(context, result);
}
else
{
throw new Exception("Unable to parse the line number");
}
}
protected override void Execute(NativeActivityContext context)
{
WorkflowDataContext dataContext = context.DataContext;
PropertyDescriptorCollection propertyDescriptorCollection = dataContext.GetProperties();
string sessionId = string.Empty;
int fileSystemItemId = 0;
foreach (PropertyDescriptor propertyDesc in propertyDescriptorCollection)
{
if (propertyDesc.Name == "ArgSessionId")
{
sessionId = propertyDesc.GetValue(dataContext) as string;
break;
}
}
foreach (PropertyDescriptor propertyDesc in propertyDescriptorCollection)
{
if (propertyDesc.Name == "ArgFileSystemItemId")
{
fileSystemItemId = (int)propertyDesc.GetValue(dataContext);
break;
}
}
if (string.IsNullOrWhiteSpace(sessionId))
{
LogHelper.AddGeneralLog(GeneralLogTypeEnum.ActivityError, $"SessionId is null.");
return;
}
if (fileSystemItemId == 0)
{
LogHelper.AddSessionLog(SessionLogTypeEnum.ActivityError, sessionId, $"FileSystemItemId is null.");
return;
}
FileSystemItemDto fileSystemItem = null;
try
{
using (var sqlDbContext = new SqlDbContext())
{
fileSystemItem = sqlDbContext.FileSystemItems.FirstOrDefault(x => x.Id == fileSystemItemId);
}
}
catch (Exception ex)
{
LogHelper.AddSessionLog(SessionLogTypeEnum.ActivityError, sessionId, $"Exception has been thrown when getting fileSystemItem. FileSystemItemId: {fileSystemItemId}", ex);
return;
}
if (File.Exists(SourceFilePath.Get(context)) == false)
{
LogHelper.AddFileSystemItemLog(fileSystemItem.Id, fileSystemItem.SourceId, sessionId, FileSystemItemLogTypeEnum.SaveTextDataFileNotFound, $"File path: {SourceFilePath.Get(context)}.");
return;
}
var content = File.ReadAllText(SourceFilePath.Get(context));
try
{
using (var sqlDbContext = new SqlDbContext())
{
var saveResult1 = sqlDbContext.SaveChanges();
var oldItemCount = sqlDbContext.ClearTexts.Count(x => x.FileSystemItemId == fileSystemItemId);
if (oldItemCount == 0)
{
var clearTextDto = new ClearTextDto
{
FileSystemItemId = fileSystemItemId,
TextInFile = content,
};
sqlDbContext.ClearTexts.Add(clearTextDto);
var saveResult2 = sqlDbContext.SaveChanges();
}
else
{
var oldClearText = sqlDbContext.ClearTexts.FirstOrDefault(x => x.FileSystemItemId == fileSystemItemId);
var sql = "UPDATE ClearText SET TextInFile = @TextInFile WHERE Id = @Id";
var executeCount = sqlDbContext.Database.ExecuteSqlCommand(sql, content, oldClearText.Id);
}
}
LogHelper.AddFileSystemItemLog(fileSystemItem.Id, fileSystemItem.SourceId, sessionId, FileSystemItemLogTypeEnum.SaveTextDataOk);
}
catch (Exception ex)
{
LogHelper.AddSessionLog(SessionLogTypeEnum.ActivityError, sessionId, $"Exception has been thrown when getting fileSystemItem. FileSystemItemId: {fileSystemItemId}", ex);
return;
}
}
protected override void Track(TrackingRecord trackRecord, TimeSpan timeStamp)
{
try
{
string State = "unknown";
Guid InstanceId = trackRecord.InstanceId;
ActivityStateRecord activityStateRecord = trackRecord as ActivityStateRecord;
ActivityScheduledRecord activityScheduledRecord = trackRecord as ActivityScheduledRecord;
//if (activityStateRecord != null || activityScheduledRecord != null)
if (activityStateRecord != null)
{
var Instance = WorkflowInstance.Instances.Where(x => x.InstanceId == InstanceId.ToString()).FirstOrDefault();
foreach (var v in activityStateRecord.Variables)
{
if (Instance.Variables.ContainsKey(v.Key))
{
Instance.Variables[v.Key].value = v.Value;
}
else
{
if (v.Value != null)
{
Instance.Variables.Add(v.Key, new WorkflowInstanceValueType(v.Value.GetType(), v.Value));
}
}
//wfi.variables.Add(v.Key, v.Value);
}
}
if (activityScheduledRecord != null)
{
string ActivityId = null;
string ChildActivityId = null;
if (activityStateRecord != null)
{
ActivityId = activityStateRecord.Activity.Id;
State = activityStateRecord.State.ToLower();
}
if (activityScheduledRecord != null)
{
State = "Scheduled";
if (activityScheduledRecord.Activity != null)
{
ActivityId = activityScheduledRecord.Activity.Id;
}
if (activityScheduledRecord.Child != null)
{
ChildActivityId = activityScheduledRecord.Child.Id;
}
}
if (string.IsNullOrEmpty(ActivityId))
{
return;
}
var Instance = WorkflowInstance.Instances.Where(x => x.InstanceId == InstanceId.ToString()).FirstOrDefault();
if (Instance == null || Instance.wfApp == null)
{
return;
}
var wfApp = Instance.wfApp;
if (Instance.Variables == null)
{
Instance.Variables = new Dictionary <string, WorkflowInstanceValueType>();
}
if (activityStateRecord != null)
{
foreach (var v in Instance.Variables.ToList())
{
if (!activityStateRecord.Variables.ContainsKey(v.Key))
{
Instance.Variables.Remove(v.Key);
}
}
foreach (var v in activityStateRecord.Variables)
{
if (Instance.Variables.ContainsKey(v.Key))
{
Instance.Variables[v.Key].value = v.Value;
}
}
}
var executor = typeof(System.Activities.Hosting.WorkflowInstance).GetField("executor", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(wfApp);
var instanceMapField = executor.GetType().GetField("instanceMap", BindingFlags.NonPublic | BindingFlags.Instance);
// get SerializedProgramMapping to have InstanceMap get filled, needed by SerializedProgramMapping
var SerializedProgramMapping = executor.GetType().GetProperty("SerializedProgramMapping", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(executor);
ActivityInstance activityInstance = executor.GetType().GetField("rootInstance", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(executor) as ActivityInstance;
// Sometimes we can find the ActivityInstance in rootInstance
ActivityInstance result = findActivityInstance(executor, activityInstance, ActivityId);
// But more often, we find it in InstanceMapping
var instanceMap = instanceMapField.GetValue(executor);
if (instanceMap != null && result == null)
{
var _list = SerializedProgramMapping.GetType().GetProperty("InstanceMapping", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(SerializedProgramMapping);
foreach (System.Collections.DictionaryEntry kvp in (System.Collections.IDictionary)_list)
{
var a = kvp.Key as Activity;
if (a == null)
{
continue;
}
if (result == null && a.Id == ActivityId)
{
result = findActivityInstance(kvp.Value, ActivityId);
}
}
}
if (result != null)
{
WorkflowDataContext context = null;
var cs = typeof(WorkflowDataContext).GetConstructors(BindingFlags.NonPublic | BindingFlags.Instance);
ConstructorInfo c = cs.First();
try
{
object o = c.Invoke(new Object[] { executor, result, true });
context = o as WorkflowDataContext;
var vars = context.GetProperties();
foreach (dynamic v in vars)
{
var value = v.GetValue(context);
if (Instance.Variables.ContainsKey(v.DisplayName))
{
Instance.Variables[v.DisplayName] = new WorkflowInstanceValueType(v.PropertyType, value);
}
else
{
Instance.Variables.Add(v.DisplayName, new WorkflowInstanceValueType(v.PropertyType, value));
}
}
}
catch (Exception ex)
{
Log.Debug(ex.Message);
}
}
OnVisualTracking?.Invoke(Instance, ActivityId, ChildActivityId, State);
}
else
{
// Log.Debug(trackRecord.ToString());
}
}
catch (Exception ex)
{
Log.Error(ex.ToString());
}
}
protected override void Track(TrackingRecord trackRecord, TimeSpan timeStamp)
{
try
{
string State = "unknown";
Guid InstanceId = trackRecord.InstanceId;
ActivityStateRecord activityStateRecord = trackRecord as ActivityStateRecord;
ActivityScheduledRecord activityScheduledRecord = trackRecord as ActivityScheduledRecord;
WorkflowInstanceRecord workflowInstanceRecord = trackRecord as WorkflowInstanceRecord;
if (workflowInstanceRecord != null)
{
Log.Activity(workflowInstanceRecord.ActivityDefinitionId + " " + workflowInstanceRecord.State);
var Instance = WorkflowInstance.Instances.Where(x => x.InstanceId == InstanceId.ToString()).FirstOrDefault();
if (Instance == null)
{
return;
}
lock (Instance)
{
if (workflowInstanceRecord.State == WorkflowInstanceStates.Started || workflowInstanceRecord.State == WorkflowInstanceStates.Resumed)
{
lock (timerslock) timers.Add(InstanceId.ToString(), new Dictionary <string, Stopwatch>());
}
else if (workflowInstanceRecord.State == WorkflowInstanceStates.Aborted || workflowInstanceRecord.State == WorkflowInstanceStates.Canceled ||
workflowInstanceRecord.State == WorkflowInstanceStates.Completed || workflowInstanceRecord.State == WorkflowInstanceStates.Deleted ||
workflowInstanceRecord.State == WorkflowInstanceStates.Suspended || workflowInstanceRecord.State == WorkflowInstanceStates.Terminated ||
workflowInstanceRecord.State == WorkflowInstanceStates.UnhandledException || workflowInstanceRecord.State == WorkflowInstanceStates.UpdateFailed)
{
if (timers.ContainsKey(InstanceId.ToString()))
{
lock (timerslock) timers.Remove(InstanceId.ToString());
}
}
}
}
if (activityStateRecord != null)
{
string ActivityId = null, name = null;
var Instance = WorkflowInstance.Instances.Where(x => x.InstanceId == InstanceId.ToString()).FirstOrDefault();
if (activityStateRecord.Activity != null && !string.IsNullOrEmpty(activityStateRecord.Activity.Id))
{
ActivityId = activityStateRecord.Activity.Id;
}
if (activityStateRecord.Activity != null && !string.IsNullOrEmpty(activityStateRecord.Activity.Name))
{
name = activityStateRecord.Activity.Name;
}
// var sw = new Stopwatch(); sw.Start();
Log.Activity(name + " " + activityStateRecord.State);
if (timers.ContainsKey(InstanceId.ToString()) && !string.IsNullOrEmpty(ActivityId))
{
var timer = timers[InstanceId.ToString()];
if (activityStateRecord.State == ActivityStates.Executing)
{
if (!timer.ContainsKey(ActivityId))
{
Stopwatch sw = new Stopwatch(); sw.Start();
timer.Add(ActivityId, sw);
var TypeName = activityStateRecord.Activity.TypeName;
var Name = activityStateRecord.Activity.Name;
if (String.IsNullOrEmpty(Name))
{
Name = TypeName;
}
if (TypeName.IndexOf("`") > -1)
{
TypeName = TypeName.Substring(0, TypeName.IndexOf("`"));
}
}
}
if (activityStateRecord.State != ActivityStates.Executing)
{
if (timer.ContainsKey(ActivityId))
{
Stopwatch sw = timer[ActivityId];
timer.Remove(ActivityId);
var TypeName = activityStateRecord.Activity.TypeName;
var Name = activityStateRecord.Activity.Name;
if (String.IsNullOrEmpty(Name))
{
Name = TypeName;
}
if (TypeName.IndexOf("`") > -1)
{
TypeName = TypeName.Substring(0, TypeName.IndexOf("`"));
}
}
}
}
if (activityStateRecord.Activity != null && !string.IsNullOrEmpty(activityStateRecord.Activity.Name) && Instance != null && Instance.Workflow != null)
{
var TypeName = activityStateRecord.Activity.TypeName;
if (TypeName.IndexOf("`") > -1)
{
TypeName = TypeName.Substring(0, TypeName.IndexOf("`"));
}
}
foreach (var v in activityStateRecord.Variables)
{
if (Instance.Variables.ContainsKey(v.Key))
{
Instance.Variables[v.Key].value = v.Value;
}
else
{
if (v.Value != null)
{
Instance.Variables.Add(v.Key, new WorkflowInstanceValueType(v.Value.GetType(), v.Value));
}
}
}
}
if (activityScheduledRecord != null)
{
var Instance = WorkflowInstance.Instances.Where(x => x.InstanceId == InstanceId.ToString()).FirstOrDefault();
if (Instance == null || Instance.wfApp == null)
{
return;
}
var wfApp = Instance.wfApp;
var executor = typeof(System.Activities.Hosting.WorkflowInstance).GetField("executor", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(wfApp);
var scheduler = executor.GetType().GetField("scheduler", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(executor);
string ActivityId = null;
string ChildActivityId = null;
if (activityStateRecord != null)
{
ActivityId = activityStateRecord.Activity.Id;
State = activityStateRecord.State.ToLower();
}
if (activityScheduledRecord != null)
{
State = "Scheduled";
if (activityScheduledRecord.Activity != null)
{
ActivityId = activityScheduledRecord.Activity.Id;
}
if (activityScheduledRecord.Child != null)
{
ChildActivityId = activityScheduledRecord.Child.Id;
}
}
if (activityScheduledRecord.Activity == null && activityScheduledRecord.Child != null)
{
// this will make "1" be handles twice, but "1" is always sendt AFTER being scheduled, but we can catch it here ?
ActivityId = activityScheduledRecord.Child.Id;
ChildActivityId = activityScheduledRecord.Child.Id;
}
if (string.IsNullOrEmpty(ActivityId))
{
return;
}
if (activityScheduledRecord.Child.Id == "1.11")
{
// scheduler.GetType().GetMethod("ClearAllWorkItems", BindingFlags.Public | BindingFlags.Instance).Invoke(scheduler, new object[] { executor });
// scheduler.GetType().GetMethod("ScheduleWork", BindingFlags.NonPublic | BindingFlags.Instance).Invoke(scheduler, new object[] { false });
//var firstWorkItem = scheduler.GetType().GetField("firstWorkItem", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(scheduler);
//firstWorkItem.GetType().GetMethod("Release", BindingFlags.Public | BindingFlags.Instance).Invoke(firstWorkItem, new object[] { executor });
//firstWorkItem.GetType().GetMethod("Dispose", BindingFlags.Public | BindingFlags.Instance).Invoke(firstWorkItem, new object[] { executor });
//scheduler.GetType().GetMethod("NotifyWorkCompletion", BindingFlags.NonPublic | BindingFlags.Instance).Invoke(scheduler, new object[] { });
}
if (Instance.Variables == null)
{
Instance.Variables = new Dictionary <string, WorkflowInstanceValueType>();
}
if (activityStateRecord != null)
{
foreach (var v in Instance.Variables.ToList())
{
if (!activityStateRecord.Variables.ContainsKey(v.Key))
{
Instance.Variables.Remove(v.Key);
}
}
foreach (var v in activityStateRecord.Variables)
{
if (Instance.Variables.ContainsKey(v.Key))
{
Instance.Variables[v.Key].value = v.Value;
}
}
}
var instanceMapField = executor.GetType().GetField("instanceMap", BindingFlags.NonPublic | BindingFlags.Instance);
// get SerializedProgramMapping to have InstanceMap get filled, needed by SerializedProgramMapping
var SerializedProgramMapping = executor.GetType().GetProperty("SerializedProgramMapping", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(executor);
ActivityInstance activityInstance = executor.GetType().GetField("rootInstance", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(executor) as ActivityInstance;
// Sometimes we can find the ActivityInstance in rootInstance
ActivityInstance result = findActivityInstance(executor, activityInstance, ActivityId);
// But more often, we find it in InstanceMapping
var instanceMap = instanceMapField.GetValue(executor);
if (instanceMap != null && result == null)
{
var _list = SerializedProgramMapping.GetType().GetProperty("InstanceMapping", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(SerializedProgramMapping);
foreach (System.Collections.DictionaryEntry kvp in (System.Collections.IDictionary)_list)
{
var a = kvp.Key as System.Activities.Activity;
if (a == null)
{
continue;
}
if (result == null && a.Id == ActivityId)
{
result = findActivityInstance(kvp.Value, ActivityId);
}
}
}
if (result != null)
{
WorkflowDataContext context = null;
var cs = typeof(WorkflowDataContext).GetConstructors(BindingFlags.NonPublic | BindingFlags.Instance);
ConstructorInfo c = cs.First();
try
{
object o = c.Invoke(new Object[] { executor, result, true });
context = o as WorkflowDataContext;
var vars = context.GetProperties();
foreach (dynamic v in vars)
{
var value = v.GetValue(context);
if (Instance.Variables.ContainsKey(v.DisplayName))
{
Instance.Variables[v.DisplayName] = new WorkflowInstanceValueType(v.PropertyType, value);
}
else
{
Instance.Variables.Add(v.DisplayName, new WorkflowInstanceValueType(v.PropertyType, value));
}
}
}
catch (Exception ex)
{
Log.Debug(ex.Message);
}
}
OnVisualTracking?.Invoke(Instance, ActivityId, ChildActivityId, State);
}
}
catch (Exception ex)
{
Log.Error(ex.ToString());
}
}
private static PropertyDescriptor GetBpContextPropertyDescriptor(WorkflowDataContext dataContext)
{
var properties = dataContext.GetProperties();
return(properties.Find(BpContext.BpContextArgumentName, true));
}
protected void Setup()
{
var options = new DbContextOptionsBuilder <WorkflowDataContext>()
.UseInMemoryDatabase(databaseName: "workflow-tets")
.Options;
var mockHttpContextAccessor = new Mock <IHttpContextAccessor>();
var user = new ClaimsPrincipal(new ClaimsIdentity(new Claim[]
{
new Claim(ClaimTypes.Name, "admin"),
new Claim(ClaimTypes.NameIdentifier, "1"),
}, "mock"));
var context = new DefaultHttpContext {
User = user
};
mockHttpContextAccessor.Setup(_ => _.HttpContext).Returns(context);
Context = new WorkflowDataContext(options, mockHttpContextAccessor.Object);
waitingApprovalStatus = new WorkflowStatus {
Name = "Waiting Approval"
};
approvedStatus = new WorkflowStatus {
Name = "Approved"
};
rejectedStatus = new WorkflowStatus {
Name = "Reject"
};
Type = new WorkflowType {
Name = "Workflow", IsActive = true
};
var approvedStep = new WorkflowApprovalStep {
IsActive = true, WorkflowStatus = approvedStatus
};
var rejectedStep = new WorkflowApprovalStep {
IsActive = true, WorkflowStatus = rejectedStatus
};
var firstStep = new WorkflowApprovalStep
{
NextStepApproved = approvedStep,
NextStepRejected = rejectedStep,
WorkflowStatus = waitingApprovalStatus,
IsActive = true,
IsFirstStep = true
};
Type.Steps.Add(firstStep);
Type.Steps.Add(approvedStep);
Type.Steps.Add(rejectedStep);
Context.WorkflowTypes.Add(Type);
Context.SaveChanges();
mockAuthService = new Mock <IAuthService>();
mockAuthService.Setup(_ => _.HasRoles(It.IsAny <string>(), It.IsAny <IEnumerable <int> >())).Returns(true);
var cache = new MemoryCache(new MemoryCacheOptions());
workflowCache = new WorkflowCache(cache, Context);
eventBus = new EventBus(new MockServiceProvider());
}
protected override void Execute(NativeActivityContext context)
{
WorkflowDataContext dataContext = context.DataContext;
PropertyDescriptorCollection propertyDescriptorCollection = dataContext.GetProperties();
string sessionId = string.Empty;
int fileSystemItemId = 0;
foreach (PropertyDescriptor propertyDesc in propertyDescriptorCollection)
{
if (propertyDesc.Name == "ArgSessionId")
{
sessionId = propertyDesc.GetValue(dataContext) as string;
break;
}
}
foreach (PropertyDescriptor propertyDesc in propertyDescriptorCollection)
{
if (propertyDesc.Name == "ArgFileSystemItemId")
{
fileSystemItemId = (int)propertyDesc.GetValue(dataContext);
break;
}
}
if (string.IsNullOrWhiteSpace(sessionId))
{
LogHelper.AddGeneralLog(GeneralLogTypeEnum.ActivityError, $"SessionId is null.");
return;
}
if (fileSystemItemId == 0)
{
LogHelper.AddSessionLog(SessionLogTypeEnum.ActivityError, sessionId, $"FileSystemItemId is null.");
return;
}
FileSystemItemDto fileSystemItem = null;
try
{
using (var sqlDbContext = new SqlDbContext())
{
fileSystemItem = sqlDbContext.FileSystemItems.FirstOrDefault(x => x.Id == fileSystemItemId);
}
}
catch (Exception ex)
{
LogHelper.AddSessionLog(SessionLogTypeEnum.ActivityError, sessionId, $"Exception has been thrown when getting fileSystemItem. FileSystemItemId: {fileSystemItemId}", ex);
return;
}
var targetFile = TargetFilePathForTextFile.Get(context);
int counter = 0;
while (true)
{
counter++;
if (File.Exists(targetFile))
{
var directory = Path.GetDirectoryName(targetFile);
var fileName = Path.GetFileNameWithoutExtension(targetFile);
var extension = Path.GetExtension(targetFile);
targetFile = Path.Combine(directory, fileName + counter + extension);
}
else
{
break;
}
}
try
{
TempData.Instance.TempPath = Path.GetTempPath();
using (PDFDoc doc = PDFDoc.Open(fileSystemItem.FullPath))
{
if (doc.GetText() == string.Empty)
{
doc.Ocr(OcrMode.Tesseract, "tur", WriteTextMode.Word);
doc.Save(TargetFilePathForPDFFile.Get(context));
var ocrText = doc.GetText();
File.WriteAllText(TargetFilePathForTextFile.Get(context), ocrText);
}
}
}
catch (Exception ex)
{
LogHelper.AddFileSystemItemLog(fileSystemItemId, fileSystemItem.SourceId, sessionId, FileSystemItemLogTypeEnum.StoppedWithError, $"Exception has been thrown in OCR operation. FileSystemItemId: {fileSystemItemId}", ex);
return;
}
LogHelper.AddFileSystemItemLog(fileSystemItem.Id, fileSystemItem.SourceId, sessionId, FileSystemItemLogTypeEnum.TesseractOcrOk);
Result.Set(context, true);
}
protected override void Execute(NativeActivityContext context)
{
WorkflowDataContext dataContext = context.DataContext;
PropertyDescriptorCollection propertyDescriptorCollection = dataContext.GetProperties();
string sessionId = string.Empty;
int fileSystemItemId = 0;
foreach (PropertyDescriptor propertyDesc in propertyDescriptorCollection)
{
if (propertyDesc.Name == "ArgSessionId")
{
sessionId = propertyDesc.GetValue(dataContext) as string;
break;
}
}
foreach (PropertyDescriptor propertyDesc in propertyDescriptorCollection)
{
if (propertyDesc.Name == "ArgFileSystemItemId")
{
fileSystemItemId = (int)propertyDesc.GetValue(dataContext);
break;
}
}
if (string.IsNullOrWhiteSpace(sessionId))
{
LogHelper.AddGeneralLog(GeneralLogTypeEnum.ActivityError, $"SessionId is null.");
return;
}
if (fileSystemItemId == 0)
{
LogHelper.AddSessionLog(SessionLogTypeEnum.ActivityError, sessionId, $"FileSystemItemId is null.");
return;
}
FileSystemItemDto fileSystemItem = null;
try
{
using (var sqlDbContext = new SqlDbContext())
{
fileSystemItem = sqlDbContext.FileSystemItems.FirstOrDefault(x => x.Id == fileSystemItemId);
}
}
catch (Exception ex)
{
LogHelper.AddSessionLog(SessionLogTypeEnum.ActivityError, sessionId, $"Exception has been thrown when getting fileSystemItem. FileSystemItemId: {fileSystemItemId}", ex);
return;
}
var targetFilePathForTextFile = TargetFilePathForTextFile.Get(context);
var targetFilePathForPDFFile = TargetFilePathForPDFFile.Get(context);
targetFilePathForTextFile = FileHelper.GetUnusedFileName(Path.GetDirectoryName(targetFilePathForTextFile), Path.GetFileName(targetFilePathForTextFile));
var dummyTiffFile = FileHelper.GetUnusedFileName(Path.GetTempPath(), Guid.NewGuid().ToString() + ".tiff");
// C:\Users\efeo\Downloads\ImageMagick-7.0.8-12-portable-Q16-x64\convert.exe -density 300 c:\AkisLog\A.pdf -depth 8 -strip -background white -alpha off c:\AkisLog\a.tiff
try
{
Process process = new Process();
ProcessStartInfo processStartInfo = new ProcessStartInfo
{
FileName = @"C:\Users\efeo\Downloads\ImageMagick-7.0.8-12-portable-Q16-x64\convert.exe",
Arguments = $"-density 300 {fileSystemItem.FullPath} -depth 8 -strip -background white -alpha off {dummyTiffFile}"
};
process.StartInfo = processStartInfo;
try
{
process.Start();
process.WaitForExit();
}
catch (Exception ex)
{
logger.Error(ex, $"Process error convert.");
return;
}
}
catch (Exception ex)
{
LogHelper.AddFileSystemItemLog(fileSystemItemId, fileSystemItem.SourceId, sessionId, FileSystemItemLogTypeEnum.StoppedWithError, $"Exception has been thrown in OCR operation. FileSystemItemId: {fileSystemItemId}", ex);
return;
}
var canOsman = false;
if (File.Exists(dummyTiffFile))
{
try
{
var fileInfo = new FileInfo(dummyTiffFile);
if (fileInfo.Length > 0)
{
canOsman = true;
}
}
catch (Exception ex)
{
logger.Error(ex, $"Check file error.");
return;
}
}
if (canOsman == false)
{
}
var tessData = "";
// "C:\Program Files (x86)\Tesseract-OCR\tesseract.exe" "c:\AkisLog\c.tiff" "c:\AkisLog\c" --tessdata-dir "C:\Program Files (x86)\Tesseract-OCR\tessdata" -l tur pdf
try
{
Process process = new Process();
ProcessStartInfo processStartInfo = new ProcessStartInfo
{
FileName = @"C:\Program Files (x86)\Tesseract-OCR\tesseract.exe",
Arguments = $"\"{dummyTiffFile}\" \"{targetFilePathForPDFFile}\" --tessdata-dir \"{tessData}\" -l tur pdf"
};
process.StartInfo = processStartInfo;
try
{
process.Start();
process.WaitForExit();
}
catch (Exception ex)
{
logger.Error(ex, $"Process error tesseract.");
return;
}
}
catch (Exception ex)
{
LogHelper.AddFileSystemItemLog(fileSystemItemId, fileSystemItem.SourceId, sessionId, FileSystemItemLogTypeEnum.StoppedWithError, $"Exception has been thrown in OCR operation. FileSystemItemId: {fileSystemItemId}", ex);
return;
}
LogHelper.AddFileSystemItemLog(fileSystemItem.Id, fileSystemItem.SourceId, sessionId, FileSystemItemLogTypeEnum.TesseractOcrOk);
Result.Set(context, true);
}