private void saveAtasanPenilai()
{
eap = new EntAtasanPejabatPenilai();
eap.Idpegawai = cmbNamaPegawai.SelectedValue.ToString();
validation = iap.validationInsert(eap);
if (validation)
{
message = "Pegawai dengan NIP : " + cmbNamaPegawai.SelectedValue.ToString() + "sudah menjadi atasan penilai";
MessageBox.Show(message, "Infromasi - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
condition = iap.save(eap, logTransactionSave());
if (condition)
{
setVisibleNotifikasiSave(false);
clearData();
}
else
{
message = "Data gagal disimpan";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public bool validationInsert(EntAtasanPejabatPenilai et)
{
query = "SpValidationInsertAtasanPenilai";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Idpegawai)
};
table = "AtasanPejabatPenilai";
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);
}
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);
}
private void delete()
{
try
{
eap = new EntAtasanPejabatPenilai();
eap.Idatasanpenilai = Id;
condition = iap.delete(eap, logTransactionDelete());
if (condition)
{
message = "Data berhasil di hapus";
MessageBox.Show(message, "Informasi - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Information);
setDataAtasanPejabatPenilai();
}
else
{
message = "Data gagal di hapus";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
setEnableButton(true);
}
catch
{
message = "tidak ada data yang dipilih";
MessageBox.Show(message, "Peringatan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}