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