private void btn_izdaj_natisni_racun_Click(object sender, RoutedEventArgs e) { if (st_racuna == 0) { IzdajRacun okno = new IzdajRacun(); okno.ShowDialog(); if (okno.DialogResult == true) { string rok_placila = okno.RokPlacila; int tip_placila = okno.TipPlacila; if (tip_placila == 0) query_tipplacila = ", tip_placila = 0"; else if (tip_placila == 1) query_tipplacila = ", tip_placila = 1, rok_placila = '" + rok_placila + "'"; var connectionString = ConfigurationManager.ConnectionStrings["myDatabaseConnection"].ConnectionString; try { using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.ConnectionString = connectionString; var queryGetRacunId = "select max(ustvarjen_racun+1) from dokumenti where YEAR(ustvarjeno) = YEAR(CURDATE());"; connection.Open(); MySqlCommand commandgetid = new MySqlCommand(queryGetRacunId, connection); int maxid = Convert.ToInt32(commandgetid.ExecuteScalar()); var queryUpdateRacun = "update dokumenti set ustvarjen_racun = " + maxid + query_tipplacila + " where id = " + id_izbranega_dokumenta + ";"; using (MySqlCommand cmd = new MySqlCommand(queryUpdateRacun, connection)) { cmd.ExecuteNonQuery(); } connection.Close(); } lv_dokumenti.DataContext = new DokumentiViewModel(checkbox_izbran); cb_tip_dokumentov.SelectedIndex = checkbox_izbran; } catch (Exception ex) { MessageBox.Show(ex.Message); } } } else { //Natisni NatisniRacun racun = new NatisniRacun(); } }
private void NatisniSloRacun(int id_racuna) { NatisniRacun racun = new NatisniRacun(id_racuna); }