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