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();
}
}
