public void SaveAnswerAkademik(HasilTes jawaban)
{
string sqlQuery = @"UPDATE HasilTes SET Jawaban=@Jawaban
WHERE SoalId=@SoalId AND PertanyaanId=@PertanyaanId AND AkunPendaftaranId=@AkunPendaftaranId";
using (var connection = new SqlConnection(_connectionHelper.GetConnectionString()))
{
connection.Execute(sql: sqlQuery, param: jawaban);
}
}
public HasilTes GetHasilTes(int sesiId)
{
HasilTes obj = null;
using (IDbContext context = new DbContext())
{
_repository = new HistoriTesRepository(context);
obj = _repository.GetHasilTes(sesiId);
}
return(obj);
}
public IActionResult JawabSoalAkademik(JawabSoalAkademikModel model)
{
int akunId = int.Parse(User.FindFirstValue(ClaimTypes.NameIdentifier));
var jawaban = new HasilTes()
{
AkunPendaftaranId = akunId,
SoalId = model.SoalId,
PertanyaanId = model.PertanyaanId,
Jawaban = model.JawabanCalonSiswa
};
_ujianService.SaveAnswerAkademik(jawaban);
return(RedirectToAction("JawabSoalAkademik", "Ujian", new { soalId = model.SoalId, qid = model.Tujuan }));
}
public IActionResult SelesaiUjianAkademik(JawabSoalAkademikModel model)
{
int akunId = int.Parse(User.FindFirstValue(ClaimTypes.NameIdentifier));
var jawaban = new HasilTes()
{
AkunPendaftaranId = akunId,
SoalId = model.SoalId,
PertanyaanId = model.PertanyaanId,
Jawaban = model.JawabanCalonSiswa
};
_ujianService.SaveAnswerAkademik(jawaban);
_ujianService.FinishUjianAkademik(akunId, model.SoalId);
return(View());
}
public HasilTes GetHasilTes(int sesiId)
{
HasilTes obj = null;
try
{
var sql = @"select
count(case hasil_jawaban when 1 then hasil_jawaban end) as benar,
count(case hasil_jawaban when 0 then hasil_jawaban end) as salah
from histori_tes
where sesi_id = @sesiId and batal = 0 and jawaban is not null";
obj = _context.Db.QuerySingleOrDefault <HasilTes>(sql, new { sesiId });
}
catch (Exception ex)
{
//_log.Error("Error:", ex);
}
return(obj);
}
