private void savePejabatPenilai()
{
epp = new EntPejabatPenilai();
epp.Idpegawai = cmbNamaPegawai.SelectedValue.ToString();
validation = ipp.validationInsert(epp);
if (validation)
{
message = "Pegawai dengan NIP : " + cmbNamaPegawai.SelectedValue.ToString() + "sudah menjadi penilai";
MessageBox.Show(message, "Infromasi - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
condition = ipp.save(epp, logTransactionSave());
if (condition)
{
setVisibleNotifikasiSave(false);
clearData();
}
else
{
message = "Data gagal disimpan";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
private void delete()
{
epp = new EntPejabatPenilai();
epp.Idpejabatpenilai = id;
condition = ipp.delete(epp, logTransactionDelete());
if (condition)
{
message = "Data berhasil di hapus";
MessageBox.Show(message, "Informasi - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Information);
setDataPejabatPenilai();
}
else
{
message = "Data gagal di hapus";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool validationInsert(EntPejabatPenilai et)
{
query = "SpValidationInsertPejabatPenilai";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Idpegawai)
};
table = "PejabatPenilai";
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(EntPejabatPenilai et, string dt)
{
query = "SpDeletePejabatPenilai";
dbParams = new SqlParameter[]
{
new SqlParameter("@idpejabatpenilai", et.Idpejabatpenilai)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool save(EntPejabatPenilai et, string dt)
{
query = "SpInsertPejabatPenilai";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Idpegawai),
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
