static void email(bontique a, int type)
{
var clientstmp = new SmtpClient("smtp.gmail.com", 587)
{
//gmail support
Credentials = new NetworkCredential("*****@*****.**", "innovation123"),
EnableSsl = true
};
//MailMessage(from,to,...)
if (type == 1)
{
MailMessage mail = new MailMessage("*****@*****.**", "*****@*****.**", "Price Changed!", a.url + " Now the price is " + a.lowest + " highest price is " + a.highest);
clientstmp.Send(mail);
}
else if (type == 2)
{
MailMessage mail = new MailMessage("*****@*****.**", "*****@*****.**", "Few left!", a.url + " Now the price is " + a.lowest + " highest price is " + a.highest);
clientstmp.Send(mail);
}
else if (type == 3)
{
MailMessage mail = new MailMessage("*****@*****.**", "*****@*****.**", "Sold Out!", a.url + " Now the price is " + a.lowest + " highest price is " + a.highest);
clientstmp.Send(mail);
}
else
{
//illegal type
MailMessage mail = new MailMessage("*****@*****.**", "*****@*****.**", "Price Changed!", a.url + " Now the price is " + a.lowest + " highest price is " + a.highest);
clientstmp.Send(mail);
}
}
static void Main(string[] args)
{
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkBook = xlApp.Workbooks.Open(@"D:\Github\SSENSE_Price_checker\data.xlsx");
Excel._Worksheet xlWorksheet = xlWorkBook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
int colCount = xlRange.Columns.Count;
List <bontique> buylist = new List <bontique>();
for (int i = 1; i <= rowCount; i++)
{
bontique tmp = new bontique()
{
row = i, url = xlRange.Cells[i, 1].Text, lowest = Convert.ToDouble(xlRange.Cells[i, 2].Text), highest = Convert.ToDouble(xlRange.Cells[i, 3].Text), last = Convert.ToDouble(xlRange.Cells[i, 4].Text), size = xlRange.Cells[i, 5].Text
};
buylist.Add(tmp);
}
IWebDriver driver = new FirefoxDriver(@"D:\Github\SSENSE_Price_checker");
foreach (bontique tmp1 in buylist)
{
/*
* using (WebClient client = new WebClient()) // WebClient class inherits IDisposable
* {
* System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
* string htmlCode = client.DownloadString(tmp1.url);
* int position = htmlCode.IndexOf("class=\"price\">");
* }
*/
driver.Url = tmp1.url;
IWebElement pricetag = driver.FindElement(By.XPath("//span[@class='price']"));
string ooo = pricetag.GetAttribute("innerHTML").ToString();
double price = Convert.ToDouble(ooo.Replace(" CAD", "").Replace("$", ""));
//check if size exist
if (driver.FindElements(By.XPath("//select[@id='size']")).Count() != 0)
{
IWebElement sizeelement = driver.FindElement(By.XPath("//select[@id='size']"));
string sizeString = sizeelement.Text;
string[] sizeList = sizeString.Split(
new[] { "\r\n", "\r", "\n" },
StringSplitOptions.None
);
//only xx left, sold out, normal
foreach (string tmpsize in sizeList)
{
if (tmpsize.Contains(tmp1.size))
{
if (tmpsize.Contains("Out"))
{
//sold out send notification
email(tmp1, 3);
}
else if (tmpsize.Contains("left"))
{
//only serveral left buybuybuy!
email(tmp1, 2);
}
else
{
//do nothing
}
}
}
}
if (driver.FindElements(By.XPath("//span[@class='text-no-transform']")).Count() != 0)
{
email(tmp1, 2);
}
xlRange.Cells[tmp1.row, 4].Value = price;
if (price < tmp1.lowest)
{
xlRange.Cells[tmp1.row, 2].Value = price;
tmp1.lowest = price;
email(tmp1, 1);
}
if (price > tmp1.highest)
{
xlRange.Cells[tmp1.row, 3].Value = price;
}
}
driver.Close();
driver.Quit();
xlWorkBook.Save();
xlWorkBook.Close(0);
xlApp.Quit();
}