private void Add() { Alat alat = new Alat(); foreach (Alat a in entities.Alats) { if (a.Sifra_alata == SelectedAlat) { alat = a; } } Popravlja popravlja = new Popravlja(); foreach (Popravlja p in entities.Popravljas) { if (p.Kvar_Sifra_kvara == SelectedKvar) { popravlja = p; } } string ime = popravlja.Majstor.Radnik.Ime; popravlja.Alats.Add(alat); string kvar = popravlja.Kvar.Tip_kvara; (entities.Popravljas.Where(a => a.Kvar_Sifra_kvara == SelectedKvar).FirstOrDefault().Alats).Add(entities.Alats.Where(m => m.Sifra_alata == SelectedAlat).FirstOrDefault()); entities.SaveChanges(); majstorKvarList.Add(new KeyValuePair <Popravlja, Alat>(popravlja, alat)); }
public IList <Alat> VratiSveAlate() { connection.Open(); List <Alat> alati = new List <Alat>(); SqlDataReader reader = null; try { SqlCommand command = connection.CreateCommand(); command.CommandText = "SELECT * FROM Alat ORDER BY Naziv"; reader = command.ExecuteReader(); while (reader.Read()) { Alat a = new Alat() { AlatId = reader.GetInt32(0), Naziv = reader.GetString(1), StanjeNaZalihama = reader.GetInt32(2) }; alati.Add(a); } } catch (Exception e) { throw new Exception("Greska u radu s bazom"); } finally { connection.Close(); reader.Close(); } return(alati); }
private void SaveUpdateAlat() { Alat nadjen = new Alat(); foreach (Alat m in entities.Alats) { if (m.Sifra_alata == SelectedItem.Sifra_alata) { nadjen = m; } } Alat alat = new Alat(); if (Naziv != string.Empty) { alat.Naziv_alata = Naziv; } alat.Sifra_alata = SelectedItem.Sifra_alata; alatList.Remove(SelectedItem); entities.Alats.Remove(nadjen); alatList.Add(alat); entities.Alats.Add(alat); entities.SaveChanges(); }
private void AddAlat() { Alat alat = new Alat(); Random rand = new Random(); alat.Naziv_alata = Naziv; alat.Sifra_alata = rand.Next(0, 100); entities.Alats.Add(alat); entities.SaveChanges(); alatList.Add(alat); Naziv = string.Empty; }
private void btnObrisiAlat_Click(object sender, EventArgs e) { if (dgvAlati.SelectedRows.Count > 0) { Alat a = (Alat)dgvAlati.SelectedRows[0].DataBoundItem; alatiNaFormi.Remove(a); foreach (Alat alat in alatiIzBaze) { if (alat.Equals(a)) { alat.StanjeNaZalihama = alat.StanjeNaZalihama + a.StanjeNaZalihama; return; } } } }
private void DeleteAlat() { Alat nadjen = new Alat(); foreach (Alat m in entities.Alats) { if (AlatList.Contains(SelectedItem)) { nadjen = SelectedItem; } } foreach (Alat m in entities.Alats) { if (m.Sifra_alata == SelectedItem.Sifra_alata) { nadjen = m; } } AlatList.Remove(nadjen); entities.Alats.Remove(nadjen); entities.SaveChanges(); }
private void btnDodajAlat_Click(object sender, EventArgs e) { Alat a = (Alat)cmbAlati.SelectedItem; foreach (Alat alat in alatiNaFormi) { if (alat.AlatId == a.AlatId) { foreach (Alat alatIzBaze in alatiIzBaze) { if (alatIzBaze.Equals(alat)) { if (alatIzBaze.StanjeNaZalihama > 0) { alat.StanjeNaZalihama++; } else { MessageBox.Show($"{alatIzBaze.Naziv} je presusio na zalihama"); return; } } } foreach (Alat al in alatiIzBaze) { if (al.AlatId == alat.AlatId) { al.StanjeNaZalihama--; break; } } dgvAlati.Refresh(); return; } } foreach (Alat alatBaza in alatiIzBaze) { if (alatBaza.Equals(a)) { if (alatBaza.StanjeNaZalihama > 0) { alatiNaFormi.Add(a); a.StanjeNaZalihama = 1; foreach (Alat al in alatiIzBaze) { if (al.AlatId == a.AlatId) { al.StanjeNaZalihama--; break; } } dgvAlati.Refresh(); } else { MessageBox.Show($"{alatBaza.Naziv} je presusio na zalihama"); return; } } } }