private void pictureBox1_Click(object sender, EventArgs e)
{
seting = new setingTeacher(NIK);
seting.Show();
seting.BackColor = this.BackColor;
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
seting = new setingTeacher();
Loginpage frm1 = new Loginpage();
//ganti back Color seting
seting.BackColor = this.BackColor;
seting.Show();
this.Hide();
koneksi();
String s = "SELECT nik FROM teacher WHERE email = '" + frm1.getemail() + "'";
MySqlCommand c = new MySqlCommand(s, conn);
Object result = c.ExecuteScalar();
String nik = (String)result;
String sql = "";
if (BackColor == Color.FromArgb(238, 142, 160))
{
sql = "UPDATE teacher SET Theme = 1 WHERE NIK = '" + nik + "'";
}
else if (BackColor == Color.FromArgb(249, 157, 42))
{
sql = "UPDATE teacher SET Theme = 2 WHERE NIK = '" + nik + "'";
}
else if (BackColor == Color.FromArgb(224, 43, 48))
{
sql = "UPDATE teacher SET Theme = 3 WHERE NIK = '" + nik + "'";
}
else if (BackColor == Color.FromArgb(95, 189, 102))
{
sql = "UPDATE teacher SET Theme = 4 WHERE NIK = '" + nik + "'";
}
else if (BackColor == Color.FromArgb(0, 192, 192))
{
sql = "UPDATE teacher SET Theme = 5 WHERE NIK = '" + nik + "'";
}
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
