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