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