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