public bool Tambah(NilaiSikap ns) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "INSERT INTO nilai_sikap VALUES(@idsikap, @nisn, @beribadah, @bersyukur, @berdoa, @toleransi, @jujur, @disiplin, @tanggungjawab, @peduli, @santun, @pd, @kerjasama, @deskripsik1, @deskripsik2, @semester)"; var args = new Dictionary <string, object> { { "@idsikap", ns.IdSikap }, { "@nisn", ns.Nisn }, { "@beribadah", ns.Beribadah }, { "@bersyukur", ns.Bersyukur }, { "@berdoa", ns.Berdoa }, { "@toleransi", ns.Toleransi }, { "@jujur", ns.Jujur }, { "@disiplin", ns.Disiplin }, { "@tanggungjawab", ns.TanggungJawab }, { "@peduli", ns.Peduli }, { "@santun", ns.Santun }, { "@pd", ns.PercayaDiri }, { "@kerjasama", ns.Kerjasama }, { "@deskripsik1", ns.DeskripsiKi1 }, { "@deskripsik2", ns.DeskripsiKi2 }, { "@semester", ns.Semester } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Ubah(NilaiSikap ns) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "UPDATE nilai_sikap SET beribadah = @beribadah, bersyukur = @bersyukur, berdoa = @berdoa, toleransi = @toleransi, jujur = @jujur, disiplin = @disiplin, tanggung_jawab = @tanggungjawab, peduli = @peduli, santun = @santun, percaya_diri = @pd, kerjasama = @kerjasama, deskripsi_ki1 = @deskripsik1, deskripsi_ki2 = @deskripsik2, semester = @semester WHERE id_sikap = @idsikap"; var args = new Dictionary <string, object> { { "@idsikap", ns.IdSikap }, { "@beribadah", ns.Beribadah }, { "@bersyukur", ns.Bersyukur }, { "@berdoa", ns.Berdoa }, { "@toleransi", ns.Toleransi }, { "@jujur", ns.Jujur }, { "@disiplin", ns.Disiplin }, { "@tanggungjawab", ns.TanggungJawab }, { "@peduli", ns.Peduli }, { "@santun", ns.Santun }, { "@pd", ns.PercayaDiri }, { "@kerjasama", ns.Kerjasama }, { "@deskripsik1", ns.DeskripsiKi1 }, { "@deskripsik2", ns.DeskripsiKi2 }, { "@semester", ns.Semester } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Ubah(DataSekolah data) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "UPDATE data_sekolah SET npsn = @npsn, kelas = @kelas, guru_kelas = @guru_kelas, nip_guru = @nip_guru, desa = @desa, kecamatan = @kecamatan, kota = @kota, provinsi = @provinsi, nm_sekolah = @nm_sekolah, alamat = @alamat, nm_kepsek = @nm_kepsek, nip_kepsek = @nip_kepsek, tgl_raport = @tgl_raport, semester = @semester, tahunajar = @tahunajar WHERE id_sek = @id_sek"; var args = new Dictionary <string, object> { { "@id_sek", data.IdSek }, { "@npsn", data.Npsn }, { "@kelas", data.Kelas }, { "@guru_kelas", data.GuruKelas }, { "@nip_guru", data.NipGuru }, { "@desa", data.Desa }, { "@kecamatan", data.Kecamatan }, { "@kota", data.Kota }, { "@provinsi", data.Provinsi }, { "@nm_sekolah", data.NmSekolah }, { "@alamat", data.Alamat }, { "@nm_kepsek", data.NmKepsek }, { "@nip_kepsek", data.NipKepsek }, { "@tgl_raport", data.TglRaport }, { "@semester", data.Semester }, { "@tahunajar", data.Tahunajar } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool HapusAll(string nisn) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "DELETE FROM nilai_keterampilan WHERE nisn = @nisn"; var args = new Dictionary <string, object> { { "@nisn", nisn } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Hapus(NilaiEkskul eks) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "DELETE FROM nilai_ekskul WHERE id_eks = @ideks"; var args = new Dictionary <string, object> { { "@ideks", eks.IdEks } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Hapus(NilaiKeterampilan nk) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "DELETE FROM nilai_keterampilan WHERE id_ket = @idket"; var args = new Dictionary <string, object> { { "@idket", nk.IdKet } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Hapus(Absensi abs) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "DELETE FROM absensi WHERE id_absen = @idabsen"; var args = new Dictionary <string, object> { { "@idabsen", abs.IdAbsen } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Hapus(NilaiPengetahuan np) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "DELETE FROM nilai_pengetahuan WHERE id_peng = @idpeng"; var args = new Dictionary <string, object> { { "@idpeng", np.IdPeng } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Hapus(DataSiswa ds) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "DELETE FROM data_siswa WHERE nisn = @nisn"; var args = new Dictionary <string, object> { { "@nisn", ds.Nisn } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Hapus(NilaiSikap ns) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "DELETE FROM nilai_sikap WHERE id_sikap = @idsikap"; var args = new Dictionary <string, object> { { "@idsikap", ns.IdSikap } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Ubah(Absensi abs) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "UPDATE absensi SET sakit = @sakit, ijin = @ijin, alpha = @alpha, semester = @semester WHERE id_absen = @idabsen"; var args = new Dictionary <string, object> { { "@idabsen", abs.IdAbsen }, { "@sakit", abs.Sakit }, { "@ijin", abs.Ijin }, { "@alpha", abs.Alpha }, { "@semester", abs.Semester } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Tambah(Absensi abs) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "INSERT INTO absensi VALUES(@idabsen, @nisn, @sakit, @ijin, @alpha, @semester)"; var args = new Dictionary <string, object> { { "@idabsen", abs.IdAbsen }, { "@nisn", abs.Nisn }, { "@sakit", abs.Sakit }, { "@ijin", abs.Ijin }, { "@alpha", abs.Alpha }, { "@semester", abs.Semester } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Ubah(DataSiswa ds, string oldnisn) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "UPDATE data_siswa SET nisn = @nisn, no_induk = @noinduk, nm_siswa = @nmsiswa, nm_panggilan = @nmpanggilan, gender = @gender, agama = @agama, tempat_lahir = @tptlahir, tgl_lahir = @tgllahir, pendidikan_seb = @penseb, alamat = @alamat, nm_ayah = @nmayah, nm_ibu = @nmibu, job_ayah = @jobayah, job_ibu = @jobibu, jalan = @jalan, kecamatan = @kecamatan, desa = @desa, kota = @kota, provinsi = @provinsi, nm_wali = @nmwali, job_wali = @jobwali, alamat_wali = @alamatwali, pendengaran = @pendengaran, penglihatan = @penglihatan, gigi = @gigi, berat1 = @berat1, berat2 = @berat2, tinggi1 = @tinggi1, tinggi2 = @tinggi2 WHERE nisn = @oldnisn"; var args = new Dictionary <string, object> { { "@oldnisn", oldnisn }, { "@nisn", ds.Nisn }, { "@noinduk", ds.NoInduk }, { "@nmsiswa", ds.NmSiswa }, { "@nmpanggilan", ds.NmPanggilan }, { "@gender", ds.Gender }, { "@agama", ds.Agama }, { "@tptlahir", ds.TempatLahir }, { "@tgllahir", ds.TglLahir }, { "@penseb", ds.PendidikanSeb }, { "@alamat", ds.Alamat }, { "@nmayah", ds.NmAyah }, { "@nmibu", ds.NmIbu }, { "@jobayah", ds.JobAyah }, { "@jobibu", ds.JobIbu }, { "@jalan", ds.Jalan }, { "@kecamatan", ds.Kecamatan }, { "@desa", ds.Desa }, { "@kota", ds.Kota }, { "@provinsi", ds.Provinsi }, { "@nmwali", ds.NmWali }, { "@jobwali", ds.JobWali }, { "@alamatwali", ds.AlamatWali }, { "@pendengaran", ds.Pendengaran }, { "@penglihatan", ds.Penglihatan }, { "@gigi", ds.Gigi }, { "@berat1", ds.Berat1 }, { "@berat2", ds.Berat2 }, { "@tinggi1", ds.Tinggi1 }, { "@tinggi2", ds.Tinggi2 } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Ubah(NilaiEkskul eks) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "UPDATE nilai_ekskul SET eskul1 = @ekskul1, eskul2 = @ekskul2, eskul3 = @ekskul3, nilai1 = @nilai1, nilai2 = @nilai2, nilai3 = @nilai3, semester = @semester WHERE id_eks = @ideks"; var args = new Dictionary <string, object> { { "@ideks", eks.IdEks }, { "@ekskul1", eks.Eskul1 }, { "@ekskul2", eks.Eskul2 }, { "@ekskul3", eks.Eskul3 }, { "@nilai1", eks.Nilai1 }, { "@nilai2", eks.Nilai2 }, { "@nilai3", eks.Nilai3 }, { "@semester", eks.Semester } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Tambah(DataSiswa ds) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "INSERT INTO data_siswa VALUES(@nisn, @noinduk, @nmsiswa, @nmpanggilan, @gender, @agama, @tptlahir, @tgllahir, @penseb, @alamat, @nmayah, @nmibu, @jobayah, @jobibu, @jalan, @kecamatan, @desa, @kota, @provinsi, @nmwali, @jobwali, @alamatwali, @pendengaran, @penglihatan, @gigi, @berat1, @berat2, @tinggi1, @tinggi2)"; var args = new Dictionary <string, object> { { "@nisn", ds.Nisn }, { "@noinduk", ds.NoInduk }, { "@nmsiswa", ds.NmSiswa }, { "@nmpanggilan", ds.NmPanggilan }, { "@gender", ds.Gender }, { "@agama", ds.Agama }, { "@tptlahir", ds.TempatLahir }, { "@tgllahir", ds.TglLahir }, { "@penseb", ds.PendidikanSeb }, { "@alamat", ds.Alamat }, { "@nmayah", ds.NmAyah }, { "@nmibu", ds.NmIbu }, { "@jobayah", ds.JobAyah }, { "@jobibu", ds.JobIbu }, { "@jalan", ds.Jalan }, { "@kecamatan", ds.Kecamatan }, { "@desa", ds.Desa }, { "@kota", ds.Kota }, { "@provinsi", ds.Provinsi }, { "@nmwali", ds.NmWali }, { "@jobwali", ds.JobWali }, { "@alamatwali", ds.AlamatWali }, { "@pendengaran", ds.Pendengaran }, { "@penglihatan", ds.Penglihatan }, { "@gigi", ds.Gigi }, { "@berat1", ds.Berat1 }, { "@berat2", ds.Berat2 }, { "@tinggi1", ds.Tinggi1 }, { "@tinggi2", ds.Tinggi2 } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Ubah(NilaiKeterampilan nk) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "UPDATE nilai_keterampilan SET kd_tertinggi = @kd_tertinggi, kd_terendah = @kd_terendah, nilai_tertinggi = @nilai_tertinggi, nilai_terendah = @nilai_terendah, nilaiakhir = @nilaiakhir, predikatketerampilan = @predikatket, deskripsi_keterampilan = @desket, semester = @semester WHERE id_ket = @idket"; var args = new Dictionary <string, object> { { "@idket", nk.IdKet }, { "@kd_tertinggi", nk.KdTertinggi }, { "@kd_terendah", nk.KdTerendah }, { "@nilai_tertinggi", nk.NilaiTertinggi }, { "@nilai_terendah", nk.NilaiTerendah }, { "@nilaiakhir", nk.NilaiAkhir }, { "@predikatket", nk.PredikatKeterampilan }, { "@desket", nk.DeskripsiKeterampilan }, { "@semester", nk.Semester } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Tambah(NilaiEkskul eks) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "INSERT INTO nilai_ekskul VALUES(@ideks, @nisn, @ekskul1, @ekskul2, @ekskul3, @nilai1, @nilai2, @nilai3, @semester)"; var args = new Dictionary <string, object> { { "@ideks", eks.IdEks }, { "@nisn", eks.Nisn }, { "@ekskul1", eks.Eskul1 }, { "@ekskul2", eks.Eskul2 }, { "@ekskul3", eks.Eskul3 }, { "@nilai1", eks.Nilai1 }, { "@nilai2", eks.Nilai2 }, { "@nilai3", eks.Nilai3 }, { "@semester", eks.Semester } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Ubah(NilaiPengetahuan np) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "UPDATE nilai_pengetahuan SET kd_tertinggi = @kd_tertinggi, kd_terendah = @kd_terendah, nilai_tertinggi = @nilai_tertinggi, nilai_terendah = @nilai_terendah, nilaiakhir = @nilaiakhir, predikatpengetahuan = @predikatpeng, deskripsi_pengetahuan = @despeng, semester = @semester WHERE id_peng = @idpeng"; var args = new Dictionary <string, object> { { "@idpeng", np.IdPeng }, { "@kd_tertinggi", np.KdTertinggi }, { "@kd_terendah", np.KdTerendah }, { "@nilai_tertinggi", np.NilaiTertinggi }, { "@nilai_terendah", np.NilaiTerendah }, { "@nilaiakhir", np.NilaiAkhir }, { "@predikatpeng", np.PredikatPengetahuan }, { "@despeng", np.DeskripsiPengetahuan }, { "@semester", np.Semester } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Tambah(NilaiPengetahuan np) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "INSERT INTO nilai_pengetahuan VALUES(@idpeng, @nisn, @idmapel, @kd_tertinggi, @kd_terendah, @nilai_tertinggi, @nilai_terendah, @nilaiakhir, @predikatpeng, @despeng, @semester)"; var args = new Dictionary <string, object> { { "@idpeng", np.IdPeng }, { "@nisn", np.Nisn }, { "@idmapel", np.IdMapel }, { "@kd_tertinggi", np.KdTertinggi }, { "@kd_terendah", np.KdTerendah }, { "@nilai_tertinggi", np.NilaiTertinggi }, { "@nilai_terendah", np.NilaiTerendah }, { "@nilaiakhir", np.NilaiAkhir }, { "@predikatpeng", np.PredikatPengetahuan }, { "@despeng", np.DeskripsiPengetahuan }, { "@semester", np.Semester } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }
public bool Tambah(NilaiKeterampilan nk) { bool isNice = false; RaportDB dB = new RaportDB(); const string query = "INSERT INTO nilai_keterampilan VALUES(@idket, @nisn, @idmapel, @kd_tertinggi, @kd_terendah, @nilai_tertinggi, @nilai_terendah, @nilaiakhir, @predikatket, @desket, @semester)"; var args = new Dictionary <string, object> { { "@idket", nk.IdKet }, { "@nisn", nk.Nisn }, { "@idmapel", nk.IdMapel }, { "@kd_tertinggi", nk.KdTertinggi }, { "@kd_terendah", nk.KdTerendah }, { "@nilai_tertinggi", nk.NilaiTertinggi }, { "@nilai_terendah", nk.NilaiTerendah }, { "@nilaiakhir", nk.NilaiAkhir }, { "@predikatket", nk.PredikatKeterampilan }, { "@desket", nk.DeskripsiKeterampilan }, { "@semester", nk.Semester } }; return(isNice = dB.ExecuteWrite(query, args) > 0 ? true : false); }