private void btnPreviewSchema_Click(object sender, RoutedEventArgs e) { try { var details = new Details(); details.File = new CodeFile() { Type = CodeFileType.SqlScript, Name = acNameBox.Text + "_Schema.Sql", Content = db.GetViewSchemaInfo(acNameBox.Text) }; details.Show(); } catch (Exception ex) { var wnd = Window.GetWindow(this) as MetroWindow; wnd.ShowMessageAsync("Error", ex.Message); } }
void t_Click(object sender, RoutedEventArgs e) { var name = ((Tile)(sender)).CommandParameter; var type = ((Tile)(sender)).Count; var details = new Details(); details.File = CodeFiles.Find(c => c.Name.Equals(name) && c.Type.ToString().Equals(type)); details.Show(); }
void t_Click(object sender, RoutedEventArgs e) { try { var name = ((Tile)(sender)).CommandParameter; if (name.Equals("xlsx")) { Process.Start(new ProcessStartInfo(_RouteDOMEngine.GetXLSXDocumentPath(acNameBox.SelectedValue as string))); } else if (name.Equals("sql")) { var details = new Details(); details.File = new CodeFile() { Type = CodeFileType.SqlScript, Name = acNameBox.Text + "_Routes.Sql", Content = _RouteDOMEngine.GetSqlScript(acNameBox.SelectedValue as string) }; details.Show(); } else { var details = new Details(); details.File = new CodeFile() { Type = CodeFileType.MochaTest, Name = acNameBox.SelectedValue as string + ".js", Content = _RouteDOMEngine.GetMochaScript(acNameBox.SelectedValue as string) }; details.Show(); } } catch (Exception ex) { var wnd = Window.GetWindow(this) as MetroWindow; wnd.ShowMessageAsync("Error", ex.Message, MessageDialogStyle.Affirmative); } }
void t_Click(object sender, RoutedEventArgs e) { var name = ((Tile)(sender)).CommandParameter; var details = new Details(); details.File = files.Find(c => c.Name.Equals(name)); details.Show(); }
private void btnPreviewSchema_Click(object sender, RoutedEventArgs e) { var dTable = SQLExecutor.ExecuteDataTable("SELECT m.definition FROM sys.views v INNER JOIN sys.sql_modules m ON m.object_id = v.object_id WHERE name = '" + acNameBox.Text + "'"); if (dTable.Rows.Count > 0) { var temp = dTable.Rows[0][0].ToString(); var details = new Details(); details.File = new CodeFile() { Type = CodeFileType.SqlScript, Name = acNameBox.Text + "_Schema.Sql", Content = temp }; details.Show(); } }