void panggilnama()
{
Loginpage frm1 = new Loginpage();
koneksi();
String sql = "Select Name,Email,jk,nik from teacher ";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
if (frm1.getemail() == rdr.GetString(1))
{
String jk = "";
if (rdr.GetString(2) == "Male")
{
jk = "Mr.";
}
else if (rdr.GetString(2) == "Female")
{
jk = "Mrs.";
}
label2.Text = "Welcome, " + jk + rdr.GetString(0);
NIK = rdr.GetString(3);
}
}
rdr.Close();
conn.Close();
}
string getNIK()
{
Loginpage frm1 = new Loginpage();
koneksi();
String sql = "Select nik from teacher where email = '" + frm1.getemail() + "'";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
String n = "";
while (rdr.Read())
{
n = rdr.GetString(0);
}
conn.Close();
return(n);
}
private void button2_Click(object sender, EventArgs e)
{
seting = new Seting();
Loginpage frm1 = new Loginpage();
koneksi();
//ganti back Color seting
seting.BackColor = this.BackColor;
seting.Show();
this.Hide();
String s = "SELECT nis FROM student WHERE email = '" + frm1.getemail() + "'";
MySqlCommand c = new MySqlCommand(s, conn);
Object result = c.ExecuteScalar();
String nis1 = (String)result;
String sql = "";
if (BackColor == Color.FromArgb(238, 142, 160))
{
sql = "UPDATE student SET Theme = 1 WHERE NIS = '" + nis1 + "'";
}
else if (BackColor == Color.FromArgb(249, 157, 42))
{
sql = "UPDATE student SET Theme = 2 WHERE NIS = '" + nis1 + "'";
}
else if (BackColor == Color.FromArgb(224, 43, 48))
{
sql = "UPDATE student SET Theme = 3 WHERE NIS = '" + nis1 + "'";
}
else if (BackColor == Color.FromArgb(95, 189, 102))
{
sql = "UPDATE student SET Theme = 4 WHERE NIS = '" + nis1 + "'";
}
else if (BackColor == Color.FromArgb(0, 192, 192))
{
sql = "UPDATE student SET Theme = 5 WHERE NIS = '" + nis1 + "'";
}
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
void panggilnama()
{
Loginpage frm1 = new Loginpage();
koneksi();
String sql = "Select Name,Email,NIS from student ";
//where Email='"+frm1.getemail()+"'"
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
if (frm1.getemail() == rdr.GetString(1))
{
labeluser.Text = "Welcome, " + rdr.GetString(0);
this.nis = rdr.GetString(2);
}
}
conn.Close();
}
public DataTable baca()
{
Loginpage frm1 = new Loginpage();
koneksi();
String s = "SELECT username FROM teacher WHERE email = '" + frm1.getemail() + "'";
MySqlCommand c = new MySqlCommand(s, conn);
Object result = c.ExecuteScalar();
String username = (String)result;
String sql = "SELECT name, nis FROM student WHERE username = '******'";
DataColumn column = new DataColumn();
column.ColumnName = "no.";
column.DataType = System.Type.GetType("System.Int32");
column.AutoIncrement = true;
column.AutoIncrementSeed = 1;
column.AutoIncrementStep = 1;
DataTable dt = new DataTable();
try
{
dt.Columns.Add(column);
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataAdapter data = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
data.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].Width = 30;
dataGridView1.Columns[1].Width = 240;
dataGridView1.Columns[2].Width = 230;
dataGridView1.BackgroundColor = Color.White;
}
catch (Exception ali)
{
MessageBox.Show(ali.Message);
}
conn.Close();
return(dt);
}
public DataTable baca()
{
Loginpage frm1 = new Loginpage();
koneksi();
String s = "SELECT username FROM student WHERE email = '" + frm1.getemail() + "'";
MySqlCommand c = new MySqlCommand(s, conn);
Object result = c.ExecuteScalar();
String username = (String)result;
String sq = "SELECT nik FROM teacher WHERE username = '******'";
MySqlCommand cm = new MySqlCommand(sq, conn);
Object r = cm.ExecuteScalar();
String nik = (String)r;
String sql = "SELECT day, time, room, course, teacher FROM schedule WHERE nik = '" + nik + "'";
DataTable dt = new DataTable();
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataAdapter data = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
data.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].Width = 60;
dataGridView1.Columns[1].Width = 50;
dataGridView1.Columns[2].Width = 60;
dataGridView1.Columns[3].Width = 267;
dataGridView1.Columns[4].Width = 100;
dataGridView1.BackgroundColor = Color.White;
}
catch (Exception ali)
{
MessageBox.Show(ali.Message);
}
conn.Close();
return(dt);
}
private void Seting_Load(object sender, EventArgs e)
{
koneksi();
Loginpage frm1 = new Loginpage();
String sql = "SELECT Theme FROM student WHERE email = '" + frm1.getemail() + "'";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
//if (nis == rdr.GetString(0))
//{
if (rdr.GetInt16(0) == 1)
{
this.BackColor = Color.FromArgb(238, 142, 160);
}
else if (rdr.GetInt16(0) == 2)
{
this.BackColor = Color.FromArgb(249, 157, 42);
}
else if (rdr.GetInt16(0) == 3)
{
this.BackColor = Color.FromArgb(224, 43, 48);
}
else if (rdr.GetInt16(0) == 4)
{
this.BackColor = Color.FromArgb(95, 189, 102);
}
else if (rdr.GetInt16(0) == 5)
{
this.BackColor = Color.FromArgb(0, 192, 192);
}
//}
}
conn.Close();
}
