public static async void InsertGamesToDatabaseAsync(int rows)
{
List <string> commandsToTextFile = new List <string>();
for (int i = 0; i < rows; i++)
{
var commandText = "insert into Kolejka (numer_kolejki) values(:numer_kolejki)";
using (OracleConnection connection = new OracleConnection(SqlConnection.connectionString))
{
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.Parameters.Add(new OracleParameter("numer_kolejki", RandomElements.GetRandomNumber(1, 99)));
commandsToTextFile.Add("insert into Kolejka (numer_kolejki) " +
"values(" + command.Parameters[0].Value.ToString() + ")");
command.Connection.Open();
await command.ExecuteNonQueryAsync();
command.Connection.Close();
}
}
}
WriteCommandsToTextFile("Kolejka", commandsToTextFile);
}
public static async void InsertClubsToDatabaseAsync(int rows)
{
List <string> commandsToTextFile = new List <string>();
for (int i = 0; i < rows; i++)
{
var commandText = "insert into Kluby (nazwa_klubu, punkty, zwyciestwa, wspolczynnik_setow, miejsce_w_tabeli) values(:nazwa_klubu, :punkty, :zwyciestwa, :wspolczynnik_setow, :miejsce_w_tabeli)";
using (OracleConnection connection = new OracleConnection(SqlConnection.connectionString))
{
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.Parameters.Add(new OracleParameter("nazwa_klubu", SD.clubs[RandomElements.GetRandomNumber(0, SD.clubs.Count - 1)]));
command.Parameters.Add(new OracleParameter("punkty", RandomElements.GetRandomNumber(0, 99)));
command.Parameters.Add(new OracleParameter("zwyciestwa", RandomElements.GetRandomNumber(0, 27)));
command.Parameters.Add(new OracleParameter("wspolczynnik_setow", RandomElements.GetRandomDouble(0.25, 5.0, 2)));
command.Parameters.Add(new OracleParameter("miejsce_w_tabeli", RandomElements.GetRandomNumber(1, 99)));
commandsToTextFile.Add("insert into Kluby (nazwa_klubu, punkty, zwyciestwa, wspolczynnik_setow, miejsce_w_tabeli) " +
"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("Kluby", commandsToTextFile);
}
public static async void InsertAddressesToDatabaseAsync(int rows)
{
List <string> commandsToTextFile = new List <string>();
List <int> clubIds = new List <int>();
List <int> foreignKeys = new List <int>();
clubIds.Clear();
foreignKeys.Clear();
clubIds = GetIds("id_klubu", "Kluby");
foreignKeys = GetIds("Kluby_id_klubu", "Adresy");
clubIds.RemoveAll(i => foreignKeys.Contains(i));
for (int i = 0; i < rows; i++)
{
var commandText = "insert into Adresy (Kluby_id_klubu, kod_pocztowy, ulica, miejscowosc,nr_budynku, nr_lokalu, strona_internetowa, email, telefon) values(:Kluby_id_klubu, :kod_pocztowy, :ulica, :miejscowosc, :nr_budynku, :nr_lokalu, :strona_internetowa, :email, :telefon)";
using (OracleConnection connection = new OracleConnection(SqlConnection.connectionString))
{
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.Parameters.Add(new OracleParameter("Kluby_id_klubu", clubIds[RandomElements.GetRandomNumber(0, clubIds.Count - 1)]));
command.Parameters.Add(new OracleParameter("kod_pocztowy", Convert.ToString(RandomElements.GetRandomNumber(10000, 99999))));
command.Parameters.Add(new OracleParameter("ulica", SD.streets[RandomElements.GetRandomNumber(0, SD.streets.Count - 1)]));
command.Parameters.Add(new OracleParameter("miejscowosc", SD.cities[RandomElements.GetRandomNumber(0, SD.cities.Count - 1)]));
command.Parameters.Add(new OracleParameter("nr_budynku", RandomElements.GetRandomNumber(1, 999)));
command.Parameters.Add(new OracleParameter("nr_lokalu", RandomElements.GetRandomNumber(1, 99)));
command.Parameters.Add(new OracleParameter("strona_internetowa", SD.websites[RandomElements.GetRandomNumber(0, SD.websites.Count - 1)]));
command.Parameters.Add(new OracleParameter("email", SD.emails[RandomElements.GetRandomNumber(0, SD.emails.Count - 1)]));
command.Parameters.Add(new OracleParameter("telefon", Convert.ToString(RandomElements.GetRandomNumber(100000000, 999999999))));
commandsToTextFile.Add("insert into Adresy (Kluby_id_klubu, kod_pocztowy, ulica, miejscowosc,nr_budynku, nr_lokalu, strona_internetowa, email, telefon) " +
"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.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();
clubIds.Remove((int)command.Parameters[0].Value);
}
}
}
WriteCommandsToTextFile("Adresy", commandsToTextFile);
clubIds.Clear();
foreignKeys.Clear();
}
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 InsertStatisticsToDatabaseAsync(int rows)
{
List <string> commandsToTextFile = new List <string>();
List <int> playerIds = new List <int>();
playerIds.Clear();
playerIds = GetIds("id_zawodnika", "Zawodnicy");
for (int i = 0; i < rows; i++)
{
var commandText = "insert into Statystyki (Zawodnicy_id_zawodnika, liczba_sezonow, liczba_meczow, punkty, asy_serwisowe, bloki, skutecznosc) values(:Zawodnicy_id_zawodnika, :liczba_sezonow, :liczba_meczow, :punkty, :asy_serwisowe, :bloki, :skutecznosc)";
using (OracleConnection connection = new OracleConnection(SqlConnection.connectionString))
{
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.Parameters.Add(new OracleParameter("Zawodnicy_id_zawodnika", playerIds[RandomElements.GetRandomNumber(0, playerIds.Count - 1)]));
command.Parameters.Add(new OracleParameter("liczba_sezonow", RandomElements.GetRandomNumber(1, 15)));
command.Parameters.Add(new OracleParameter("liczba_meczow", RandomElements.GetRandomNumber(10, 200)));
command.Parameters.Add(new OracleParameter("punkty", RandomElements.GetRandomNumber(10, 500)));
command.Parameters.Add(new OracleParameter("asy_serwisowe", RandomElements.GetRandomNumber(1, 70)));
command.Parameters.Add(new OracleParameter("bloki", RandomElements.GetRandomNumber(1, 60)));
command.Parameters.Add(new OracleParameter("skutecznosc", RandomElements.GetRandomDouble(30.0, 80.0, 1)));
commandsToTextFile.Add("insert into Statystyki (Zawodnicy_id_zawodnika, liczba_sezonow, liczba_meczow, punkty, asy_serwisowe, bloki, skutecznosc) " +
"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.Parameters[5].Value.ToString()
+ ", " + command.Parameters[6].Value.ToString() + ")");
command.Connection.Open();
await command.ExecuteNonQueryAsync();
command.Connection.Close();
playerIds.Remove((int)command.Parameters[0].Value);
}
}
}
WriteCommandsToTextFile("Statystyki", commandsToTextFile);
playerIds.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();
}
private void TestingForSimplex(int dalyba, int skaicius)
{
RandomElements rand = new RandomElements();
List<int> k = new List<int> { };
int KiekAtrinktiVariantu;
if (skaicius != 0)
{
KiekAtrinktiVariantu = skaicius;
}
else
{
KiekAtrinktiVariantu = Convert.ToInt32(Math.Floor(Convert.ToDouble(RandomList.random.Count) / dalyba));
if (KiekAtrinktiVariantu < 10)
{
KiekAtrinktiVariantu = RandomList.random.Count;
}
}
for (int i = 0; i < KiekAtrinktiVariantu; i++)
{
int min = 0; int mn = 0;
for (int j = 0; j < RandomList.random.Count; j++)
{
Boolean neMinusas = true;
for (int h = 0; h < RandomList.random[j].suma.Count; h++)
{
if (RandomList.random[j].suma[h] < 0)
{
neMinusas = false;
}
}
for (int h = 0; h < RandomList.random[j].kiekis.Count; h++)
{
if (RandomList.random[j].kiekis[h] < 0)
{
neMinusas = false;
}
}
if (RandomList.random[j].pagamintaDetaliu > min && k.IndexOf(j) == -1 && neMinusas == true)
{
min = RandomList.random[j].pagamintaDetaliu;
mn = j;
}
}
k.Add(mn);
if (RandomList.random.Count != 0)
{
rand.random.Add(RandomList.random[k[i]]);
}
}
RandomList = rand;
}
private void Testing(int dalyba)
{
RandomElements rand = new RandomElements();
List<int> k = new List<int> { };
int KiekAtrinktiVariantu = Convert.ToInt32(Math.Floor(Convert.ToDouble(RandomList.random.Count) / dalyba));
if (KiekAtrinktiVariantu < 10)
{
KiekAtrinktiVariantu = RandomList.random.Count;
}
for (int i = 0; i < KiekAtrinktiVariantu; i++)
{
int min = 0; int mn = 0;
for (int j = 0; j < RandomList.random.Count; j++)
{
if (RandomList.random[j].pagamintaDetaliu > min && k.IndexOf(j) == -1)
{
min = RandomList.random[j].pagamintaDetaliu;
mn = j;
}
}
k.Add(mn);
rand.random.Add(RandomList.random[k[i]]);
}
RandomList = rand;
}
private void SymplexCikloNR(SimplexLentele Lentele, int cikloNr)
{
SimplexLentele Lent = new SimplexLentele();
Lent = MakeLentelesCopy(Lentele);
Boolean stop = false;
RandomElements LocalList = new RandomElements();
while (CheckArGalimaTestiSprendima(Lent) == true && stop == false)
{
List<int> Likutis = new List<int> { };
int MaxCj = RastiMaxCjCikle(Lent, cikloNr);
Tuple<int, double> back = RastiMinRHS(MaxCj, Lent);
int MinRHS = back.Item1;
int MinRHSReiksme = Convert.ToInt32(Math.Floor(back.Item2));
Lent.BVS[MinRHS] = MaxCj;
PertvarkytiPagrindineEilute(MinRHS, MaxCj, ref Lent);
PertvarkytiLikusesEilutes(MinRHS, MaxCj, ref Lent);
PertvarkytiPagrindiniStulpeli(MinRHS, MaxCj, ref Lent);
PerskaiciuotiRHS(MinRHS, MaxCj, MinRHSReiksme, ref Lent, ref Likutis);
stop = ParuostiSpausdinimui(Lent, Likutis, ref LocalList);
if (LocalList.random.Count > 100)
{
stop = true;
}
}
RandomList.random.AddRange(LocalList.random);
}
private void Reset()
{
problem = new Uzklausa();
visoP = new Uzklausa();
RandomList = new RandomElements();
problemOld = new Uzklausa();
}
//MAIN
// Pagrindinis skaičiavimas ir rezultatų spausdinimas:
private void bw_DoWork(object sender, DoWorkEventArgs e)
{
BackgroundWorker worker = sender as BackgroundWorker;
LygciuSudarimas();
RandomList = new RandomElements();
SimplexCiklas(Lentele);
;
}
private void Reset()
{
problem = new Uzklausa();
visoP = new Uzklausa();
RandomList = new RandomElements();
problemOld = new Uzklausa();
Lygtys = new LygciuSistema();
Lentele = new SimplexLentele();
}
public static async void InsertSponsorsToDatabaseAsync(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 Sponsorzy (nazwa_sponsora, Kluby_id_klubu, wklad_pieniezny) values(:nazwa_sponsora, :Kluby_id_klubu, :wklad_pieniezny)";
using (OracleConnection connection = new OracleConnection(SqlConnection.connectionString))
{
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.Parameters.Add(new OracleParameter("nazwa_sponsora", SD.sponsors[RandomElements.GetRandomNumber(0, SD.sponsors.Count - 1)]));
command.Parameters.Add(new OracleParameter("Kluby_id_klubu", clubIds[RandomElements.GetRandomNumber(0, clubIds.Count - 1)]));
command.Parameters.Add(new OracleParameter("wklad_pieniezny", RandomElements.GetRandomNumber(20000, 900000)));
commandsToTextFile.Add("insert into Sponsorzy (nazwa_sponsora, Kluby_id_klubu, wklad_pieniezny) " +
"values(" + command.Parameters[0].Value.ToString() + ", " + command.Parameters[1].Value.ToString() + ", " + command.Parameters[2].Value.ToString() + ")");
command.Connection.Open();
await command.ExecuteNonQueryAsync();
command.Connection.Close();
}
}
}
WriteCommandsToTextFile("Sponsorzy", commandsToTextFile);
clubIds.Clear();
}
public static async void InsertGymStuffsToDatabaseAsync(int rows)
{
List <string> commandsToTextFile = new List <string>();
List <int> gymIds = new List <int>();
List <int> foreignKeys = new List <int>();
gymIds.Clear();
foreignKeys.Clear();
gymIds = GetIds("id_hali", "Hale_sportowe");
foreignKeys = GetIds("Hale_sportowe_id_hali", "Zarzad_hali");
gymIds.RemoveAll(i => foreignKeys.Contains(i));
for (int i = 0; i < rows; i++)
{
var commandText = "insert into Zarzad_hali (Hale_sportowe_id_hali, wozny, kierownik) values(:Hale_sportowe_id_hali, :wozny, :kierownik)";
using (OracleConnection connection = new OracleConnection(SqlConnection.connectionString))
{
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.Parameters.Add(new OracleParameter("Hale_sportowe_id_hali", gymIds[RandomElements.GetRandomNumber(0, gymIds.Count - 1)]));
command.Parameters.Add(new OracleParameter("wozny", SD.people[RandomElements.GetRandomNumber(0, SD.people.Count - 1)]));
command.Parameters.Add(new OracleParameter("kierownik", SD.people[RandomElements.GetRandomNumber(0, SD.people.Count - 1)]));
commandsToTextFile.Add("insert into Zarzad_hali (Hale_sportowe_id_hali, wozny, kierownik) " +
"values(" + command.Parameters[0].Value.ToString() + ", " + command.Parameters[1].Value.ToString() + ", " + command.Parameters[2].Value.ToString() + ")");
command.Connection.Open();
await command.ExecuteNonQueryAsync();
command.Connection.Close();
gymIds.Remove((int)command.Parameters[0].Value);
}
}
}
WriteCommandsToTextFile("Zarzad_hali", commandsToTextFile);
gymIds.Clear();
foreignKeys.Clear();
}
private void NykstukuFabrikas(int kiekis)
{
// RandomList => HelperList
Random r = new Random();
RandomiserClass Randomiser = new RandomiserClass();
for (int kiek = 0; kiek < kiekis; kiek++)
{
Randomiser = new RandomiserClass();
Randomiser.sablonas = subsabl;
List<int> viso = new List<int> { };
List<int> likeNr = new List<int> { };
for (int i = 0; i < problem.kiekis.Count; i++)
{
viso.Add(problem.kiekis[i]);
}
for (int i = 0; i < Randomiser.sablonas.SablonoSubNr.Count; i++)
{
Randomiser.kiekis.Add(0);
likeNr.Add(Randomiser.sablonas.SablonoSubNr[i]);
}
while (likeNr.Count != 0)
{
int randomSablNr = r.Next(0, likeNr.Count);
int min = 99999;
for (int j = 0; j < Randomiser.sablonas.SablonoElem[randomSablNr].JuostIlgis.Count; j++)
{
for (int h = 0; h < viso.Count; h++)
{
if (problem.ilgis[h] == Randomiser.sablonas.SablonoElem[randomSablNr].JuostIlgis[j] && problem.tipai[h] == Randomiser.sablonas.SablonoElem[randomSablNr].JuostTipas[j])
{
double dal = Convert.ToDouble(Randomiser.sablonas.SablonoElem[randomSablNr].Kiekis[j]);
int dalyba;
if(dal != 0)
{
dalyba = Convert.ToInt32(Math.Floor(Convert.ToDouble(viso[h]) / dal));
}
else
{
dalyba = 9999999;
}
if (dalyba < min)
{
min = dalyba;
}
}
}
}
if (min == 0)
{
likeNr.RemoveAt(randomSablNr);
}
else
{
int atm = r.Next(0, min + 1); // panaikinti random
Randomiser.kiekis[randomSablNr] += atm;
for (int j = 0; j < Randomiser.sablonas.SablonoElem[randomSablNr].Kiekis.Count; j++)
{
int atimti = Randomiser.sablonas.SablonoElem[randomSablNr].Kiekis[j] * atm;
for (int h = 0; h < viso.Count; h++)
{
if (problem.ilgis[h] == Randomiser.sablonas.SablonoElem[randomSablNr].JuostIlgis[j] && problem.tipai[h] == Randomiser.sablonas.SablonoElem[randomSablNr].JuostTipas[j])
{
viso[h] -= atimti;
}
}
}
}
}
RandomElements rand = new RandomElements();
Boolean virsNulio = true;
int suma = 0;
for (int sum = 0; sum < viso.Count; sum++)
{
if (viso[sum] < 0)
{
virsNulio = false;
}
Randomiser.suma.Add(viso[sum]);
Randomiser.ilgis.Add(problem.ilgis[sum]);
Randomiser.tipas.Add(problem.tipai[sum]);
suma += Math.Abs(viso[sum]);
}
Randomiser.liekana = suma;
if (virsNulio == true)
{
int pagaminta = 0;
for (int j = 0; j < Randomiser.sablonas.SablonoElem.Count; j++)
{
if (Randomiser.kiekis[j] != 0)
{
pagaminta += Randomiser.kiekis[j];
}
}
Randomiser.pagamintaDetaliu = pagaminta;
HelperList.Push(Randomiser);//RandomList.random.Add(Randomiser);
}
}
}
public static async void InsertGymsToDatabaseAsync(int rows)
{
List <string> commandsToTextFile = new List <string>();
List <int> clubIds = new List <int>();
List <int> foreignKeys = new List <int>();
foreignKeys.Clear();
clubIds.Clear();
clubIds = GetIds("id_klubu", "Kluby");
foreignKeys = GetIds("Kluby_id_klubu", "Hale_sportowe");
clubIds.RemoveAll(i => foreignKeys.Contains(i));
for (int i = 0; i < rows; i++)
{
var commandText = "insert into Hale_sportowe (Kluby_id_klubu, nazwa_hali, liczba_miejsc) values(:Kluby_id_klubu, :nazwa_hali, :liczba_miejsc)";
using (OracleConnection connection = new OracleConnection(SqlConnection.connectionString))
{
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.Parameters.Add(new OracleParameter("Kluby_id_klubu", clubIds[RandomElements.GetRandomNumber(0, clubIds.Count - 1)]));
command.Parameters.Add(new OracleParameter("nazwa_hali", SD.gyms[RandomElements.GetRandomNumber(0, SD.gyms.Count - 1)]));
command.Parameters.Add(new OracleParameter("liczba_miejsc", Convert.ToString(RandomElements.GetRandomNumber(300, 50000))));
commandsToTextFile.Add("insert into Hale_sportowe (Kluby_id_klubu, nazwa_hali, liczba_miejsc) " +
"values(" + command.Parameters[0].Value.ToString() + ", " + command.Parameters[1].Value.ToString() + ", " + command.Parameters[2].Value.ToString() + ")");
command.Connection.Open();
await command.ExecuteNonQueryAsync();
command.Connection.Close();
clubIds.Remove((int)command.Parameters[0].Value);
}
}
}
foreignKeys.Clear();
clubIds.Clear();
WriteCommandsToTextFile("Hale_sportowe", commandsToTextFile);
}
private Boolean ParuostiSpausdinimui(SimplexLentele Lent, List<int> Likutis, ref RandomElements rnd)
{
RandomiserClass Randomiser = new RandomiserClass();
Randomiser.sablonas = subsabl;
for (int i = 0; i < Randomiser.sablonas.SablonoSubNr.Count; i++)
{
Randomiser.kiekis.Add(0);
}
int dabartinis = 0;
Boolean blogas = false;
for (int i = 0; i < Lent.RHS.Count; i++)
{
if (Lent.BVS[i] >= 0)
{
if (Lent.RHS[i] < 0)
{
blogas = true;
return true;
}
dabartinis += Lent.RHS[i];
Randomiser.kiekis[Lent.BVS[i]] = Lent.RHS[i];
}
}
if (blogas == false)
{
Randomiser.suma.AddRange(Likutis);
for (int i = 0; i < Likutis.Count; i++)
{
if (Likutis[i] < 0)
{
blogas = true;
return true;
}
Randomiser.liekana += Likutis[i];
}
if (blogas == false)
{
Randomiser.ilgis.AddRange(problem.ilgis);
Randomiser.tipas.AddRange(problem.tipai);
Randomiser.pagamintaDetaliu = dabartinis;
if (rnd.random.Count > 0)
{
if (rnd.random[0].pagamintaDetaliu < dabartinis)
{
rnd.random.Clear();
rnd.random.Add(Randomiser);
}
if (rnd.random[0].pagamintaDetaliu == dabartinis)
{
rnd.random.Add(Randomiser);
}
if (rnd.random[0].pagamintaDetaliu > dabartinis)
{
return true;
}
}
else
{
rnd.random.Add(Randomiser);
}
}
}
return false;
}
public static async void InsertTeamStuffsToDatabaseAsync(int rows)
{
List <string> commandsToTextFile = new List <string>();
List <int> clubIds = new List <int>();
List <int> foreignKeys = new List <int>();
foreignKeys.Clear();
clubIds.Clear();
clubIds = GetIds("id_klubu", "Kluby");
foreignKeys = GetIds("Kluby_id_klubu", "Sztaby_druzyn");
clubIds.RemoveAll(i => foreignKeys.Contains(i));
for (int i = 0; i < rows; i++)
{
var commandText = "insert into Sztaby_druzyn (Kluby_id_klubu, trener, drugi_trener, prezes, menadzer, dyrektor_sportowy) values(:Kluby_id_klubu, :trener, :drugi_trener, :prezes, :menadzer, :dyrektor_sportowy)";
using (OracleConnection connection = new OracleConnection(SqlConnection.connectionString))
{
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.Parameters.Add(new OracleParameter("Kluby_id_klubu", clubIds[RandomElements.GetRandomNumber(0, clubIds.Count - 1)]));
command.Parameters.Add(new OracleParameter("trener", SD.people[RandomElements.GetRandomNumber(0, SD.people.Count - 1)]));
command.Parameters.Add(new OracleParameter("drugi_trener", SD.people[RandomElements.GetRandomNumber(0, SD.people.Count - 1)]));
command.Parameters.Add(new OracleParameter("prezes", SD.people[RandomElements.GetRandomNumber(0, SD.people.Count - 1)]));
command.Parameters.Add(new OracleParameter("menadzer", SD.people[RandomElements.GetRandomNumber(0, SD.people.Count - 1)]));
command.Parameters.Add(new OracleParameter("dyrektor_sportowy", SD.people[RandomElements.GetRandomNumber(0, SD.people.Count - 1)]));
commandsToTextFile.Add("insert into Sztaby_druzyn (Kluby_id_klubu, trener, drugi_trener, prezes, menadzer, dyrektor_sportowy) " +
"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.Parameters[5].Value.ToString() + ")");
command.Connection.Open();
await command.ExecuteNonQueryAsync();
command.Connection.Close();
clubIds.Remove((int)command.Parameters[0].Value);
}
}
}
WriteCommandsToTextFile("Sztaby_druzyn", commandsToTextFile);
clubIds.Clear();
foreignKeys.Clear();
}
