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