public void InsertCalonSiswa(CalonSiswa newCalonSiswa) { string sqlInsertCalonSiswa = @"INSERT INTO CalonSiswa(Nik, Nisn, NamaLengkap) VALUES(@Nik, @Nisn, @NamaLengkap)"; using (var connection = new SqlConnection(_connectionHelper.GetConnectionString())) { connection.Open(); connection.Execute(sql: sqlInsertCalonSiswa, param: newCalonSiswa); } }
public void InsertCalonSiswa_Insert() { // Arrange var _pendaftaranService = new PendaftaranService(_connectionHelper, null); var newCalonSiswa = new CalonSiswa() { Nik = "9999999999999999", NamaLengkap = "Tesu Indrawan", Nisn = "9999999999" }; // Action _pendaftaranService.InsertCalonSiswa(newCalonSiswa); bool isExist = _pendaftaranService.IsExistCalonSiswa(newCalonSiswa.Nik); // Assert Assert.True(isExist); string msg = $"Kasus Uji: Membuat objek calon siswa kemudian melakukan penyimpanan\n" + $"Hasil yang diinginkan: data tersimpan\n"; if (isExist) { msg += "Hasil aktual: data tersimpan"; } else { msg += "Hasil aktual: data tidak tersimpan"; } _output.WriteLine(msg); //using (SqlConnection conn = new SqlConnection(_connectionHelper.GetConnectionString())) //{ // conn.Execute("DELETE FROM CalonSiswa WHERE Nik = @Nik", new { Nik = newCalonSiswa.Nik }); //} }