private void AdvertisingForm_Load(object sender, EventArgs e)
{
this.Font = Configs.USER_FONT;
this.ForeColor = Configs.USER_COLOR;
List <String> catsList = SQLClass.Select("SELECT Name FROM " + Tables.CATEGORIES + " LIMIT 0, 7");
for (int artIndex = 0; artIndex < catsList.Count; artIndex++)
{
checkedListBox1.Items.Add(catsList[artIndex].ToString());
}
List <String> s = Advertising.GetRandom();
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
pictureBox1.LoadAsync(s[0]);
pictureBox1.Tag = s[1];
}
private void button3_Click(object sender, EventArgs e)
{
panel1.Controls.Clear();
Dictionary <String, String> dict = new Dictionary <string, string>();
dict.Add("STR", "%" + textBox2.Text + "%");
List <String> AuthorArticles =
SQLClass.Select
("SELECT Header, Picture, " +
"IFNULL((SELECT likesCount FROM " + Tables.LIKES + " WHERE Header = Article), 0) likesCount, " +
"IFNULL((SELECT discount FROM " + Tables.LIKES + " WHERE Header = Article), 0) discount, " +
"(SELECT COUNT(*) FROM " + Tables.READ_OF_ARTICLES + " WHERE Header = name_of_article) A" +
" FROM " + Tables.ARTICLES +
" WHERE (header like @STR OR category like @STR) AND `Author` = '" + login + "' " +
getKak(), dict);
int articleY = 50;
for (int artIndex = 0; artIndex < AuthorArticles.Count; artIndex += 5)
{
LinkLabel label1 = new LinkLabel();
label1.Location = new Point(0, articleY);
label1.Size = new Size(panel1.Width, 20);
label1.Text = AuthorArticles[AuthorArticles.Count - artIndex - 5].ToString();
label1.Dock = DockStyle.Top;
label1.Click += new System.EventHandler(ArticleClick);
panel1.Controls.Add(label1);
PictureBox image1 = new PictureBox();
image1.Location = new Point(0, articleY + 25);
image1.Size = new Size(panel1.Width, 150);
image1.Image = new Bitmap("defolt_statiy.jpg");
image1.SizeMode = PictureBoxSizeMode.StretchImage;
image1.Dock = DockStyle.Top;
panel1.Controls.Add(image1);
String[] chasti_stroki = AuthorArticles[AuthorArticles.Count - artIndex - 4].ToString().Split(new char[] { ' ', '/' });
try
{
image1.Image = new Bitmap(chasti_stroki[chasti_stroki.Length - 1]);
}
catch (Exception)
{
try
{
image1.Load(AuthorArticles[AuthorArticles.Count - artIndex - 4].ToString());
Uri uri = new Uri(AuthorArticles[AuthorArticles.Count - artIndex - 4].ToString());
client.DownloadFileAsync(uri, chasti_stroki[chasti_stroki.Length - 1]);
}
catch (Exception)
{
}
}
arts.Add(label1);
articleY += 180;
}
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
List <string> s = Advertising.GetRandom();
pictureBox1.LoadAsync(s[0]);
pictureBox1.Tag = s[1];
pictureBox2.SizeMode = PictureBoxSizeMode.StretchImage;
s = Advertising.GetRandom();
pictureBox2.LoadAsync(s[0]);
pictureBox2.Tag = s[1];
}
private void AuthorMainFormLoad(object sender, EventArgs e)
{
this.Font = Configs.USER_FONT;
this.ForeColor = Configs.USER_COLOR;
List <String> AuthorInfo = SQLClass.Select(
"SELECT Information_about_author, Articles, Pic FROM " + Tables.AUTHORS +
" WHERE `UserName` = '" + login + "'");
List <String> mesto = SQLClass.Select("SELECT COUNT(*) + 1 FROM (SELECT UserName, SUM(`Likes`) - Sum(DisLikes) F FROM "
+ Tables.AUTHORS + " GROUP BY UserName HAVING F > (SELECT SUM(`Likes`) - Sum(DisLikes) FROM " + Tables.AUTHORS +
" WHERE UserName = '******') ) T");
label4.Text = "Место автора " + mesto[0];
Button_Balance.Text = "Баланс: 0";
List <String> bal = SQLClass.Select("SELECT `Summa` FROM " + Tables.BALANCE + " WHERE `Author`= '" + login + "'");
if (bal.Count > 0)
{
Button_Balance.Text = "Баланс: " + bal[0];
}
for (int infoIndex = 0; infoIndex < AuthorInfo.Count; infoIndex += 3)
{
List <String> likes = SQLClass.Select(string.Format("SELECT SUM(`LikesCount`), SUM(`DisCount`) FROM `Likes` WHERE `Author` = '{0}'", login));
aboutAuthorLabel.Text = AuthorInfo[infoIndex].ToString() + string.Format(" Лайков: {0}, Дизлайков: {1}", likes[0], likes[1]);
String[] chasti_stroki = AuthorInfo[infoIndex + 2].ToString().Split(new char[] { ' ', '/' });
try
{
Avatar_author.Image = new Bitmap(chasti_stroki[chasti_stroki.Length - 1]);
}
catch (Exception)
{
try
{
Avatar_author.Load(AuthorInfo[infoIndex + 2].ToString());
Uri uri = new Uri(AuthorInfo[infoIndex + 2].ToString());
client.DownloadFileAsync(uri, chasti_stroki[chasti_stroki.Length - 1]);
}
catch (Exception)
{
Avatar_author.Image = new Bitmap("defolt_avtor.jpg");
}
}
Avatar_author.SizeMode = PictureBoxSizeMode.StretchImage;
}
List <String> AuthorArticles = SQLClass.Select("SELECT Header, Picture FROM " + Tables.ARTICLES +
" WHERE `Author` = '" + login + "'");
int articleY = 50;
for (int artIndex = 0; artIndex < AuthorArticles.Count; artIndex += 2)
{
LinkLabel label1 = new LinkLabel();
label1.Location = new Point(0, articleY);
label1.Size = new Size(panel1.Width, 20);
label1.Text = AuthorArticles[artIndex].ToString();
label1.Dock = DockStyle.Top;
label1.Click += new System.EventHandler(ArticleClick);
panel1.Controls.Add(label1);
PictureBox image1 = new PictureBox();
image1.Location = new Point(0, articleY + 25);
image1.Size = new Size(panel1.Width, 150);
image1.Image = new Bitmap("defolt_statiy.jpg");
image1.SizeMode = PictureBoxSizeMode.StretchImage;
image1.Dock = DockStyle.Top;
panel1.Controls.Add(image1);
String[] chasti_stroki = AuthorArticles[artIndex + 1].ToString().Split(new char[] { ' ', '/' });
try
{
image1.Image = new Bitmap(chasti_stroki[chasti_stroki.Length - 1]);
}
catch (Exception)
{
try
{
image1.Load(AuthorArticles[artIndex + 1].ToString());
Uri uri = new Uri(AuthorArticles[artIndex + 1].ToString());
client.DownloadFileAsync(uri, chasti_stroki[chasti_stroki.Length - 1]);
}
catch (Exception)
{
}
}
arts.Add(label1);
articleY += 180;
}
//FIXME!!! Show region
#region Advertising
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
List <string> s = Advertising.GetRandom();
pictureBox1.LoadAsync(s[0]);
pictureBox1.Tag = s[1];
pictureBox2.SizeMode = PictureBoxSizeMode.StretchImage;
s = Advertising.GetRandom();
pictureBox2.LoadAsync(s[0]);
pictureBox2.Tag = s[1];
#endregion
}
