示例#1
0
        private void pictureBox2_MouseClick(object sender, MouseEventArgs e)
        {
            b_awal a = new b_awal();

            a.Show();
            this.Hide();
        }
示例#2
0
        private void login_Click(object sender, EventArgs e)
        {
            string          adm     = "ADMIN";
            string          pet     = "PETUGAS";
            string          user    = username.Text;
            string          pass    = password.Text;
            string          koneksi = "server=localhost;database=aplikasispp;uid=root;pwd='';";
            MySqlConnection con     = new MySqlConnection(koneksi);

            if (user == "" && pass == "")
            {
                MessageBox.Show("Harap Masukan Username dan Password", "Peringatan !", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else if (user == "")
            {
                MessageBox.Show("Harap Masukan Username", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else if (user == "")
            {
                MessageBox.Show("Harap Masukan Password", "Peringatan !", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else if (MessageBox.Show("Ingin Login?", "Konfirmasi", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                try
                {
                    con.Open();


                    MySqlDataAdapter da  = new MySqlDataAdapter("SELECT * FROM petugas WHERE username = '******' && password='******' && level='" + adm + "'", con);
                    MySqlDataAdapter da1 = new MySqlDataAdapter("SELECT * FROM petugas WHERE username = '******' && password='******' && level='" + pet + "'", con);
                    MySqlDataAdapter da2 = new MySqlDataAdapter("SELECT * FROM siswa WHERE nama_siswa = '" + user + "' && nis='" + pass + "'", con);
                    DataTable        dt  = new DataTable();
                    DataTable        dt1 = new DataTable();
                    DataTable        dt2 = new DataTable();
                    da.Fill(dt);
                    da1.Fill(dt1);
                    da2.Fill(dt2);

                    if (dt.Rows.Count > 0)
                    {
                        this.Hide();
                        MessageBox.Show("Selamat Datang " + user + ".");
                        a_awal awal_admin = new a_awal();
                        awal_admin.Show();
                    }
                    else if (dt1.Rows.Count > 0)
                    {
                        MessageBox.Show("Selamat Datang " + user + ".");
                        b_awal b_petugas = new b_awal();
                        b_petugas.Show();
                        this.Hide();
                    }
                    else if (dt2.Rows.Count > 0)
                    {
                        MessageBox.Show("Selamat Datang " + user + ".");
                        c_awal_siswa c_siswa = new c_awal_siswa();
                        c_siswa.Show();
                        this.Hide();
                    }
                    else
                    {
                        MessageBox.Show("data salah", "peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                    con.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Tak Ada Koneksi");
                }
            }
        }