示例#1
0
        private void pictureBox2_Click_1(object sender, EventArgs e)
        {
            if (this._permi != 1)
            {
                MessageBox.Show("Access Denied");
                return;
            }
            UserForm frm = new UserForm(_permi);

            frm.Show();
        }
示例#2
0
        MySqlCommand command; // Used to launch a command to database

        // Event handler for button click
        private void button1_Click(object sender, EventArgs e)
        {
            // Check if the text boxes have any text
            if (string.IsNullOrEmpty(textBox1.Text))
            {
                MessageBox.Show("You have to complete the username field!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Stop);
                textBox1.Focus();
            }
            else if (string.IsNullOrEmpty(textBox2.Text))
            {
                MessageBox.Show("You have to complete the password field!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Stop);
                textBox2.Focus();
            }

            string connectionString = "Server = 127.0.0.1; Port = 3306; Database = db_admin; Uid = root; Pwd=; ";                         // Details for connection
            //string connectionString = "Server = 192.168.1.113; Port = 3306; Database = db_A030; Uid = user_A030; Pwd = pass_A030";
            string querry = "SELECT userType FROM users WHERE userName = '******' AND userPass = '******'"; // The querry for the database

            connection = new MySqlConnection(connectionString);                                                                           // Create a connection with the database
            command    = new MySqlCommand(querry, connection);                                                                            // Create a command for the database

            connection.Open();                                                                                                            // Connect to the database
            string userType = command.ExecuteScalar() as string;                                                                          // Execute the command and return the result as a string

            connection.Close();                                                                                                           // Close the connection to the database

            // Check if any results have been returned. If there is no result, return an error to the user
            if (string.IsNullOrEmpty(userType))
            {
                MessageBox.Show("Wrong username or password!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                textBox1.Text = "";
                textBox2.Text = "";
            }
            // If there is a result, check if the user is an administrator or an user based on what the database returned and
            // open the form for the administrator or the user
            else if (userType.Equals("A"))
            {
                AdminForm f = new AdminForm();
                f.Show();
                this.Close();
            }
            else if (userType.Equals("U"))
            {
                UserForm f = new UserForm();
                f.Show();
                this.Close();
            }

            /*if (textBox1.Text == "")
             * {
             *  MessageBox.Show("You have to complete the username field!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Stop);
             *  textBox1.Focus();
             * }
             * else if (textBox2.Text == "")
             * {
             *  MessageBox.Show("You have to complete the password field!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Stop);
             *  textBox2.Focus();
             * }
             * else if (textBox1.Text == "admin")
             * {
             *  AdminForm f = new AdminForm();
             *  f.Show();
             *  this.Close();
             * }
             * else
             * {
             *  UserForm f = new UserForm();
             *  f.Show();
             *  this.Close();
             * }*/
        }
        // Event handler for button click
        private void button1_Click(object sender, EventArgs e)
        {
            // Check if the text boxes have any text
            if(string.IsNullOrEmpty(textBox1.Text))
            {
                MessageBox.Show("You have to complete the username field!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Stop);
                textBox1.Focus();
            }
            else if(string.IsNullOrEmpty(textBox2.Text))
            {
                MessageBox.Show("You have to complete the password field!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Stop);
                textBox2.Focus();
            }

            string connectionString = "Server = 127.0.0.1; Port = 3306; Database = db_admin; Uid = root; Pwd=; "; // Details for connection
            //string connectionString = "Server = 192.168.1.113; Port = 3306; Database = db_A030; Uid = user_A030; Pwd = pass_A030";
            string querry = "SELECT userType FROM users WHERE userName = '******' AND userPass = '******'"; // The querry for the database
            connection = new MySqlConnection(connectionString); // Create a connection with the database
            command = new MySqlCommand(querry, connection); // Create a command for the database

            connection.Open(); // Connect to the database
            string userType = command.ExecuteScalar() as string; // Execute the command and return the result as a string
            connection.Close(); // Close the connection to the database

            // Check if any results have been returned. If there is no result, return an error to the user
            if (string.IsNullOrEmpty(userType))
            {
                MessageBox.Show("Wrong username or password!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                textBox1.Text = "";
                textBox2.Text = "";
            }
            // If there is a result, check if the user is an administrator or an user based on what the database returned and
            // open the form for the administrator or the user
            else if (userType.Equals("A"))
            {
                AdminForm f = new AdminForm();
                f.Show();
                this.Close();
            }
            else if (userType.Equals("U"))
            {
                UserForm f = new UserForm();
                f.Show();
                this.Close();
            }

            /*if (textBox1.Text == "")
            {
                MessageBox.Show("You have to complete the username field!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Stop);
                textBox1.Focus();
            }
            else if (textBox2.Text == "")
            {
                MessageBox.Show("You have to complete the password field!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Stop);
                textBox2.Focus();
            }
            else if (textBox1.Text == "admin")
            {
                AdminForm f = new AdminForm();
                f.Show();
                this.Close();
            }
            else
            {
                UserForm f = new UserForm();
                f.Show();
                this.Close();
            }*/
        }