private void button1_Click(object sender, EventArgs e) { DetailPasien formDetail = new DetailPasien(); formDetail.id = regid_textbox.Text; formDetail.Show(); this.Hide(); }
private void button2_Click(object sender, EventArgs e) { string queryTambah = "INSERT INTO riwayat_berobat (id_pasien, id_dokter, id_ruang, tanggal_berobat) VALUES" + "(@id, (SELECT nip FROM dokter WHERE nama_dokter='" + dokter_combobox.Text + "'), " + "(SELECT room_id FROM poli WHERE nama_ruangan='" + poli_combobox.Text + "'), @tanggal)" + "\n" + "insert into memeriksa values ('" + regid_textbox.Text + "', " + "(SELECT nip FROM dokter WHERE nama_dokter='" + dokter_combobox.Text + "'))" + "\n" + "insert into berobat values ('" + regid_textbox.Text + "'," + "(select room_id FROM poli where nama_ruangan='" + poli_combobox.Text + "'))" + "\n" + "insert into memiliki values('" + regid_textbox.Text + "'," + "(select trx from riwayat_berobat where id_pasien = '" + regid_textbox.Text + "'))"; System.Data.SqlClient.SqlConnection conn = konn.GetConn(); try { conn.Open(); SqlCommand cmd = new SqlCommand(queryTambah, conn); cmd.Parameters.AddWithValue("@id", regid_textbox.Text); cmd.Parameters.AddWithValue("@tanggal", tanggal_berobat_datetimepicker.Value); String name = nama_textbox.Text; DetailPasien formDetail = new DetailPasien(); id = regid_textbox.Text; cmd.ExecuteNonQuery(); MessageBox.Show("Pasien " + nama_textbox.Text + " \n" + "" + poli_combobox.Text + " \n" + "Silahkan Menunggu . . ."); reset(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } }