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));
}
private void Delete_all_Click(object sender, RoutedEventArgs e)
{
if (passw.Password == "TooEasyWork")
{
client.Query("DELETE FROM content");
passw.Password = "";
}
}
/// <summary>
///
/// </summary>
public bool LoadContentToSQL()
{
if (ContainsNote())
{
return(false);
}
time_of_addition = DateTime.Now;
client.Query("INSERT INTO content (header, description, imgUrl, URL, tags, source, date, time_of_addition)"
+ "VALUES(@header, @description, @imgUrl, @URL, @tags, @source, @date, @time_of_addition)", this);
CheckForOF(this);
return(true);
}
/// <summary>
///
/// </summary>
public void LoadContentToSQL()
{
ID++;
client.Query("INSERT INTO content VALUES(" + ID + "+", " + header +", " +description +", " +imgUrl +", "
+ URL + "," + tags + "," + source + ");");
}