private void btnTambah_Click(object sender, EventArgs e)
{
try
{
String pesan = "";
if (va.doValidation() == false)
{
return;
}
ru = db.tbl_Ruangans.FirstOrDefault(x => x.id_ruangan == tbIdruangan.Text);
if (ru == 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)
{
ru = aksinya == "insert" ? new tbl_Ruangan() : db.tbl_Ruangans.FirstOrDefault(x => x.id_ruangan == tbIdruangan.Text);
ru.nama_ruangan = tbNamaruangan.Text;
ru.id_tipe = cmbIdtipe.SelectedValue.ToString();
ru.id_dokter = int.Parse(cmbIddokter.SelectedValue.ToString());
ru.id_jadwal = cmbIdjadwal.SelectedValue.ToString();
ru.status = cmbStatus.Text;
if (aksinya == "insert")
{
ru.id_ruangan = tbIdruangan.Text;
db.tbl_Ruangans.InsertOnSubmit(ru);
}
db.SubmitChanges();
}
private void btnHapus_Click(object sender, EventArgs e)
{
if (klik == 1)
{
foreach (DataGridViewRow rw in this.dgvRuangan.SelectedRows)
{
primary = rw.Cells[0].Value.ToString();
}
ru = db.tbl_Ruangans.Where(x => x.id_ruangan == primary).Single();
db.tbl_Ruangans.DeleteOnSubmit(ru);
db.SubmitChanges();
loadGrid();
}
else
{
MessageBox.Show("Silahkan pilih baris yang ingin dihapus", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void setTextbox()
{
if (!String.IsNullOrEmpty(tbIdruangan.Text))
{
ru = db.tbl_Ruangans.FirstOrDefault(x => x.id_ruangan == tbIdruangan.Text);
if (ru != null)
{
tbIdruangan.Text = ru.id_ruangan;
tbNamaruangan.Text = ru.nama_ruangan;
cmbIdtipe.Text = ru.id_tipe;
cmbIddokter.Text = ru.id_dokter.ToString();
cmbIdjadwal.Text = ru.id_jadwal;
cmbStatus.Text = ru.status;
btnTambah.Text = "UBAH";
}
else
{
va.clear("tbIdruangan");
btnTambah.Text = "TAMBAH";
}
}
}
