public DataSet QueryExecuter(string query)
        {
            string connectionString = GetConnectionString(username, password);

            DataSet data = new DataSet();

            string queryString = query;

            using (OracleConnection connection = new OracleConnection(connectionString))
            {
                OracleCommand command = new OracleCommand(queryString, connection);
                connection.Open();
                OracleDataAdapter dataAdapter = new OracleDataAdapter(command);
                try
                {
                    dataAdapter.Fill(data);
                }
                catch (Exception ex)
                {
                    Console.Write(ex.ToString());
                }
                connection.Close();
            }
            return data;
        }