private void signup_Click(object sender, EventArgs e) { SqlDb db = new SqlDb(); MySqlCommand command = new MySqlCommand("INSERT INTO `users`(`Username`,`Name`,`Password`,`Admin Id`) VALUES (@usn,@nam,@pass,@Adi)", db.getConnection()); command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = Username.Text; command.Parameters.Add("@nam", MySqlDbType.VarChar).Value = NameU.Text; command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = Password.Text; command.Parameters.Add("@Adi", MySqlDbType.VarChar).Value = AdiD.Text; db.openConnection(); if (!checkTextBoxesValues()) { if (Password.Text.Equals(PasswordConf.Text)) { if (checkUsername()) { MessageBox.Show("This Username Already Exists, Select A Different One", "Duplicate Username", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } else { if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Your Account Has Been Created", "Account Created", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Hide(); Form1 log = new Form1(); log.Show(); } else { MessageBox.Show("ERROR"); } } } else { MessageBox.Show("Wrong Confirmation Password", "Password Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } } else { MessageBox.Show("Enter Your Informations First", "Empty Data", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } db.closeConnection(); }
public Boolean checkUsername() { SqlDb db = new SqlDb(); String username = Username.Text; DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `username` = @usn", db.getConnection()); command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = username; adapter.SelectCommand = command; adapter.Fill(table); if (table.Rows.Count > 0) { return(true); } else { return(false); } }
private void button1_Click(object sender, EventArgs e) { SqlDb db = new SqlDb(); String Usname = textBoxUsername.Text; String Password = textBoxPassword.Text; String Admin = textBoxAdminID.Text; DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `Username`= @usn AND `Password` = @pass AND`Admin Id`= @Adi", db.getConnection()); command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = Usname; command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = Password; command.Parameters.Add("@Adi", MySqlDbType.VarChar).Value = Admin; adapter.SelectCommand = command; adapter.Fill(table); bool lib = radioButton1.Checked; bool stu = radioButton2.Checked; if (table.Rows.Count > 0) { this.Hide(); HomePage regis = new HomePage(); regis.Show(); } else { if (lib) { if (Usname.Trim().Equals("")) { MessageBox.Show("Enter Your Username To Login", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Password.Trim().Equals("")) { MessageBox.Show("Enter Your Password To Login", "Empty Password", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Admin.Trim().Equals("")) { MessageBox.Show("Enter Your Admin Id To Login", "Empty Password", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Wrong Username Or Password or Wrong Admin Id", "Wrong Data", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (stu) { MessageBox.Show("Wrong Username Or Password", "Wrong Data", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }