private void buttonAdminLogin_Submit_Click(object sender, EventArgs e) { DB db = new DB(); String username = textUsername.Text; String password = textPassword.Text; DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("SELECT * FROM `admin_data` WHERE `username` = @usn and `password` = @pass", db.getConnect()); command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = username; command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = password; adapter.SelectCommand = command; adapter.Fill(table); if (table.Rows.Count > 0) { this.Hide(); AdminDashboard adminDashboard = new AdminDashboard(); adminDashboard.ShowDialog(); this.Close(); } else { MessageBox.Show("Please check your username or password", "Invalid Input"); } }
private void buttonBack_Click(object sender, EventArgs e) { this.Hide(); AdminDashboard adminDashboard = new AdminDashboard(); adminDashboard.ShowDialog(); this.Close(); }
private void buttonCreate_Click(object sender, EventArgs e) { // add new user DB db = new DB(); MySqlCommand command = new MySqlCommand("INSERT INTO `user_data`(`student_no`, `name`, `course`, `address`, `phone_no`, `username`, `password`) VALUES (@student_no, @name, @course, @address, @phone_no, @username, @password)", db.getConnect()); command.Parameters.Add("@student_no", MySqlDbType.VarChar).Value = textBox1.Text; command.Parameters.Add("@name", MySqlDbType.VarChar).Value = textBox2.Text; command.Parameters.Add("@course", MySqlDbType.VarChar).Value = textBox3.Text; command.Parameters.Add("@address", MySqlDbType.VarChar).Value = textBox4.Text; command.Parameters.Add("@phone_no", MySqlDbType.Int16).Value = textBox5.Text; command.Parameters.Add("@username", MySqlDbType.VarChar).Value = textBox6.Text; command.Parameters.Add("@password", MySqlDbType.VarChar).Value = textBox7.Text; // open connection db.openConnection(); //execute query if (command.ExecuteNonQuery() > 0) { MessageBox.Show("Account Created"); this.Hide(); AdminDashboard adminDashboard = new AdminDashboard(); adminDashboard.ShowDialog(); this.Close(); } else { MessageBox.Show("Error"); } //close connection db.closeConnection(); }