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);
}
