private void delete()
{
ek = new EntKegiatan();
ek.Idkegiatan = sendIdKegiatan;
condition = ik.delete(ek, logtransactiondelete());
if (condition)
{
message = "Data berhasil di hapus";
MessageBox.Show(message, "Informasi - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Information);
setDataKegiatan();
}
else
{
message = "Data gagal di hapus";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool validationInsert(EntKegiatan et)
{
query = "SpValidationInsertKegiatan";
dbParams = new SqlParameter[]
{
new SqlParameter("@kegiatan", et.Kegiatan)
};
table = "Kegiatan";
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 getEntity()
{
ek = new EntKegiatan();
ek.Idkegiatan = receiveIdKegiatan;
ek.Kegiatan = txtKegiatan.Text;
ek.Idjenis = cmbJenis.SelectedValue.ToString();
ek.Outputkegiatan = txtOutput.Text;
ek.Satuan = cmbSatuan.SelectedItem.ToString();
ek.Status = cmbStatus.SelectedItem.ToString();
ek.Keterangan = cmbKeterangan.SelectedItem.ToString();
}
public bool delete(EntKegiatan et, string dt)
{
query = "SpDeleteKegiatan";
dbParams = new SqlParameter[]
{
new SqlParameter("@idkegiatan", et.Idkegiatan)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool edit(EntKegiatan et, string dt)
{
query = "SpEditKegiatan";
dbParams = new SqlParameter[]
{
new SqlParameter("@idkegiatan", et.Idkegiatan),
new SqlParameter("@outputkegiatan", et.Outputkegiatan),
new SqlParameter("@satuan", et.Satuan),
new SqlParameter("@idjenis", et.Idjenis),
new SqlParameter("@statuskegiatan", et.Status),
new SqlParameter("@keterangan", et.Keterangan)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
