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});"); }