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;
}
