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