protected void GetData() { Collection <Zamestnanec> zamaznici = ZamestnanecTable.select(); BindingList <Zamestnanec> bindingList = new BindingList <Zamestnanec>(zamaznici); zamGrid.DataSource = bindingList; }
public bool NacistVhodneZamestnance(int ID, DateTime Datum) { Collection <Zamestnanec> zamestnanci = ZamestnanecTable.VypisVhodnychZamestnancu(ID, Datum); ZamestnanciLB.Items.Clear(); foreach (Zamestnanec zamestnanec in zamestnanci) { ZamestnanciLB.Items.Add(zamestnanec.ID_zamestnance + " " + zamestnanec.Jmeno + " " + zamestnanec.Prijmeni); } return(true); }
public bool NacistZamestnanceZTymu(int ID) { Collection <TymZamestnance> zamestnanci = TymZamestnanceTable.SeznamZamestnancuVTymu(ID); TymZamestnanceLB.Items.Clear(); foreach (TymZamestnance zamestnanec in zamestnanci) { Zamestnanec z = ZamestnanecTable.Select(zamestnanec.ID_zamestnance); TymZamestnanceLB.Items.Add(z.ID_zamestnance + " " + z.Jmeno + " " + z.Prijmeni); } return(true); }
private bool GetData() { Collection <Zakaznik> zakaznici = ZakaznikTable.select(); Collection <Zamestnanec> zamestnanci = ZamestnanecTable.select(); Collection <Zbran> zbrane = ZbranTable.select(); Collection <Prostor> prostory = ProstorTable.select(); strelba.Zacatek = dateTimePicker1.Value; strelba.Konec = dateTimePicker2.Value; strelba.Zakaznik_idZak = zakaznici[comboBox1.SelectedIndex].idZak; strelba.Zamestnanec_idZam = zamestnanci[comboBox2.SelectedIndex].idZam; strelba.Zbran_idZbr = zbrane[comboBox3.SelectedIndex].idZbr; strelba.Prostor_idSpr = prostory[comboBox4.SelectedIndex].idSpr; return(true); }
public bool OpenRecord(object primaryKey) { if (primaryKey != null) { int idZam = (int)primaryKey; zamestnanec = ZamestnanecTable.select(idZam); newRecord = false; } else { zamestnanec = new Zamestnanec(); zamestnanec.Datum_narozeni = new DateTime(2000, 01, 01); newRecord = true; } BindData(); return(true); }
private void BindData() { Collection <Zakaznik> zakaznici = ZakaznikTable.select(); Collection <Zamestnanec> zamestnanci = ZamestnanecTable.select(); Collection <Zbran> zbrane = ZbranTable.select(); Collection <Prostor> prostory = ProstorTable.select(); foreach (Zakaznik zakaznik in zakaznici) { comboBox1.Items.Add(zakaznik.Jmeno + " " + zakaznik.Prijmeni); if (zakaznik.idZak == strelba.Zakaznik_idZak) { comboBox1.SelectedIndex = comboBox1.Items.Count - 1; } } foreach (Zamestnanec zamestnanec in zamestnanci) { comboBox2.Items.Add(zamestnanec.Jmeno + " " + zamestnanec.Prijmeni); if (zamestnanec.idZam == strelba.Zamestnanec_idZam) { comboBox2.SelectedIndex = comboBox2.Items.Count - 1; } } foreach (Zbran zbran in zbrane) { comboBox3.Items.Add(zbran.Nazev); if (zbran.idZbr == strelba.Zbran_idZbr) { comboBox3.SelectedIndex = comboBox3.Items.Count - 1; } } foreach (Prostor prostor in prostory) { comboBox4.Items.Add(prostor.idSpr.ToString() + " " + prostor.vzdalenost.ToString()); if (prostor.idSpr == strelba.Prostor_idSpr) { comboBox4.SelectedIndex = comboBox4.Items.Count - 1; } } dateTimePicker1.Value = strelba.Zacatek; dateTimePicker2.Value = strelba.Konec; }
protected bool SaveRecord() { if (GetData()) { if (newRecord) { ZamestnanecTable.insert(zamestnanec); } else { ZamestnanecTable.update(zamestnanec); } return(true); } else { return(false); } }
private void novyZamB_Click(object sender, EventArgs e) { zamestnanec.jmeno = jmenoText.Text; zamestnanec.prijmeni = prijmeniText.Text; if (jmeno.Text != null && jmenoText.Text != "") { if (prijmeniText.Text != null && prijmeniText.Text != "") { if (poziceCB.Text != null && poziceCB.Text != "") { zamestnanec.pozice = new PoziceTable().select(poziceCB.Text); zamestnanec.id_Pozice = zamestnanec.pozice.id_pozice; int status = ZamestnanecTable.insert(zamestnanec); if (status >= 0) { MessageBox.Show("Zaměstnanec úspěšně vytvořen"); } else { MessageBox.Show("Chyba při vytváření nového zaměstnance"); } } else { MessageBox.Show("Je potřeba vybrat pozici zaměstnance"); } } else { MessageBox.Show("Je potřeba zadat příjmení zaměstnance"); } } else { MessageBox.Show("Je potřeba zadat jméno zaměstnance"); } }
protected void DeleteRecord() { ZamestnanecTable.delete(zamestnanec.idZam); }