public bool loginUser(EntAdministrator et, string dt) { query = "SpLoginAdministrator"; dbParams = new SqlParameter[] { new SqlParameter("@user", et.Namapengguna), new SqlParameter("@pass", et.Passwordpengguna) }; table = "Administrator"; dtb = new DataTable(); condition = connect.eksekusiQuery(query, dbParams, false); if (condition) { connect.viewTable(table).Fill(dtb); if (dtb.Rows.Count > 0) { status = true; ls = new ImpLogServer(); ls.writeLogTrasaction(dt); } else { status = false; } } return(status); }
public bool delete(EntUnitKerja et, string dt) { query = "SpDeleteUnitKerja"; dbParams = new SqlParameter[] { new SqlParameter("@idunit", et.Idunit) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
public bool delete(EntPegawai et, string dt) { query = "SpDeletePegawai"; dbParams = new SqlParameter[] { new SqlParameter("@nip", et.Nip) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
public bool delete(EntDetailKegiatan ed, string dt) { query = "SpDeleteDetailKegiatan"; dbParams = new SqlParameter[] { new SqlParameter("@iddetailkegiatan", ed.Iddetailkegiatan) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
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); }
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); }
public bool save(EntUnitKerja et, string dt) { query = "SpInsertUnitKerja"; dbParams = new SqlParameter[] { new SqlParameter("@unit", et.Unitkerja), new SqlParameter("@alamatunit", et.Alamatunit) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
public bool save(EntLoginPegawai et, string dt) { query = "SpInsertLogin"; dbParams = new SqlParameter[] { new SqlParameter("@nip", et.Nip), new SqlParameter("@user", et.Namapengguna), new SqlParameter("@pass", et.Katasandi) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
public bool edit(EntAdministrator et, string dt) { query = "SpEditAdministrator"; dbParams = new SqlParameter[] { new SqlParameter("@idadmin", et.Idadmin), new SqlParameter("@nama", et.Nama), new SqlParameter("@jekel", et.Jekel), new SqlParameter("@namapengguna", et.Namapengguna), new SqlParameter("@pass", et.Passwordpengguna) }; condition = connect.eksekusiQuery(query, dbParams, false); ls = new ImpLogServer(); ls.writeLogTrasaction(dt); return(condition); }
public bool edit(EntPegawai et, string dt) { query = "SpEditPegawai"; dbParams = new SqlParameter[] { new SqlParameter("@nip", et.Nip), new SqlParameter("@nama", et.Nama), new SqlParameter("@pagolru", et.Pagolru), new SqlParameter("@jabatan", et.Jabatan), new SqlParameter("@idunit", et.Idunit), new SqlParameter("@keterangan", et.Keterangan) }; 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); }