internal void InitEdit(int id, Form_Seznam_Zamestnanec parent)
{
this._parent = parent;
DataTable dt_zam = dt.getZamestnanec(id);
this.Id = id;
this.button_Pridat.Text = "Upravit";
this.textBox_Jmeno.Text = dt_zam.Rows[0]["Jmeno"].ToString();
this.textBox_Prijmeni.Text = dt_zam.Rows[0]["Prijmeni"].ToString();
this.textBox_Pracovni_Email.Text = dt_zam.Rows[0]["Pracovni_Email"].ToString();
this.textBox_Soukromy_Email.Text = dt_zam.Rows[0]["Soukromy_Email"].ToString();
this.textBox_Uvazek.Text = dt_zam.Rows[0]["Uvazek"].ToString();
for (int i = 0; i < comboBox_Doktorant.Items.Count; i++)
{
if ((comboBox_Doktorant.Items[i] as combobox_item).id == Convert.ToInt32(Convert.ToBoolean(dt_zam.Rows[0]["Doktorand"].ToString())))
{
comboBox_Doktorant.SelectedIndex = i;
comboBox_Doktorant.SelectedItem = comboBox_Doktorant.Items[i];
}
}
Uvazky uvazky = new Uvazky(true);
double body = 0;
DataTable dataTable = dt.getPracovniStitekNJZamestnanec(id);
foreach (DataRow drSt in dataTable.Rows)
{
body += uvazky.getBody(
(TypStitek)(int)drSt.ItemArray[dataTable.Columns.IndexOf("Typ_Stitek")],
(TypJazyk)(int)drSt.ItemArray[dataTable.Columns.IndexOf("Jazyk")],
Convert.ToDouble(drSt.ItemArray[dataTable.Columns.IndexOf("Pocet_Hodin")]),
Convert.ToDouble(drSt.ItemArray[dataTable.Columns.IndexOf("Uvazek")])
);
}
;
this.textBox_Pracovni_Body.Text = body.ToString();
double body_bez_AJ = 0;
foreach (DataRow drSt in dataTable.Rows)
{
body_bez_AJ += uvazky.getBody(
(TypStitek)(int)drSt.ItemArray[dataTable.Columns.IndexOf("Typ_Stitek")],
(TypJazyk)(int)drSt.ItemArray[dataTable.Columns.IndexOf("Jazyk")],
Convert.ToDouble(drSt.ItemArray[dataTable.Columns.IndexOf("Pocet_Hodin")]),
Convert.ToDouble(drSt.ItemArray[dataTable.Columns.IndexOf("Uvazek")]),
true
);
}
;
this.textBox_Pracovni_Body_Bez_AJ.Text = body_bez_AJ.ToString();
}
private void Form_Pridat_Stitek_Load(object sender, EventArgs e)
{
DataTable dataT_Zamestnanci = DB_Data.getZamestnanec();
DataTable dataT_Jazyky = DB_Data.getJazyk();
DataTable dataT_Typ_Stitek = DB_Data.getTypStitek();
DataTable dataT_Predmet = DB_Data.getPredmet();
List <combobox_item> col_Zamestnanec = new List <combobox_item>();
List <combobox_item> col_Jazyky = new List <combobox_item>();
List <combobox_item> col_Typ_Stitek = new List <combobox_item>();
List <combobox_item> col_Predmet = new List <combobox_item>();
foreach (DataRow dr in dataT_Zamestnanci.Rows)
{
col_Zamestnanec.Add(new combobox_item {
id = Convert.ToInt32(dr.ItemArray[0]), zkratka = string.Empty, nazev = dr.ItemArray[1].ToString().Trim() + " " + dr.ItemArray[2].ToString().Trim()
});
}
foreach (DataRow dr in dataT_Jazyky.Rows)
{
col_Jazyky.Add(new combobox_item {
id = Convert.ToInt32(dr.ItemArray[0]), zkratka = dr.ItemArray[1].ToString().Trim(), nazev = dr.ItemArray[2].ToString().Trim()
});
}
foreach (DataRow dr in dataT_Typ_Stitek.Rows)
{
col_Typ_Stitek.Add(new combobox_item {
id = Convert.ToInt32(dr.ItemArray[0]), zkratka = dr.ItemArray[1].ToString().Trim(), nazev = dr.ItemArray[2].ToString().Trim()
});
}
foreach (DataRow dr in dataT_Predmet.Rows)
{
col_Predmet.Add(new combobox_item {
id = Convert.ToInt32(dr.ItemArray[0]), zkratka = dr.ItemArray[1].ToString().Trim(), nazev = dr.ItemArray[2].ToString().Trim()
});
}
//Zdroje comboboxů
comboBox_Zamestnanec.DataSource = col_Zamestnanec;
comboBox_Jazyk.DataSource = col_Jazyky;
comboBox_Typ_Stitek.DataSource = col_Typ_Stitek;
comboBox_Predmet.DataSource = col_Predmet;
//Select default empty value
comboBox_Zamestnanec.SelectedIndex = -1;
comboBox_Jazyk.SelectedIndex = -1;
comboBox_Typ_Stitek.SelectedIndex = -1;
comboBox_Predmet.SelectedIndex = -1;
}
public void Form_Seznam_Zamestnanec_Load(object sender, EventArgs e)
{
dataGridView1.Rows.Clear();
DataTable dbtable = DB_Data.getZamestnanec();
int i = 0;
Uvazky uvazky = new Uvazky(true);
foreach (DataRow dr in dbtable.Rows)
{
double body = 0;
DataTable dataTable = DB_Data.getPracovniStitekNJZamestnanec(Convert.ToInt32(dr.ItemArray[0]));
foreach (DataRow drSt in dataTable.Rows)
{
body += uvazky.getBody(
(TypStitek)(int)drSt.ItemArray[dataTable.Columns.IndexOf("Typ_Stitek")],
(TypJazyk)(int)drSt.ItemArray[dataTable.Columns.IndexOf("Jazyk")],
Convert.ToDouble(drSt.ItemArray[dataTable.Columns.IndexOf("Pocet_Hodin")]),
Convert.ToDouble(drSt.ItemArray[dataTable.Columns.IndexOf("Uvazek")])
);
}
DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[i++].Clone();
row.Cells[0].Value = Convert.ToInt32(dr.ItemArray[0]);
row.Cells[1].Value = dr.ItemArray[1].ToString() + " " + dr.ItemArray[2].ToString();
row.Cells[2].Value = dr.ItemArray[3];
row.Cells[3].Value = dr.ItemArray[4];
row.Cells[4].Value = (bool)dr.ItemArray[5] ? "Ano" : "Ne";
row.Cells[5].Value = dr.ItemArray[6];
row.Cells[6].Value = body;
//row.Cells[2].Value = dt.getNazevTypStitek(Convert.ToInt32(dr.ItemArray[3]));
//if (dr.ItemArray[1].ToString() != string.Empty)
// row.Cells[3].Value = dt.getZamestnanecJmeno(Convert.ToInt32(dr.ItemArray[1]));
dataGridView1.Rows.Add(row);
}
}
public void InitValue(int Id, string Nazev, string typ, string nazev_zamestnanec)
{
DataTable dataT_zamestnanci = dt.getZamestnanec();
List <combobox_item> col_Zamestnanec = new List <combobox_item>();
foreach (DataRow dr in dataT_zamestnanci.Rows)
{
col_Zamestnanec.Add(new combobox_item {
id = Convert.ToInt32(dr.ItemArray[0]), zkratka = string.Empty, nazev = dr.ItemArray[1].ToString().Trim() + " " + dr.ItemArray[2].ToString().Trim()
});
}
//Zdroje comboboxů
comboBox_Zamestnanec.DataSource = col_Zamestnanec;
//Select default empty value
comboBox_Zamestnanec.SelectedIndex = -1;
this.Id = Id;
this.textBox1.Text = Nazev;
this.textBox2.Text = typ;
if (nazev_zamestnanec != String.Empty)
{
for (int i = 0; i < comboBox_Zamestnanec.Items.Count; i++)
{
if ((comboBox_Zamestnanec.Items[i] as combobox_item).nazev.ToLower().Trim() == nazev_zamestnanec.ToLower().Trim())
{
comboBox_Zamestnanec.SelectedIndex = i;
comboBox_Zamestnanec.SelectedItem = comboBox_Zamestnanec.Items[i];
}
}
}
}