private void pictureBox2_Click(object sender, EventArgs e)
 {
     if (labelUser.Text == "Admin")
     {
         this.Hide();
         Dashboard dashboard = new Dashboard();
         dashboard.Show();
     }
     else if (labelUser.Text == "Sailfish Team Leader")
     {
         this.Hide();
         Sailfish_Dashboard sailfishDash = new Sailfish_Dashboard();
         sailfishDash.Show();
     }
     else if (labelUser.Text == "Grenfin Team Leader")
     {
         this.Hide();
         Grenfin_Dashboard grenfinDash = new Grenfin_Dashboard();
         grenfinDash.Show();
     }
     else if (labelUser.Text == "Dolphin Team Leader")
     {
         this.Hide();
         Dolphin_Dashboard dolphinDash = new Dolphin_Dashboard();
         dolphinDash.Show();
     }
     else if (labelUser.Text == "Grenada Team Leader")
     {
         this.Hide();
         Grenada_Team_Dashboard grenadaDash = new Grenada_Team_Dashboard();
         grenadaDash.Show();
     }
 }
 private void pictureBox2_Click(object sender, EventArgs e)
 {
     if (labelUser.Text == "Sailfish Team Leader")
     {
         this.Hide();
         Grenfin_Dashboard grenfinDash = new Grenfin_Dashboard();
         grenfinDash.Show();
     }
 }
 private void pictureBox2_Click(object sender, EventArgs e)
 {
     if (labelUser.Text == "Admin")
     {
         this.Hide();
         Dashboard dashboard = new Dashboard();
         dashboard.Show();
     }
     else if (labelUser.Text == "Grenfin Team Leader")
     {
         this.Hide();
         Grenfin_Dashboard grenfinDash = new Grenfin_Dashboard();
         grenfinDash.Show();
     }
 }
        private void button1_Click(object sender, EventArgs e)
        {
            MY_DB db = new MY_DB();

            String username     = textBoxUsername.Text;
            String password     = textBoxPassword.Text;
            String userType     = comboBox1.Text;
            string cmbItemValue = comboBox1.SelectedItem.ToString();

            MySqlDataAdapter adapter = new MySqlDataAdapter();
            DataTable        table   = new DataTable();

            MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `Username`=@usn AND `Password`=@pass AND `User Type`=@ustype", db.getConnection());

            command.Parameters.Add("@usn", MySqlDbType.VarChar).Value    = textBoxUsername.Text;
            command.Parameters.Add("@pass", MySqlDbType.VarChar).Value   = textBoxPassword.Text;
            command.Parameters.Add("@ustype", MySqlDbType.VarChar).Value = comboBox1.Text;


            //Opening the cnnection
            db.openConnection();

            adapter.SelectCommand = command;

            adapter.Fill(table);


            //Checking if the users exists
            if (table.Rows.Count > 0)
            {
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    if (table.Rows[i]["User Type"].ToString() == cmbItemValue)
                    {
                        MessageBox.Show("You Are Logged in as " + table.Rows[i][2]);
                        if (comboBox1.SelectedIndex == 0)
                        {
                            GLOBAL.username = table.Rows[0]["Username"].ToString();
                            GLOBAL.userType = table.Rows[0]["User Type"].ToString();
                            this.Hide();
                            Dashboard dashboard = new Dashboard();
                            dashboard.Show();
                        }
                        else if (comboBox1.SelectedIndex == 1)
                        {
                            GLOBAL.username = table.Rows[0]["Username"].ToString();
                            GLOBAL.userType = table.Rows[0]["User Type"].ToString();
                            this.Hide();
                            Sailfish_Dashboard sailfishDash = new Sailfish_Dashboard();
                            sailfishDash.Show();
                        }
                        else if (comboBox1.SelectedIndex == 2)
                        {
                            GLOBAL.username = table.Rows[0]["Username"].ToString();
                            GLOBAL.userType = table.Rows[0]["User Type"].ToString();
                            this.Hide();
                            Grenfin_Dashboard grenfinDash = new Grenfin_Dashboard();
                            grenfinDash.Show();
                        }
                        else if (comboBox1.SelectedIndex == 3)
                        {
                            GLOBAL.username = table.Rows[0]["Username"].ToString();
                            GLOBAL.userType = table.Rows[0]["User Type"].ToString();
                            this.Hide();
                            Dolphin_Dashboard dolphinDash = new Dolphin_Dashboard();
                            dolphinDash.Show();
                        }
                        else if (comboBox1.SelectedIndex == 4)
                        {
                            GLOBAL.username = table.Rows[0]["Username"].ToString();
                            GLOBAL.userType = table.Rows[0]["User Type"].ToString();
                            this.Hide();
                            Grenada_Team_Dashboard grenTeamDash = new Grenada_Team_Dashboard();
                            grenTeamDash.Show();
                        }
                    }
                }
            }

            else
            {
                if (username.Trim().Equals(""))
                {
                    MessageBox.Show("Please Enter Your Username to Login!", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else if (userType.Trim().Equals(""))
                {
                    MessageBox.Show("Please Check The User Type!", "Empty User Type", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else if (password.Trim().Equals(""))
                {
                    MessageBox.Show("Please Check Your Password!", "Empty Password", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    MessageBox.Show("Please Check Username OR Password!", "Wrong Data", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }