using System;
using System.Data;
using System.Windows.Forms;
using GBS.Data.GBasedbt;

namespace TestDotNet
{
    public partial class Form1 : Form
    {
        IfxConnection ifxconn; 
        DataSet ds;

        public Form1()
        {
            InitializeComponent();
            IfxConnectionStringBuilder build = new IfxConnectionStringBuilder();
            // Complete connection details here instead of using setnet sqlhosts config
            build.Host = "bd.gbasedbt.com"; // Hostname or IP address
            build.Protocol = "onsoctcp"; // Protocol used by the database
            build.Service = "9088"; // Port number
            build.Server = "gbase01"; // Database server name
            build.Database = "utf8"; // Database name (DBNAME)
            build.UID = "gbasedbt"; // User
            build.Pwd = "GBase123"; // Password
            build.DbLocale = "zh_CN.utf8"; // Database character set
            build.ClientLocale = "zh_CN.utf8"; // Client character set
            build.PersistSecurityInfo = true; // Persist security info
            ifxconn = new IfxConnection(build.ConnectionString);
            ifxconn.Open();

            using (IfxCommand ifxcmd = ifxconn.CreateCommand())
            {
                ifxcmd.CommandText = "drop table if exists company";
                ifxcmd.ExecuteNonQuery();
                ifxcmd.CommandText = "create table company(coid serial, coname varchar(255), coaddr varchar(255))";
                ifxcmd.ExecuteNonQuery();
                ifxcmd.CommandText = "insert into company values (0, 'GBASE', 'Tianjin High-Tech')";
                ifxcmd.ExecuteNonQuery();
                ifxcmd.CommandText = "insert into company values (0, 'GBASE Beijing Branch', 'Beijing Chaoyang')";
                ifxcmd.ExecuteNonQuery();
                ifxcmd.CommandText = "update company set coaddr = 'Tianjin Tianbai Park' where coid = 1";
                ifxcmd.ExecuteNonQuery();
                ifxcmd.CommandText = "select dbinfo('version','full') from dual";

                IfxDataReader dr = ifxcmd.ExecuteReader();
                if (dr.Read())
                {
                    this.label1.Text = "Database version: " + dr[0];
                }
            }
        }

        private void btnSelect_Click(object sender, EventArgs e)
        {
            IfxDataAdapter ifxadpt = new IfxDataAdapter("select * from company", ifxconn);
            ds = new DataSet();
            ifxadpt.Fill(ds);
            this.dataGridView1.DataSource = ds.Tables[0];
            MessageBox.Show("Database operation successful using DotNet! \n");
        }
    }
}