public void Design(IActivityDesigner designer)
{
designer.AddInput("Excel File Path").WithDefaultValue(FieldValue_ExcelFilePath);
designer.AddInput("Has Header Row").WithBooleanBrowser().WithDefaultValue(FieldValue_HasHeaderRow);
designer.AddInput("Force mixed data to be converted to text").WithBooleanBrowser().WithDefaultValue(FieldValue_ForceMixedData).NotRequired();
designer.AddInput("TypeGuessRows").WithListBrowser(TypeGuessValues).WithDefaultValue(FieldValue_TypeGuessRows).NotRequired();
designer.AddInput("; Replacement").WithDefaultValue(FieldValue_SemiColonReplacement).NotRequired();
designer.AddInput("CSV Delimiter").WithDefaultValue(FieldValue_CSVDelimiter).NotRequired();
designer.AddInput("Sheet Name").WithDefaultValue(FieldValue_SheetName).NotRequired();
designer.AddOutput("Excel File Path").AsString();
designer.AddOutput("Full line as string with fields separated by ;").AsString();
designer.AddOutput("Number of rows").AsNumber();
designer.AddOutput("Has Header Row").AsString();
designer.AddOutput("Force mixed data to be converted to text").AsString();
designer.AddOutput("TypeGuessRows").AsNumber();
designer.AddOutput("Select filter").AsString();
designer.AddOutput("Where filter").AsString();
designer.AddOutput("; Replacement").AsString();
designer.AddOutput("CSV Delimiter").AsString();
designer.AddOutput("Sheet Name").AsString();
designer.AddFilter("Select filter").WithRelations(Relation.EqualTo);
designer.AddFilter("Where filter").WithRelations(Relation.EqualTo);
}
public void Design(IActivityDesigner designer)
{
OrchestratorContext sco = new OrchestratorContext(new Uri(Credentials.OrchestratorServiceURL));
sco.Credentials = new NetworkCredential(Credentials.UserName, Credentials.Password, Credentials.Domain);
sco.MergeOption = MergeOption.OverwriteChanges;
string[] SummaryString = SCOrch.getOrchestartorEventSummaries(sco);
if (SummaryString.Length > 0)
{
designer.AddFilter("Summary").WithRelations(Relation.Contains | Relation.EqualTo).WithListBrowser(SummaryString);
}
else
{
designer.AddFilter("Summary").WithRelations(Relation.Contains | Relation.EqualTo);
}
designer.AddFilter("CreationTime").WithRelations(Relation.After | Relation.Before);
designer.AddCorellatedData(typeof(EventInst));
designer.AddOutput("Number of Events");
}
