private void savePejabatPenilai() { epp = new EntPejabatPenilai(); epp.Idpegawai = cmbNamaPegawai.SelectedValue.ToString(); validation = ipp.validationInsert(epp); if (validation) { message = "Pegawai dengan NIP : " + cmbNamaPegawai.SelectedValue.ToString() + "sudah menjadi penilai"; MessageBox.Show(message, "Infromasi - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { condition = ipp.save(epp, logTransactionSave()); if (condition) { setVisibleNotifikasiSave(false); clearData(); } else { message = "Data gagal disimpan"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
private void delete() { epp = new EntPejabatPenilai(); epp.Idpejabatpenilai = id; condition = ipp.delete(epp, logTransactionDelete()); if (condition) { message = "Data berhasil di hapus"; MessageBox.Show(message, "Informasi - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Information); setDataPejabatPenilai(); } else { message = "Data gagal di hapus"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool validationInsert(EntPejabatPenilai et) { query = "SpValidationInsertPejabatPenilai"; dbParams = new SqlParameter[] { new SqlParameter("@nip", et.Idpegawai) }; table = "PejabatPenilai"; 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); }
public bool delete(EntPejabatPenilai et, string dt) { query = "SpDeletePejabatPenilai"; dbParams = new SqlParameter[] { new SqlParameter("@idpejabatpenilai", et.Idpejabatpenilai) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
public bool save(EntPejabatPenilai et, string dt) { query = "SpInsertPejabatPenilai"; dbParams = new SqlParameter[] { new SqlParameter("@nip", et.Idpegawai), }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }