private void btnsqlbck_Click(object sender, EventArgs e)
        {
            SQLServerDiagnostics rd = new SQLServerDiagnostics();

            rd.Show();
            this.Close();
        }
        private void lblsqld_Click(object sender, EventArgs e)
        {
            SQLServerDiagnostics sqld = new SQLServerDiagnostics();

            sqld.Show();
            this.Close();
        }
Esempio n. 3
0
        public void Execute(bool isNormalExecution = true)
        {
            try
            {
                bool          blniiserr  = false;
                var           _rootpath  = Path.Combine(System.IO.Path.GetDirectoryName(Application.ExecutablePath), "Resources");
                string        script     = Path.Combine(_rootpath, scriptName + ".ps1");
                string        scriptText = File.ReadAllText(script);
                StringBuilder sb         = new StringBuilder();
                var           powershell = new PowerShellHelper();
                var           runspace   = powershell.CreateRunSpace(Application.ExecutablePath, scriptName);
                runspace.Open();
                Pipeline pipeline  = runspace.CreatePipeline();
                Command  myCommand = new Command(scriptText, true);

                foreach (var item in FormElements.IISInformation)
                {
                    if (chklstApp.CheckedIndices.Contains(item.id))
                    {
                        var param5 = new CommandParameter(null, 1);
                        myCommand.Parameters.Add(param5);
                    }
                    else
                    {
                        var param5 = new CommandParameter(null, 0);
                        myCommand.Parameters.Add(param5);
                    }
                }

                pipeline.Commands.Add(myCommand);
                Collection <PSObject> results = pipeline.Invoke();
                var errors = pipeline.Error;

                // CSV or Error file Generation code
                var generateCSV = new Csvhelper();
                generateCSV.WriteOutput(Application.ExecutablePath, scriptName, results, pipeline, this.timeStamp, out blniiserr);
                // CSV or Error file Generation code
                //Profilecreation();


                if (blniiserr)
                {
                    // MessageBox.Show("Error Occured.for more detail kindly check iis Log!!\r\n", "Error Message");
                    // return;
                }
                else
                {
                    if (isNormalExecution)
                    {
                        var profileHelper = new ProfileHelper();
                        profileHelper.SetProfileData <IISInformationModel>(Application.ExecutablePath, scriptName, FormElements, chklstApp);
                    }
                }
                runspace.Close();
                //DialogResult dialogResult = MessageBox.Show("IIS scripts executed successfully.Do you want to execute next script?", "Success", MessageBoxButtons.YesNo);
                //if (dialogResult == DialogResult.Yes)
                //{
                //    //do something
                //    SQLServerDiagnostics objfrm = new SQLServerDiagnostics();
                //    objfrm.Show();
                //    this.Close();
                //}
                //else if (dialogResult == DialogResult.No)
                //{
                //    IISInformation objfrm = new IISInformation();
                //    objfrm.Show();
                //    this.Close();
                //}

                if (isNormalExecution)
                {
                    IISInformationlogs frmiislogs = new IISInformationlogs();
                    DialogResult       dr         = frmiislogs.ShowDialog(this);
                    if (dr == DialogResult.Cancel)
                    {
                    }
                    else if (dr == DialogResult.OK)
                    {
                        this.Enabled = true;
                        SQLServerDiagnostics objfrm = new SQLServerDiagnostics();
                        objfrm.Show();
                        this.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Occured.for more detail kindly check IIS Log!!\r\n" + "\r\n" + ex.Message.ToString(), "Error Message");
            }
        }