async Task LoadCategoriesDropdown() { try { DropdownItems.Clear(); var CategoryListArr = new List <string>(); using (SQLiteConnection con = new SQLiteConnection(@"Data Source=|DataDirectory|\Database.db")) { con.Open(); SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Categories", con); SQLiteDataReader reader = cmd.ExecuteReader(); string[] vnvalues = { "Category" }; while (reader.Read()) { int i = 0; foreach (string value in vnvalues) { if (!reader.IsDBNull(reader.GetOrdinal(value))) { CategoryListArr.Add(reader[value].ToString()); } i++; } } con.Close(); } DropdownItems.AddRange(CategoryListArr); //return; // AddCategory.Clear(); List <MenuItem> menuitmList = new List <MenuItem>(); foreach (string categoryName in CategoryListArr)//this loop adds the text to the dropdown menu { if (categoryName.ToString() != "All") { MenuItem menuitm2 = new MenuItem(); menuitm2.Header = categoryName; menuitm2.Click += VisualNovelsListBox.ListInstance.AddToCategory; //menuitm2.Command = AddToCategoryCommand; //menuitm2.Click += VisualNovelsListbox.ListInstance.AddToCategory_Click; menuitmList.Add(menuitm2); } } AddCategory.AddMenuItemRange(menuitmList); RemoveCategory.Clear(); menuitmList.Clear(); foreach (string categoryName in CategoryListArr)//this loop adds the text to the dropdown menu { if (categoryName.ToString() != "All") { MenuItem menuitm2 = new MenuItem(); menuitm2.Header = categoryName; menuitm2.Click += VisualNovelsListBox.ListInstance.RemoveFromCategory; menuitmList.Add(menuitm2); } } RemoveCategory.AddMenuItemRange(menuitmList); } catch (Exception ex) { using (StreamWriter sw = File.AppendText(StaticClass.CurrentDirectory + @"\debug.log")) { sw.WriteLine(DateTime.Now); sw.WriteLine("Exception Found:\tType: {0}", ex.GetType().FullName); sw.WriteLine("Class File: VnListBoxViewModel.cs"); sw.WriteLine("Method Name: LoadCategoriesDropdown"); sw.WriteLine("\nMessage: {0}", ex.Message); sw.WriteLine("Source: {0}", ex.Source); sw.WriteLine("StackTrace: {0}", ex.StackTrace); sw.WriteLine("Target Site: {0}", ex.TargetSite); sw.WriteLine("\n\n"); } throw; } }
public void Clear() { SelectedItem = default(T); DropdownItems.Clear(); }