private void btn_Zmaz_Kuriera_Click(object sender, EventArgs e)
{
SqlConnection MyConn = new SqlConnection(pripojenie);
MyConn.Open();
string delete = "delete from Kurier where ID_Kurier='" + cb_Zamestnanec_Kurier_ID.Text + "'";
sql = new SqlCommand(delete, MyConn);
sql.ExecuteNonQuery();
ds_Kurier.Tables["Kurier"].Clear();
MyAdapter3.Fill(ds_Kurier, "Kurier");
dgw_Kurier.DataSource = ds_Kurier.Tables["Kurier"];
}
private void btn_Pridaj_Kuriera_Click(object sender, EventArgs e)
{
SqlConnection MyConn = new SqlConnection(pripojenie);
MyConn.Open();
string insert = "insert into Kurier(ID_Kurier,Cislo_Trasy,Vozidlo_ID_Vozidlo,Uzivatel_Username,Zamestnanec_ID_Zamestnanec) values (next value for sekKurier, '" + num_Kurier_Cislo_Trasy.Value + "','" + cb_ID_Vozidlo_Kurier.Text + "','" + cb_Evidoval_Kuriera.Text + "','" + cb_Zamestnanec_Kurier.Text + "') ";
sql = new SqlCommand(insert, MyConn);
sql.ExecuteNonQuery();
ds_Kurier.Tables["Kurier"].Clear();
MyAdapter3.Fill(ds_Kurier, "Kurier");
dgw_Kurier.DataSource = ds_Kurier.Tables["Kurier"];
}
private void btn_Edituj_Kuriera_Click(object sender, EventArgs e)
{
SqlConnection MyConn = new SqlConnection(pripojenie);
MyConn.Open();
string update = "UPDATE Kurier SET Cislo_Trasy = '" + num_Kurier_Cislo_Trasy.Text + "', " +
"Vozidlo_ID_Vozidlo = '" + cb_ID_Vozidlo_Kurier.Text + "', " +
"Uzivatel_Username = '******', " +
"Zamestnanec_ID_Zamestnanec = '" + cb_Zamestnanec_Kurier.Text + "' WHERE ID_Kurier = '" + cb_Zamestnanec_Kurier_ID.Text + "'";
sql = new SqlCommand(update, MyConn);
sql.ExecuteNonQuery();
ds_Kurier.Tables["Kurier"].Clear();
MyAdapter3.Fill(ds_Kurier, "Kurier");
dgw_Kurier.DataSource = ds_Kurier.Tables["Kurier"];
}
private void btn_Editovat_Objednavku_Click(object sender, EventArgs e)
{
SqlConnection MyConn = new SqlConnection(pripojenie);
MyConn.Open();
string update = "UPDATE Objednavka SET Cena = '" + tb_Cena_Objednavky.Text + "', " +
"Hmotnost = '" + tb_Hmotnost_Objednavky.Text + "', " +
"Pocet_Balikov = '" + num_Pocet_Balikov.Text + "', " +
"Datum_Prijatia = '" + dt_DP_Objednavky.Text + "', " +
"Datum_Dorucenia = '" + dt_DD_Objednavky.Text + "', " +
"Stav = '" + cb_Stav_Objednavky.Text + "', " +
"Kurier_ID_Kurier = '" + cb_ID_Kurier_Objednavka.Text + "', " +
"Uzivatel_Username = '******', " +
"Prijemca_ID_Prijemca = '" + tb_Prijemca_Objednavky.Text + "', " +
"Odosielatel_ID_Odosielatel = '" + tb_Odosielatel_Objednavky.Text + "' WHERE ID_Kurier = '" + cb_ID_Objednavky.Text + "'";
sql = new SqlCommand(update, MyConn);
sql.ExecuteNonQuery();
ds_Objednavky.Tables["Objednavka"].Clear();
MyAdapter3.Fill(ds_Kurier, "Objednavka");
dgw_Objednavky.DataSource = ds_Kurier.Tables["Objednavka"];
}