private void btnTambah_Click(object sender, EventArgs e)
{
try
{
String pesan = "";
if (va.doValidation() == false)
{
return;
}
diag = db.tbl_Diagnosas.FirstOrDefault(x => x.id_diagnosa == tbIddiagnosa.Text);
if (diag == null)
{
aksi("insert");
pesan = "menambah";
}
else
{
aksi("update");
pesan = "memperbaharui";
}
MessageBox.Show("Berhasil " + pesan + " data", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
loadGrid();
}
catch (Exception err)
{
MessageBox.Show("Terjadi Kesalahan" + err.ToString(), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void aksi(String aksinya)
{
diag = aksinya == "insert" ? new tbl_Diagnosa() : db.tbl_Diagnosas.FirstOrDefault(x => x.id_diagnosa == tbIddiagnosa.Text);
diag.id = int.Parse(cmbIdantrian.SelectedValue.ToString());
diag.hasil_diagnosa = rtbHasil.Text;
diag.resep = rtbResep.Text;
diag.status = "BELUM DIBAYAR";
if (aksinya == "insert")
{
diag.id_diagnosa = tbIddiagnosa.Text;
db.tbl_Diagnosas.InsertOnSubmit(diag);
}
db.SubmitChanges();
}
private void btnHapus_Click(object sender, EventArgs e)
{
if (klik == 1)
{
foreach (DataGridViewRow rw in this.dgvDiagnosa.SelectedRows)
{
primary = rw.Cells[0].Value.ToString();
}
diag = db.tbl_Diagnosas.Where(x => x.id_diagnosa == primary).Single();
db.tbl_Diagnosas.DeleteOnSubmit(diag);
db.SubmitChanges();
loadGrid();
}
else
{
MessageBox.Show("Silahkan pilih baris yang ingin di hapus!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void setTextBox()
{
if (!String.IsNullOrEmpty(tbIddiagnosa.Text))
{
diag = db.tbl_Diagnosas.FirstOrDefault(x => x.id_diagnosa == tbIddiagnosa.Text);
if (diag != null)
{
tbIddiagnosa.Text = diag.id_diagnosa;
cmbIdantrian.Text = diag.id.ToString();
rtbHasil.Text = diag.hasil_diagnosa;
rtbResep.Text = diag.resep;
btnTambah.Text = "UBAH";
}
else
{
va.clear("tbIddiagnosa");
btnTambah.Text = "TAMBAH";
}
}
}
