public IEnumerable <ResultArchive> Get(ResultArchiveUploadStatus status)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
var entities = (from r in linqMetaData.ResultArchiveUpload where r.Status == (int)status select r).ToArray();
return(AutoMapper.Mapper.Map <IEnumerable <ResultArchiveUploadEntity>, IEnumerable <ResultArchive> >(entities));
}
}
private void SetResultArchiveStatus(long resultArchiveUploadId, ResultArchiveUploadStatus status)
{
if (resultArchiveUploadId > 0)
{
var resultArchive = _resultArchiveUploadRepository.GetById(resultArchiveUploadId);
resultArchive.Status = status;
resultArchive.UploadEndTime = DateTime.Now;
_resultArchiveUploadRepository.Save(resultArchive);
}
}
public IEnumerable <long> GetEventIdsForStatus(IEnumerable <long> eventIds, ResultArchiveUploadStatus status)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
return((from rau in linqMetaData.ResultArchiveUpload
join rauGroup in
(from rau in linqMetaData.ResultArchiveUpload
group rau by rau.EventId
into g
select
new
{
EventId = g.Key,
ResultArchiveUploadId = g.Max(rau => rau.ResultArchiveUploadId)
}
) on rau.ResultArchiveUploadId equals rauGroup.ResultArchiveUploadId
where rau.Status >= (int)status
select rau.EventId).ToList());
}
}
