public void Hapus(string nis)
{
string query = "DELETE FROM siswa WHERE nis=@kriteria";
MySQLDB db = new MySQLDB();
db.Execute(query, new Dictionary <string, dynamic>()
{
{ "@kriteria", nis }
});
}
public void Add(SiswaModel data)
{
string query = "INSERT INTO siswa (nis,nama,kelas) VALUES (@nis,@nama,@kelas)";
MySQLDB db = new MySQLDB();
db.Execute(query, new Dictionary <string, dynamic>()
{
{ "@nis", data.nis },
{ "@nama", data.nama },
{ "@kelas", data.kelas }
});
}
public void Edit(string nis, SiswaModel data)
{
string query = "UPDATE siswa SET nis=@nisBaru,nama=@namaBaru,kelas=@kelasBaru WHERE nis=@nisLama";
MySQLDB db = new MySQLDB();
db.Execute(query, new Dictionary <string, dynamic>()
{
{ "@nisBaru", data.nis },
{ "@namaBaru", data.nama },
{ "@kelasBaru", data.kelas },
{ "@nisLama", nis }
});
}
