public static async Task<DataTable> CallSubroutine()
{
try
{
DataTable lRetDT = new DataTable("EmpTable");
lRetDT.Columns.Add("ID", typeof(Int32));
lRetDT.Columns.Add("Name", typeof(string));
lRetDT.Columns.Add("HireDate", typeof(DateTime));
U2Connection conn = CreateConnection.GetConnection();
await conn.OpenAsync();
U2Command command = conn.CreateCommand();
Console.WriteLine("Connected.........................");
command.CommandText = "CALL *HS.SALES*SELECT_SUBROUTINE(?,?)"; // UniVerse subroutine, returns multi-value data
command.Parameters.Clear();
command.CommandType = CommandType.StoredProcedure;
U2Parameter p1 = new U2Parameter();
p1.Direction = ParameterDirection.InputOutput;
p1.Value = "1";//INPUT
p1.ParameterName = "@arg1";
U2Parameter p2 = new U2Parameter();
p2.Direction = ParameterDirection.InputOutput;
p2.Value = "";//OUTPUT (multi-value data
p2.ParameterName = "@arg2";
command.Parameters.Add(p1);
command.Parameters.Add(p2);
await command.ExecuteNonQueryAsync();
string s1 = command.Parameters[0].Value.ToString();//INPUT
string s2 = command.Parameters[1].Value.ToString();// OUTPUT
p2.MV_To_DataTable(lRetDT);//Convert multi-value data to C# DataTable using Schema
conn.Close();
return lRetDT;
}
catch (Exception ee)
{
string lErr = ee.Message;
throw;
}
}
public static async Task <DataTable> CallSubroutine()
{
try
{
DataTable lRetDT = new DataTable("EmpTable");
lRetDT.Columns.Add("ID", typeof(Int32));
lRetDT.Columns.Add("Name", typeof(string));
lRetDT.Columns.Add("HireDate", typeof(DateTime));
U2Connection conn = CreateConnection.GetConnection();
await conn.OpenAsync();
U2Command command = conn.CreateCommand();
Console.WriteLine("Connected.........................");
command.CommandText = "CALL *HS.SALES*SELECT_SUBROUTINE(?,?)"; // UniVerse subroutine, returns multi-value data
command.Parameters.Clear();
command.CommandType = CommandType.StoredProcedure;
U2Parameter p1 = new U2Parameter();
p1.Direction = ParameterDirection.InputOutput;
p1.Value = "1";//INPUT
p1.ParameterName = "@arg1";
U2Parameter p2 = new U2Parameter();
p2.Direction = ParameterDirection.InputOutput;
p2.Value = "";//OUTPUT (multi-value data
p2.ParameterName = "@arg2";
command.Parameters.Add(p1);
command.Parameters.Add(p2);
await command.ExecuteNonQueryAsync();
string s1 = command.Parameters[0].Value.ToString(); //INPUT
string s2 = command.Parameters[1].Value.ToString(); // OUTPUT
p2.MV_To_DataTable(lRetDT); //Convert multi-value data to C# DataTable using Schema
conn.Close();
return(lRetDT);
}
catch (Exception ee)
{
string lErr = ee.Message;
throw;
}
}
public static async Task<string> CallSubroutine()
{
try
{
string lRetJsonData = string.Empty;
U2Connection conn = CreateConnection.GetConnection();
await conn.OpenAsync();
U2Command command = conn.CreateCommand();
Console.WriteLine("Connected.........................");
command.CommandText = "CALL *HS.SALES*SELECT_SUBROUTINE(?,?)"; // UniVerse subroutine, returns multi-value data
command.Parameters.Clear();
command.CommandType = CommandType.StoredProcedure;
U2Parameter p1 = new U2Parameter();
p1.Direction = ParameterDirection.InputOutput;
p1.Value = "1";//INPUT
p1.ParameterName = "@arg1";
U2Parameter p2 = new U2Parameter();
p2.Direction = ParameterDirection.InputOutput;
p2.Value = "";//OUTPUT (multi-value data
p2.ParameterName = "@arg2";
command.Parameters.Add(p1);
command.Parameters.Add(p2);
await command.ExecuteNonQueryAsync();
string s1 = command.Parameters[0].Value.ToString();//INPUT
string s2 = command.Parameters[1].Value.ToString();// OUTPUT
List <Employee> lRetEmpList = p2.MV_To_POCO<Employee>();//Convert multi-value data to C# POCO Class using Schema
lRetJsonData = Newtonsoft.Json.JsonConvert.SerializeObject(lRetEmpList);
conn.Close();
return lRetJsonData;
}
catch (Exception ee)
{
string lErr = ee.Message;
throw;
}
}
public static async Task <string> CallSubroutine()
{
try
{
string lRetJsonData = string.Empty;
U2Connection conn = CreateConnection.GetConnection();
await conn.OpenAsync();
U2Command command = conn.CreateCommand();
Console.WriteLine("Connected.........................");
command.CommandText = "CALL *HS.SALES*SELECT_SUBROUTINE(?,?)"; // UniVerse subroutine, returns multi-value data
command.Parameters.Clear();
command.CommandType = CommandType.StoredProcedure;
U2Parameter p1 = new U2Parameter();
p1.Direction = ParameterDirection.InputOutput;
p1.Value = "1";//INPUT
p1.ParameterName = "@arg1";
U2Parameter p2 = new U2Parameter();
p2.Direction = ParameterDirection.InputOutput;
p2.Value = "";//OUTPUT (multi-value data
p2.ParameterName = "@arg2";
command.Parameters.Add(p1);
command.Parameters.Add(p2);
await command.ExecuteNonQueryAsync();
string s1 = command.Parameters[0].Value.ToString(); //INPUT
string s2 = command.Parameters[1].Value.ToString(); // OUTPUT
List <Employee> lRetEmpList = p2.MV_To_POCO <Employee>(); //Convert multi-value data to C# POCO Class using Schema
lRetJsonData = Newtonsoft.Json.JsonConvert.SerializeObject(lRetEmpList);
conn.Close();
return(lRetJsonData);
}
catch (Exception ee)
{
string lErr = ee.Message;
throw;
}
}
public static async Task <string> CallSubroutine()
{
try
{
string lRet = string.Empty;
U2Connection conn = CreateConnection.GetConnection();
await conn.OpenAsync();
U2Command command = conn.CreateCommand();
Console.WriteLine("Connected.........................");
command.CommandText = "CALL *GETXMLSUB(?,?,?,?,?,?)"; // UniVerse subroutine
command.Parameters.Clear();
command.CommandType = CommandType.StoredProcedure;
U2Parameter p1 = new U2Parameter();
p1.Direction = ParameterDirection.InputOutput;
p1.Value = "LIST CUSTOMER";
p1.ParameterName = "@arg1";
U2Parameter p2 = new U2Parameter();
p2.Direction = ParameterDirection.InputOutput;
p2.Value = "";
p2.ParameterName = "@arg2";
U2Parameter p3 = new U2Parameter();
p3.Direction = ParameterDirection.InputOutput;
p3.Value = "";
p3.ParameterName = "@arg3";
U2Parameter p4 = new U2Parameter();
p4.Direction = ParameterDirection.InputOutput;
p4.Value = "";
p4.ParameterName = "@arg4";
U2Parameter p5 = new U2Parameter();
p5.Direction = ParameterDirection.InputOutput;
p5.Value = "";
p5.ParameterName = "@arg5";
U2Parameter p6 = new U2Parameter();
p6.Direction = ParameterDirection.InputOutput;
p6.Value = "";
p6.ParameterName = "@arg6";
command.Parameters.Add(p1);
command.Parameters.Add(p2);
command.Parameters.Add(p3);
command.Parameters.Add(p4);
command.Parameters.Add(p5);
command.Parameters.Add(p6);
await command.ExecuteNonQueryAsync();
string s1 = command.Parameters[0].Value.ToString(); //INPUT command
string s2 = command.Parameters[1].Value.ToString(); // INPUT command option
string lOutputValue = command.Parameters[2].Value.ToString(); // OUTPUT xml
string s4 = command.Parameters[3].Value.ToString(); //OUTPUT xsd
string s5 = command.Parameters[4].Value.ToString(); //OUTPUT msg #
string s6 = command.Parameters[5].Value.ToString(); //OUTPUT msg description
conn.Close();
return(lOutputValue);
}
catch (Exception ee)
{
string lErr = ee.Message;
throw;
}
}
static void Main(string[] args)
{
try
{
U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder();
conn_str.UserID = "user";
conn_str.Password = "******";
conn_str.Server = "localhost";
conn_str.Database = "HS.SALES";
conn_str.ServerType = "UNIVERSE";
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
U2Command command = con.CreateCommand();
command.CommandText = "CALL *GETXMLSUB(?,?,?,?,?,?)"; // UniVerse subroutine
command.Parameters.Clear();
command.CommandType = CommandType.StoredProcedure;
U2Parameter p1 = new U2Parameter();
p1.Direction = ParameterDirection.InputOutput;
p1.Value = "LIST CUSTOMER";
p1.ParameterName = "@arg1";
U2Parameter p2 = new U2Parameter();
p2.Direction = ParameterDirection.InputOutput;
p2.Value = "";
p2.ParameterName = "@arg2";
U2Parameter p3 = new U2Parameter();
p3.Direction = ParameterDirection.InputOutput;
p3.Value = "";
p3.ParameterName = "@arg3";
U2Parameter p4 = new U2Parameter();
p4.Direction = ParameterDirection.InputOutput;
p4.Value = "";
p4.ParameterName = "@arg4";
U2Parameter p5 = new U2Parameter();
p5.Direction = ParameterDirection.InputOutput;
p5.Value = "";
p5.ParameterName = "@arg5";
U2Parameter p6 = new U2Parameter();
p6.Direction = ParameterDirection.InputOutput;
p6.Value = "";
p6.ParameterName = "@arg6";
command.Parameters.Add(p1);
command.Parameters.Add(p2);
command.Parameters.Add(p3);
command.Parameters.Add(p4);
command.Parameters.Add(p5);
command.Parameters.Add(p6);
command.ExecuteNonQuery();
string s1 = command.Parameters[0].Value.ToString();//command
string s2 = command.Parameters[1].Value.ToString();// command option
string s3 = command.Parameters[2].Value.ToString(); // xml
string s4 = command.Parameters[3].Value.ToString(); //xsd
string s5 = command.Parameters[4].Value.ToString(); // msg #
string s6 = command.Parameters[5].Value.ToString(); // msg description
Console.WriteLine("Subroutine Output:" + s3 + Environment.NewLine);
Console.WriteLine("Subroutine Output:" + s4 + Environment.NewLine);
con.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
static void Main(string[] args)
{
try
{
U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder();
conn_str.UserID = "user";
conn_str.Password = "******";
conn_str.Server = "localhost";
conn_str.Database = "HS.SALES";
conn_str.ServerType = "UNIVERSE";
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
U2Command command = con.CreateCommand();
command.CommandText = "CALL *GETXMLSUB(?,?,?,?,?,?)"; // UniVerse subroutine
command.Parameters.Clear();
command.CommandType = CommandType.StoredProcedure;
U2Parameter p1 = new U2Parameter();
p1.Direction = ParameterDirection.InputOutput;
p1.Value = "LIST CUSTOMER";
p1.ParameterName = "@arg1";
U2Parameter p2 = new U2Parameter();
p2.Direction = ParameterDirection.InputOutput;
p2.Value = "";
p2.ParameterName = "@arg2";
U2Parameter p3 = new U2Parameter();
p3.Direction = ParameterDirection.InputOutput;
p3.Value = "";
p3.ParameterName = "@arg3";
U2Parameter p4 = new U2Parameter();
p4.Direction = ParameterDirection.InputOutput;
p4.Value = "";
p4.ParameterName = "@arg4";
U2Parameter p5 = new U2Parameter();
p5.Direction = ParameterDirection.InputOutput;
p5.Value = "";
p5.ParameterName = "@arg5";
U2Parameter p6 = new U2Parameter();
p6.Direction = ParameterDirection.InputOutput;
p6.Value = "";
p6.ParameterName = "@arg6";
command.Parameters.Add(p1);
command.Parameters.Add(p2);
command.Parameters.Add(p3);
command.Parameters.Add(p4);
command.Parameters.Add(p5);
command.Parameters.Add(p6);
command.ExecuteNonQuery();
string s1 = command.Parameters[0].Value.ToString(); //command
string s2 = command.Parameters[1].Value.ToString(); // command option
string s3 = command.Parameters[2].Value.ToString(); // xml
string s4 = command.Parameters[3].Value.ToString(); //xsd
string s5 = command.Parameters[4].Value.ToString(); // msg #
string s6 = command.Parameters[5].Value.ToString(); // msg description
Console.WriteLine("Subroutine Output:" + s3 + Environment.NewLine);
Console.WriteLine("Subroutine Output:" + s4 + Environment.NewLine);
con.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
public static async Task<string> CallSubroutine()
{
try
{
string lRet = string.Empty;
U2Connection conn = CreateConnection.GetConnection();
await conn.OpenAsync();
U2Command command = conn.CreateCommand();
Console.WriteLine("Connected.........................");
command.CommandText = "CALL *GETXMLSUB(?,?,?,?,?,?)"; // UniVerse subroutine
command.Parameters.Clear();
command.CommandType = CommandType.StoredProcedure;
U2Parameter p1 = new U2Parameter();
p1.Direction = ParameterDirection.InputOutput;
p1.Value = "LIST CUSTOMER";
p1.ParameterName = "@arg1";
U2Parameter p2 = new U2Parameter();
p2.Direction = ParameterDirection.InputOutput;
p2.Value = "";
p2.ParameterName = "@arg2";
U2Parameter p3 = new U2Parameter();
p3.Direction = ParameterDirection.InputOutput;
p3.Value = "";
p3.ParameterName = "@arg3";
U2Parameter p4 = new U2Parameter();
p4.Direction = ParameterDirection.InputOutput;
p4.Value = "";
p4.ParameterName = "@arg4";
U2Parameter p5 = new U2Parameter();
p5.Direction = ParameterDirection.InputOutput;
p5.Value = "";
p5.ParameterName = "@arg5";
U2Parameter p6 = new U2Parameter();
p6.Direction = ParameterDirection.InputOutput;
p6.Value = "";
p6.ParameterName = "@arg6";
command.Parameters.Add(p1);
command.Parameters.Add(p2);
command.Parameters.Add(p3);
command.Parameters.Add(p4);
command.Parameters.Add(p5);
command.Parameters.Add(p6);
await command.ExecuteNonQueryAsync();
string s1 = command.Parameters[0].Value.ToString();//INPUT command
string s2 = command.Parameters[1].Value.ToString();// INPUT command option
string lOutputValue = command.Parameters[2].Value.ToString(); // OUTPUT xml
string s4 = command.Parameters[3].Value.ToString(); //OUTPUT xsd
string s5 = command.Parameters[4].Value.ToString(); //OUTPUT msg #
string s6 = command.Parameters[5].Value.ToString(); //OUTPUT msg description
conn.Close();
return lOutputValue;
}
catch (Exception ee)
{
string lErr = ee.Message;
throw;
}
}
