/// <summary>
/// åbner sql filer i nye text felter
/// </summary>
public void OpenSQLFile()
{
OpenFileDialog file = new OpenFileDialog
{
Multiselect = false,
Filter = "SQL(SQL(*.sql)|*.sql"
};
if (file.ShowDialog() == true)
{
if (file.FileName.Contains(".sql"))
{
FileInfo sqlfil = new FileInfo(file.FileName);
string scriptet = sqlfil.OpenText().ReadToEnd();
TableAddons.writeLogFile($"{file.FileName} sql script has been opened in the ScriptNote", dataservice.LogLocation);
ScriptContentString = scriptet;
sqlfil.OpenText().Close();
}
else
{
MessageBox.Show($"{ConfigurationManager.AppSettings["script_only_sql_files_msg"]}",
$"{ConfigurationManager.AppSettings["New_script_note_open_script_header"]}",
MessageBoxButton.OK,
MessageBoxImage.Warning);
}
}
}
/// <summary>
/// Til at modtage nye forbindelser via. Enkelte valgte forbindelse i sidepanelet.
/// Tilføjer forbindelsen i forbindelses listen hvis den er gyldig
/// Åbner forbindelsen
/// </summary>
/// <param name="message"></param>
public void OnConnection(ConnectionMessages message)
{
try
{
switch (message.Type)
{
case DBAdapterType.Mysql:
var MysqlCon = new MySqlConnection(message.ConnectionString);
MysqlCon.Open();
dataService.ConnectionList.Add(message.Databasename, new MySqlDataConnection(MysqlCon));
dataService.ConnectionListNames.Add(message.Databasename);
Items.Add(dataService.mysqlTree.BuildTree(MysqlCon));
message.Execute(true);
TableAddons.writeLogFile($"{message.Databasename} type of MySql, has been added to" +
$" the connection list", dataService.LogLocation);
//-- Sender en besked 'true' til SidepanelViewModel så du kan tilføje tabeller
Messenger.Default.Send <bool, SidePanelViewModel>(true);
ItemsFilter = Items;
break;
case DBAdapterType.Oracle:
var OracleCon = new OdbcConnection(message.ConnectionString);
OracleCon.Open();
dataService.ConnectionList.Add(message.Databasename, new OracleDataConnection(OracleCon));
dataService.ConnectionListNames.Add(message.Databasename);
Items.Add(dataService.oracleTree.BuildTree(OracleCon));
message.Execute(true);
TableAddons.writeLogFile($"{message.Databasename} type of Oracle, has been added to" +
$" the connection list", dataService.LogLocation);
//-- Sender en besked 'true' til SidepanelViewModel så du kan tilføje tabeller
Messenger.Default.Send <bool, SidePanelViewModel>(true);
ItemsFilter = Items;
break;
case DBAdapterType.Mssql:
var MssCon = new SqlConnection(message.ConnectionString);
MssCon.Open();
dataService.ConnectionList.Add(message.Databasename, new MssqlDataConnection(MssCon));
dataService.ConnectionListNames.Add(message.Databasename);
Items.Add(dataService.mssqlTree.BuildTree(MssCon));
message.Execute(true);
TableAddons.writeLogFile($"{message.Databasename} type of MsSql, has been added to" +
$" the connection list", dataService.LogLocation);
//-- Sender en besked 'true' til SidepanelViewModel så du kan tilføje tabeller
Messenger.Default.Send <bool, SidePanelViewModel>(true);
ItemsFilter = Items;
break;
default:
message.Execute(false);
break;
}
}
catch
{
message.Execute(false);
}
}
/// <summary>
/// Køre scripts
/// </summary>
public void ExecuteScript()
{
//-- Modtager database string fra NewQueryTabItem --- PULL
MessengerInstance.Send <NotificationMessageAction <string> >(
new NotificationMessageAction <string>
("", ActiveConnection => CurrentDBName = ActiveConnection)
);
if (!string.IsNullOrWhiteSpace(CurrentDBName) && CurrentDBName.ToLower() != "none")
{
dataservice.ConnectionList.FirstOrDefault(x => x.Key == CurrentDBName).Value.UnknownReadCreateToDatabaes(ScriptContentString);
TableAddons.writeLogFile($"{ScriptContentString} executed from the ScriptNote", dataservice.LogLocation);
}
else
{
MessageBox.Show($"{ConfigurationManager.AppSettings["New_script_note_verify_connection_msg"]}",
$"{ConfigurationManager.AppSettings["New_script_note_execute_header"]}",
MessageBoxButton.OK,
MessageBoxImage.Warning);
}
}
/// <summary>
/// fortæller hurtigt om der er forskel på tabel a og b
/// </summary>
public void QuickCheckTableContent()
{
if (righttDataTable != null && leftDataTable != null)
{
if (!righttDataTable.Rows.Count.Equals(0) && !leftDataTable.Rows.Count.Equals(0))
{
if (TableAddons.TellTableDifferences(righttDataTable, leftDataTable) == true)
{
MessageBox.Show("There is no differences betweeen the two tables.",
"DataMergeEditor - Quick compare message",
MessageBoxButton.OK,
MessageBoxImage.Information);
}
else
{
MessageBox.Show("There is differences between the two tables.",
"DataMergeEditor - Quick compare message",
MessageBoxButton.OK,
MessageBoxImage.Information);
}
}
else
{
MessageBox.Show("Table A or B need to contain rows in order to compare.",
"DataMergeEditor - Quick compare message",
MessageBoxButton.OK,
MessageBoxImage.Information);
}
}
else
{
MessageBox.Show("Table A or B cannot be null",
"DataMergeEditor - Quick compare message",
MessageBoxButton.OK,
MessageBoxImage.Information);
}
}
/// <summary>
/// Viser kun rækker hvor data ikke stemmer overens i begge tabeller
/// </summary>
public void ShowTableDifferencesByMissMatch()
{
//-- sætter de nye tabeller
DummyTableRight = TableAddons.ReturnFilteredTableByMissMatch(righttDataTable, leftDataTable);
DummyTableLeft = TableAddons.ReturnFilteredTableByMissMatch(leftDataTable, righttDataTable);
}
