private void OnNewDatabaseRequested(ObservableTreeItem item)
{
try
{
if (item != null && SelectedItem.Type == ItemTypeModel.Folder)
{
AddDatabaseDialog dialog = new AddDatabaseDialog();
if (dialog.ShowDialog() ?? false)
{
string databasePath = dialog.DatabaseName.EndsWith(".db") ? Path.Combine(SelectedItem.Path, dialog.DatabaseName) : Path.Combine(SelectedItem.Path, String.Concat(dialog.DatabaseName, ".db"));
_sqliteService.BuildDatabase(databasePath);
item.Items.Add(new ObservableTreeItem
{
Name = dialog.DatabaseName,
Path = databasePath,
Type = ItemTypeModel.Database
});
ItemsCollectionChanged(this, new ItemsCollectionChangedEventArgs(Items.SelectMany(i => i.Items)));
}
}
else
{
WpfMessageBox.ShowDialog("Invalid Item Selected", "Please select a folder to add a database to.", MessageBoxButton.OK, MessageIcon.Error);
}
}
catch (Exception ex)
{
WpfMessageBox.ShowDialog("Error Building Database", ex.Message, MessageBoxButton.OK, MessageIcon.Error);
}
}
private void CloseWindow(object parameter = null)
{
var checkWin = new WpfMessageBox("アプリを終了します", MessageBoxButton.YesNo);
checkWin.ShowDialog();
if (checkWin.Result == MessageBoxResult.Yes)
{
App.Current.Shutdown(0);
}
}
private void ReOauth(object parameter = null)
{
var checkWin = new WpfMessageBox("現在のアカウント情報を削除し、新しいアカウントを認証します", MessageBoxButton.YesNo);
checkWin.ShowDialog();
if (checkWin.Result == MessageBoxResult.Yes)
{
TokenIO.ResetSetting();
GetToken();
}
}
private void OnCancel()
{
try
{
Done();
}
catch (Exception ex)
{
WpfMessageBox.ShowDialog("Data Error", ex.Message, MessageBoxButton.OK, MessageIcon.Error);
}
}
private void OnEditVendor(Vendor vendor)
{
try
{
EditVendor(vendor);
}
catch (Exception ex)
{
WpfMessageBox.ShowDialog("Data Error", ex.Message, MessageBoxButton.OK, MessageIcon.Error);
}
}
private void OnSaveAs(Document document)
{
SaveFileDialog dialog = new SaveFileDialog();
if (dialog.ShowDialog() ?? false)
{
document.FilePath = dialog.Path.EndsWith(".sqe") ? dialog.Path : string.Concat(dialog.Path, ".sqe");
if (!File.Exists(document.FilePath) || (WpfMessageBox.ShowDialog("File Exists", "Overwrite existing file?", MessageBoxButton.YesNo, MessageIcon.Warning) ?? false))
{
File.WriteAllText($"{document.FilePath}", document.Text);
document.IsSaved = true;
}
}
}
private void OnSave()
{
try
{
UpdateVendor(Vendor, _editingVendor);
if (EditMode)
{
ModifyVendor(_editingVendor);
}
else
{
AddVendor(_editingVendor);
}
Done();
}
catch (Exception ex)
{
WpfMessageBox.ShowDialog("Data Error", ex.Message, MessageBoxButton.OK, MessageIcon.Error);
}
}
private void UpdateViewModels()
{
try
{
_monthlyCostsViewModel.SetTransactions(_transactionRepository.GetTransactionsByMonth(DateTime.Today));
_yearlyCostsViewModel.SetTransactions(_transactionRepository.GetTransactionsByYear(DateTime.Today.Year));
_yearlyCostsViewModel.SetBreakdown(_transactionRepository.GetYearCostBreakdowns().Where(b => b.TimePeriod.Year == DateTime.Today.Year).FirstOrDefault());
_allCostsViewModel.SetTransactions(_transactionRepository.GetTransactions());
_allCostsViewModel.SetBreakdown(_transactionRepository.GetLifetimeCostBreakdown());
_transactionsViewModel.SetTransactions(_transactionRepository.GetTransactions());
_vendorsViewModel.SetVendors(_vendorRepository.GetVendors());
MonthCostData = new ObservableCollection <CostBreakdown>(_transactionRepository.GetMonthCostBreakdowns());
IEnumerable <CostBreakdown> costData = _transactionRepository.GetMonthCostBreakdowns();
}
catch (Exception ex)
{
Logger.LogException(ex);
WpfMessageBox.ShowDialog("Data Error", ex.Message, MessageBoxButton.OK, MessageIcon.Error);
}
}
private void OnNavToMonthView(CostBreakdown breakdown)
{
try
{
if (breakdown != null)
{
IEnumerable <Transaction> viewTransactions = _transactionRepository.GetTransactionsByMonth(breakdown.TimePeriod);
_monthlyCostsViewModel.SetTransactions(viewTransactions);
_monthlyCostsViewModel.SetBreakdown(breakdown);
CurrentViewModel = _monthlyCostsViewModel;
}
else
{
WpfMessageBox.ShowDialog("Warning", "No transaction data available for the current month.", MessageBoxButton.OK, MessageIcon.Information);
}
}
catch (Exception ex)
{
WpfMessageBox.ShowDialog("Error", ex.Message, MessageBoxButton.OK, MessageIcon.Error);
}
}
private void OnNewTableRequested(ObservableTreeItem item)
{
if (item != null && SelectedItem.Type == ItemTypeModel.Database)
{
CreateTableDialog dialog = new CreateTableDialog(SelectedItem.Path, _sqliteService);
if (dialog.ShowDialog() ?? false)
{
ObservableTreeItem newItem = new ObservableTreeItem
{
Name = dialog.TableName,
Path = dialog.DatabasePath,
Type = ItemTypeModel.Table
};
newItem.Items = new ObservableCollection <ObservableTreeItem>(_sqliteService.GetItems(newItem.Translate()).Select(i => i.Translate()));
item.Items.Add(newItem);
}
}
else
{
WpfMessageBox.ShowDialog("Invalid Operation", "Please select a database for this operation.", MessageBoxButton.OK, MessageIcon.Error);
}
}
private void OnExecute(Document document)
{
ResultSets.Clear();
try
{
IEnumerable <DataTable> results;
if (string.IsNullOrEmpty(ActiveDocumentSelectedText))
{
results = _sqliteService.ExecuteQuery(_activeDocument.Text, _activeDocument.DatabasePath);
}
else
{
results = _sqliteService.ExecuteQuery(ActiveDocumentSelectedText, _activeDocument.DatabasePath);
}
foreach (DataTable table in results)
{
ResultSets.Add(table);
}
}
catch (Exception ex)
{
WpfMessageBox.ShowDialog("Execution Error", ex.Message, MessageBoxButton.OK, MessageIcon.Error);
}
}