Ejemplo n.º 1
0
        private void LoadSection(string[] linkSection)
        {
            /*if (!string.IsNullOrEmpty(LinkAdtextBox.Text) && !string.IsNullOrEmpty(userNametextBox.Text)
             && !string.IsNullOrEmpty(PasswordtextBox.Text) && !string.IsNullOrEmpty(pathToProxytextBox.Text)
             && !string.IsNullOrEmpty(pathToImgtextBox.Text))*/
              {
            try
            {
              label6.SetPropertyThreadSafe(() => label6.Text, "Start");

              while (AvitoState.Pausing || AvitoState.Paused)
              {
            if (AvitoState.Pausing)
            {
              AddLog(string.Empty, LogMessageColor.Information());
              AddLog("Paused", LogMessageColor.Information());
              AddLog(string.Empty, LogMessageColor.Information());
            }
            AvitoState.SetPaused();
            if (EbayState.Pausing || EbayState.Paused)
            {
              btnParsingAvitoEbayStart.SetPropertyThreadSafe(() => btnParsingAvitoEbayStart.Enabled, true);
              btnParsingAvitoEbayPause.SetPropertyThreadSafe(() => btnParsingAvitoEbayPause.Enabled, false);
              btnParsingAvitoEbayStop.SetPropertyThreadSafe(() => btnParsingAvitoEbayStop.Enabled, true);
            }
            else
            {
              btnParsingAvitoStart.SetPropertyThreadSafe(() => btnParsingAvitoStart.Enabled, true);
              btnParsingAvitoPause.SetPropertyThreadSafe(() => btnParsingAvitoPause.Enabled, false);
              btnParsingAvitoStop.SetPropertyThreadSafe(() => btnParsingAvitoStop.Enabled, true);
            }
            Thread.Sleep(1000);
              }

              if (AvitoState.Stopping || AvitoState.Stopped)
              {
            label6.SetPropertyThreadSafe(() => label6.Text, "Finish");
            return;
              }

              //Ссылка на обьявление
              //  URLLink = LinkAdtextBox.Text;
              //Создаем класс и вводим параметры
              var Parser = new RuslanParser(Properties.Default.User, Properties.Default.Password, Properties.Default.PathToProxy, mySqlDB);
              var imageCount = new ImageParsedCountHelper();
              var Parser2 = new RuslanParser2(Properties.Default.User, Properties.Default.Password, Properties.Default.PathToProxy, mySqlDB, Properties.Default.FtpUsername, Properties.Default.FtpPassword, imageCount);

              Parser.PathImages = Properties.Default.PathToImg;

              var linksAds = Parser.LoadLinks(linkSection[0]);
              if (linksAds == null)
              {
            AddLog("Parser: Couldn't retrieve ad links from given section " + linkSection[1], LogMessageColor.Error());
            return;
              }
              AddLog("Parser: " + linkSection[1], LogMessageColor.Information());
              AddLog("Parser: Count new ad: " + linksAds.Count().ToString(), LogMessageColor.Information());
              var i = 0;
              var countPre = 0;
              var countIns = 0;

              while (AvitoState.Pausing || AvitoState.Paused)
              {
            if (AvitoState.Pausing)
            {
              AddLog(string.Empty, LogMessageColor.Information());
              AddLog("Paused", LogMessageColor.Information());
              AddLog(string.Empty, LogMessageColor.Information());
            }
            AvitoState.SetPaused();
            if (EbayState.Pausing || EbayState.Paused)
            {
              btnParsingAvitoEbayStart.SetPropertyThreadSafe(() => btnParsingAvitoEbayStart.Enabled, true);
              btnParsingAvitoEbayPause.SetPropertyThreadSafe(() => btnParsingAvitoEbayPause.Enabled, false);
              btnParsingAvitoEbayStop.SetPropertyThreadSafe(() => btnParsingAvitoEbayStop.Enabled, true);
            }
            else
            {
              btnParsingAvitoStart.SetPropertyThreadSafe(() => btnParsingAvitoStart.Enabled, true);
              btnParsingAvitoPause.SetPropertyThreadSafe(() => btnParsingAvitoPause.Enabled, false);
              btnParsingAvitoStop.SetPropertyThreadSafe(() => btnParsingAvitoStop.Enabled, true);
            }
            Thread.Sleep(1000);
              }

              if (AvitoState.Stopping || AvitoState.Stopped)
              {
            label6.SetPropertyThreadSafe(() => label6.Text, "Finish");
            return;
              }

              foreach (var item in linksAds)
              {
            while (AvitoState.Pausing || AvitoState.Paused)
            {
              if (AvitoState.Pausing)
              {
                AddLog(string.Empty, LogMessageColor.Information());
                AddLog("Paused", LogMessageColor.Information());
                AddLog(string.Empty, LogMessageColor.Information());
              }
              AvitoState.SetPaused();
              if (EbayState.Pausing || EbayState.Paused)
              {
                btnParsingAvitoEbayStart.SetPropertyThreadSafe(() => btnParsingAvitoEbayStart.Enabled, true);
                btnParsingAvitoEbayPause.SetPropertyThreadSafe(() => btnParsingAvitoEbayPause.Enabled, false);
                btnParsingAvitoEbayStop.SetPropertyThreadSafe(() => btnParsingAvitoEbayStop.Enabled, true);
              }
              else
              {
                btnParsingAvitoStart.SetPropertyThreadSafe(() => btnParsingAvitoStart.Enabled, true);
                btnParsingAvitoPause.SetPropertyThreadSafe(() => btnParsingAvitoPause.Enabled, false);
                btnParsingAvitoStop.SetPropertyThreadSafe(() => btnParsingAvitoStop.Enabled, true);
              }
              Thread.Sleep(1000);
            }

            if (AvitoState.Stopping || AvitoState.Stopped)
              break;

            try
            {
              imageCount.ErrorList.Clear();
              imageCount.Resources.Clear();
              imageCount.CountParsed = 0;
              imageCount.CountDownloaded = 0;
              imageCount.ResourceId = string.Empty;
              AddLog("Parser: start parse link: " + item, LogMessageColor.Information());
              i++;
              if (i == 25)
                i = -1;
              URLLink = item;
              mySqlDB.PrepareAvitoEnvironment();
              Dictionary<PartsPage, IEnumerable<string>> result = null;
              try
              {
                result = Parser.Run(item);
              }
              catch (Exception ex)
              {
                AddLog("Parser: " + ex.Message, LogMessageColor.Error());
                continue;
              }
              var sb = new StringBuilder();
              sb.AppendLine();
              foreach (var element in result)
              {
                if (element.Key != PartsPage.Body)
                {
                  sb.Append(string.Format("{0,-15} - ", element.Key));
                  if (element.Value != null)
                    foreach (var t in element.Value)
                    {
                      if (element.Value.Count() > 1)
                        sb.Append(t + " |");
                      else
                        sb.Append(t);
                    }
                  sb.Append(Environment.NewLine);
                }
              }
              AddLog("Parser: " + sb.ToString().TrimEnd(Environment.NewLine.ToCharArray()), LogMessageColor.Information());
              IncParsed();
              countPre++;

              AddLog("Parser: sleep after parse on. " + Properties.Default.SleepAfterParseSec + " sec", LogMessageColor.Information());
              Thread.Sleep(Properties.Default.SleepAfterParseSec * 1000);
              AddLog("Parser: sleep after parse off", LogMessageColor.Information());

              AddLog("Parser: preparing ad to insert to db", LogMessageColor.Information());
              var idResourceList = mySqlDB.ResourceListIDAvito();
              mySqlDB.InsertFctAvitoGrabber(result, idResourceList, item, linkSection[1]);
              AddLog("Parser: ad inserted", LogMessageColor.Information());
              incInserted();
              imageCount.ResourceId = idResourceList;
              if (Properties.Default.PublishParsedData)
              {
                AddLog("Parser: Begin loading images", LogMessageColor.Information());
                Parser2.PathImages2 = Properties.Default.PathToImg;

                var result2 = Parser2.Run(item);
                AddLog("Parser: " + imageCount.CountParsed + " images parsed", LogMessageColor.Information());
                AddLog("Parser: " + imageCount.CountDownloaded + " images downloaded", LogMessageColor.Information());

                foreach (var error in imageCount.ErrorList)
                  AddLog(error.Key, error.Value == true ? LogMessageColor.Error() : LogMessageColor.Success());

                foreach (var im in imageCount.Resources)
                  mySqlDB.InsertassGrabberAvitoResourceList(idResourceList, im);

                mySqlDB.UpdateFctAvitoGrabberPhotoCount(idResourceList, imageCount.Resources.Count);

                AddLog("Parser: Loading images end", LogMessageColor.Information());
                AddLog("Parser: Begin publishing ad", LogMessageColor.Information());
                mySqlDB.ExecuteProcAvito(idResourceList);
                AddLog("Parser: End publishing ad", LogMessageColor.Information());

                AddLog("Parser: sleep after publication on. " + Properties.Default.SleepSecAfterPublicationSec + " sec", LogMessageColor.Information());
                Thread.Sleep(Properties.Default.SleepSecAfterPublicationSec * 1000);
                AddLog("Parser: sleep after publication off", LogMessageColor.Information());
              }
              else
              {
                AddLog("Parser: Saving data to SMSSpamer", LogMessageColor.Information());
                mySqlDB.InsertSMSSpamerData(idResourceList);
                AddLog("Parser: Data saved successfully", LogMessageColor.Information());
              }
              countIns++;
            }
            catch (Exception ex)
            {
              AddLog("Parser: " + ex.Message, LogMessageColor.Error());
            }
            AddLog(string.Empty, LogMessageColor.Information());
              }
              AddLogStatistic(linkSection[1], mySqlDB.CountAd, countIns);
            }
            catch (Exception ex)
            {
              AddLog("Parser: " + ex.Message, LogMessageColor.Error());
            }
            label6.SetPropertyThreadSafe(() => label6.Text, "Finish");
              }
        }
Ejemplo n.º 2
0
        private void OneLinkAvito()
        {
            try
              {
            label6.SetPropertyThreadSafe(() => label6.Text, "Start");
            //Ссылка на обьявление
            mySqlDB.PrepareAvitoEnvironment();
            //Создаем класс и вводим параметры
            var Parser = new RuslanParser(Properties.Default.User, Properties.Default.Password, Properties.Default.PathToProxy, mySqlDB);
            Parser.PathImages = Properties.Default.PathToImg;
            //вот тут мы вызывем запрос на Id к базе
            //Parser.LoadGuid = (() => MySqlDB.SeletGuid());
            //Parser.LoadGuid = (() => "1532");
            //тут мы присваем результат переменной result
            Dictionary<PartsPage, IEnumerable<string>> result = null;
            try
            {
              result = Parser.Run(URLLink);
            }
            catch (Exception ex)
            {
              AddLog("Parser: " + ex.Message, LogMessageColor.Error());
            }
            // тут мы передаем в метод вставки данные
            //result, index ID, ссылку на обьявления
            //id я не вставлял так как непонятно было и неподходило под структуру бд
            if (result != null)
            {
              var idResourceList = mySqlDB.ResourceListIDAvito();
              mySqlDB.InsertFctAvitoGrabber(result, idResourceList, URLLink, cbCategories.Text);
              var imageCount = new ImageParsedCountHelper();
              imageCount.ResourceId = idResourceList;
              var Parser2 = new RuslanParser2(Properties.Default.User, Properties.Default.Password, Properties.Default.PathToProxy, mySqlDB, Properties.Default.FtpUsername, Properties.Default.FtpPassword, imageCount);
              Parser2.PathImages2 = Properties.Default.PathToImg;
              var result2 = Parser2.Run(URLLink);
              AddLog("Parser: " + imageCount.CountParsed + " images parsed", LogMessageColor.Information());
              AddLog("Parser: " + imageCount.CountDownloaded + " images downloaded", LogMessageColor.Information());
              foreach (var error in imageCount.ErrorList)
              {
            AddLog(error.Key, error.Value == true ? LogMessageColor.Error() : LogMessageColor.Success());
              }

              foreach (var im in imageCount.Resources)
            mySqlDB.InsertassGrabberAvitoResourceList(idResourceList, im);

              mySqlDB.UpdateFctAvitoGrabberPhotoCount(idResourceList, imageCount.Resources.Count);

              AddLog("Parser: Loading images end", LogMessageColor.Information());
              AddLog("Parser: Begin publishing ad", LogMessageColor.Information());
              mySqlDB.ExecuteProcAvito(idResourceList);
              AddLog("Parser: End publishing ad", LogMessageColor.Information());
            }
              }
              catch (Exception ex)
              {
            AddLog("Parser: " + ex.Message, LogMessageColor.Error());
              }
              label6.SetPropertyThreadSafe(() => label6.Text, "Finish");
        }