protected override async Task <Action <AsyncCodeActivityContext> > ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)
{
// Inputs
var excelFilePath = ExcelFilePath.Get(context);
var sapProcessName = SAPProcessName.Get(context);
var xmlFolderPath = XMLFolderPath.Get(context);
var xmlFilePath = string.Empty;
XmlDocument doc = null;
ExcelToXMLConverter excelToXMLConverter = new ExcelToXMLConverter();
if (!string.IsNullOrEmpty(xmlFolderPath))
{
xmlFilePath = excelToXMLConverter.ConvertExcelToXMLFile(excelFilePath, sapProcessName, xmlFolderPath);
}
else
{
doc = excelToXMLConverter.ConvertExcelToXMLDocument(excelFilePath, sapProcessName);
}
// Outputs
return((ctx) => {
XMLDocument.Set(ctx, doc);
XMLPath.Set(ctx, xmlFilePath);
});
}
static void Main(string[] args)
{
ExcelToXMLConverter excelToXMLConverter = new ExcelToXMLConverter();
var xmlDocument = excelToXMLConverter.ConvertExcelToXMLDocument("BAPI_SALESORDER_CREATEFROMDAT2.xlsx", "BAPI_SALESORDER_CREATEFROMDAT2");
SAPXmlConverter sAPXmlConverter = new SAPXmlConverter();
var output = sAPXmlConverter.ProcessXMLForSAPBapi("", xmlDocument);
}