private void kembali() { home formHome = new home(); formHome.Show(); this.Hide(); }
private void button3_Click(object sender, EventArgs e) { home formHome = new home(); formHome.Show(); this.Hide(); }
private void login_Click(object sender, EventArgs e) { System.Data.SqlClient.SqlConnection conn = konn.GetConn(); try { conn.Open(); string sql = "SELECT * FROM admin WHERE username = '******'AND password = '******'"; SqlCommand command = new SqlCommand(sql, conn); command.ExecuteNonQuery(); SqlDataReader reader = null; reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { username = reader["username"].ToString(); password = reader["password"].ToString(); nama = reader["nama_pegawai"].ToString(); idAdmin = reader["no_pegawai"].ToString(); } reader.Close(); } else { string queryDokter = "SELECT * FROM dokter WHERE nip='" + username_textbox.Text + "' AND password_d='" + password_textbox.Text + "'"; SqlCommand commandDokter = new SqlCommand(queryDokter, conn); reader.Close(); reader = commandDokter.ExecuteReader(); while (reader.Read()) { nipDokter = usernameDokter = reader["nip"].ToString(); passwordDokter = reader["password_d"].ToString(); namaDokter = reader["nama_dokter"].ToString(); } reader.Close(); } if (username_textbox.Text.Equals(username) && password_textbox.Text.Equals(password)) { MessageBox.Show("Selamat Datang " + nama); formHome.Show(); this.Hide(); } else if (username_textbox.Text.Equals(usernameDokter) && password_textbox.Text.Equals(passwordDokter)) { MessageBox.Show("Selamat Datang " + namaDokter); TampilanDokter formDokter = new TampilanDokter(); formDokter.idDokter = nipDokter; formDokter.Show(); this.Hide(); } else { MessageBox.Show("Username atau password Salah"); } System.Data.SqlClient.SqlConnection con = konn.GetConn(); try { con.Open(); string queryInsert = "INSERT INTO login VALUES(@id)"; SqlCommand cmd = new SqlCommand(queryInsert, con); cmd.Parameters.AddWithValue("@id", idAdmin); cmd.ExecuteNonQuery(); } catch (Exception ex) { } finally { conn.Close(); } } catch (Exception ex) { MessageBox.Show("Silahkan periksa username dan Password anda"); } finally { conn.Close(); } }