private void AddButton_Click(object sender, RoutedEventArgs e)
        {
            Potrawy recipe = new Potrawy();

            recipe.NazwaPotrawy  = NameTextBox.Text;
            recipe.Skladniki     = IngTextBox.Text;
            recipe.Przygotowanie = PrepTextBox.Text;

            try
            {
                using (var dbCtx = new KitchenEntities1())
                {
                    dbCtx.Entry(recipe).State = EntityState.Added;
                    dbCtx.SaveChanges();

                    Skladniki ingridient = new Skladniki();
                    string[]  ingr       = System.Text.RegularExpressions.Regex.Split(recipe.Skladniki, "\r\n");

                    ingridient.IdPotrawy = recipe.IdPotrawy;
                    foreach (string i in ingr)
                    {
                        ingridient.Skladnik           = i;
                        dbCtx.Entry(ingridient).State = EntityState.Added;
                        dbCtx.SaveChanges();
                    }
                }
                this.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("Added failed");
            }
        }
        public EditWindow(Potrawy p, KitchenEntities1 dataEntities)
        {
            InitializeComponent();
            this.p           = p;
            NameTextBox.Text = p.NazwaPotrawy;
            IngTextBox.Text  = p.Skladniki;
            PrepTextBox.Text = p.Przygotowanie;
            IdLabel.Content  = "" + p.IdPotrawy;

            this.dataEntities = dataEntities;
        }
        private void DeleteButton_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                Potrawy recipeRow = new Potrawy();
                //int dataGridSelection = DataGrid.SelectedIndex + 1;
                //recipeRow.IdPotrawy = dataGridSelection;
                using (var dataEntities = new KitchenEntities1())
                {
                    var              original = dataEntities.Potrawy.Find(GetSelectedId());
                    string           msgtext  = "Do you really want to delete that row?";
                    string           txt      = "Deleting row";
                    MessageBoxButton button   = MessageBoxButton.YesNoCancel;
                    MessageBoxResult result   = MessageBox.Show(msgtext, txt, button);
                    switch (result)
                    {
                    case MessageBoxResult.Yes:
                        original.NazwaPotrawy  = "NULL";
                        original.Skladniki     = "NULL";
                        original.Przygotowanie = "NULL";

                        dataEntities.Entry(original).State = EntityState.Modified;
                        dataEntities.SaveChanges();

                        dataEntities.Database.ExecuteSqlCommand("DELETE FROM Skladniki WHERE IdPotrawy=" + original.IdPotrawy);

                        Window_Loaded(sender, e);
                        break;

                    case MessageBoxResult.No:
                        break;

                    case MessageBoxResult.Cancel:
                        break;
                    }
                }
            }
            catch (Exception Ex)
            {
                MessageBox.Show(Ex.Message);
                return;
            }
        }
 private void EditButton_Click(object sender, RoutedEventArgs e)
 {
     try
     {
         Potrawy recipeRow = new Potrawy();
         using (var dataEntities = new KitchenEntities1())
         {
             var original  = dataEntities.Potrawy.Find(GetSelectedId());
             var newWindow = new EditWindow(original, dataEntities);
             newWindow.ShowDialog();
         }
         Window_Loaded(sender, e);
     }
     catch (Exception Ex)
     {
         MessageBox.Show(Ex.Message);
         return;
     }
 }