private void button1_Click(object sender, EventArgs e) { int Count = 0; String query = "select count(*) from UsersDB where Login = '******' and Password = '******';"; MySqlConnection conn = DB.GetDBConnection(); MySqlCommand cmDB = new MySqlCommand(query, conn); cmDB.CommandTimeout = 60; try { conn.Open(); Count = Convert.ToInt32(cmDB.ExecuteScalar()); conn.Close(); } catch (Exception ex) { MessageBox.Show("Это просто буква А, ничего подозрительного"); } if (Count > 0 && loginField.Text == "Admin" && passField.Text == "Admin") { AdminMenu win = new AdminMenu(); win.Show(); this.Hide(); } else { if (Count > 0 && loginField.Text == "Security" && passField.Text == "123Lock") { MainForm1 win = new MainForm1(); win.Show(); this.Hide(); } } }
private void buttonLogin_Click(object sender, EventArgs e) { String loginUser = loginField.Text; String passUser = passField.Text; DB db = new DB(); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `login` = @uL AND `pass` = @uP", DB.getConnection()); command.Parameters.Add("@uL", MySqlDbType.VarChar).Value = loginUser; command.Parameters.Add("@uP", MySqlDbType.VarChar).Value = passUser; adapter.SelectCommand = command; adapter.Fill(table); if (table.Rows.Count > 0) { this.Hide(); MainForm1 mainForm1 = new MainForm1(); mainForm1.Show(); } else { MessageBox.Show("No"); } }
private void backmain_Click(object sender, EventArgs e) { this.Hide(); MainForm1 mainForm1 = new MainForm1(); mainForm1.Show(); }
private void buttonaddstat_Click(object sender, EventArgs e) { if (author.Text == "Введите автора") { MessageBox.Show("Введите автора"); return; } if (name.Text == "Введите название") { MessageBox.Show("Введите название"); return; } if (tag.Text == "Введите тэги") { MessageBox.Show("Введите тэги"); return; } if (stat.Text == "Напишите статью") { MessageBox.Show("Напишите статью"); return; } if (modeS == "add") { string query = "insert into article(author, name, tag, stat) values('" + author.Text + "', '" + name.Text + "', '" + tag.Text + "', '" + stat.Text + "');"; MySqlConnection conn = DB.GetDBConnection(); MySqlCommand cmDB = new MySqlCommand(query, conn); cmDB.CommandTimeout = 60; try { conn.Open(); MySqlDataReader rd = cmDB.ExecuteReader(); conn.Close(); MessageBox.Show("Статья была создана."); this.Hide(); MainForm1 mainForm1 = new MainForm1(); mainForm1.Show(); } catch (Exception ex) { MessageBox.Show("Статья была не создана."); MessageBox.Show(ex.Message); } } if (modeS == "change") { string content = stat.Text.ToString(); string query = "update article set author ='" + author.Text + "', name='" + name.Text + "', tag='" + tag.Text + "', stat='" + stat.Text + "' where id = " + item.ToString() + ";"; MySqlConnection conn = DB.GetDBConnection(); MySqlCommand cmDB = new MySqlCommand(query, conn); cmDB.CommandTimeout = 60; try { conn.Open(); MySqlDataReader rd = cmDB.ExecuteReader(); conn.Close(); MessageBox.Show("Статья была изменена."); this.Hide(); MainForm1 mainForm1 = new MainForm1(); mainForm1.Show(); this.Close(); } catch (Exception ex) { MessageBox.Show("Статья не изменена."); MessageBox.Show(ex.Message); } } }
private void buttonaddstat_Click(object sender, EventArgs e) { if (author.Text == "Введите ФИО") { MessageBox.Show("Введите ФИО"); return; } if (name.Text == " ") { MessageBox.Show("Введите температуру"); return; } if (tag.Text == " ") { MessageBox.Show("Введите дату"); return; } if (stat.Text == " ") { MessageBox.Show("Введите статус"); return; } if (modeS == "add") { string query = "insert into People(FI,Temper, Data, id_Status) values('" + author.Text + "', '" + name.Text + "', '" + tag.Text + "', '" + stat.Text + "');"; MySqlConnection conn = DB.GetDBConnection(); MySqlCommand cmDB = new MySqlCommand(query, conn); cmDB.CommandTimeout = 60; try { conn.Open(); MySqlDataReader rd = cmDB.ExecuteReader(); conn.Close(); MessageBox.Show("Данные успешно добавлены."); this.Hide(); MainForm1 mainForm1 = new MainForm1(); mainForm1.Show(); } catch (Exception ex) { MessageBox.Show("Не удалось добавить данные."); MessageBox.Show(ex.Message); } } if (modeS == "change") { string content = stat.Text.ToString(); string query = "update People set FI ='" + author.Text + "', Temper='" + name.Text + "', Data='" + tag.Text + "', id_Status='" + stat.Text + "' where Id_People = " + item.ToString() + ";"; MySqlConnection conn = DB.GetDBConnection(); MySqlCommand cmDB = new MySqlCommand(query, conn); cmDB.CommandTimeout = 60; try { conn.Open(); MySqlDataReader rd = cmDB.ExecuteReader(); conn.Close(); MessageBox.Show("Данные успешно изменены."); this.Hide(); MainForm1 mainForm1 = new MainForm1(); mainForm1.Show(); this.Close(); } catch (Exception ex) { MessageBox.Show("Не удалось изменить данные."); MessageBox.Show(ex.Message); } } }