private void button1_Click(object sender, EventArgs e)
{
if (ne_povtor == textBox_Name.Text)
{
MessageBox.Show("Скоре всего вы пытаетесь опубликовать ещё раз");
}
else
{
List <String> ids = SQLClass.Select("SELECT MAX(Artic_ID + 1) FROM " + Tables.ARTICLES);
id = ids[0];
SQLClass.Insert("INSERT INTO " + Tables.ARTICLES +
"(Header, Text, Author, Picture, Artic_ID, Category, new)" +
" VALUES ('" + textBox_Name.Text + "'," +
"'" + textBox_txtStat.Text + "'," +
"'" + avtor1 + "'," +
"'" + textBox_ssulka.Text + "'," +
"" + id + "," +
"'" + comboBox_kategorii.Text + "'," +
" 1)");
SQLClass.Update("UPDATE " + Tables.AUTHORS +
" SET Articles = Articles + 1 WHERE UserName = '******'");
ne_povtor = textBox_Name.Text;
}
}
private void button_send_Click(object sender, EventArgs e)
{
if (checkBox_agree.Checked && checkBox_agree2.Checked)
{
MySqlCommand Dcmd = new MySqlCommand("SELECT MAX(id+1) FROM Advertisment", SQLClass.CONN);
MySqlDataReader Drdr = Dcmd.ExecuteReader();
String NewAdvId = "";
while (Drdr.Read())
{
NewAdvId = Drdr[0].ToString();
}
Drdr.Close();
SQLClass.Insert("INSERT INTO " + Tables.ADVERTISMENT +
"(Text, Pic, Date_From, Data_to, id, new)" +
" VALUES (" +
"'" + text_na_reklame.Text + "'" +
", '" + textBox_adress.Text + "'" +
", '13.10.2018', '20.10.2018', '" + NewAdvId + "', '1')");
foreach (String item in checkedListBox1.CheckedItems)
{
SQLClass.Insert("INSERT INTO " + Tables.PROMO_CATEGORIES_LINK +
"(id_promo, category, money)" +
" VALUES (" + NewAdvId + ",'" + item + "', 1)");
}
}
MessageBox.Show("Ваша реклама отправлена на рассмотрение");
this.Close();
}
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 textBox_name_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
SQLClass.Insert("INSERT INTO " + Tables.CATEGORIES +
"(`Name`, `Picture`, `Coteg_ID`)" +
" VALUES (\"" + textBox_name.Text + "\", \"a\", 0)");
update();
}
}
private void checkedListBox1_ItemCheck(object sender, ItemCheckEventArgs e)
{
SQLClass.Delete("DELETE FROM " + Tables.COLLECTION + " WHERE Coll_Text = '" + comboBox1.Text + "'");
for (int index = 0; index < checkedListBox1.CheckedItems.Count; index++)
{
String str = checkedListBox1.CheckedItems[index].ToString();
SQLClass.Insert("INSERT INTO " + Tables.COLLECTION + "(Coll_Text, id_art) VALUES ('" + comboBox1.Text + "'," +
"(SELECT artic_id FROM `Articles1` WHERE `Header` = '" + str + "'))");
}
}
private void pictureBox1_Click(object sender, EventArgs e)
{
isLike = !isLike;
pictureBox1.Image = (isLike) ?
Properties.Resources.Like2 :
Properties.Resources.like;
List <String> likes = SQLClass.Select("SELECT Article FROM " + Tables.LIKES + " WHERE Article = '" + name.Text + "'");
if (isLike)
{
if (likes.Count > 0)
{
SQLClass.Update("UPDATE " + Tables.LIKES +
" SET LikesCount = LikesCount + 1" +
" WHERE Article = '" + name.Text + "'");
}
else
{
SQLClass.Insert(
"INSERT INTO " + Tables.LIKES +
"(Article, Author, Category, LikesCount, DisCount)" +
" VALUES (" +
"'" + name.Text + "'" +
", '" + label2.Text + "'" +
", '" + kategoriy.Text + "'" +
",1" +
",0)");
}
}
else
{
SQLClass.Update("UPDATE " + Tables.LIKES +
" SET LikesCount = LikesCount - 1" +
" WHERE Article = '" + name.Text + "'");
}
GetStata(label3, label4, name.Text);
}
private void pictureBoxDislike_Click(object sender, EventArgs e)
{
isDisLike = !isDisLike;
pictureBoxDislike.Image = (isDisLike) ?
Properties.Resources.DisLike2 :
Properties.Resources.Dislike;
List <String> dislikes = SQLClass.Select("SELECT Article FROM " + Tables.LIKES + " WHERE Article = '" + Maintext.Text + "'");
if (isDisLike)
{
if (dislikes.Count > 0)
{
SQLClass.Update("UPDATE " + Tables.LIKES +
" SET DisCount = DisCount + 1" +
" WHERE Article = '" + Maintext.Text + "'");
}
else
{
SQLClass.Insert(
"INSERT INTO " + Tables.LIKES +
"(Article, Author, Category, LikesCount, DisCount)" +
" VALUES (" +
"'" + Maintext.Text + "'" +
", '" + Authortext.Text + "'" +
", '" + Kategoriatext.Text + "'" +
",0" +
",1)");
}
}
else
{
SQLClass.Update("UPDATE " + Tables.LIKES +
" SET DisCount = DisCount - 1" +
" WHERE Article = '" + Maintext.Text + "'");
}
GetStata(labelLike, labeldis, Maintext.Text);
}
private void button1_Click(object sender, EventArgs e)
{
SQLClass.Insert("INSERT INTO `Colection` (`id_art`, `Coll_text`) VALUES ('" + textBox1.Text + "', " + "'" + New.Text + "')");
}
private void button1_Click(object sender, EventArgs e)
{
if (!ob)
{
#region Добавляем пользователя
List <String> byl = SQLClass.Select(
"SELECT COUNT(*) FROM " + Tables.POLZOVATELI + " WHERE Login='******'");
bool userBylUzhe = (byl[0].ToString() != "0");
if (userBylUzhe)
{
MessageBox.Show("Ты был уже. Регистрируйся заново");
return;
}
SQLClass.Insert("INSERT INTO " + Tables.POLZOVATELI +
"(`Login`, `Parol`, `ban`, `aboutme`, admin)" +
" VALUES ('" + textBox_login.Text + "'," +
"'" + textBox_password.Text + "'," +
"0" + ",'" + textBox_about_me.Text + "', 0)");
#endregion
if (checkBox_I_author.Checked == true)
{
#region Добавляем автора
List <String> isAdminData = SQLClass.Select(
"SELECT COUNT(*) FROM " + Tables.AUTHORS + " WHERE `UserName`=\"" + textBox_login.Text +
"\"");
bool BylUzhe = (isAdminData[0].ToString() != "0");
if (BylUzhe)
{
MessageBox.Show("Ты был уже. Регистрируйся заново");
return;
}
SQLClass.Insert("INSERT INTO " + Tables.AUTHORS +
"(UserName, Information_about_author, Pic) " +
"VALUES ('" + textBox_login.Text + "','" +
textBox_about_me.Text + "', '" +
textBox_pic + "')");
#endregion
}
}
else
{
if (infoObAvtore[0] != textBox_login.Text)
{
List <String> isAdminData = SQLClass.Select(
"SELECT COUNT(*) FROM " + Tables.AUTHORS + " WHERE `UserName`=\"" + textBox_login.Text +
"\"");
bool BylUzhe = (isAdminData[0].ToString() != "0");
if (BylUzhe)
{
MessageBox.Show("Ты вообще не оригинальный");
return;
}
isAdminData = SQLClass.Select(
"SELECT COUNT(*) FROM " + Tables.AUTHORS + " WHERE `UserName`=\"" + textBox_login.Text +
"\"");
BylUzhe = (isAdminData[0].ToString() != "0");
if (BylUzhe)
{
MessageBox.Show("Такой пользователь уже есть");
return;
}
SQLClass.Update("UPDATE " + Tables.ARTICLES +
" SET Author = '" + textBox_login.Text +
"' WHERE Author = '" + login + "'");
SQLClass.Update("UPDATE " + Tables.POLZOVATELI +
" SET Login = '******' WHERE Login = '******'");
SQLClass.Update("UPDATE " + Tables.BALANCE +
" SET Login = '******' WHERE Login = '******'");
SQLClass.Update("UPDATE " + Tables.LIKES +
" SET Login = '******' WHERE Login = '******'");
}
SQLClass.Update("UPDATE " + Tables.AUTHORS +
" SET UserName = '******', Pic = '" + textBox_pic.Text +
"', Information_about_author = '" + textBox_about_me.Text +
"' WHERE UserName = '******'");
}
Close();
}