private void getEntity()
{
ejk = new EntJenisKegiatan();
ejk.Idjenis = receiveIdJenis;
ejk.Jenis = txtJenis.Text;
}
public bool validationInsert(EntJenisKegiatan et)
{
query = "SpValidationInsertJenisKegiatan";
dbParams = new SqlParameter[]
{
new SqlParameter("@jenis", et.Jenis)
};
table = "JenisKegiatan";
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);
}
private void delete()
{
ejk = new EntJenisKegiatan();
ejk.Idjenis = sendIdJnsKegiatan;
condition = ijk.delete(ejk, logTransactionDelete());
if (condition)
{
message = "Data berhasil di hapus";
MessageBox.Show(message, "Informasi - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Information);
setDataJenisKegiatan();
}
else
{
message = "Data gagal di hapus";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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);
}
