public static async Task <IActionResult> WorkflowDelete(
[HttpTrigger(AuthorizationLevel.Anonymous, "delete", Route = "workflows/{workflowId}")] HttpRequest req,
ILogger log, int workflowId)
{
using (var da = new WorkflowDataAccess(conStr))
{
await da.DeleteAsync(workflowId);
return(new OkObjectResult(new { Message = "Delete successfully" }));
}
}
public void all_snowman_material_supplier_event_types_accounted_for()
{
var dataAccess = new WorkflowDataAccess();
Guid[] appTenantIds = GetAppTenantIds().ToArray();
Dictionary <Guid, IReadOnlyDictionary <string, IEnumerable <OutgoingCall> > > workflows =
appTenantIds.ToDictionary(x => x, x => dataAccess.GetWorkflow(x));
IEnumerable <string> eventTypes = GetEventTypes(typeof(SnowmanMaterialSupplier.Surface.Definitions.EventTypes));
Assert.IsTrue(appTenantIds.All(x => eventTypes.All(y => workflows[x].ContainsKey(y) && workflows[x][y] != null)));
}
public static async Task <IActionResult> Workflow_ScheduleOperation(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = "projects/{projectId}/workflows/{workflowId}/schedule-operation")] HttpRequest req,
ILogger log, int projectId, int workflowId)
{
using (var da = new WorkflowDataAccess(conStr))
{
var results = await da.GetOperations(workflowId);
if (results.Any())
{
}
return(new OkObjectResult(await da.GetByProject(projectId)));
}
}
public static async Task <IActionResult> WorkflowCreate(
[HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = "projects/{projectId}/workflows")] HttpRequest req,
ILogger log, int projectId)
{
string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
dynamic data = JsonConvert.DeserializeObject <Workflow>(requestBody);
using (var da = new WorkflowDataAccess(conStr))
{
var result = await da.CreateAsync(data);
if (result != null)
{
await da.MarkWorkflowActiveAsync(result.Id, projectId);
}
return(new OkObjectResult(result));
}
}
public static async Task <IActionResult> WorkflowConnectorGet(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = "workflows/{workflowId}/connectors")] HttpRequest req,
ILogger log, int workflowId)
{
using (var da = new WorkflowDataAccess(conStr))
{
var workflow = await da.Get(workflowId);
if (workflow != null)
{
await da.MarkWorkflowActiveAsync(workflow.Id, workflow.ProjectId);
}
}
using (var da = new WorkflowConnectorDataAccess(conStr))
{
return(new OkObjectResult(await da.GetByWorkflow(workflowId)));
}
}
public static async Task <IActionResult> WorkflowGet(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = "projects/{projectId}/workflows")] HttpRequest req,
ILogger log, int projectId)
{
using (var da = new WorkflowDataAccess(conStr))
{
var results = await da.GetByProject(projectId);
if (results != null)
{
if (results.Count() == 1)
{
await da.MarkWorkflowActiveAsync(results.FirstOrDefault().Id, projectId);
}
}
return(new OkObjectResult(await da.GetByProject(projectId)));
}
}
public async Task <object> RunOperation()
{
using (var da = new WorkflowDataAccess(_conStr))
{
var operations = await da.GetOperations(_workflowId);
var transformationPayload = operations.Where(o => o.Name == "Transformation Payload").FirstOrDefault();
if (operations.Any())
{
List <IDictionary <string, object> > transformedList = new List <IDictionary <string, object> >();
dynamic salesforceResult = null;
foreach (var item in operations)
{
var excelList = new List <Dictionary <string, object> >();
switch (item.Type.ToString())
{
case "Salesforce":
if (item.Pos == 0)
{
var sfService = new SalesforceService(_conStr, _workflowId);
var intermediateJson = JsonConvert.DeserializeObject <string>(item.Content);
if (!string.IsNullOrWhiteSpace(intermediateJson) && intermediateJson.Contains("SELECT"))
{
salesforceResult = await sfService.ExecuteSourceOperation(intermediateJson);
}
}
else if (item.Name == "Salesforce Target Object Selection")
{
var sfService = new SalesforceService(_conStr, _workflowId);
salesforceResult = await sfService.ExecuteTargetOperation(item, transformedList);
}
break;
case "Excel":
var excelService = new ExcelService(_conStr, _workflowId);
if (item.Pos == 0)
{
excelList = (await excelService.ExecuteSourceOperation(item)).ToList();
}
else
{
var content = JsonConvert.DeserializeObject <ExcelConfig>(item.Content);
if (!string.IsNullOrWhiteSpace(content.FileName))
{
var blobFileName = await excelService.ExecuteTargetOperation(content.FileName, salesforceResult);
if (!string.IsNullOrWhiteSpace(blobFileName))
{
using (var ds = new DocumentService())
{
await ds.CreateDocument(content.FileName, "", null, ".xls", _workflowId, blobFileName);
return(new
{
localFileSystem = content.IsLocalFileSystem,
fileName = blobFileName
});
}
}
}
}
break;
default:
break;
}
if (item.Pos == 0 && excelList.Any())
{
var tService = new TransformationService(_conStr, _workflowId);
transformedList = (await tService.ExecuteOperation(transformationPayload, excelList)).Take(1).ToList();
}
}
}
}
return(new
{
Success = false,
Message = "Operation Unsuccesfully"
});;
}
