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.........................");
con.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
if (e.InnerException != null)
{
Console.WriteLine(e.InnerException.Message);
}
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
public static List <Orders> ReadExistingOrders(String OrderID)
{
List <Orders> Cart = new List <Orders>();
OrderID = OrderID;
string connection = ConfigurationManager.AppSettings["MVWriter"];
U2Connection con = new U2Connection();
con.ConnectionString = connection;
con.Open();
U2Command cmd = con.CreateCommand();
cmd.CommandText = "SELECT PROD, QUAN, COST FROM UNNEST SHOPPINGCART ON CARTS WHERE RECID = '" + OrderID + "'";
DataSet ds = new DataSet();
U2DataAdapter da = new U2DataAdapter(cmd);
da.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Orders ExistingLineItems = new Orders {
Cost = dr["COST"].ToString(), Quantity = dr["QUAN"].ToString(), Serial = dr["PROD"].ToString()
};
Cart.Add(ExistingLineItems);
}
con.Close();
return(Cart);
}
private void ExecuteCommand(U2Connection con)
{
try
{
if (settings.AccessMode == "Native")
{
// Native mode
UniSession us1 = con.UniSession;
UniCommand uniCmd = us1.CreateUniCommand();
uniCmd.Command = settings.CommandText;
uniCmd.Execute();
// Get response string but not output
string strNative = uniCmd.Response;
}
else
{
// SQL mode
U2Command cmd = con.CreateCommand();
cmd.Connection = con;
cmd.CommandText = settings.CommandText;
cmd.ExecuteNonQuery();
}
}
catch (System.Exception ex)
{
throw ex;
}
finally
{
}
}
public static async Task <List <Customer> > CallSubroutine()
{
try
{
List <Customer> lRetList = new List <Customer>();
U2Connection conn = CreateConnection.GetConnection();
await conn.OpenAsync();
U2Command command = conn.CreateCommand();
Console.WriteLine("Connected.........................");
command.CommandText = "CALL *HS.SALES*GETCUSTOMER()"; // UniVerse subroutine, returns multi-value data
U2DataReader dr = await command.ExecuteReaderAsync();
while (await dr.ReadAsync())
{
Customer lCust = new Customer();
lCust.CustomerId = await dr.GetFieldValueAsync <int>(0);
lCust.FirstName = await dr.GetFieldValueAsync <string>(1);
lCust.LastName = await dr.GetFieldValueAsync <string>(2);
lRetList.Add(lCust);
}
conn.Close();
return(lRetList);
}
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.........................");
con.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
if (e.InnerException != null)
{
Console.WriteLine(e.InnerException.Message);
}
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
this.textBox1.Clear();
var connection_str = System.Configuration.ConfigurationManager.ConnectionStrings["DEMO_UD"];
string s = connection_str.ConnectionString;
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
this.textBox1.AppendText("Connected.........................(UniData Account)" + Environment.NewLine);
U2Command cmd = con.CreateCommand();
cmd.CommandText = "SELECT ID, FNAME,LNAME FROM STUDENT_NF_SUB";
DataSet ds = new DataSet();
m_da = new U2DataAdapter(cmd);
m_da.Fill(ds);
m_U2CommandBuilder = new U2CommandBuilder(m_da);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
this.textBox1.AppendText("Done........................." + Environment.NewLine);
}
catch (Exception e3)
{
this.textBox1.AppendText(e3.Message);
MessageBox.Show(e3.Message);
}
}
private void ExecuteDataReader(U2Connection con)
{
try
{
if (settings.AccessMode == "Native")
{
// Need to confirm how to use UniDataSet
}
else
{
U2Command cmd = con.CreateCommand();
cmd.Connection = con;
cmd.CommandText = settings.CommandText;
U2DataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
// Do something
}
}
}
catch (System.Exception ex)
{
throw ex;
}
}
private void ExecuteDataSet(U2Connection con)
{
try
{
if (settings.AccessMode == "Native")
{
// Need to confirm how to use UniDataSet
}
else
{
U2Command cmd = con.CreateCommand();
cmd.Connection = con;
cmd.CommandText = settings.CommandText;
U2DataAdapter da = new U2DataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
}
}
catch (System.Exception ex)
{
throw ex;
}
}
public async Task <string> QueryUsers(int pageNumber, int pageSize)
{
string lRetJsonData = string.Empty;
try
{
U2ConnectionStringBuilder l = new U2ConnectionStringBuilder();
l.UserID = "admjjin";
l.Password = "******";
l.Server = "192.168.102.132";
l.Database = "HS.SALES";
l.ServerType = "universe";
l.Connect_Timeout = 360;
l.RpcServiceType = "uvcs";
l.AccessMode = "Native";
string lconnstr = l.ToString();
U2Connection c = new U2Connection();
c.ConnectionString = lconnstr;
await c.OpenAsync();
U2Command cmd = c.CreateCommand();
cmd.CommandText = string.Format("Action=Select;File=CUSTOMER;Attributes=CUSTID,FNAME,LNAME,PRODID,BUY_DATE;Where=CUSTID>0;Sort=CUSTID");
lRetJsonData = await cmd.ExecuteJsonAsync();
c.Close();
}
catch (Exception ee)
{
throw ee;
}
return(lRetJsonData);
}
public Boolean connect(string host, String user, String path, String pass, String service, ref String errText)
{
if (service == String.Empty)
{
service = "uvcs";
}
conn = new U2Connection();
U2ConnectionStringBuilder connBuilder = new U2ConnectionStringBuilder();
connBuilder.Server = host;
connBuilder.UserID = user;
connBuilder.Password = pass;
connBuilder.Database = path;
connBuilder.ServerType = "UNIVERSE";
connBuilder.AccessMode = "Native"; // FOR UO
connBuilder.RpcServiceType = service; // FOR UO
connBuilder.Pooling = false;
try {
conn.ConnectionString = connBuilder.ToString();
conn.Open();
_sess = conn.UniSession;
} catch (Exception ex) {
_sess = null;
errText = ex.Message;
return(false);
}
return(true);
}
private void button2_Click(object sender, EventArgs e)
{
try
{
this.textBox1.Clear();
var connection_str = System.Configuration.ConfigurationManager.ConnectionStrings["DEMO_UD"];
string s = connection_str.ConnectionString;
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
this.textBox1.AppendText("Connected.........................(UniData Account)" + Environment.NewLine);
U2Command cmd = con.CreateCommand();
cmd.CommandText = "SELECT ID, FNAME,LNAME FROM STUDENT_NF_SUB";
DataSet ds = new DataSet();
m_da = new U2DataAdapter(cmd);
m_da.Fill(ds);
m_U2CommandBuilder = new U2CommandBuilder(m_da);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
this.textBox1.AppendText("Done........................." + Environment.NewLine);
}
catch (Exception e3)
{
this.textBox1.AppendText(e3.Message);
MessageBox.Show(e3.Message);
}
}
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.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "uvcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
// get RECID
UniSession us1 = con.UniSession;
UniSelectList sl = us1.CreateUniSelectList(2);
// Select UniFile
UniFile fl = us1.CreateUniFile("CUSTOMER");
sl.Select(fl);
bool lLastRecord = sl.LastRecordRead;
List <string> lRecIdList = new List <string>();
while (!lLastRecord)
{
string sRecID = sl.Next();
lRecIdList.Add(sRecID);
Console.WriteLine("Record ID:" + sRecID);
lLastRecord = sl.LastRecordRead;
}
UniDataSet uSet = fl.ReadRecords(lRecIdList.ToArray());
// use for each statement to print the record
foreach (UniRecord item in uSet)
{
Console.WriteLine(item.ToString());
}
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 = "demo";
conn_str.ServerType = "UNIDATA";
conn_str.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "udcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
// get RECID
UniSession us1 = con.UniSession;
UniSelectList sl = us1.CreateUniSelectList(2);
// Select UniFile
UniFile fl = us1.CreateUniFile("STUDENT");
sl.Select(fl);
bool lLastRecord = sl.LastRecordRead;
while (!lLastRecord)
{
string s2 = sl.Next();
Console.WriteLine("Record ID:" + s2);
lLastRecord = sl.LastRecordRead;
}
con.Close();
}
catch (Exception e)
{
string s = e.Message;
if (e.InnerException != null)
{
s += e.InnerException.Message;
}
Console.WriteLine(s);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
public void disconnect()
{
if (conn != null)
{
conn.Close();
conn = null;
_sess = null;
}
}
/// <summary>
/// Close active connection
/// </summary>
private void DoDisconnection()
{
if (con != null && con.State == ConnectionState.Open)
{
con.Close();
con.Dispose();
con = null;
}
}
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.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "uvcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
UniSession us1 = con.UniSession;
string RoutineName = "!TIMDAT";
int IntTotalAtgs = 1;
string[] largs = new string[IntTotalAtgs];
largs[0] = "1";
UniDynArray tmpStr2;
UniSubroutine sub = us1.CreateUniSubroutine(RoutineName, IntTotalAtgs);
for (int i = 0; i < IntTotalAtgs; i++)
{
sub.SetArg(i, largs[i]);
}
sub.Call();
tmpStr2 = sub.GetArgDynArray(0);
string result = "\n" + "Result is :" + tmpStr2;
Console.WriteLine(" Response from UniSubRoutineSample :" + result);
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.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "uvcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
// get RECID
UniSession us1 = con.UniSession;
UniSelectList sl = us1.CreateUniSelectList(2);
// Select UniFile
UniFile fl = us1.CreateUniFile("CUSTOMER");
sl.Select(fl);
bool lLastRecord = sl.LastRecordRead;
while (!lLastRecord)
{
string s2 = sl.Next();
Console.WriteLine("Record ID:" + s2);
lLastRecord = sl.LastRecordRead;
}
con.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
/// <summary>
/// Get an U2 connection object
/// </summary>
/// <returns></returns>
private U2Connection GetU2Connection()
{
U2ConnectionStringBuilder conStr = new U2ConnectionStringBuilder();
// Login settings
conStr.UserID = settings.UserName;
conStr.Password = settings.Password;
conStr.Server = settings.Server;
conStr.Database = settings.Database;
conStr.ServerType = settings.ServerType;
conStr.Connect_Timeout = settings.ConnTimeOut;
conStr.ConnectionLifeTime = settings.ConnLifeTime;
// Access mode
if (settings.AccessMode == "Native")
{
conStr.AccessMode = settings.AccessMode;
if (conStr.ServerType == "UNIDATA")
{
conStr.RpcServiceType = "udcs";
}
else
{
conStr.RpcServiceType = "uvcs";
}
}
else
{
// If not Native mode and set the property like bellow, an error occurred
//conStr.AccessMode = "Uci"; // settings.AccessMode;
//conStr.RpcServiceType = "defcs"; // settings.RpcServiceType;
}
// SSL settings
conStr.SSLConnection = settings.EnableSSLConnection;
if (conStr.SSLConnection == true)
{
conStr.SslIgnoreCertificateNameMismatch = settings.EnableSSLIgnCertNameMismatch;
if (settings.CertificateFilePath.Length > 0)
{
conStr.ClientCertificatePath = settings.CertificateFilePath;
}
conStr.SslIgnoreIncompleteCertificateChain = settings.EnableSSLIgnIncompCertChain;
conStr.SslCheckCertificateRevocation = settings.EnableSSLChkCertRevocation;
}
U2Connection con = new U2Connection();
con.ConnectionString = conStr.ToString();
return(con);
}
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.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "uvcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
UniSession us1 = con.UniSession;
string RoutineName = "!TIMDAT";
int IntTotalAtgs = 1;
string[] largs = new string[IntTotalAtgs];
largs[0] = "1";
UniDynArray tmpStr2;
UniSubroutine sub = us1.CreateUniSubroutine(RoutineName, IntTotalAtgs);
for (int i = 0; i < IntTotalAtgs; i++)
{
sub.SetArg(i, largs[i]);
}
sub.Call();
tmpStr2 = sub.GetArgDynArray(0);
string result = "\n" + "Result is :" + tmpStr2;
Console.WriteLine(" Response from UniSubRoutineSample :" + result);
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 = "demo";
conn_str.ServerType = "UNIDATA";
conn_str.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "udcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
UniSession us1 = con.UniSession;
UniCommand cmd = us1.CreateUniCommand();
cmd.Command = "LIST STUDENT ALL SAMPLE 10";
cmd.Execute();
string response_str = cmd.Response;
Console.WriteLine("UniCommand Output" + response_str + Environment.NewLine);
con.Close();
}
catch (Exception e)
{
string s = e.Message;
if (e.InnerException != null)
{
s += e.InnerException.Message;
}
Console.WriteLine(s);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
public ActionResult Index()
{
List <APMST> sample = new List <APMST>();
try
{
string s = ConfigurationManager.AppSettings["TESTString"];
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
U2Command cmd = con.CreateCommand();
cmd.CommandText = "SELECT PROD,SALE, DESC1 FROM IVMST"; // FNAME = SingleValue, PRICE = multivalue
DataSet ds = new DataSet();
U2DataAdapter da = new U2DataAdapter(cmd);
da.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
//APMST loadRecord = new APMST { NAME = dr["NAME"].ToString() };
APMST loadRecord = new APMST {
NAME = dr["PROD"].ToString()
};
sample.Add(loadRecord);
}
con.Close();
}
catch (Exception e)
{
// Console.WriteLine(e.Message);
if (e.InnerException != null)
{
}
}
finally
{
// string line = Console.ReadLine();
}
return(View(sample));
}
/// <summary>
/// Create and open connection
/// </summary>
private void DoConnection()
{
try
{
// Close current connection if exists
DoDisconnection();
con = GetU2Connection();
con.Open();
}
catch (Exception e)
{
throw e;
}
}
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 ActionResult GetProduct(string term)
{
List <Product> ProductsFound = new List <Product>();
string Upperterm = term.ToUpper();
try
{
string s = ConfigurationManager.AppSettings["TESTString"];
U2Connection con = new U2Connection();
U2Command cmd = con.CreateCommand();
con.ConnectionString = s;
con.Open();
cmd.CommandText = "SELECT PROD,SALE, DESC1 FROM IVMST WHERE UPPER(DESC1) LIKE '%" + Upperterm + "%'";
U2DataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Product ProductList = new Product {
DESC1 = dr["DESC1"].ToString(),
PROD = dr["PROD"].ToString(),
SALE = dr["SALE"].ToString()
};
ProductsFound.Add(ProductList);
}
con.Close();
}
catch (Exception e)
{
// Console.WriteLine(e.Message);
if (e.InnerException != null)
{
}
}
finally
{
// string line = Console.ReadLine();
}
return(Json(ProductsFound, JsonRequestBehavior.AllowGet));
}
public static U2Connection GetConnection()
{
U2ConnectionStringBuilder l = new U2ConnectionStringBuilder();
l.UserID = "admin";
l.Password = "******";
l.Server = "9.21.45.89";
l.Database = "HS.SALES";
l.ServerType = "universe";
l.Connect_Timeout = 360;
l.AccessMode = "Uci";
string lconnstr = l.ToString();
U2Connection conn = new U2Connection();
conn.ConnectionString = lconnstr;
return conn;
}
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 = "demo";
conn_str.ServerType = "UNIDATA";
conn_str.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "udcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
UniSession us1 = con.UniSession;
UniCommand cmd = us1.CreateUniCommand();
cmd.Command = "LIST STUDENT ALL SAMPLE 10";
cmd.Execute();
string response_str = cmd.Response;
Console.WriteLine("UniCommand Output" + response_str + Environment.NewLine);
con.Close();
}
catch (Exception e)
{
string s = e.Message;
if (e.InnerException != null)
{
s += e.InnerException.Message;
}
Console.WriteLine(s);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
public static bool UpdateProducts(List <Orders> Cart, string OrderID, string Product)
{
try
{
int lRecID = 99;
U2ConnectionStringBuilder conn_bldr = new U2ConnectionStringBuilder();
conn_bldr.UserID = "administrator";
conn_bldr.Password = "******";
conn_bldr.Server = "myserver";
conn_bldr.ServerType = "universe";
conn_bldr.Database = "HS.SALES";
conn_bldr.AccessMode = "Native";
conn_bldr.RpcServiceType = "uvcs";
string lConnStr = conn_bldr.ConnectionString;
U2Connection lConn = new U2Connection();
lConn.ConnectionString = lConnStr;
lConn.Open();
UniSession lUniSession = lConn.UniSession;
U2Command cmd = lConn.CreateCommand();
//CUSTID,FNAME,LNAME : Single Value
//PRODID, BUY_DATE : Multi Value
//Syntax : Action=Update;File=?;Attributes=?;Where=?;Sort
UniDynArray lArr = new UniDynArray(lUniSession, "2/1/1991");
lArr.Insert(1, -1, "3/9/1991");
lArr.Insert(1, -1, "4/1/1991");
string lCmd = string.Format("UPDATE SHOPPINGCART SET FNAME={0},BUY_DATE='{1}' WHERE CUSTID={2} ", "Fred2", lArr.StringValue, lRecID);
cmd.CommandText = lCmd;
int l2 = cmd.ExecuteNonQuery();
lConn.Close();
}
catch (Exception e2)
{
string lErr = e2.Message;
if (e2.InnerException != null)
{
lErr += lErr + e2.InnerException.Message;
}
}
return(true);
}
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;
}
}
static void Main(string[] args)
{
try
{
Console.WriteLine("start.........................");
Stopwatch sw = new Stopwatch();
sw.Start();
U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder();
conn_str.UserID = "administrator";
conn_str.Password = "******";
conn_str.Server = "localhost";
conn_str.Database = "XDEMO";
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 cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM PRODUCTS";
DataSet ds = new DataSet();
U2DataAdapter da = new U2DataAdapter(cmd);
da.Fill(ds);
sw.Stop();
TimeSpan elapsed = sw.Elapsed;
string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", elapsed.Hours, elapsed.Minutes, elapsed.Seconds, elapsed.Milliseconds / 10);
int nSec = elapsed.Seconds;
con.Close();
Console.WriteLine("Time Taken in seconds:" + elapsedTime);
Console.WriteLine("End........................... ");
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
public static List <Orders> GetProducts(List <Orders> Cart)
{
List <Orders> shoppingCart = Cart;
U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder();
conn_str.UserID = "Demo";
conn_str.Password = "******";
conn_str.Server = "localhost";
conn_str.Database = "pwdemo";
conn_str.ServerType = "UNIVERSE";
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con1 = new U2Connection();
con1.ConnectionString = s;
con1.Open();
U2Command cmd1 = con1.CreateCommand();
foreach (var Product in shoppingCart)
{
try
{
cmd1.CommandText = "SELECT [DESC_POS] FROM IVMST WHERE ID=" + Product.Serial.ToString();
U2DataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
{
Product.ProdDescription = string.Format(dr1["DESC_POS"].ToString());
dr1.Close();
}
}
catch (Exception ex)
{
}
}
con1.Close();
return(shoppingCart);
}
public static U2Connection GetConnection()
{
U2ConnectionStringBuilder l = new U2ConnectionStringBuilder();
l.UserID = "admin";
l.Password = "******";
l.Server = "9.21.45.89";
l.Database = "HS.SALES";
l.ServerType = "universe";
l.Connect_Timeout = 360;
l.AccessMode = "Uci";
string lconnstr = l.ToString();
U2Connection conn = new U2Connection();
conn.ConnectionString = lconnstr;
return(conn);
}
public static bool DeleteProducts(List <Orders> Cart, string OrderID, string Product)
{
/// // First Insert, then Print, then Delete
try
{
Console.WriteLine(Environment.NewLine + "Start...");
U2ConnectionStringBuilder conn_bldr = new U2ConnectionStringBuilder();
conn_bldr.UserID = "Demo";
conn_bldr.Password = "******";
conn_bldr.Server = "localhost";
conn_bldr.ServerType = "universe";
conn_bldr.Database = "pwdemo";
conn_bldr.AccessMode = "Native";
conn_bldr.RpcServiceType = "uvcs";
string lConnStr = conn_bldr.ConnectionString;
U2Connection lConn = new U2Connection();
lConn.ConnectionString = lConnStr;
lConn.Open();
UniSession lUniSession = lConn.UniSession;
U2Command cmd = lConn.CreateCommand();
// delete inserted value
cmd.CommandText = string.Format("Action=Delete;File=SHOPPINGCART;Where=newrecid={0}", OrderID);
int l2 = cmd.ExecuteNonQuery();
//close connection
lConn.Close();
}
catch (Exception e2)
{
string lErr = e2.Message;
if (e2.InnerException != null)
{
lErr += lErr + e2.InnerException.Message;
}
}
// public static bool InsertOrderItem(List<Orders> LineItem, string OrderNumber)
return(true);
}
private U2Connection GetConnection()
{
var connectionString = new U2ConnectionStringBuilder
{
UserID = this.Username,
Password = this.Password,
Server = this.Hostname,
Database = this.Account,
AccessMode = "Native",
RpcServiceType = "uvcs",
ServerType = "UniVerse",
Connect_Timeout = 1200
}.ToString();
var con = new U2Connection(connectionString);
con.Open();
return(con);
}
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 = "demo";
conn_str.ServerType = "UNIDATA";
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
U2Command cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM STUDENT_NF_SUB";
DataSet ds = new DataSet();
U2DataAdapter da = new U2DataAdapter(cmd);
da.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Console.WriteLine(dr["FNAME"]);
}
con.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
public async Task <string> UpdateUser(object customer)
{
int lRet = -1;
try
{
var cust = (IDictionary <string, object>)customer;
foreach (var property in (IDictionary <String, Object>)cust)
{
Console.WriteLine(property.Key + ": " + property.Value);
var t1 = property.Key;
var t2 = property.Value;
}
U2ConnectionStringBuilder l = new U2ConnectionStringBuilder();
l.UserID = "admin";
l.Password = "******";
l.Server = "192.168.102.132";
l.Database = "HS.SALES";
l.ServerType = "universe";
l.Connect_Timeout = 360;
l.RpcServiceType = "uvcs";
l.AccessMode = "Native";
string lconnstr = l.ToString();
U2Connection c = new U2Connection();
c.ConnectionString = lconnstr;
await c.OpenAsync();
U2Command cmd = c.CreateCommand();
//cmd.CommandText = string.Format("Action=Select;File=CUSTOMER;Attributes=CUSTID,FNAME,LNAME,PRODID,BUY_DATE;Where=CUSTID>0;Sort=CUSTID");
//cmd.CommandText = string.Format("Action=Update;File=CUSTOMER;Attributes=FNAME={0},LNAME={1},DISCOUNT{2};Where=CUSTID={3}", cust["FNAME"], cust["LNAME"], cust["DISCOUNT"], cust["CUSTID"]);
cmd.CommandText = string.Format("Action=Update;File=CUSTOMER;Attributes=FNAME={0},LNAME={1};Where=CUSTID={2}", cust["FNAME"], cust["LNAME"], cust["CUSTID"]);
lRet = await cmd.ExecuteNonQueryAsync();
c.Close();
}
catch (Exception ee)
{
throw ee;
}
return("200");
}
private static void FillDataSetWithUNNEST()
{
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.FirstNormalForm = false;
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
U2Command cmd = con.CreateCommand();
cmd.CommandText = "SELECT FNAME, PRICE FROM UNNEST CUSTOMER ON ORDERS"; // FNAME = SingleValue, PRICE = multivalue
DataSet ds = new DataSet();
U2DataAdapter da = new U2DataAdapter(cmd);
da.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Console.WriteLine(dr["FNAME"] + "==" + dr["PRICE"]);
}
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 = "demo";
conn_str.ServerType = "UNIDATA";
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
U2Command cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM STUDENT_NF_SUB";
U2DataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string s1 = string.Format("FNAME={0} LNAME={1}", dr["FNAME"], dr["LNAME"] + Environment.NewLine);
Console.WriteLine(s1);
}
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 cmd = con.CreateCommand();
cmd.CommandText = "LIST CUSTOMER";
DataSet ds = new DataSet();
U2DataAdapter da = new U2DataAdapter(cmd);
da.FillWithTOXML(ds);
Console.WriteLine(ds.GetXml());
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 = "demo";
conn_str.ServerType = "UNIDATA";
conn_str.Pooling = false;
conn_str.FirstNormalForm = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
U2Command cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM STUDENT UNNEST NL_ALL CGA ;";
DataSet ds = new DataSet();
U2DataAdapter da = new U2DataAdapter(cmd);
da.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Console.WriteLine(dr["FNAME"] + "==" + dr["SEMESTER"]);
}
con.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
private static void FillDataSetWithUNNEST()
{
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.FirstNormalForm = false;
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
U2Command cmd = con.CreateCommand();
cmd.CommandText = "SELECT FNAME, PRICE FROM UNNEST CUSTOMER ON ORDERS"; // FNAME = SingleValue, PRICE = multivalue
DataSet ds = new DataSet();
U2DataAdapter da = new U2DataAdapter(cmd);
da.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Console.WriteLine(dr["FNAME"] + "==" + dr["PRICE"]);
}
con.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
//Console.WriteLine("Enter to exit:");
//string line = Console.ReadLine();
}
}
public async Task<string> UpdateUser(object customer)
{
int lRet = -1;
try
{
var cust = (IDictionary<string, object>)customer;
foreach (var property in (IDictionary<String, Object>)cust)
{
Console.WriteLine(property.Key + ": " + property.Value);
var t1 = property.Key;
var t2 = property.Value;
}
U2ConnectionStringBuilder l = new U2ConnectionStringBuilder();
l.UserID = "admin";
l.Password = "******";
l.Server = "192.168.102.132";
l.Database = "HS.SALES";
l.ServerType = "universe";
l.Connect_Timeout = 360;
l.RpcServiceType = "uvcs";
l.AccessMode = "Native";
string lconnstr = l.ToString();
U2Connection c = new U2Connection();
c.ConnectionString = lconnstr;
await c.OpenAsync();
U2Command cmd = c.CreateCommand();
//cmd.CommandText = string.Format("Action=Select;File=CUSTOMER;Attributes=CUSTID,FNAME,LNAME,PRODID,BUY_DATE;Where=CUSTID>0;Sort=CUSTID");
//cmd.CommandText = string.Format("Action=Update;File=CUSTOMER;Attributes=FNAME={0},LNAME={1},DISCOUNT{2};Where=CUSTID={3}", cust["FNAME"], cust["LNAME"], cust["DISCOUNT"], cust["CUSTID"]);
cmd.CommandText = string.Format("Action=Update;File=CUSTOMER;Attributes=FNAME={0},LNAME={1};Where=CUSTID={2}", cust["FNAME"], cust["LNAME"], cust["CUSTID"]);
lRet = await cmd.ExecuteNonQueryAsync();
c.Close();
}
catch (Exception ee)
{
throw ee;
}
return "200";
}
private void ExecuteCommand(U2Connection con)
{
try
{
if (settings.AccessMode=="Native")
{
// Native mode
UniSession us1 = con.UniSession;
UniCommand uniCmd = us1.CreateUniCommand();
uniCmd.Command = settings.CommandText;
uniCmd.Execute();
// Get response string but not output
string strNative = uniCmd.Response;
}
else
{
// SQL mode
U2Command cmd = con.CreateCommand();
cmd.Connection = con;
cmd.CommandText = settings.CommandText;
cmd.ExecuteNonQuery();
}
}
catch (System.Exception ex)
{
throw ex;
}
finally
{
}
}
private void ExecuteDataReader(U2Connection con)
{
try
{
if (settings.AccessMode == "Native")
{
// Need to confirm how to use UniDataSet
}
else
{
U2Command cmd = con.CreateCommand();
cmd.Connection = con;
cmd.CommandText = settings.CommandText;
U2DataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
// Do something
}
}
}
catch (System.Exception ex)
{
throw ex;
}
}
private void ExecuteDataSet(U2Connection con)
{
try
{
if (settings.AccessMode == "Native")
{
// Need to confirm how to use UniDataSet
}
else
{
U2Command cmd = con.CreateCommand();
cmd.Connection = con;
cmd.CommandText = settings.CommandText;
U2DataAdapter da = new U2DataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
}
}
catch (System.Exception ex)
{
throw ex;
}
}
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 = "demo";
conn_str.ServerType = "UNIDATA";
conn_str.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "udcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
UniSession us1 = con.UniSession;
string RoutineName = "*GETXMLSUB";
int IntTotalAtgs = 6;
string[] largs = new string[IntTotalAtgs];
largs[0] = "LIST STUDENT ALL";
largs[1] = "arg2";
largs[2] = "arg3";
largs[3] = "arg4";
largs[4] = "arg5";
largs[5] = "arg6";
UniDynArray tmpStr2;
UniSubroutine sub = us1.CreateUniSubroutine(RoutineName, IntTotalAtgs);
for (int i = 0; i < IntTotalAtgs; i++)
{
sub.SetArg(i, largs[i]);
}
sub.Call();
tmpStr2 = sub.GetArgDynArray(2);
string result = "\n" + "Result is :" + tmpStr2;
Console.WriteLine(" Response from UniSubRoutineSample :" + result);
con.Close();
}
catch (Exception e)
{
string s = e.Message;
if (e.InnerException != null)
{
s += e.InnerException.Message;
}
Console.WriteLine(s);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
/// <summary>
/// Get dataset in SQL mode
/// </summary>
/// <param name="conStrBdr"></param>
/// <param name="strTableName"></param>
/// <returns></returns>
private DataSet GetSQLDataSet(U2ConnectionStringBuilder conStrBdr, string strTableName)
{
try
{
U2Connection con = new U2Connection();
con.ConnectionString = conStrBdr.ToString();
con.Open();
U2Command cmd = con.CreateCommand();
cmd.CommandText = string.Format("SELECT * FROM [{0}]", strTableName);
U2DataAdapter da = new U2DataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
return ds;
}
catch (Exception e)
{
throw e ;
}
}
/// <summary>
/// Create and open connection
/// </summary>
private void DoConnection()
{
try
{
// Close current connection if exists
DoDisconnection();
con = GetU2Connection();
con.Open();
}
catch (Exception e)
{
throw e;
}
}
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 = "demo";
conn_str.ServerType = "UNIDATA";
conn_str.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "udcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
UniSession us1 = con.UniSession;
UniSelectList sl = us1.CreateUniSelectList(2);
// Select UniFile
UniFile fl = us1.CreateUniFile("STUDENT");
sl.Select(fl);
// read records as unidataset
string[] sArray = { "291222021", "521814564","424325656" };
UniDataSet uSet = fl.ReadRecords(sArray);
// use for each statement to print the record
foreach (UniRecord item in uSet)
{
Console.WriteLine(item.ToString());
}
// use index to print the record
int lCount = uSet.RowCount;
for (int ii = 0; ii < lCount; ii++)
{
UniRecord ee = uSet[ii];
Console.WriteLine(ee.ToString());
}
// print one by one record
UniRecord q2 = uSet["291222021"];
string sq2 = q2.ToString();
Console.WriteLine(" Record data for rec id 291222021:" + sq2);
UniRecord q3 = uSet["521814564"];
string sq3 = q3.ToString();
Console.WriteLine(" Record data for rec id 521814564:" + sq3);
UniRecord q4 = uSet["424325656"];
string sq4 = q4.ToString();
Console.WriteLine(" Record data for rec id 424325656:" + sq4);
//create UniDataSet in the Client Side
UniDataSet uSet3 = us1.CreateUniDataSet();
uSet3.Insert("3", "aaa");
uSet3.Insert("4", "bbb");
uSet3.Insert("5", "vvv");
uSet3.Insert(2, "8", "www");
con.Close();
}
catch (Exception e)
{
string s = e.Message;
if (e.InnerException != null)
{
s += e.InnerException.Message;
}
Console.WriteLine(s);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
public async Task<string> QueryUsers(int pageNumber, int pageSize)
{
string lRetJsonData = string.Empty;
try
{
U2ConnectionStringBuilder l = new U2ConnectionStringBuilder();
l.UserID = "admjjin";
l.Password = "******";
l.Server = "192.168.102.132";
l.Database = "HS.SALES";
l.ServerType = "universe";
l.Connect_Timeout = 360;
l.RpcServiceType = "uvcs";
l.AccessMode = "Native";
string lconnstr = l.ToString();
U2Connection c = new U2Connection();
c.ConnectionString = lconnstr;
await c.OpenAsync();
U2Command cmd = c.CreateCommand();
cmd.CommandText = string.Format("Action=Select;File=CUSTOMER;Attributes=CUSTID,FNAME,LNAME,PRODID,BUY_DATE;Where=CUSTID>0;Sort=CUSTID");
lRetJsonData = await cmd.ExecuteJsonAsync();
c.Close();
}
catch (Exception ee)
{
throw ee;
}
return lRetJsonData;
}
private void button3_Click(object sender, EventArgs e)
{
try
{
this.textBox1.AppendText("Start..." + Environment.NewLine);
//strat get U2 data
U2ConnectionStringBuilder conn_bldr = new U2ConnectionStringBuilder();
conn_bldr.UserID = "admin";
conn_bldr.Password = "******";
conn_bldr.Server = "192.168.102.132";
conn_bldr.ServerType = "universe";
conn_bldr.Database = "HS.SALES";
conn_bldr.AccessMode = "Native";
conn_bldr.RpcServiceType = "uvcs";
string lConnStr = conn_bldr.ConnectionString;
U2Connection lConn = new U2Connection();
lConn.ConnectionString = lConnStr;
lConn.Open();
Console.WriteLine("Connected...");
U2Command cmd = lConn.CreateCommand();
// CUSTID,FNAME,LNAME : Single Value
//PRODID, BUY_DATE : Multi Value
//Syntax : Action=?;File=?;Attributes=?;Where=?;Sort
cmd.CommandText = string.Format("Action=Select;File=CUSTOMER;Attributes=CUSTID,FNAME,LNAME,PRODID,BUY_DATE;Where=CUSTID>0;Sort=CUSTID");
U2DataAdapter da = new U2DataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
//end get U2 data
//load table storage
string lTableStorageName = "CUSTOMER3";
StorageCredentials creds = new StorageCredentials(accountName, accountKey);
CloudStorageAccount account = new CloudStorageAccount(creds, useHttps: true);
CloudTableClient client = account.CreateCloudTableClient();
CloudTable table = client.GetTableReference("CUSTOMER6");
table.CreateIfNotExists();
string lUri = table.Uri.ToString();
// Console.WriteLine(table.Uri.ToString());
this.textBox1.AppendText(lUri + Environment.NewLine);
foreach (DataRow item in dt.Rows)
{
var t1 = item["CUSTID"].ToString();
var t2 = item["Z_MV_KEY"].ToString();
DateTime lhiredate;
if (item["BUY_DATE"] == DBNull.Value)
{
lhiredate = DateTime.Now;// new DateTime();
}
else
{
lhiredate = (DateTime)item["BUY_DATE"];
}
CustomerEntity entity = new CustomerEntity(t1,t2)
{
FNAME = (string)item["FNAME"],
LNAME = (string)item["LNAME"],
PRODID = (string)item["PRODID"],
BUY_DATE = lhiredate
};
TableOperation insertOperation = TableOperation.InsertOrReplace(entity);
table.Execute(insertOperation);
this.textBox1.AppendText("Entity inserted!" + Environment.NewLine);
}
this.textBox1.AppendText("End..." + Environment.NewLine);
}
catch (Exception ex)
{
this.textBox1.AppendText(ex.Message + Environment.NewLine);
}
}
/// <summary>
/// Close active connection
/// </summary>
private void DoDisconnection()
{
if (con != null && con.State == ConnectionState.Open)
{
con.Close();
con.Dispose();
con = null;
}
}
/// <summary>
/// Get an U2 connection object
/// </summary>
/// <returns></returns>
private U2Connection GetU2Connection()
{
U2ConnectionStringBuilder conStr = new U2ConnectionStringBuilder();
// Login settings
conStr.UserID = settings.UserName;
conStr.Password = settings.Password;
conStr.Server = settings.Server;
conStr.Database = settings.Database;
conStr.ServerType = settings.ServerType;
conStr.Connect_Timeout = settings.ConnTimeOut;
conStr.ConnectionLifeTime = settings.ConnLifeTime;
// Access mode
if (settings.AccessMode == "Native")
{
conStr.AccessMode = settings.AccessMode;
if (conStr.ServerType == "UNIDATA")
{
conStr.RpcServiceType = "udcs";
}
else
{
conStr.RpcServiceType = "uvcs";
}
}
else
{
// If not Native mode and set the property like bellow, an error occurred
//conStr.AccessMode = "Uci"; // settings.AccessMode;
//conStr.RpcServiceType = "defcs"; // settings.RpcServiceType;
}
// SSL settings
conStr.SSLConnection = settings.EnableSSLConnection;
if (conStr.SSLConnection == true)
{
conStr.SslIgnoreCertificateNameMismatch = settings.EnableSSLIgnCertNameMismatch;
if (settings.CertificateFilePath.Length > 0)
{
conStr.ClientCertificatePath = settings.CertificateFilePath;
}
conStr.SslIgnoreIncompleteCertificateChain = settings.EnableSSLIgnIncompCertChain;
conStr.SslCheckCertificateRevocation = settings.EnableSSLChkCertRevocation;
}
U2Connection con = new U2Connection();
con.ConnectionString = conStr.ToString();
return con;
}
/// <summary>
/// Get an U2 connection object
/// </summary>
/// <returns></returns>
private static U2Connection GetU2Connection()
{
U2ConnectionStringBuilder conStr = new U2ConnectionStringBuilder();
// Login
conStr.UserID = settings.UserName;
conStr.Password = settings.Password;
conStr.Server = settings.Server;
conStr.Database = settings.Database;
conStr.ServerType = settings.ServerType;
// Pool
conStr.Pooling = settings.EnablePooling;
conStr.MinPoolSize = settings.MinPoolSize;
conStr.MaxPoolSize = settings.MaxPoolSize;
conStr.ConnectionReset = settings.EnableConnReset;
conStr.Connect_Timeout = settings.ConnTimeOut;
conStr.ConnectionLifeTime = settings.ConnLifeTime;
// Access mode
if (settings.AccessMode == "Native")
{
conStr.AccessMode = settings.AccessMode;
if (conStr.ServerType == "UNIDATA")
{
conStr.RpcServiceType = "udcs";
}
else
{
conStr.RpcServiceType = "uvcs";
}
}
U2Connection con = new U2Connection();
con.ConnectionString = conStr.ToString();
return con;
}
/// <summary>
/// Get native string in Native mode
/// </summary>
/// <param name="conStrBdr"></param>
/// <param name="strFileName"></param>
/// <returns></returns>
private string GetNativeString(U2ConnectionStringBuilder conStrBdr, string strFileName)
{
try
{
U2Connection con = new U2Connection();
con.ConnectionString = conStrBdr.ToString();
con.Open();
string strInfo = string.Format("Connected......{0}{0}",Environment.NewLine);
// 0 is meaningless
bwkRetrieve.ReportProgress(0, strInfo);
string strNative = string.Empty;
UniSession us1 = con.UniSession;
UniCommand cmd = us1.CreateUniCommand();
// List no more than 10 records for sample
if (conStrBdr.ServerType=="UNIDATA")
{
cmd.Command = string.Format("LIST {0} ALL SAMPLE 10", strFileName);
}
else
{
cmd.Command = string.Format("LIST {0} SAMPLE 10", strFileName);
}
cmd.Execute();
if (cmd.Response != null)
{
strNative = cmd.Response.Trim();
}
con.Close();
return strNative;
}
catch (Exception e)
{
throw e;
}
}
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.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "uvcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
// get RECID
UniSession us1 = con.UniSession;
// open customer file
UniFile fl = us1.CreateUniFile("CUSTOMER");
// read records as unidataset
string[] sArray = { "2", "12", "3", "4" };
UniDataSet uSet = fl.ReadRecords(sArray);
// use for each statement to print the record
foreach (UniRecord item in uSet)
{
Console.WriteLine(item.ToString());
}
// use index to print the record
int lCount = uSet.RowCount;
for (int ii = 0; ii < lCount; ii++)
{
UniRecord ee = uSet[ii];
Console.WriteLine(ee.ToString());
}
// print one by one record
UniRecord q2 = uSet["2"];
string sq2 = q2.ToString();
Console.WriteLine(" Record data for rec id 2:" + sq2);
UniRecord q3 = uSet["3"];
string sq3 = q3.ToString();
Console.WriteLine(" Record data for rec id 3:" + sq3);
UniRecord q4 = uSet["4"];
string sq4 = q4.ToString();
Console.WriteLine(" Record data for rec id 4:" + sq4);
// create UniDataSet in the Client Side
UniDataSet uSet3 = us1.CreateUniDataSet();
uSet3.Insert("3", "aaa");
uSet3.Insert("4", "bbb");
uSet3.Insert("5", "vvv");
uSet3.Insert(2, "8", "www");
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 = "demo";
conn_str.ServerType = "UNIDATA";
conn_str.AccessMode = "Native"; // FOR UO
conn_str.RpcServiceType = "udcs"; // FOR UO
conn_str.Pooling = false;
string s = conn_str.ToString();
U2Connection con = new U2Connection();
con.ConnectionString = s;
con.Open();
Console.WriteLine("Connected.........................");
// get RECID
UniSession us1 = con.UniSession;
UniSelectList sl = us1.CreateUniSelectList(2);
// Select UniFile
UniFile fl = us1.CreateUniFile("STUDENT");
sl.Select(fl);
bool lLastRecord = sl.LastRecordRead;
List<string> lRecIdList = new List<string>();
while (!lLastRecord)
{
string sRecID = sl.Next();
lRecIdList.Add(sRecID);
Console.WriteLine("Record ID:" + sRecID);
lLastRecord = sl.LastRecordRead;
}
UniDataSet uSet = fl.ReadRecords(lRecIdList.ToArray());
// use for each statement to print the record
foreach (UniRecord item in uSet)
{
Console.WriteLine(item.ToString());
}
con.Close();
}
catch (Exception e)
{
string s = e.Message;
if (e.InnerException != null)
{
s += e.InnerException.Message;
}
Console.WriteLine(s);
}
finally
{
Console.WriteLine("Enter to exit:");
string line = Console.ReadLine();
}
}
