private void delete() { esk = new EntSasaranKerja(); etc = new EntRemoteTransactionClient(); esk.Idsasarankerja = id; etc.Text = setData(); condition = isk.delete(esk, etc); if (condition) { sendDataToServer(); message = "Data berhasil di hapus"; MessageBox.Show(message, "Informasi - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Information); setDataSKP(); } else { message = "Data gagal di hapus"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool save(EntSasaranKerja et, EntRemoteTransactionClient rtc) { query = "SpInsertSasaranKerja"; dbParams = new SqlParameter[] { new SqlParameter("@idekegiatan", et.Iddetailkegiatan), new SqlParameter("@idpenilai", et.Idpenilai), new SqlParameter("@idatasanpenilai", et.Idatasanpenilai), new SqlParameter("@kuantitas", et.Kuantitas), new SqlParameter("@kualitas", et.Kualitas), new SqlParameter("@jumlahwaktu", et.Jumlahwaktu), new SqlParameter("@satuanwaktu", et.Satuanwaktu), new SqlParameter("@biaya", et.Biaya), new SqlParameter("@perodeawal", et.Periodeawal), new SqlParameter("@periodeakhir", et.Periodeakhir) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeSaveLogTransactionClient(rtc.Text); return(condition); }
private void edit() { esk = new EntSasaranKerja(); etc = new EntRemoteTransactionClient(); esk.Periodeawal = sendperiodeawal.Text; esk.Periodeakhir = dtPeriodeAkhir.Value.Date.ToString("yyyy-MM-dd"); esk.Jabatan = sendjabatan; etc.Text = setData(); condition = isk.edit(esk, etc); if (condition) { sendDataToServer(); setVisibleNotifikasiEditSucces(); } else { message = "Data gagal diubah"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool delete(EntSasaranKerja et, EntRemoteTransactionClient rtc) { query = "SpDeleteSasaranKerja"; dbParams = new SqlParameter[] { new SqlParameter("@idsasarankerja", et.Idsasarankerja) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeSaveLogTransactionClient(rtc.Text); return(condition); }
public bool edit(EntSasaranKerja et, EntRemoteTransactionClient rtc) { query = "SpEditSasaranKerja"; dbParams = new SqlParameter[] { new SqlParameter("@periodeawal", et.Periodeawal), new SqlParameter("@periodeakhir", et.Periodeakhir), new SqlParameter("@jabatan", et.Jabatan) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeSaveLogTransactionClient(rtc.Text); return(condition); }