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"; } } }