private void InitializationSites() { all_sites.Add(new NplusOne()); all_sites.Add(new KinoPoisk()); all_sites.Add(new Kanobu()); all_sites.Add(new LentaRu()); all_sites.Add(new TheVillagePars()); all_sites.Add(new TJpars()); all_sites.Add(new RoemInvesticii()); all_sites.Add(new RoemMedia()); all_sites.Add(new LifeHacker()); all_sites.Add(new RiaNews()); all_sites.Add(new DiletantMedia()); all_sites.Add(new LibrebookNews()); all_sites.Add(new AdMe()); all_sites.Add(new Starhit()); string allSitesLink = ""; foreach (var site in all_sites) { allSitesLink += site.Source + ";"; } DBClient client = new DBClient(); client.Query("UPDATE users SET favorites_source = @allSitesLink WHERE id = 0", new MySql.Data.MySqlClient.MySqlParameter("allSitesLink", allSitesLink)); }
public ContentUnit() { MySqlConnectionStringBuilder sqlStrBuilder = new MySqlConnectionStringBuilder(); sqlStrBuilder.Server = "localhost"; sqlStrBuilder.Database = "work_db"; sqlStrBuilder.UserID = "root"; sqlStrBuilder.Password = "******"; client = new DBClient(sqlStrBuilder); }
public MainWindow() { InitializeComponent(); all_sites = new List <SiteForPars>(); InitializationSites(); ContentUnit.Row_limit = 5000; client = new DBClient(); refresh_timer = new DispatcherTimer(); refresh_timer.Tick += Refresh_timer_Tick; refresh_timer.Interval = new TimeSpan(0, 0, 30); button_off.Click += Button_off_Click; button_on.Click += Button_on_Click; button_delete_all.Click += Delete_all_Click; passw.KeyDown += Passw_KeyDown; }
public ContentUnit() { client = new DBClient(); date = header = imgUrl = description = URL = tags = source = ""; This = this; }