private void btnPotvrdi_Click(object sender, EventArgs e) { IList <int> listaSirovina = new List <int>(); SqlConnection myConnection = new SqlConnection(@"Data Source=31.147.204.119\PISERVER,1433;Initial Catalog=17015_DB;Integrated Security=False;User ID=17015_User;Password=546YQ8yy;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); SqlDataAdapter myDataAdapter = new SqlDataAdapter("SELECT id_sirovina FROM primka_sirovina WHERE id_primke = " + idPrimke, myConnection); DataTable dataTable = new System.Data.DataTable(); myDataAdapter.Fill(dataTable); using (IDataReader reader = dataTable.CreateDataReader()) while (reader.Read()) { listaSirovina.Add(reader.GetInt32(reader.GetOrdinal("id_sirovina"))); } if (listaSirovina.Count.Equals(0)) { MessageBox.Show("Ne možete kreirati prazan dokument!", "Upozorenje", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { foreach (int item in listaSirovina) { int trenutnaKolicina = Int32.Parse(sirovinaTableAdapter.DohvatiKolicinu(item).ToString()); int zaprimljenaKolicina = Int32.Parse(primka_sirovinaTableAdapter.DohvatiKolicinu(item, idPrimke).ToString()); int novaKolicina = PomocneClass.dajPovecanuKolicinu(trenutnaKolicina, zaprimljenaKolicina); sirovinaTableAdapter.UpdateQueryAzurirajKolicinu(novaKolicina, item); } this.Close(); } }
private void btnPotvrdi_Click(object sender, EventArgs e) { DataSetSirovineTableAdapters.otpisnicaTableAdapter noviTblaOtpisnica = new DataSetSirovineTableAdapters.otpisnicaTableAdapter(); DataSetSirovineTableAdapters.otpisnica_sirovinaTableAdapter noviTblaOtpisnicaSirovina = new DataSetSirovineTableAdapters.otpisnica_sirovinaTableAdapter(); int?brojSirovina = noviTblaOtpisnicaSirovina.BrojSirovina(sifraOtpisnice); if (brojSirovina == 0) { MessageBox.Show("Ne možete kreirati prazan dokument!", "Upozorenje", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { foreach (DataGridViewRow row in dgvPopisSirovinaNaOtpisnici.Rows) { DataSetSirovineTableAdapters.sirovinaTableAdapter noviSirovine = new DataSetSirovineTableAdapters.sirovinaTableAdapter(); int staraKolicina = noviSirovine.ScalarQueryDostupnaKolicina(Int32.Parse(row.Cells[1].Value.ToString())).Value; int kolicinaZaOduzeti = Int32.Parse(row.Cells[2].Value.ToString()); int novaKolicina = PomocneClass.dajSmanjenuKolicinu(staraKolicina, kolicinaZaOduzeti); noviSirovine.UpdateQueryDostupnaKolicina(novaKolicina, Int32.Parse(row.Cells[1].Value.ToString())); } MessageBox.Show("Uspjesno ste otpisali sirovine sa skladista i kreirali otpisnicu!", "Poruka", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } }
private void btnKreiraj_Click(object sender, EventArgs e) { if (txtSifra.Text != "" && txtNaslov.Text != "" && txtOpis.Text != "") { int idIzdatnica = Int32.Parse(txtSifra.Text); string naslov = txtNaslov.Text; string opis = txtOpis.Text; string datum = inputDatum.Text; int idKorisnik = 2; int brojIzdatnica = Int32.Parse(zahtjevnica_sirovinaTableAdapter.FillByIdIzdatniceBrojRedova(idIzdatnica).ToString()); if (brojIzdatnica != 0) { MessageBox.Show("Izdatnica s ovom šifrom već postoji!", "Upozorenje", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { zahtjevnica_sirovinaTableAdapter.InsertQueryIntoIzdatnica(idIzdatnica, naslov, opis, datum, idKorisnik, idZahtjevnica); for (int i = 0; i < dgvPopisSirovinaIzdatnica.RowCount; i++) { int id_sirovina = Int32.Parse(dgvPopisSirovinaIzdatnica.Rows[i].Cells[0].Value.ToString()); int kolicina = Int32.Parse(dgvPopisSirovinaIzdatnica.Rows[i].Cells[2].Value.ToString()); int staraKolicina = Int32.Parse(dgvPopisSirovinaIzdatnica.Rows[i].Cells[3].Value.ToString()); int novaKolicina = PomocneClass.dajSmanjenuKolicinu(staraKolicina, kolicina); DataSetSirovineTableAdapters.sirovinaTableAdapter noviTableAdapterSirovina = new DataSetSirovineTableAdapters.sirovinaTableAdapter(); noviTableAdapterSirovina.UpdateQueryDostupnaKolicina(novaKolicina, id_sirovina); zahtjevnica_sirovinaTableAdapter.InsertQueryIzdatnicaSirovina(idIzdatnica, id_sirovina, kolicina); } MessageBox.Show("Uspjesno ste kreirali novu izdatnicu", "Uspjeh", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } else { MessageBox.Show("Niste unjeli sve podatke!", "Upozorenje", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }