public static void fHelp(string wbs, string Layout)
{
try
{
cSettings cs = My.Application.Csettings; string Help_Path = cs.HelpPath;
string wbs_parent = wbs.Substring(0, wbs.LastIndexOf(".")) + ".x";
if (Strings.Trim(Layout + "") != "")
{
if (System.IO.File.Exists(Help_Path + wbs_parent + "_" + Layout + ".docx"))
{
Process.Start(Help_Path + wbs_parent + "_" + Layout + ".docx"); return;
}
if (System.IO.File.Exists(Help_Path + wbs + "_" + Layout + ".docx"))
{
Process.Start(Help_Path + wbs + "_" + Layout + ".docx"); return;
}
}
//start help without being layout specific
if (System.IO.File.Exists(Help_Path + wbs_parent + ".docx"))
{
Process.Start(Help_Path + wbs_parent + ".docx"); return;
}
if (System.IO.File.Exists(Help_Path + wbs + ".docx"))
{
Process.Start(Help_Path + wbs + ".docx"); return;
}
}
catch (Exception ex)
{
Interaction.MsgBox(ex.Message);
}
}
/// <summary>
/// Update the Settings form with the values taken from the output file Settings.xml.
/// </summary>
public void updateFormFromSettings()
{
mainSettings.updateFrom(MainWindow.settings.MainS);
toolsSettings.updateFrom(MainWindow.settings.ToolsS);
pdfSettings.updateFrom(MainWindow.settings.PdfS);
toolbarSettings.updateFrom(MainWindow.settings.ToolbarS);
backupSettings = (cSettings)MainWindow.settings.Clone();
}
private void LoadSettings()
{
mySettings = new cSettings(Application.StartupPath + "\\config.xml");
foreach (DataRow row in mySettings.GetServers().Rows)
{
lbServers.Items.Add(row[0].ToString());
cmbFromServer.Items.Add(row[0].ToString());
cmbToServer.Items.Add(row[0].ToString());
}
}
/// <summary>
/// Updates Settings.xml output file with the values taken from the Settings form.
/// </summary>
public void updateSettingsFromForm()
{
MainWindow.settings.MainS = mainSettings.getFromForm();
MainWindow.settings.ToolsS = toolsSettings.getFromForm();
MainWindow.settings.PdfS = pdfSettings.getFromForm();
MainWindow.settings.ToolbarS = toolbarSettings.getFromForm();
if (backupSettings.MainS.dotSize != MainWindow.settings.MainS.dotSize || backupSettings.MainS.leftColor != MainWindow.settings.MainS.leftColor || backupSettings.MainS.rightColor != MainWindow.settings.MainS.rightColor || backupSettings.MainS.showChart != MainWindow.settings.MainS.showChart || backupSettings.MainS.dotsToPaint != MainWindow.settings.MainS.dotsToPaint || backupSettings.MainS.channels != MainWindow.settings.MainS.channels || backupSettings.MainS.mono_stereo != MainWindow.settings.MainS.mono_stereo)
{
mw.reloadCochcleogram();
backupSettings = (cSettings)MainWindow.settings.Clone();
}
}
private void Form1_Load(object sender, EventArgs e)
{
//Open Application in full screen
this.WindowState = FormWindowState.Maximized;
//check & Create Directories for SW if not exists.
CreateDirectory(System.Environment.CurrentDirectory + @"\CSV Files");
CreateDirectory(System.Environment.CurrentDirectory + @"\Database");
//File Dropdown list with csv file exist in directory
FillBox();
configSettings = new cSettings();
}
static void Main(string[] args)
{
Console.Title = "SQL Server Database Copy Tool";
_settings = new cSettings(Application.StartupPath + "\\config.xml");
//check if we are in commandline with arguments
if (args.Length > 0)
{
if (args.Length == 4)
{
//do things
string sFromServer = args[0];
string sToServer = args[1];
string sFromDatabase = args[2];
string sToDatabase = args[3];
if (!PreCheckServer(sFromServer) || !PreCheckServer(sToServer))
{
Application.Exit();
}
else
{
cDatabaseCopy dbc = new cDatabaseCopy();
dbc.Progress += new ProgressEventHandler(OperationProgress);
dbc.StepChanged += new StepsEventHandler(StepChanged);
try
{
dbc.CopyDatabase(_settings.GetServerDefaultBackupdir(sFromServer),
sFromDatabase,
sToDatabase,
_settings.GetServerDefaultDatadir(sToServer),
_settings.GetServerDefaultBackupdir(sToServer),
_settings.GetServerDefaultLogdir(sToServer),
sFromServer,
sToServer,
_settings.GetServerUsername(sFromServer),
_settings.GetServerPassword(sFromServer),
_settings.GetServerIntegratedSecurity(sFromServer),
_settings.GetServerUsername(sToServer),
_settings.GetServerPassword(sToServer),
_settings.GetServerIntegratedSecurity(sToServer));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine("Exiting...");
Application.Exit();
}
}
}
else
{
Console.WriteLine("No chance...! Use DbCopyTool.exe YOUR_FROM_SERVER YOUR_TO_SERVER YOUR_FROM_DB YOUR_TO_DB");
Console.WriteLine("Exiting...");
}
}
else
{
//hide console
setConsoleWindowVisibility(false, Console.Title);
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
frmDBTools main = new frmDBTools();
Application.Run(main);
}
setConsoleWindowVisibility(true, Console.Title);
}
