private void AddNewItemToCategoryFromDatabase() { for (int i = 0; i < categoryManager.CategoryCount; i++) { categoryManager.AddListItemToCategoryFromDatabase(i, SaveDataHandler.ReadItemTable(categoryManager.Categories[i].IdDb)); } }
public MainWindow() { InitializeComponent(); //setting loading settingManager.ReadFromSetting(); //temp item start /* * form.Id = "13123"; * form.Name = "dsfafdsfasf"; * form.Description = "dfjslkvja jdsflajvs afs"; * * AddCategoryToList(); * * itemForm.Name = "fdsvdnn"; * itemForm.Description = "fdsvsv"; * itemForm.Id = "1231"; * AddNewItemToCategory(categoryManager.Categories[0]); * //temp item end * */ //setting data contexts gridNewCat.DataContext = form; gridNewItem.DataContext = itemForm; gridExistingCat.DataContext = categoryManager; cbNewItemCategory.DataContext = categoryManager; tabInventory.DataContext = categoryManager; cmbChangeItemCategory.DataContext = categoryManager; tbSaveFolderPath.DataContext = settingManager.SaveFileManager; dgRecentHistory.DataContext = historyManager; tbHistorySavePath.DataContext = settingManager.SaveFileManager; SaveDataHandler.InitializeConnection("data.sqlite", settingManager.SaveFileManager.FirstLaunch); if (settingManager.SaveFileManager.FirstLaunch) { settingManager.NoLongerFirstLaunch(); } //SaveDataHandler.InitializeConnection("data.sqlite"); //temp data //SaveDataHandler.InsertCategoryToTable(categoryManager.Categories[0]); //SaveDataHandler.CreateItemTable(categoryManager.Categories[0].Items[0]); try { AddCategoryToListDataBase(); AddNewItemToCategoryFromDatabase(); } catch (System.Data.SQLite.SQLiteException e) { Console.WriteLine("sql error save file error"); MessageBox.Show("Database error, try restarting the program."); settingManager.SaveFileManager.FirstLaunch = true; settingManager.WriteToSetting(); throw new System.Data.SQLite.SQLiteException(); } }
private void AddNewItemToCategory(CategoryViewModel _cat) { categoryManager.AddNewItemToCategory(_cat, itemForm.GetItem); SaveDataHandler.InsertItemToTable(itemForm.GetItem); HistoryAddNewItem(itemForm.GetItem); NewItemReset(); }
private void DgExistingCat_LostFocus(object sender, RoutedEventArgs e) { SaveDataHandler.OpenConnection(); for (int i = 0; i < categoryManager.CategoryCount; i++) { SaveDataHandler.UpdateCategoryInTableManualConnection(categoryManager.Categories[i]); } SaveDataHandler.CloseConnection(); }
private void AddCategoryToList() { categoryManager.AddCategoryToList(form.GetCategory); SaveDataHandler.InsertCategoryToTable(form.GetCategory); SaveDataHandler.CreateItemTable(form.GetCategory.IdDb); HistoryAddNewCategory(form.GetCategory); form.Reset(); }
private void DgItemList_LostFocus(object sender, RoutedEventArgs e) { SaveDataHandler.OpenConnection(); for (int i = 0; i < categoryManager.SelectedCategoryItems.Count; i++) { SaveDataHandler.UpdateItemInTableManualConnection(categoryManager.SelectedCategoryItems[i]); } SaveDataHandler.CloseConnection(); //Console.WriteLine("data grid lost focus"); //HistoryRecord(); }
private void BtnInventoryDelete_Click(object sender, RoutedEventArgs e) { if (dgItemList.SelectedIndex == -1) { return; } ItemViewModel temp = (ItemViewModel)dgItemList.SelectedItem; HistoryRemoveItem(temp); SaveDataHandler.RemoveItemInTable(temp); categoryManager.Categories[categoryManager.CurrentCategoryIndex].RemoveItem((ItemViewModel)dgItemList.SelectedItem); }
private void RewriteAllData() { SaveDataHandler.OpenConnection(); for (int i = 0; i < categoryManager.CategoryCount; i++) { SaveDataHandler.UpdateCategoryInTableManualConnection(categoryManager.Categories[i]); for (int x = 0; x < categoryManager.Categories[i].Items.Count; x++) { SaveDataHandler.UpdateItemInTableManualConnection(categoryManager.Categories[i].Items[x]); } } SaveDataHandler.CloseConnection(); }
private void BtnRemoveExistingCat_Click(object sender, RoutedEventArgs e) { if (dgExistingCat.SelectedItem == null) { return; } CategoryViewModel temp = (CategoryViewModel)dgExistingCat.SelectedItem; HistoryRemoveCategory(temp); foreach (ItemViewModel item in temp.Items) { HistoryRemoveItem(item); } SaveDataHandler.RemoveCategoryInTable(temp); categoryManager.RemoveCategoryFromList((CategoryViewModel)dgExistingCat.SelectedItem); }
private void AddCategoryToListDataBase() { categoryManager.AddCategoryToListFromDatabase(SaveDataHandler.ReadCategoryTable()); }