yigityus / astm Goto Github PK

        Message m = new Message(_barcode);

        string sql = "select C.CIHAZ_TEST from CHZ_ORDER O, CHZ_TEST C where O.TUBE_BARCODE=" +
            _barcode.ToString() + "and C.CIHAZ_ID=" + cihazId + "and C.LIS_TEST=O.LIS_TEST and O.PENDING='P'";
        
        OracleCommand cmd = new OracleCommand(sql, conn);
        List<string> tests = new List<string>();
        OracleDataReader read;
        try
        {
            conn.Open();
            read = cmd.ExecuteReader();


            while (read.Read())
            {
                tests.Add(read[0].ToString());
            }

        }


        catch (OracleException OEx)
        {
            Console.WriteLine(OEx.Message);
        }
        finally
        {
            conn.Close();
            cmd.Dispose();
        }


        string[] send = m.SendOrder(tests);

        for (int i = 0; i < send.Length; i++)
        {
            sp.Write(send[i]);
            wh.WaitOne();
        }

        Console.WriteLine("[Host ~]$ ordered: {0}", "tests");
    }`