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