public void mSQL_SFakturaIzmeni(int IDFakt, string RedniBroj, int cena, int kolicina)
{
Connect();
MySqlCommand check_ID = new MySqlCommand();
check_ID.CommandText = "SELECT COUNT(*) FROM stavke_faktura WHERE xID=@ID";
check_ID.Parameters.AddWithValue("@ID", IDFakt);
check_ID.Connection = connection;
var checkNumberID = check_ID.ExecuteScalar();
int valueID = Convert.ToInt32(checkNumberID);
if (valueID > 0)
{
ListaStavki SfaktPage = new ListaStavki();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "UPDATE stavke_faktura SET xRedniBroj = @RedniBroj, xCena = @cena, xKolicina = @Kolicina , xUkupno = @ukupno WHERE xID = @ID";
cmd.Parameters.AddWithValue("@RedniBroj", RedniBroj);
cmd.Parameters.AddWithValue("@cena", cena);
cmd.Parameters.AddWithValue("@Kolicina", kolicina);
cmd.Parameters.AddWithValue("@ukupno", (cena * kolicina));
cmd.Parameters.AddWithValue("@ID", IDFakt);
cmd.Connection = connection;
var check = cmd.ExecuteScalar();
int value = Convert.ToInt32(check);
MessageBox.Show("Uspesno ste izmenili stavku fakture");
SfaktPage.RefreshGrid();
}
else
{
MessageBox.Show("Taj ID Stavke ne postoji");
}
}
private void btnListaS_Click(object sender, EventArgs e)
{
ListaStavki listaPage = new ListaStavki();
listaPage.ShowDialog();
}
