private void delete() { epg = new EntPegawai(); epg.Nip = sendNip; condition = ipg.delete(epg, logTransactionDelete()); if (condition) { message = "Data berhasil di hapus"; MessageBox.Show(message, "Informasi - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Information); setDataPegawai(); } else { message = "Data gagal di hapus"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool validationInsert(EntPegawai et) { query = "SpValidationInsertPegawai"; dbParams = new SqlParameter[] { new SqlParameter("@jabatan", et.Jabatan) }; table = "Pegawai"; dt = new DataTable(); condition = connect.eksekusiQuery(query, dbParams, false); if (condition) { connect.viewTable(table).Fill(dt); if (dt.Rows.Count > 0) { status = true; } else { status = false; } } return(status); }
private void getEntity() { ep = new EntPegawai(); ep.Nip = txtNip.Text; ep.Nama = txtNama.Text; ep.Pagolru = txtPangkat.Text; ep.Jabatan = txtJabatan.Text; ep.Idunit = cmbUnitKerja.SelectedValue.ToString(); ep.Keterangan = cmbKeterangan.SelectedItem.ToString(); }
public bool delete(EntPegawai et, string dt) { query = "SpDeletePegawai"; dbParams = new SqlParameter[] { new SqlParameter("@nip", et.Nip) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
public bool edit(EntPegawai et, string dt) { query = "SpEditPegawai"; dbParams = new SqlParameter[] { new SqlParameter("@nip", et.Nip), new SqlParameter("@nama", et.Nama), new SqlParameter("@pagolru", et.Pagolru), new SqlParameter("@jabatan", et.Jabatan), new SqlParameter("@idunit", et.Idunit), new SqlParameter("@keterangan", et.Keterangan) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }