private void AddButton(object sender, RoutedEventArgs e)
{
if(CategoryName.Text == "")
{
MessageBox.Show("Please Enter A Category Name");
}
else // two cases if it already exit , else add it to database
{
sql_queries sql = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
bool found = sql.check_catagory(CategoryName.Text);
if (found)
{
MessageBox.Show("This Category is Already Exist");
}
else
{
// e3mel query y insert Category *note that how we can make the combbobox change when insertion , delete
sql.Add_catagory(CategoryName.Text);
MessageBox.Show("Category Inserted Successfully");
}
}
}
private void RemoveButton(object sender, RoutedEventArgs e)
{
if (DeleteCategoryName.Text == "")
{
MessageBox.Show("Please Enter A Category Name");
}
else // two cases if exist delete else print not exist
{
sql_queries sql = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
bool found = sql.check_catagory(DeleteCategoryName.Text);
if (found) // delete
{
// e3mal query y delete el category
sql.Delete_catagory(DeleteCategoryName.Text);
sql.update_catagories(DeleteCategoryName.Text);
MessageBox.Show("Category Removed Successfully");
}
else
{
MessageBox.Show("This Category isn't Exist");
}
}
}
