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