public NilaiSikap GetNilaiSikap(string idsikap) { NilaiSikap nilaiSikap; RaportDB dB = new RaportDB(); string query = $"SELECT * FROM nilai_sikap WHERE id_sikap = '{idsikap}'"; DataTable dt = dB.GetDataRaport(query); nilaiSikap = new NilaiSikap { IdSikap = idsikap, Nisn = dt.Rows[0][1].ToString(), Beribadah = Convert.ToInt32(dt.Rows[0][2]), Bersyukur = Convert.ToInt32(dt.Rows[0][3]), Berdoa = Convert.ToInt32(dt.Rows[0][4]), Toleransi = Convert.ToInt32(dt.Rows[0][5]), Jujur = Convert.ToInt32(dt.Rows[0][6]), Disiplin = Convert.ToInt32(dt.Rows[0][7]), TanggungJawab = Convert.ToInt32(dt.Rows[0][8]), Peduli = Convert.ToInt32(dt.Rows[0][9]), Santun = Convert.ToInt32(dt.Rows[0][10]), PercayaDiri = Convert.ToInt32(dt.Rows[0][11]), Kerjasama = Convert.ToInt32(dt.Rows[0][12]), DeskripsiKi1 = dt.Rows[0][13].ToString(), DeskripsiKi2 = dt.Rows[0][14].ToString(), Semester = dt.Rows[0][15].ToString() }; return(nilaiSikap); }
public Absensi GetAbsensiSiswa(string nisn, string semester) { Absensi absensi; RaportDB dB = new RaportDB(); string query = $"SELECT * FROM absensi WHERE nisn = '{nisn}' AND semester = '{semester}'"; DataTable dt = dB.GetDataRaport(query); if (dt.Rows.Count > 0) { absensi = new Absensi { IdAbsen = dt.Rows[0][0].ToString(), Nisn = dt.Rows[0][1].ToString(), Sakit = Convert.ToInt32(dt.Rows[0][2]), Ijin = Convert.ToInt32(dt.Rows[0][3]), Alpha = Convert.ToInt32(dt.Rows[0][4]), Semester = dt.Rows[0][5].ToString() }; } else { absensi = new Absensi { IdAbsen = "", Nisn = "", Sakit = 0, Ijin = 0, Alpha = 0, Semester = "" }; } return(absensi); }
public void GetSiswaTable() { var query = "SELECT nisn, no_induk, nm_siswa, gender, agama, tempat_lahir, tgl_lahir FROM data_siswa"; RaportDB db = new RaportDB(); SiswaDataTable = db.GetDataRaport(query); }
public DataSekolah GetDataSekolah() { DataSekolah dataSekolah; RaportDB dB = new RaportDB(); const string query = "SELECT * FROM data_sekolah WHERE id_sek = 1"; DataTable dT = dB.GetDataRaport(query); dataSekolah = new DataSekolah { Npsn = Convert.ToInt32(dT.Rows[0][1]), Kelas = dT.Rows[0][2].ToString(), GuruKelas = dT.Rows[0][3].ToString(), NipGuru = dT.Rows[0][4].ToString(), Desa = dT.Rows[0][5].ToString(), Kecamatan = dT.Rows[0][6].ToString(), Kota = dT.Rows[0][7].ToString(), Provinsi = dT.Rows[0][8].ToString(), NmSekolah = dT.Rows[0][9].ToString(), Alamat = dT.Rows[0][10].ToString(), NmKepsek = dT.Rows[0][11].ToString(), NipKepsek = dT.Rows[0][12].ToString(), TglRaport = dT.Rows[0][13].ToString(), Semester = dT.Rows[0][14].ToString(), Tahunajar = dT.Rows[0][15].ToString() }; return(dataSekolah); }
public int GetKKM(int id_mapel) { int hasil; RaportDB dB = new RaportDB(); string query = $"SELECT kkm FROM data_mapel WHERE id_mapel = {id_mapel}"; DataTable dt = dB.GetDataRaport(query); hasil = Convert.ToInt32(dt.Rows[0][0]); return(hasil); }
public NilaiSikap GetNilaiSikapSiswa(string nisn, string semester) { NilaiSikap nilaiSikap; RaportDB dB = new RaportDB(); string query = $"SELECT * FROM nilai_sikap WHERE nisn = '{nisn}' AND semester = '{semester}'"; DataTable dt = dB.GetDataRaport(query); if (dt.Rows.Count > 0) { nilaiSikap = new NilaiSikap { IdSikap = dt.Rows[0][0].ToString(), Nisn = dt.Rows[0][1].ToString(), Beribadah = Convert.ToInt32(dt.Rows[0][2]), Bersyukur = Convert.ToInt32(dt.Rows[0][3]), Berdoa = Convert.ToInt32(dt.Rows[0][4]), Toleransi = Convert.ToInt32(dt.Rows[0][5]), Jujur = Convert.ToInt32(dt.Rows[0][6]), Disiplin = Convert.ToInt32(dt.Rows[0][7]), TanggungJawab = Convert.ToInt32(dt.Rows[0][8]), Peduli = Convert.ToInt32(dt.Rows[0][9]), Santun = Convert.ToInt32(dt.Rows[0][10]), PercayaDiri = Convert.ToInt32(dt.Rows[0][11]), Kerjasama = Convert.ToInt32(dt.Rows[0][12]), DeskripsiKi1 = dt.Rows[0][13].ToString(), DeskripsiKi2 = dt.Rows[0][14].ToString(), Semester = dt.Rows[0][15].ToString() }; } else { nilaiSikap = new NilaiSikap { IdSikap = "", Nisn = "", Beribadah = 0, Bersyukur = 0, Berdoa = 0, Toleransi = 0, Jujur = 0, Disiplin = 0, TanggungJawab = 0, Peduli = 0, Santun = 0, PercayaDiri = 0, Kerjasama = 0, DeskripsiKi1 = "", DeskripsiKi2 = "", Semester = "" }; } return(nilaiSikap); }
public string DeskripsiKD(int id_kd) { string hasil = ""; RaportDB dB = new RaportDB(); if (id_kd != 0) { string query = $"SELECT deskripsi_kd FROM kompetensi_dasar WHERE id_kd = {id_kd}"; DataTable dt = dB.GetDataRaport(query); hasil = dt.Rows[0][0].ToString(); } return(hasil); }
public bool IsRowExist(string nisn, int mode) { string query = ""; if (mode == 0) { query = $"SELECT * FROM view_editsikap WHERE nisn = '{nisn}'"; } else if (mode == 1) { query = $"SELECT * FROM view_editpengket WHERE nisn = '{nisn}'"; } RaportDB dB = new RaportDB(); DataTable dt = dB.GetDataRaport(query); return(dt.Rows.Count > 0 ? true : false); }
public Absensi GetAbsensi(string idabs) { Absensi absensi; RaportDB dB = new RaportDB(); string query = $"SELECT * FROM absensi WHERE id_absen = '{idabs}'"; DataTable dt = dB.GetDataRaport(query); absensi = new Absensi { IdAbsen = idabs, Nisn = dt.Rows[0][1].ToString(), Sakit = Convert.ToInt32(dt.Rows[0][2]), Ijin = Convert.ToInt32(dt.Rows[0][3]), Alpha = Convert.ToInt32(dt.Rows[0][4]), Semester = dt.Rows[0][5].ToString() }; return(absensi); }
public NilaiKeterampilan GetNilaiKeterampilanSiswa(string nisn, string semester, int idmapel) { NilaiKeterampilan nilaiKeterampilan; RaportDB dB = new RaportDB(); string query = $"SELECT * FROM nilai_keterampilan WHERE nisn = '{nisn}' AND semester = '{semester}' AND id_mapel = {idmapel}"; DataTable dt = dB.GetDataRaport(query); if (dt.Rows.Count > 0) { nilaiKeterampilan = new NilaiKeterampilan { IdKet = dt.Rows[0][0].ToString(), Nisn = dt.Rows[0][1].ToString(), IdMapel = Convert.ToInt32(dt.Rows[0][2]), KdTertinggi = Convert.ToInt32(dt.Rows[0][3]), KdTerendah = Convert.ToInt32(dt.Rows[0][4]), NilaiTertinggi = Convert.ToInt32(dt.Rows[0][5]), NilaiTerendah = Convert.ToInt32(dt.Rows[0][6]), NilaiAkhir = Convert.ToInt32(dt.Rows[0][7]), PredikatKeterampilan = dt.Rows[0][8].ToString(), DeskripsiKeterampilan = dt.Rows[0][9].ToString(), Semester = dt.Rows[0][10].ToString() }; } else { nilaiKeterampilan = new NilaiKeterampilan { IdKet = "", Nisn = "", IdMapel = 0, KdTertinggi = 0, KdTerendah = 0, NilaiTertinggi = 0, NilaiTerendah = 0, NilaiAkhir = 0, PredikatKeterampilan = "", DeskripsiKeterampilan = "", Semester = "" }; } return(nilaiKeterampilan); }
public DataSiswa GetDataSiswa(string nisn) { DataSiswa dataSiswa; RaportDB dB = new RaportDB(); string query = $"SELECT * FROM data_siswa WHERE nisn = {nisn}"; DataTable dt = dB.GetDataRaport(query); dataSiswa = new DataSiswa { Nisn = dt.Rows[0][0].ToString(), NoInduk = dt.Rows[0][1].ToString(), NmSiswa = dt.Rows[0][2].ToString(), NmPanggilan = dt.Rows[0][3].ToString(), Gender = dt.Rows[0][4].ToString(), Agama = dt.Rows[0][5].ToString(), TempatLahir = dt.Rows[0][6].ToString(), TglLahir = dt.Rows[0][7].ToString(), PendidikanSeb = dt.Rows[0][8].ToString(), Alamat = dt.Rows[0][9].ToString(), NmAyah = dt.Rows[0][10].ToString(), NmIbu = dt.Rows[0][11].ToString(), JobAyah = dt.Rows[0][12].ToString(), JobIbu = dt.Rows[0][13].ToString(), Jalan = dt.Rows[0][14].ToString(), Kecamatan = dt.Rows[0][15].ToString(), Desa = dt.Rows[0][16].ToString(), Kota = dt.Rows[0][17].ToString(), Provinsi = dt.Rows[0][18].ToString(), NmWali = dt.Rows[0][19].ToString(), JobWali = dt.Rows[0][20].ToString(), AlamatWali = dt.Rows[0][21].ToString(), Pendengaran = dt.Rows[0][22].ToString(), Penglihatan = dt.Rows[0][23].ToString(), Gigi = dt.Rows[0][24].ToString(), Berat1 = dt.Rows[0][25].ToString(), Berat2 = dt.Rows[0][26].ToString(), Tinggi1 = dt.Rows[0][27].ToString(), Tinggi2 = dt.Rows[0][28].ToString() }; return(dataSiswa); }
public NilaiEkskul GetNilaiEkskul(string ideks) { NilaiEkskul nilaiEkskul; RaportDB dB = new RaportDB(); string query = $"SELECT * FROM nilai_ekskul WHERE id_eks = '{ideks}'"; DataTable dt = dB.GetDataRaport(query); nilaiEkskul = new NilaiEkskul { IdEks = ideks, Nisn = dt.Rows[0][1].ToString(), Eskul1 = dt.Rows[0][2].ToString(), Eskul2 = dt.Rows[0][3].ToString(), Eskul3 = dt.Rows[0][4].ToString(), Nilai1 = dt.Rows[0][5].ToString(), Nilai2 = dt.Rows[0][6].ToString(), Nilai3 = dt.Rows[0][7].ToString(), Semester = dt.Rows[0][8].ToString() }; return(nilaiEkskul); }
public NilaiEkskul GetNilaiEkskulSiswa(string nisn, string semester) { NilaiEkskul nilaiEkskul; RaportDB dB = new RaportDB(); string query = $"SELECT * FROM nilai_ekskul WHERE nisn = '{nisn}' AND semester = '{semester}'"; DataTable dt = dB.GetDataRaport(query); if (dt.Rows.Count > 0) { nilaiEkskul = new NilaiEkskul { IdEks = dt.Rows[0][0].ToString(), Nisn = dt.Rows[0][1].ToString(), Eskul1 = dt.Rows[0][2].ToString(), Eskul2 = dt.Rows[0][3].ToString(), Eskul3 = dt.Rows[0][4].ToString(), Nilai1 = dt.Rows[0][5].ToString(), Nilai2 = dt.Rows[0][6].ToString(), Nilai3 = dt.Rows[0][7].ToString(), Semester = dt.Rows[0][8].ToString() }; } else { nilaiEkskul = new NilaiEkskul { IdEks = "", Nisn = "", Eskul1 = "", Eskul2 = "", Eskul3 = "", Nilai1 = "", Nilai2 = "", Nilai3 = "", Semester = "" }; } return(nilaiEkskul); }
public NilaiKeterampilan GetNilaiKeterampilan(string idket) { NilaiKeterampilan nilaiKeterampilan; RaportDB dB = new RaportDB(); string query = $"SELECT * FROM nilai_keterampilan WHERE id_ket = '{idket}'"; DataTable dt = dB.GetDataRaport(query); nilaiKeterampilan = new NilaiKeterampilan { IdKet = idket, Nisn = dt.Rows[0][1].ToString(), IdMapel = Convert.ToInt32(dt.Rows[0][2]), KdTertinggi = Convert.ToInt32(dt.Rows[0][3]), KdTerendah = Convert.ToInt32(dt.Rows[0][4]), NilaiTertinggi = Convert.ToInt32(dt.Rows[0][5]), NilaiTerendah = Convert.ToInt32(dt.Rows[0][6]), NilaiAkhir = Convert.ToInt32(dt.Rows[0][7]), PredikatKeterampilan = dt.Rows[0][8].ToString(), DeskripsiKeterampilan = dt.Rows[0][9].ToString(), Semester = dt.Rows[0][10].ToString() }; return(nilaiKeterampilan); }