private void button5_Click_1(object sender, EventArgs e)
        {
            koneksi();
            String       sq     = "SELECT ID_Course FROM course WHERE Course_Name = '" + cName.Text + "'";
            MySqlCommand cm     = new MySqlCommand(sq, conn);
            Object       result = cm.ExecuteScalar();
            int          id     = (int)result;

            String       q        = "SELECT ID_Schedule FROM schedule WHERE course = '" + cName.Text + "'";
            MySqlCommand d        = new MySqlCommand(q, conn);
            Object       r        = d.ExecuteScalar();
            int          id_sched = (int)r;

            String       s = "UPDATE course SET Course_Name = '" + cName.Text + "' WHERE ID_Course = " + id;
            MySqlCommand c = new MySqlCommand(s, conn);

            c.ExecuteNonQuery();

            String       sql = "UPDATE schedule SET Day = '" + textBox1.Text + "', Room = '" + cls.Text + "', Course = '" + cName.Text + "', Teacher = '" + teache.Text + "', Time = '" + hour + ":" + minute + "' WHERE ID_Schedule = " + id_sched;
            MySqlCommand cmd = new MySqlCommand(sql, conn);

            cmd.ExecuteNonQuery();
            conn.Close();
            sched = new ScheduleTeacher(NIK);
            sched.Show();
            sched.BackColor = this.BackColor;
            this.Hide();
        }
Пример #2
0
 private void pictureBox1_Click(object sender, EventArgs e)
 {
     sched = new ScheduleTeacher(NIP);
     sched.Show();
     sched.BackColor = this.BackColor;
     this.Hide();
 }
        private void delete_Click(object sender, EventArgs e)
        {
            DialogResult box = MessageBox.Show("Are you sure want to delete the schedule?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);

            if (box == DialogResult.Yes)
            {
                koneksi();
                String       sq     = "SELECT ID_Course FROM course WHERE Course_Name = '" + cName.Text + "'";
                MySqlCommand cm     = new MySqlCommand(sq, conn);
                Object       result = cm.ExecuteScalar();
                int          id     = (int)result;

                String       q        = "SELECT ID_Schedule FROM schedule WHERE course = '" + cName.Text + "'";
                MySqlCommand d        = new MySqlCommand(q, conn);
                Object       r        = d.ExecuteScalar();
                int          id_sched = (int)r;

                String       s = "DELETE FROM course WHERE ID_Course = " + id;
                MySqlCommand c = new MySqlCommand(s, conn);
                c.ExecuteNonQuery();

                String       sql = "DELETE FROM schedule WHERE ID_Schedule = " + id_sched;
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
                conn.Close();
                sched = new ScheduleTeacher(NIK);
                sched.Show();
                sched.BackColor = this.BackColor;
                this.Hide();
            }
            else if (box == DialogResult.No)
            {
                this.Show();
            }
        }
Пример #4
0
        private void button5_Click(object sender, EventArgs e)
        {
            koneksi();
            String       s = "INSERT INTO course (Course_Name) values ('" + textBox1.Text + "')";
            MySqlCommand c = new MySqlCommand(s, conn);

            c.ExecuteNonQuery();

            String       sq     = "SELECT max(ID_Course) FROM course";
            MySqlCommand cm     = new MySqlCommand(sq, conn);
            Object       result = cm.ExecuteScalar();
            int          id     = (int)result;

            String       sql = "INSERT INTO schedule (Day, Time, Room, Course, Teacher, NIK, ID_Course) values ('" + textBox2.Text + "','" + hour + ":" + minute + "','" + textBox7.Text + "','" + textBox1.Text + "','" + textBox4.Text + "','" + NIP + "'," + id + ")";
            MySqlCommand cmd = new MySqlCommand(sql, conn);

            cmd.ExecuteNonQuery();
            conn.Close();
            sched = new ScheduleTeacher(NIP);
            sched.Show();
            sched.BackColor = this.BackColor;
            this.Hide();
        }