public NaplanovanyTwoCols(KonkretniKrouzekPrototype planned)
{
this.InitializeComponent();
this.planned_ = planned;
string cityName = this.planned_.krouzek.skola.adresa.mesto;
if (cityName.Contains('-'))
{
cityName = cityName.Substring(0, cityName.IndexOf('-'));
}
if (cityName.Contains(' '))
{
cityName = cityName.Substring(0, cityName.IndexOf(' '));
}
this.leftLabel.Text = cityName;
this.rightLabel.Text = planned.krouzek.casKonaniOd.ToString("HH:mm");
}
public static string InsertString(KonkretniKrouzekPrototype krouzek)
{
bool zrusen = false;
int pocetZaku = 0;
//Random random = new Random((int)DateTime.Now.Ticks);
if (random.Next(0, 50) == 25)
{
zrusen = true;
pocetZaku = 0;
}
else
{
pocetZaku = random.Next(3, 10);
}
return
($"INSERT INTO projekt.KonkretniKrouzek(idKrouzek,datum,zrusen,pocetZaku) VALUES ({krouzek.idKrouzek}, '{krouzek.datum:yyyy-MM-dd}', {Convert.ToInt32(zrusen)}, {pocetZaku});");
}
