/// <summary> /// gets the amazon link of a post from the website /// </summary> /// <param name="driver"></param> /// <param name="wait"></param> /// <param name="post"></param> /// <returns></returns> public static String getLink(IWebDriver driver, WebDriverWait wait, Post post) { int totalPages; String tag = Wordpress.SendGetTag(Wordpress.GetTag(post)); driver.FindElement(By.XPath("//div [@class = 'wp-menu-image dashicons-before dashicons-admin-post']")).Click(); if (driver.FindElements(By.XPath("//span [@class = 'total-pages']")).Count > 0) { totalPages = int.Parse(driver.FindElement(By.XPath("//span [@class = 'total-pages']")).Text); } else { totalPages = 1; } for (int x = 1; x <= totalPages; x++) { List <IWebElement> elements = driver.FindElements(By.XPath("//td [@class = 'tags column-tags']")).ToList(); foreach (IWebElement element in elements) { if (element.Text == tag) { return(driver.FindElement(By.XPath("(//span [@class = 'url'])[" + (elements.IndexOf(element) + 1).ToString() + "]")).GetAttribute("innerHTML")); } } if (x != totalPages) { driver.FindElement(By.XPath("//a [@class = 'next-page button']")).Click(); wait.Until(ExpectedConditions.PresenceOfAllElementsLocatedBy(By.XPath("//td [@id = 'cb']"))); } } MessageBox.Show("Link not found"); return("Not Found"); }
public static void WriteProducts() { SqlCommand cmd = new SqlCommand("TRUNCATE TABLE Products", con); cmd.ExecuteNonQuery(); List <Post> WP = Wordpress.SendGetPosts(Wordpress.GetPosts()); foreach (Post post in WP) { String id = Wordpress.SendGetTag(Wordpress.GetTag(post)); String name = post.Title.Rendered; int price = int.Parse(Formatting.GetPrice(post.Content.Rendered)); int xprice = int.Parse(Formatting.GetXprice(post.Content.Rendered)); String category = Formatting.CatIDtoCategory(post.Categories[0]); String url = post.Link; cmd.CommandText = $"INSERT INTO Products VALUES ('{id}', '{name}', {price}, {xprice}, '{category}', '{url}');"; cmd.ExecuteNonQuery(); } }
public static void WriteHHPosts() { IWorkbook wb = new XSSFWorkbook(); ISheet ws = wb.CreateSheet(); IRow header = ws.CreateRow(0); header.CreateCell(0).SetCellValue("Name"); header.CreateCell(1).SetCellValue("Price"); header.CreateCell(2).SetCellValue("Old Price"); header.CreateCell(3).SetCellValue("Difference"); header.CreateCell(4).SetCellValue("Category"); header.CreateCell(5).SetCellValue("ID"); header.CreateCell(6).SetCellValue("URL"); int rowcount = 1; List <Post> WP = Wordpress.SendGetPosts(Wordpress.GetPosts()); foreach (Post post in WP) { IRow row = ws.CreateRow(rowcount); row.CreateCell(0).SetCellValue(post.Title.Rendered); row.CreateCell(1).SetCellValue(int.Parse(Formatting.GetPrice(post.Content.Rendered))); row.CreateCell(2).SetCellValue(int.Parse(Formatting.GetXprice(post.Content.Rendered))); row.CreateCell(3).SetCellValue(int.Parse(Formatting.GetXprice(post.Content.Rendered)) - int.Parse(Formatting.GetPrice(post.Content.Rendered))); row.CreateCell(4).SetCellValue(Formatting.CatIDtoCategory(post.Categories[0])); row.CreateCell(5).SetCellValue(Wordpress.SendGetTag(Wordpress.GetTag(post))); row.CreateCell(6).SetCellValue(post.Link); rowcount++; } ws.CreateRow(rowcount).CreateCell(0).SetCellValue("Stop"); rowcount++; ws.CreateRow(rowcount).CreateCell(0).SetCellValue(DateTime.Now.ToString("D")); wb.Write(new FileStream(@"C:\Users\email\Desktop\Hardware Hub\HHPosts.xlsx", FileMode.Create, FileAccess.Write, FileShare.ReadWrite)); wb.Close(); }