public VisibleStockItem(ISposDb db, SaveableStockItem item) : base(item.Number, item.Quantity) { SimplePOS.Article.RegularArticle article = db.GetArticleByNumber(item.Number); if (article != null) { this.name = article.Name; this.text = article.Text; } }
public StockArticle(ISposDb db, SaveableStockItem item) : this(db) { textBox1.Text = item.Number; textBox2.Text = item.Quantity.ToString(); curr_quantity = item.Quantity; button2.Visibility = Visibility.Hidden; singleShow = true; textBox1.IsEnabled = false; }
public void SetItemToStock(SimplePOS.Inventory.SaveableStockItem item) { mutex.WaitOne(); connection.Open(); using (SQLiteCommand command = new SQLiteCommand(connection)) { //TODO if exist alter command.CommandText = "UPDATE stock SET item_quantity = " + item.Quantity + " WHERE item_id LIKE ?;"; command.Parameters.Add(new SQLiteParameter("item_id", item.Number)); //command.Parameters.Add(new SQLiteParameter("item_quantity", item.Quantity)); command.ExecuteNonQuery(); } connection.Close(); mutex.Release(); }
public void AddItemToStock(SimplePOS.Inventory.SaveableStockItem item) { mutex.WaitOne(); connection.Open(); using (SQLiteCommand command = new SQLiteCommand(connection)) { //TODO if exist alter (gemensame funktion command.CommandText = "INSERT INTO stock (item_id, item_quantity) VALUES (?,?);"; command.Parameters.Add(new SQLiteParameter("item_id", item.Number)); command.Parameters.Add(new SQLiteParameter("item_quantity", item.Quantity)); command.ExecuteNonQuery(); } connection.Close(); mutex.Release(); }
private void saveItemFromForm() { string number = textBox1.Text; SimplePOS.Article.AbstractArticle article = db.GetArticleByNumber(number); if (article == null) { // Artikel nicht vorhanden SimplePOS.Article.ArticleView window = new SimplePOS.Article.ArticleView(db, new SimplePOS.Article.RegularArticle(number)); window.Owner = this; window.ShowDialog(); article = db.GetArticleByNumber(number); // wenn nichts gültiges eingegeben wird --> beenden if (article == null) { return; } } double quantity = 0; try { quantity = Double.Parse(textBox2.Text); } catch { MessageBox.Show("Bitte Menge eingeben.", "", MessageBoxButton.OK, MessageBoxImage.Warning); return; } SaveableStockItem item = new SaveableStockItem(number, quantity); if (singleShow) { curr_quantity += item.Quantity; item.Quantity = curr_quantity; db.SetItemToStock(item); } else { db.AddItemToStock(item); } stop_stocking = false; }