Ejemplo n.º 1
0
        private void button2_Click(object sender, EventArgs e)
        {
            Sportsman frm = new Sportsman();

            frm.Show();
            this.Hide();
        }
Ejemplo n.º 2
0
        private void button1_Click(object sender, EventArgs e)
        {
            try {
                userID       = id.Text;
                userPassword = password.Text;


                MySqlCommand cmd = new MySqlCommand("select id,isAdmin  from myfitsecret.entrance where id = @ID and password = @Password", con);

                cmd.Parameters.AddWithValue("@ID", id.Text);
                cmd.Parameters.AddWithValue("@Password", password.Text);

                cmd.Connection.Open();

                MySqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);

                if (rd.HasRows)       // if entered username and password have  data
                {
                    while (rd.Read()) // if reader can read
                    {
                        int id = int.Parse(rd["id"].ToString());
                        if (rd["isAdmin"].ToString() == "1") // Truee for admin
                        {
                            // if it is true open form 2
                            Admin  admin = new Admin();
                            string time  = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
                            admin.label1.Text = "WELCOME  a" + userID + " \n\nLogin Time:" + time + "";
                            admin.Show();
                            this.Hide();
                        }
                        else if (rd["isAdmin"].ToString() == "0" && id < 1000)
                        {
                            // Open student page
                            employee employee = new employee();
                            string   time     = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
                            employee.label1.Text = "WELCOME  e" + userID + " \n\nLogin Time:" + time + "";

                            employee.Show();
                            this.Hide();
                        }
                        else
                        {
                            Sportsman sportsman = new Sportsman();
                            string    time      = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
                            sportsman.label1.Text = "WELCOME  s" + userID + " \n\nLogin Time:" + time + "";

                            sportsman.Show();
                            this.Hide();
                        }
                    }
                }

                else // If reader cannot read
                {
                    rd.Close();
                    MessageBox.Show("Username or Password is not available", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    id.Clear();
                    password.Clear();
                }

                con.Close();
            }
            catch (MySql.Data.MySqlClient.MySqlException ex)
            {
                MessageBox.Show("Cannot reach database", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }