private void dataGridViewStockBalances_SelectionChanged(object sender, EventArgs e) { var row = dataGridViewStockBalances.CurrentRow; var storeId = (int)row.Cells[0].Value; var isbn = row.Cells[1].Value.ToString(); using (var db = new BokhandelContext()) { var stockBalance = db.LagerSaldo .Include(s => s.Böcker) .SingleOrDefault(ls => ls.ButikerId == storeId && ls.Isbn == isbn); SelectedStockBalance = stockBalance; } OnSelectionChanged(EventArgs.Empty); if (SelectedStockBalance != null) { labelEditStockBalanceTitle.Text = SelectedStockBalance.Böcker.Titel; numericUpDownStockBalance.Value = SelectedStockBalance.Antal; } else { labelEditStockBalanceTitle.Text = "Ingen bok vald."; numericUpDownStockBalance.Value = 0; } }
private void CreateStockBalance() { using var db = new BokhandelContext(); if (!db.Database.CanConnect()) { return; } var selectedBook = userControlBooks.SelectedBook; var stockBalance = new LagerSaldo { ButikerId = SelectedBookstore.Id, Isbn = selectedBook.Isbn, Antal = (int)numericUpDownAmount.Value }; StockBalance = stockBalance; db.LagerSaldo.Add(stockBalance); db.SaveChanges(); numericUpDownAmount.Value = 0; OnStockBalanceCreated(EventArgs.Empty); }