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