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