private void button3_Click(object sender, EventArgs e) { if (textBox2.Text == "") { MessageBox.Show("Введите старый пароль"); } else if (textBox3.Text == "") { MessageBox.Show("Введите новый пароль"); } if (User_info.password_user == textBox2.Text) { connect DB = new connect(); string password = textBox3.Text; MySqlCommand command = new MySqlCommand("UPDATE `user_info` SET `password`=@password WHERE `id_user`=@id_user ", DB.getConnection()); command.Parameters.Add("@id_user", MySqlDbType.String).Value = User_info.id_user; command.Parameters.Add("@password", MySqlDbType.String).Value = password; DB.openConnection(); command.Prepare(); command.ExecuteNonQuery(); DB.closeConnection(); MessageBox.Show("Вы успешно именили пароль"); } else { MessageBox.Show("Неверный пароль"); } }
private void button2_Click(object sender, EventArgs e) { if (textBox1.Text != "") { connect DB = new connect(); var link = textBox1.Text; MySqlCommand command = new MySqlCommand("UPDATE `user_info` SET `reference`=@reference WHERE `id_user`=@id_user ", DB.getConnection()); command.Parameters.Add("@id_user", MySqlDbType.String).Value = User_info.id_user; command.Parameters.Add("@reference", MySqlDbType.VarChar).Value = link; DB.openConnection(); command.Prepare(); command.ExecuteNonQuery(); DB.closeConnection(); MessageBox.Show("Вы успешно именили SteamLink"); } else { MessageBox.Show("Введите данные "); } }
private void CheckAll_CheckedChanged(object sender, EventArgs e) { dataGridView1.Rows.Clear(); connect DB = new connect(); MySqlCommand command = new MySqlCommand("SELECT `login`,`role`,`reference` FROM `user_info` WHERE `id_user`!=@id_user", DB.getConnection()); command.Parameters.Add("@id_user", MySqlDbType.String).Value = User_info.id_user; DB.openConnection(); MySqlDataReader reader = command.ExecuteReader(); List <string[]> data = new List <string[]>(); while (reader.Read()) { data.Add(new string[3]); data[data.Count - 1][0] = reader[0].ToString(); data[data.Count - 1][1] = reader[1].ToString(); data[data.Count - 1][2] = reader[2].ToString(); } reader.Close(); DB.closeConnection(); foreach (string[] s in data) { dataGridView1.Rows.Add(s); } }
private void Check(string role) { connect DB = new connect(); MySqlCommand command = new MySqlCommand("UPDATE `user_info` SET `role`=@role WHERE `id_user`=@id_user ", DB.getConnection()); command.Parameters.Add("@id_user", MySqlDbType.String).Value = User_info.id_user; command.Parameters.Add("@role", MySqlDbType.String).Value = role; DB.openConnection(); command.Prepare(); command.ExecuteNonQuery(); DB.closeConnection(); }
public void btnLogIn_Click(object sender, EventArgs e) { connect DB = new connect(); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB.openConnection(); MySqlCommand command = new MySqlCommand("SELECT `id_user`,`password` FROM `user_info` WHERE `login`=@login AND `password`=@password ", DB.getConnection()); command.Parameters.Add("@login", MySqlDbType.VarChar).Value = inputLogin1.Text; command.Parameters.Add("@password", MySqlDbType.VarChar).Value = inputPassword1.Text; MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { User_info.id_user = String.Format("{0}", reader[0]); User_info.password_user = String.Format("{0}", reader[1]); } DB.closeConnection(); adapter.SelectCommand = command; adapter.Fill(table); if (table.Rows.Count > 0) { this.Hide(); ShowUsr Main = new ShowUsr(); Main.Show(); } else { MessageBox.Show("Неверные данные"); } }
private void Lk_Load(object sender, EventArgs e) { connect DB = new connect(); MySqlCommand command = new MySqlCommand("SELECT `login`,`role` FROM `user_info` WHERE `id_user`=@id_user ", DB.getConnection()); command.Parameters.Add("@id_user", MySqlDbType.String).Value = User_info.id_user; DB.openConnection(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { label7.Text = reader[0].ToString(); label8.Text = reader[1].ToString(); } reader.Close(); DB.closeConnection(); }
private void btnSignUp_Click(object sender, EventArgs e) { if ((inputLogin.Text == "") || (InputLink.Text == "") || (InputPassword.Text == "")) { MessageBox.Show("Введите данные"); return; } if (radioButton1.Checked == false && radioButton2.Checked == false && radioButton3.Checked == false && radioButton4.Checked == false && radioButton5.Checked == false) { MessageBox.Show("Выберите роль"); return; } if (UserCheck() == true) { return; } var role = ""; if (radioButton1.Checked) { role = "Carry"; } if (radioButton2.Checked) { role = "Mid"; } if (radioButton3.Checked) { role = "Offline"; } if (radioButton4.Checked) { role = "Support"; } if (radioButton5.Checked) { role = "Hard Support"; } connect DB = new connect(); MySqlCommand command = new MySqlCommand("INSERT INTO `user_info`(`login`, `password`,`reference`,`role`) VALUES (@login,@password,@reference,@role)", DB.getConnection()); command.Parameters.Add("@login", MySqlDbType.VarChar).Value = inputLogin.Text; command.Parameters.Add("@password", MySqlDbType.VarChar).Value = InputPassword.Text; command.Parameters.Add("@reference", MySqlDbType.VarChar).Value = InputLink.Text; command.Parameters.AddWithValue("@role", role); DB.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Аккаунт успешно создан"); } else { MessageBox.Show("Аккаунт не создан"); } DB.closeConnection(); }