private async void ButtonCountClick(object sender, EventArgs e)
{
if (OraSession != null)
{
FromCrets = new DateTime(2017, 5, 1);
string FromCretsStr = FromCrets.ToString("dd'/'MM'/'yyyy HH:mm:ss");
string query = "Select trc.trcbus, count(t.transik) " +
"From TRANSMAIN t join TRCBUS trc on trc.trcbusno = t.trcbusno " +
"Where t.tracan=0 and t.chgts>=to_timestamp(:FromChgts,'DD/MM/YYYY HH24:MI:SS') " +
"Group by trc.trcbus " +
"Order by trc.trcbus";
OracleCommand cmd = new OracleCommand(query, OraSession.Connection);
listViewTransCode.Items.Clear();
textBoxMessages.Text = "Calculating...";
cmd.Parameters.Add(":FromChgts", OracleDbType.Varchar2).Value = FromCretsStr;
DataTable dt = await OraSession.ExecuteQueryParallel(cmd);
FillListView(dt);
textBoxMessages.Text = "";
}
else
{
textBoxMessages.Text = "Please connect first";
}
}
private void ButtonConnectClick(object sender, EventArgs e)
{
if (OraSession == null)
{
Connection Connection = new Connection(host: "DK01SV7020", port: "1521", sid: "T7020230", schema: "TESTIMMD", password: "******");
OraSession = new OraSession(Connection.Data);
textBoxMessages.Text = OraSession.Connect();
}
}