public static dynamic ExecuteBAPI(InputBAPI Input)
{
DataSet resultDataSet;
Dictionary <String, String> connectionParams = new Dictionary <string, string>();
String[] connectionStringArray = Input.ConnectionString.Split(';');
foreach (String configEntry in connectionStringArray)
{
connectionParams.Add(configEntry.TrimEnd().TrimStart().Split('=')[0], configEntry.TrimEnd().TrimStart().Split('=')[1]);
}
using (var connection = new SapConnection(connectionParams))
{
connection.Open();
var command = new SapCommand(Input.BAPIName, connection);
foreach (Parameter param in Input.Parameters)
{
command.Parameters.Add(param.Name, param.Value);
}
resultDataSet = command.ExecuteDataSet();
}
return(JToken.FromObject(resultDataSet));
}
static void Main(string[] args)
{
using (var connection = new SapConnection("DEV"))
{
connection.Open();
var session = new SapSession(connection);
//var transaction = connection.BeginTransaction();
var command = new SapCommand("BAPI_GET_PROJECT_DETAILS_TABLE", connection);
command.Parameters.Add("PROJECT_TYPE","EP");
session.StartSession();
var resultDataSet = command.ExecuteDataSet();
session.EndSession();
var sapDataReader = command.ExecuteReader("RESULTS");
var i = 0;
while(sapDataReader.Read())
{
Console.WriteLine("{0} : {1}",i,sapDataReader.Item.GetString(0));
i++;
}
Console.WriteLine(sapDataReader.RowCount);
//transaction.Commit();
//var rfcTables = command.ExecuteRfcTables();
}
Console.WriteLine("Done !");
Console.ReadKey();
}
static void Main(string[] args)
{
using (var connection = new SapConnection("DEV"))
{
connection.Open();
var session = new SapSession(connection);
//var transaction = connection.BeginTransaction();
var command = new SapCommand("BAPI_GET_PROJECT_DETAILS_TABLE", connection);
command.Parameters.Add("PROJECT_TYPE", "EP");
session.StartSession();
var resultDataSet = command.ExecuteDataSet();
session.EndSession();
var sapDataReader = command.ExecuteReader("RESULTS");
var i = 0;
while (sapDataReader.Read())
{
Console.WriteLine("{0} : {1}", i, sapDataReader.Item.GetString(0));
i++;
}
Console.WriteLine(sapDataReader.RowCount);
//transaction.Commit();
//var rfcTables = command.ExecuteRfcTables();
}
Console.WriteLine("Done !");
Console.ReadKey();
}