public DataTable SimpanHasilAkhir(int id_kat, int id_matpel, int no_soal, int no, int salah, int benar, string hasil)
{
classKoneksi = new koneksi();
sql = "call simpanHasil(" + id_kat + "," + id_matpel + "," + no_soal + "," + no + "," + salah + "," + benar + ",'" + hasil + "')";
tabel = new DataTable();
try
{
classKoneksi.koneksiBuka();
komand = new MySqlCommand(sql, classKoneksi.konek);
adapter = new MySqlDataAdapter(komand);
adapter.Fill(tabel);
} catch (Exception) {
}
classKoneksi.koneksiTutup();
return(tabel);
}
public DataTable SimpanHasilJawaban(string id_soal, string id_kat, string no_soal, string id_matpel, string no, string inJwbn)
{
classKoneksi = new koneksi();
sql = "call simpanJawaban(" + id_soal + "," + id_kat + "," + no_soal + "," + id_matpel + "," + no + ",'" + inJwbn + "')";
tabel = new DataTable();
try
{
classKoneksi.koneksiBuka();
komand = new MySqlCommand(sql, classKoneksi.konek);
adapter = new MySqlDataAdapter(komand);
adapter.Fill(tabel);
} catch (Exception) {
}
classKoneksi.koneksiTutup();
return(tabel);
}
public DataTable HitungKebenaranSoal(int id_kat, int no_soal, int no_induk, string pilih)
{
classKoneksi = new koneksi();
sql = "call tampilHasilTesSementara(" + id_kat + "," + no_soal + "," + no_induk + ",'" + pilih + "')";
tabel = new DataTable();
try
{
classKoneksi.koneksiBuka();
komand = new MySqlCommand(sql, classKoneksi.konek);
adapter = new MySqlDataAdapter(komand);
adapter.Fill(tabel);
} catch (Exception) {
}
classKoneksi.koneksiTutup();
return(tabel);
}
public DataTable bacaSoalPerKategori(string id)
{
classKoneksi = new koneksi();
sql = "call lihatPerKat(" + id + ")";
tabel = new DataTable();
try
{
classKoneksi.koneksiBuka();
komand = new MySqlCommand(sql, classKoneksi.konek);
adapter = new MySqlDataAdapter(komand);
adapter.Fill(tabel);
} catch (Exception) {
}
classKoneksi.koneksiTutup();
return(tabel);
}
public DataTable bacaSemuaSoal()
{
classKoneksi = new koneksi();
sql = "call lihatSemuaSoal";
tabel = new DataTable();
try
{
classKoneksi.koneksiBuka();
komand = new MySqlCommand(sql, classKoneksi.konek);
adapter = new MySqlDataAdapter(komand);
adapter.Fill(tabel);
} catch (Exception) {
}
classKoneksi.koneksiTutup();
return(tabel);
}
public DataTable UpdateFoto(int no_induk, string nama_baru)
{
classKoneksi = new koneksi();
sql = "call updateFotoSiswa(" + no_induk + ",'" + nama_baru + "')";
tabel = new DataTable();
try
{
classKoneksi.koneksiBuka();
komand = new MySqlCommand(sql, classKoneksi.konek);
adapter = new MySqlDataAdapter(komand);
adapter.Fill(tabel);
} catch (Exception) {
}
classKoneksi.koneksiTutup();
return(tabel);
}
public DataTable kirimPesan(string pengirim, string psn)
{
classKoneksi = new koneksi();
sql = "call kirimPesanClient('" + pengirim + "','" + psn + "')";
tabel = new DataTable();
try
{
classKoneksi.koneksiBuka();
komand = new MySqlCommand(sql, classKoneksi.konek);
adapter = new MySqlDataAdapter(komand);
adapter.Fill(tabel);
} catch (Exception) {
}
classKoneksi.koneksiTutup();
return(tabel);
}
public DataTable bacaNilaiPerMatPel(int no_induk, int id_matpel)
{
classKoneksi = new koneksi();
sql = "call lihatNilaiPerMatPel(" + no_induk + "," + id_matpel + ")";
tabel = new DataTable();
try
{
classKoneksi.koneksiBuka();
komand = new MySqlCommand(sql, classKoneksi.konek);
adapter = new MySqlDataAdapter(komand);
adapter.Fill(tabel);
} catch (Exception) {
}
classKoneksi.koneksiTutup();
return(tabel);
}
public DataTable TampilSoalAcak(string no_soal, string id_matpel, string id_kat)
{
classKoneksi = new koneksi();
sql = "call AcakSoal(" + no_soal + "," + id_matpel + "," + id_kat + ")";
tabel = new DataTable();
try
{
classKoneksi.koneksiBuka();
komand = new MySqlCommand(sql, classKoneksi.konek);
adapter = new MySqlDataAdapter(komand);
adapter.Fill(tabel);
} catch (Exception) {
}
classKoneksi.koneksiTutup();
return(tabel);
}
public DataTable CekIkutSerta(string id_kat, string id_pel, string no_soal, string id_siswa)
{
classKoneksi = new koneksi();
sql = "call cekIkutSerta('" + id_kat + "','" + id_pel + "','" + no_soal + "','" + id_siswa + "')";
tabel = new DataTable();
try
{
classKoneksi.koneksiBuka();
komand = new MySqlCommand(sql, classKoneksi.konek);
adapter = new MySqlDataAdapter(komand);
adapter.Fill(tabel);
} catch (Exception) {
}
classKoneksi.koneksiTutup();
return(tabel);
}
public DataTable bacaPesanMasuk(int id_siswa)
{
classKoneksi = new koneksi();
sql = "call bacaPesanMasuk(" + id_siswa + ")";
tabel = new DataTable();
try
{
classKoneksi.koneksiBuka();
komand = new MySqlCommand(sql, classKoneksi.konek);
adapter = new MySqlDataAdapter(komand);
adapter.Fill(tabel);
} catch (Exception) {
}
classKoneksi.koneksiTutup();
return(tabel);
}
public DataTable ValidasiLogin(string user, string pass)
{
classKoneksi = new koneksi();
sql = "call loginUser('" + user + "','" + pass + "')";
tabel = new DataTable();
try
{
classKoneksi.koneksiBuka();
komand = new MySqlCommand(sql, classKoneksi.konek);
adapter = new MySqlDataAdapter(komand);
adapter.Fill(tabel);
} catch (Exception)
{
}
classKoneksi.koneksiTutup();
return(tabel);
}
