private void Button_Click(object sender, RoutedEventArgs e) { RoboContext db = new RoboContext(); db.Database.EnsureDeleted(); db.Database.EnsureCreated(); MessageBox.Show("Ok"); }
private void Button_Click_1(object sender, RoutedEventArgs e) { RoboContext db = new RoboContext(); db.Add(new Solution { Header = "ELECTRONICS", Type = 1, Pid = 0, Lft = 1, Rgt = 20 }); db.Add(new Solution { Header = "TELEVISIONS", Type = 1, Pid = 1, Lft = 2, Rgt = 9 }); db.Add(new Solution { Header = "TUBE", Type = 2, Pid = 2, Lft = 3, Rgt = 4 }); db.Add(new Solution { Header = "LCD", Type = 2, Pid = 2, Lft = 5, Rgt = 6 }); db.Add(new Solution { Header = "PLASMA", Type = 3, Pid = 2, Lft = 7, Rgt = 8 }); db.Add(new Solution { Header = "PORTABLE ELECTRONICS", Type = 1, Pid = 1, Lft = 10, Rgt = 19 }); db.Add(new Solution { Header = "MP3 PLAYERS", Type = 1, Pid = 6, Lft = 11, Rgt = 14 }); db.Add(new Solution { Header = "FLASH", Type = 3, Pid = 7, Lft = 12, Rgt = 13 }); db.Add(new Solution { Header = "CD PLAYERS", Type = 2, Pid = 6, Lft = 15, Rgt = 16 }); db.Add(new Solution { Header = "2 WAY RADIOS", Type = 2, Pid = 6, Lft = 17, Rgt = 18 }); db.Add(new Solution { Header = "KOMPUTERS", Type = 1, Pid = 0, Lft = 21, Rgt = 28 }); db.Add(new Solution { Header = "PORTABLE", Type = 2, Pid = 11, Lft = 22, Rgt = 23 }); db.Add(new Solution { Header = "DESKTOP", Type = 3, Pid = 11, Lft = 24, Rgt = 25 }); db.Add(new Solution { Header = "SERVERS", Type = 2, Pid = 11, Lft = 26, Rgt = 27 }); db.Add(new Solution { Header = "CARS", Type = 1, Pid = 0, Lft = 29, Rgt = 30 }); db.SaveChanges(); MessageBox.Show("Ok"); }
private void GetChildren(TreeViewItem parentItem) { int id = 0; if (parentItem != null) { Solution s = (Solution)parentItem.Tag; id = s.Id; } List <Solution> solutionList = new List <Solution>(); using (var db = new RoboContext()) { solutionList = db.Solutions.Where(s => s.Pid == id).ToList(); } foreach (Solution row in solutionList) { TreeViewItem newItem = new TreeViewItem() { Header = row.Header, Tag = row }; if (parentItem == null) { CTreeWiew.Items.Add(newItem); } else { parentItem.Items.Add(newItem) } Solution k = (Solution)newItem.Tag; if ((k.Rgt - k.lft) > 1) { GetChildren(newItem); } } }