public IEnumerable <Stage> GetStagesByQuiz(int quizId)
{
var sql = $"Select * From Stages Where Stages.QuizId = @id";
IEnumerable <Stage> result = _connectionString.Query <Stage>(sql, new { id = quizId });
if (result == null)
{
_logger.LogError($"Stages not find with this quiz id: {quizId}");
return(result);
}
using (var fileObjRepo = new FileObjectRepository(_transaction, _logger))
{
foreach (var item in result)
{
item.Files = fileObjRepo.GetAllFilesForObject(item);
}
}
return(result);
}
public IEnumerable <Ending> GetEndingsByStage(int stageId)
{
var sql = $"Select * From Endings Where Endings.StageId = @id";
IEnumerable <Ending> result = _connectionString.Query <Ending>(sql, new { id = stageId });
if (result == null)
{
_logger.LogError($"Endings not find with this stage id: {stageId}");
return(result);
}
using (var fileObjRepo = new FileObjectRepository(_transaction, _logger))
{
foreach (var item in result)
{
item.Files = fileObjRepo.GetAllFilesForObject(item);
}
}
return(result);
}