public static void pictureBoxLike_Clicking1(String Text, bool isLike) { List <String> textesAut = SQLClass.Select("SELECT Author, Category FROM " + Tables.ARTICLES + " WHERE `Header` = '" + Text + "'"); List <String> likes = SQLClass.Select("SELECT Article FROM " + Tables.LIKES + " WHERE Article = '" + Text + "'"); if (isLike) { if (likes.Count > 0) { SQLClass.Update("UPDATE " + Tables.LIKES + " SET LikesCount = LikesCount + 1" + " WHERE Article = '" + Text + "'"); } else { SQLClass.Insert( "INSERT INTO " + Tables.LIKES + "(Article, Author, Category, LikesCount, DisCount)" + " VALUES (" + "'" + Text + "'" + ", '" + textesAut[0] + "'" + ", '" + textesAut[1] + "'" + ",1" + ",0)"); } } else { SQLClass.Update("UPDATE " + Tables.LIKES + " SET LikesCount = LikesCount - 1" + " WHERE Article = '" + Text + "'"); } }
/// <summary> /// Кнопка добавления статьи /// </summary> /// <param name="sender"></param> /// <param name="e"></param> 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; } }
/// <summary> /// нопка отправки статьи на рассмотрение /// </summary> /// <param name="sender"></param> /// <param name="e"></param> 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(); }
/// <summary> /// Функция сохранения юзерконтрола на форму и базу. /// </summary> public static void SaveUserControl(object sender, EventArgs e) { UserControl pb = (UserControl)((ContextMenuStrip)((ToolStripMenuItem)sender).Owner).SourceControl; string FormName = pb.FindForm().Name; MessageBox.Show(pb.Location.X.ToString()); SQLClass.Insert("INSERT INTO `block`(`form`,`Parent`, `x`, `y`, `name`, Dock) VALUES ('" + FormName + "','" + pb.Parent.Name + "'," + pb.Location.X + ", " + pb.Location.Y + ",'" + pb.Name + "','" + pb.Dock + "')"); }
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 " + Tables.ARTICLES + " WHERE `Header` = '" + str + "'))"); } }
/// <summary> /// Добавление информации о блоке в БД /// </summary> public static void InsertBlockToDB(object sender, UserControl a1, string par) { Control c = ((ContextMenuStrip)((ToolStripMenuItem)sender).Owner).SourceControl; c.Controls.Add(a1); //Program.CONTROLY.Add(a1); SQLClass.Insert("INSERT INTO block(form,Parent,x,y,name,Params, Dock) VALUES ('" + c.FindForm().Name + "', '" + c.Name + "', '" + a1.Location.X + "','" + a1.Location.Y + "','" + a1.Name + "','" + par + "', '" + c.Dock + "')"); List <String> str = SQLClass.Select("SELECT MAX(id) FROM block"); a1.Tag = str[0]; }
public static void UpdateLabelDesignInDb(Control pb) { SQLClass.Delete("DELETE FROM " + Tables.UNIQUE + " WHERE type = 'Label'" + " AND name = '" + pb.Name + "' AND FormFrom = '" + pb.FindForm().Name + "'"); SQLClass.Insert("INSERT INTO " + Tables.UNIQUE + " (type, design, author, name, FormFrom) VALUES " + "('Label', " + "'ForeColor = " + ButtonUniqueForm.ColorToJSON(pb.ForeColor) + ", FontName = " + pb.Font.Name + ", FontSize = " + pb.Font.Size + ", Text = " + pb.Text + "', 'admin', '" + pb.Name + "', '" + pb.FindForm().Name + "')"); }
/// <summary> /// Обновление дизайна конкретной кнопки в БД /// </summary> public static void UpdateButtonDesignInDb(Button pb) { SQLClass.Delete("DELETE FROM " + Tables.UNIQUE + " WHERE type = 'Button'" + " AND name = '" + pb.Name + "' AND FormFrom = '" + pb.FindForm().Name + "'"); SQLClass.Insert("INSERT INTO " + Tables.UNIQUE + " (type, design, author, name, FormFrom) VALUES " + "('Button', " + "'Color = " + ColorToJSON(pb.BackColor) + ", Visible = " + pb.Visible + ", BackgroundImage = " + pb.BackgroundImage + ", Text = " + pb.Text + ", Dock = " + pb.Dock.ToString() + ", FlatStyle = " + pb.FlatStyle + "', 'admin', '" + pb.Name + "', '" + pb.FindForm().Name + "')"); }
public void pictureBoxLike_Clicking(object sender, EventArgs e) { if (isDisLike) { pictureBoxDislike_Click(sender, e); } isLike = !isLike; pictureBoxLike.Image = (isLike) ? Properties.Resources.Like2 : Properties.Resources.like; List <String> likes = SQLClass.Select("SELECT Article FROM " + Tables.LIKES + " WHERE Article = '" + Maintext.Text + "'"); if (isLike) { if (likes.Count > 0) { SQLClass.Update("UPDATE " + Tables.LIKES + " SET LikesCount = LikesCount + 1" + " WHERE Article = '" + Maintext.Text + "'"); } else { SQLClass.Insert( "INSERT INTO " + Tables.LIKES + "(Article, Author, Category, LikesCount, DisCount)" + " VALUES (" + "'" + Maintext.Text + "'" + ", '" + Authortext.Text + "'" + ", '" + Kategoriatext.Text + "'" + ",1" + ",0)"); } } else { SQLClass.Update("UPDATE " + Tables.LIKES + " SET LikesCount = LikesCount - 1" + " WHERE Article = '" + Maintext.Text + "'"); } GetStata(labelLike, labeldis, Maintext.Text); }
public static Dictionary <string, JObject> typeSerialize() { Dictionary <string, JObject> AllTypesData = new Dictionary <string, JObject>(); #region Button Dictionary <string, string> ButtonData = new Dictionary <string, string>(); if (DesignClass.BUTTON_BACKGROUND_IMG_ADRESS != null) { ButtonData.Add("BackgroundImage", DesignClass.BUTTON_BACKGROUND_IMG_ADRESS.ToString()); } //ButtonData.Add("BackgroundImageLayout", button1.BackgroundImageLayout.ToString()); if (DesignClass.BUTTON_TEXT_COLOR != null) { ButtonData.Add("ForeColor", ButtonUniqueForm.ColorToJSON(DesignClass.BUTTON_TEXT_COLOR));//DesignClass.BUTTON_TEXT_COLOR.ToString()); } if (DesignClass.BUTTON_FONT != null) { ButtonData.Add("Font", DesignClass.BUTTON_FONT.ToString()); } if (DesignClass.BUTTON_COLOR != null) { ButtonData.Add("Color", ButtonUniqueForm.ColorToJSON(DesignClass.BUTTON_COLOR));//.ToString()); } ButtonData.Add("ImageAlign", DesignClass.BUTTONIMAGE_ALLINE.ToString()); //.ToString()); ButtonData.Add("FlatStyle", Convert.ToString(DesignClass.FLAT_OF_BUTTON)); //.ToString()); #endregion AllTypesData.Add("button", JObject.FromObject(ButtonData)); foreach (string type in AllTypesData.Keys) { SQLClass.Delete("DELETE FROM " + Tables.DEFAULT + " WHERE type = '" + type + "'"); SQLClass.Insert(String.Format("INSERT INTO " + Tables.DEFAULT + "(type, design, author) VALUES ('{0}','{1}','{2}')", type, AllTypesData[type].ToString(), "test")); } return(AllTypesData); }
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 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 Author = '" + textBox_login.Text + "' WHERE Author = '" + login + "'"); SQLClass.Update("UPDATE " + Tables.LIKES + " SET Author = '" + textBox_login.Text + "' WHERE Author = '" + login + "'"); } SQLClass.Update("UPDATE " + Tables.AUTHORS + " SET UserName = '******', Pic = '" + textBox_pic.Text + "', Information_about_author = '" + textBox_about_me.Text + "' WHERE UserName = '******'"); } Close(); }
private void button1_Click(object sender, EventArgs e) { SQLClass.Insert("INSERT INTO " + Tables.COLLECTION + " (`id_art`, `Coll_text`) VALUES ('" + textBox1.Text + "', " + "'" + New.Text + "')"); }