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