private void StatiyaForm1_Load(object sender, EventArgs e)
{
this.Font = Configs.USER_FONT;
this.ForeColor = Configs.USER_COLOR;
List <string> s = Advertising.GetRandom();
pictureBox2.SizeMode = PictureBoxSizeMode.StretchImage;
pictureBox2.LoadAsync(s[0]);
pictureBox2.Tag = s[1];
s = Advertising.GetRandom();
pictureBox3.SizeMode = PictureBoxSizeMode.StretchImage;
pictureBox3.LoadAsync(s[0]);
pictureBox3.Tag = s[1];
List <String> countRecords = SQLClass.Select(
"SELECT COUNT(*) FROM " + Tables.READ_OF_ARTICLES +
" WHERE `name_of_article` = '" + Maintext.Text + "'");
label1.Text = "Просмотров: " + countRecords[0];
SQLClass.Insert(
"INSERT INTO " + Tables.READ_OF_ARTICLES +
"(name_of_article, reader, dt)" +
"VALUES (" +
"'" + Maintext.Text + "'" +
", '" + Users.CURRENT_USER + "'" +
", DATE_FORMAT(NOW(), '%Y-%m-%d'))");
#region Деньги за показанную рекламу
int money = 2;
List <String> AuthorExist = SQLClass.Select("SELECT COUNT(*) FROM " + Tables.BALANCE +
" WHERE AUTHOR = '" + Authortext.Text + "'");
if (AuthorExist[0] != "0")
{
SQLClass.Update(" UPDATE " + Tables.BALANCE +
" SET Summa = Summa + " + money.ToString() +
" WHERE Author = '" + Authortext.Text + "'");
}
else
{
SQLClass.Insert(
"INSERT INTO " + Tables.BALANCE +
" (Summa, Author)" +
" VALUES (" +
money.ToString() + ", " +
"'" + Authortext.Text + "')");
}
#endregion
}
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 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 SUM(`LikesCount`) - SUM(`DisCount`) FROM " + Tables.LIKES +
" WHERE `Author` = '" + login + "'");
label4.Text = "Место автора " + mesto[0];
Button_Balance.Text = string.Format("Баланс: {0}", SQLClass.Select("SELECT `Summa` FROM " + Tables.BALANCE + " WHERE `Author`= '" + login + "'")[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
}
private void Form1_Load(object sender, EventArgs e)
{
arts.Clear();
Right_panel.Controls.Clear();
//Right_panel.Controls.Add(button_add_reklama);
//Right_panel.Controls.Add(button1);
// button_add_reklama.Visible = false;
lable_name_of_polzovatel.Text = Users.CURRENT_USER;
AdmButton.Visible = adm;
AutButton.Visible = aut;
if (lable_name_of_polzovatel.Text != "NONAME")
{
lable_name_of_polzovatel.Text = "Вы вошли как " + Users.CURRENT_USER;
Right_panel.Controls.Add(lable_name_of_polzovatel);
Right_panel.Controls.Add(tableLayoutPanel2);
button_add_reklama.Visible = true;
button1.Visible = true;
}
#region Обновление списка категорий
Right_panel.Controls.Add(label_cats_header);
Right_panel.Controls.Add(categories_linklabel);
List <String> catsList = SQLClass.Select("SELECT Name FROM " + Tables.CATEGORIES + " LIMIT 0, 7");
int catY = 210;
for (int artIndex = 0; artIndex < catsList.Count; artIndex++)
{
Label label1 = new Label();
label1.Location = new Point(0, catY);
label1.Size = new Size(100, 20);
label1.Text = catsList[artIndex].ToString();
label1.Click += new System.EventHandler(Author_Or_Category_CLick);
Right_panel.Controls.Add(label1);
catY += 28;
}
#endregion
#region Обновление списка авторов
Right_panel.Controls.Add(label_Author_header);
Right_panel.Controls.Add(label_author);
List <String> authorsList = SQLClass.Select("SELECT UserName FROM " + Tables.AUTHORS + " LIMIT 0, 3");
int authorsY = 75;
for (int artIndex = 0; artIndex < authorsList.Count; artIndex++)
{
Label label1 = new Label();
label1.Location = new Point(0, authorsY);
label1.Size = new Size(100, 20);
label1.Text = authorsList[artIndex].ToString();
label1.Click += new System.EventHandler(Author_Or_Category_CLick);
Right_panel.Controls.Add(label1);
authorsY += 25;
}
#endregion
#region Advertising
List <String> s = Advertising.GetRandom();
reclama.SizeMode = PictureBoxSizeMode.StretchImage;
reclama.LoadAsync(s[0]);
reclama.Tag = s[1];
s = Advertising.GetRandom();
reclama2.SizeMode = PictureBoxSizeMode.StretchImage;
reclama2.LoadAsync(s[0]);
reclama3.Tag = s[1];
s = Advertising.GetRandom();
reclama3.SizeMode = PictureBoxSizeMode.StretchImage;
reclama3.LoadAsync(s[0]);
reclama3.Tag = s[1];
#endregion
textBox_search.Text = "";
butto_search_Click(sender, e);
textBox_search.Text = "Поиск";
}