private void SaveButton_Click(object sender, RoutedEventArgs e) { using (var db = new OnlineShopEntities1()) { db.Items.Attach(tmp); db.Entry(tmp).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); this.DialogResult = true; } }
private void NewButton_Click(object sender, RoutedEventArgs e) { new NewDialogWindow().ShowDialog(); using (var db = new OnlineShopEntities1()) { _items = db.Items.ToList(); _itemcharacteristics = db.ItemCharacteristics.ToList(); gridItems.ItemsSource = _items; gridItemCharacteristics.ItemsSource = _itemcharacteristics; } }
public NewDialogWindow() { InitializeComponent(); using (var db = new OnlineShopEntities1()) { _items = db.Items.ToList(); _categories = db.Categories.ToList(); _characteristics = db.Characteristics.ToList(); _itemcharacteristics = db.ItemCharacteristics.ToList(); } }
private void EditButton_Click(object sender, RoutedEventArgs e) { if (gridItems.SelectedIndex != -1) { new EditDialogWindow(gridItems.SelectedIndex).ShowDialog(); using (var db = new OnlineShopEntities1()) { _items = db.Items.ToList(); _itemcharacteristics = db.ItemCharacteristics.ToList(); gridItems.ItemsSource = _items; gridItemCharacteristics.ItemsSource = _itemcharacteristics; } } }
public MainWindow() { InitializeComponent(); using (var db = new OnlineShopEntities1()) { _items = db.Items.ToList(); _categories = db.Categories.ToList(); _characteristics = db.Characteristics.ToList(); _itemcharacteristics = db.ItemCharacteristics.ToList(); } gridItems.ItemsSource = _items; gridCategories.ItemsSource = _categories; gridCharacteristics.ItemsSource = _characteristics; gridItemCharacteristics.ItemsSource = _itemcharacteristics; FilterCategory.ItemsSource = _categories; }
private void DeleteButton_Click(object sender, RoutedEventArgs e) { if (gridItems.SelectedIndex != -1) { using (var db = new OnlineShopEntities1()) { var tmp = gridItems.SelectedItem as OnlineShop.Item; db.Items.Attach(tmp); db.Entry(tmp).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); _items = db.Items.ToList(); _itemcharacteristics = db.ItemCharacteristics.ToList(); gridItems.ItemsSource = _items; gridItemCharacteristics.ItemsSource = _itemcharacteristics; } } }
private void AddCharacteristicButton_Click(object sender, RoutedEventArgs e) { if (characteristicsText.Text.Length > 0) { tmp1 = new ItemCharacteristic { itemId = tmp.itemId, characteristicId = Int32.Parse(characteristicsText.Text) }; using (var db = new OnlineShopEntities1()) { db.ItemCharacteristics.Attach(tmp1); db.Entry(tmp1).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } else { MessageBox.Show("Fill all form"); } }
private void AddButton_Click(object sender, RoutedEventArgs e) { if (titleText.Text.Length > 0 && categoryText.Text.Length > 0 && creatorText.Text.Length > 0) { using (var db = new OnlineShopEntities1()) { tmp = new OnlineShop.Item { itemTitle = titleText.Text, categoryId = Int32.Parse(categoryText.Text), creator = creatorText.Text, info = infoText.Text }; tmp.itemId = _items[id1].itemId; gridItems.ItemsSource = new List <OnlineShop.Item> { tmp }; } } else { MessageBox.Show("Fill all form"); } }
public EditDialogWindow(int id) { InitializeComponent(); using (var db = new OnlineShopEntities1()) { _items = db.Items.ToList(); _categories = db.Categories.ToList(); _characteristics = db.Characteristics.ToList(); _itemcharacteristics = db.ItemCharacteristics.ToList(); } id1 = id; tmp = _items[id]; gridItems.ItemsSource = new List <OnlineShop.Item> { _items[id] }; titleText.Text = _items[id].itemTitle; creatorText.Text = _items[id].creator; infoText.Text = _items[id].info; categoryText.Text = _items[id].categoryId.ToString(); }