private void Find_Click(object sender, RoutedEventArgs e) { string value = FindTB.Text.Trim(); if (commander.IsInputInvalid(value, "Category name")) { MessageBox.Show("Invalid value"); return; } if (commander.ExistsInDatabaseByNameCaseInsensitive(OSHome.DbSources.Categories, value, out string found)) { int categoryId = db.Categories.Single(x => x.category_name == found).category_id; MessageBox.Show($"Found:\nID: {categoryId}\nName: {found}"); return; } MessageBox.Show("Not Found"); FindTB.Text = "Category name"; }
private void Add_Click(object sender, RoutedEventArgs e) { string value = AddNameTB.Text.Trim(); if (commander.IsInputInvalid(value, "Producer name")) { MessageBox.Show($"Can't add empty or default value to database."); return; } if (commander.ExistsInDatabaseByNameCaseInsensitive(OSHome.DbSources.Producers, value, out string found)) { MessageBox.Show($"Producer with name {found} already exists in database."); return; } Producers newProducer = new Producers(); newProducer.producer_name = value; db.Producers.Add(newProducer); db.SaveChanges(); MessageBox.Show($"Successfully added new producer to database: {value}."); AddNameTB.Text = "Producer name"; }