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); }
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); } }
private void edit() { epk = new EntPrilakukerja(); etc = new EntRemoteTransactionClient(); epk.Idprilaku = Convert.ToInt32(sendIdPrilaku); epk.Orientasi = Convert.ToDouble(txtOrientasi.Text); epk.Integritas = Convert.ToDouble(txtIntegritas.Text); epk.Disiplin = Convert.ToDouble(txtDisiplin.Text); epk.Kerjasama = Convert.ToDouble(txtKerjasama.Text); epk.Kepemimpinam = Convert.ToDouble(txtKepemimpinan.Text); epk.Komitmen = Convert.ToDouble(txtKomitmen.Text); epk.Jumlah = Convert.ToDouble(txtJumlah.Text); epk.Ratarata = Convert.ToDouble(txtNilaiRata.Text); etc.Text = setData(); condition = ipl.edit(epk, etc); if (condition) { sendDataToServer(); setVisibleNotifikasiEditSucces(); } else { message = "Data gagal diubah"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void loginUser() { elp = new EntLoginPegawai(); rc = new EntRemoteTransactionClient(); elp.Namapengguna = txtUser.Text; elp.Jabatan = cmbJabatan.SelectedValue.ToString(); elp.Katasandi = txtPass.Text; rc.Text = setData(); condition = rlc.loginClient(elp, rc); if (condition) { sendDataToServer(); setVisibleWarningBox(true); sendNama = txtUser.Text; FrmMenuClient frm = new FrmMenuClient(sendNama, sendIpServer, sendHostServer, elp.Jabatan); frm.Show(); this.Hide(); } else { setVisibleWarningBox(false); clearTextBox(); } }
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 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); } }
private void save() { etc = new EntRemoteTransactionClient(); ers = new EntRealisasi(); foreach (DataGridViewRow row in dgvWorkSheetRealisasi.Rows) { ers.Iddetailkegiatan = row.Cells["iddetailkegiatan"].Value.ToString(); ers.Kuantitas = Convert.ToInt32(row.Cells["kuantitas"].Value.ToString()); ers.Kualitas = Convert.ToInt32(row.Cells["kualitas"].Value.ToString()); ers.Jumlahwaktu = Convert.ToInt32(row.Cells["waktu"].Value.ToString()); ers.Satuanwaktu = row.Cells["satuanwaktu"].Value.ToString(); ers.Biaya = Convert.ToDouble(row.Cells["biaya"].Value.ToString()); ers.Periodeawal = sendPeriodeAwal; ers.Periodeakhir = sendPeriodeAkhir; etc.Text = setData(); condition = irr.save(ers, etc); } if (condition) { sendDataToServer(); FrmDataRealisasi frm = new FrmDataRealisasi(viewForm, sendIpAddress, sendNama, sendJabatan); viewForm(frm); } else { message = "Data gagal disimpan"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void save() { euk = new EntUkurSasaran(); etc = new EntRemoteTransactionClient(); foreach (DataGridViewRow row in dgvDataUkurSasaran.Rows) { euk.Idsasaran = Convert.ToInt32(row.Cells["idsasarankerja"].Value.ToString()); euk.Idrealisasi = Convert.ToInt32(row.Cells["idrealisasi"].Value.ToString()); euk.Perhitungan = Convert.ToDouble(row.Cells["perhitungan"].Value.ToString()); euk.Capaian = Convert.ToDouble(row.Cells["capaian"].Value.ToString()); etc.Text = DateTime.Now.ToString("dd/MM/yyyy") + " " + DateTime.Now.ToString("hh:mm:ss") + " " + "[" + "Insert Ukur Sasaran Kerja" + "]" + "" + "" + " " + sendIpAddress + " " + sendNama; condition = iuk.save(euk, etc); } if (condition) { sendDataToServer(); FrmDataUkurSasaran frm = new FrmDataUkurSasaran(viewForm, sendIpAddress, sendNama, sendJabatan); viewForm(frm); } else { message = "Data gagal disimpan"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
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); }
private void delete() { elc = new EntLCKH(); etc = new EntRemoteTransactionClient(); elc.Idcapaian = Convert.ToInt32(sendidcapaian); etc.Text = setData(); condition = irl.delete(elc, etc); if (condition) { sendDataToServer(); message = "Data berhasil di hapus"; MessageBox.Show(message, "Informasi - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Information); setDataLCKH(); } else { message = "Data gagal di hapus"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void edit() { elc = new EntLCKH(); elcsync = new EntLCKH(); etc = new EntRemoteTransactionClient(); elc.Idcapaian = Convert.ToInt32(sendidcapaian); elc.Jumlah = Convert.ToInt32(txtVolume.Text); elcsync.Jumlah = Convert.ToInt32(txtVolume.Text); elcsync.Tanggal = date; elcsync.Idetailkegiatan = sendiddetaikegiatan; etc.Text = setData(); if (sendstatuskegiatan.Equals("Tidak Sinkron", StringComparison.InvariantCultureIgnoreCase)) { condition = irl.edit(elc, etc); if (condition) { sendDataToServer(); setVisibleNotifikasiEditSucces(); } else { message = "Data gagal diubah"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { condition = irl.editSync(elcsync, etc); if (condition) { sendDataToServer(); setVisibleNotifikasiEditSucces(); } else { message = "Data gagal diubah"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void editLoginPegawai() { elp = new EntLoginPegawai(); rtc = new EntRemoteTransactionClient(); elp.Namapengguna = receivenama; elp.Katasandi = txtConfirmPassword.Text; rtc.Text = setData(); conditionselect = rcp.selectPassword(elp); if (conditionselect) { if (txtNewPassword.Text == txtConfirmPassword.Text) { condition = rcp.edit(elp, rtc); if (condition) { sendDataToServer(); setVisibleNotifikasiSave(false); clearData(); } else { message = "Data gagal diubah"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { message = "Konfirmasi kata sandi baru tidak valid"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { message = "Kata sandi lama tidak valid"; MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void save() { epk = new EntPrilakukerja(); etc = new EntRemoteTransactionClient(); epk.Periodeawal = sendPeriodeAwal; epk.Periodeakhir = sendPeriodeAkhir; epk.Idatasanpenilai = sendidatasanpenilai; epk.Idpejabatpenilai = sendidpenilai; epk.Nip = cmbNip.SelectedValue.ToString(); epk.Orientasi = Convert.ToDouble(txtOrientasi.Text); epk.Integritas = Convert.ToDouble(txtIntegritas.Text); epk.Disiplin = Convert.ToDouble(txtDisiplin.Text); epk.Kerjasama = Convert.ToDouble(txtKerjasama.Text); epk.Kepemimpinam = Convert.ToDouble(txtKepemimpinan.Text); epk.Komitmen = Convert.ToDouble(txtKomitmen.Text); epk.Jumlah = Convert.ToDouble(txtJumlah.Text); epk.Ratarata = Convert.ToDouble(txtNilaiRata.Text); epk.Jabatan = sendJabatan; etc.Text = setData(); validation = ipk.validationInsert(epk); if (validation) { message = "Anda sudah menginputkan data nilai pada periode " + sendPeriodeAwal + " - " + sendPeriodeAkhir; MessageBox.Show(message, "Informasi - SIMKAP 1.0.0", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { condition = ipk.save(epk, etc); if (condition) { sendDataToServer(); clearData(); setVisibleNotifikasiSave(false); } else { message = "Data gagal disimpan"; 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(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 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(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(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 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(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); }