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