public static async void InsertPlayersToDatabaseAsync(int rows)
{
List <string> commandsToTextFile = new List <string>();
List <int> clubIds = new List <int>();
clubIds.Clear();
clubIds = GetIds("id_klubu", "Kluby");
for (int i = 0; i < rows; i++)
{
var commandText = "insert into Zawodnicy (imie, nazwisko, data_urodzenia, Kluby_id_klubu, wzrost, waga, pozycja, numer, zasieg) values(:imie, :nazwisko, TO_DATE(:data_urodzenia,'DD/MM/YYYY'), :Kluby_id_klubu, :wzrost, :waga, :pozycja, :numer, :zasieg)";
using (OracleConnection connection = new OracleConnection(SqlConnection.connectionString))
{
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.Parameters.Add(new OracleParameter("imie", SD.people[RandomElements.GetRandomNumber(0, SD.people.Count - 1)].Split(' ').First()));
command.Parameters.Add(new OracleParameter("nazwisko", SD.people[RandomElements.GetRandomNumber(0, SD.people.Count - 1)].Split(' ')[1]));
command.Parameters.Add(new OracleParameter("data_urodzenia", RandomElements.GetRandomDate(1970, 2000, "d")));
command.Parameters.Add(new OracleParameter("Kluby_id_klubu", clubIds[RandomElements.GetRandomNumber(0, clubIds.Count - 1)]));
command.Parameters.Add(new OracleParameter("wzrost", RandomElements.GetRandomNumber(170, 215)));
command.Parameters.Add(new OracleParameter("waga", RandomElements.GetRandomNumber(70, 115)));
command.Parameters.Add(new OracleParameter("pozycja", SD.positions[RandomElements.GetRandomNumber(0, SD.positions.Count - 1)]));
command.Parameters.Add(new OracleParameter("numer", RandomElements.GetRandomNumber(1, 99)));
command.Parameters.Add(new OracleParameter("zasieg", RandomElements.GetRandomNumber(300, 385)));
commandsToTextFile.Add("insert into Zawodnicy (imie, nazwisko, data_urodzenia, Kluby_id_klubu, wzrost, waga, pozycja, numer, zasieg) " +
"values(" + command.Parameters[0].Value.ToString() + ", " + command.Parameters[1].Value.ToString() + ", TO_DATE(" + command.Parameters[2].Value.ToString() +
", DD/MM/YYYY), " + command.Parameters[3].Value.ToString() + ", " + command.Parameters[4].Value.ToString() + ", " + command.Parameters[5].Value.ToString()
+ ", " + command.Parameters[6].Value.ToString() + ", " + command.Parameters[7].Value.ToString() + ", " + command.Parameters[8].Value.ToString() + ")");
command.Connection.Open();
await command.ExecuteNonQueryAsync();
command.Connection.Close();
}
}
}
WriteCommandsToTextFile("Zawodnicy", commandsToTextFile);
clubIds.Clear();
}
public static async void InsertMatchesToDatabaseAsync(int rows)
{
List <string> commandsToTextFile = new List <string>();
List <int> clubIds = new List <int>();
List <int> gameIds = new List <int>();
clubIds.Clear();
gameIds.Clear();
clubIds = GetIds("id_klubu", "Kluby");
gameIds = GetIds("id_kolejki", "Kolejka");
for (int i = 0; i < rows; i++)
{
var commandText = "insert into Mecze (Kolejka_id_kolejki, Kluby_id_klubu, id_gosc, data_i_godzina, wynik) values(:Kolejka_id_kolejki, :Kluby_id_klubu, :id_gosc, :data_i_godzina, :wynik)";
using (OracleConnection connection = new OracleConnection(SqlConnection.connectionString))
{
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.Parameters.Add(new OracleParameter("Kolejka_id_kolejki", gameIds[RandomElements.GetRandomNumber(0, gameIds.Count - 1)]));
command.Parameters.Add(new OracleParameter("Kluby_id_klubu", clubIds[RandomElements.GetRandomNumber(0, clubIds.Count - 1)]));
command.Parameters.Add(new OracleParameter("id_gosc", clubIds[RandomElements.GetRandomNumber(0, clubIds.Count - 1)]));
command.Parameters.Add(new OracleParameter("data_i_godzina", RandomElements.GetRandomDate(2018, 2021, "yyyy-MM-dd HH:mm:ss")));
command.Parameters.Add(new OracleParameter("wynik", Convert.ToString(RandomElements.GetRandomResult())));
commandsToTextFile.Add("insert into Mecze (Kolejka_id_kolejki, Kluby_id_klubu, id_gosc, data_i_godzina, wynik) " +
"values(" + command.Parameters[0].Value.ToString() + ", " + command.Parameters[1].Value.ToString() + ", " + command.Parameters[2].Value.ToString() + ", " + command.Parameters[3].Value.ToString() + ", " + command.Parameters[4].Value.ToString() + ")");
command.Connection.Open();
await command.ExecuteNonQueryAsync();
command.Connection.Close();
}
}
}
WriteCommandsToTextFile("Mecze", commandsToTextFile);
clubIds.Clear();
}
