private void FormBackupDatabase_Load(object sender, EventArgs e)
{
Inventori.Module.ModuleControlSettings.SaveLog(ListOfAction.Open, string.Empty, ListOfTable.Database, lbl_UserName.Text);
oScript.ConnectDatabaseWithRefresh(pServer, pDatabase, pUserName, pPassword);
if (lbl_Auto.Text == true.ToString())
{
this.Size = new Size(this.Size.Width, 145);
this.Text = "Otomatisasi Backup Database";
panel1.Visible = false;
pb_Loading.Location = new Point(pb_Loading.Location.X, 7);
lbl_Loading.Location = new Point(lbl_Loading.Location.X, 30);
this.Refresh();
System.Threading.Thread.Sleep(5000);
btn_Backup_Click(null, null);
this.Close();
}
}
private void btn_BackupFile_Click(object sender, EventArgs e)
{
openFileDialog1.FileName = "";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
txt_BackupFile.Text = openFileDialog1.FileName;
}
if (!string.IsNullOrEmpty(txt_BackupFile.Text.Trim()))
{
clsZip.UnzipIT(txt_BackupFile.Text, txt_BackupDir.Text);
oScript.ConnectDatabaseWithRefresh(pServer, pDatabase, pUserName, pPassword);
DataSet DS = new DataSet();
DS.ReadXml(txt_BackupDir.Text + "SQLScripts.xml");
if (DS.Tables.Count > 0)
{
DataTable dt = DS.Tables[0];
dt.DefaultView.RowFilter = "ObjectType='table'";
Get_Objects(ref dt, ref grid_Tables, "TableName");
}
}
}
