public Write ( string KeyName, object Value ) : bool | ||
KeyName | string | |
Value | object | |
Результат | bool |
/// <summary>Implements the Exec method of the IDTCommandTarget interface. This is called when the command is invoked.</summary> /// <param term='commandName'>The name of the command to execute.</param> /// <param term='executeOption'>Describes how the command should be run.</param> /// <param term='varIn'>Parameters passed from the caller to the command handler.</param> /// <param term='varOut'>Parameters passed from the command handler to the caller.</param> /// <param term='handled'>Informs the caller if the command was handled or not.</param> /// <seealso class='Exec' /> public void Exec(string commandName, vsCommandExecOption executeOption, ref object varIn, ref object varOut, ref bool handled) { handled = false; if (executeOption == vsCommandExecOption.vsCommandExecOptionDoDefault) { if (commandName == "SSMSAddin.Connect.SSMSAddin") { Document document = ((DTE2)ServiceCache.ExtensibilityModel).ActiveDocument; if (document != null) { //replace currently selected text TextSelection selection = (TextSelection)document.Selection; //selection.Insert(@"xxxxxx", (Int32)EnvDTE.vsInsertFlags.vsInsertFlagsContainNewText); //VisualisationPane myControl = new VisualisationPane(); //Windows2 myWindow = (Windows2) _applicationObject.Windows; //var window = myWindow.CreateToolWindow2(_addInInstance, // System.Reflection.Assembly.GetExecutingAssembly().Location, "SSMSAddin.VisualisationPane", // "xxxx", "{5B7F8C1C-65B9-2aca-1Ac3-12AcBbAF21d5}", myControl); //window.Visible = true; try { RegistryAccess ra = new RegistryAccess("SQLDep", false); // "3c81b7e5-109f-49c0-bfc7-a67c3cb67b62" string userAccountId = ra.Read("userAccountId"); bool execute = false; bool save = false; AskUserForm askUser = new AskUserForm(userAccountId); // Show testDialog as a modal dialog and determine if DialogResult = OK. if (askUser.ShowDialog(null) == DialogResult.OK) { // Read the contents of testDialog's TextBox. execute = true; userAccountId = askUser.UserId; save = askUser.StoreAble; } else { } askUser.Dispose(); if (save) { ra.Write("userAccountId", userAccountId); } if (execute) { string result = ""; string json = "{ \"userAccountId\":\"" + userAccountId + "\", \"dialect\":\"mssql\", \"queries\": [ { \"sourceCode\": \"" + selection.Text + "\" } ] }"; using (var client = new WebClient()) { client.Headers[HttpRequestHeader.ContentType] = "application/json"; result = client.UploadString("https://sqldep.com/api/rest/sqlset/create/", "POST", json); // REMOVE // MessageBox.Show(result); } // PARSE RESULTS HERE AND DISPLAY ON PANEL XmlDocument doc = JsonConvert.DeserializeXmlNode(result, "Root"); string retUrl = doc["Root"]["urlToVisualisation"].InnerText; // otevre IE (chrome) System.Diagnostics.Process.Start(retUrl); // okenko - take moznost //myControl.webBrowser1.Navigate(retUrl); } } catch (Exception e) { MessageBox.Show(e.Message); } } handled = true; return; } } }
/// <summary>Implements the Exec method of the IDTCommandTarget interface. This is called when the command is invoked.</summary> /// <param term='commandName'>The name of the command to execute.</param> /// <param term='executeOption'>Describes how the command should be run.</param> /// <param term='varIn'>Parameters passed from the caller to the command handler.</param> /// <param term='varOut'>Parameters passed from the command handler to the caller.</param> /// <param term='handled'>Informs the caller if the command was handled or not.</param> /// <seealso class='Exec' /> public void Exec(string commandName, vsCommandExecOption executeOption, ref object varIn, ref object varOut, ref bool handled) { handled = false; if (executeOption == vsCommandExecOption.vsCommandExecOptionDoDefault) { if (commandName == "SSMSAddin.Connect.SSMSAddin") { Document document = ((DTE2)ServiceCache.ExtensibilityModel).ActiveDocument; if (document != null) { //replace currently selected text TextSelection selection = (TextSelection)document.Selection; //selection.Insert(@"xxxxxx", (Int32)EnvDTE.vsInsertFlags.vsInsertFlagsContainNewText); //VisualisationPane myControl = new VisualisationPane(); //Windows2 myWindow = (Windows2) _applicationObject.Windows; //var window = myWindow.CreateToolWindow2(_addInInstance, // System.Reflection.Assembly.GetExecutingAssembly().Location, "SSMSAddin.VisualisationPane", // "xxxx", "{5B7F8C1C-65B9-2aca-1Ac3-12AcBbAF21d5}", myControl); //window.Visible = true; try { RegistryAccess ra = new RegistryAccess("SQLDep", false); // "3c81b7e5-109f-49c0-bfc7-a67c3cb67b62" string userAccountId = ra.Read("userAccountId"); bool execute = false; bool save = false; AskUserForm askUser = new AskUserForm(userAccountId); // Show testDialog as a modal dialog and determine if DialogResult = OK. if (askUser.ShowDialog(null) == DialogResult.OK) { // Read the contents of testDialog's TextBox. execute = true; userAccountId = askUser.UserId; save = askUser.StoreAble; } else { } askUser.Dispose(); if (save) { ra.Write("userAccountId", userAccountId); } if (execute) { string result = ""; string json = "{ \"userAccountId\":\"" + userAccountId + "\", \"dialect\":\"mssql\", \"queries\": [ { \"sourceCode\": \"" + selection.Text + "\" } ] }"; using (var client = new WebClient()) { client.Headers[HttpRequestHeader.ContentType] = "application/json"; result = client.UploadString("https://sqldep.com/api/rest/sqlset/create/", "POST", json); // REMOVE // MessageBox.Show(result); } // PARSE RESULTS HERE AND DISPLAY ON PANEL XmlDocument doc = JsonConvert.DeserializeXmlNode(result, "Root"); string retUrl = doc["Root"]["urlToVisualisation"].InnerText; // otevre IE (chrome) System.Diagnostics.Process.Start(retUrl); // okenko - take moznost //myControl.webBrowser1.Navigate(retUrl); } } catch (Exception e) { MessageBox.Show(e.Message); } } handled = true; return; } } }