public void testTabulkyZarizeni(Database db) { Console.Out.WriteLine("-------------------------------------------------------------------------------"); Console.Out.WriteLine("Zkouška tabulky Zarizeni:"); Zarizeni zarizeni = new Zarizeni(); zarizeni.idZarizeni = 1; zarizeni.SpecifikaceZarizeni_idSpecifikaceZarizeni = 1; zarizeni.nazev = "P400/29 xjks"; zarizeni.vyrobce = "Ja"; zarizeni.zaruka = 24; zarizeni.datumSpusteni = new DateTime(2017, 3, 1, 7, 0, 0); zarizeni.StavZarizeni_idStavZarizeni = 1; //EvidenceZarizeni.Insert(zarizeni, db); Console.Out.WriteLine("Nové zařízení vloženo!\n"); Collection <Zarizeni> selectZarizeni = new Collection <Zarizeni>(); selectZarizeni = EvidenceZarizeni.Select(db); Console.Out.WriteLine("Select z tabulky zarizeni:"); // select detail> //sp.vyrobniCislo, sp.model, sp.vykon, sp.emisniTrida, sp.posledniKontrola // select normal> //idZarizeni, SpecifikaceZarizeni_idSpecifikaceZarizeni, nazev, vyrobce, zaruka, datumSpusteni, StavZarizeni_idStavZarizeni foreach (Zarizeni select in selectZarizeni) { Console.Out.WriteLine("\t" + select.idZarizeni + " | --- | " + select.SpecifikaceZarizeni_idSpecifikaceZarizeni + " " + select.nazev + " " + select.vyrobce + " " + select.zaruka + " " + select.datumSpusteni); } Console.Out.WriteLine("\nPoslední záznam z tabulky zarizeni byl upraven! (nazev)"); zarizeni.nazev = "P400/29"; zarizeni.vyrobce = "Ja Taky"; EvidenceZarizeni.Update(zarizeni, db); Console.Out.WriteLine("\nDetail posledního záznamu z tabulky zarizeni:"); SpecifikaceZarizeni selectDetail = new SpecifikaceZarizeni(); selectDetail = EvidenceZarizeni.SelectDetail(1, db); Console.Out.WriteLine("\t" + selectDetail.vyrobniCislo + " | --- | " + selectDetail.model + " | --- | " + selectDetail.vykon + " | --- | " + selectDetail.emisniTrida + " | --- | " + selectDetail.posledniKontrola); Console.Out.WriteLine("-------------------------------------------------------------------------------\n"); }
public void Zobrazit(FormMain f) { mainForm = f; Database db = new Database(); db.Connect(); zakaznici = EvidenceZakaznika.Select(db); zarizeni = EvidenceZarizeni.Select(db); db.Close(); nazevTextBox.Text = ""; smlouvaTextBox.Text = ""; comboBox1.DisplayMember = "Prijmeni"; comboBox1.DataSource = zakaznici; comboBox2.DisplayMember = "nazev"; comboBox2.DataSource = zarizeni; dateTimePicker1.Value = DateTime.Now; this.Show(); }