public bool validationInsert(EntDetailKegiatan et) { query = "SpValidationInsertDetailKegiatan"; dbParams = new SqlParameter[] { new SqlParameter("@idkegiatan", et.Idkegiatan), new SqlParameter("@nip", et.Nip) }; table = "DetailKegiatan"; 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 delete() { edk = new EntDetailKegiatan(); edk.Iddetailkegiatan = id; condition = idk.delete(edk, logTransactionDelete()); if (condition) { message = "Data berhasil di hapus"; MessageBox.Show(message, "Informasi - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Information); setDataDetailKegiatanPegawai(); } else { message = "Data gagal di hapus"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool delete(EntDetailKegiatan ed, string dt) { query = "SpDeleteDetailKegiatan"; dbParams = new SqlParameter[] { new SqlParameter("@iddetailkegiatan", ed.Iddetailkegiatan) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
private void save() { edk = new EntDetailKegiatan(); edk.Nip = cmbNama.SelectedValue.ToString(); edk.Idkegiatan = cmbKegiatan.SelectedValue.ToString(); condition = idk.save(edk, logTransactionSave()); if (condition) { setVisibleNotifikasiSave(false); clearData(); } else { message = "Data gagal disimpan"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } }