Changeset 12858 for branches/HiveStatistics/sources/HeuristicLab.Services.WebApp.Statistics/3.3/WebApi/ExceptionController.cs
- Timestamp:
- 08/13/15 15:22:51 (9 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/HiveStatistics/sources/HeuristicLab.Services.WebApp.Statistics/3.3/WebApi/ExceptionController.cs
r12562 r12858 35 35 36 36 public DT.ExceptionPage GetExceptions(int page, int size) { 37 using (var pm = PersistenceManager) { 38 var dimClientDao = pm.DimClientDao; 39 var dimJobDao = pm.DimJobDao; 40 var factTaskDao = pm.FactTaskDao; 41 var tasks = factTaskDao.GetTasksWithException(); 42 return pm.UseTransaction(() => new DT.ExceptionPage { 43 TotalExceptions = tasks.Count(), 44 Exceptions = (from factTask in tasks 45 join dimJob in dimJobDao.GetAll() on factTask.JobId equals dimJob.JobId 46 join dimClient in dimClientDao.GetAll() on factTask.LastClientId equals 47 dimClient.Id into taskClientJoin 48 from a in taskClientJoin.DefaultIfEmpty() 49 let endTime = factTask.EndTime ?? DateTime.Now 50 select new DT.Exception { 51 TaskId = factTask.TaskId, 52 JobId = factTask.JobId, 53 JobName = dimJob.JobName, 54 UserId = dimJob.UserId, 55 UserName = dimJob.UserName, 56 ClientId = factTask.LastClientId ?? default(Guid), 57 ClientName = a != null ? a.Name : string.Empty, 58 Date = endTime, 59 Details = factTask.Exception 60 }) 61 .OrderByDescending(x => x.Date) 62 .Skip((page - 1) * size) 63 .Take(size) 64 .ToList() 65 }); 66 } 37 var pm = PersistenceManager; 38 var dimClientDao = pm.DimClientDao; 39 var dimJobDao = pm.DimJobDao; 40 var factTaskDao = pm.FactTaskDao; 41 var tasks = factTaskDao.GetTasksWithException(); 42 return pm.UseTransaction(() => new DT.ExceptionPage { 43 TotalExceptions = tasks.Count(), 44 Exceptions = (from factTask in tasks 45 join dimJob in dimJobDao.GetAll() on factTask.JobId equals dimJob.JobId 46 join dimClient in dimClientDao.GetAll() on factTask.LastClientId equals 47 dimClient.Id into taskClientJoin 48 from a in taskClientJoin.DefaultIfEmpty() 49 let endTime = factTask.EndTime ?? DateTime.Now 50 select new DT.Exception { 51 TaskId = factTask.TaskId, 52 JobId = factTask.JobId, 53 JobName = dimJob.JobName, 54 UserId = dimJob.UserId, 55 UserName = dimJob.UserName, 56 ClientId = factTask.LastClientId ?? default(Guid), 57 ClientName = a != null ? a.Name : string.Empty, 58 Date = endTime, 59 Details = factTask.Exception 60 }) 61 .OrderByDescending(x => x.Date) 62 .Skip((page - 1) * size) 63 .Take(size) 64 .ToList() 65 }); 67 66 } 68 67 }
Note: See TracChangeset
for help on using the changeset viewer.