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