public string ExecutePlSql(string partNo, string description, string unitCode)
{
string resultString;
// CREATE OR REPLACE PACKAGE BODY C_PART_CATALOG_API IS
//-----------------------------------------------------------------------------
//-------------------- LU SPECIFIC PUBLIC METHODS -----------------------------
//-----------------------------------------------------------------------------
// PROCEDURE Create_Part_Catalog(part_no_ IN VARCHAR2,
// description_ IN VARCHAR2,
// unit_code_ IN VARCHAR2)
string sqlCommand = @"C_PART_CATALOG_API.Create_Part_Catalog(:PART_NO,:DESC,:UNIT_CODE)";
try
{
FndPLSQLCommand command = new FndPLSQLCommand(_connection, sqlCommand);
command.BindVariables.AddFndTextVariable("PART_NO", partNo, FndBindVariableDirection.In);
command.BindVariables.AddFndTextVariable("DESC", description, FndBindVariableDirection.In);
command.BindVariables.AddFndTextVariable("UNIT_CODE", unitCode, FndBindVariableDirection.In);
command.ExecuteNonQuery();
resultString = "SUSCCESS";
}
catch (Exception ex)
{
resultString = String.Format("{0}\n{1}", ex.Message, (ex.InnerException != null ? ex.InnerException.Message : ""));
}
return(resultString);
}
/// <summary>
/// Task for performing commands using IFS Access Provider: http://ifsscan-odemo-2.cloudapp.net/ifsdoc/f1doc/foundation1/050_development/default.htm
/// See documentation at https://github.com/CommunityHiQ/Frends.Community.IFSAccessProvider
/// </summary>
/// <param name="commandInput"></param>
/// <param name="connection"></param>
/// <param name="cancellationToken"></param>
/// <returns>Object { bool Success, string Result, string Message }</returns>
public static Output Command([PropertyTab] CommandProperties commandInput, [PropertyTab] ConnectionProperties connection, CancellationToken cancellationToken)
{
var conn = new FndConnection(connection.Address, connection.Username, connection.Password)
{
AsynchronousMode = connection.AsynchronousMode,
ConnectionTimeout = connection.TimeoutSeconds,
CatchExceptions = false
};
var command = new FndPLSQLCommand(conn, commandInput.Command);
foreach (var param in commandInput.Parameters)
{
command.BindVariables.Add(Extensions.CreateFndParameter(param));
}
command.ExecuteNonQuery();
return(new Output {
Result = "Command executed", Success = true, Message = null
});
}
public string ExecutePlSql(string partNo, string description, string unitCode )
{
string resultString;
// CREATE OR REPLACE PACKAGE BODY C_PART_CATALOG_API IS
//-----------------------------------------------------------------------------
//-------------------- LU SPECIFIC PUBLIC METHODS -----------------------------
//-----------------------------------------------------------------------------
// PROCEDURE Create_Part_Catalog(part_no_ IN VARCHAR2,
// description_ IN VARCHAR2,
// unit_code_ IN VARCHAR2)
string sqlCommand = @"C_PART_CATALOG_API.Create_Part_Catalog(:PART_NO,:DESC,:UNIT_CODE)";
try
{
FndPLSQLCommand command = new FndPLSQLCommand(_connection, sqlCommand);
command.BindVariables.AddFndTextVariable("PART_NO", partNo, FndBindVariableDirection.In);
command.BindVariables.AddFndTextVariable("DESC", description, FndBindVariableDirection.In);
command.BindVariables.AddFndTextVariable("UNIT_CODE", unitCode, FndBindVariableDirection.In);
command.ExecuteNonQuery();
resultString = "SUSCCESS";
}
catch (Exception ex)
{
resultString = String.Format("{0}\n{1}", ex.Message, (ex.InnerException != null ? ex.InnerException.Message : ""));
}
return resultString;
}