private bool login() { string query = "Select * from userinfo where AccountNumber=@AccountNumber and Pin=@Pin"; if (this.dbConnect.OpenConnection() == true) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, dbConnect.connection); cmd.Parameters.AddWithValue("@AccountNumber", txtAccountNumber.Text); Class1.AccountNumber = txtAccountNumber.Text; cmd.Parameters.AddWithValue("@Pin", txtPin.Text); cmd.ExecuteNonQuery(); MySqlDataReader login = cmd.ExecuteReader(); if (login.Read()) { dbConnect.CloseConnection(); return(true); } else { dbConnect.CloseConnection(); return(false); } } else { return(true); } }
private bool login() { string query = "Select * from employee where Username=@Username and Password=@Password"; if (this.dbConnect.OpenConnection() == true) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, dbConnect.connection); cmd.Parameters.AddWithValue("@Username", txtUsername.Text); cmd.Parameters.AddWithValue("@Password", txtPassword.Text); cmd.ExecuteNonQuery(); MySqlDataReader login = cmd.ExecuteReader(); if (login.Read()) { dbConnect.CloseConnection(); return(true); } else { dbConnect.CloseConnection(); return(false); } } else { return(true); } }