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);
}
public IEnumerable <Rule> GetRulesByQuiz(int quizId)
{
var sql = $"Select * From Rules Where Rules.QuizId = @id";
IEnumerable <Rule> result = _connectionString.Query <Rule>(sql, new { id = quizId });
if (result == null)
{
_logger.LogError($"Rules 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);
}