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