private void Button_Click(object sender, RoutedEventArgs e)
        {
            int i = 1;

            if ((string)categoeryCB.SelectedItem != "" && (string)categoeryCB.SelectedItem != null)
            {
                var categoery = _db.Catergoeries.ToList();
                i = categoery.First(c => c.Name == (string)categoeryCB.SelectedItem).Id;
            }
            Part updatePart = (from p in _db.Parts where p.Id == Id select p).Single();

            if (partNumTB.Text == currentPartNum || !partsObject.CheckIfPartNumberCreated(partNumTB.Text))
            {
                updatePart.Link        = linkTB.Text;
                updatePart.PartNumber  = partNumTB.Text;
                updatePart.Description = DescTB.Text;
                updatePart.Supplier    = supplierTB.Text;
                updatePart.Price       = priceTB.Text;

                updatePart.CatergoeryId = i;

                _db.SaveChanges();
                MainWindow.frame.Content = new PartsHomePage();
            }
            else
            {
                MessageBox.Show($"{updatePart.PartNumber} is already used. Please update part with this part number\nor check part number is correct.");
            }
        }
        private void addBtn_Click(object sender, RoutedEventArgs e)
        {
            PartsViewModel parts = new PartsViewModel();
            int            i     = 9;

            try
            {
                if ((string)catergoeryComboBox.SelectedItem != "")
                {
                    var categoery = _db.Catergoeries.ToList();
                    i = categoery.First(c => c.Name == (string)catergoeryComboBox.SelectedItem).Id;
                }
            }
            catch (Exception ex)
            {
                //throw;
            }
            if (descTextBox.Text == "")
            {
                MessageBox.Show("Please enter a description to this part before adding");
            }
            else if (partNumTextBox.Text == "")
            {
                MessageBox.Show("Please enter a part number to this part before adding");
            }
            else
            {
                bool exists = parts.CheckIfPartNumberCreated(partNumTextBox.Text);
                if (!exists)
                {
                    Part newPart = new Part()
                    {
                        Description  = descTextBox.Text,
                        PartNumber   = partNumTextBox.Text,
                        Link         = linkTextBox.Text,
                        Supplier     = supplierTextBox.Text,
                        Price        = priceTextBox.Text,
                        CatergoeryId = i
                    };

                    _db.Parts.Add(newPart);
                    _db.SaveChanges();
                    MainWindow.frame.Content = new PartsHomePage();
                    MessageBox.Show($"Part Number {newPart.PartNumber} was added to the database");
                }

                else
                {
                    MessageBox.Show("There is already a part created with this part number.\nCheck parts list to update this part\nor change part number");
                }
                //Load();
            }
        }