public ActionResult ScraperSzczegoly(int productID) { ScraperDetailsViewModel scraperDetails = new ScraperDetailsViewModel(); using (sklepEntities db = new sklepEntities()) { Scrapers scraper = db.Scrapers.Where(x => x.ProductID == productID).FirstOrDefault(); if (scraper.DifferencePrice != null) { scraperDetails.DifferencePrice = ((decimal)scraper.DifferencePrice).ToString("C2"); } scraperDetails.LastUpdate = (DateTime)scraper.DateLastUpdate; scraperDetails.XKomPrice = ReplacePriceScraper(scraper.XKomPrice); scraperDetails.XKomLinks = GetLinks(scraper.XKomLink); scraperDetails.XKomLinkChecked = scraper.XKomLinkChecked; scraperDetails.VobisPrice = ReplacePriceScraper(scraper.VobisPrice); scraperDetails.VobisLinks = GetLinks(scraper.VobistLink); scraperDetails.VobisLinkChecked = scraper.VobistLinkChecked; scraperDetails.AlsenPrice = ReplacePriceScraper(scraper.AlsenPrice); scraperDetails.AlsenLinks = GetLinks(scraper.AlsentLink); scraperDetails.AlsenLinkChecked = scraper.AlsentLinkChecked; scraperDetails.CeneoPrice = ReplacePriceScraper(scraper.CeneoPrice); scraperDetails.CeneoLinks = GetLinks(scraper.CeneoLink); scraperDetails.CeneoLinkChecked = scraper.CeneoLinkChecked; scraperDetails.ProductID = productID; } return(View(scraperDetails)); }
public void saveData(int productID, string xkomPrice, string xkomLink, string vobisPrice, string vobisLink, string alsenPrice, string alsenLink, string ceneoPrice, string ceneoLink, decimal differencePrice) { using (sklepEntities db = new sklepEntities()) { bool isExistProduct = db.Scrapers.Where(x => x.ProductID == productID).Any(); if (isExistProduct) { Scrapers productScrap = db.Scrapers.Where(x => x.ProductID == productID).Single(); productScrap.XKomPrice = xkomPrice; productScrap.XKomLink = xkomLink; productScrap.VobisPrice = vobisPrice; productScrap.VobistLink = vobisLink; productScrap.AlsenPrice = alsenPrice; productScrap.AlsentLink = alsenLink; productScrap.CeneoPrice = ceneoPrice; productScrap.CeneoLink = ceneoLink; productScrap.DateLastUpdate = DateTime.Now; if (differencePrice == -9999999) { productScrap.DifferencePrice = null; } else { productScrap.DifferencePrice = differencePrice; } db.SaveChanges(); } else { Scrapers productScrap = new Scrapers(); productScrap.XKomPrice = xkomPrice; productScrap.XKomLink = xkomLink; productScrap.VobisPrice = vobisPrice; productScrap.VobistLink = vobisLink; productScrap.AlsenPrice = alsenPrice; productScrap.AlsentLink = alsenLink; productScrap.CeneoPrice = ceneoPrice; productScrap.CeneoLink = ceneoLink; productScrap.ProductID = productID; productScrap.DateLastUpdate = DateTime.Now; if (differencePrice == -9999999) { productScrap.DifferencePrice = null; } else { productScrap.DifferencePrice = differencePrice; } db.Scrapers.Add(productScrap); db.SaveChanges(); } } }
public ActionResult ScraperEdycja(ScraperDetailsViewModel scraper) { System.Diagnostics.Debug.WriteLine("scrap " + scraper.ProductID + " " + scraper.XKomLinks + " \n" + scraper.XKomLinkChecked + " d"); using (sklepEntities db = new sklepEntities()) { Scrapers scraperDB = db.Scrapers.Where(x => x.ProductID == scraper.ProductID).First(); scraperDB.XKomLinkChecked = scraper.XKomLinkChecked; scraperDB.VobistLinkChecked = scraper.VobisLinkChecked; scraperDB.AlsentLinkChecked = scraper.AlsenLinkChecked; scraperDB.CeneoLinkChecked = scraper.CeneoLinkChecked; db.SaveChanges(); } return(RedirectToAction("ScraperSzczegoly", new { productID = scraper.ProductID })); }
public void OnImmediateChatReaction(NotifyTextMessageEvent evt, Action <string> messageCallback) { if (Settings.ImmediateYoutubeEnabled && AudioHelper.IsYouTubeVideoUrl(evt.Message) != null) { evt.Message = $"!yt {evt.Message}"; CommandHandler.HandleTextMessage(evt, messageCallback); } else if (Settings.ImmediateGeneralEnabled) { if (evt.Message.ToLower().StartsWith("[url]") && evt.Message.ToLower().EndsWith("[/url]")) { string url = evt.Message.Substring(5, evt.Message.Length - 11); string generalInfo = Scrapers.ScrapeGeneral(url); if (generalInfo != null) { messageCallback.Invoke(generalInfo); } } } }