public ObservableCollection <FittingsClass> LoadAllFittings()
{
ObservableCollection <FittingsClass> _fittings = new ObservableCollection <FittingsClass>();
SqlCommand cmd = new SqlCommand($"select okovid, nazivokova, jedinicamere, cena from okov", _conn);
try
{
_conn.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
FittingsClass fitting = new FittingsClass()
{
ID = reader.GetInt64(0),
FittingName = reader.GetString(1),
UnitOfMeasure = reader.GetString(2),
Price = reader.GetDecimal(3)
};
_fittings.Add(fitting);
}
return(_fittings);
}
finally
{
_conn.Close();
}
}
public void RemoveFittings(FittingsClass fitting)
{
foreach (var item in _fittingsInElement)
{
if (item.ID == fitting.ID)
{
_fittingsInElement.Remove(item);
break;
}
}
}
public void AddFittings(FittingsClass fitting)
{
if (_fittingsInElement.Contains(fitting))
{
foreach (var item in _fittingsInElement)
{
if (item.ID == fitting.ID)
{
item.Quantity += fitting.Quantity;
}
}
}
else
{
_fittingsInElement.Add(fitting);
}
}
private void executeInsertFittingCommand()
{
FittingsClass fitting = new FittingsClass()
{
ID = SelectedFitting.ID,
FittingName = SelectedFitting.FittingName,
Price = SelectedFitting.Price,
UnitOfMeasure = SelectedFitting.UnitOfMeasure,
Quantity = _nuber
};
if (_table != null)
{
_table.AddFittings(fitting);
}
Number = 0f;
}
