public void display_settings()
{
br = new classes.BackupRestore();
settings_table = br.select_settings_table();
if (settings_table.Rows.Count > 0)
{
foreach (DataRow row in settings_table.Rows)
{
string path = row["path"].ToString();
string day = row["day"].ToString();
DateTime time = Convert.ToDateTime(row["time"]);
txtPath.Text = path;
if (string.IsNullOrEmpty(day) || time == DateTime.MaxValue)
{
switchAutoBackup.Checked = false;
}
else
{
switchAutoBackup.Checked = true;
cbDay.SelectedIndex = cbDay.FindStringExact(day);
dtpTime.Value = time;
}
}
}
}
public void display_settings()
{
br = new classes.BackupRestore();
settings_table = br.select_settings_table();
if (settings_table.Rows.Count > 0)
{
foreach (DataRow row in settings_table.Rows)
{
DateTime d = Convert.ToDateTime(row["time"]);
string day = row["day"].ToString();
if (string.IsNullOrEmpty(day) || d == DateTime.MaxValue)
{
lblDateTime.Text = "You haven't set automatic back-up yet. Click database settings to set-up.";
lblDirectory.Text = @"Back up will be saved to C:\Desktop";
}
else
{
lblDirectory.Text = "Back up will be saved to " + row["path"].ToString();
directory = row["path"].ToString();
time = d;
timerAutoBackup.Start();
}
}
}
else
{
lblDateTime.Text = "You haven't set automatic back-up yet. Click database settings to set-up.";
}
}
public void display_db_logs()
{
br = new classes.BackupRestore();
db_logs_table = br.select_database_logs_table();
dgvDatabaseLogs.DataSource = db_logs_table;
dgvDatabaseLogs.AutoGenerateColumns = false;
}
private void backup_Complete(object sender, ServerMessageEventArgs e)
{
if (e.Error != null)
{
lblProgressText.Invoke((MethodInvoker) delegate
{
lblProgressText.Text = e.Error.Message;
});
}
MessageBox.Show("Database backup successful!", "Backup Database", MessageBoxButtons.OK, MessageBoxIcon.Information);
br = new classes.BackupRestore();
br.insert_logs(true, is_automatic);
if (File.Exists(directory))
{
Process.Start("explorer.exe", "/select, " + directory);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
hasError = false;
if (string.IsNullOrEmpty(txtPath.Text))
{
hasError = true;
MessageBox.Show("Please specify the path you want to save the backup.", "Database Settings", MessageBoxButtons.OK, MessageBoxIcon.Error);
btnBrowse.PerformClick();
return;
}
else
{
if (switchAutoBackup.Checked)
{
if (cbDay.SelectedIndex == 0 || cbDay.SelectedIndex == -1)
{
hasError = true;
MessageBox.Show("Please select the day you want to perform automatic backup.", "Database Settings", MessageBoxButtons.OK, MessageBoxIcon.Error);
cbDay.Focus();
return;
}
}
if (hasError == false)
{
string path = txtPath.Text;
string day = (switchAutoBackup.Checked) ? cbDay.Text : string.Empty;
DateTime time = (switchAutoBackup.Checked) ? dtpTime.Value : DateTime.MaxValue;
br = new classes.BackupRestore();
if (br.apply_settings(path, day, time))
{
MessageBox.Show("Settings has been saved!", "Database Settings", MessageBoxButtons.OK, MessageBoxIcon.Information);
display_settings();
}
else
{
return;
}
}
}
}