Example #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            username = textBox1.Text;
            CONNECT          conn    = new CONNECT();
            DataTable        table   = new DataTable();
            MySqlDataAdapter adapter = new MySqlDataAdapter();
            MySqlCommand     command = new MySqlCommand();
            String           query   = "SELECT * FROM `user` WHERE `username`=@usn AND `password`=@pass AND `role`=@role";

            command.CommandText = query;
            command.Connection  = conn.getConnection();

            command.Parameters.Add("@usn", MySqlDbType.VarChar).Value  = textBox1.Text;
            command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = textBox2.Text;
            try
            {
                command.Parameters.Add("@role", MySqlDbType.VarChar).Value = comboBox1.SelectedItem.ToString();
            }
            catch { }

            adapter.SelectCommand = command;
            adapter.Fill(table);

            //if the username and the password exist or match
            if (table.Rows.Count > 0)
            {
                MessageBox.Show("You are logged in as " + comboBox1.SelectedItem.ToString());
                if (comboBox1.SelectedIndex == 0)
                {
                    this.Hide();
                    Admin admin = new Admin();
                    admin.Show();
                }
                else if (comboBox1.SelectedIndex == 1)
                {
                    this.Hide();
                    Staff staff = new Staff();
                    staff.Show();
                }
                else
                {
                    this.Hide();
                    Trainer trainer = new Trainer();
                    trainer.Show();
                }
            }
            else
            {
                if (textBox1.Text.Trim().Equals(""))
                {
                    MessageBox.Show("Please enter Username!", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else if (textBox2.Text.Trim().Equals(""))
                {
                    MessageBox.Show("Please enter Password!", "Empty Password", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else if (comboBox1.SelectedItem == null)
                {
                    MessageBox.Show("Please select a role to login", "Empty Role", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    MessageBox.Show("No username or password matches for this role", "Login Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
Example #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            username = textBox1.Text;
            CONNECT          conn    = new CONNECT();
            DataTable        table   = new DataTable();
            MySqlDataAdapter adapter = new MySqlDataAdapter();
            MySqlCommand     command = new MySqlCommand();
            String           query   = "SELECT * FROM `user` WHERE `username`=@usn AND `password`=@pass";

            command.CommandText = query;
            command.Connection  = conn.getConnection();

            command.Parameters.Add("@usn", MySqlDbType.VarChar).Value  = textBox1.Text;
            command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = textBox2.Text;

            adapter.SelectCommand = command;
            adapter.Fill(table);

            //if the username and the password exist or match
            if (table.Rows.Count > 0)
            {
                foreach (DataRow dr in table.Rows)
                {
                    if (dr["role"].ToString() == "Admin")
                    {
                        MessageBox.Show("You are logged in as Admin");
                        this.Hide();
                        Admin adminPanel = new Admin();
                        adminPanel.Show();
                    }
                    else if (dr["role"].ToString() == "Staff")
                    {
                        MessageBox.Show("You are logged in as Staff");
                        this.Hide();
                        Staff staffPanel = new Staff();
                        staffPanel.Show();
                    }
                    else if (dr["role"].ToString() == "Trainer")
                    {
                        MessageBox.Show("You are logged in as Trainer");
                        this.Hide();
                        Trainer trainerPanel = new Trainer();
                        trainerPanel.Show();
                    }
                    else
                    {
                        MessageBox.Show("This username or password doesnt exists!", "Wrong username or password", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
            }

            /*
             * MessageBox.Show("You are logged in as " + comboBox1.SelectedItem.ToString());
             * if (comboBox1.SelectedIndex == 0)
             * {
             *  this.Hide();
             *  Admin admin = new Admin();
             *  admin.Show();
             * }
             * else if (comboBox1.SelectedIndex == 1)
             * {
             *  this.Hide();
             *  Staff staff = new Staff();
             *  staff.Show();
             * }
             * else
             * {
             *  this.Hide();
             *  Trainer trainer = new Trainer();
             *  trainer.Show();
             * }*/
            else
            {
                if (textBox1.Text.Trim().Equals(""))
                {
                    MessageBox.Show("Please enter Username!", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else if (textBox2.Text.Trim().Equals(""))
                {
                    MessageBox.Show("Please enter Password!", "Empty Password", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    MessageBox.Show("This username or password doesnt exists!", "Wrong username or password", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }