Exemple #1
0
        private void bbtRestoreDatabase_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            Cursor.Current = Cursors.WaitCursor;

            try
            {
                if (File.Exists(@"D:\SQLBackup\QuanLySieuThi.bak"))
                {
                    if (MessageBox.Show("Are you sure you restore?", "Back", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        if (BackupDatabaseService.RestoreDatabase())
                        {
                            MessageBox.Show("Restore thành công");
                        }
                        else
                        {
                            MessageBox.Show("Restore thất bại");
                        }
                    }
                }
            }
            catch (Exception exp)
            {
                MessageBox.Show(exp.Message);
            }
        }
Exemple #2
0
        private void bbtBackupDatabase_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            bool bBackUpStatus = true;

            Cursor.Current = Cursors.WaitCursor;

            if (Directory.Exists(@"D:\SQLBackup"))
            {
                if (File.Exists(@"D:\SQLBackup\QuanLySieuThi.bak"))
                {
                    if (MessageBox.Show(@"Do you want to replace it?", "Back", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        File.Delete(@"D:\SQLBackup\QuanLySieuThi.bak");
                    }
                    else
                    {
                        bBackUpStatus = false;
                    }
                }
            }
            else
            {
                Directory.CreateDirectory(@"D:\SQLBackup");
            }

            if (bBackUpStatus)
            {
                if (BackupDatabaseService.BackupDatabase())
                {
                    MessageBox.Show("Backup thành công");
                }
                else
                {
                    MessageBox.Show("Backup thất bại");
                }
            }
        }