uusing Oracle.ManagedDataAccess.Client;
using System;
using System.Net.Sockets;
using System.Text;

namespace Zadanie1
{
    public class Program
    {
        private const string TCP_HOST = "150.254.11.230";
        private const int TCP_PORT = 31084;
        private const string ORACLE_CONNECTION_STRING =
            "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=150.254.11.231)" +
            "(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)));" +
            "User ID=egzamin2019;Password=student;";
        private static Random random = new Random();

        public static void Main(string[] args)
        {
            Socket client;
            byte[] buffer;
            int a, i;
            OracleConnection connection;
            OracleCommand command;

            client = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
            client.Connect(TCP_HOST, TCP_PORT);
            buffer = new byte[20];
            client.Receive(buffer, 4, SocketFlags.None);
            a = BitConverter.ToInt32(buffer, 0);
            Console.WriteLine("Odebrano A = " + a);
            connection = new OracleConnection(ORACLE_CONNECTION_STRING);
            connection.Open();

            for (i = 0; i < a; i++)
            {
                client.Receive(buffer);
                Console.Write("Odebrano = ");
                PrintOutByteArray(buffer);
                command = new OracleCommand();
                command.Connection = connection;
                command.CommandText = string.Format(
                    "INSERT INTO grupaA (ID, indeks, student) VALUES ({0}, 131084, '{1}')",
                    random.Next(1, 1000), Encoding.UTF8.GetString(buffer));
                command.ExecuteNonQuery();
                Console.WriteLine("Wykonano instrukcję SQL = " + command.CommandText);
            }

            connection.Close();
            client.Close();
        }

        private static void PrintOutByteArray(byte[] buffer)
        {
            int i;

            for (i = 0; i < buffer.Length; i++)
            {
                Console.Write(buffer[i]);
            }

            Console.WriteLine();
        }
    }
}