// GET: api/Users public IHttpActionResult GetUser(PublicModel publicModel) { SHDocVw.InternetExplorer ie = new SHDocVw.InternetExplorer(); ie.Navigate("https://login.taobao.com/member/login.jhtml?redirectURL=https%3A%2F%2Fai.taobao.com%2F%3Fpid%3Dmm_112599953_14918079_77950911"); ie.Visible = true; IHTMLDocument3 doc = (IHTMLDocument3)ie.Document; doc.getElementById("TPL_username_1").innerText = "肖梓璇35834616"; doc.getElementById("TPL_password_1").innerText = "xiao4563515"; doc.getElementById("J_SubmitStatic").click(); ie.Navigate("http://i.taobao.com/my_taobao.htm"); ie.Visible = true; ie.Navigate(" https://buyertrade.taobao.com/trade/itemlist/list_bought_items.htm?spm=a1z02.1.972272805.d4919663.73d2782d6TTeTm&action=itemlist/BoughtQueryAction&event_submit_do_query=1&tabCode=waitRate"); ie.Visible = true; doc.getElementById("rateOrder").click(); var ss = doc.documentElement.outerText = "1111"; var userList = db.User.ToList(); var data = Newtonsoft.Json.JsonConvert.SerializeObject(userList); return(Json(data)); }
private void OpenWebPage(string url) { //WebPlayer wp = new WebPlayer(); //wp.Show(); //wp.Play(url); SHDocVw.InternetExplorer ie = new SHDocVw.InternetExplorer(); ie.DocumentComplete += (object pDisp, ref object URL) => { ThreadPool.QueueUserWorkItem((o) => { try { mshtml.HTMLDocument doc = (mshtml.HTMLDocument)ie.Document; doc.bgColor = "black"; doc.getElementById("player").removeAttribute("style"); doc.getElementById("player").setAttribute("width", "100%"); doc.getElementById("player").setAttribute("height", "100%"); doc.getElementById("player").setAttribute("align", "center"); } catch { } }); }; ie.Visible = true; ie.TheaterMode = true; ie.Navigate(url); BringWindowToTop(new IntPtr(ie.HWND)); }
public static void Main(string[] args) { String res = ""; var ie = new SHDocVw.InternetExplorer(); //ネット接続 try { ie.Navigate("https://moneykit.net/visitor/sb_rate/"); Wait(ie); //DOM操作 var doc = ie.Document as mshtml.IHTMLDocument3; var tmpCol = doc.getElementsByTagName("tbody") as mshtml.IHTMLElementCollection; tmpCol = tmpCol.item(0).getElementsByTagName("td") as mshtml.IHTMLElementCollection; res = tmpCol.item(2).innerText; } catch (Exception) { res = "接続エラー"; } finally { ie.Quit(); FileOutput(res); } }
/// <summary> /// Obtiene el formulario para que pueda ser utilizado en toda la clase /// </summary> /// <param name="formUID"></param> public void obtenerFormulario(string formUID, string ruta) { try { //Obtiene el formulario de Visualizar XML visualiza = SAPbouiCOM.Framework.Application.SBO_Application.Forms.Item("frmVisualizar"); //Agrega el objeto Browser de tipo ActiveX en el formulario Item oItem = visualiza.Items.Add("Brwsr", SAPbouiCOM.BoFormItemTypes.it_ACTIVE_X); oItem.Height = visualiza.Height - 37; oItem.Width = visualiza.Width - 15; ActiveX axBrwsr = (ActiveX)oItem.Specific; //Se define la clase para el objeto ActiveX axBrwsr.ClassID = "Shell.Explorer.2"; //Se crea el visor de Internet Explorer oSHDocVw = ((SHDocVw.InternetExplorer)(axBrwsr.Object)); //Se carga el archivo xml al visor oSHDocVw.Navigate(ruta, Type.Missing, Type.Missing, Type.Missing, Type.Missing); //Se borra el archivo cargado File.Delete(ruta); } catch (Exception ex) { SAPbouiCOM.Framework.Application.SBO_Application.MessageBox("ObtenerFormulario/Error:" + ex.ToString()); } }
private void button2_Click(object sender, EventArgs e) { string Url = System.Configuration.ConfigurationManager.AppSettings["Url"]; SHDocVw.InternetExplorer ie = new SHDocVw.InternetExplorer(); ie.Navigate(Url); ie.Visible = true; OpenComm(); }
private void IE_Open(String searchEngine) { SHDocVw.InternetExplorer objIE = new SHDocVw.InternetExplorer(); //オブジェクトを作成 objIE.Navigate("about:blank"); //空ページの表示 objIE.Visible = true; //IEを表示 String encodedKeyword = System.Web.HttpUtility.UrlEncode(this.textBox1.Text, System.Text.Encoding.UTF8); String targetUrl = searchEngine + encodedKeyword; objIE.Navigate(targetUrl); //読み込み完了まで待つ while (objIE.Busy || objIE.ReadyState != SHDocVw.tagREADYSTATE.READYSTATE_COMPLETE) { //無処理 System.Windows.Forms.Application.DoEvents(); System.Threading.Thread.Sleep(100); } var ObjHtml = (mshtml.HTMLDocument)objIE.Document; var bodys = ObjHtml.getElementsByTagName("body"); foreach (mshtml.IHTMLElement element in bodys) { if (element != null) { Debug.WriteLine(element.outerHTML); } } System.Threading.Thread.Sleep(5000); if (objIE == null) { objIE.Quit(); } }
public void InitialBusinessLink() { //https://app.singlewindow.cn/cas/login?service=http%3A%2F%2Fwww.singlewindow.cn%2Fsinglewindow%2Flogin.jspx&logoutFlag=1&_swCardF=1 MyWebBrower.Navigate("https://app.singlewindow.cn/cas/login?service=http%3A%2F%2Fwww.singlewindow.cn%2Fsinglewindow%2Flogin.jspx&logoutFlag=1&_swCardF=1", ref o, ref o, ref o, ref o); DateTime strFileName = DateTime.Now;//开始时间 while (!isReadyForSearch) { System.Windows.Forms.Application.DoEvents(); } MyWebBrower.Quit(); isReadyForSearch = false; }
public IHttpActionResult appClick(PublicModel publicModel) { SHDocVw.InternetExplorer ie = new SHDocVw.InternetExplorer(); ie.Navigate(publicModel.Url); ie.Visible = true; IHTMLDocument3 doc = (IHTMLDocument3)ie.Document; doc.getElementById(publicModel.InputText1).innerText = "hello world"; doc.getElementById(publicModel.SavaId).click(); return(Json("yes")); }
public string AnalogClicks([FromUri] PublicFindModel findModel) { SHDocVw.InternetExplorer ie = new SHDocVw.InternetExplorer(); ie.Navigate(findModel.Url); ie.Visible = true; IHTMLDocument3 doc = (IHTMLDocument3)ie.Document; doc.getElementById(findModel.InputText1).innerText = "hello world"; doc.getElementById(findModel.SavaId).click(); return("yes"); }
public Task Start(System.Threading.CancellationToken token) { var tcs = new TaskCompletionSource <string>(); SHDocVw.InternetExplorer ie = new SHDocVw.InternetExplorer(); ie.Visible = true; ie.DocumentComplete += (object pDisp, ref object URL) => { ParseProxies(ie.Document as mshtml.HTMLDocument); }; ie.Navigate("http://spys.ru/en/non-anonymous-proxy-list/"); return(tcs.Task); }
public void IeExp() { ie.Height = 1200; ie.Width = 1500; ie.Visible = true; ie.DocumentComplete += Ie_DocomentComplete; ie.Navigate("http://www.baidu.com"); ie.Visible = true; ie_read = false; compWait(); HTMLDocument doc = ie.Document; doc.getElementById("kw").innerText = "234567"; //ie.Quit(); }
/// <summary> /// Establecer el formulario como seleccionado para que muestre en el frente de la pantalla /// </summary> public void seleccionarFormulario(string ruta) { try { //Se comprueba que el objeto no este nulo if (oSHDocVw != null) { //Se carga el archivo xml al visor oSHDocVw.Navigate(ruta); } visualiza.Select(); } catch (Exception) { } }
public async Task <string> GetAuthorizationCodeAsync(string uri) { var authorizationCode = string.Empty; SHDocVw.InternetExplorer ie = null; try { ie = new SHDocVw.InternetExplorer(); ie.Navigate(uri); await WaitAsync(ie); ie.Visible = true; do { var url = ie.LocationURL; if (url.Contains("?code=")) { var index = url.IndexOf("?code="); if (index > 0) { authorizationCode = url.Substring(index + 6); } break; } await Task.Delay(TimeSpan.FromMilliseconds(100)); } while (true); } catch (Exception) { // ie を閉じたときに ie.LocationURL にアクセスするタイミングで COMException が発生する } finally { if (ie != null) { try { ie.Quit(); } catch (Exception) { } Marshal.ReleaseComObject(ie); ie = null; } } return(authorizationCode); }
static void Main(string[] args) { SHDocVw.InternetExplorer ie = new SHDocVw.InternetExplorer(); ie.DocumentComplete += ie_DocumentComplete; ie.Navigate("https://www.baidu.com/"); ie.Visible = true; //while (ie_Read) //{ // Thread.Sleep(1000); // if (ie.ReadyState == SHDocVw.tagREADYSTATE.READYSTATE_COMPLETE) // break; //} IHTMLDocument3 doc = (IHTMLDocument3)ie.Document; doc.getElementById("kw").innerText = "hello world"; doc.getElementById("su").click(); Console.Read(); }
public override void RunCommand(object sender) { var engine = (Core.Automation.Engine.AutomationEngineInstance)sender; var instanceName = v_InstanceName.ConvertToUserVariable(sender); SHDocVw.InternetExplorer newBrowserSession = new SHDocVw.InternetExplorer(); try { newBrowserSession.Navigate(v_URL.ConvertToUserVariable(sender)); WaitForReadyState(newBrowserSession); newBrowserSession.Visible = true; } catch (Exception ex) { } //add app instance engine.AddAppInstance(instanceName, newBrowserSession); //handle app instance tracking if (v_InstanceTracking == "Keep Instance Alive") { GlobalAppInstances.AddInstance(instanceName, newBrowserSession); } }
private void viewDocument(ECMFolderService.documentDto doc) { if (doc != null) { //LOG.imprimeLog(System.DateTime.Now + " ========= Exibindo documento: " + doc.documentId + " - " + doc.version + " = " + doc.documentDescription); SHDocVw.InternetExplorer ie = new SHDocVw.InternetExplorer(); string url = ecmURL; if (!url.EndsWith("/")) { url = url + "/"; } url = url + "documentviewer?WDNrDocto=" + doc.documentId + "&WDNrVersao=" + doc.version; //LOG.imprimeLog(System.DateTime.Now + " ========= URL: " + url); ie.Navigate(url); ie.ToolBar = 0; ie.AddressBar = false; ie.Visible = true; } else { LOG.imprimeLog(System.DateTime.Now + " ========= Lascou!!! Nao achou o documento!!"); } }
private void loadPosts() { try { error = false; posts.Clear(); int count = 0; SHDocVw.InternetExplorer IE = new SHDocVw.InternetExplorer(); IE.Visible = false; for (int i = (int)Math.Floor(minPage.Value); i <= (int)Math.Floor(maxPage.Value); i++) { IE.Navigate(File.ReadAllText("MafiaUrlConfig") + "?pagenum=" + i); while (IE.ReadyState.ToString() != "READYSTATE_COMPLETE") { System.Threading.Thread.Sleep(100); } if (!IE.LocationURL.ToString().Contains("pagenum") && count < 5) { count++; i--; } else if (count >= 5) { MessageBox.Show("Could not connect to forum post. Make sure that you are logged into roll20 on Internet Explorer, and that you have the correct url."); count = 0; posts.Clear(); break; } else { var htmlDoc = IE.Document; string content = htmlDoc.body.outerHTML; File.WriteAllText("temporaryHold.html", content); // load snippet HtmlAgilityPack.HtmlDocument htmlSnippet = new HtmlAgilityPack.HtmlDocument(); htmlSnippet = LoadHtmlSnippetFromFile(); // extract Posts if (ExtractAllPosts(htmlSnippet, i.ToString()) != null) { posts.AddRange(ExtractAllPosts(htmlSnippet, i.ToString())); } else { error = true; posts.Clear(); break; } } } IE.Quit(); } catch (FileNotFoundException) { MessageBox.Show("Please click on the New Game button in the bottom left of the page to add your game"); } catch (Exception e) { MessageBox.Show(e.Message); } try { using (StreamWriter sw = File.CreateText("All.html")) { sw.WriteLine("<head>"); sw.WriteLine("<meta charset='utf-8'>"); sw.WriteLine("</head>"); sw.WriteLine("<body>"); if (!error) { foreach (ForumPost f in posts) { AddToComboBox(f.name); sw.WriteLine("<table style='width:100%'><tr><td><h3><font color='" + dictionary[comboBox1.Items.IndexOf(f.name)] + "'>" + f.name + "</font></h3></td>" + "<td align='right'><h4> Page: " + f.page + "</h4></td></tr>"); sw.WriteLine("<h4>" + f.time + "</h4>"); sw.WriteLine("<p>" + f.post + "</p>"); sw.WriteLine(); sw.WriteLine("<hr>"); } sw.WriteLine("</body>"); } else { sw.WriteLine("<h1>ERROR</h1>"); sw.WriteLine("</body>"); } } NavigateWebBrowserThread(di.ToString() + "\\All.html"); MovePostsToMainThread(posts); SetComboBoxToIndexThread(0); } catch (Exception e) { MessageBox.Show(e.Message); } }
public void Navigate(string url) { ie.Navigate(url); Wait(); }
private void startButton_Click(object asdf, EventArgs e) { this.Cursor = Cursors.WaitCursor; //------------------------- //openVAS Report Parsing //------------------------- if (NessusRadio.Checked == true) { //---------------------------------- // Ensure a path has been specified //---------------------------------- if (pathTextBox.Text == "") { MessageBox.Show("Please enter a path to a Nessus CSV file."); } else { String path = Directory.GetCurrentDirectory(); Excel.Application excelApp = new Excel.Application(); excelApp.Visible = true; excelApp.DisplayAlerts = false; Excel.Workbook excelWorkbooks = null; Excel.Workbook pivotTableTemplate = null; //------------------------- // Check file extension //------------------------- if (Path.GetExtension(pathTextBox.Text).Equals(".csv")) { //------------------------------------------------- // copy initial template for pivot table //------------------------------------------------- File.Copy("template_nessus.xlsx", pathTextBox.Text + "-parsedNessus.xlsx", true); //------------------------------------------------- // This opens the csv file and converts it to xlsx // Saves it in the specified path in the text box //------------------------------------------------- try { excelWorkbooks = excelApp.Workbooks.Open(pathTextBox.Text); excelWorkbooks.SaveAs(pathTextBox.Text + ".xlsx", FileFormat: Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook); excelWorkbooks.Close(); excelWorkbooks = excelApp.Workbooks.Open(pathTextBox.Text + ".xlsx"); Excel._Worksheet convertedCSVWorksheet = excelWorkbooks.ActiveSheet; //Get range to use for loops Excel.Range usedRange = convertedCSVWorksheet.UsedRange; /* * transfer all the information * into the excel pivot table */ pivotTableTemplate = excelApp.Workbooks.Open(pathTextBox.Text + "-parsedNessus.xlsx"); Excel._Worksheet pivotTableData = pivotTableTemplate.Sheets[2]; for (int i = 0; i < usedRange.Rows.Count; ++i) { if (i == 0) { continue; } else { //ID pivotTableData.Cells[i + 9, 1] = convertedCSVWorksheet.Cells[i + 1, 1]; //IP pivotTableData.Cells[i + 9, 2] = convertedCSVWorksheet.Cells[i + 1, 5]; //Vulnerability Name pivotTableData.Cells[i + 9, 3] = convertedCSVWorksheet.Cells[i + 1, 8]; //Risk and Severity if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 4].Value).Equals("None") || Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 4].Value).Equals("Info")) { pivotTableData.Cells[i + 9, 4] = "Info"; pivotTableData.Cells[i + 9, 5] = "0"; } if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 4].Value).Equals("Low")) { pivotTableData.Cells[i + 9, 4] = "Low"; pivotTableData.Cells[i + 9, 5] = "1"; } if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 4].Value).Equals("Medium")) { pivotTableData.Cells[i + 9, 4] = "Medium"; pivotTableData.Cells[i + 9, 5] = "2"; } if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 4].Value).Equals("High")) { pivotTableData.Cells[i + 9, 4] = "High"; pivotTableData.Cells[i + 9, 5] = "3"; } if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 4].Value).Equals("Critical") || Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 4].Value).Equals("Serious")) { pivotTableData.Cells[i + 9, 4] = "Critical"; pivotTableData.Cells[i + 9, 5] = "4"; } //Protocol pivotTableData.Cells[i + 9, 6] = convertedCSVWorksheet.Cells[i + 1, 6]; //Port if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 7].Value).Equals("0")) { pivotTableData.Cells[i + 9, 7] = "---"; } else { pivotTableData.Cells[i + 9, 7] = convertedCSVWorksheet.Cells[i + 1, 7]; } pivotTableData.Cells[i + 9, 8] = convertedCSVWorksheet.Cells[i + 1, 10]; pivotTableData.Cells[i + 9, 9] = convertedCSVWorksheet.Cells[i + 1, 11]; //cvss vector, exploit available, and vulnerability publish date if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 2].Value) != null && !(Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 2].Value).Equals("-"))) { String[] cve = Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 2].Value).Split(','); //must do in openvas due to csv cve String NVDurl = "https://web.nvd.nist.gov/view/vuln/detail?vulnId=" + cve[0]; SHDocVw.InternetExplorer IE = new SHDocVw.InternetExplorer(); IE.Visible = false; IE.Navigate(NVDurl); System.Threading.Thread.Sleep(2000); mshtml.IHTMLDocument2 htmlDoc = IE.Document as mshtml.IHTMLDocument2; string content = htmlDoc.body.parentElement.outerHTML; int CVSSVectorStartIndex = content.IndexOf("(AV", content.IndexOf("(AV") + 1); int CVSSVectorEndIndex = 28; int vulnDateStartIndex = content.IndexOf("Original release date:") + 42; int vulnDateEndIndex = 10; pivotTableData.Cells[i + 9, 8] = convertedCSVWorksheet.Cells[i + 1, 10]; pivotTableData.Cells[i + 9, 9] = convertedCSVWorksheet.Cells[i + 1, 11]; if (vulnDateStartIndex != -1) { string stringVulndDate = content.Substring(vulnDateStartIndex, vulnDateEndIndex); pivotTableData.Cells[i + 9, 11] = stringVulndDate; } if (CVSSVectorStartIndex != -1) { string stringCVSSVector = content.Substring(CVSSVectorStartIndex, CVSSVectorEndIndex); pivotTableData.Cells[i + 9, 15] = stringCVSSVector; } IE.Quit(); } //Exploit available if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 2].Value) != null) { pivotTableData.Cells[i + 9, 10] = "Exploit is available."; } //See Also pivotTableData.Cells[i + 9, 13] = convertedCSVWorksheet.Cells[i + 1, 12]; //CVSS SCORE pivotTableData.Cells[i + 9, 14] = convertedCSVWorksheet.Cells[i + 1, 3]; //CVE pivotTableData.Cells[i + 9, 16] = convertedCSVWorksheet.Cells[i + 1, 2]; } } //--------------------------------------------------- // Close worksheets and workbooks. Release Resources // and close excel //--------------------------------------------------- System.Runtime.InteropServices.Marshal.ReleaseComObject(convertedCSVWorksheet); excelWorkbooks.Close(false); pivotTableTemplate.Close(true); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelWorkbooks); excelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp); MessageBox.Show("Done parsing file."); } catch (Exception err) { MessageBox.Show("Error encountered. Please try again."); if (excelWorkbooks != null) { excelWorkbooks.Close(); } System.Runtime.InteropServices.Marshal.ReleaseComObject(excelWorkbooks); excelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp); } } else { if (excelWorkbooks != null) { excelWorkbooks.Close(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelWorkbooks); } excelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp); MessageBox.Show("Please select a CSV file."); } } } //----------------------- // Nessus Report Parsing //----------------------- else { if (pathTextBox.Text == "") { MessageBox.Show("Please enter a path to a Nessus CSV file."); } else { String path = Directory.GetCurrentDirectory(); Excel.Application excelApp = new Excel.Application(); excelApp.Visible = true; excelApp.DisplayAlerts = false; Excel.Workbook excelWorkbooks = null; Excel.Workbook pivotTableTemplate = null; //------------------------- // Check file extension //------------------------- if (Path.GetExtension(pathTextBox.Text).Equals(".xlsx")) { //------------------------------------------------- // copy initial template for pivot table //------------------------------------------------- File.Copy("template_openvas.xlsx", pathTextBox.Text + "-parsedOpenVAS.xlsx", true); try { //start timer for time analysis Stopwatch stopwatch = new Stopwatch(); stopwatch.Start(); excelWorkbooks = excelApp.Workbooks.Open(pathTextBox.Text); // excelWorkbooks.SaveAs(pathTextBox.Text + ".xlsx", FileFormat: Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook); // excelWorkbooks.Close(); //closes first workbook // excelWorkbooks = excelApp.Workbooks.Open(pathTextBox.Text + ".xlsx"); Excel._Worksheet convertedCSVWorksheet = excelWorkbooks.ActiveSheet; //opens another workbook on index 1 /* * Getting range and iterating through * the open file to get information * for report */ Excel.Range usedRange = convertedCSVWorksheet.UsedRange; pivotTableTemplate = excelApp.Workbooks.Open(pathTextBox.Text + "-parsedOpenVAS.xlsx"); Excel._Worksheet pivotTableData = pivotTableTemplate.Sheets[2]; for (int i = 0; i < usedRange.Rows.Count; ++i) { if (i < 6) { continue; } else { //ID pivotTableData.Cells[i + 4, 1] = convertedCSVWorksheet.Cells[i + 1, 4]; //IP pivotTableData.Cells[i + 4, 2] = convertedCSVWorksheet.Cells[i + 1, 2]; //Hostname pivotTableData.Cells[i + 4, 3] = convertedCSVWorksheet.Cells[i + 1, 1]; //Operating System/software check if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 13].Value) != "n/a") { pivotTableData.Cells[i + 4, 4] = convertedCSVWorksheet.Cells[i + 1, 13]; } //Vulnerability Name if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 8].Value) != "n/a") { pivotTableData.Cells[i + 4, 5] = convertedCSVWorksheet.Cells[i + 1, 8]; } else { pivotTableData.Cells[i + 4, 5] = "Not available."; } //Risk Level if (convertedCSVWorksheet.Cells[i + 1, 7].Value2 != null) { if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 7].Value2).Equals("None") || Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 7].Value2).Equals("Info")) { pivotTableData.Cells[i + 4, 6] = "Info"; pivotTableData.Cells[i + 4, 7] = "0"; } if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 7].Value2).Equals("Low")) { pivotTableData.Cells[i + 4, 6] = "Low"; pivotTableData.Cells[i + 4, 7] = "1"; } if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 7].Value2).Equals("Medium")) { pivotTableData.Cells[i + 4, 6] = "Medium"; pivotTableData.Cells[i + 4, 7] = "2"; } if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 7].Value2).Equals("High")) { pivotTableData.Cells[i + 4, 6] = "High"; pivotTableData.Cells[i + 4, 7] = "3"; } if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 7].Value2).Equals("Critical") || Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 7].Value2).Equals("Serious")) { pivotTableData.Cells[i + 4, 6] = "Critical"; pivotTableData.Cells[i + 4, 7] = "4"; } } String[] parenthSplit = Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 3].Value).Split('('); //service pivotTableData.Cells[i + 4, 8] = parenthSplit[0]; //protocol String[] slashSplit = parenthSplit[1].Split('/'); pivotTableData.Cells[i + 4, 9] = slashSplit[1].Substring(0, slashSplit[1].Length - 1); //port pivotTableData.Cells[i + 4, 10] = slashSplit[0]; //Vulnerability Description pivotTableData.Cells[i + 4, 11] = convertedCSVWorksheet.Cells[i + 1, 9]; //Remediation check if (!(Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 10].Value2).Equals("n/a"))) { pivotTableData.Cells[i + 4, 12] = convertedCSVWorksheet.Cells[i + 1, 10]; } //Results check // pivotTableData.Cells[i + 4, 13] = convertedCSVWorksheet.Cells[i + 1, 12]; if (!(Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 12].Value2).Equals("n/a"))) { pivotTableData.Cells[i + 4, 13] = convertedCSVWorksheet.Cells[i + 1, 12].Value2; } //pivotTableData.Cells[i + 4, 13] = convertedCSVWorksheet.Cells[i + 1, 12].Value2; //exploit available if (Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 6].Value) != null && !(Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 6].Value).Equals("-"))) { pivotTableData.Cells[i + 4, 14] = "Exploit is available."; //cvss score 18 if (Convert.ToInt32(convertedCSVWorksheet.Cells[i + 1, 5].Value) != 0) { pivotTableData.Cells[i + 4, 18] = convertedCSVWorksheet.Cells[i + 1, 5]; } //cvss vector 19 String[] cve = Convert.ToString(convertedCSVWorksheet.Cells[i + 1, 6].Value).Split(','); //must do in openvas due to csv cve String NVDurl = "https://web.nvd.nist.gov/view/vuln/detail?vulnId=" + cve[0]; pivotTableData.Cells[i + 4, 17] = NVDurl; SHDocVw.InternetExplorer IE = new SHDocVw.InternetExplorer(); IE.Visible = false; IE.Navigate(NVDurl); System.Threading.Thread.Sleep(2000); mshtml.IHTMLDocument2 htmlDoc = IE.Document as mshtml.IHTMLDocument2; string content = htmlDoc.body.parentElement.outerHTML; int CVSSVectorStartIndex = content.IndexOf("(AV", content.IndexOf("(AV") + 1); int CVSSVectorEndIndex = 28; int vulnDateStartIndex = content.IndexOf("Original release date:") + 42; int vulnDateEndIndex = 10; if (vulnDateStartIndex != -1) { string stringVulndDate = content.Substring(vulnDateStartIndex, vulnDateEndIndex); pivotTableData.Cells[i + 4, 15] = stringVulndDate; } if (CVSSVectorStartIndex != -1) { string stringCVSSVector = content.Substring(CVSSVectorStartIndex, CVSSVectorEndIndex); pivotTableData.Cells[i + 4, 19] = stringCVSSVector; } IE.Quit(); //cve 20 pivotTableData.Cells[i + 4, 20] = convertedCSVWorksheet.Cells[i + 1, 6]; //Console.WriteLine(cve[0]); //WebClient browser = new WebClient(); //string nvdWebsite = browser.DownloadString(NVDurl); //int index1 = nvdWebsite.IndexOf("Date Entry Created") + 49; //int index2 = 8; //string substr = nvdWebsite.Substring(index1, index2); //Console.WriteLine(substr); //HtmlAgilityPack.HtmlDocument page = new HtmlAgilityPack.HtmlDocument(); //Console.WriteLine(nvdWebsite); //WatiN.Core.Settings.MakeNewIeInstanceVisible = false; //WatiN.Core.Settings.AutoMoveMousePointerToTopLeft = false; //page.LoadHtml(nvdWebsite); //HtmlNode titleNode = page.DocumentNode.SelectSingleNode("/html/body/div[1]/div[4]/table/tr[9]/td/b"); //if (titleNode == null) //{ // Console.WriteLine("NULL OMG NULL"); //} //HtmlNode titleNode = pageResult.Html.CssSelect(".hohoho-header").First(); //string stuffnode = titleNode.InnerText; //Console.WriteLine(titleNode); //pivotTableData.Cells[i + 4, 15] = titleNode; } } } //--------------------------------------------------- // Close worksheets and workbooks. Release Resources // and close excel //--------------------------------------------------- System.Runtime.InteropServices.Marshal.ReleaseComObject(convertedCSVWorksheet); excelWorkbooks.Close(false); pivotTableTemplate.Close(true); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelWorkbooks); excelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp); MessageBox.Show("Done parsing file."); } catch (Exception err) { MessageBox.Show("Error encountered. Please try again."); if (excelWorkbooks != null) { excelWorkbooks.Close(); } System.Runtime.InteropServices.Marshal.ReleaseComObject(excelWorkbooks); excelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp); } } else { if (excelWorkbooks != null) { excelWorkbooks.Close(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelWorkbooks); } excelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp); MessageBox.Show("Please select a XLSX file."); } } } this.Cursor = Cursors.Default; }
void CommandBinding_Help(object sender, ExecutedRoutedEventArgs e) { IE = new SHDocVw.InternetExplorer(); IE.Navigate(System.Windows.Forms.Application.StartupPath + @"\Help\Help.html"); IE.Visible = true; }