private void VisualizeCommand_Executed(object sender, ExecutedRoutedEventArgs e) { TableManager tm = new TableManager(); tm.CreateRawTable((int)e.Parameter); Window w = new VistrailOptions((int)e.Parameter); w.ShowDialog(); }
private void ExportCommand_Executed(object sender, ExecutedRoutedEventArgs e) { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "CSV File(*.csv)|*.*"; if (saveFileDialog.ShowDialog() != DialogResult.OK) return; TableManager tm = new TableManager(); tm.CreateRawTable((int)e.Parameter); string path = ConfigurationManager.AppSettings["CMDSQLPath"]; string savePath = saveFileDialog.FileName; if (!savePath.Contains(".csv")) savePath += ".csv"; //make sure we backup to a unique name FileInfo fInfo = new FileInfo(savePath); Process p = new Process(); p.StartInfo.FileName = "sqlcmd"; p.StartInfo.Arguments = "-S (local)\\SQL2008 -d DMU -E -Q \"SET NOCOUNT ON; SELECT * FROM tmpVizStorage\" -s\";\" -w 999 -W -o " + ConfigurationManager.AppSettings["TMPPath"] + "\\" + fInfo.Name; p.StartInfo.WorkingDirectory = path; p.StartInfo.UseShellExecute = true; p.Start(); p.WaitForExit(); if (File.Exists(ConfigurationManager.AppSettings["TMPPath"] + "\\" + fInfo.Name)) File.Move(ConfigurationManager.AppSettings["TMPPath"] + "\\" + fInfo.Name, savePath); else { Logger.Message("An error has occured."); return; } Logger.Message("The data has been exported."); }