public bool loginClient(EntLoginPegawai et, EntRemoteTransactionClient rtc) { query = "SpLoginPegawai"; dbParams = new SqlParameter[] { new SqlParameter("@namapengguna", et.Namapengguna), new SqlParameter("@jabatan", et.Jabatan), new SqlParameter("@katasandi", et.Katasandi) }; table = "Pegawai"; dtb = new DataTable(); condition = connect.eksekusiQuery(query, dbParams, false); if (condition) { connect.viewTable(table).Fill(dtb); if (dtb.Rows.Count > 0) { status = true; ls = new ImpLogServer(); ls.writeSaveLogTransactionClient(rtc.Text); } else { status = false; } } return(status); }
public bool save(EntPrilakukerja et, EntRemoteTransactionClient rtc) { query = "SpInsertPrilakuKerja"; dbParams = new SqlParameter[] { new SqlParameter("@nip", et.Nip), new SqlParameter("@orientasi", et.Orientasi), new SqlParameter("@integritas", et.Integritas), new SqlParameter("@disiplin", et.Disiplin), new SqlParameter("@kerjasama", et.Kerjasama), new SqlParameter("@periodeawal", et.Periodeawal), new SqlParameter("@periodeakhir", et.Periodeakhir), new SqlParameter("@idatasanpenilai", et.Idatasanpenilai), new SqlParameter("@idpejabatpenilai", et.Idpejabatpenilai), new SqlParameter("@kepemimpinan", et.Kepemimpinam), new SqlParameter("@komitmen", et.Komitmen), new SqlParameter("@jumlah", et.Jumlah), new SqlParameter("@ratarata", et.Ratarata) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeSaveLogTransactionClient(rtc.Text); return(condition); }
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); }
public bool loginUser(EntAdministrator et, string dt) { query = "SpLoginAdministrator"; dbParams = new SqlParameter[] { new SqlParameter("@user", et.Namapengguna), new SqlParameter("@pass", et.Passwordpengguna) }; table = "Administrator"; dtb = new DataTable(); condition = connect.eksekusiQuery(query, dbParams, false); if (condition) { connect.viewTable(table).Fill(dtb); if (dtb.Rows.Count > 0) { status = true; ls = new ImpLogServer(); ls.writeLogTrasaction(dt); } else { status = false; } } return(status); }
public bool delete(EntUnitKerja et, string dt) { query = "SpDeleteUnitKerja"; dbParams = new SqlParameter[] { new SqlParameter("@idunit", et.Idunit) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
public bool delete(EntJenisKegiatan et, string dt) { query = "SpDeleteJenisKegiatan"; dbParams = new SqlParameter[] { new SqlParameter("@idjenis", et.Idjenis) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
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 delete(EntAtasanPejabatPenilai et, string dt) { query = "SpDeleteAtasanPejabatPenilai"; dbParams = new SqlParameter[] { new SqlParameter("@idatasanpejabatpenilai", et.Idatasanpenilai) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
public bool save(EntAtasanPejabatPenilai et, string dt) { query = "SpInsertAtasanPejabatPenilai"; dbParams = new SqlParameter[] { new SqlParameter("@nip", et.Idpegawai), }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
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); }
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(EntLoginPegawai et, EntRemoteTransactionClient rtc) { query = "SpEditLogin"; dbParams = new SqlParameter[] { new SqlParameter("@namapengguna", et.Namapengguna), new SqlParameter("@pass", et.Katasandi) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeSaveLogTransactionClient(rtc.Text); return(condition); }
public bool edit(EntLCKH et, EntRemoteTransactionClient rtc) { query = "SpEditLCKHNoSync"; dbParams = new SqlParameter[] { new SqlParameter("@jumlah", et.Jumlah), new SqlParameter("@idcapian", et.Idcapaian) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeSaveLogTransactionClient(rtc.Text); return(condition); }
public bool save(EntUnitKerja et, string dt) { query = "SpInsertUnitKerja"; dbParams = new SqlParameter[] { new SqlParameter("@unit", et.Unitkerja), new SqlParameter("@alamatunit", et.Alamatunit) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
public bool save(EntLCKH et, EntRemoteTransactionClient rtc) { query = "SpInsertLCKH"; dbParams = new SqlParameter[] { new SqlParameter("@iddetailkegiatan", et.Idetailkegiatan), new SqlParameter("@jumlah", et.Jumlah), new SqlParameter("@keterangan", et.Keterangan) }; 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); }
public bool save(EntLoginPegawai et, string dt) { query = "SpInsertLogin"; dbParams = new SqlParameter[] { new SqlParameter("@nip", et.Nip), new SqlParameter("@user", et.Namapengguna), new SqlParameter("@pass", et.Katasandi) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
public bool save(EntUkurSasaran et, EntRemoteTransactionClient rtc) { query = "SpInsertUkurSasaran"; dbParams = new SqlParameter[] { new SqlParameter("@idsasaran", et.Idsasaran), new SqlParameter("@idrealisasi", et.Idrealisasi), new SqlParameter("@perhitungan", et.Perhitungan), new SqlParameter("@capaian", et.Capaian) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeSaveLogTransactionClient(rtc.Text); return(condition); }
public bool edit(EntAdministrator et, string dt) { query = "SpEditAdministrator"; dbParams = new SqlParameter[] { new SqlParameter("@idadmin", et.Idadmin), new SqlParameter("@nama", et.Nama), new SqlParameter("@jekel", et.Jekel), new SqlParameter("@namapengguna", et.Namapengguna), new SqlParameter("@pass", et.Passwordpengguna) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
public bool edit(EntKegiatan et, string dt) { query = "SpEditKegiatan"; dbParams = new SqlParameter[] { new SqlParameter("@idkegiatan", et.Idkegiatan), new SqlParameter("@outputkegiatan", et.Outputkegiatan), new SqlParameter("@satuan", et.Satuan), new SqlParameter("@idjenis", et.Idjenis), new SqlParameter("@statuskegiatan", et.Status), new SqlParameter("@keterangan", et.Keterangan) }; 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); }
public bool edit(EntPrilakukerja et, EntRemoteTransactionClient rtc) { query = "SpEditPrilakuKerja"; dbParams = new SqlParameter[] { new SqlParameter("@idprilaku", et.Idprilaku), new SqlParameter("@orientasi", et.Orientasi), new SqlParameter("@integritas", et.Integritas), new SqlParameter("@disiplin", et.Disiplin), new SqlParameter("@kerjasama", et.Kerjasama), new SqlParameter("@kepemimpinan", et.Kepemimpinam), new SqlParameter("@komitmen", et.Komitmen), new SqlParameter("@jumlah", et.Jumlah), new SqlParameter("@ratarata", et.Ratarata) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeSaveLogTransactionClient(rtc.Text); return(condition); }