private void btn_delete_radnik_Click(object sender, EventArgs e)
{
k = new mysqlController();
k.InsertUpdateDelete("delete from tbl_radnik where id=@id",
new MySqlParameter("@id", Convert.ToInt32(txt_radnik_id.Text)));
PuniRadnikGrid();
}
private void btn_update_radnik_Click(object sender, EventArgs e)
{
k.InsertUpdateDelete("update tbl_radnik set ime=@ime, prezime=@prezime, maticni = @maticni, sektorid = @sektorid where id=@id",
new MySqlParameter("@ime", txt_ime.Text),
new MySqlParameter("@prezime", txt_prezime.Text),
new MySqlParameter("@maticni", txt_maticni.Text),
new MySqlParameter("@sektorid", combo_sektor.SelectedValue),
new MySqlParameter("@id", Convert.ToInt32(txt_radnik_id.Text)));
PuniRadnikGrid();
}
private void btn_insert_radnik_Click(object sender, EventArgs e)
{
k = new mysqlController();
k.InsertUpdateDelete("insert into tbl_radnik (ime, prezime,maticni, sektorid) values (@ime, @prezime, @maticni, @sektorid)",
new MySqlParameter("@ime", txt_ime.Text),
new MySqlParameter("@prezime", txt_prezime.Text),
new MySqlParameter("@maticni", txt_maticni.Text),
new MySqlParameter("@sektorid", combo_sektor.SelectedValue));
PuniRadnikGrid();
}
