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 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;
}
}
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);
}
}
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);
}
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));
}
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();
}
}
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();
}
}
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 = "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();
}
}
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();
}
}
/// <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>
/// 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 ;
}
}
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);
}
}
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);
}
}
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;
}
}
