private void btn_Pridaj_Zamestnanca_Click(object sender, EventArgs e)
{
SqlConnection MyConn = new SqlConnection(pripojenie);
MyConn.Open();
string insert = "insert into Zamestnanec(ID_Zamestnanec,Meno,Priezvisko,Datum_Narodenia,Narodnost,Ulica,Mesto,Pozicia,Telefon,Email,Uzivatel_Username) values (next value for sekZamestnanec,'" + tb_Meno_Zamestnanca.Text + "','" + tb_Priezvisko_Zamestnanca.Text + "','" + dtp_Datum_Narodenia_Z.Text + "','" + tb_Narodnost_Zamestnanca.Text + "','" + tb_Ulica_Zamestnanca.Text + "','" + tb_Mesto_Zamestnanca.Text + "','" + cb_Pozicia_Zamestnanca.Text + "','" + tb_Telefon_Zamestnanca.Text + "','" + tb_Email_Zamestnanca.Text + "','" + cb_Zamestnanec_Uzivatel.Text + "') ";
sql = new SqlCommand(insert, MyConn);
sql.ExecuteNonQuery();
ds_Zamestnanec.Tables["Zamestnanec"].Clear();
MyAdapter5.Fill(ds_Zamestnanec, "Zamestnanec");
dgw_Zamestnanec.DataSource = ds_Zamestnanec.Tables["Zamestnanec"];
}
private void btn_Zmaz_Zamestnanca_Click(object sender, EventArgs e)
{
SqlConnection MyConn = new SqlConnection(pripojenie);
MyConn.Open();
string delete = "delete from Zamestnanec where ID_Zamestnanec='" + cb_ID_Zamestnanec.Text + "'; " +
"delete from Kurier where Zamestnanec_ID_Zamestnanec='" + cb_ID_Zamestnanec.Text + "';";
sql = new SqlCommand(delete, MyConn);
sql.ExecuteNonQuery();
ds_Zamestnanec.Tables["Zamestnanec"].Clear();
MyAdapter5.Fill(ds_Zamestnanec, "Zamestnanec");
dgw_Zamestnanec.DataSource = ds_Zamestnanec.Tables["Zamestnanec"];
}
private void btn_Edituj_Zamestnanca_Click(object sender, EventArgs e)
{
SqlConnection MyConn = new SqlConnection(pripojenie);
MyConn.Open();
string update = "UPDATE Zamestnanec SET Meno = '" + tb_Meno_Zamestnanca.Text + "', " +
"Priezvisko = '" + tb_Priezvisko_Zamestnanca.Text + "', " +
"Datum_Narodenia = '" + dtp_Datum_Narodenia_Z.Text + "', " +
"Narodnost = '" + tb_Narodnost_Zamestnanca.Text + "', " +
"Ulica = '" + tb_Ulica_Zamestnanca.Text + "', " +
"Mesto = '" + tb_Mesto_Zamestnanca.Text + "', " +
"Pozicia = '" + cb_Pozicia_Zamestnanca.Text + "', " +
"Telefon = '" + tb_Telefon_Zamestnanca.Text + "', " +
"Email = '" + tb_Email_Zamestnanca.Text + "', " +
"Uzivatel_Username = '******' WHERE ID_Zamestnanec = '" + cb_ID_Zamestnanec.Text + "'";
sql = new SqlCommand(update, MyConn);
sql.ExecuteNonQuery();
ds_Zamestnanec.Tables["Zamestnanec"].Clear();
MyAdapter5.Fill(ds_Zamestnanec, "Zamestnanec");
dgw_Zamestnanec.DataSource = ds_Zamestnanec.Tables["Zamestnanec"];
}
