Пример #1
0
        private void restoreBackupToolStripMenuItem_Click(object sender, EventArgs e)
        {
            var dialog = new OpenFileDialog
            {
                InitialDirectory = BackupsFolderPath,
                Filter           = "Zip File (*.zip) | *.zip"
            };

            var result = dialog.ShowDialog();

            if (result == DialogResult.OK)
            {
                var    tempFolder = $"{Path.GetTempPath()}\\excelRestoreFolder";
                string tempFile   = $"{tempFolder}\\{DB_NAME}";

                Directory.CreateDirectory(tempFolder);
                ZipFile.ExtractToDirectory(dialog.FileName, tempFolder);

                File.Copy(tempFile, DbPath, true);
                File.Delete(tempFile);
                Directory.Delete(tempFolder);

                excelGrid.DataSource = ExcelHandler.GetDataTable(DbPath);
                createBackupToolStripMenuItem.Enabled = true;
                MessageBox.Show("Restore Successful");
            }
        }
Пример #2
0
        /// <summary>
        /// Loads Db to Datagrid If it exists and
        /// Enables Excel Menu Item
        /// </summary>
        private void InitDb()
        {
            importExcelToolStripMenuItem.Enabled   = true;
            restoreBackupToolStripMenuItem.Enabled = true;

            if (DbExists)
            {
                excelGrid.DataSource = ExcelHandler.GetDataTable(DbPath);
                createBackupToolStripMenuItem.Enabled = true;
            }
            else
            {
                excelGrid.DataSource = new DataTable();
                createBackupToolStripMenuItem.Enabled = false;
            }
        }
Пример #3
0
        private void OpenImportExcelDialog()
        {
            var dialog = new OpenFileDialog
            {
                InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop),
                Filter           = "Excel (*.xlsx) | *.xlsx"
            };
            var result = dialog.ShowDialog();

            if (result == DialogResult.OK)
            {
                File.Copy(dialog.FileName, DbPath, true);
                excelGrid.DataSource = ExcelHandler.GetDataTable(DbPath);
                createBackupToolStripMenuItem.Enabled = true;
            }
        }