private void SaveNewUjian(Ujian newData)
{
string sqlQuery = @"INSERT INTO Ujian(AkunPendaftaranId, SoalId, WaktuBerakhir)
VALUES(@AkunPendaftaranId, @SoalId, @WaktuBerakhir)";
using (var connection = new SqlConnection(_connectionHelper.GetConnectionString()))
{
connection.Open();
connection.Execute(sql: sqlQuery, param: newData);
}
}
public void SaveWawancara(List <HasilTes> listHasil)
{
int soalId = listHasil[0].SoalId;
int akunId = listHasil[0].AkunPendaftaranId;
var newUjian = new Ujian()
{
AkunPendaftaranId = akunId,
SoalId = soalId,
WaktuBerakhir = DateTime.Now,
IsSelesai = true
};
SaveNewAnswers(listHasil);
SaveNewUjian(newUjian);
UpdateFinishStatusUjian(akunId, soalId);
}
public void StartUjianAkademik(int akunPendaftaranId, int soalId)
{
var soal = _soalService.GetDetailSoal(soalId);
var ujianBaru = new Ujian()
{
SoalId = soalId,
AkunPendaftaranId = akunPendaftaranId,
WaktuBerakhir = DateTime.Now.AddMinutes(soal.BatasWaktu)
};
var jawabanKosong = soal.ListPertanyaan.Select(x => new HasilTes()
{
AkunPendaftaranId = akunPendaftaranId,
SoalId = soalId,
PertanyaanId = x.Id
}).ToList();
SaveNewUjian(ujianBaru);
SaveNewAnswers(jawabanKosong);
UpdateStatusSudahUjian(akunPendaftaranId);
}
