private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
if (m_ignoreTabChange)
{
return;
}
try
{
if (tabControl1.SelectedIndex == 1)
{
if (rbtDatabase.Checked)
{
if (cbxDatabase.SelectedIndex < 0)
{
throw new Exception("Please select database");
}
if (cbxBackup.SelectedIndex < 0)
{
throw new Exception("Please select backup");
}
LoadBackupSet(((BackupSetHodler)(cbxBackup.Items[cbxBackup.SelectedIndex])).bid);
}
if (rbtFile.Checked)
{
LoadBackupSet(tbxFile.Text);
}
}
}
catch (Exception ex)
{
StdDialog.ShowError("Error loading metadata from backup: " + ex.Message);
tabControl1.SelectedIndex = 0;
}
}
private void wpprovider_CloseFromNext(object sender, Gui.Wizard.PageEventArgs e)
{
try
{
if (cbxProvider.SelectedIndex >= 0)
{
m_factoryName = cbxProvider.SelectedItem.ToString();
m_driverName = null;
}
if (cbxDriver.SelectedIndex >= 0)
{
m_driverName = ((DbDriverDefinition)cbxDriver.SelectedItem).InvariantName;
m_factoryName = null;
}
if (m_factoryName != null)
{
m_factory = DbProviderFactories.GetFactory(m_factoryName);
}
if (m_driverName != null)
{
m_factory = DbDriverManager.Instance.CreateFactory(m_driverName);
}
}
catch (Exception err)
{
StdDialog.ShowError(String.Format(
"{0}:\n{1}", Texts.Get("s_cannot_create_provider"), err.Message));
e.Page = wpprovider;
return;
}
}
private void CheckServiceRunning()
{
if (!ServiceControl.IsRunning())
{
StdDialog.ShowError("s_warning_service_not_running");
}
}
private void codeEditorQuery_Leave(object sender, EventArgs e)
{
try
{
SaveSource(false);
}
catch (Exception err)
{
CurCache.TargetChanged = false;
CurCache.SourceModel = null;
StdDialog.ShowError(Errors.ExtractImportantException(err).Message);
}
if (CurCache.SourceModel != null)
{
var cols = new HashSetEx <string>();
foreach (var col in CurCache.SourceModel.Columns)
{
if (cols.Contains(col.ColumnName))
{
CurCache.TargetChanged = false;
CurCache.SourceModel = null;
StdDialog.ShowError(Texts.Get("s_datasynerr_duplicate$column", "column", col.ColumnName));
break;
}
cols.Add(col.ColumnName);
}
}
}
private void btnCopyCommandShellToClipboard_Click(object sender, EventArgs e)
{
if (lsvCommands.SelectedItems.Count == 0)
{
StdDialog.ShowError("s_no_commands_selected");
return;
}
SaveToShellClipboard(SaveCommandsShell);
}
private void mnuCopyJobSchellToClipboard_Click(object sender, EventArgs e)
{
if (lsvJobs.SelectedItems.Count == 0)
{
StdDialog.ShowError("s_no_jobs_selected");
return;
}
SaveToShellClipboard(SaveJobShell);
}
private void sreportToolStripMenuItem_Click(object sender, EventArgs e)
{
if (m_jobconn == null)
{
StdDialog.ShowInfo("s_please_save_job_first");
return;
}
JobReportForm.Run(m_jobconn.FileName, m_cmd);
}
private bool CheckDbName()
{
if (String.IsNullOrEmpty(tbxDatabase.Text))
{
StdDialog.ShowError("Please fill database name first");
return(false);
}
return(true);
}
private void btmSavePhpTunnel_Click(object sender, EventArgs e)
{
if (saveFileDialog1.ShowDialogEx() == DialogResult.OK)
{
SaveConnection();
using (FileStream fw = new FileStream(saveFileDialog1.FileName, FileMode.Create))
{
byte[] buffer = Params.GetPhpTunnelFile();
fw.Write(buffer, 0, buffer.Length);
StdDialog.ShowInfo("s_ok");
}
}
}
private void btnAddToFavorites_Click(object sender, EventArgs e)
{
if (m_jobconn == null)
{
StdDialog.ShowInfo("s_please_save_job_first");
return;
}
AddToFavoriteForm.Run(
new DataSynFavorite {
File = m_jobconn.FileName, Command = m_cmd.GroupId
},
Path.GetFileNameWithoutExtension(m_jobconn.FileName)
);
}
private void toolStripButton1_Click_2(object sender, EventArgs e)
{
string name = InputBox.Run(Texts.Get("s_select_template_name"), "tpl1");
if (name != null)
{
string fn = Path.Combine(DiagramStyleAddonType.Instance.CommonSpace.Folder, name + ".adx");
if (File.Exists(fn))
{
if (!StdDialog.ReallyOverwriteFile(fn))
{
return;
}
}
//m_diagram.Style.WriteXml
XmlTool.SerializeObject(fn, m_diagram.Style);
DiagramStyleAddonType.Instance.CommonSpace.ClearCache();
}
}
private void btnSynchronize_Click(object sender, EventArgs e)
{
if (m_dstDb == null || m_diff == null)
{
return;
}
if (objectListTables.CheckedItems.Count == 0)
{
StdDialog.ShowInfo("s_no_synchronize_action_checked");
return;
}
try
{
bool ok = false;
if (m_dstDb.DatabaseCaps.ExecuteSql)
{
// synchronize using SQL dumping
ok = RunActionAsSql(m_diff.Actions);
}
else
{
// synchronize using data-sources alter/create/drop methods
if (MessageBox.Show(Texts.Get("s_really_change_destination_structure"), VersionInfo.ProgramTitle, MessageBoxButtons.YesNo) == DialogResult.Yes)
{
var plan = m_diff.Actions.GetPlanForThis(m_dstDb, true);
var opts = CreateDbDiffOptions();
m_dstDb.AlterDatabase(plan, opts);
ok = true;
}
}
if (ok)
{
RefreshData(false, true);
Usage.AddSub("synchronize_ok", m_src.ToString(), m_dst.ToString());
}
}
catch (Exception err)
{
Errors.Report(err);
}
}
private bool DbSuitable(IDatabaseSource db)
{
if (db == null)
{
return(false);
}
if (!db.DatabaseCaps.ExecuteSql)
{
StdDialog.ShowError("DAE-00368 " + Texts.Get("s_only_sql_databasources_can_be_sync"));
return(false);
}
Errors.CheckNotNull("DAE-00366", db.Dialect);
if (db.Dialect.CreateDataSynAdapter() == null)
{
StdDialog.ShowError("DAE-00367 " + Texts.Get("s_dialect_doesnt_support_sync$dialect", "dialect", db.Dialect.DisplayName));
return(false);
}
return(true);
}
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
if (tabControl1.SelectedIndex == 1)
{
if (Database == null)
{
StdDialog.ShowError("s_please_select_database");
tabControl1.SelectedIndex = 0;
return;
}
foreach (Control ctrl in tabControl1.TabPages[1].Controls)
{
ctrl.Dispose();
}
var page = appDesigner1.Page.CreateControl(Database, m_env);
tabControl1.TabPages[1].Controls.Add(page);
//page.Width = tabControl1.TabPages[1].Width;
//page.Height = tabControl1.TabPages[1].Height;
page.Dock = DockStyle.Fill;
}
}
private void btnNewJob_Click(object sender, EventArgs e)
{
string name = InputBox.Run("s_select_job_name", "newjob");
if (name == null)
{
return;
}
string fn = Path.Combine(Core.JobsDirectory, name + ".djb");
if (File.Exists(fn))
{
if (!StdDialog.ReallyOverwriteFile(fn))
{
return;
}
}
Job job = new Job();
job.SaveToFile(fn);
RefreshJobs();
}
private void rbtNone_CheckedChanged(object sender, EventArgs e)
{
if (m_loading == 0)
{
if (rbtNone.Checked && m_item != null)
{
if (StdDialog.YesNoDialog("s_really_remove_datasyn_item"))
{
if (RemovedItem != null)
{
RemovedItem(this, EventArgs.Empty);
}
}
}
if (!rbtNone.Checked && m_item == null)
{
if (CreatedItem != null)
{
var args = new CreateDataSynItemEventArgs();
if (rbtTable.Checked)
{
args.Source = new DataSynTableSource();
}
if (rbtView.Checked)
{
args.Source = new DataSynViewSource();
}
if (rbtQuery.Checked)
{
args.Source = new DataSynQuerySource();
}
CreatedItem(this, args);
}
}
}
UpdateSourceVisibility();
}
