private void btnOk_Click(object sender, EventArgs e)
{
if (rbtDetail.Checked)
{
if (lsvDetailReferences.SelectedItems.Count == 0)
{
StdDialog.ShowError("s_please_select_foreign_key");
return;
}
IForeignKey fk = (IForeignKey)lsvDetailReferences.SelectedItems[0].Tag;
m_result = CreateDetailReference(fk, m_dialect);
m_resultFk = fk;
}
if (rbtMaster.Checked)
{
if (lsvMasterReferences.SelectedItems.Count == 0)
{
StdDialog.ShowError("s_please_select_foreign_key");
return;
}
IForeignKey fk = (IForeignKey)lsvMasterReferences.SelectedItems[0].Tag;
m_resultFk = fk;
m_result = CreateMasterReference(fk, m_dialect);
}
DialogResult = DialogResult.OK;
Close();
}
public static bool CheckAbsoluteOutputFileName(string fn, string extensions)
{
try
{
if (!Path.IsPathRooted(fn))
{
StdDialog.ShowError("s_please_enter_full_path_to_file");
return(false);
}
string dir = Path.GetDirectoryName(fn);
if (!Directory.Exists(dir))
{
StdDialog.ShowError("s_output_directory_does_not_exist");
return(false);
}
if (!IOTool.FileHasOneOfExtension(fn, extensions))
{
StdDialog.ShowError(Texts.Get("s_incorrect_file$extension", "extension", extensions.ToLower()));
return(false);
}
}
catch (Exception err)
{
StdDialog.ShowError(err.Message);
return(false);
}
if (File.Exists(fn) && !StdDialog.ReallyOverwriteFile(fn))
{
return(false);
}
return(true);
}
public void DragDrop_CopyDatabase(AppObject draggingObject)
{
var conn = this.FindServerConnection();
if (draggingObject is DatabaseAppObject)
{
try
{
IDatabaseSource dsource = ((DatabaseAppObject)draggingObject).FindDatabaseConnection();
var dbprops = new DatabaseProperties();
dbprops.Name = dsource.DatabaseName;
DatabasePropertiesForm.Run(dbprops, new GenericDatabaseSource(conn, conn.Connection, null), false);
//string newname = InputBox.Run(Texts.Get("s_name_of_new_database"), dsource.DatabaseName);
//if (newname == null) return;
if (ArrayTool.Contains(conn.Databases, dbprops.Name))
{
StdDialog.ShowError(Texts.Get("s_database_allready_exists"));
return;
}
IDatabaseSource newdb = conn.CreateDatabase(dbprops.Name, dbprops.SpecificData);
CopyDbWizard.Run(dsource.CloneSource(), newdb.CloneSource());
//CopyDbProcess.StartProcess(dsource.CloneSource(), newdb.CloneSource(), null);
}
catch (Exception e)
{
Errors.Report(e);
}
}
}
private void wpTarget_CloseFromNext(object sender, Gui.Wizard.PageEventArgs e)
{
if (addonSelectFrame1.SelectedObject is IDatabaseWriter)
{
m_target = (IDatabaseWriter)addonSelectFrame1.SelectedObject;
}
else if (addonSelectFrame1.SelectedObject is DatabaseWriterChooser)
{
m_target = m_writerChooser.GetDatabaseWriter();
}
if (m_target != null)
{
try
{
m_target.CheckConfiguration(m_source);
}
catch (Exception err)
{
Errors.Report(err);
e.Page = wpTarget;
return;
}
}
else
{
StdDialog.ShowError("s_please_select_database");
e.Page = wpTarget;
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (rbtCreateNewJob.Checked)
{
if (tbxJob.Text.IsEmpty())
{
StdDialog.ShowError("s_please_specify_job_name");
return;
}
}
if (rbtAppendToExistingJob.Checked)
{
if (lbxJobs.SelectedIndex < 0)
{
StdDialog.ShowError("s_please_choose_job");
return;
}
}
Usage["jobname"] = tbxJob.Text;
Usage["addtofavorite"] = chbAddToFavorites.Checked ? "1" : "0";
Usage["result"] = "ok";
DialogResult = DialogResult.OK;
Close();
}
protected override void OnDataError(bool displayErrorDialogIfNoHandler, DataGridViewDataErrorEventArgs e)
{
base.OnDataError(false, e);
Logging.Warning("Data error, row={0}, col={1}, error={2}", e.RowIndex, e.ColumnIndex, e.Exception.Message);
if (m_showDataErrors > 0)
{
StdDialog.ShowError(e.Exception.Message);
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (lbxJobs.SelectedIndex < 0)
{
StdDialog.ShowError("s_please_choose_job");
return;
}
DialogResult = DialogResult.OK;
Close();
}
private void btnOk_Click(object sender, EventArgs e)
{
GlobalSettings.Pages.BeginEdit();
GlobalSettings.Pages.General().AskWhenUploadUsageStats = false;
GlobalSettings.Pages.General().AllowUploadUsageStats = chbAllowUploadStats.Checked;
GlobalSettings.Pages.EndEdit();
if (rbtPersonal.Checked)
{
InstallationInfo.Instance.InstallMode = InstallationMode.Personal;
}
if (rbtProfessional.Checked)
{
InstallationInfo.Instance.InstallMode = InstallationMode.Professional;
}
InstallationInfo.Instance.LastShown = DateTime.UtcNow;
InstallationInfo.Instance.Save();
if (grpEval.Enabled && (chbDataSynEval.Checked || chbProEval.Checked || chbVersionDbEval.Checked))
{
var evdata = GetEvalCodeForm.Run();
if (evdata == null)
{
DialogResult = DialogResult.None;
return;
}
int cnt = 0;
using (var wc = new WaitContext())
{
if (chbDataSynEval.Checked && GetEvalCode.GetLicense(evdata.Name, evdata.Email, "datasyn"))
{
cnt++;
}
if (chbProEval.Checked && GetEvalCode.GetLicense(evdata.Name, evdata.Email, "pro"))
{
cnt++;
}
if (chbVersionDbEval.Checked && GetEvalCode.GetLicense(evdata.Name, evdata.Email, "versiondb"))
{
cnt++;
}
}
if (cnt > 0)
{
LicenseTool.ReloadLicenses();
HLicense.CallChangedLicenses();
StdDialog.ShowInfo("s_license_succesfuly_installed");
}
else
{
StdDialog.ShowError("s_error_when_install_license");
}
}
Close();
}
static void win_SelectedOk(object sender, CheckSelectedOkEventArgs e)
{
var win = sender as TreeSelectForm;
var node = win.daTreeView1.Selected as IDatabaseTreeNode;
if (node == null || node.DatabaseConnection == null)
{
StdDialog.ShowError("s_please_select_database");
return;
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (listView1.FocusedItem != null)
{
m_result = (JobCommandWithConnection)listView1.FocusedItem.Tag;
Close();
}
else
{
StdDialog.ShowError("s_please_select_command");
}
}
public override void Remove()
{
try
{
File.Delete(DiskPath);
}
catch (Exception err)
{
StdDialog.ShowError("s_path_cannot_be_deleted_delete_scheduled");
DeletedFileRegistrer.AddPath(DiskPath, true);
throw new DeleteError(DiskPath, err);
}
}
private void wpcolmap_CloseFromNext(object sender, Gui.Wizard.PageEventArgs e)
{
try
{
var tran = columnMapFrame1.GetTransform();
}
catch (Exception err)
{
StdDialog.ShowError(err.Message);
m_wpcolmapError = true;
e.Page = wpcolmap;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (lbxItems.SelectedItems.Count == 0)
{
StdDialog.ShowError("s_you_must_select_item_to_create");
lbxItems.Focus();
return;
}
if (rbtNameInTree.Checked && tbxNewName.Text == "")
{
StdDialog.ShowError("s_you_must_enter_name");
tbxNewName.Focus();
return;
}
if (rbtFileOnDisk.Checked && tbxFileName.Text == "")
{
StdDialog.ShowError("s_input_file_name");
tbxFileName.Focus();
return;
}
ICreateFactoryItem item = (ICreateFactoryItem)lbxItems.SelectedItems[0].Tag;
if (rbtFileOnDisk.Checked)
{
if (!StdDialog.CheckAbsoluteOutputFileName(tbxFileName.Text, item.FileExtensions))
{
return;
}
}
try { Directory.CreateDirectory(m_parent.FileSystemPath); }
catch (Exception) { }
if (rbtNameInTree.Checked)
{
if (item.Create(m_parent, tbxNewName.Text))
{
Close();
}
}
if (rbtFileOnDisk.Checked)
{
if (!item.CreateFile(tbxFileName.Text))
{
return;
}
using (StreamWriter sw = new StreamWriter(Path.Combine(m_parent.FileSystemPath, Path.GetFileNameWithoutExtension(tbxFileName.Text) + ".lnk")))
{
sw.Write(tbxFileName.Text);
}
Close();
}
}
private void PushedValue(int row, int col, object value)
{
if (m_data != null)
{
try
{
m_data.Rows[row][col] = value;
}
catch (Exception err)
{
StdDialog.ShowError(err.Message);
}
}
InvalidateRow(row);
}
public static void ShowErrorWindow(Exception e)
{
e = ExtractImportantException(e);
if (e is BadSettingsError)
{
BadSettingsErrorForm.Run((BadSettingsError)e);
}
else if (e is ExpectedError)
{
StdDialog.ShowError(e.Message);
}
else
{
ErrorForm.Run(e, Logging.GetFeedbackLastLogEntries());
}
}
public void MenuCreateDatabase()
{
var dbprops = new DatabaseProperties();
dbprops.Name = "newdb";
if (DatabasePropertiesForm.Run(dbprops, new GenericDatabaseSource(m_conn, m_conn.Connection, null), false))
{
if (ArrayTool.Contains(m_conn.Databases, dbprops.Name))
{
StdDialog.ShowError(Texts.Get("s_database_allready_exists"));
return;
}
InvokeScript(fmt => { fmt.CreateDatabase(dbprops.Name, dbprops.SpecificData); });
TreeNodeExtension.CompleteRefresh(this);
}
}
private void pgdbconn_CloseFromNext(object sender, Gui.Wizard.PageEventArgs e)
{
try
{
var conn = (TunnelConnection)GetConnection().CreateSystemConnection();
using (var wc = new WaitContext())
{
conn.PingDb();
}
}
catch (Exception err)
{
StdDialog.ShowError(err.Message);
e.Page = pgdbconn;
}
}
public void DragDrop_CopyTable(AppObject appobj)
{
//var tobj = appobj as TableAppObject;
//if (tobj == null) return;
var conn = this.FindDatabaseConnection();
ITableSource tsource = appobj.TableSource;
TableStructure tbl = new TableStructure(tsource.InvokeLoadStructure(TableStructureMembers.AllNoRefs));
TableCopyOptions opts;
bool copydata;
string newname = CopyTableForm.Run(tsource, conn, out copydata, out opts);
if (newname == null)
{
return;
}
List <NameWithSchema> names = new List <NameWithSchema>(conn.InvokeLoadFullTableNames());
if (ArrayTool.Contains(names, new NameWithSchema(newname)))
{
StdDialog.ShowError(Texts.Get("s_table_allready_exists"));
return;
}
tbl.FullName = new NameWithSchema(newname);
if (conn.Dialect != null)
{
conn.Dialect.MigrateTable(tbl, conn.Dialect.CreateMigrationProfile(), null);
}
tbl.RemoveConstraints <IForeignKey>();
PrimaryKey pk = (PrimaryKey)TableStructureExtension.FindConstraint <IPrimaryKey>(tbl);
if (pk != null && pk.Name != null && pk.Name.ToUpper().StartsWith("PK_"))
{
pk.Name = "PK_" + tbl.Name;
}
try
{
ITableSource dst = conn.CreateTable(tbl);
if (copydata)
{
BulkCopyJob.Create(tsource.GetDataStoreAndClone(), dst.GetDataStoreAndClone(), new IdentityTransform(tbl), opts, null).StartProcess();
}
}
catch (Exception e)
{
Errors.Report(e);
}
}
private void btnInstallLicense_Click(object sender, EventArgs e)
{
if (openFileDialogLicense.ShowDialogEx() == DialogResult.OK)
{
var lic = LicenseTool.LoadLicense(openFileDialogLicense.FileName);
if (lic != null)
{
LicenseTool.InstallLicense(openFileDialogLicense.FileName);
StdDialog.ShowInfo("s_license_installed_please_restart");
ReloadLicenses();
}
else
{
StdDialog.ShowError("s_license_file_is_not_valid");
}
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (tbxName.Text.IsEmpty())
{
StdDialog.ShowError("s_please_fill_name");
tbxName.Focus();
return;
}
if (!IncorrectEmailError.IsValid(tbxEmail.Text))
{
StdDialog.ShowError(Texts.Get("s_incorrect$email", "email", tbxEmail.Text));
tbxEmail.Focus();
return;
}
DialogResult = DialogResult.OK;
Close();
}
private void btnOk_Click(object sender, EventArgs e)
{
var sel = cbxType.SelectedItem as AddonHolder;
if (sel == null)
{
StdDialog.ShowError("s_please_choose_type");
return;
}
if (tbxNewName.Text.IsEmpty())
{
StdDialog.ShowError("s_please_fill_name");
return;
}
DialogResult = DialogResult.OK;
m_addon = sel.CreateInstance();
Close();
}
//public static bool Run(CopyDbJobCommand command)
//{
// CopyDbWizard wizard = new CopyDbWizard(command);
// return wizard.ShowDialogEx() == DialogResult.OK;
//}
private void wpSource_CloseFromNext(object sender, Gui.Wizard.PageEventArgs e)
{
IDatabaseTreeNode node = treSource.Selected as IDatabaseTreeNode;
if (node == null)
{
StdDialog.ShowError("s_please_select_database");
e.Page = wpSource;
return;
}
m_source = node.DatabaseConnection.CloneSource();
if (m_source.Connection != null)
{
m_source.Connection.Owner = this;
}
m_chooseNode = null;
m_structure = null;
m_dataPageInitialized = false;
}
private void wptarget_CloseFromNext(object sender, Gui.Wizard.PageEventArgs e)
{
if (target.DataStore != null)
{
try
{
target.DataStore.CheckConfiguration();
}
catch (Exception err)
{
Errors.Report(err);
e.Page = wptarget;
}
}
else
{
StdDialog.ShowError("s_please_select_valid_target");
e.Page = wptarget;
}
}
public override void Remove()
{
if (IOTool.FileIsLink(DiskPath))
{
File.Delete(DiskPath);
}
else
{
try
{
Directory.Delete(DiskPath, true);
}
catch (Exception err)
{
StdDialog.ShowError("s_path_cannot_be_deleted_delete_scheduled");
DeletedFileRegistrer.AddPath(DiskPath, true);
throw new DeleteError(DiskPath, err);
}
}
}
private void wpsource_CloseFromNext(object sender, Gui.Wizard.PageEventArgs e)
{
if (source.DataStore != null)
{
try
{
source.DataStore.CheckConfiguration();
}
catch (Exception err)
{
Errors.Report(err);
e.Page = wpsource;
}
}
else
{
StdDialog.ShowError("s_please_select_valid_source");
e.Page = wpsource;
}
m_sourceCacheCleared = false;
}
public override void CreateNew(AppObject appobj, ConnectionPack connpack)
{
var dbprops = new DatabaseProperties();
dbprops.Name = "newdb";
var server = appobj.FindServerConnection(connpack);
if (server == null || server.Connection == null)
{
return;
}
if (DatabasePropertiesForm.Run(dbprops, new GenericDatabaseSource(server, server.Connection, null), false))
{
if (ArrayTool.Contains(server.Databases, dbprops.Name))
{
StdDialog.ShowError(Texts.Get("s_database_allready_exists"));
return;
}
server.Connection.InvokeScript(fmt => { fmt.CreateDatabase(dbprops.Name, dbprops.SpecificData); }, null);
appobj.CallCompleteChanged();
}
}
private void edfactory_DropDown(object sender, EventArgs e)
{
if (!m_typesLoaded)
{
try
{
edfactory.Items.Clear();
Assembly a = Assembly.LoadFile(Path.Combine(Core.ProgramDirectory, edfile.Text));
foreach (Type t in a.GetTypes())
{
if (t.IsSubclassOf(typeof(DbProviderFactory)))
{
edfactory.Items.Add(t.FullName);
}
}
m_typesLoaded = true;
}
catch (Exception err)
{
StdDialog.ShowError(Texts.Get("s_error_loading_assembly$error", "error", err));
}
}
}
public static void Run(IDatabaseSource dst)
{
var loaders = new List <IDatabaseLoader>();
if (dst.DatabaseCaps.ExecuteSql && dst.Dialect != null)
{
var sl = dst.Dialect.CreateSpecificDatabaseLoader();
if (sl != null)
{
loaders.Add(sl);
}
}
foreach (var item in DatabaseLoaderAddonType.Instance.CommonSpace.GetFilteredAddons(RegisterItemUsage.DirectUse))
{
var loader = (IDatabaseLoader)item.CreateInstance();
if (!loader.IsSqlDumpLoader)
{
continue;
}
if (!loader.SuitableFor(dst))
{
continue;
}
loaders.Add(loader);
}
if (loaders.Count == 0)
{
StdDialog.ShowError("s_no_dump_loader_available");
return;
}
ImportSqlDumpForm win = new ImportSqlDumpForm(dst, loaders);
win.ShowDialogEx();
}
protected override void OnLinkClick(LinkClickEventArgs e)
{
base.OnLinkClick(e);
string url = e.Href;
if (url.StartsWith("'") && url.EndsWith("'"))
{
url = url.Substring(1, url.Length - 2);
}
if (url.StartsWith("\"") && url.EndsWith("\""))
{
url = url.Substring(1, url.Length - 2);
}
if (url.StartsWith("http://") || url.StartsWith("mailto:"))
{
try { System.Diagnostics.Process.Start(url); }
catch
{
StdDialog.ShowError(Texts.Get("s_cannot_open$url", "url", url));
}
e.Handled = true;
}
if (url.StartsWith("callback://"))
{
e.Handled = true;
try
{
string mtdname = url.Substring("callback://".Length);
Dictionary <string, string> pars = null;
if (mtdname.Contains("?"))
{
pars = new Dictionary <string, string>();
string[] pair = mtdname.Split('?');
mtdname = pair[0];
foreach (string parstr in pair[1].Split('&'))
{
string[] p2 = parstr.Split(':');
if (p2.Length != 2)
{
continue;
}
pars[p2[0]] = HttpUtility.UrlDecode(p2[1]);
}
}
if (mtdname.EndsWith("/"))
{
mtdname = mtdname.Substring(0, mtdname.Length - 1);
}
object mtd = Procedures[mtdname];
if (mtd is Action)
{
((Action)mtd)();
}
else if (mtd is Action <Dictionary <string, string> > )
{
((Action <Dictionary <string, string> >)mtd)(pars);
}
else
{
// using reflection we call method, which name is after callback://
Type tp = mtd.GetType();
MethodInfo call = tp.GetMethod("Call", new Type[] { (new object[] { }).GetType() });
if (call != null)
{
call.Invoke(mtd, new object[] { new object[] { } });
}
call = tp.GetMethod("Call", new Type[] { (new object[] { typeof(Dictionary <string, string>) }).GetType() });
if (call != null)
{
call.Invoke(mtd, new object[] { new object[] { pars } });
}
}
}
catch (Exception err)
{
Errors.Report(err);
}
}
}
