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);
}
